APPS.AP_APXTRSWP_XMLP_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 548: FROM PO_LINE_LOCATIONS_ALL PLL,

544:
545: CURSOR PO_LIST IS
546: SELECT DISTINCT PLL.LINE_LOCATION_ID,
547: PLL.CLOSED_DATE
548: FROM PO_LINE_LOCATIONS_ALL PLL,
549: PO_DISTRIBUTIONS_ALL PD,
550: AP_INVOICE_DISTRIBUTIONS_ALL AID
551: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
552: AND PLL.CLOSED_DATE IS NOT NULL

Line 603: update po_line_locations_all

599:
600: if (l_ship_close_date is not null and
601: l_ship_close_date < c_sweep_to_date) then
602:
603: update po_line_locations_all
604: set closed_date = c_sweep_to_date
605: where line_location_id = l_line_loc_id;
606:
607: select distinct POH.po_header_id,

Line 612: po_line_locations_all PLL

608: POH.closed_date
609: into l_header_id,
610: l_header_close_date
611: from po_headers_all POH,
612: po_line_locations_all PLL
613: where POH.po_header_id = PLL.po_header_id
614: and PLL.line_location_id = l_line_loc_id;
615:
616: if (l_header_close_date is not null and