[Home] [Help] [Dependency Information]
Object Name: | OKX_AGING_BUCKETS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_AGING_BUCKETS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGING_BUCKET_ID | NUMBER | (15) | Yes | Identifier of aging bucket |
BUCKET_NAME | VARCHAR2 | (20) | Yes | Aging bucket name |
STATUS | VARCHAR2 | (30) | Yes | Status of the aging bucket (Active or Inactive) |
AGING_TYPE | VARCHAR2 | (30) | Yes | Lookup code for aging bucket type in AR_LOOKUPS |
DESCRIPTION | VARCHAR2 | (240) | Aging bucket description | |
B_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
B_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
B_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
AGING_BUCKET_LINE_ID | NUMBER | (15) | Yes | Identifier of aging bucket line |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
BUCKET_SEQUENCE_NUM | NUMBER | (15) | Sequence number | |
DAYS_START | NUMBER | Start of days range | ||
DAYS_TO | NUMBER | End of days range | ||
TYPE | VARCHAR2 | (30) | Yes | Lookup code for aging bucket line type in AR_LOOKUPS, with significant values DISPUTE_ONLY, DISPUTE_PENDADJ, and PENDADJ_ONLY |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT AGING_BUCKET_ID
, BUCKET_NAME
, STATUS
, AGING_TYPE
, DESCRIPTION
, B_ATTRIBUTE_CATEGORY
, B_ATTRIBUTE1
, B_ATTRIBUTE2
, B_ATTRIBUTE3
, B_ATTRIBUTE4
, B_ATTRIBUTE5
, B_ATTRIBUTE6
, B_ATTRIBUTE7
, B_ATTRIBUTE8
, B_ATTRIBUTE9
, B_ATTRIBUTE10
, B_ATTRIBUTE11
, B_ATTRIBUTE12
, B_ATTRIBUTE13
, B_ATTRIBUTE14
, B_ATTRIBUTE15
, AGING_BUCKET_LINE_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, BUCKET_SEQUENCE_NUM
, DAYS_START
, DAYS_TO
, TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.OKX_AGING_BUCKETS_V;
|
|
|