SQL Query to find out the records exposed by a Component Interface.

-


      SELECT distinct RECNAME
        FROM PSBCITEM
       WHERE BCNAME = 'XXXX_CI';

Comments

Post a Comment

Popular posts from this blog

Dynamic Views In Peoplesoft

-
Image
Understanding Dynamic Prompts in PeopleSoft Every so often during the interviews, we encounter this question a lot and without a proper understanding we end up improvising the explanation. The question is -  What do you know about dynamic prompts and how we can create them? Well, let’s get to the point and try understanding the concept with examples. Prompts enable user to select a value from the list of predefined control values for a field in a page during transactions.  For Example, when we create a new department, to select the company we click on the prompt for company field and select one of the listed values. In this case, the list of companies displayed in the prompt is static and is directly pulled from the record COMPANY_TBL.  Below is the record field properties of COMPANY field in the record DEPT_TBL, In this case, there is no control over what are all the values will be prompted to the user, whatever is available in t...
Read more