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 1526: -- select the reserved quantity from mtl_reservations for non OE rows

1522:
1523: total := total + nvl(qty,0);
1524:
1525:
1526: -- select the reserved quantity from mtl_reservations for non OE rows
1527: select sum(PRIMARY_RESERVATION_QUANTITY)
1528: into qty
1529: from mtl_reservations
1530: where p_net_reserved = 1

Line 1529: from mtl_reservations

1525:
1526: -- select the reserved quantity from mtl_reservations for non OE rows
1527: select sum(PRIMARY_RESERVATION_QUANTITY)
1528: into qty
1529: from mtl_reservations
1530: where p_net_reserved = 1
1531: and ORGANIZATION_ID = p_organization_id
1532: and INVENTORY_ITEM_ID = p_inventory_item_id
1533: and REQUIREMENT_DATE <= sysdate + p_demand_cutoff

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

1577: 1)));
1578:
1579: end if;
1580:
1581: -- find out the reserved qty for the material from mtl_reservations
1582: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1583: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1584: select sum(PRIMARY_RESERVATION_QUANTITY)
1585: into l_total_reserve_qty

Line 1586: from mtl_reservations

1582: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1583: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1584: select sum(PRIMARY_RESERVATION_QUANTITY)
1585: into l_total_reserve_qty
1586: from mtl_reservations
1587: WHERE ORGANIZATION_ID = p_organization_id
1588: and INVENTORY_ITEM_ID = p_inventory_item_id
1589: and REQUIREMENT_DATE <= sysdate + p_demand_cutoff
1590: and demand_source_type_id in (2,8,12)

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

1605: -- total demand is calculated as follows:
1606: -- if we have to consider both unreserved matl and reserved matl. then the
1607: -- demand is simply the total demand = ordered qty - shipped qty.
1608: -- elsif we have to take into account only reserved matl. then the
1609: -- demand is simply the reservations from mtl_reservations for the matl.
1610: -- elsif we have to take into account just the unreserved matl. then the
1611: -- demand is total demand - the reservations for the material.
1612: if p_net_unreserved = 1 and p_net_reserved = 1 then
1613: l_demand_qty := Nvl(l_total_demand_qty,0);

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

1659: S.availability_type,
1660: 1)));
1661: end if;
1662:
1663: -- find out the reserved qty for the material from mtl_reservations
1664: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1665: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1666: -- Include the reserved demand from mtl_reservations
1667: select sum(PRIMARY_RESERVATION_QUANTITY)

Line 1666: -- Include the reserved demand from mtl_reservations

1662:
1663: -- find out the reserved qty for the material from mtl_reservations
1664: if ((p_net_reserved = 1 or p_net_unreserved = 1) and
1665: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1666: -- Include the reserved demand from mtl_reservations
1667: select sum(PRIMARY_RESERVATION_QUANTITY)
1668: into l_total_reserve_qty
1669: from mtl_reservations md, oe_order_lines_all so,
1670: po_req_distributions_all pod,

Line 1669: from mtl_reservations md, oe_order_lines_all so,

1665: (nvl(p_net_reserved,0) <> 1 and nvl(p_net_unreserved,0) <> 1)) then
1666: -- Include the reserved demand from mtl_reservations
1667: select sum(PRIMARY_RESERVATION_QUANTITY)
1668: into l_total_reserve_qty
1669: from mtl_reservations md, oe_order_lines_all so,
1670: po_req_distributions_all pod,
1671: po_requisition_lines_all pol
1672: where md.DEMAND_SOURCE_LINE_ID = so.LINE_ID
1673: and so.ORIG_SYS_LINE_REF = pod.DISTRIBUTION_ID

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

1696: -- total demand is calculated as follows:
1697: -- if we have to consider both unreserved matl and reserved matl. then the
1698: -- demand is simply the total demand = ordered qty - shipped qty.
1699: -- elsif we have to take into account only reserved matl. then the
1700: -- demand is simply the reservations from mtl_reservations for the matl.
1701: -- elsif we have to take into account just the unreserved matl. then the
1702: -- demand is total demand - the reservations for the material.
1703: if p_net_unreserved = 1 and p_net_reserved = 1 then
1704: l_demand_qty := Nvl(l_total_demand_qty,0);