eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on OE_ORDER_LINES_ALL

Line 3139: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

3135: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3136:
3137: l_org_id NUMBER;
3138:
3139: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3140: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3141: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3142: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3143: l_line_rec_open_flag VARCHAR2(1);

Line 3140: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;

3136:
3137: l_org_id NUMBER;
3138:
3139: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3140: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3141: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3142: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3143: l_line_rec_open_flag VARCHAR2(1);
3144:

Line 3141: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;

3137: l_org_id NUMBER;
3138:
3139: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3140: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3141: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3142: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3143: l_line_rec_open_flag VARCHAR2(1);
3144:
3145: l_ordered_quantity_rsv_uom NUMBER := 0;

Line 3142: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;

3138:
3139: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3140: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3141: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3142: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3143: l_line_rec_open_flag VARCHAR2(1);
3144:
3145: l_ordered_quantity_rsv_uom NUMBER := 0;
3146: l_primary_uom_code VARCHAR2(3);

Line 3183: FROM oe_order_lines_all

3179: l_line_rec_open_flag,
3180: l_source_type_code,
3181: l_flow_status_code,
3182: l_booked_flag
3183: FROM oe_order_lines_all
3184: WHERE line_id = p_demand_line_id ;
3185:
3186: -- Bug 2366024 -- Do not perform the reservation check
3187: -- for drop ship orders - source_type_code = 'EXTERNAL'