DBA Data[Home] [Help]

APPS.INV_RESERVATION_FORM_PKG dependencies on OE_ORDER_LINES_ALL

Line 1572: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

1568: l_reserved_quantity NUMBER := 0;
1569: l_ship_tolerance_above NUMBER; -- INVCONV
1570:
1571: l_org_id NUMBER;
1572: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1573: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1574: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1575: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1576: -- R12 Project : SU

Line 1573: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;

1569: l_ship_tolerance_above NUMBER; -- INVCONV
1570:
1571: l_org_id NUMBER;
1572: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1573: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1574: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1575: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1576: -- R12 Project : SU
1577: lx_Qty_Available Number;

Line 1574: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;

1570:
1571: l_org_id NUMBER;
1572: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1573: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1574: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1575: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1576: -- R12 Project : SU
1577: lx_Qty_Available Number;
1578:

Line 1575: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;

1571: l_org_id NUMBER;
1572: l_line_rec_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
1573: l_line_rec_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE;
1574: l_line_rec_order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE;
1575: l_line_rec_org_id oe_order_lines_all.org_id%TYPE;
1576: -- R12 Project : SU
1577: lx_Qty_Available Number;
1578:
1579: lx_Qty_Available2 Number;

Line 1624: FROM oe_order_lines_all

1620: l_line_rec_ordered_quantity,
1621: l_line_rec_order_quantity_uom,
1622: l_line_rec_org_id,
1623: l_ship_tolerance_above
1624: FROM oe_order_lines_all
1625: WHERE line_id = p_demand_line_id ;
1626: --AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0) ;
1627:
1628: -- Convert order quantity into reservation uom code