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

Line 1289: from mtl_reservations mr

1285: wdj.scheduled_completion_date receipt_date,
1286: GREATEST(0, (wdj.start_quantity - wdj.quantity_completed
1287: - wdj.quantity_scrapped)) item_qty,
1288: (select sum(mr.reservation_quantity)
1289: from mtl_reservations mr
1290: where mr.supply_source_type_id = 5 --wip supply
1291: and mr.supply_source_header_id = wdj.wip_entity_id
1292: and mr.organization_id = wdj.organization_id) reservation_qty,
1293: wdj.wip_entity_id --added for bug 6886708 for logging

Line 1448: from mtl_reservations mr

1444: CURSOR po_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) IS
1445: SELECT
1446: ms.to_org_primary_quantity item_qty,
1447: (select sum(mr.reservation_quantity)
1448: from mtl_reservations mr
1449: where mr.supply_source_type_id = 1 --po supply
1450: and mr.supply_source_header_id = ms.po_header_id
1451: and mr.supply_source_line_id = ms.po_line_id ) reservation_qty,
1452: pd.PO_HEADER_ID --added for bug 6886708 for logging

Line 1495: from mtl_reservations mr

1491: SELECT
1492: (nvl(ms.to_org_primary_quantity,0) *
1493: pd.req_line_quantity/prl.quantity) item_qty,
1494: (select sum(mr.reservation_quantity)
1495: from mtl_reservations mr
1496: where mr.supply_source_type_id = 18 --po req supply
1497: and mr.supply_source_header_id = ms.req_header_id
1498: and mr.supply_source_line_id = ms.req_line_id ) reservation_qty,
1499: pd.requisition_line_id, --added for bug 6886708 for logging

Line 1543: from mtl_reservations mr

1539: SELECT
1540: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)
1541: item_qty,
1542: (select sum(mr.reservation_quantity)
1543: from mtl_reservations mr
1544: where mr.supply_source_type_id = 18 --todo, need to check source type id
1545: and mr.supply_source_header_id = ms.shipment_header_id
1546: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1547: pd.requisition_line_id, --added for bug 6886708 for logging

Line 1593: from mtl_reservations mr

1589: SELECT
1590: nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1591: pl.quantity item_qty,
1592: (select sum(mr.reservation_quantity)
1593: from mtl_reservations mr
1594: where mr.supply_source_type_id = 18 --todo, need to check source type id
1595: and mr.supply_source_header_id = ms.shipment_header_id
1596: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1597: FROM po_requisition_lines_all pl,

Line 1617: from mtl_reservations mr

1613: UNION ALL
1614: SELECT
1615: SUM(ms.to_org_primary_quantity) item_qty,
1616: (select sum(mr.reservation_quantity)
1617: from mtl_reservations mr
1618: where mr.supply_source_type_id = 18 --todo, need to check source type id
1619: and mr.supply_source_header_id = ms.shipment_header_id
1620: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1621: FROM mtl_secondary_inventories msub,

Line 1659: from mtl_reservations mr

1655: CURSOR po_rcv_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) IS
1656: SELECT
1657: ms.to_org_primary_quantity item_qty,
1658: (select sum(mr.reservation_quantity)
1659: from mtl_reservations mr
1660: where mr.supply_source_type_id = 18 --todo, need to check source type id
1661: and mr.supply_source_header_id = ms.shipment_header_id
1662: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1663: pd.PO_HEADER_ID --added for bug 6886708 for logging