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

AM_TXN_RSC_VW

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

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory