DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1194: FROM po_requisition_lines_all prl

1190: )
1191: )
1192: AND (sup.req_line_id IS NULL
1193: OR EXISTS (SELECT ''x''
1194: FROM po_requisition_lines_all prl
1195: WHERE prl.requisition_line_id = sup.req_line_id
1196: AND NVL(prl.vmi_flag,''N'') = ''N''
1197: )
1198: )';

Line 1700: po_requisition_lines_all pol

1696: get_shipped_qty(p_org_id, p_item_id, so.line_id))
1697: into l_total_demand_qty
1698: from oe_order_lines_all so,
1699: -- po_requisition_headers_all poh,
1700: po_requisition_lines_all pol
1701: where so.SOURCE_DOCUMENT_ID = pol.requisition_header_id
1702: -- and poh.requisition_header_id = pol.requisition_header_id
1703: and so.source_document_line_id = pol.requisition_line_id
1704: and (pol.DESTINATION_ORGANIZATION_ID <> p_org_id or

Line 1744: po_requisition_lines_all pol

1740: select sum(PRIMARY_RESERVATION_QUANTITY)
1741: into l_total_reserve_qty
1742: from mtl_reservations md, oe_order_lines_all so,
1743: po_req_distributions_all pod,
1744: po_requisition_lines_all pol
1745: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1746: and so.ORIG_SYS_LINE_REF = to_char(pod.DISTRIBUTION_ID)
1747: and pod.REQUISITION_LINE_ID = pol.REQUISITION_LINE_ID
1748: and (pol.DESTINATION_ORGANIZATION_ID <> p_org_id or