APPS.PO_SUPPLY dependencies on PO_REQUISITION_LINES_ALL

Line 386: from po_requisition_lines_all

382: END IF;
383:
384: select requisition_header_id
385: into l_doc_id
386: from po_requisition_lines_all
387: where requisition_line_id = p_lineid;
388:
389: PO_RESERVATION_MAINTAIN_SV.MAINTAIN_RESERVATION(
390: p_header_id => p_docid

Line 556: FROM po_requisition_lines_all prl

552: WHERE ms.supply_type_code = 'REQ'
553: AND ms.supply_source_id IN
554: (
555: SELECT prl.requisition_line_id
556: FROM po_requisition_lines_all prl
557: , po_distributions_all pd
558: WHERE prl.line_location_id = pd.line_location_id
559: AND pd.po_header_id = p_docid
560: );

Line 676: FROM po_requisition_lines_all prl

672: WHERE ms.supply_type_code = 'REQ'
673: AND ms.supply_source_id IN
674: (
675: SELECT prl.requisition_line_id
676: FROM po_requisition_lines_all prl
677: , po_line_locations_all pll
678: WHERE prl.line_location_id = pll.line_location_id
679: AND pll.po_release_id = p_docid
680: );

Line 2153: FROM po_requisition_lines_all porl

2149: AND ms.req_header_id = p_docid
2150: AND EXISTS
2151: (
2152: SELECT 1
2153: FROM po_requisition_lines_all porl
2154: WHERE porl.source_type_code = 'VENDOR'
2155: AND porl.requisition_line_id = ms.req_line_id
2156: );
2157:

Line 2223: FROM po_requisition_lines_all pl

2219: DELETE FROM mtl_supply ms1
2220: WHERE ms1.supply_source_id IN
2221: (
2222: SELECT pl.requisition_line_id
2223: FROM po_requisition_lines_all pl
2224: WHERE pl.requisition_header_id = p_entity_id
2225: AND NVL(pl.modified_by_agent_flag, 'N') <> 'Y'
2226: AND NVL(pl.closed_code, 'OPEN') = 'OPEN'
2227: AND NVL(pl.cancel_flag, 'N') = 'N'

Line 2289: FROM po_requisition_lines_all prl

2285: prl.source_subinventory,
2286: prl.destination_organization_id,
2287: prl.destination_subinventory,
2288: 'Y'
2289: FROM po_requisition_lines_all prl
2290: WHERE prl.requisition_header_id = p_entity_id
2291: AND nvl(prl.modified_by_agent_flag,'N') <> 'Y'
2292: AND nvl(prl.CLOSED_CODE,'OPEN') = 'OPEN'
2293: AND nvl(prl.CANCEL_FLAG, 'N') = 'N'

Line 2354: FROM po_requisition_lines_all prl

2350: prl.source_subinventory,
2351: prl.destination_organization_id,
2352: prl.destination_subinventory,
2353: 'Y'
2354: FROM po_requisition_lines_all prl
2355: WHERE prl.requisition_line_id = p_entity_id
2356: AND nvl(prl.modified_by_agent_flag,'N') <> 'Y'
2357: AND nvl(prl.CLOSED_CODE, 'OPEN') = 'OPEN'
2358: AND nvl(prl.CANCEL_FLAG, 'N') = 'N'

Line 2495: from po_requisition_lines_all prl

2491: prl.source_subinventory,
2492: prl.destination_organization_id,
2493: prl.destination_subinventory,
2494: 'Y'
2495: from po_requisition_lines_all prl
2496: where prl.requisition_line_id in
2497: (select prl1.requisition_line_id
2498: from po_requisition_lines_all prl1
2499: where prl1.requisition_header_id =

Line 2498: from po_requisition_lines_all prl1

2494: 'Y'
2495: from po_requisition_lines_all prl
2496: where prl.requisition_line_id in
2497: (select prl1.requisition_line_id
2498: from po_requisition_lines_all prl1
2499: where prl1.requisition_header_id =
2500: (select prl2.requisition_header_id
2501: from po_requisition_lines_all prl2
2502: where prl2.requisition_line_id = p_lineid

Line 2501: from po_requisition_lines_all prl2

2497: (select prl1.requisition_line_id
2498: from po_requisition_lines_all prl1
2499: where prl1.requisition_header_id =
2500: (select prl2.requisition_header_id
2501: from po_requisition_lines_all prl2
2502: where prl2.requisition_line_id = p_lineid
2503: and prl2.modified_by_agent_flag = 'Y'))
2504: and nvl(prl.modified_by_agent_flag, 'N') <> 'Y'
2505: and nvl(prl.closed_code, 'OPEN') = 'OPEN'