AM_TXN_PRJ_VW (SQL View)	Index Back
Project Selects the AM Business Unit + Project from those entries in INTFC PHY A with load status NEW.

AM_TXN_PRJ_VW

(SQL View)

Project

Selects the AM Business Unit + Project from those entries in INTFC PHY A with load status NEW.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField