APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_LINES_ALL

Line 3038: FROM po_lines_all

3034: SELECT item_id
3035: , unit_meas_lookup_code
3036: INTO l_item_id
3037: , l_po_uom
3038: FROM po_lines_all
3039: WHERE po_line_id= p_po_line_id;
3040:
3041: SELECT unit_of_measure
3042: INTO l_primary_meas

Line 3293: ,po_lines_all pl

3289: ,pll.line_location_id
3290: ,pll.ship_to_organization_id
3291: ,pl.item_id
3292: FROM po_line_locations_all pll
3293: ,po_lines_all pl
3294: WHERE pll.po_header_id = v_po_header_id
3295: AND pl.po_line_id = pll.po_line_id;
3296:
3297:

Line 3348: ,po_lines_all pl

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:
3352: --

Line 3367: FROM po_lines_all --

3363: --when po line is cancelled the reservations needs to be transferred back to the req or deleted
3364: --
3365: CURSOR get_po_header_id_line(v_po_line_id IN NUMBER) IS
3366: SELECT po_header_id
3367: FROM po_lines_all --
3368: WHERE po_line_id = v_po_line_id;
3369:
3370:
3371: --

Line 3385: FROM po_line_locations_all pll, po_lines_all pl --

3381: , pll.line_location_id
3382: , pll.ship_to_organization_id
3383: , pl.item_id
3384: , pll.quantity
3385: FROM po_line_locations_all pll, po_lines_all pl --
3386: WHERE pl.po_line_id = v_po_line_id
3387: AND pl.po_line_id = pll.po_line_id;
3388:
3389: --

Line 3413: FROM po_line_locations_all pll, po_lines_all pl--

3409: , pll.line_location_id
3410: , pll.ship_to_organization_id
3411: , pl.item_id
3412: , pll.quantity
3413: FROM po_line_locations_all pll, po_lines_all pl--
3414: WHERE pll.line_location_id = v_po_line_location_id AND
3415: pl.po_line_id = pll.po_line_id;
3416:
3417: --