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_KFV

Line 1885: FROM mtl_system_items_kfv msiv,

1881: , NVL(msi.SECONDARY_DEFAULT_IND,'')
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

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

Line 1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

1994: , NVL(msi.SECONDARY_DEFAULT_IND,'')
1995: , NVL(msi.TRACKING_QUANTITY_IND,'P')
1996: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
1997: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
1998: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
1999: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2000: AND mmtt.organization_id = p_org_id
2001: AND mmtt.organization_id = msi.organization_id
2002: AND msi.ont_pricing_qty_source = 'S'

Line 2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

2050: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2051: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2052: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2053: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2054: from mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
2055: where (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
2056: and mmtt.organization_id = p_org_id
2057: and mmtt.organization_id = msi.organization_id
2058: and mmtt.inventory_item_id = msi.inventory_item_id

Line 2108: FROM mtl_system_items_kfv msi, wsh_Delivery_Details wdd1

2104: , NVL(msi.SECONDARY_DEFAULT_IND,'')
2105: , NVL(msi.TRACKING_QUANTITY_IND,'P')
2106: , NVL(msi.DUAL_UOM_DEVIATION_HIGH,0)
2107: , NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
2108: FROM mtl_system_items_kfv msi, wsh_Delivery_Details wdd1
2109: WHERE wdd1.inventory_item_id = msi.inventory_item_id
2110: AND wdd1.organization_id = msi.organization_id
2111: AND msi.ont_pricing_qty_source = 'S'
2112: AND wdd1. picked_quantity2 is NULL