[Home] [Help] [Dependency Information]
Object Name: | OZF_AE_HEADERS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
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
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 | |||
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#;
|
|
|