SCC_DA_PCOMP_VW

(SQL View)

SELECT DISTINCT H.SCC_DA_TXN_CD ,M.PNLGRPNAME ,A.MENUNAME FROM PSMENUITEM M ,PSAUTHITEM A ,PS_SCC_DA_TXN_HDR H ,PSROLECLASS R WHERE R.ROLENAME=H.ROLENAME AND A.CLASSID=R.CLASSID AND M.MENUNAME=A.MENUNAME AND M.ITEMNAME=A.BARITEMNAME AND A.BARNAME=M.BARNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_DA_TXN_CD Character(50) VARCHAR2(50) NOT NULL Transaction Code

2 SCC_DA_PROXY_COMP Character(18) VARCHAR2(18) NOT NULL Component Name

3 SCC_DA_PROXY_MENU Character(30) VARCHAR2(30) NOT NULL Pop Select tool menu name field. Used for transfering to the tool's edit page.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_DA_TXN_CD	Character(50)	VARCHAR2(50) NOT NULL	Transaction Code
2	SCC_DA_PROXY_COMP	Character(18)	VARCHAR2(18) NOT NULL	Component Name
3	SCC_DA_PROXY_MENU	Character(30)	VARCHAR2(30) NOT NULL	Pop Select tool menu name field. Used for transfering to the tool's edit page.