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.CSP_EXCESS_PARTS_PVT dependencies on MTL_RESERVATIONS

Line 1647: -- select the reserved quantity from mtl_reservations for non OE rows

1643:
1644: total := total + nvl(qty,0);
1645:
1646:
1647: -- select the reserved quantity from mtl_reservations for non OE rows
1648: select sum(PRIMARY_RESERVATION_QUANTITY)
1649: into qty
1650: from mtl_reservations
1651: where p_net_reserved = 1

Line 1650: from mtl_reservations

1646:
1647: -- select the reserved quantity from mtl_reservations for non OE rows
1648: select sum(PRIMARY_RESERVATION_QUANTITY)
1649: into qty
1650: from mtl_reservations
1651: where p_net_reserved = 1
1652: and ORGANIZATION_ID = p_organization_id
1653: and INVENTORY_ITEM_ID = p_inventory_item_id
1654: and REQUIREMENT_DATE <= sysdate + p_demand_cutoff

Line 1702: -- find out the reserved qty for the material from mtl_reservations

1698: 1)));
1699:
1700: end if;
1701:
1702: -- find out the reserved qty for the material from mtl_reservations
1703: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1704: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1705: select sum(PRIMARY_RESERVATION_QUANTITY)
1706: into l_total_reserve_qty

Line 1707: from mtl_reservations

1703: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1704: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1705: select sum(PRIMARY_RESERVATION_QUANTITY)
1706: into l_total_reserve_qty
1707: from mtl_reservations
1708: WHERE ORGANIZATION_ID = p_organization_id
1709: and INVENTORY_ITEM_ID = p_inventory_item_id
1710: and REQUIREMENT_DATE <= sysdate + p_demand_cutoff
1711: and demand_source_type_id in (2,8,12)

Line 1730: -- demand is simply the reservations from mtl_reservations for the matl.

1726: -- total demand is calculated as follows:
1727: -- if we have to consider both unreserved matl and reserved matl. then the
1728: -- demand is simply the total demand = ordered qty - shipped qty.
1729: -- elsif we have to take into account only reserved matl. then the
1730: -- demand is simply the reservations from mtl_reservations for the matl.
1731: -- elsif we have to take into account just the unreserved matl. then the
1732: -- demand is total demand - the reservations for the material.
1733: if p_net_unreserved = 1 and p_net_reserved = 1 then
1734: l_demand_qty := Nvl(l_total_demand_qty,0);

Line 1784: -- find out the reserved qty for the material from mtl_reservations

1780: S.availability_type,
1781: 1)));
1782: end if;
1783:
1784: -- find out the reserved qty for the material from mtl_reservations
1785: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1786: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1787: -- Include the reserved demand from mtl_reservations
1788: select sum(PRIMARY_RESERVATION_QUANTITY)

Line 1787: -- Include the reserved demand from mtl_reservations

1783:
1784: -- find out the reserved qty for the material from mtl_reservations
1785: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1786: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1787: -- Include the reserved demand from mtl_reservations
1788: select sum(PRIMARY_RESERVATION_QUANTITY)
1789: into l_total_reserve_qty
1790: from mtl_reservations md, oe_order_lines_all so,
1791: po_req_distributions_all pod,

Line 1790: from mtl_reservations md, oe_order_lines_all so,

1786: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1787: -- Include the reserved demand from mtl_reservations
1788: select sum(PRIMARY_RESERVATION_QUANTITY)
1789: into l_total_reserve_qty
1790: from mtl_reservations md, oe_order_lines_all so,
1791: po_req_distributions_all pod,
1792: po_requisition_lines_all pol
1793: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1794: and so.ORIG_SYS_LINE_REF = pod.DISTRIBUTION_ID

Line 1821: -- demand is simply the reservations from mtl_reservations for the matl.

1817: -- total demand is calculated as follows:
1818: -- if we have to consider both unreserved matl and reserved matl. then the
1819: -- demand is simply the total demand = ordered qty - shipped qty.
1820: -- elsif we have to take into account only reserved matl. then the
1821: -- demand is simply the reservations from mtl_reservations for the matl.
1822: -- elsif we have to take into account just the unreserved matl. then the
1823: -- demand is total demand - the reservations for the material.
1824: if p_net_unreserved = 1 and p_net_reserved = 1 then
1825: l_demand_qty := Nvl(l_total_demand_qty,0);