APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1455: from po_line_locations_archive_all

1451: and poh.po_header_id=pol.from_header_id) ;
1452:
1453: cursor ga_ship_csr(p_line_id in number) is
1454: select line_location_id,quantity
1455: from po_line_locations_archive_all
1456: where po_line_id = p_line_id and
1457: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and
1458: nvl(cancel_flag,'N') <> 'Y' and
1459: latest_external_flag='Y' ;

Line 1654: from po_line_locations_archive_all

1650: -- Get the price break for the total quantity for each line using the min shipment
1651: -- need by date and ship to org
1652: select ship_to_location_id, ship_to_organization_id,need_by_date
1653: into l_shipToLoc,l_shipToOrg,l_needBydate
1654: from po_line_locations_archive_all
1655: where shipment_num = (select min(shipment_num)
1656: from po_line_locations_archive_all
1657: where po_line_id = l_ga_lineId and
1658: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and

Line 1656: from po_line_locations_archive_all

1652: select ship_to_location_id, ship_to_organization_id,need_by_date
1653: into l_shipToLoc,l_shipToOrg,l_needBydate
1654: from po_line_locations_archive_all
1655: where shipment_num = (select min(shipment_num)
1656: from po_line_locations_archive_all
1657: where po_line_id = l_ga_lineId and
1658: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and
1659: nvl(cancel_flag,'N') <> 'Y' and
1660: latest_external_flag='Y' ) and