APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 3290: FROM po_line_locations_all pll

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

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

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

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

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