IN_FW_SEL_9_VW (SQL View)	Index Back
FW: Base view for temp prompt FW: Base view for template prompt

IN_FW_SEL_9_VW

(SQL View)

FW: Base view for temp prompt

FW: Base view for template prompt

SELECT ITOH1.TEMPLATE_ID ,ITOH1.DESCR ,ITOS1.OPRID ,ITOS1.ROLENAME ,ITOS1.BUSINESS_UNIT ,ITOS1.SETID FROM PS_IN_TM_OPR_HDR ITOH1 , PS_IN_TM_OPR_SEC ITOS1 WHERE ITOH1.IN_TM_CODE = ITOS1.IN_TM_CODE AND ITOH1.TEMPLATE_ID = ITOS1.TEMPLATE_ID AND ITOH1.ACTIVE_FLAG = 'A' AND ITOH1.IN_TM_CODE = 'FULFIL_WRKBENCH'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
Prompt Table: IN_FW_SEL_6_VW

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

5 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template Prompt Table: IN_FW_SEL_6_VW
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
5	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID