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) = 1;
74:

Line 133: FROM mtl_system_items

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

Line 166: FROM mtl_system_items

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

Line 198: FROM mtl_system_items

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