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 3294: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

3290: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3291:
3292: l_org_id NUMBER;
3293:
3294: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3295: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3296: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3297: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3298: l_line_rec_open_flag VARCHAR2(1);

Line 3295: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;

3291:
3292: l_org_id NUMBER;
3293:
3294: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3295: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3296: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3297: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3298: l_line_rec_open_flag VARCHAR2(1);
3299:

Line 3296: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;

3292: l_org_id NUMBER;
3293:
3294: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3295: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3296: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3297: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3298: l_line_rec_open_flag VARCHAR2(1);
3299:
3300: l_ordered_quantity_rsv_uom NUMBER := 0;

Line 3297: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;

3293:
3294: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3295: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
3296: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
3297: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
3298: l_line_rec_open_flag VARCHAR2(1);
3299:
3300: l_ordered_quantity_rsv_uom NUMBER := 0;
3301: l_primary_uom_code VARCHAR2(3);

Line 3341: FROM oe_order_lines_all

3337: l_source_type_code,
3338: l_flow_status_code,
3339: l_booked_flag,
3340: l_order_header_id
3341: FROM oe_order_lines_all
3342: WHERE line_id = p_demand_line_id ;
3343:
3344: -- Bug 2366024 -- Do not perform the reservation check
3345: -- for drop ship orders - source_type_code = 'EXTERNAL'