eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENGECOBO dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1162: from eng_revised_items eri, mtl_system_items_b_kfv msikfv

1158: -- Commented for bug 4946796
1159: /*CURSOR c_rev_items_for_enable (v_rev_item_seq_id NUMBER)
1160: IS
1161: select distinct eri.revised_item_id, msikfv.concatenated_segments item_name
1162: from eng_revised_items eri, mtl_system_items_b_kfv msikfv
1163: where eri.revised_item_id = msikfv.inventory_item_id
1164: and eri.organization_id = msikfv.organization_id
1165: and eri.parent_revised_item_seq_id = v_rev_item_seq_id
1166: and (eri.transfer_or_copy is not null and eri.transfer_or_copy = 'T')

Line 1169: FROM mtl_system_items_b_kfv

1165: and eri.parent_revised_item_seq_id = v_rev_item_seq_id
1166: and (eri.transfer_or_copy is not null and eri.transfer_or_copy = 'T')
1167: and eri.enable_item_in_local_org = 'Y'
1168: and eri.revised_item_id not in (SELECT inventory_item_id
1169: FROM mtl_system_items_b_kfv
1170: WHERE inventory_item_id = eri.revised_item_id
1171: AND organization_id = p_local_org_id);*/
1172:
1173: -- Commented for bug 4946796

Line 1287: FROM mtl_system_items_b_kfv

1283: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if item exists in local Organization');
1284: BEGIN
1285: SELECT 1
1286: into l_item_exists_in_org_flag
1287: FROM mtl_system_items_b_kfv
1288: WHERE inventory_item_id = p_revised_item_id
1289: AND organization_id = p_local_org_id;
1290: EXCEPTION
1291: WHEN NO_DATA_FOUND THEN

Line 1299: FROM mtl_system_items_b_kfv

1295: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_item_exists_in_org_flag: '||l_item_exists_in_org_flag);
1296:
1297: SELECT concatenated_segments
1298: into l_revised_item_number
1299: FROM mtl_system_items_b_kfv
1300: WHERE inventory_item_id = p_revised_item_id
1301: AND organization_id = g_global_org_id;
1302:
1303: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_revised_item_number: '||l_revised_item_number);

Line 1585: from mtl_system_items_b_kfv

1581: IF (l_item_exists_in_org_flag = 0)
1582: THEN
1583: select concatenated_segments
1584: into l_temp_item_name
1585: from mtl_system_items_b_kfv
1586: where inventory_item_id = tolc.revised_item_id
1587: and organization_id = p_global_org_id;
1588:
1589: Fnd_message.set_name('ENG', 'ENG_PRP_ITM_NOT_EXISTS');

Line 2283: FROM mtl_system_items_b_kfv

2279: l_item_exits_in_org_flag := 1;
2280:
2281: SELECT concatenated_segments
2282: INTO l_revised_item_number
2283: FROM mtl_system_items_b_kfv
2284: WHERE inventory_item_id = ri.revised_item_id
2285: AND organization_id = l_org_id;
2286: EXCEPTION
2287: WHEN NO_DATA_FOUND THEN

Line 2331: FROM mtl_system_items_b_kfv

2327:
2328: BEGIN
2329: SELECT concatenated_segments
2330: INTO l_use_up_item_name
2331: FROM mtl_system_items_b_kfv
2332: WHERE inventory_item_id = ri.use_up_item_id
2333: AND organization_id = l_org_id;
2334: EXCEPTION WHEN NO_DATA_FOUND THEN
2335: l_item_exits_in_org_flag := 0;

Line 2462: FROM mtl_system_items_b_kfv msi,

2458: BEGIN
2459: l_item_exits_in_org_flag := 1;
2460: SELECT msi.concatenated_segments,eri.new_item_revision
2461: INTO l_revised_item_name,l_new_item_revision
2462: FROM mtl_system_items_b_kfv msi,
2463: eng_revised_items eri
2464: WHERE eri.revised_item_sequence_id = rcd.revised_item_sequence_id
2465: AND eri.revised_item_id = msi.inventory_item_id
2466: AND msi.organization_id = l_org_id;

Line 2477: FROM mtl_system_items_b_kfv

2473:
2474: BEGIN
2475: SELECT concatenated_segments
2476: INTO l_component_item_name
2477: FROM mtl_system_items_b_kfv
2478: WHERE inventory_item_id = rcd.component_item_id
2479: AND organization_id = l_org_id;
2480: EXCEPTION WHEN NO_DATA_FOUND THEN
2481: l_item_exits_in_org_flag := 0;

Line 2662: FROM mtl_system_items_b_kfv msi,

2658:
2659:
2660: SELECT msi.concatenated_segments,eri.new_item_revision
2661: INTO l_revised_item_name,l_new_item_revision
2662: FROM mtl_system_items_b_kfv msi,
2663: eng_revised_items eri
2664: WHERE eri.revised_item_sequence_id = rc.revised_item_sequence_id
2665: AND eri.revised_item_id = msi.inventory_item_id
2666: AND msi.organization_id = l_org_id;

Line 2680: FROM mtl_system_items_b_kfv

2676: BEGIN
2677:
2678: /* SELECT concatenated_segments -- Commented for bug-5725081
2679: INTO l_component_item_name
2680: FROM mtl_system_items_b_kfv
2681: WHERE inventory_item_id = rc.component_item_id
2682: AND organization_id = l_org_id;
2683: */
2684:

Line 2738: FROM mtl_system_items_b_kfv MSIF ,

2734: INTO l_component_item_name,
2735: v_component_quantity_to,
2736: v_component_low_quantity,
2737: v_component_high_quantity
2738: FROM mtl_system_items_b_kfv MSIF ,
2739: mtl_system_items_b_kfv MSIT
2740: WHERE msif.inventory_item_id = msit.inventory_item_id
2741: AND msif.inventory_item_id = rc.component_item_id
2742: AND msit.organization_id = l_org_id

Line 2739: mtl_system_items_b_kfv MSIT

2735: v_component_quantity_to,
2736: v_component_low_quantity,
2737: v_component_high_quantity
2738: FROM mtl_system_items_b_kfv MSIF ,
2739: mtl_system_items_b_kfv MSIT
2740: WHERE msif.inventory_item_id = msit.inventory_item_id
2741: AND msif.inventory_item_id = rc.component_item_id
2742: AND msit.organization_id = l_org_id
2743: AND msif.organization_id = l_org_hierarchy_level_id ;

Line 2955: FROM mtl_system_items_b_kfv msi,

2951: l_item_exits_in_org_flag := 1;
2952:
2953: SELECT msi.concatenated_segments,eri.new_item_revision
2954: INTO l_revised_item_name1,l_new_item_revision
2955: FROM mtl_system_items_b_kfv msi,
2956: eng_revised_items eri,
2957: bom_inventory_components bic
2958: WHERE bic.component_sequence_id = sc.component_sequence_id
2959: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id

Line 2974: FROM mtl_system_items_b_kfv msi,

2970: SELECT concatenated_segments,bic.effectivity_date,
2971: bic.operation_seq_num
2972: INTO l_component_item_name1,l_effectivity_date,
2973: l_operation_seq_num
2974: FROM mtl_system_items_b_kfv msi,
2975: bom_inventory_components bic
2976: WHERE bic.component_sequence_id = sc.component_sequence_id
2977: AND msi.inventory_item_id = bic.component_item_id
2978: AND msi.organization_id = l_org_id;

Line 2992: FROM mtl_system_items_b_kfv

2988: v_substitute_item_quantity := 0; -- Added for bug-5725081
2989:
2990: /* SELECT concatenated_segments -- Commented for bug-5725081
2991: INTO l_substitute_component_name
2992: FROM mtl_system_items_b_kfv
2993: WHERE inventory_item_id = sc.substitute_component_id
2994: AND organization_id = l_org_id;
2995: */
2996:

Line 3011: FROM mtl_system_items_b_kfv MSIF,

3007: msit.primary_unit_of_measure)
3008: )
3009: INTO l_substitute_component_name,
3010: v_substitute_item_quantity
3011: FROM mtl_system_items_b_kfv MSIF,
3012: mtl_system_items_b_kfv MSIT
3013: WHERE msif.inventory_item_id = msit.inventory_item_id
3014: AND msif.inventory_item_id = sc.substitute_component_id
3015: AND msit.organization_id = l_org_id

Line 3012: mtl_system_items_b_kfv MSIT

3008: )
3009: INTO l_substitute_component_name,
3010: v_substitute_item_quantity
3011: FROM mtl_system_items_b_kfv MSIF,
3012: mtl_system_items_b_kfv MSIT
3013: WHERE msif.inventory_item_id = msit.inventory_item_id
3014: AND msif.inventory_item_id = sc.substitute_component_id
3015: AND msit.organization_id = l_org_id
3016: AND msif.organization_id = l_org_hierarchy_level_id;

Line 3120: FROM mtl_system_items_b_kfv msi,

3116: SELECT msi.concatenated_segments,eri.new_item_revision,
3117: bic.effectivity_date,bic.operation_seq_num
3118: INTO l_revised_item_name2,l_new_item_revision,
3119: l_effectivity_date,l_operation_seq_num
3120: FROM mtl_system_items_b_kfv msi,
3121: eng_revised_items eri,
3122: bom_inventory_components bic
3123: WHERE bic.component_sequence_id = rd.component_sequence_id
3124: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id

Line 3138: FROM mtl_system_items_b_kfv msi,

3134:
3135: BEGIN
3136: SELECT concatenated_segments
3137: INTO l_component_item_name2
3138: FROM mtl_system_items_b_kfv msi,
3139: bom_inventory_components bic
3140: WHERE bic.component_sequence_id = rd.component_sequence_id
3141: AND msi.inventory_item_id = bic.component_item_id
3142: AND msi.organization_id = l_org_id;

Line 4536: FROM mtl_system_items_b_kfv

4532: THEN
4533: BEGIN
4534: SELECT concatenated_segments
4535: INTO l_pk1_name
4536: FROM mtl_system_items_b_kfv
4537: WHERE inventory_item_id = l_pk1_value
4538: AND organization_id = p_local_organization_id;
4539: EXCEPTION
4540: WHEN NO_DATA_FOUND THEN

Line 5062: FROM mtl_system_items_b_kfv

5058: THEN
5059: -- get the item name, use up item name and plan name
5060: SELECT concatenated_segments
5061: INTO l_revised_item_number
5062: FROM mtl_system_items_b_kfv
5063: WHERE inventory_item_id = ri.revised_item_id
5064: AND organization_id = p_local_organization_id;
5065:
5066: l_use_up_item_name := null;

Line 5071: FROM mtl_system_items_b_kfv

5067: IF (ri.use_up_item_id IS NOT NULL)
5068: THEN
5069: SELECT concatenated_segments
5070: INTO l_use_up_item_name
5071: FROM mtl_system_items_b_kfv
5072: WHERE inventory_item_id = ri.use_up_item_id
5073: AND organization_id = p_local_organization_id;
5074: END IF;
5075:

Line 5215: from mtl_system_items_b_kfv msikfv, mtl_item_revisions mir

5211: IF (ri.from_end_item_rev_id IS NOT NULL)
5212: THEN
5213: select msikfv.concatenated_segments, mir.revision
5214: into l_from_end_item_name, l_from_end_item_revision
5215: from mtl_system_items_b_kfv msikfv, mtl_item_revisions mir
5216: where mir.revision_id = ri.from_end_item_rev_id
5217: and mir.inventory_item_id = msikfv.inventory_item_id
5218: and mir.organization_id = msikfv.organization_id;
5219: END IF;