APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4789: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

4785: wild := value;
4786:
4787: --dgupta: Start R12 EAM Integration. Bug 4345492
4788: sql_string := 'select distinct msikfv.concatenated_segments, msikfv.description
4789: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
4790: where msikfv.organization_id = mp.organization_id
4791: and msikfv.eam_item_type in (1,3)
4792: and mp.maint_organization_id = :1
4793: and msikfv.concatenated_segments like :2

Line 4844: mtl_system_items_b_kfv msib

4840: sql_string := 'SELECT
4841: msib.concatenated_segments activity ,
4842: msib.description activity_description
4843: FROM mtl_eam_asset_activities meaav,
4844: mtl_system_items_b_kfv msib
4845: WHERE msib.organization_id = :1
4846: AND meaav. maintenance_object_id = :2 --pass asset group inventory_item_id
4847: AND (meaav.end_date_active is null
4848: OR meaav.end_date_active > sysdate)

Line 4877: mtl_system_items_b_kfv msi

4873: sql_string := 'SELECT
4874: msi.concatenated_segments activity ,
4875: msi.description activity_description
4876: FROM mtl_eam_asset_activities meaa,
4877: mtl_system_items_b_kfv msi
4878: WHERE msi.organization_id = :1
4879: AND meaa.maintenance_object_id = :2 --pass asset instance_id
4880: AND meaa.maintenance_object_type = 3 --serialized item
4881: AND (meaa.end_date_active is null

Line 5207: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp

5203: id NUMBER;
5204: --rownum=1 =>better performance since all rows have same inventory_item_id
5205: CURSOR c (o_id NUMBER, a_group VARCHAR2) IS
5206: SELECT msikfv.inventory_item_id
5207: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
5208: WHERE msikfv.organization_id = mp.organization_id
5209: and msikfv.eam_item_type in (1,3)
5210: and mp.maint_organization_id = o_id
5211: and msikfv.concatenated_segments = a_group