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_SUPPLY

Line 1454: mtl_supply ms

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
1453: FROM po_distributions_all pd,
1454: mtl_supply ms
1455: WHERE ms.item_id = p_inv_item_id
1456: AND ms.to_organization_id = p_org_id
1457: AND ( ms.supply_type_code = 'PO' or
1458: ms.supply_type_code = 'ASN')

Line 1503: mtl_supply ms

1499: pd.requisition_line_id, --added for bug 6886708 for logging
1500: prl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1501: FROM po_req_distributions_all pd,
1502: po_requisition_lines_all prl,
1503: mtl_supply ms
1504: WHERE ms.item_id = p_inv_item_id
1505: AND ms.to_organization_id = p_org_id
1506: AND ms.supply_type_code = 'REQ'
1507: AND ms.destination_type_code = 'INVENTORY'

Line 1551: mtl_supply ms

1547: pd.requisition_line_id, --added for bug 6886708 for logging
1548: pl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1549: FROM po_req_distributions_all pd,
1550: po_requisition_lines_all pl,
1551: mtl_supply ms
1552: WHERE ms.item_id = p_inv_item_id
1553: AND ms.to_organization_id = p_org_id
1554: AND ms.supply_type_code = 'SHIPMENT'
1555: AND ms.destination_type_code = 'INVENTORY'

Line 1599: mtl_supply ms

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,
1598: po_req_distributions_all pd,
1599: mtl_supply ms
1600: WHERE ms.item_id = p_inv_item_id
1601: AND ms.to_organization_id = p_org_id
1602: AND ms.supply_type_code = 'RECEIVING'
1603: AND ms.destination_type_code = 'INVENTORY'

Line 1622: mtl_supply ms

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,
1622: mtl_supply ms
1623: WHERE ms.item_id = p_inv_item_id
1624: AND ms.to_organization_id = p_org_id
1625: AND ms.supply_type_code = 'RECEIVING'
1626: AND ms.destination_type_code = 'INVENTORY'

Line 1665: mtl_supply ms

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
1664: FROM po_distributions_all pd,
1665: mtl_supply ms
1666: WHERE ms.item_id = p_inv_item_id
1667: AND ms.to_organization_id = p_org_id
1668: AND ms.supply_type_code = 'RECEIVING'
1669: AND ms.destination_type_code = 'INVENTORY'