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_UI_ITEM_LOVS dependencies on INV_MATERIAL_STATUS_GRP

Line 2121: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

2117: NVL(DUAL_UOM_DEVIATION_LOW,0)
2118: FROM mtl_system_items_vl /* Bug 5581528 */
2119: WHERE organization_id = p_organization_id
2120: AND concatenated_segments LIKE (p_concatenated_segments)
2121: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2122: p_organization_id,
2123: inventory_item_id,
2124: p_subinventory_code)='Y' --Bug# 2879164
2125: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,

Line 2125: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,

2121: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2122: p_organization_id,
2123: inventory_item_id,
2124: p_subinventory_code)='Y' --Bug# 2879164
2125: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,
2126: inventory_item_id,
2127: p_subinventory_code)='Y' -- Bug 5500255
2128: AND mtl_system_items_vl.stock_enabled_flag = 'Y' -- Added for Bug 6310345
2129:

Line 2247: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

2243: FROM mtl_physical_adjustments
2244: WHERE physical_inventory_id = p_physical_inventory_id
2245: AND organization_id = p_organization_id
2246: AND approval_status IS NULL)
2247: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2248: p_organization_id,
2249: msik.inventory_item_id,
2250: p_subinventory_code)='Y' --Bug# 2879164
2251: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

Line 2251: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

2247: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2248: p_organization_id,
2249: msik.inventory_item_id,
2250: p_subinventory_code)='Y' --Bug# 2879164
2251: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,
2252: msik.inventory_item_id,
2253: p_subinventory_code)='Y' -- Bug 5500255
2254: AND msik.stock_enabled_flag = 'Y' -- Added for Bug 6310345
2255:

Line 2660: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

2656: AND serial_number_control_code NOT IN (1, 6)
2657: )
2658: )
2659: AND msik.concatenated_segments LIKE (p_concatenated_segments)
2660: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2661: p_organization_id,
2662: msik.inventory_item_id,
2663: p_subinventory_code)='Y' --Bug# 3188455 Added this for validating restricted Items to locator and subinventory
2664: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

Line 2664: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

2660: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2661: p_organization_id,
2662: msik.inventory_item_id,
2663: p_subinventory_code)='Y' --Bug# 3188455 Added this for validating restricted Items to locator and subinventory
2664: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,
2665: msik.inventory_item_id,
2666: p_subinventory_code)='Y' -- Bug 5500255
2667: --Changes for GTIN
2668: UNION