AM_TXN_DEP_VW

(SQL View)
 Index Back

Deptid Prompt

Selects the AM Business Unit + Deptid from those entries in INTFC PHY A for all load status values.

SELECT DISTINCT DEPTID FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') AND A.DEPTID <> ' ' UNION SELECT DISTINCT DEPTID FROM PS_INTFC_FIN A WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') AND A.DEPTID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department