[Home] [Help] [Dependency Information]
Object Name: | AR_GTA_TRXIMP_TMP |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_GTA_TRXIMP_TMP |
Subobject Name: | |
Status: | VALID |
AR_GTA_TRXIMP_TMP stores the data of VAT invoice text
imported from flat file. It�s inserted by SQL*Loader and deleted by VAT invoice import program after import concurrent finishes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_GTA_TRXIMP_TMP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | IMPORT_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IMPORT_SEQ | NUMBER | Yes | IMPORT SEQUENCE | |
COL1 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL2 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL3 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL4 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL5 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL6 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL7 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL8 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL9 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL10 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL11 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL12 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL13 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL14 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL15 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL16 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL17 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL18 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL19 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL20 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL21 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL22 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL23 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL24 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
COL25 | VARCHAR2 | (200) | FIELD FROM FLAT FILE | |
LAST_UPDATE_DATE | DATE | Yes | Standard date column | |
LAST_UPDATED_BY | NUMBER | (22) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard date column | |
CREATED_BY | NUMBER | (22) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT IMPORT_SEQ
, COL1
, COL2
, COL3
, COL4
, COL5
, COL6
, COL7
, COL8
, COL9
, COL10
, COL11
, COL12
, COL13
, COL14
, COL15
, COL16
, COL17
, COL18
, COL19
, COL20
, COL21
, COL22
, COL23
, COL24
, COL25
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM AR.AR_GTA_TRXIMP_TMP;
AR.AR_GTA_TRXIMP_TMP does not reference any database object
AR.AR_GTA_TRXIMP_TMP is referenced by following:
|
|
|