APPS.PO_SUPPLY dependencies on PO_REQUISITION_LINES_CLM_V

Line 386: from po_requisition_lines_clm_v

382: END IF;
383:
384: select requisition_header_id
385: into l_doc_id
386: from po_requisition_lines_clm_v
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_clm_v 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_clm_v 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_clm_v 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_clm_v 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 2325: FROM po_requisition_lines_clm_v porl

2321: AND ms.req_header_id = p_docid
2322: AND EXISTS
2323: (
2324: SELECT 1
2325: FROM po_requisition_lines_clm_v porl
2326: WHERE porl.source_type_code = 'VENDOR'
2327: AND porl.requisition_line_id = ms.req_line_id
2328: AND porl.line_location_id is null--Bug 13518969
2329: );

Line 2406: FROM po_requisition_lines_clm_v pl

2402: DELETE FROM mtl_supply ms1
2403: WHERE ms1.supply_source_id IN
2404: (
2405: SELECT pl.requisition_line_id
2406: FROM po_requisition_lines_clm_v pl
2407: WHERE pl.requisition_header_id = p_entity_id
2408: AND NVL(pl.modified_by_agent_flag, 'N') <> 'Y'
2409: AND NVL(pl.closed_code, 'OPEN') = 'OPEN'
2410: AND NVL(pl.cancel_flag, 'N') = 'N'

Line 2472: FROM po_requisition_lines_clm_v prl

2468: prl.source_subinventory,
2469: prl.destination_organization_id,
2470: prl.destination_subinventory,
2471: 'Y'
2472: FROM po_requisition_lines_clm_v prl
2473: WHERE prl.requisition_header_id = p_entity_id
2474: AND nvl(prl.modified_by_agent_flag,'N') <> 'Y'
2475: AND nvl(prl.CLOSED_CODE,'OPEN') = 'OPEN'
2476: AND nvl(prl.CANCEL_FLAG, 'N') = 'N'

Line 2551: FROM po_requisition_lines_clm_v prl

2547: prl.source_subinventory,
2548: prl.destination_organization_id,
2549: prl.destination_subinventory,
2550: 'Y'
2551: FROM po_requisition_lines_clm_v prl
2552: WHERE prl.requisition_line_id = p_entity_id
2553: AND nvl(prl.modified_by_agent_flag,'N') <> 'Y'
2554: AND nvl(prl.CLOSED_CODE, 'OPEN') = 'OPEN'
2555: AND nvl(prl.CANCEL_FLAG, 'N') = 'N'

Line 2693: from po_requisition_lines_clm_v prl

2689: prl.source_subinventory,
2690: prl.destination_organization_id,
2691: prl.destination_subinventory,
2692: 'Y'
2693: from po_requisition_lines_clm_v prl
2694: where prl.requisition_line_id in
2695: (select prl1.requisition_line_id
2696: from po_requisition_lines_clm_v prl1
2697: where prl1.requisition_header_id =

Line 2696: from po_requisition_lines_clm_v prl1

2692: 'Y'
2693: from po_requisition_lines_clm_v prl
2694: where prl.requisition_line_id in
2695: (select prl1.requisition_line_id
2696: from po_requisition_lines_clm_v prl1
2697: where prl1.requisition_header_id =
2698: (select prl2.requisition_header_id
2699: from po_requisition_lines_clm_v prl2
2700: where prl2.requisition_line_id = p_lineid

Line 2699: from po_requisition_lines_clm_v prl2

2695: (select prl1.requisition_line_id
2696: from po_requisition_lines_clm_v prl1
2697: where prl1.requisition_header_id =
2698: (select prl2.requisition_header_id
2699: from po_requisition_lines_clm_v prl2
2700: where prl2.requisition_line_id = p_lineid
2701: and prl2.modified_by_agent_flag = 'Y'))
2702: and nvl(prl.modified_by_agent_flag, 'N') <> 'Y'
2703: and nvl(prl.closed_code, 'OPEN') = 'OPEN'