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_FORM_PKG dependencies on OE_ORDER_LINES_ALL

Line 1557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

1553: l_reserved_quantity NUMBER := 0;
1554: l_ship_tolerance_above NUMBER; -- INVCONV
1555:
1556: l_org_id NUMBER;
1557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1561: -- R12 Project : SU

Line 1558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;

1554: l_ship_tolerance_above NUMBER; -- INVCONV
1555:
1556: l_org_id NUMBER;
1557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1561: -- R12 Project : SU
1562: lx_Qty_Available Number;

Line 1559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;

1555:
1556: l_org_id NUMBER;
1557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1561: -- R12 Project : SU
1562: lx_Qty_Available Number;
1563: BEGIN

Line 1560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;

1556: l_org_id NUMBER;
1557: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1558: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1559: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1560: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1561: -- R12 Project : SU
1562: lx_Qty_Available Number;
1563: BEGIN
1564: -- Initialize return status

Line 1606: FROM oe_order_lines_all

1602: l_line_rec_ordered_quantity,
1603: l_line_rec_order_quantity_uom,
1604: l_line_rec_org_id,
1605: l_ship_tolerance_above
1606: FROM oe_order_lines_all
1607: WHERE line_id = p_demand_line_id ;
1608: --AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0) ;
1609:
1610: -- Convert order quantity into reservation uom code