APPS.PO_CHANGEORDERWF_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 627: from po_line_locations_all

623: from po_headers_all
624: where po_header_id = p_can_hdr_id;
625: else
626: select cancel_flag into l_cancel_flag
627: from po_line_locations_all
628: where line_location_id = p_can_line_loc_id;
629: end if;
630: update po_headers_all
631: set authorization_status = 'IN PROCESS'

Line 640: from po_line_locations_all

636: from po_releases_all
637: where po_release_id = p_can_rel_id;
638: else
639: select cancel_flag into l_cancel_flag
640: from po_line_locations_all
641: where line_location_id = p_can_line_loc_id;
642: end if;
643:
644: update po_releases_all

Line 7497: update po_line_locations_all

7493: -- Bug 3771964
7494:
7495: if (l_rej_id is not null) then
7496: if (p_release_id is null) then
7497: update po_line_locations_all
7498: set approved_flag = 'Y'
7499: where po_header_id=p_header_id
7500: and po_release_id is null;
7501: else

Line 7502: update po_line_locations_all

7498: set approved_flag = 'Y'
7499: where po_header_id=p_header_id
7500: and po_release_id is null;
7501: else
7502: update po_line_locations_all
7503: set approved_flag = 'Y'
7504: where po_header_id=p_header_id
7505: and po_release_id = p_release_id;
7506: end if;

Line 7605: po_line_locations_all pll

7601: select pda.deliver_to_person_id
7602: from
7603: po_change_requests pcr,
7604: po_distributions_all pda,
7605: po_line_locations_all pll
7606: where pcr.change_request_group_id = grp_id
7607: and pcr.request_level = 'LINE'
7608: and pcr.document_line_id = pda.po_line_id
7609: and pda.line_location_id = pll.line_location_id

Line 7796: po_line_locations_all poll

7792: select distinct porh.requisition_header_id
7793: from po_requisition_headers_all porh,
7794: po_requisition_lines_all porl,
7795: po_headers_all poh,
7796: po_line_locations_all poll
7797: where porh.requisition_header_id = porl.requisition_header_id AND
7798: porl.line_location_id = poll.line_location_id AND
7799: poh.po_header_id = poll.po_header_id AND
7800: poh.po_header_id = p_po_header_id_csr;

Line 8372: po_line_locations_all polla

8368: IS
8369: CURSOR getReqHdrId(c_po_header_id in NUMBER) IS
8370: select distinct(porla.requisition_header_id)
8371: from po_requisition_lines_all porla,
8372: po_line_locations_all polla
8373: where polla.po_header_id = c_po_header_id
8374: and porla.line_location_id = polla.line_location_id;
8375:
8376: CURSOR getReqNum(c_req_header_id in NUMBER) IS

Line 8385: po_line_locations_all polla

8381: -- for releases
8382: CURSOR getReqHdrId_rel(c_po_header_id in NUMBER, c_po_release_id in NUMBER) IS
8383: select distinct(porla.requisition_header_id)
8384: from po_requisition_lines_all porla,
8385: po_line_locations_all polla
8386: where polla.po_header_id = c_po_header_id
8387: and polla.po_release_id = c_po_release_id
8388: and porla.line_location_id = polla.line_location_id;
8389:

Line 8491: FROM po_line_locations_all poll1,

8487: INTO l_ship_invalid_for_ctrl_actn
8488: FROM DUAL
8489: WHERE EXISTS(
8490: SELECT 1
8491: FROM po_line_locations_all poll1,
8492: po_line_locations_all poll2
8493: WHERE poll1.line_location_id = po_line_location_id
8494: AND poll1.po_line_id = poll2.po_line_id
8495: AND NVL(poll2.cancel_flag,'N') <> 'Y'

Line 8492: po_line_locations_all poll2

8488: FROM DUAL
8489: WHERE EXISTS(
8490: SELECT 1
8491: FROM po_line_locations_all poll1,
8492: po_line_locations_all poll2
8493: WHERE poll1.line_location_id = po_line_location_id
8494: AND poll1.po_line_id = poll2.po_line_id
8495: AND NVL(poll2.cancel_flag,'N') <> 'Y'
8496: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --