APPS.CSE_ASSET_CREATION_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 2510: FROM mtl_secondary_inventories

2506: END IF;
2507: --Added For bug9488846 - start
2508: SELECT decode(asset_inventory,2,'Y','N') --1=Asset Subinventory 2=Expense subinventory
2509: INTO l_exp_subinv_flag
2510: FROM mtl_secondary_inventories
2511: WHERE organization_id = l_organization_id
2512: AND secondary_inventory_name = l_subinventory_code;
2513:
2514: IF l_inventory_asset_flag = 'N' AND l_asset_for_exp_item_flag = 'N' THEN

Line 2559: FROM mtl_secondary_inventories

2555: l_location_type_code := 'INVENTORY';
2556:
2557: SELECT location_id
2558: INTO l_location_id
2559: FROM mtl_secondary_inventories
2560: WHERE organization_id = l_organization_id
2561: AND secondary_inventory_name = l_subinventory_code;
2562:
2563: IF l_location_id IS NULL THEN