APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1574: from po_line_locations_archive_all poll

1570: from po_headers_all poh
1571: where poh.global_agreement_flag='Y'
1572: and poh.po_header_id=pol.from_header_id) and
1573: exists(select poll.line_location_id
1574: from po_line_locations_archive_all poll
1575: where poll.po_line_id = pol.po_line_id and
1576: nvl(poll.closed_code,'OPEN') not in('FINALLY CLOSED') and
1577: nvl(poll.cancel_flag,'N') <> 'Y' and
1578: poll.latest_external_flag='Y');

Line 1582: from po_line_locations_archive_all

1578: poll.latest_external_flag='Y');
1579:
1580: cursor ga_ship_csr(p_line_id in number) is
1581: select line_location_id,quantity
1582: from po_line_locations_archive_all
1583: where po_line_id = p_line_id and
1584: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and
1585: nvl(cancel_flag,'N') <> 'Y' and
1586: latest_external_flag='Y' ;

Line 1801: from po_line_locations_archive_all

1797: -- Get the price break for the total quantity for each line using the min shipment
1798: -- need by date and ship to org
1799: select ship_to_location_id, ship_to_organization_id,need_by_date
1800: into l_shipToLoc,l_shipToOrg,l_needBydate
1801: from po_line_locations_archive_all
1802: where shipment_num = (select min(shipment_num)
1803: from po_line_locations_archive_all
1804: where po_line_id = l_ga_lineId and
1805: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and

Line 1803: from po_line_locations_archive_all

1799: select ship_to_location_id, ship_to_organization_id,need_by_date
1800: into l_shipToLoc,l_shipToOrg,l_needBydate
1801: from po_line_locations_archive_all
1802: where shipment_num = (select min(shipment_num)
1803: from po_line_locations_archive_all
1804: where po_line_id = l_ga_lineId and
1805: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and
1806: nvl(cancel_flag,'N') <> 'Y' and
1807: latest_external_flag='Y' ) and