[Home] [Help]
1269: AND mtrl.to_subinventory_code = p_subinv
1270: AND mtrl.line_status NOT IN (5,6)
1271: AND mtrl.date_required <= p_s_cutoff; */
1272:
1273: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
1274: ,p_item_id
1275: , mtrl.uom_code
1276: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1277: ),0)
1541: -- Bug 2350243: For sub level, calculate pick released
1542: -- (move order) qty
1543: --
1544: if p_net_unrsv = 1 then
1545: select SUM(inv_decimals_pub.get_primary_quantity( ship_from_org_id
1546: , inventory_item_id
1547: , order_quantity_uom
1548: , NVL(ordered_quantity,0)) -
1549: get_shipped_qty(p_org_id, p_item_id, ool.line_id)),
1688: -- orig_sys_document_ref and orig_sys_line_ref to identify requisitions
1689: -- and requisition lines uniquely.
1690:
1691: if p_net_unrsv = 1 then
1692: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( SHIP_FROM_ORG_ID
1693: , INVENTORY_ITEM_ID
1694: , ORDER_QUANTITY_UOM
1695: , NVL(ordered_quantity,0)) -
1696: get_shipped_qty(p_org_id, p_item_id, so.line_id))
1908: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
1909: 1,S.AVAILABILITY_TYPE,1)))
1910: AND MTRL.DATE_REQUIRED <= p_d_cutoff; */
1911:
1912: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
1913: ,p_item_id
1914: , mtrl.uom_code
1915: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1916: ),0)
1960: AND mtrl.from_subinventory_code = p_subinv
1961: AND mtrl.line_status NOT IN (5,6)
1962: AND mtrl.date_required <= p_d_cutoff;*/
1963:
1964: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
1965: ,p_item_id
1966: ,mtrl.uom_code
1967: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1968: ),0)