eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_TXN_REQUEST_LINES_V

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