AM_TXN_FUN_VW (SQL View)	Index Back
FUND_CODE PROMPT Selects the FUND_CODE from those entries in the interface tables for all load status values.

AM_TXN_FUN_VW

(SQL View)

FUND_CODE PROMPT

Selects the FUND_CODE from those entries in the interface tables for all load status values.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code