DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on OE_ORDER_LINES_ALL

Line 1596: from oe_order_lines_all ool

1592: , ool.line_id),
1593: 0)
1594: )
1595: into l_total_demand_qty, l_staged_qty, l_pick_released_qty
1596: from oe_order_lines_all ool
1597: where ship_from_org_id = p_org_id
1598: and open_flag = 'Y'
1599: AND visible_demand_flag = 'Y'
1600: AND shipped_quantity is null

Line 1635: -- demand from oe_order_lines_all (above) we only need to query

1631: --
1632: -- Find out the reserved qty for the material from mtl_reservations
1633: --
1634: -- Since total demand = reserved + unreserved, and we know total
1635: -- demand from oe_order_lines_all (above) we only need to query
1636: -- mtl_reservations if the user wants one of the following:
1637: --
1638: -- 1) Only reserved: (p_net_rsv = 1 and p_net_unrsv = 2)
1639: --

Line 1705: from mtl_reservations mr, oe_order_lines_all ool

1701: --
1702: IF (p_level = 2 and (p_net_rsv = 1 or p_net_unrsv = 1)) THEN
1703:
1704: select sum(mr.PRIMARY_RESERVATION_QUANTITY) into l_sub_reserve_qty
1705: from mtl_reservations mr, oe_order_lines_all ool
1706: where mr.organization_id = p_org_id
1707: AND mr.inventory_item_id = p_item_id
1708: AND mr.demand_source_line_id = ool.line_id
1709: AND mr.demand_source_type_id in (2,8,12)

Line 1806: -- and source_document_line_id of oe_order_lines_all instead of

1802: -- This gives the total demand including the reserved
1803: -- and the unreserved material.
1804: --
1805: -- Bug 2820011. Modified the where clause to make use of source_document_id
1806: -- and source_document_line_id of oe_order_lines_all instead of
1807: -- orig_sys_document_ref and orig_sys_line_ref to identify requisitions
1808: -- and requisition lines uniquely.
1809:
1810: if p_net_unrsv = 1 then

Line 1817: from oe_order_lines_all so,

1813: , ORDER_QUANTITY_UOM
1814: , NVL(ordered_quantity,0)) -
1815: get_shipped_qty(p_org_id, p_item_id, so.line_id))
1816: into l_total_demand_qty
1817: from oe_order_lines_all so,
1818: -- po_requisition_headers_all poh,
1819: po_requisition_lines_all pol
1820: where so.SOURCE_DOCUMENT_ID = pol.requisition_header_id
1821: -- and poh.requisition_header_id = pol.requisition_header_id

Line 1875: from mtl_reservations md, oe_order_lines_all so,

1871: -- Include the reserved demand from mtl_reservations
1872: --
1873: select sum(PRIMARY_RESERVATION_QUANTITY)
1874: into l_total_reserve_qty
1875: from mtl_reservations md, oe_order_lines_all so,
1876: -- po_req_distributions_all pod, Bug 5934651
1877: po_requisition_lines_all pol
1878: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1879: -- and to_number(so.ORIG_SYS_LINE_REF) = pod.DISTRIBUTION_ID --Bug#2883172