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

AM_CON_ACT_VW

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

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID