EODP_PNLREC_VW (SQL View)	Index Back
SecPage Record Prompt Prompt view to select the record from the secondary page called via peoplecode

EODP_PNLREC_VW

(SQL View)

SecPage Record Prompt

Prompt view to select the record from the secondary page called via peoplecode

SELECT DISTINCT A.PNLNAME ,B.RECNAME FROM PSPNLDEFN A , PS_EODP_COMP_REF B WHERE A.PNLNAME=B.PNLNAME AND B.PNLGRPNAME='BLANK_DP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).