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 PO_REQUISITION_LINES_ALL

Line 1639: po_requisition_lines_all pol

1635: get_shipped_qty(p_organization_id,p_inventory_item_id, so.line_id))
1636: into l_total_demand_qty
1637: from oe_order_lines_all so,
1638: po_requisition_headers_all poh,
1639: po_requisition_lines_all pol
1640: where so.ORIG_SYS_DOCUMENT_REF = poh.segment1
1641: and poh.requisition_header_id = pol .requisition_header_id
1642: and so.orig_sys_line_ref = pol.line_num
1643: and ( pol.DESTINATION_ORGANIZATION_ID <> p_organization_id or

Line 1671: po_requisition_lines_all pol

1667: select sum(PRIMARY_RESERVATION_QUANTITY)
1668: into l_total_reserve_qty
1669: from mtl_reservations md, oe_order_lines_all so,
1670: po_req_distributions_all pod,
1671: po_requisition_lines_all pol
1672: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1673: and so.ORIG_SYS_LINE_REF = pod.DISTRIBUTION_ID
1674: and pod.REQUISITION_LINE_ID = pol.REQUISITION_LINE_ID
1675: and (pol.DESTINATION_ORGANIZATION_ID <> p_organization_id or