DBA Data[Home] [Help]

APPS.QA_FLEX_UTIL dependencies on MTL_PARAMETERS

Line 74: from mtl_system_items_kfv msikfv,mtl_parameters mp

70: and organization_id = c_org_id
71: and rownum=1
72: UNION ALL
73: select concatenated_segments
74: from mtl_system_items_kfv msikfv,mtl_parameters mp
75: where msikfv.inventory_item_id = c_item_id
76: and msikfv.organization_id = mp.organization_id
77: and mp.maint_organization_id = c_org_id
78: and rownum=1;

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