VIEW: APPS.GL_JOURNAL_REPORTS_ITF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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