APPS.INV_MINMAX_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1101: FROM po_requisition_lines_all prl

1097: )
1098: )
1099: AND (sup.req_line_id IS NULL
1100: OR EXISTS (SELECT ''x''
1101: FROM po_requisition_lines_all prl
1102: WHERE prl.requisition_line_id = sup.req_line_id
1103: AND NVL(prl.vmi_flag,''N'') = ''N''
1104: )
1105: )';

Line 1816: po_requisition_lines_all pol

1812: get_shipped_qty(p_org_id, p_item_id, so.line_id))
1813: into l_total_demand_qty
1814: from oe_order_lines_all so,
1815: -- po_requisition_headers_all poh,
1816: po_requisition_lines_all pol
1817: where so.SOURCE_DOCUMENT_ID = pol.requisition_header_id
1818: -- and poh.requisition_header_id = pol.requisition_header_id
1819: and so.source_document_line_id = pol.requisition_line_id
1820: and (pol.DESTINATION_ORGANIZATION_ID <> p_org_id or

Line 1874: po_requisition_lines_all pol

1870: select sum(PRIMARY_RESERVATION_QUANTITY)
1871: into l_total_reserve_qty
1872: from mtl_reservations md, oe_order_lines_all so,
1873: -- po_req_distributions_all pod, Bug 5934651
1874: po_requisition_lines_all pol
1875: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1876: -- and to_number(so.ORIG_SYS_LINE_REF) = pod.DISTRIBUTION_ID --Bug#2883172
1877: and so.SOURCE_DOCUMENT_ID = pol.requisition_header_id -- Bug 5934651
1878: and so.source_document_line_id = pol.requisition_line_id