DBA Data[Home] [Help]

APPS.WIP_REBUILD dependencies on MTL_SYSTEM_ITEMS

Line 73: mtl_system_items msi,

69: meaa.owning_department_id,
70: meaa.tagging_required_flag,
71: to_number(meaa.shutdown_type_code)
72: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
73: mtl_system_items msi,
74: mtl_eam_asset_activities meaa
75: WHERE transaction_temp_id = p_tempId
76: and mmtt.rebuild_activity_id = msi.inventory_item_id (+)
77: and mmtt.organization_id = msi.organization_id (+)

Line 204: mtl_system_items msi,

200: tagging_required_flag,
201: to_number(shutdown_type_code) as shutdown_type_code
202: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
203: mtl_serial_numbers msn,
204: mtl_system_items msi,
205: mtl_eam_asset_activities meaa
206: WHERE transaction_temp_id = p_tempId
207: and mmtt.rebuild_activity_id = msi.inventory_item_id (+)
208: and mmtt.organization_id = msi.organization_id (+)

Line 278: FROM mtl_system_items

274: END;
275: else
276: BEGIN
277: SELECT inventory_item_id into l_maintenance_object_id
278: FROM mtl_system_items
279: WHERE inventory_item_id = l_workorder.rebuild_item_id and organization_id =l_workorder.organization_id;
280: l_maintenance_object_type := 2;
281: EXCEPTION
282: WHEN NO_DATA_FOUND THEN