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 1774: FROM mtl_txn_request_lines_v

1770: -- select only the issue from stores for org level planning
1771: -- Also select those lines for the sub level planning.
1772: /* SELECT sum(quantity - Nvl(quantity_delivered,0))
1773: INTO qty
1774: FROM mtl_txn_request_lines_v
1775: WHERE organization_id = p_organization_id
1776: AND inventory_item_id = p_inventory_item_id
1777: AND line_status NOT IN (5,6)
1778: AND transaction_action_id = 1

Line 1820: FROM mtl_txn_request_lines_v

1816: -- Include the sub transfer and the staging transfer move orders
1817: -- for sub level planning
1818: SELECT sum(quantity - Nvl(quantity_delivered,0))
1819: INTO qty
1820: FROM mtl_txn_request_lines_v
1821: WHERE organization_id = p_organization_id
1822: AND inventory_item_id = p_inventory_item_id
1823: AND line_status NOT IN (5,6)
1824: AND transaction_action_id IN (2,28)