VIEW: APPS.CST_XLA_INV_LINES_V

Source

View Text - Preformatted

SELECT /*+ Leading(xgt,CXIHV) push_pred(CXIHV) INDEX(MTA MTL_TRANSACTION_ACCOUNTS_N1) */ cxihv.event_id, /* EVENT IDENTIFIER */ ROW_NUMBER() OVER(Partition BY CXIHV.EVENT_ID ORDER BY CXIHV.EVENT_ID) AS LINE_NUMBER, /* LINE NUMBER */ mta.reference_account code_combination_id, /* REFERENCE_ACCOUNT */ NVL(mta.transaction_value, mta.base_transaction_value) entered_amount, /* ENTERED_AMOUNT */ mta.accounting_line_type accounting_line_type_code, /* ACCOUNTING_LINE_TYPE_CODE */ mta.base_transaction_value accounted_amount, /* ACCOUNTED_AMOUNT */ mta.rate_or_amount, /* RATE_OR_AMOUNT */ mta.basis_type inv_txn_basis_type, /* BASIS_TYPE */ NVL(MTA.CURRENCY_CODE, GL.CURRENCY_CODE) CURRENCY_CODE, DECODE(MTA.CURRENCY_CODE, NULL, NVL(MTA.CURRENCY_CONVERSION_DATE,MMT.CURRENCY_CONVERSION_DATE), GL.CURRENCY_CODE, MTA.CURRENCY_CONVERSION_DATE, NVL(MTA.CURRENCY_CONVERSION_DATE,NVL(MMT.CURRENCY_CONVERSION_DATE, CXIHV.TRANSACTION_DATE) ) ) CURRENCY_CONVERSION_DATE, DECODE(MTA.CURRENCY_CODE, NULL, to_number(NULL), GL.CURRENCY_CODE, to_number(NULL), MTA.CURRENCY_CONVERSION_RATE ) CURRENCY_CONVERSION_RATE, DECODE(MTA.CURRENCY_CODE, NULL, NULL, GL.CURRENCY_CODE, NULL, MTA.CURRENCY_CONVERSION_TYPE ) CURRENCY_CONVERSION_TYPE, mta.resource_id material_overhead_id , /* MATERIAL_OVERHEAD_ID */ mta.cost_element_id, /* COST_ELEMENT_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_subinventory_code, CXIHV.h_transfer_subinventory ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_subinventory_code, CXIHV.h_transfer_subinventory ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_subinventory_code, CXIHV.h_transfer_subinventory ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_subinventory_code, CXIHV.h_transfer_subinventory ), h_subinventory_code ) subinventory_code, /* SUBINVENTORY_CODE */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_subinventory, CXIHV.h_subinventory_code ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_subinventory, CXIHV.h_subinventory_code ), 28,DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_subinventory, CXIHV.h_subinventory_code ), 55,DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_subinventory, CXIHV.h_subinventory_code ), h_transfer_subinventory ) transfer_subinventory, /* TRANSFER_SUBINVENTORY */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_locator_id, CXIHV.h_transfer_locator_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_locator_id, CXIHV.h_transfer_locator_id ), 28,DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_locator_id, CXIHV.h_transfer_locator_id ), 55,DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_locator_id, CXIHV.h_transfer_locator_id ), h_locator_id ) locator_id, /* LOCATOR_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_locator_id, CXIHV.h_locator_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_locator_id, CXIHV.h_locator_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_locator_id, CXIHV.h_locator_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_locator_id, CXIHV.h_locator_id ), h_transfer_locator_id ) transfer_locator_id, /* TRANSFER_LOCATOR_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_cost_group_id, CXIHV.h_transfer_cost_group_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_cost_group_id, CXIHV.h_transfer_cost_group_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_cost_group_id, CXIHV.h_transfer_cost_group_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_cost_group_id, CXIHV.h_transfer_cost_group_id ), h_cost_group_id ) cost_group_id, /*COST_GROUP_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_cost_group_id, CXIHV.h_cost_group_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_cost_group_id, CXIHV.h_cost_group_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_cost_group_id, CXIHV.h_cost_group_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_transfer_cost_group_id, CXIHV.h_cost_group_id ), h_transfer_cost_group_id ) transfer_cost_group_id, /*TRANSFER_COST_GROUP_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_project_id, CXIHV.h_project_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_project_id, CXIHV.h_project_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_project_id, CXIHV.h_project_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_project_id, CXIHV.h_project_id ), h_to_project_id ) to_project_id, /* TO_PROJECT_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_project_id, CXIHV.h_to_project_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_project_id, CXIHV.h_to_project_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_project_id, CXIHV.h_to_project_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_project_id, CXIHV.h_to_project_id ), h_project_id ) project_id, /* PROJECT_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_task_id, CXIHV.h_task_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_task_id, CXIHV.h_task_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_task_id, CXIHV.h_task_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_to_task_id, CXIHV.h_task_id ), h_to_task_id ) to_task_id, /* TO_TASK_ID */ DECODE(CXIHV.transaction_action_id, 2, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_task_id, CXIHV.h_to_task_id ), 5, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_task_id, CXIHV.h_to_task_id ), 28, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_task_id, CXIHV.h_to_task_id ), 55, DECODE(SIGN(MTA.primary_quantity), SIGN(CXIHV.primary_quantity), CXIHV.h_task_id, CXIHV.h_to_task_id ), h_task_id ) task_id, /* TASK_ID */ CXIHV.h_ledger_id ledger_id, CXIHV.organization_id l_organization_id, MTA.inv_sub_ledger_id distribution_identifier , mta.transaction_id , mp.organization_code l_organization_code FROM MTL_TRANSACTION_ACCOUNTS MTA , CST_XLA_INV_HEADERS_V CXIHV , GL_LEDGERS GL , MTL_MATERIAL_TRANSACTIONS MMT , xla_events_gt xgt , mtl_parameters mp WHERE MTA.transaction_id = CXIHV.transaction_id AND MTA.transaction_source_type_id = CXIHV.transaction_source_type_id AND MTA.transaction_id = MMT.transaction_id AND CXIHV.event_id = xgt.event_id AND CXIHV.organization_id = MTA.organization_id AND GL.ledger_id = CXIHV.h_ledger_id AND mta.organization_id = mp.organization_id

View Text - HTML Formatted

SELECT /*+ LEADING(XGT
, CXIHV) PUSH_PRED(CXIHV) INDEX(MTA MTL_TRANSACTION_ACCOUNTS_N1) */ CXIHV.EVENT_ID
, /* EVENT IDENTIFIER */ ROW_NUMBER() OVER(PARTITION BY CXIHV.EVENT_ID ORDER BY CXIHV.EVENT_ID) AS LINE_NUMBER
, /* LINE NUMBER */ MTA.REFERENCE_ACCOUNT CODE_COMBINATION_ID
, /* REFERENCE_ACCOUNT */ NVL(MTA.TRANSACTION_VALUE
, MTA.BASE_TRANSACTION_VALUE) ENTERED_AMOUNT
, /* ENTERED_AMOUNT */ MTA.ACCOUNTING_LINE_TYPE ACCOUNTING_LINE_TYPE_CODE
, /* ACCOUNTING_LINE_TYPE_CODE */ MTA.BASE_TRANSACTION_VALUE ACCOUNTED_AMOUNT
, /* ACCOUNTED_AMOUNT */ MTA.RATE_OR_AMOUNT
, /* RATE_OR_AMOUNT */ MTA.BASIS_TYPE INV_TXN_BASIS_TYPE
, /* BASIS_TYPE */ NVL(MTA.CURRENCY_CODE
, GL.CURRENCY_CODE) CURRENCY_CODE
, DECODE(MTA.CURRENCY_CODE
, NULL
, NVL(MTA.CURRENCY_CONVERSION_DATE
, MMT.CURRENCY_CONVERSION_DATE)
, GL.CURRENCY_CODE
, MTA.CURRENCY_CONVERSION_DATE
, NVL(MTA.CURRENCY_CONVERSION_DATE
, NVL(MMT.CURRENCY_CONVERSION_DATE
, CXIHV.TRANSACTION_DATE) ) ) CURRENCY_CONVERSION_DATE
, DECODE(MTA.CURRENCY_CODE
, NULL
, TO_NUMBER(NULL)
, GL.CURRENCY_CODE
, TO_NUMBER(NULL)
, MTA.CURRENCY_CONVERSION_RATE ) CURRENCY_CONVERSION_RATE
, DECODE(MTA.CURRENCY_CODE
, NULL
, NULL
, GL.CURRENCY_CODE
, NULL
, MTA.CURRENCY_CONVERSION_TYPE ) CURRENCY_CONVERSION_TYPE
, MTA.RESOURCE_ID MATERIAL_OVERHEAD_ID
, /* MATERIAL_OVERHEAD_ID */ MTA.COST_ELEMENT_ID
, /* COST_ELEMENT_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_SUBINVENTORY_CODE
, CXIHV.H_TRANSFER_SUBINVENTORY )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_SUBINVENTORY_CODE
, CXIHV.H_TRANSFER_SUBINVENTORY )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_SUBINVENTORY_CODE
, CXIHV.H_TRANSFER_SUBINVENTORY )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_SUBINVENTORY_CODE
, CXIHV.H_TRANSFER_SUBINVENTORY )
, H_SUBINVENTORY_CODE ) SUBINVENTORY_CODE
, /* SUBINVENTORY_CODE */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_SUBINVENTORY
, CXIHV.H_SUBINVENTORY_CODE )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_SUBINVENTORY
, CXIHV.H_SUBINVENTORY_CODE )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_SUBINVENTORY
, CXIHV.H_SUBINVENTORY_CODE )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_SUBINVENTORY
, CXIHV.H_SUBINVENTORY_CODE )
, H_TRANSFER_SUBINVENTORY ) TRANSFER_SUBINVENTORY
, /* TRANSFER_SUBINVENTORY */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_LOCATOR_ID
, CXIHV.H_TRANSFER_LOCATOR_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_LOCATOR_ID
, CXIHV.H_TRANSFER_LOCATOR_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_LOCATOR_ID
, CXIHV.H_TRANSFER_LOCATOR_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_LOCATOR_ID
, CXIHV.H_TRANSFER_LOCATOR_ID )
, H_LOCATOR_ID ) LOCATOR_ID
, /* LOCATOR_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_LOCATOR_ID
, CXIHV.H_LOCATOR_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_LOCATOR_ID
, CXIHV.H_LOCATOR_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_LOCATOR_ID
, CXIHV.H_LOCATOR_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_LOCATOR_ID
, CXIHV.H_LOCATOR_ID )
, H_TRANSFER_LOCATOR_ID ) TRANSFER_LOCATOR_ID
, /* TRANSFER_LOCATOR_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_COST_GROUP_ID
, CXIHV.H_TRANSFER_COST_GROUP_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_COST_GROUP_ID
, CXIHV.H_TRANSFER_COST_GROUP_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_COST_GROUP_ID
, CXIHV.H_TRANSFER_COST_GROUP_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_COST_GROUP_ID
, CXIHV.H_TRANSFER_COST_GROUP_ID )
, H_COST_GROUP_ID ) COST_GROUP_ID
, /*COST_GROUP_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_COST_GROUP_ID
, CXIHV.H_COST_GROUP_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_COST_GROUP_ID
, CXIHV.H_COST_GROUP_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_COST_GROUP_ID
, CXIHV.H_COST_GROUP_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TRANSFER_COST_GROUP_ID
, CXIHV.H_COST_GROUP_ID )
, H_TRANSFER_COST_GROUP_ID ) TRANSFER_COST_GROUP_ID
, /*TRANSFER_COST_GROUP_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_PROJECT_ID
, CXIHV.H_PROJECT_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_PROJECT_ID
, CXIHV.H_PROJECT_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_PROJECT_ID
, CXIHV.H_PROJECT_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_PROJECT_ID
, CXIHV.H_PROJECT_ID )
, H_TO_PROJECT_ID ) TO_PROJECT_ID
, /* TO_PROJECT_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_PROJECT_ID
, CXIHV.H_TO_PROJECT_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_PROJECT_ID
, CXIHV.H_TO_PROJECT_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_PROJECT_ID
, CXIHV.H_TO_PROJECT_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_PROJECT_ID
, CXIHV.H_TO_PROJECT_ID )
, H_PROJECT_ID ) PROJECT_ID
, /* PROJECT_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_TASK_ID
, CXIHV.H_TASK_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_TASK_ID
, CXIHV.H_TASK_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_TASK_ID
, CXIHV.H_TASK_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TO_TASK_ID
, CXIHV.H_TASK_ID )
, H_TO_TASK_ID ) TO_TASK_ID
, /* TO_TASK_ID */ DECODE(CXIHV.TRANSACTION_ACTION_ID
, 2
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TASK_ID
, CXIHV.H_TO_TASK_ID )
, 5
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TASK_ID
, CXIHV.H_TO_TASK_ID )
, 28
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TASK_ID
, CXIHV.H_TO_TASK_ID )
, 55
, DECODE(SIGN(MTA.PRIMARY_QUANTITY)
, SIGN(CXIHV.PRIMARY_QUANTITY)
, CXIHV.H_TASK_ID
, CXIHV.H_TO_TASK_ID )
, H_TASK_ID ) TASK_ID
, /* TASK_ID */ CXIHV.H_LEDGER_ID LEDGER_ID
, CXIHV.ORGANIZATION_ID L_ORGANIZATION_ID
, MTA.INV_SUB_LEDGER_ID DISTRIBUTION_IDENTIFIER
, MTA.TRANSACTION_ID
, MP.ORGANIZATION_CODE L_ORGANIZATION_CODE
FROM MTL_TRANSACTION_ACCOUNTS MTA
, CST_XLA_INV_HEADERS_V CXIHV
, GL_LEDGERS GL
, MTL_MATERIAL_TRANSACTIONS MMT
, XLA_EVENTS_GT XGT
, MTL_PARAMETERS MP
WHERE MTA.TRANSACTION_ID = CXIHV.TRANSACTION_ID
AND MTA.TRANSACTION_SOURCE_TYPE_ID = CXIHV.TRANSACTION_SOURCE_TYPE_ID
AND MTA.TRANSACTION_ID = MMT.TRANSACTION_ID
AND CXIHV.EVENT_ID = XGT.EVENT_ID
AND CXIHV.ORGANIZATION_ID = MTA.ORGANIZATION_ID
AND GL.LEDGER_ID = CXIHV.H_LEDGER_ID
AND MTA.ORGANIZATION_ID = MP.ORGANIZATION_ID