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 1525: mtl_supply ms

1521: and mr.supply_source_header_id = ms.po_header_id
1522: and mr.supply_source_line_id = ms.po_line_id ) reservation_qty,
1523: pd.PO_HEADER_ID --added for bug 6886708 for logging
1524: FROM po_distributions_all pd,
1525: mtl_supply ms
1526: WHERE ms.item_id = p_inv_item_id
1527: AND ms.to_organization_id = p_org_id
1528: AND ( ms.supply_type_code = 'PO' or
1529: ms.supply_type_code = 'ASN')

Line 1574: mtl_supply ms

1570: pd.requisition_line_id, --added for bug 6886708 for logging
1571: prl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1572: FROM po_req_distributions_all pd,
1573: po_requisition_lines_all prl,
1574: mtl_supply ms
1575: WHERE ms.item_id = p_inv_item_id
1576: AND ms.to_organization_id = p_org_id
1577: AND ms.supply_type_code = 'REQ'
1578: AND ms.destination_type_code = 'INVENTORY'

Line 1622: mtl_supply ms

1618: pd.requisition_line_id, --added for bug 6886708 for logging
1619: pl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1620: FROM po_req_distributions_all pd,
1621: po_requisition_lines_all pl,
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 = 'SHIPMENT'
1626: AND ms.destination_type_code = 'INVENTORY'

Line 1670: mtl_supply ms

1666: and mr.supply_source_header_id = ms.shipment_header_id
1667: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1668: FROM po_requisition_lines_all pl,
1669: po_req_distributions_all pd,
1670: mtl_supply ms
1671: WHERE ms.item_id = p_inv_item_id
1672: AND ms.to_organization_id = p_org_id
1673: AND ms.supply_type_code = 'RECEIVING'
1674: AND ms.destination_type_code = 'INVENTORY'

Line 1693: mtl_supply ms

1689: where mr.supply_source_type_id = 18 --todo, need to check source type id
1690: and mr.supply_source_header_id = ms.shipment_header_id
1691: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1692: FROM mtl_secondary_inventories msub,
1693: mtl_supply ms
1694: WHERE ms.item_id = p_inv_item_id
1695: AND ms.to_organization_id = p_org_id
1696: AND ms.supply_type_code = 'RECEIVING'
1697: AND ms.destination_type_code = 'INVENTORY'

Line 1736: mtl_supply ms

1732: and mr.supply_source_header_id = ms.shipment_header_id
1733: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1734: pd.PO_HEADER_ID --added for bug 6886708 for logging
1735: FROM po_distributions_all pd,
1736: mtl_supply ms
1737: WHERE ms.item_id = p_inv_item_id
1738: AND ms.to_organization_id = p_org_id
1739: AND ms.supply_type_code = 'RECEIVING'
1740: AND ms.destination_type_code = 'INVENTORY'