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 WMS_LPN_CONTENTS

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 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 1886: wms_lpn_contents wlc,

1882: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1883: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1884: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1885: FROM mtl_system_items_kfv msiv,
1886: wms_lpn_contents wlc,
1887: mtl_system_items msi
1888: WHERE wlc.parent_lpn_id = p_lpn_id
1889: AND wlc.organization_id = p_org_id
1890: AND msi.organization_id = wlc.organization_id

Line 1948: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc

1944: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1945: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1946: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1947: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1948: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
1949: WHERE wlc.parent_lpn_id = p_lpn_id
1950: AND wlc.inventory_item_id = msi.inventory_item_id
1951: AND msi.ont_pricing_qty_source = 'S'
1952: AND wlc.organization_id = msi.organization_id