APPS.PO_COPY_DOCUMENTS_S dependencies on PO_LINE_LOCATIONS

Line 918: FROM po_line_locations pl

914: x_to_po_header_id number;
915:
916: CURSOR shipments_cursor(x_get_po_line_id number) IS
917: SELECT line_location_id
918: FROM po_line_locations pl
919: WHERE pl.po_line_id = x_get_po_line_id
920: ORDER BY pl.line_location_id;
921:
922: BEGIN

Line 940: select po_line_locations_s.nextval, pol.po_header_id

936: --dbms_output.put_line('progress cs 4');
937: x_progress:= '004';
938:
939: /* get the new line loc id, and the original po_header_id */
940: select po_line_locations_s.nextval, pol.po_header_id
941: into x_to_po_line_location_id, x_to_po_header_id
942: from po_lines pol
943: where pol.po_line_id = x_to_po_line_id;
944:

Line 956: insert into po_line_locations(

952: otherwise if tax code is defined for the new supplier it will consider the
953: default tax_code of new supplier.
954: */
955:
956: insert into po_line_locations(
957: LINE_LOCATION_ID
958: ,LAST_UPDATE_DATE
959: ,LAST_UPDATED_BY
960: ,PO_HEADER_ID

Line 1155: from po_line_locations

1151: --added note to receiver
1152: note_to_receiver
1153: ,outsourced_assembly /* Bug 6675806. Missing in R12 SHIKYU Transition.*/
1154:
1155: from po_line_locations
1156: where line_location_id = x_from_po_line_location_id;
1157:
1158: --dbms_output.put_line('progress cs 006');
1159: IF(x_copy_attachments = 'Y') THEN