DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_LINES_ALL

Line 3024: FROM po_lines_all

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

Line 3291: ,po_lines_all pl

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. */

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: AND pl.item_id is not null; -- Bug # 12996777
3352:

Line 3368: FROM po_lines_all --

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 --
3369: WHERE po_line_id = v_po_line_id;
3370:
3371:
3372: --

Line 3386: FROM po_line_locations_all pll, po_lines_all pl --

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 --
3387: WHERE pl.po_line_id = v_po_line_id
3388: AND pl.po_line_id = pll.po_line_id;
3389:
3390: --

Line 3414: FROM po_line_locations_all pll, po_lines_all pl--

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--
3415: WHERE pll.line_location_id = v_po_line_location_id AND
3416: pl.po_line_id = pll.po_line_id;
3417:
3418: --