AM_TXN_OPU_VW (SQL View)	Index Back
Operating Unit Selects the Operating Unit from those entries in INTFC PHY A with load status NEW.

AM_TXN_OPU_VW

(SQL View)

Operating Unit

Selects the Operating Unit from those entries in INTFC PHY A with load status NEW.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField