Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_TRX_CONTINGENCIES_GT

Object Details
Object Name: AR_TRX_CONTINGENCIES_GT
Object Type: TABLE
Owner: AR
Subobject Name:
Status: VALID


The AR_TRX_CONTINGENCIES_GT table is used by the Invoice Creation API to import contingencies information that impacts revenue for your transactions.


Temporary Table Details

AR.AR_TRX_CONTINGENCIES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
TRX_CONTINGENCY_ID NUMBER

Transaction Contingency Identifier
TRX_HEADER_ID NUMBER

Invoice Identifier
TRX_LINE_ID NUMBER
Yes Invoice Line Identifier
EXPIRATION_DATE DATE

Contingency Expiration Date
EXPIRATION_DAYS NUMBER

Contingency Expiration in Days
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (30)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (30)
Descriptive flexfield segment
ORG_ID NUMBER

Organization Identifier
REQUEST_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)
CREATED_BY NUMBER
Yes Standard Who column - user who created this row (foreign key to FND_USERS.USER_ID)
CREATION_DATE DATE
Yes Standard Who column - date when this row was created
LAST_UPDATED_BY NUMBER
Yes Standard Who column - user who last updated this row (foreign key to FND_USERS.USER_ID)
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when this row was last updated
LAST_UPDATE_LOGIN NUMBER

Standard Who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CONTINGENCY_ID NUMBER
Yes
EXPIRATION_EVENT_DATE DATE

COMPLETED_FLAG VARCHAR2 (1)
COMPLETED_BY NUMBER

CONTINGENCY_CODE VARCHAR2 (30)
Contingency Code Lookup Code for AR_REVENUE_CONTINGENCIES
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRX_CONTINGENCY_ID
,      TRX_HEADER_ID
,      TRX_LINE_ID
,      EXPIRATION_DATE
,      EXPIRATION_DAYS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONTINGENCY_ID
,      EXPIRATION_EVENT_DATE
,      COMPLETED_FLAG
,      COMPLETED_BY
,      CONTINGENCY_CODE
FROM AR.AR_TRX_CONTINGENCIES_GT;

Dependencies

[top of page]

AR.AR_TRX_CONTINGENCIES_GT does not reference any database object

AR.AR_TRX_CONTINGENCIES_GT is referenced by following:

SchemaAPPS
SynonymAR_TRX_CONTINGENCIES_GT