APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 3292: FROM po_line_locations_all pll

3288: ,pll.po_line_id
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:

Line 3347: FROM po_line_locations_all pll

3343: , pll.po_line_id
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:

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 3395: FROM po_line_locations_all --

3391: --to Check whether reservation exists for the PO
3392: --
3393: CURSOR get_po_header_id_shipment (v_po_line_location_id IN NUMBER)IS
3394: SELECT po_header_id
3395: FROM po_line_locations_all --
3396: WHERE line_location_id = p_line_location_id;
3397:
3398:
3399: --

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