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.INV_LABEL_PVT4 dependencies on MTL_MATERIAL_STATUSES_VL

Line 766: , mtl_material_statuses_vl mmsv

762: , mtl_system_items_kfv msik
763: , mtl_transaction_lots_temp mtlt
764: , mtl_material_transactions_temp mmtt
765: , po_hazard_classes poh
766: , mtl_material_statuses_vl mmsv
767: WHERE msik.inventory_item_id = p_item_id
768: AND msik.organization_id = p_org_id
769: AND mp.organization_id = msik.organization_id
770: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id

Line 874: , mtl_material_statuses_vl mmsv

870: FROM mtl_parameters mp
871: , mtl_system_items_kfv msik
872: , mtl_lot_numbers mln
873: , po_hazard_classes poh
874: , mtl_material_statuses_vl mmsv
875: WHERE msik.inventory_item_id = p_item_id
876: AND msik.organization_id = p_org_id
877: AND mp.organization_id = msik.organization_id
878: AND mln.organization_id (+) = msik.organization_id

Line 2941: FROM mtl_material_statuses_vl

2937: trace('Status_id returned is '||l_return_status_id);
2938: END IF;
2939: BEGIN
2940: SELECT status_code INTO l_material_status_code
2941: FROM mtl_material_statuses_vl
2942: WHERE status_id = l_return_status_id;
2943: EXCEPTION
2944: WHEN No_Data_Found THEN
2945: l_material_status_code := NULL;