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

AM_TXN_ITEM_VW

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

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID