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 4370: FROM mtl_system_items_kfv msiv,

4366: , NVL(msiv.secondary_default_ind,'')
4367: , NVL(msiv.tracking_quantity_ind,'P')
4368: , NVL(msiv.dual_uom_deviation_high,0)
4369: , NVL(msiv.dual_uom_deviation_low,0)
4370: FROM mtl_system_items_kfv msiv,
4371: wms_lpn_contents wlc
4372: WHERE wlc.parent_lpn_id = p_lpn_id
4373: AND wlc.organization_id = p_org_id
4374: AND wms_catch_weight_pvt.check_ds_lpn( p_lpn_id

Line 4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc

4430: , NVL(msi.secondary_default_ind,'')
4431: , NVL(msi.tracking_quantity_ind,'P')
4432: , NVL(msi.dual_uom_deviation_high,0)
4433: , NVL(msi.dual_uom_deviation_low,0)
4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
4435: WHERE wlc.parent_lpn_id = p_lpn_id
4436: AND wlc.inventory_item_id = msi.inventory_item_id
4437: AND wlc.organization_id = msi.organization_id
4438: AND wms_catch_weight_pvt.check_wsh_lpn( p_lpn_id

Line 4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

4484: , NVL(msi.secondary_default_ind,'')
4485: , NVL(msi.tracking_quantity_ind,'P')
4486: , NVL(msi.dual_uom_deviation_high,0)
4487: , NVL(msi.dual_uom_deviation_low,0)
4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
4489: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4490: AND mmtt.organization_id = p_org_id
4491: AND mmtt.organization_id = msi.organization_id
4492: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 4549: mtl_system_items_kfv msi

4545: , NVL(msi.dual_uom_deviation_high,0)
4546: , NVL(msi.dual_uom_deviation_low,0)
4547: FROM wms_license_plate_numbers wlpn,
4548: mtl_material_transactions_temp mmtt,
4549: mtl_system_items_kfv msi
4550: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4551: AND mmtt.organization_id = p_org_id
4552: AND mmtt.organization_id = msi.organization_id
4553: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 4611: mtl_system_items_kfv msi

4607: , NVL(msi.tracking_quantity_ind,'P')
4608: , NVL(msi.dual_uom_deviation_high,0)
4609: , NVL(msi.dual_uom_deviation_low,0)
4610: FROM wms_lpn_contents wlc,
4611: mtl_system_items_kfv msi
4612: WHERE wlc.parent_lpn_id = p_lpn_id
4613: AND wlc.organization_id = p_org_id
4614: AND msi.inventory_item_id = wlc.inventory_item_id
4615: AND msi.organization_id = wlc.organization_id