DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_TRANSACTION_TYPES

Line 1795: MTL_TRANSACTION_TYPES MTT

1791:
1792: SELECT SUM(MTRL.QUANTITY - NVL(MTRL.QUANTITY_DELIVERED,0))
1793: INTO qty
1794: FROM MTL_TXN_REQUEST_LINES MTRL,
1795: MTL_TRANSACTION_TYPES MTT
1796: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
1797: AND MTRL.ORGANIZATION_ID = p_organization_id
1798: AND MTRL.INVENTORY_ITEM_ID = p_inventory_item_id
1799: AND MTRL.LINE_STATUS NOT IN (5,6)