APPS.QA_PLAN_ELEMENT_API dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4591: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

4587: wild := value;
4588:
4589: --dgupta: Start R12 EAM Integration. Bug 4345492
4590: sql_string := 'select distinct msikfv.concatenated_segments, msikfv.description
4591: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
4592: where msikfv.organization_id = mp.organization_id
4593: and msikfv.eam_item_type in (1,3)
4594: and mp.maint_organization_id = :1
4595: and msikfv.concatenated_segments like :2

Line 4646: mtl_system_items_b_kfv msib

4642: sql_string := 'SELECT
4643: msib.concatenated_segments activity ,
4644: msib.description activity_description
4645: FROM mtl_eam_asset_activities meaav,
4646: mtl_system_items_b_kfv msib
4647: WHERE msib.organization_id = :1
4648: AND meaav. maintenance_object_id = :2 --pass asset group inventory_item_id
4649: AND (meaav.end_date_active is null
4650: OR meaav.end_date_active > sysdate)

Line 4679: mtl_system_items_b_kfv msi

4675: sql_string := 'SELECT
4676: msi.concatenated_segments activity ,
4677: msi.description activity_description
4678: FROM mtl_eam_asset_activities meaa,
4679: mtl_system_items_b_kfv msi
4680: WHERE msi.organization_id = :1
4681: AND meaa.maintenance_object_id = :2 --pass asset instance_id
4682: AND meaa.maintenance_object_type = 3 --serialized item
4683: AND (meaa.end_date_active is null

Line 5009: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp

5005: id NUMBER;
5006: --rownum=1 =>better performance since all rows have same inventory_item_id
5007: CURSOR c (o_id NUMBER, a_group VARCHAR2) IS
5008: SELECT msikfv.inventory_item_id
5009: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
5010: WHERE msikfv.organization_id = mp.organization_id
5011: and msikfv.eam_item_type in (1,3)
5012: and mp.maint_organization_id = o_id
5013: and msikfv.concatenated_segments = a_group