[Home] [Help] [Dependency Information]
Object Name: | AR_LINE_CONTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_LINE_CONTS_ALL |
Subobject Name: | |
Status: | VALID |
The AR_LINE_CONTS_ALL table stores, for each line, contingencies that impact revenue.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_LINE_CONTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CUSTOMER_TRX_LINE_ID
CONTINGENCY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_LINE_ID | NUMBER | Yes | Invoice Line Identifier | |
CONTINGENCY_CODE | VARCHAR2 | (30) | Yes | Contingency Code Lookup Code for lookup type AR_REVENUE_CONTINGENCIES |
EXPIRATION_DATE | DATE | Contingency Expiration Date | ||
EXPIRATION_DAYS | NUMBER | Contingency Expiration in Days | ||
COMPLETED_FLAG | VARCHAR2 | (1) | Indicated Completion | |
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 - user who created this row (foreign key to FND_USERS.USER_ID) | |
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) | ||
EXPIRATION_EVENT_DATE | DATE | Expiration event date | ||
REASON_REMOVAL_DATE | DATE | Reason removal date | ||
COMPLETED_BY | NUMBER | Standard Who column - user who completed the contingency | ||
DEFAULTED_IN_AR_FLAG | VARCHAR2 | (1) | Contingencies defaulted in AR | |
CONTINGENCY_ID | NUMBER | (15) | Yes | Contingency identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_LINE_ID
, CONTINGENCY_CODE
, EXPIRATION_DATE
, EXPIRATION_DAYS
, COMPLETED_FLAG
, ORG_ID
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EXPIRATION_EVENT_DATE
, REASON_REMOVAL_DATE
, COMPLETED_BY
, DEFAULTED_IN_AR_FLAG
, CONTINGENCY_ID
FROM AR.AR_LINE_CONTS_ALL;
AR.AR_LINE_CONTS_ALL does not reference any database object
AR.AR_LINE_CONTS_ALL is referenced by following:
|
|
|