FND Design Data [Home] [Help]

View: GL_JOURNAL_REPORTS_ITF_V

Product: GL - General Ledger
Description:
Implementation/DBA Data: ViewAPPS.GL_JOURNAL_REPORTS_ITF_V
View Text

SELECT /*+ ORDERED USE_NL(RX B H SOURCE CAT FU L) */ RX.ROWID ROW_ID
, RX.REQUEST_ID REQUEST_ID
, RX.CREATED_BY CREATED_BY
, RX.CREATION_DATE CREATION_DATE
, RX.LAST_UPDATED_BY LAST_UPDATED_BY
, RX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RX.ORGANIZATION_NAME ORGANIZATION_NAME
, RX.FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, B.NAME BATCH_NAME
, RX.BATCH_STATUS BATCH_STATUS
, B.DEFAULT_EFFECTIVE_DATE BATCH_EFFECTIVE_DATE
, B.POSTED_DATE BATCH_POSTED_DATE
, B.RUNNING_TOTAL_DR BATCH_RUN_TOTAL_DR
, B.RUNNING_TOTAL_CR BATCH_RUN_TOTAL_CR
, B.RUNNING_TOTAL_ACCOUNTED_DR BATCH_RUN_TOTAL_ACCTD_DR
, B.RUNNING_TOTAL_ACCOUNTED_CR BATCH_RUN_TOTAL_ACCTD_CR
, B.DEFAULT_PERIOD_NAME BATCH_PERIOD_NAME
, RX.BATCH_ID BATCH_ID
, RX.BATCH_TYPE BATCH_TYPE
, RX.BATCH_JOURNAL_TYPE BATCH_JOURNAL_TYPE
, RX.BATCH_APPROVAL_STATUS BATCH_APPROVAL_STATUS
, B.DESCRIPTION BATCH_DESCRIPTION
, RX.BATCH_BUDGET_CONTROL_STATUS BATCH_BUDGET_CONTROL_STATUS
, B.DATE_CREATED BATCH_DATE_CREATED
, RX.HEADER_ID HEADER_ID
, H.NAME HEADER_NAME
, CAT.USER_JE_CATEGORY_NAME HEADER_CATEGORY
, SOURCE.USER_JE_SOURCE_NAME HEADER_SOURCE
, H.RUNNING_TOTAL_DR HEADER_RUN_TOTAL_DR
, H.RUNNING_TOTAL_CR HEADER_RUN_TOTAL_CR
, H.RUNNING_TOTAL_ACCOUNTED_DR HEADER_RUN_TOTAL_ACCTD_DR
, H.RUNNING_TOTAL_ACCOUNTED_CR HEADER_RUN_TOTAL_ACCTD_CR
, H.CURRENCY_CODE CURRENCY_CODE
, H.CURRENCY_CONVERSION_RATE EXCHANGE_RATE
, H.CURRENCY_CONVERSION_DATE EXCHANGE_DATE
, RX.EXCHANGE_TYPE EXCHANGE_TYPE
, H.EXTERNAL_REFERENCE HEADER_EXTERNAL_REF
, RX.DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
, H.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, H.LAST_UPDATE_DATE HEADER_LAST_UPDATE_DATE
, FU.USER_NAME HEADER_LAST_UPDATED_BY
, /* H.LAST_UPDATED_BY HEADER_LAST_UPDATED_BY
, */ RX.TAX_STATUS TAX_STATUS
, H.DEFAULT_EFFECTIVE_DATE HEADER_EFFECTIVE_DATE
, H.DESCRIPTION HEADER_DESCRIPTION
, RX.HEADER_ENCUMBRANCE_TYPE HEADER_ENCUMBRANCE_TYPE
, RX.HEADER_BUDGET_NAME HEADER_BUDGET_NAME
, RX.JE_LINE_NUM JE_LINE_NUM
, RX.SUBLEDGER_DOC_SEQ_NAME SUBLEDGER_DOC_SEQ_NAME
, L.SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQ_VALUE
, L.ENTERED_DR ENTERED_DR
, L.ENTERED_CR ENTERED_CR
, L.ACCOUNTED_DR ACCOUNTED_DR
, L.ACCOUNTED_CR ACCOUNTED_CR
, L.CODE_COMBINATION_ID CODE_COMBINATION_ID
, RX.JE_ACCOUNT JE_ACCOUNT
, RX.JE_ACCOUNT_DESC JE_ACCOUNT_DESC
, RX.JE_BALANCE JE_BALANCE
, RX.JE_BALANCE_DESC JE_BALANCE_DESC
, RX.JE_NATACCT JE_NATACCT
, RX.JE_NATACCT_DESC JE_NATACCT_DESC
, RX.JE_CC JE_CC
, RX.JE_CC_DESC JE_CC_DESC
, RX.JE_CONTRA_ACCT JE_CONTRA_ACCT
, RX.JE_CONTRA_ACCT_DESC JE_CONTRA_ACCT_DESC
, RX.JE_SECONDARY_SEG JE_SECONDARY_SEG
, RX.JE_SECONDARY_DESC JE_SECONDARY_DESC
, RX.TAX_CODE TAX_CODE
, RX.TAX_TYPE TAX_TYPE
, L.DESCRIPTION LINE_DESCRIPTION
, L.STAT_AMOUNT STAT_AMOUNT
, L.EFFECTIVE_DATE EFFECTIVE_DATE
, L.REFERENCE_1 LINE_REFERENCE
, L.REFERENCE_4 SOURCE_REFERENCE
, L.REFERENCE_1 REFERENCE_1
, L.REFERENCE_2 REFERENCE_2
, L.REFERENCE_3 REFERENCE_3
, L.REFERENCE_4 REFERENCE_4
, L.REFERENCE_5 REFERENCE_5
, L.REFERENCE_6 REFERENCE_6
, L.REFERENCE_7 REFERENCE_7
, L.REFERENCE_8 REFERENCE_8
, L.REFERENCE_9 REFERENCE_9
, L.REFERENCE_10 REFERENCE_10
FROM GL_JOURNAL_REPORTS_ITF RX
, GL_JE_BATCHES B
, GL_JE_HEADERS H
, GL_JE_LINES L
, GL_JE_CATEGORIES CAT
, GL_JE_SOURCES SOURCE
, FND_USER FU
WHERE RX.BATCH_ID = B.JE_BATCH_ID
AND RX.BATCH_ID = H.JE_BATCH_ID
AND RX.HEADER_ID = H.JE_HEADER_ID
AND RX.HEADER_ID = L.JE_HEADER_ID
AND RX.JE_LINE_NUM = L.JE_LINE_NUM
AND FU.USER_ID = H.LAST_UPDATED_BY
AND H.JE_CATEGORY = CAT.JE_CATEGORY_NAME
AND H.JE_SOURCE = SOURCE.JE_SOURCE_NAME UNION ALL SELECT /*+ ORDERED USE_NL(RX B H SOURCE CAT FU) */ RX.ROWID ROW_ID
, RX.REQUEST_ID REQUEST_ID
, RX.CREATED_BY CREATED_BY
, RX.CREATION_DATE CREATION_DATE
, RX.LAST_UPDATED_BY LAST_UPDATED_BY
, RX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RX.ORGANIZATION_NAME ORGANIZATION_NAME
, RX.FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, B.NAME BATCH_NAME
, RX.BATCH_STATUS BATCH_STATUS
, B.DEFAULT_EFFECTIVE_DATE BATCH_EFFECTIVE_DATE
, B.POSTED_DATE BATCH_POSTED_DATE
, B.RUNNING_TOTAL_DR BATCH_RUN_TOTAL_DR
, B.RUNNING_TOTAL_CR BATCH_RUN_TOTAL_CR
, B.RUNNING_TOTAL_ACCOUNTED_DR BATCH_RUN_TOTAL_ACCTD_DR
, B.RUNNING_TOTAL_ACCOUNTED_CR BATCH_RUN_TOTAL_ACCTD_CR
, B.DEFAULT_PERIOD_NAME BATCH_PERIOD_NAME
, RX.BATCH_ID BATCH_ID
, RX.BATCH_TYPE BATCH_TYPE
, RX.BATCH_JOURNAL_TYPE BATCH_JOURNAL_TYPE
, RX.BATCH_APPROVAL_STATUS BATCH_APPROVAL_STATUS
, B.DESCRIPTION BATCH_DESCRIPTION
, RX.BATCH_BUDGET_CONTROL_STATUS BATCH_BUDGET_CONTROL_STATUS
, B.DATE_CREATED BATCH_DATE_CREATED
, RX.HEADER_ID HEADER_ID
, H.NAME HEADER_NAME
, CAT.USER_JE_CATEGORY_NAME HEADER_CATEGORY
, SOURCE.USER_JE_SOURCE_NAME HEADER_SOURCE
, H.RUNNING_TOTAL_DR HEADER_RUN_TOTAL_DR
, H.RUNNING_TOTAL_CR HEADER_RUN_TOTAL_CR
, H.RUNNING_TOTAL_ACCOUNTED_DR HEADER_RUN_TOTAL_ACCTD_DR
, H.RUNNING_TOTAL_ACCOUNTED_CR HEADER_RUN_TOTAL_ACCTD_CR
, H.CURRENCY_CODE CURRENCY_CODE
, H.CURRENCY_CONVERSION_RATE EXCHANGE_RATE
, H.CURRENCY_CONVERSION_DATE EXCHANGE_DATE
, RX.EXCHANGE_TYPE EXCHANGE_TYPE
, H.EXTERNAL_REFERENCE HEADER_EXTERNAL_REF
, RX.DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
, H.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, H.LAST_UPDATE_DATE HEADER_LAST_UPDATE_DATE
, FU.USER_NAME HEADER_LAST_UPDATED_BY
, /* H.LAST_UPDATED_BY HEADER_LAST_UPDATED_BY
, */ RX.TAX_STATUS TAX_STATUS
, H.DEFAULT_EFFECTIVE_DATE HEADER_EFFECTIVE_DATE
, H.DESCRIPTION HEADER_DESCRIPTION
, RX.HEADER_ENCUMBRANCE_TYPE HEADER_ENCUMBRANCE_TYPE
, RX.HEADER_BUDGET_NAME HEADER_BUDGET_NAME
, RX.JE_LINE_NUM JE_LINE_NUM
, RX.SUBLEDGER_DOC_SEQ_NAME SUBLEDGER_DOC_SEQ_NAME
, TO_NUMBER(NULL)
, /* SUBLEDGER_DOC_SEQ_VALUE */ TO_NUMBER(NULL)
, /* ENTERED_DR */ TO_NUMBER(NULL)
, /* ENTERED_RC */ TO_NUMBER(NULL)
, /* ACCOUNTED_DR */ TO_NUMBER(NULL)
, /* ACCOUNTED_CR */ TO_NUMBER(NULL)
, /* CODE_COMBINATION_ID */ RX.JE_ACCOUNT JE_ACCOUNT
, RX.JE_ACCOUNT_DESC JE_ACCOUNT_DESC
, RX.JE_BALANCE JE_BALANCE
, RX.JE_BALANCE_DESC JE_BALANCE_DESC
, RX.JE_NATACCT JE_NATACCT
, RX.JE_NATACCT_DESC JE_NATACCT_DESC
, RX.JE_CC JE_CC
, RX.JE_CC_DESC JE_CC_DESC
, RX.JE_CONTRA_ACCT JE_CONTRA_ACCT
, RX.JE_CONTRA_ACCT_DESC JE_CONTRA_ACCT_DESC
, RX.JE_SECONDARY_SEG JE_SECONDARY_SEG
, RX.JE_SECONDARY_DESC JE_SECONDARY_DESC
, RX.TAX_CODE TAX_CODE
, RX.TAX_TYPE TAX_TYPE
, TO_CHAR(NULL)
, /* LINE_DESCRIPTION */ TO_NUMBER(NULL)
, /* STAT_AMOUNT */ TO_DATE(NULL)
, /* EFFECTIVE_DATE */ TO_CHAR(NULL)
, /* LINE_REFERENCE */ TO_CHAR(NULL)
, /* SOURCE_REFERENCE */ TO_CHAR(NULL)
, /* REFERENCE_1 */ TO_CHAR(NULL)
, /* REFERENCE_2 */ TO_CHAR(NULL)
, /* REFERENCE_3 */ TO_CHAR(NULL)
, /* REFERENCE_4 */ TO_CHAR(NULL)
, /* REFERENCE_5 */ TO_CHAR(NULL)
, /* REFERENCE_6 */ TO_CHAR(NULL)
, /* REFERENCE_7 */ TO_CHAR(NULL)
, /* REFERENCE_8 */ TO_CHAR(NULL)
, /* REFERENCE_9 */ TO_CHAR(NULL) /* REFERENCE_10 */
FROM GL_JOURNAL_REPORTS_ITF RX
, GL_JE_BATCHES B
, GL_JE_HEADERS H
, GL_JE_CATEGORIES CAT
, GL_JE_SOURCES SOURCE
, FND_USER FU
WHERE RX.JE_LINE_NUM IS NULL
AND RX.BATCH_ID = B.JE_BATCH_ID
AND RX.BATCH_ID = H.JE_BATCH_ID
AND RX.HEADER_ID = H.JE_HEADER_ID
AND FU.USER_ID = H.LAST_UPDATED_BY
AND H.JE_CATEGORY = CAT.JE_CATEGORY_NAME
AND H.JE_SOURCE = SOURCE.JE_SOURCE_NAME

Columns

Name
ROW_ID
REQUEST_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ORGANIZATION_NAME
FUNCTIONAL_CURRENCY_CODE
BATCH_NAME
BATCH_STATUS
BATCH_EFFECTIVE_DATE
BATCH_POSTED_DATE
BATCH_RUN_TOTAL_DR
BATCH_RUN_TOTAL_CR
BATCH_RUN_TOTAL_ACCTD_DR
BATCH_RUN_TOTAL_ACCTD_CR
BATCH_PERIOD_NAME
BATCH_ID
BATCH_TYPE
BATCH_JOURNAL_TYPE
BATCH_APPROVAL_STATUS
BATCH_DESCRIPTION
BATCH_BUDGET_CONTROL_STATUS
BATCH_DATE_CREATED
HEADER_ID
HEADER_NAME
HEADER_CATEGORY
HEADER_SOURCE
HEADER_RUN_TOTAL_DR
HEADER_RUN_TOTAL_CR
HEADER_RUN_TOTAL_ACCTD_DR
HEADER_RUN_TOTAL_ACCTD_CR
CURRENCY_CODE
EXCHANGE_RATE
EXCHANGE_DATE
EXCHANGE_TYPE
HEADER_EXTERNAL_REF
DOC_SEQUENCE_NAME
DOC_SEQUENCE_VALUE
HEADER_LAST_UPDATE_DATE
HEADER_LAST_UPDATED_BY
TAX_STATUS
HEADER_EFFECTIVE_DATE
HEADER_DESCRIPTION
HEADER_ENCUMBRANCE_TYPE
HEADER_BUDGET_NAME
JE_LINE_NUM
SUBLEDGER_DOC_SEQ_NAME
SUBLEDGER_DOC_SEQ_VALUE
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
CODE_COMBINATION_ID
JE_ACCOUNT
JE_ACCOUNT_DESC
JE_BALANCE
JE_BALANCE_DESC
JE_NATACCT
JE_NATACCT_DESC
JE_CC
JE_CC_DESC
JE_CONTRA_ACCT
JE_CONTRA_ACCT_DESC
JE_SECONDARY_SEG
JE_SECONDARY_DESC
TAX_CODE
TAX_TYPE
LINE_DESCRIPTION
STAT_AMOUNT
EFFECTIVE_DATE
LINE_REFERENCE
SOURCE_REFERENCE
REFERENCE_1
REFERENCE_2
REFERENCE_3
REFERENCE_4
REFERENCE_5
REFERENCE_6
REFERENCE_7
REFERENCE_8
REFERENCE_9
REFERENCE_10