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 1819: po_requisition_lines_all pol

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

Line 1877: po_requisition_lines_all pol

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