[Home] [Help] [Dependency Information]
Object Name: | GL_JOURNAL_REPORTS_ITF# |
---|---|
Object Type: | VIEW |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
BATCH_ID | NUMBER | (15) | Yes | |
HEADER_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
JE_LINE_NUM | NUMBER | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (30) | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | ||
BATCH_STATUS | VARCHAR2 | (80) | ||
BATCH_TYPE | VARCHAR2 | (240) | ||
BATCH_JOURNAL_TYPE | VARCHAR2 | (80) | ||
BATCH_APPROVAL_STATUS | VARCHAR2 | (80) | ||
BATCH_BUDGET_CONTROL_STATUS | VARCHAR2 | (80) | ||
EXCHANGE_TYPE | VARCHAR2 | (30) | ||
DOC_SEQUENCE_NAME | VARCHAR2 | (30) | ||
TAX_STATUS | VARCHAR2 | (80) | ||
HEADER_ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
HEADER_BUDGET_NAME | VARCHAR2 | (15) | ||
SUBLEDGER_DOC_SEQ_NAME | VARCHAR2 | (30) | ||
TAX_CODE | VARCHAR2 | (50) | ||
TAX_TYPE | VARCHAR2 | (80) | ||
JE_ACCOUNT | VARCHAR2 | (240) | ||
JE_ACCOUNT_DESC | VARCHAR2 | (240) | ||
JE_BALANCE | VARCHAR2 | (240) | ||
JE_BALANCE_DESC | VARCHAR2 | (240) | ||
JE_NATACCT | VARCHAR2 | (240) | ||
JE_NATACCT_DESC | VARCHAR2 | (240) | ||
JE_CC | VARCHAR2 | (240) | ||
JE_CC_DESC | VARCHAR2 | (240) | ||
JE_SECONDARY_SEG | VARCHAR2 | (240) | ||
JE_SECONDARY_DESC | VARCHAR2 | (240) | ||
JE_CONTRA_ACCT | VARCHAR2 | (240) | ||
JE_CONTRA_ACCT_DESC | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, BATCH_ID
, HEADER_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, JE_LINE_NUM
, ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE
, BATCH_STATUS
, BATCH_TYPE
, BATCH_JOURNAL_TYPE
, BATCH_APPROVAL_STATUS
, BATCH_BUDGET_CONTROL_STATUS
, EXCHANGE_TYPE
, DOC_SEQUENCE_NAME
, TAX_STATUS
, HEADER_ENCUMBRANCE_TYPE
, HEADER_BUDGET_NAME
, SUBLEDGER_DOC_SEQ_NAME
, TAX_CODE
, TAX_TYPE
, JE_ACCOUNT
, JE_ACCOUNT_DESC
, JE_BALANCE
, JE_BALANCE_DESC
, JE_NATACCT
, JE_NATACCT_DESC
, JE_CC
, JE_CC_DESC
, JE_SECONDARY_SEG
, JE_SECONDARY_DESC
, JE_CONTRA_ACCT
, JE_CONTRA_ACCT_DESC
FROM GL.GL_JOURNAL_REPORTS_ITF#;
|
|
|