DBA Data[Home] [Help]

APPS.QA_FLEX_UTIL dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 886: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp

882: name VARCHAR2(2000);
883: --rownum=1 =>better performance since all rows have same inventory_item_id
884: CURSOR c (o_id NUMBER, asset_group_id NUMBER) IS
885: SELECT msikfv.concatenated_segments
886: FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
887: WHERE msikfv.organization_id = mp.organization_id
888: and msikfv.eam_item_type in (1,3)
889: and mp.maint_organization_id = o_id
890: and msikfv.inventory_item_id = asset_group_id