APPS.PO_CHANGEORDERWF_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 557: from po_line_locations_all

553: from po_headers_all
554: where po_header_id = p_can_hdr_id;
555: else
556: select cancel_flag into l_cancel_flag
557: from po_line_locations_all
558: where line_location_id = p_can_line_loc_id;
559: end if;
560: update po_headers_all
561: set authorization_status = 'IN PROCESS'

Line 570: from po_line_locations_all

566: from po_releases_all
567: where po_release_id = p_can_rel_id;
568: else
569: select cancel_flag into l_cancel_flag
570: from po_line_locations_all
571: where line_location_id = p_can_line_loc_id;
572: end if;
573:
574: update po_releases_all

Line 7339: update po_line_locations_all

7335: -- Bug 3771964
7336:
7337: if (l_rej_id is not null) then
7338: if (p_release_id is null) then
7339: update po_line_locations_all
7340: set approved_flag = 'Y'
7341: where po_header_id=p_header_id
7342: and po_release_id is null;
7343: else

Line 7344: update po_line_locations_all

7340: set approved_flag = 'Y'
7341: where po_header_id=p_header_id
7342: and po_release_id is null;
7343: else
7344: update po_line_locations_all
7345: set approved_flag = 'Y'
7346: where po_header_id=p_header_id
7347: and po_release_id = p_release_id;
7348: end if;

Line 7447: po_line_locations_all pll

7443: select pda.deliver_to_person_id
7444: from
7445: po_change_requests pcr,
7446: po_distributions_all pda,
7447: po_line_locations_all pll
7448: where pcr.change_request_group_id = grp_id
7449: and pcr.request_level = 'LINE'
7450: and pcr.document_line_id = pda.po_line_id
7451: and pda.line_location_id = pll.line_location_id

Line 7638: po_line_locations_all poll

7634: select distinct porh.requisition_header_id
7635: from po_requisition_headers_all porh,
7636: po_requisition_lines_all porl,
7637: po_headers_all poh,
7638: po_line_locations_all poll
7639: where porh.requisition_header_id = porl.requisition_header_id AND
7640: porl.line_location_id = poll.line_location_id AND
7641: poh.po_header_id = poll.po_header_id AND
7642: poh.po_header_id = p_po_header_id_csr;

Line 8097: po_line_locations_all polla

8093: IS
8094: CURSOR getReqHdrId(c_po_header_id in NUMBER) IS
8095: select distinct(porla.requisition_header_id)
8096: from po_requisition_lines_all porla,
8097: po_line_locations_all polla
8098: where polla.po_header_id = c_po_header_id
8099: and porla.line_location_id = polla.line_location_id;
8100:
8101: CURSOR getReqNum(c_req_header_id in NUMBER) IS

Line 8110: po_line_locations_all polla

8106: -- for releases
8107: CURSOR getReqHdrId_rel(c_po_header_id in NUMBER, c_po_release_id in NUMBER) IS
8108: select distinct(porla.requisition_header_id)
8109: from po_requisition_lines_all porla,
8110: po_line_locations_all polla
8111: where polla.po_header_id = c_po_header_id
8112: and polla.po_release_id = c_po_release_id
8113: and porla.line_location_id = polla.line_location_id;
8114:

Line 8216: FROM po_line_locations_all poll1,

8212: INTO l_ship_invalid_for_ctrl_actn
8213: FROM DUAL
8214: WHERE EXISTS(
8215: SELECT 1
8216: FROM po_line_locations_all poll1,
8217: po_line_locations_all poll2
8218: WHERE poll1.line_location_id = po_line_location_id
8219: AND poll1.po_line_id = poll2.po_line_id
8220: AND NVL(poll2.cancel_flag,'N') <> 'Y'

Line 8217: po_line_locations_all poll2

8213: FROM DUAL
8214: WHERE EXISTS(
8215: SELECT 1
8216: FROM po_line_locations_all poll1,
8217: po_line_locations_all poll2
8218: WHERE poll1.line_location_id = po_line_location_id
8219: AND poll1.po_line_id = poll2.po_line_id
8220: AND NVL(poll2.cancel_flag,'N') <> 'Y'
8221: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --