Creating a View for the Component Search Record
To create a view for the component search record:
-
Select File, Open in PeopleSoft Application Designer.
-
Select Record in the Definition drop-down menu.
-
Open the EO_CHUNKBU_VW record.
-
Save the record as YOUR_TABLE_VW.
-
Select the Record Type tab.
-
Open the SQL editor.
-
Modify the Where clause.
Change
WHERE RECNAME_CHUNK=EO_BUSUNT_EOCtoWHERE RECNAME_CHUNK=YOUR_TABLE_EOC. -
Select File, Save.
-
Build the SQL view.