AM_TXN_PRF_VW (SQL View)	Index Back
Category Selects the AM Business Unit + Category from those entries in INTFC PHY A for all load status values.

AM_TXN_PRF_VW

Selects the AM Business Unit + Category from those entries in INTFC PHY A for all load status values.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID