[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AW_FUND_ROLLOVER |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGF.IGF_AW_FUND_ROLLOVER
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Stores the relationships between funds where in you can find out which fund ID has to get rolled over to which corresponding fund ID , this view is used by the fund rollover process
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| FROL_ID | NUMBER | (15) | Yes | |
| CR_CAL_TYPE | VARCHAR2 | (10) | Yes | |
| CR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
| SC_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
| ROLLOVER_STATUS | VARCHAR2 | (1) | Yes | |
| ORG_ID | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FROL_ID
, CR_CAL_TYPE
, CR_SEQUENCE_NUMBER
, SC_SEQUENCE_NUMBER
, ROLLOVER_STATUS
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM APPS.IGF_AW_FUND_ROLLOVER;
APPS
IGF_AW_FUND_ROLLOVER_ALL
APPS
IGF_AW_FUND_ROLLOVER_PKG
- show dependent code
IGF_AW_FUND_ROLLOVER_V
|
|
|
|