PTLT_CIPG_VW (SQL View)	Index Back
Component Interface - View Component Interfaces and corresponding Panel Groups

PTLT_CIPG_VW

(SQL View)

Component Interface - View

Component Interfaces and corresponding Panel Groups

SELECT %Sql(PTLT_TASK_CODE,A.PNLGRPNAME, A.MARKET) , B.BCNAME , B.BCDISPLAYNAME FROM PSPNLGRPDEFN A , PSBCDEFN B WHERE A.PNLGRPNAME = B.BCPGNAME AND A.MARKET = B.MARKET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code

2 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

3 BCDISPLAYNAME Character(30) VARCHAR2(30) NOT NULL BC Display Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTLT_TASK_CODE	Character(30)	VARCHAR2(30) NOT NULL	Task Code
2	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
3	BCDISPLAYNAME	Character(30)	VARCHAR2(30) NOT NULL	BC Display Name