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

AM_CON_PRO_VW

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

SELECT DISTINCT %Sql(PRODUCT, A.) FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS = 'NEW' AND %Sql(PRODUCT, A.) <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField