APPS.POS_CREATE_ASN dependencies on PO_LINE_LOCATIONS_ALL

Line 143: from po_line_locations_all

139: x_progress := '015' ;
140:
141: select ship_to_location_id
142: into x_ship_to_location_id
143: from po_line_locations_all
144: where line_location_id = P_PO_LINE_LOCATION_ID_T;
145:
146: /* Insert into RHI only if a record for the same ship_to_org
147: and ship_to_location is not already inserted for the group id */

Line 686: FROM po_line_locations_all pll,

682: x_qty_rcv_tolerance,
683: x_qty_rcv_exception_code,
684: x_item_id,
685: x_po_uom
686: FROM po_line_locations_all pll,
687: po_lines_all pl
688: WHERE pll.line_location_id = p_line_location_id
689: AND pll.po_line_id = pl.po_line_id;
690:

Line 809: FROM po_line_locations_all pll,

805: SELECT pl.item_id,
806: pl.unit_meas_lookup_code
807: INTO x_item_id,
808: x_po_uom
809: FROM po_line_locations_all pll,
810: po_lines_all pl
811: WHERE pll.line_location_id = p_line_location_id
812: AND pll.po_line_id = pl.po_line_id;
813: