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

AM_CON_CAT_VW

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

SELECT DISTINCT A.CATEGORY FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS = 'NEW' AND A.CATEGORY <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category