1447: pl.item_id,
1448: pll.ship_to_organization_id,
1449: pll.consigned_flag
1450: FROM po_line_locations_all pll,
1451: po_lines_all pl
1452: WHERE pll.po_header_id = p_po_header_id
1453: AND pl.po_line_id = pll.po_line_id;
1454:
1455: BEGIN