DBA Data[Home] [Help]

APPS.CTO_COST_ROLLUP_CONC_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1140: FROM mtl_system_items_kfv kfv, mtl_parameters mp

1136: begin
1137: SELECT substrb(kfv.concatenated_segments,1,35),
1138: mp.organization_code
1139: INTO l_config_description, l_org_code
1140: FROM mtl_system_items_kfv kfv, mtl_parameters mp
1141: WHERE kfv.inventory_item_id = succ_item_arr(curr_count).cfg_item_id
1142: AND kfv.organization_id = succ_item_arr(curr_count).cfg_org_id
1143: AND kfv.organization_id = mp.organization_id;
1144:

Line 1183: FROM mtl_system_items_kfv kfv, mtl_parameters mp

1179: begin
1180: SELECT substrb(kfv.concatenated_segments,1,35),
1181: mp.organization_code
1182: INTO l_config_description, l_org_code
1183: FROM mtl_system_items_kfv kfv, mtl_parameters mp
1184: WHERE kfv.inventory_item_id = fail_item_arr(curr_count).cfg_item_id
1185: AND kfv.organization_id = fail_item_arr(curr_count).cfg_org_id
1186: AND kfv.organization_id = mp.organization_id;
1187: