View: GMF_XLA_INVENTORY_TXNS_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from inventory transactions
Implementation/DBA Data:	APPS.GMF_XLA_INVENTORY_TXNS_V

View Text

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) 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

Columns