[Home] [Help]
1182: AND mtrl.line_status NOT IN (5,6)
1183: AND mtrl.date_required <= p_s_cutoff;*/
1184:
1185: /*4518296*/
1186: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
1187: ,p_item_id
1188: , mtrl.uom_code
1189: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1190: ),0)
1568: -- Bug 3480523, from patch I onwards schedule_ship_date is being populated
1569: -- with time component, hence truncating it to get the same day demand. These
1570: -- changes are also in mtl_reservation queries.
1571: if p_net_unrsv = 1 then
1572: select SUM(inv_decimals_pub.get_primary_quantity( ship_from_org_id
1573: , inventory_item_id
1574: , order_quantity_uom
1575: , NVL(ordered_quantity,0)) -
1576: get_shipped_qty(p_org_id, p_item_id, ool.line_id)),
1804: -- orig_sys_document_ref and orig_sys_line_ref to identify requisitions
1805: -- and requisition lines uniquely.
1806:
1807: if p_net_unrsv = 1 then
1808: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( SHIP_FROM_ORG_ID
1809: , INVENTORY_ITEM_ID
1810: , ORDER_QUANTITY_UOM
1811: , NVL(ordered_quantity,0)) -
1812: get_shipped_qty(p_org_id, p_item_id, so.line_id))
2150: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
2151: 1,S.AVAILABILITY_TYPE,1)))
2152: AND MTRL.DATE_REQUIRED <= p_d_cutoff;*/
2153:
2154: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
2155: ,p_item_id
2156: , mtrl.uom_code
2157: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2158: ),0)
2223: AND mtrl.from_subinventory_code = p_subinv
2224: AND mtrl.line_status NOT IN (5,6)
2225: AND mtrl.date_required <= p_d_cutoff;*/
2226:
2227: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
2228: ,p_item_id
2229: ,mtrl.uom_code
2230: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2231: ),0)