[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_IMP_CHGS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_FI_IMP_CHGS |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This entity stores the header details for the charges lines (External and Ancillary) which are imported from the Interface tables.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
IMPORT_CHARGES_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (15) | Yes | |
FEE_TYPE | VARCHAR2 | (10) | Yes | |
FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | |
FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
TRANSACTION_TYPE | VARCHAR2 | (30) | Yes | |
ORG_ID | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, IMPORT_CHARGES_ID
, PERSON_ID
, FEE_TYPE
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, TRANSACTION_TYPE
, ORG_ID
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_FI_IMP_CHGS;
|
|
|