VIEW: APPS.GMF_XLA_INVENTORY_TXNS_V

Source

View Text - Preformatted

SELECT mmt.transaction_id, mmt.transaction_date, mtt.transaction_type_name transaction_type, mp.organization_code, (SELECT organization_code FROM mtl_parameters WHERE organization_id = (CASE WHEN (mmt.organization_id = eh.organization_id) THEN mmt.transfer_organization_id ELSE mmt.organization_id END) ) transfer_organization_code, mmt.subinventory_code, mmt.transfer_subinventory transfer_subinventory, item.concatenated_segments item_name, to_char (mmt.primary_quantity) ||' '|| item.primary_uom_code primary_quantity, item.primary_uom_code, item.secondary_uom_code, mmt.transaction_source_id, mmt.transaction_reference, mtr.reason_name, CASE mmt.transaction_action_id WHEN 15 THEN mmt.shipment_number WHEN 21 THEN mmt.shipment_number WHEN 22 THEN mmt.shipment_number WHEN 12 THEN (CASE WHEN mmt.transaction_source_type_id = 13 THEN to_char(mmt.transaction_id) WHEN mmt.transaction_source_type_id = 7 THEN (SELECT receipt_num FROM rcv_shipment_headers rsh, rcv_transactions rt WHERE rt.transaction_id = mmt.rcv_transaction_id AND rsh.shipment_header_id = rt.shipment_header_id ) END) ELSE to_char(mmt.transaction_id) END document_number, led.ledger_id, led.name ledger_name, eh.valuation_cost_type_id, eh.valuation_cost_type, eh.event_class_code FROM mtl_parameters mp, mtl_system_items_b_kfv item, mtl_transaction_types mtt, mtl_transaction_reasons mtr, mtl_material_transactions mmt, gmf_xla_extract_headers eh, gl_ledgers led WHERE mmt.reason_id = mtr.reason_id (+) and mmt.transaction_type_id = mtt.transaction_type_id and eh.organization_id = item.organization_id and eh.inventory_item_id = item.inventory_item_id and eh.organization_id = mp.organization_id and eh.transaction_id = mmt.transaction_id and led.ledger_id = eh.ledger_id

View Text - HTML Formatted

SELECT MMT.TRANSACTION_ID
, MMT.TRANSACTION_DATE
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE
, MP.ORGANIZATION_CODE
, (SELECT ORGANIZATION_CODE
FROM MTL_PARAMETERS
WHERE ORGANIZATION_ID = (CASE WHEN (MMT.ORGANIZATION_ID = EH.ORGANIZATION_ID) THEN MMT.TRANSFER_ORGANIZATION_ID ELSE MMT.ORGANIZATION_ID END) ) TRANSFER_ORGANIZATION_CODE
, MMT.SUBINVENTORY_CODE
, MMT.TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY
, ITEM.CONCATENATED_SEGMENTS ITEM_NAME
, TO_CHAR (MMT.PRIMARY_QUANTITY) ||' '|| ITEM.PRIMARY_UOM_CODE PRIMARY_QUANTITY
, ITEM.PRIMARY_UOM_CODE
, ITEM.SECONDARY_UOM_CODE
, MMT.TRANSACTION_SOURCE_ID
, MMT.TRANSACTION_REFERENCE
, MTR.REASON_NAME
, CASE MMT.TRANSACTION_ACTION_ID WHEN 15 THEN MMT.SHIPMENT_NUMBER WHEN 21 THEN MMT.SHIPMENT_NUMBER WHEN 22 THEN MMT.SHIPMENT_NUMBER WHEN 12 THEN (CASE WHEN MMT.TRANSACTION_SOURCE_TYPE_ID = 13 THEN TO_CHAR(MMT.TRANSACTION_ID) WHEN MMT.TRANSACTION_SOURCE_TYPE_ID = 7 THEN (SELECT RECEIPT_NUM
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
WHERE RT.TRANSACTION_ID = MMT.RCV_TRANSACTION_ID
AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID ) END) ELSE TO_CHAR(MMT.TRANSACTION_ID) END DOCUMENT_NUMBER
, LED.LEDGER_ID
, LED.NAME LEDGER_NAME
, EH.VALUATION_COST_TYPE_ID
, EH.VALUATION_COST_TYPE
, EH.EVENT_CLASS_CODE
FROM MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_B_KFV ITEM
, MTL_TRANSACTION_TYPES MTT
, MTL_TRANSACTION_REASONS MTR
, MTL_MATERIAL_TRANSACTIONS MMT
, GMF_XLA_EXTRACT_HEADERS EH
, GL_LEDGERS LED
WHERE MMT.REASON_ID = MTR.REASON_ID (+)
AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND EH.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND EH.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND EH.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND EH.TRANSACTION_ID = MMT.TRANSACTION_ID
AND LED.LEDGER_ID = EH.LEDGER_ID