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 2255: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

2251: --FROM mtl_system_items_vl /* Bug 5581528 */
2252: from mtl_system_items_vl msik /*bug7626228*/
2253: WHERE organization_id = p_organization_id
2254: AND concatenated_segments LIKE (p_concatenated_segments||l_append)
2255: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2256: p_organization_id,
2257: inventory_item_id,
2258: p_subinventory_code)='Y' --Bug# 2879164
2259: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,

Line 2259: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,

2255: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2256: p_organization_id,
2257: inventory_item_id,
2258: p_subinventory_code)='Y' --Bug# 2879164
2259: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,
2260: inventory_item_id,
2261: p_subinventory_code)='Y' -- Bug 5500255*/
2262: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,
2263: msik.restrict_subinventories_code,msik.restrict_locators_code)='Y' -- bug7626228

Line 2262: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,

2258: p_subinventory_code)='Y' --Bug# 2879164
2259: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item (p_organization_id,
2260: inventory_item_id,
2261: p_subinventory_code)='Y' -- Bug 5500255*/
2262: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,
2263: msik.restrict_subinventories_code,msik.restrict_locators_code)='Y' -- bug7626228
2264: AND msik.stock_enabled_flag = 'Y' -- Added for Bug 6310345
2265:
2266: --Changes for GTIN

Line 2385: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

2381: FROM mtl_physical_adjustments
2382: WHERE physical_inventory_id = p_physical_inventory_id
2383: AND organization_id = p_organization_id
2384: AND approval_status IS NULL) OR mpit.adjustment_id IS NULL)--Bug#9772069
2385: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2386: p_organization_id,
2387: msik.inventory_item_id,
2388: p_subinventory_code)='Y' --Bug# 2879164
2389: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

Line 2389: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

2385: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2386: p_organization_id,
2387: msik.inventory_item_id,
2388: p_subinventory_code)='Y' --Bug# 2879164
2389: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,
2390: msik.inventory_item_id,
2391: p_subinventory_code)='Y' -- Bug 5500255*/
2392: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,
2393: msik.restrict_subinventories_code,msik.restrict_locators_code)='Y' -- bug7626228

Line 2392: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,

2388: p_subinventory_code)='Y' --Bug# 2879164
2389: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,
2390: msik.inventory_item_id,
2391: p_subinventory_code)='Y' -- Bug 5500255*/
2392: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,
2393: msik.restrict_subinventories_code,msik.restrict_locators_code)='Y' -- bug7626228
2394: AND msik.stock_enabled_flag = 'Y' -- Added for Bug 6310345
2395:
2396: --Changes for GTIN

Line 2810: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

2806: AND serial_number_control_code NOT IN (1, 6)
2807: )
2808: )
2809: AND msik.concatenated_segments LIKE (p_concatenated_segments||l_append)
2810: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2811: p_organization_id,
2812: msik.inventory_item_id,
2813: p_subinventory_code)='Y' --Bug# 3188455 Added this for validating restricted Items to locator and subinventory
2814: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

Line 2814: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,

2810: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,
2811: p_organization_id,
2812: msik.inventory_item_id,
2813: p_subinventory_code)='Y' --Bug# 3188455 Added this for validating restricted Items to locator and subinventory
2814: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,
2815: msik.inventory_item_id,
2816: p_subinventory_code)='Y' -- Bug 5500255*/
2817: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,
2818: msik.restrict_subinventories_code,msik.restrict_locators_code)='Y' -- Bug7626228

Line 2817: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,

2813: p_subinventory_code)='Y' --Bug# 3188455 Added this for validating restricted Items to locator and subinventory
2814: AND INV_MATERIAL_STATUS_GRP.sub_valid_for_item(p_organization_id,
2815: msik.inventory_item_id,
2816: p_subinventory_code)='Y' -- Bug 5500255*/
2817: AND INV_MATERIAL_STATUS_GRP.sub_loc_valid_for_item(p_organization_id,msik.inventory_item_id,p_subinventory_code,p_locator_id,
2818: msik.restrict_subinventories_code,msik.restrict_locators_code)='Y' -- Bug7626228
2819: --Changes for GTIN
2820: UNION
2821: