eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MINMAX_PVT dependencies on OE_ORDER_LINES_ALL

Line 1593: from oe_order_lines_all ool

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

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

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

Line 1702: from mtl_reservations mr, oe_order_lines_all ool

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

Line 1803: -- and source_document_line_id of oe_order_lines_all instead of

1799: -- This gives the total demand including the reserved
1800: -- and the unreserved material.
1801: --
1802: -- Bug 2820011. Modified the where clause to make use of source_document_id
1803: -- and source_document_line_id of oe_order_lines_all instead of
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

Line 1814: from oe_order_lines_all so,

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

Line 1872: from mtl_reservations md, oe_order_lines_all so,

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