AM_TXN_BUD_VW

(SQL View)
 Index Back

BUDGET_REF Prompt

Selects the BUDGET_REF from those entries in Interface tables for all load status values.

SELECT DISTINCT %Sql(BUDGET_REF, A.) FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') AND %Sql(BUDGET_REF, A.) <> ' ' UNION SELECT DISTINCT %Sql(BUDGET_REF, A.) FROM PS_INTFC_FIN A WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') AND %Sql(BUDGET_REF, A.) <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference