PTLT_BP_VW

(SQL View)
Index Back

Business Process - Detail

Business Process Definitions - Detail

SELECT A.PTLT_BP_NAME , A.PTLT_BP_NAME_EXT , A.DESCR254_MIXED , A.OBJECTOWNERID FROM %Table(PTLT_BUSPRC) A , %Table(PTLT_INSTALL) B WHERE A.PTLT_BP_VERSION = B.PTLT_BP_VERSION

# 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_NAME_EXT Character(50) VARCHAR2(50) NOT NULL Internal business process name
3 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
4 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier