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_PVT8 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 854: FROM mtl_system_items_kfv msik

850: ,msik.attribute13
851: ,msik.attribute14
852: ,msik.attribute15
853: ,poh.hazard_class
854: FROM mtl_system_items_kfv msik
855: ,po_hazard_classes poh
856: WHERE msik.organization_id = p_organization_id
857: AND msik.inventory_item_id = p_inventory_item_id
858: AND msik.hazard_class_id = poh.hazard_class_id(+);

Line 1016: , mtl_system_items_kfv msik

1012: , wlpn.attribute14
1013: , wlpn.attribute15
1014: , msik.concatenated_segments lpn_container_item
1015: FROM wms_license_plate_numbers wlpn
1016: , mtl_system_items_kfv msik
1017: , mtl_item_locations_kfv milk
1018: WHERE wlpn.lpn_id = p_lpn_id
1019: AND msik.organization_id(+) = wlpn.organization_id
1020: AND msik.inventory_item_id(+) = wlpn.inventory_item_id

Line 1227: , mtl_system_items_kfv msik_oi

1223: 'INT', msik_oi.concatenated_segments,
1224: msik_oi.concatenated_segments)) ordered_item
1225: FROM oe_order_lines_all oeol
1226: , mtl_customer_items mci_oi
1227: , mtl_system_items_kfv msik_oi
1228: WHERE oeol.line_id = p_line_id
1229: AND oeol.ordered_item_id = mci_oi.customer_item_id (+)
1230: AND oeol.ordered_item_id = msik_oi.inventory_item_id (+)
1231: AND oeol.org_id = msik_oi.organization_id (+);