APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1895: FROM mtl_txn_request_lines_v

1891: -- select only the issue from stores for org level planning
1892: -- Also select those lines for the sub level planning.
1893: /* SELECT sum(quantity - Nvl(quantity_delivered,0))
1894: INTO qty
1895: FROM mtl_txn_request_lines_v
1896: WHERE organization_id = p_organization_id
1897: AND inventory_item_id = p_inventory_item_id
1898: AND line_status NOT IN (5,6)
1899: AND transaction_action_id = 1

Line 1915: FROM MTL_TXN_REQUEST_LINES MTRL,

1911: */
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

Line 1941: FROM mtl_txn_request_lines_v

1937: -- Include the sub transfer and the staging transfer move orders
1938: -- for sub level planning
1939: SELECT sum(quantity - Nvl(quantity_delivered,0))
1940: INTO qty
1941: FROM mtl_txn_request_lines_v
1942: WHERE organization_id = p_organization_id
1943: AND inventory_item_id = p_inventory_item_id
1944: AND line_status NOT IN (5,6)
1945: AND transaction_action_id IN (2,28)