PTLT_B_P_F_VW1

index back

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 Field Type Column Type Description
PTLT_BP_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name
PTLT_BP_DTL_NAME Character(50) VARCHAR2(50) NOT NULL Detailed Business Process Name
PTLT_PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Unique code for a product.
PTLT_FEATURE_CODE Character(10) VARCHAR2(10) NOT NULL Unique code identifying a feature

Prompt Table: PTLT_FEATURE

PTLT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Is this required for implementation?
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19