DBA Data[Home] [Help]

VIEW: APPS.IGF_AW_FUND_TD_MAP_V

Source

View Text - Preformatted

SELECT FTODO.ROW_ID, FTODO.FTODO_ID, FTODO.FUND_ID, FTODO.ITEM_SEQUENCE_NUMBER, TDM.ITEM_CODE, TDM.DESCRIPTION, FTODO.CREATED_BY, FTODO.CREATION_DATE, FTODO.LAST_UPDATED_BY, FTODO.LAST_UPDATE_DATE, FTODO.LAST_UPDATE_LOGIN FROM IGF_AW_FUND_TD_MAP FTODO, IGF_AP_TD_ITEM_MST TDM WHERE TDM.TODO_NUMBER = FTODO. ITEM_SEQUENCE_NUMBER
View Text - HTML Formatted

SELECT FTODO.ROW_ID
, FTODO.FTODO_ID
, FTODO.FUND_ID
, FTODO.ITEM_SEQUENCE_NUMBER
, TDM.ITEM_CODE
, TDM.DESCRIPTION
, FTODO.CREATED_BY
, FTODO.CREATION_DATE
, FTODO.LAST_UPDATED_BY
, FTODO.LAST_UPDATE_DATE
, FTODO.LAST_UPDATE_LOGIN
FROM IGF_AW_FUND_TD_MAP FTODO
, IGF_AP_TD_ITEM_MST TDM
WHERE TDM.TODO_NUMBER = FTODO. ITEM_SEQUENCE_NUMBER