PTLT_B_P_F_VW (SQL View)	Index Back
Product Features-Bus Processes Used in Setup Manager

PTLT_B_P_F_VW

(SQL View)

Product Features-Bus Processes

Used in Setup Manager

SELECT A.PTLT_BP_NAME , A.PTLT_BP_DTL_NAME , B.PTLT_PRODUCT_CODE , B.PTLT_FEATURE_CODE , C.PTLT_REQUIRED FROM %Table(PTLT_BP_DTL_VW) A , %Table(PTLT_ASSGN_PRFT) B , %Table(PTLT_ASSGN_FEAT) C WHERE A.PTLT_BP_NAME = B.PTLT_BP_NAME AND A.PTLT_BP_DTL_NAME = B.PTLT_BP_DTL_NAME AND B.PTLT_PRODUCT_CODE = C.PTLT_PRODUCT_CODE AND B.PTLT_FEATURE_CODE = C.PTLT_FEATURE_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTLT_BP_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name

2 PTLT_BP_DTL_NAME Character(50) VARCHAR2(50) NOT NULL Detailed Business Process Name

3 PTLT_PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Unique code for a product.

4 PTLT_FEATURE_CODE Character(10) VARCHAR2(10) NOT NULL Unique code identifying a feature
Prompt Table: PTLT_FEATURE

5 PTLT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Is this required for implementation?

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTLT_BP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Business Process Name
2	PTLT_BP_DTL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Detailed Business Process Name
3	PTLT_PRODUCT_CODE	Character(4)	VARCHAR2(4) NOT NULL	Unique code for a product.
4	PTLT_FEATURE_CODE	Character(10)	VARCHAR2(10) NOT NULL	Unique code identifying a feature Prompt Table: PTLT_FEATURE
5	PTLT_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Is this required for implementation?