[Home] [Help] [Dependency Information]
Object Name: | OZF_AE_LINES_ALL |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_AE_LINES_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 Lines. This is an Org stripped view
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_AE_LINES_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AE_LINE_ID |
OZF_AE_LINES_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CODE_COMBINATION_ID |
OZF_AE_LINES_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SOURCE_TABLE
SOURCE_ID |
OZF_AE_LINES_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GL_SL_LINK_ID |
OZF_AE_LINES_ALL_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
THIRD_PARTY_ID
THIRD_PARTY_SUB_ID |
OZF_AE_LINES_ALL_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AE_LINE_TYPE_CODE |
OZF_AE_LINES_ALL_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
AE_HEADER_ID
AE_LINE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_LINE_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 | |||
ACCOUNTED_CR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
ACCOUNTING_ERROR_CODE | VARCHAR2 | (30) | ||
AE_HEADER_ID | NUMBER | Yes | ||
AE_LINE_NUMBER | NUMBER | Yes | ||
AE_LINE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
APPLIED_FROM_TRX_HDR_ID | NUMBER | |||
APPLIED_FROM_TRX_HDR_TABLE | VARCHAR2 | (30) | ||
APPLIED_TO_TRX_HDR_ID | NUMBER | |||
APPLIED_TO_TRX_HDR_TABLE | VARCHAR2 | (30) | ||
CODE_COMBINATION_ID | NUMBER | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
ENTERED_CR | NUMBER | |||
ENTERED_DR | NUMBER | |||
GL_SL_LINK_ID | NUMBER | |||
GL_TRANSFER_ERROR_CODE | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | Yes | ||
REFERENCE1 | VARCHAR2 | (240) | ||
REFERENCE2 | VARCHAR2 | (240) | ||
REFERENCE3 | VARCHAR2 | (240) | ||
REFERENCE4 | VARCHAR2 | (240) | ||
REFERENCE5 | VARCHAR2 | (240) | ||
REFERENCE6 | VARCHAR2 | (240) | ||
REFERENCE7 | VARCHAR2 | (240) | ||
REFERENCE8 | VARCHAR2 | (240) | ||
REFERENCE9 | VARCHAR2 | (240) | ||
REFERENCE10 | VARCHAR2 | (240) | ||
SOURCE_ID | NUMBER | Yes | ||
SOURCE_TABLE | VARCHAR2 | (30) | Yes | |
STAT_AMOUNT | NUMBER | |||
SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | |||
SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | |||
TAXABLE_ACCOUNTED_CR | NUMBER | |||
TAXABLE_ACCOUNTED_DR | NUMBER | |||
TAXABLE_ENTERED_CR | NUMBER | |||
TAXABLE_ENTERED_DR | NUMBER | |||
TAX_CODE_ID | NUMBER | |||
TAX_LINK_ID | NUMBER | |||
THIRD_PARTY_ID | NUMBER | |||
THIRD_PARTY_SUB_ID | NUMBER | |||
THIRD_PARTY_TYPE | VARCHAR2 | (30) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT AE_LINE_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
, ACCOUNTED_CR
, ACCOUNTED_DR
, ACCOUNTING_ERROR_CODE
, AE_HEADER_ID
, AE_LINE_NUMBER
, AE_LINE_TYPE_CODE
, APPLIED_FROM_TRX_HDR_ID
, APPLIED_FROM_TRX_HDR_TABLE
, APPLIED_TO_TRX_HDR_ID
, APPLIED_TO_TRX_HDR_TABLE
, CODE_COMBINATION_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, DESCRIPTION
, ENTERED_CR
, ENTERED_DR
, GL_SL_LINK_ID
, GL_TRANSFER_ERROR_CODE
, ORG_ID
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, SOURCE_ID
, SOURCE_TABLE
, STAT_AMOUNT
, SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE
, TAXABLE_ACCOUNTED_CR
, TAXABLE_ACCOUNTED_DR
, TAXABLE_ENTERED_CR
, TAXABLE_ENTERED_DR
, TAX_CODE_ID
, TAX_LINK_ID
, THIRD_PARTY_ID
, THIRD_PARTY_SUB_ID
, THIRD_PARTY_TYPE
, USSGL_TRANSACTION_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM OZF.OZF_AE_LINES_ALL;
OZF.OZF_AE_LINES_ALL does not reference any database object
OZF.OZF_AE_LINES_ALL is referenced by following:
|
|
|