SQL Developer

Dear All,

MTL_MATERIAL_TRANSACTION TABLE column TRANSACTION_SOURCE_ID show null when transaction type is More order issue and Miscellaneous receipt

Please guide how can i solve this iessue.

Query


SELECT

MSI.SEGMENT1,
MSI.SEGMENT2,
MSI.DESCRIPTION,
MSI.PRIMARY_UNIT_OF_MEASURE,
(SELECT MTT.TRANSACTION_TYPE_NAME FROM MTL_TRANSACTION_TYPES MTT WHERE MTT.TRANSACTION_TYPE_ID = A.TRANSACTION_TYPE_ID) TRANSACTION_TYPE,

A.*


FROM

MTL_SYSTEM_ITEMS MSI


,MTL_ITEM_CATEGORIES_V MIC
,MTL_TRANSACTION_TYPES MTT

,
(SELECT
DISTINCT

M.TRANSACTION_DATE, M.TRANSACTION_ID , M.ACTUAL_COST , M.INVENTORY_ITEM_ID , M.ORGANIZATION_ID , M.SUBINVENTORY_CODE ,
M.TRANSACTION_TYPE_ID ,

M.PRIMARY_QUANTITY , M.TRANSACTION_QUANTITY , phpl.ITEM_DESCRIPTION , phpl.UNIT_PRICE , phpl.QUANTITY , R.PO_UNIT_PRICE
from
mtl_material_transactions m
left outer join rcv_transactions r
on m.SOURCE_LINE_ID = r.transaction_id
left outer join (select * from po_lines_all pl join po_headers_all ph
on pl.PO_HEADER_ID = ph.po_header_id) phpl
on r.po_line_id = phpl.po_line_id
) A

WHERE

MSI.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = A.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
and A.ORGANIZATION_ID = 110
--AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
--AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID