PTLT_B_P_F_VW

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 NameField TypeColumn TypeDescription
PTLT_BP_NAMECharacter(50)VARCHAR2(50) NOT NULLBusiness Process Name
PTLT_BP_DTL_NAMECharacter(50)VARCHAR2(50) NOT NULLDetailed Business Process Name
PTLT_PRODUCT_CODECharacter(4)VARCHAR2(4) NOT NULLUnique code for a product.
PTLT_FEATURE_CODECharacter(10)VARCHAR2(10) NOT NULLUnique code identifying a feature

Prompt Table: PTLT_FEATURE

PTLT_REQUIREDCharacter(1)VARCHAR2(1) NOT NULLIs this required for implementation?
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19