3020: SELECT item_id
3021: , unit_meas_lookup_code
3022: INTO l_item_id
3023: , l_po_uom
3024: FROM po_lines_all
3025: WHERE po_line_id= p_po_line_id;
3026:
3027: SELECT unit_of_measure
3028: INTO l_primary_meas
3287: ,pll.line_location_id
3288: ,pll.ship_to_organization_id
3289: ,pl.item_id
3290: FROM po_line_locations_all pll
3291: ,po_lines_all pl
3292: WHERE pll.po_header_id = v_po_header_id
3293: AND pl.po_line_id = pll.po_line_id
3294: AND pl.item_id IS NOT NULL; /* Bug 16236492 exclude PO line locations for expense/one time item
3295: as it has no reservation to check against. */
3344: , pll.line_location_id
3345: , pll.ship_to_organization_id --?? is it correct org_id ??
3346: , pl.item_id
3347: FROM po_line_locations_all pll
3348: ,po_lines_all pl
3349: WHERE pll.po_release_id = v_po_header_id
3350: AND pll.po_line_id = pl.po_line_id
3351: AND pl.item_id is not null; -- Bug # 12996777
3352:
3364: --when po line is cancelled the reservations needs to be transferred back to the req or deleted
3365: --
3366: CURSOR get_po_header_id_line(v_po_line_id IN NUMBER) IS
3367: SELECT po_header_id
3368: FROM po_lines_all --
3370:
3371:
3372: --
3382: , pll.line_location_id
3383: , pll.ship_to_organization_id
3384: , pl.item_id
3385: , pll.quantity
3386: FROM po_line_locations_all pll, po_lines_all pl --
3388: AND pl.po_line_id = pll.po_line_id;
3389:
3390: --
3410: , pll.line_location_id
3411: , pll.ship_to_organization_id
3412: , pl.item_id
3413: , pll.quantity
3414: FROM po_line_locations_all pll, po_lines_all pl--
3416: pl.po_line_id = pll.po_line_id;
3417:
3418: --