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

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 1284: FROM mtl_system_items_b_kfv

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

Line 1296: FROM mtl_system_items_b_kfv

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

Line 1571: FROM mtl_system_items_b

1567:
1568: BEGIN
1569: select 1
1570: into l_item_exists_in_org_flag
1571: FROM mtl_system_items_b
1572: WHERE inventory_item_id = tolc.revised_item_id
1573: AND organization_id = p_local_org_id;
1574: EXCEPTION
1575: WHEN NO_DATA_FOUND THEN

Line 1582: from mtl_system_items_b_kfv

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

Line 2263: FROM mtl_system_items_b_kfv

2259: l_item_exits_in_org_flag := 1;
2260:
2261: SELECT concatenated_segments
2262: INTO l_revised_item_number
2263: FROM mtl_system_items_b_kfv
2264: WHERE inventory_item_id = ri.revised_item_id
2265: AND organization_id = l_org_id;
2266: EXCEPTION
2267: WHEN NO_DATA_FOUND THEN

Line 2279: FROM mtl_system_items_b_kfv

2275:
2276: BEGIN
2277: SELECT concatenated_segments
2278: INTO l_use_up_item_name
2279: FROM mtl_system_items_b_kfv
2280: WHERE inventory_item_id = ri.use_up_item_id
2281: AND organization_id = l_org_id;
2282: EXCEPTION WHEN NO_DATA_FOUND THEN
2283: l_item_exits_in_org_flag := 0;

Line 2411: FROM mtl_system_items_b_kfv msi,

2407: BEGIN
2408: l_item_exits_in_org_flag := 1;
2409: SELECT msi.concatenated_segments,eri.new_item_revision
2410: INTO l_revised_item_name,l_new_item_revision
2411: FROM mtl_system_items_b_kfv msi,
2412: eng_revised_items eri
2413: WHERE eri.revised_item_sequence_id = rcd.revised_item_sequence_id
2414: AND eri.revised_item_id = msi.inventory_item_id
2415: AND msi.organization_id = l_org_id;

Line 2426: FROM mtl_system_items_b_kfv

2422:
2423: BEGIN
2424: SELECT concatenated_segments
2425: INTO l_component_item_name
2426: FROM mtl_system_items_b_kfv
2427: WHERE inventory_item_id = rcd.component_item_id
2428: AND organization_id = l_org_id;
2429: EXCEPTION WHEN NO_DATA_FOUND THEN
2430: l_item_exits_in_org_flag := 0;

Line 2605: FROM mtl_system_items_b_kfv msi,

2601:
2602:
2603: SELECT msi.concatenated_segments,eri.new_item_revision
2604: INTO l_revised_item_name,l_new_item_revision
2605: FROM mtl_system_items_b_kfv msi,
2606: eng_revised_items eri
2607: WHERE eri.revised_item_sequence_id = rc.revised_item_sequence_id
2608: AND eri.revised_item_id = msi.inventory_item_id
2609: AND msi.organization_id = l_org_id;

Line 2623: FROM mtl_system_items_b_kfv

2619: BEGIN
2620:
2621: /* SELECT concatenated_segments -- Commented for bug-5725081
2622: INTO l_component_item_name
2623: FROM mtl_system_items_b_kfv
2624: WHERE inventory_item_id = rc.component_item_id
2625: AND organization_id = l_org_id;
2626: */
2627:

Line 2681: FROM mtl_system_items_b_kfv MSIF ,

2677: INTO l_component_item_name,
2678: v_component_quantity_to,
2679: v_component_low_quantity,
2680: v_component_high_quantity
2681: FROM mtl_system_items_b_kfv MSIF ,
2682: mtl_system_items_b_kfv MSIT
2683: WHERE msif.inventory_item_id = msit.inventory_item_id
2684: AND msif.inventory_item_id = rc.component_item_id
2685: AND msit.organization_id = l_org_id

Line 2682: mtl_system_items_b_kfv MSIT

2678: v_component_quantity_to,
2679: v_component_low_quantity,
2680: v_component_high_quantity
2681: FROM mtl_system_items_b_kfv MSIF ,
2682: mtl_system_items_b_kfv MSIT
2683: WHERE msif.inventory_item_id = msit.inventory_item_id
2684: AND msif.inventory_item_id = rc.component_item_id
2685: AND msit.organization_id = l_org_id
2686: AND msif.organization_id = l_org_hierarchy_level_id ;

Line 2887: FROM mtl_system_items_b_kfv msi,

2883: l_item_exits_in_org_flag := 1;
2884:
2885: SELECT msi.concatenated_segments,eri.new_item_revision
2886: INTO l_revised_item_name1,l_new_item_revision
2887: FROM mtl_system_items_b_kfv msi,
2888: eng_revised_items eri,
2889: bom_inventory_components bic
2890: WHERE bic.component_sequence_id = sc.component_sequence_id
2891: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id

Line 2906: FROM mtl_system_items_b_kfv msi,

2902: SELECT concatenated_segments,bic.effectivity_date,
2903: bic.operation_seq_num
2904: INTO l_component_item_name1,l_effectivity_date,
2905: l_operation_seq_num
2906: FROM mtl_system_items_b_kfv msi,
2907: bom_inventory_components bic
2908: WHERE bic.component_sequence_id = sc.component_sequence_id
2909: AND msi.inventory_item_id = bic.component_item_id
2910: AND msi.organization_id = l_org_id;

Line 2924: FROM mtl_system_items_b_kfv

2920: v_substitute_item_quantity := 0; -- Added for bug-5725081
2921:
2922: /* SELECT concatenated_segments -- Commented for bug-5725081
2923: INTO l_substitute_component_name
2924: FROM mtl_system_items_b_kfv
2925: WHERE inventory_item_id = sc.substitute_component_id
2926: AND organization_id = l_org_id;
2927: */
2928:

Line 2943: FROM mtl_system_items_b_kfv MSIF,

2939: msit.primary_unit_of_measure)
2940: )
2941: INTO l_substitute_component_name,
2942: v_substitute_item_quantity
2943: FROM mtl_system_items_b_kfv MSIF,
2944: mtl_system_items_b_kfv MSIT
2945: WHERE msif.inventory_item_id = msit.inventory_item_id
2946: AND msif.inventory_item_id = sc.substitute_component_id
2947: AND msit.organization_id = l_org_id

Line 2944: mtl_system_items_b_kfv MSIT

2940: )
2941: INTO l_substitute_component_name,
2942: v_substitute_item_quantity
2943: FROM mtl_system_items_b_kfv MSIF,
2944: mtl_system_items_b_kfv MSIT
2945: WHERE msif.inventory_item_id = msit.inventory_item_id
2946: AND msif.inventory_item_id = sc.substitute_component_id
2947: AND msit.organization_id = l_org_id
2948: AND msif.organization_id = l_org_hierarchy_level_id;

Line 3040: FROM mtl_system_items_b_kfv msi,

3036: SELECT msi.concatenated_segments,eri.new_item_revision,
3037: bic.effectivity_date,bic.operation_seq_num
3038: INTO l_revised_item_name2,l_new_item_revision,
3039: l_effectivity_date,l_operation_seq_num
3040: FROM mtl_system_items_b_kfv msi,
3041: eng_revised_items eri,
3042: bom_inventory_components bic
3043: WHERE bic.component_sequence_id = rd.component_sequence_id
3044: AND eri.revised_item_sequence_id = bic.revised_item_sequence_id

Line 3058: FROM mtl_system_items_b_kfv msi,

3054:
3055: BEGIN
3056: SELECT concatenated_segments
3057: INTO l_component_item_name2
3058: FROM mtl_system_items_b_kfv msi,
3059: bom_inventory_components bic
3060: WHERE bic.component_sequence_id = rd.component_sequence_id
3061: AND msi.inventory_item_id = bic.component_item_id
3062: AND msi.organization_id = l_org_id;

Line 4153: FROM fnd_object_instance_sets instance_set, mtl_system_items_b item1

4149: AND NVL(grants.end_date, SYSDATE+1) >= TRUNC(SYSDATE)
4150: AND grants.instance_type= 'SET'
4151: AND grants.menu_id = cp_assignee_role_id
4152: AND grants.instance_set_id IN ( SELECT instance_set.instance_set_id
4153: FROM fnd_object_instance_sets instance_set, mtl_system_items_b item1
4154: WHERE instance_set.object_id = grants.object_id
4155: AND instance_set.instance_set_name = 'EGO_ORG_CAT_ITEM_' ||
4156: to_char(item1.organization_id) || '_' || to_char(item1.ITEM_CATALOG_GROUP_ID)
4157: AND item1.INVENTORY_ITEM_ID= cp_item_id

Line 4411: FROM mtl_system_items_b_kfv

4407: THEN
4408: BEGIN
4409: SELECT concatenated_segments
4410: INTO l_pk1_name
4411: FROM mtl_system_items_b_kfv
4412: WHERE inventory_item_id = l_pk1_value
4413: AND organization_id = p_local_organization_id;
4414: EXCEPTION
4415: WHEN NO_DATA_FOUND THEN

Line 4935: FROM mtl_system_items_b_kfv

4931: THEN
4932: -- get the item name, use up item name and plan name
4933: SELECT concatenated_segments
4934: INTO l_revised_item_number
4935: FROM mtl_system_items_b_kfv
4936: WHERE inventory_item_id = ri.revised_item_id
4937: AND organization_id = p_local_organization_id;
4938:
4939: l_use_up_item_name := null;

Line 4944: FROM mtl_system_items_b_kfv

4940: IF (ri.use_up_item_id IS NOT NULL)
4941: THEN
4942: SELECT concatenated_segments
4943: INTO l_use_up_item_name
4944: FROM mtl_system_items_b_kfv
4945: WHERE inventory_item_id = ri.use_up_item_id
4946: AND organization_id = p_local_organization_id;
4947: END IF;
4948:

Line 5088: from mtl_system_items_b_kfv msikfv, mtl_item_revisions mir

5084: IF (ri.from_end_item_rev_id IS NOT NULL)
5085: THEN
5086: select msikfv.concatenated_segments, mir.revision
5087: into l_from_end_item_name, l_from_end_item_revision
5088: from mtl_system_items_b_kfv msikfv, mtl_item_revisions mir
5089: where mir.revision_id = ri.from_end_item_rev_id
5090: and mir.inventory_item_id = msikfv.inventory_item_id
5091: and mir.organization_id = msikfv.organization_id;
5092: END IF;