IS_PARENT_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT, A.PARENT_ID, A.DESCR FROM PS_PARENT_ASSET A, PS_ASSET B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PARENT_ID = B.ASSET_ID AND A.DELETE_PARENT_SW IN ('N',' ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description