PTLT_COMPMKTVW

(SQL View)

SELECT PTLT_TASK_CODE , %Sql (PTLT_CODE_COMPONENT,PTLT_TASK_CODE) , %Sql(PTLT_CODE_MARKET,PTLT_TASK_CODE) FROM %Table(PTLT_TASK) WHERE PTLT_TASK_TYPE = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 MARKET Character(3) VARCHAR2(3) NOT NULL Market

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTLT_TASK_CODE	Character(30)	VARCHAR2(30) NOT NULL	Task Code
2	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
3	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market