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

Line 204: p_local_entity_name IN VARCHAR2 -- MTL_ITEM_REVISIONS or MTL_SYSTEM_ITEMS

200:
201: END Propagated_Local_Change;
202:
203: FUNCTION Get_local_org_attachment_id (
204: p_local_entity_name IN VARCHAR2 -- MTL_ITEM_REVISIONS or MTL_SYSTEM_ITEMS
205: , p_local_pk1_value IN VARCHAR2 -- Org_id
206: , p_local_pk2_value IN VARCHAR2 -- item id
207: , p_local_pk3_value IN VARCHAR2 -- current item_revision_id
208: , p_global_document_id IN NUMBER

Line 291: OR (eac.entity_name = 'MTL_SYSTEM_ITEMS'

287: WHERE eac.change_id = p_change_id -- 4517503
288: AND eac.revised_item_sequence_id = cp_revised_item_sequence_id
289: AND eac.attachment_id = fad.attached_document_id(+)
290: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'
291: OR (eac.entity_name = 'MTL_SYSTEM_ITEMS'
292: AND NOT EXISTS (SELECT 1 FROM MTL_PARAMETERS MP
293: WHERE MP.organization_id = g_global_org_id
294: AND MP.master_organization_id = MP.organization_id)
295: ))

Line 722: FROM MTL_ITEM_REVISIONS mir ,MTL_SYSTEM_ITEMS msi

718: SELECT 1
719: FROM (SELECT nvl(mir.lifecycle_id,msi.lifecycle_id) lifecycle_id,
720: nvl(mir.current_phase_id,msi.current_phase_id) current_phase_id, msi.item_catalog_group_id,
721: mir.inventory_item_id, mir.organization_id
722: FROM MTL_ITEM_REVISIONS mir ,MTL_SYSTEM_ITEMS msi
723: WHERE mir.INVENTORY_ITEM_ID = p_inventory_item_id
724: AND mir.ORGANIZATION_ID = p_organization_id
725: AND mir.revision_id = p_revision_id
726: AND msi.INVENTORY_ITEM_ID = mir.INVENTORY_ITEM_ID

Line 787: OR (eac.entity_name = 'MTL_SYSTEM_ITEMS'

783: WHERE eac.change_id = p_change_id
784: AND eac.revised_item_sequence_id = p_rev_item_sequence_id
785: AND eac.attachment_id = fad.attached_document_id(+)
786: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'
787: OR (eac.entity_name = 'MTL_SYSTEM_ITEMS'
788: AND NOT EXISTS (SELECT 1 FROM MTL_PARAMETERS MP
789: WHERE MP.organization_id = p_global_organization_id
790: AND MP.master_organization_id = MP.organization_id)
791: ))

Line 804: AND eac.entity_name = 'MTL_SYSTEM_ITEMS'

800: SELECT 1
801: FROM eng_attachment_changes eac
802: WHERE eac.change_id = p_change_id
803: AND eac.revised_item_sequence_id = p_rev_item_sequence_id
804: AND eac.entity_name = 'MTL_SYSTEM_ITEMS'
805: AND EXISTS(SELECT 1 FROM MTL_PARAMETERS MP
806: WHERE MP.organization_id = p_global_organization_id
807: AND MP.master_organization_id = MP.organization_id)
808: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm

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 1196: l_revised_item_number mtl_system_items_kfv.concatenated_segments%TYPE;

1192:
1193: l_use_up_item_exists NUMBER;
1194: l_item_sourced_flag NUMBER := 2;
1195: l_structure_exists_flag NUMBER;
1196: l_revised_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
1197: l_common_bom_flag NUMBER;
1198: l_local_bill_sequence_id NUMBER;
1199: l_comn_bill_sequence_id NUMBER;
1200: l_eng_bill_flag NUMBER;

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 1370: FROM mtl_system_items

1366: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Check if use up item Exists');
1367: BEGIN
1368: SELECT 1
1369: INTO l_use_up_item_exists
1370: FROM mtl_system_items
1371: WHERE inventory_item_id = p_use_up_item_id
1372: AND organization_id = p_local_org_id;
1373: EXCEPTION
1374: WHEN NO_DATA_FOUND THEN

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 3327: l_component_item_name mtl_system_items_vl.concatenated_segments%type;

3323: l_rev_component_count NUMBER := 1;
3324: l_sub_component_count NUMBER := 1;
3325: l_ref_designator_count NUMBER := 1;
3326:
3327: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3328: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3329: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3330: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3331: l_new_item_revision VARCHAR2(3);

Line 3329: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;

3325: l_ref_designator_count NUMBER := 1;
3326:
3327: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3328: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3329: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3330: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3331: l_new_item_revision VARCHAR2(3);
3332: l_effectivity_date DATE;
3333: st_number NUMBER;

Line 3330: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;

3326:
3327: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3328: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3329: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3330: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3331: l_new_item_revision VARCHAR2(3);
3332: l_effectivity_date DATE;
3333: st_number NUMBER;
3334: item_id NUMBER;

Line 3405: FROM mtl_system_items_kfv

3401: AND component_sequence_id = p_component_sequence_id;
3402:
3403: CURSOR c_get_item_details(cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
3404: SELECT concatenated_segments
3405: FROM mtl_system_items_kfv
3406: WHERE inventory_item_id = cp_inventory_item_id
3407: AND organization_id = cp_organization_id;
3408: BEGIN
3409: -- Initialize this API for error handling

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 4709: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

4705: IS
4706: CURSOR c_status_control_attribute IS
4707: SELECT control_level
4708: FROM MTL_ITEM_ATTRIBUTES
4709: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
4710: BEGIN
4711:
4712: IF G_STATUS_CONTROL_LEVEL IS NULL
4713: THEN

Line 4742: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4738: l_sourcing_rules_exists NUMBER;
4739: --l_propagated_rev_items_tbl Prop_Rev_Items_Tbl_Type;
4740: --l_prop_rev_items_count NUMBER;
4741: l_propagate_revised_item NUMBER;
4742: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4743: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4744: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4745: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 4744: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;

4740: --l_prop_rev_items_count NUMBER;
4741: l_propagate_revised_item NUMBER;
4742: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4743: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4744: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4745: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4747: l_new_item_revision mtl_item_revisions.revision%TYPE;
4748: l_new_struc_revision VARCHAR2(3);

Line 4745: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4741: l_propagate_revised_item NUMBER;
4742: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4743: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4744: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4745: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4747: l_new_item_revision mtl_item_revisions.revision%TYPE;
4748: l_new_struc_revision VARCHAR2(3);
4749: l_current_struc_revision VARCHAR2(3);

Line 4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4742: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4743: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4744: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4745: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4747: l_new_item_revision mtl_item_revisions.revision%TYPE;
4748: l_new_struc_revision VARCHAR2(3);
4749: l_current_struc_revision VARCHAR2(3);
4750: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 4750: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4746: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4747: l_new_item_revision mtl_item_revisions.revision%TYPE;
4748: l_new_struc_revision VARCHAR2(3);
4749: l_current_struc_revision VARCHAR2(3);
4750: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4751: l_from_end_item_alternate VARCHAR2(10);
4752: l_from_end_item_revision mtl_item_revisions.revision%TYPE;
4753: l_current_local_revision_id NUMBER;
4754: l_current_local_revision VARCHAR2(3);

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;

Line 5112: || 'FROM pa_ego_phases_v LP, MTL_System_items_vl msiv '

5108: BEGIN
5109: -- Bug 3311072: Made the query dynamic
5110: -- Modified By LKASTURI
5111: l_sql_stmt := 'SELECT LP.DISPLAY_SEQUENCE, LP.NAME '
5112: || 'FROM pa_ego_phases_v LP, MTL_System_items_vl msiv '
5113: || 'WHERE LP.PROJ_ELEMENT_ID = msiv.CURRENT_PHASE_ID '
5114: || 'AND msiv.INVENTORY_ITEM_ID = :1 '
5115: || 'AND msiv.ORGANIZATION_ID = :2 ';
5116: -- End Changes 3311072