[Home] [Help] [Dependency Information]
Object Name: | PSA_XLA_VALIDATION_LINES_LOGS# |
---|---|
Object Type: | VIEW |
Owner: | PSA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | ||
ENTITY_ID | NUMBER | (15) | ||
AE_HEADER_ID | NUMBER | (15) | ||
AE_LINE_NUM | NUMBER | (15) | ||
ACCOUNTING_DATE | DATE | |||
BALANCE_TYPE_CODE | VARCHAR2 | (1) | ||
JE_CATEGORY_NAME | VARCHAR2 | (25) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
ACCOUNTED_CR | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | |||
BALANCING_LINE_TYPE | VARCHAR2 | (1) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | (30) | ||
PERIOD_NAME | VARCHAR2 | (30) | ||
PHASE | VARCHAR2 | (30) | ||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, ENTITY_ID
, AE_HEADER_ID
, AE_LINE_NUM
, ACCOUNTING_DATE
, BALANCE_TYPE_CODE
, JE_CATEGORY_NAME
, BUDGET_VERSION_ID
, LEDGER_ID
, ENTERED_CURRENCY_CODE
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, CODE_COMBINATION_ID
, BALANCING_LINE_TYPE
, ENCUMBRANCE_TYPE_ID
, ACCOUNTING_ENTRY_STATUS_CODE
, PERIOD_NAME
, PHASE
, CREATION_DATE
FROM PSA.PSA_XLA_VALIDATION_LINES_LOGS#;
|
|
|