[Home] [Help] [Dependency Information]
Object Name: | OZF_AE_HEADERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_AE_HEADERS_ALL |
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 view definition returns the General Ledger Accounting Event Headers. This is an Org stripped view
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_AE_HEADERS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AE_HEADER_ID |
OZF_AE_HEADERS_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACCOUNTING_EVENT_ID
SET_OF_BOOKS_ID |
OZF_AE_HEADERS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GL_TRANSFER_FLAG |
OZF_AE_HEADERS_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GL_TRANSFER_RUN_ID
ACCOUNTING_DATE |
OZF_AE_HEADERS_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOUNTING_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_HEADER_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
PROGRAM_ID | NUMBER | |||
ACCOUNTING_EVENT_ID | NUMBER | Yes | ||
ACCOUNTING_DATE | DATE | Yes | ||
ACCOUNTING_ERROR_CODE | VARCHAR2 | (30) | ||
AE_CATEGORY | VARCHAR2 | (30) | Yes | |
AE_SEQUENCE_ID | NUMBER | |||
AE_SEQUENCE_VALUE | NUMBER | |||
CROSS_CURRENCY_FLAG | VARCHAR2 | (1) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
GL_REVERSAL_FLAG | VARCHAR2 | (1) | ||
GL_TRANSFAR_ERROR_CODE | VARCHAR2 | (30) | ||
GL_TRANSFAR_FLAG | VARCHAR2 | (1) | ||
GL_TRANSFAR_RUN_ID | NUMBER | |||
ORG_ID | NUMBER | Yes | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | Yes | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
GL_TRANSFER_ERROR_CODE | VARCHAR2 | (30) | ||
GL_TRANSFER_FLAG | VARCHAR2 | (1) | Yes | |
GL_TRANSFER_RUN_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, ACCOUNTING_EVENT_ID
, ACCOUNTING_DATE
, ACCOUNTING_ERROR_CODE
, AE_CATEGORY
, AE_SEQUENCE_ID
, AE_SEQUENCE_VALUE
, CROSS_CURRENCY_FLAG
, DESCRIPTION
, GL_REVERSAL_FLAG
, GL_TRANSFAR_ERROR_CODE
, GL_TRANSFAR_FLAG
, GL_TRANSFAR_RUN_ID
, ORG_ID
, PERIOD_NAME
, SET_OF_BOOKS_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, GL_TRANSFER_ERROR_CODE
, GL_TRANSFER_FLAG
, GL_TRANSFER_RUN_ID
FROM OZF.OZF_AE_HEADERS_ALL;
OZF.OZF_AE_HEADERS_ALL does not reference any database object
OZF.OZF_AE_HEADERS_ALL is referenced by following:
|
|
|