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.WMS_CATCH_WEIGHT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1583: FROM wms_lpn_contents wlc , mtl_system_items_b msi

1579: AND wlpn.organization_id = p_org_id
1580: AND wlpn.license_plate_number LIKE (p_lpn || '%')
1581: AND EXISTS (
1582: SELECT msi.inventory_item_id
1583: FROM wms_lpn_contents wlc , mtl_system_items_b msi
1584: WHERE wlc.organization_id = msi.organization_id
1585: AND wlc.inventory_item_id = msi.inventory_item_id
1586: AND msi.ont_pricing_qty_source = 'S'
1587: AND msi.organization_id = p_org_id

Line 1595: mtl_system_items_b msi

1591: nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) outer_lpn,
1592: wlpn.lpn_context
1593: FROM mtl_material_transactions_temp mmtt,
1594: wms_license_plate_numbers wlpn,
1595: mtl_system_items_b msi
1596: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1597: AND mmtt.organization_id = msi.organization_id
1598: AND mmtt.organization_id = p_org_id
1599: AND wlpn.lpn_id = nvl(mmtt.transfer_lpn_id, content_lpn_id)

Line 1610: mtl_system_items_b msi

1606: transfer_lpn_id,
1607: wlpn.lpn_context
1608: FROM mtl_material_transactions_temp mmtt,
1609: wms_license_plate_numbers wlpn,
1610: mtl_system_items_b msi
1611: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1612: AND mmtt.organization_id = msi.organization_id
1613: AND mmtt.organization_id = p_org_id
1614: AND wlpn.lpn_id = mmtt.transfer_lpn_id

Line 1635: FROM mtl_system_items_b msi,

1631: AND wlpn.organization_id = p_org_id
1632: AND wlpn.license_plate_number LIKE (p_lpn || '%')
1633: AND EXISTS (
1634: SELECT msi.inventory_item_id, wddl.lpn_id
1635: FROM mtl_system_items_b msi,
1636: wsh_delivery_details wddl,
1637: wsh_delivery_assignments_v wda,
1638: wsh_delivery_details wddit
1639: WHERE wddit.organization_id = msi.organization_id

Line 1653: mtl_system_items_b msi, mtl_transaction_lots_temp mtlt

1649: SELECT UNIQUE wlpn.license_plate_number,
1650: nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) outer_lpn,
1651: wlpn.lpn_context
1652: FROM mtl_material_transactions_temp mmtt, wms_license_plate_numbers wlpn,
1653: mtl_system_items_b msi, mtl_transaction_lots_temp mtlt
1654: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1655: AND mmtt.organization_id = msi.organization_id
1656: AND mmtt.organization_id = p_org_id
1657: AND msi.ont_pricing_qty_source = 'S'

Line 1670: mtl_system_items_b msi,

1666: SELECT UNIQUE wlpn.license_plate_number,
1667: transfer_lpn_id, wlpn.lpn_context
1668: FROM mtl_material_transactions_temp mmtt,
1669: wms_license_plate_numbers wlpn,
1670: mtl_system_items_b msi,
1671: mtl_transaction_lots_temp mtlt
1672: WHERE mmtt.inventory_item_id = msi.inventory_item_id
1673: AND mmtt.organization_id = msi.organization_id
1674: AND mmtt.organization_id = p_org_id

Line 1711: FROM mtl_system_items_b msi, wms_lpn_contents wlc

1707: FROM wms_license_plate_numbers wlpn
1708: WHERE outermost_lpn_id = p_outer_lpn_id
1709: AND EXISTS (
1710: SELECT 1
1711: FROM mtl_system_items_b msi, wms_lpn_contents wlc
1712: WHERE wlc.organization_id = wlpn.organization_id
1713: AND wlc.parent_lpn_id = wlpn.lpn_id
1714: AND msi.organization_id = wlc.organization_id
1715: AND msi.inventory_item_id = wlc.inventory_item_id

Line 1732: FROM wms_lpn_contents wlc , mtl_system_items_b msi

1728: WHERE outermost_lpn_id = p_outer_lpn_id
1729: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%')
1730: AND EXISTS (
1731: SELECT msi.inventory_item_id
1732: FROM wms_lpn_contents wlc , mtl_system_items_b msi
1733: WHERE wlc.organization_id = msi.organization_id
1734: AND wlc.inventory_item_id = msi.inventory_item_id
1735: AND msi.ont_pricing_qty_source = 'S'
1736: AND wlc.parent_lpn_id = wlpn.lpn_id)

Line 1819: FROM mtl_system_items_b msi

1815: AND picked_quantity2 is null) outer
1816: WHERE inner.delivery_detail_id = outer.delivery_Detail_id
1817: AND outer.container_name LIKE (p_inner_lpn || '%')
1818: AND exists (SELECT msi.inventory_item_id
1819: FROM mtl_system_items_b msi
1820: WHERE msi.organization_id = inner.organization_id
1821: AND msi.organization_id = p_org_id
1822: AND msi.ont_pricing_qty_source = 'S'
1823: AND msi.inventory_item_id = inner.inventory_item_id);

Line 2144: mtl_system_items_b msib

2140:
2141: CURSOR itemCur(in_lpn_id NUMBER) IS
2142: SELECT picked_quantity2
2143: FROM wsh_delivery_details wdd,
2144: mtl_system_items_b msib
2145: WHERE wdd.inventory_item_id = p_from_item_id
2146: AND wdd.inventory_item_id = msib.inventory_item_id
2147: AND wdd.organization_id = p_org_id
2148: AND wdd.organization_id = msib.organization_id

Line 2301: mtl_system_items_b msib

2297: NULL)) requested_quantity,
2298: sum(picked_quantity2) picked_quantity2,
2299: msib.primary_uom_code
2300: FROM wsh_delivery_details wdd,
2301: mtl_system_items_b msib
2302: WHERE wdd.inventory_item_id = p_from_item_id
2303: AND wdd.inventory_item_id = msib.inventory_item_id
2304: AND wdd.organization_id = p_org_id
2305: AND wdd.organization_id = msib.organization_id