GL_XCC_JOURNALS_EXTRACT_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name

DATA_SET_ID SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 TRANSACTION_NUMBER SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 LINE_GROUP_CODE LINE_NUM LEDGER_ID BUSINESS_UNIT_ID DESTINATION_TYPE_CODE DOCUMENT_TYPE_CODE TRANSACTION_SOURCE_CODE TRANSACTION_SUBTYPE_CODE JE_SOURCE_CODE JE_CATEGORY_CODE BUDGET_DATE ACCOUNTING_DATE ENCUMBRANCE_TYPE_CODE ENTERED_CURRENCY UOM_CODE QUANTITY PRICE ENTERED_AMOUNT CONVERSION_TYPE_CODE CONVERSION_DATE LEDGER_AMOUNT LIQUIDATION_DATE LIQUIDATION_QUANTITY LIQUIDATION_AMOUNT LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_6 STATISTICAL_AMOUNT BUDGET_CCID VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO CODE_COMBINATION_ID PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID CONTROL_BUDGET_ID

Query

SQL_Statement

SELECT XCCJ.data_set_id DATA_SET_ID, TO_CHAR(JB.je_batch_id) SOURCE_HEADER_ID_1, ' ' SOURCE_HEADER_ID_2, JB.name || ' ' || JB.default_period_name TRANSACTION_NUMBER, TO_CHAR(JH.je_header_id) SOURCE_LINE_ID_1, TO_CHAR(JL.je_line_num) SOURCE_LINE_ID_2, ' ' SOURCE_LINE_ID_3, ' ' SOURCE_LINE_ID_4, ' ' SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, NULL LINE_GROUP_CODE, NULL LINE_NUM, JL.ledger_id LEDGER_ID, NULL BUSINESS_UNIT_ID, NULL DESTINATION_TYPE_CODE, NULL DOCUMENT_TYPE_CODE, NULL TRANSACTION_SOURCE_CODE, NULL TRANSACTION_SUBTYPE_CODE, JH.je_source JE_SOURCE_CODE, JH.je_category JE_CATEGORY_CODE, JL.effective_date BUDGET_DATE, JL.effective_date ACCOUNTING_DATE, ENC.encumbrance_type_code ENCUMBRANCE_TYPE_CODE, JL.currency_code ENTERED_CURRENCY, NULL UOM_CODE, NULL QUANTITY, NULL PRICE, DECODE(DECODE(CC.account_type, 'A', 'dr', 'E', 'dr', 'D', 'dr', 'L', 'cr', 'R', 'cr', 'O', 'cr', 'C', 'cr'), 'dr', nvl(JL.entered_dr, 0) - nvl(JL.entered_cr, 0), 'cr', nvl(JL.entered_cr, 0) - nvl(JL.entered_dr, 0)) ENTERED_AMOUNT, JL.currency_conversion_type CONVERSION_TYPE_CODE, JL.currency_conversion_date CONVERSION_DATE, DECODE(DECODE(CC.account_type, 'A', 'dr', 'E', 'dr', 'D', 'dr', 'L', 'cr', 'R', 'cr', 'O', 'cr', 'C', 'cr'), 'dr', nvl(JL.accounted_dr, 0) - nvl(JL.accounted_cr, 0), 'cr', nvl(JL.accounted_cr, 0) - nvl(JL.accounted_dr, 0)) LEDGER_AMOUNT, NULL LIQUIDATION_DATE, NULL LIQUIDATION_QUANTITY, NULL LIQUIDATION_AMOUNT, NULL LIQUIDATION_TRANS_TYPE_CODE, NULL LIQUIDATION_LINE_ID_1, NULL LIQUIDATION_LINE_ID_2, NULL LIQUIDATION_LINE_ID_3, NULL LIQUIDATION_LINE_ID_4, NULL LIQUIDATION_LINE_ID_5, NULL LIQUIDATION_LINE_ID_6, JL.stat_amount STATISTICAL_AMOUNT, NULL BUDGET_CCID, NULL VENDOR_ID, NULL INVENTORY_ITEM_ID, NULL ORDER_TYPE_INFO, JL.code_combination_id CODE_COMBINATION_ID, NULL PJC_PROJECT_ID, NULL PJC_TASK_ID, NULL PJC_RESOURCE_ID, NULL PJC_CONTRACT_ID, NULL PJC_CONTRACT_LINE_ID, NULL PJC_FUNDING_ALLOCATION_ID, NULL PJC_BILLABLE_FLAG, NULL PJC_CAPITALIZABLE_FLAG, NULL PJC_EXPENDITURE_TYPE_ID, NULL PJC_EXPENDITURE_ITEM_DATE, NULL PJC_ORGANIZATION_ID, NULL PJC_WORK_TYPE_ID, NULL CONTROL_BUDGET_ID FROM GL_XCC_JOURNALS_GT XCCJ, GL_JE_BATCHES JB, GL_JE_HEADERS JH, GL_JE_LINES JL, GL_ENCUMBRANCE_TYPES_B ENC, GL_CODE_COMBINATIONS CC WHERE JB.je_batch_id = XCCJ.je_batch_id AND JH.je_batch_id = JB.je_batch_id AND ENC.encumbrance_type_id (+) = JH.encumbrance_type_id AND JL.je_header_id = JH.je_header_id AND CC.code_combination_id = JL.code_combination_id