[Home] [Help]
1562: , ool.line_id),
1563: 0)
1564: )
1565: into l_total_demand_qty, l_staged_qty, l_pick_released_qty
1566: from oe_order_lines_all ool
1567: where ship_from_org_id = p_org_id
1568: and open_flag = 'Y'
1569: AND visible_demand_flag = 'Y'
1570: AND shipped_quantity is null
1600: --
1601: -- Find out the reserved qty for the material from mtl_reservations
1602: --
1603: -- Since total demand = reserved + unreserved, and we know total
1604: -- demand from oe_order_lines_all (above) we only need to query
1605: -- mtl_reservations if the user wants one of the following:
1606: --
1607: -- 1) Only reserved: (p_net_rsv = 1 and p_net_unrsv = 2)
1608: --
1683: -- This gives the total demand including the reserved
1684: -- and the unreserved material.
1685: --
1686: -- Bug 2820011. Modified the where clause to make use of source_document_id
1687: -- and source_document_line_id of oe_order_lines_all instead of
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
1694: , ORDER_QUANTITY_UOM
1695: , NVL(ordered_quantity,0)) -
1696: get_shipped_qty(p_org_id, p_item_id, so.line_id))
1697: into l_total_demand_qty
1698: from oe_order_lines_all so,
1699: -- po_requisition_headers_all poh,
1700: po_requisition_lines_all pol
1701: where so.SOURCE_DOCUMENT_ID = pol.requisition_header_id
1702: -- and poh.requisition_header_id = pol.requisition_header_id
1738: -- Include the reserved demand from mtl_reservations
1739: --
1740: select sum(PRIMARY_RESERVATION_QUANTITY)
1741: into l_total_reserve_qty
1742: from mtl_reservations md, oe_order_lines_all so,
1743: po_req_distributions_all pod,
1744: po_requisition_lines_all pol
1745: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1746: and so.ORIG_SYS_LINE_REF = to_char(pod.DISTRIBUTION_ID)