[Home] [Help]
View: IGF_AW_FUND_TD_MAP_V
View Text
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
Columns
| Name |
| ROW_ID |
| FTODO_ID |
| FUND_ID |
| ITEM_SEQUENCE_NUMBER |
| ITEM_CODE |
| DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |