DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_TRANSACTION_TYPES

Line 1916: MTL_TRANSACTION_TYPES MTT

1912:
1913: SELECT SUM(MTRL.QUANTITY - NVL(MTRL.QUANTITY_DELIVERED,0))
1914: INTO qty
1915: FROM MTL_TXN_REQUEST_LINES MTRL,
1916: MTL_TRANSACTION_TYPES MTT
1917: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
1918: AND MTRL.ORGANIZATION_ID = p_organization_id
1919: AND MTRL.INVENTORY_ITEM_ID = p_inventory_item_id
1920: AND MTRL.LINE_STATUS NOT IN (5,6)