APPS.BOM_EAMUTIL dependencies on MTL_SYSTEM_ITEMS

Line 70: FROM mtl_system_items

66: END IF;
67:
68: SELECT decode(effectivity_control , 2 , 'Y' , 'N')
69: INTO l_serial_eff_item
70: FROM mtl_system_items
71: WHERE inventory_item_id = item_id
72: AND organization_id = org_id
73: AND nvl(eam_item_type,0) IN (1,3); /*Bug 7286777: Serial Effectivity
74: should be for both Asset Group as well as Rebuildable*/

Line 134: FROM mtl_system_items

130: END IF;
131:
132: SELECT 'Y'
133: INTO l_asset_activity_item
134: FROM mtl_system_items
135: WHERE inventory_item_id = item_id AND
136: organization_id = org_id AND
137: nvl(eam_item_type,0) = 2;
138:

Line 167: FROM mtl_system_items

163: END IF;
164:
165: SELECT 'Y'
166: INTO l_asset_group_item
167: FROM mtl_system_items
168: WHERE inventory_item_id = item_id AND
169: organization_id = org_id AND
170: nvl(eam_item_type,0) = 1;
171:

Line 199: FROM mtl_system_items

195: END IF;
196:
197: SELECT 'Y'
198: INTO l_direct_item
199: FROM mtl_system_items
200: WHERE inventory_item_id = item_id AND
201: organization_id = org_id AND
202: /*inventory_item_flag = 'Y' AND Bug 7566475 Removing the and condition on the column inventory_item_flag*/
203: stock_enabled_flag = 'N';