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

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

Line 1574: FROM mtl_system_items_b

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

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

3448: l_rev_component_count NUMBER := 1;
3449: l_sub_component_count NUMBER := 1;
3450: l_ref_designator_count NUMBER := 1;
3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);

Line 3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;

3450: l_ref_designator_count NUMBER := 1;
3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);
3457: l_effectivity_date DATE;
3458: st_number NUMBER;

Line 3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;

3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);
3457: l_effectivity_date DATE;
3458: st_number NUMBER;
3459: item_id NUMBER;

Line 3530: FROM mtl_system_items_kfv

3526: AND component_sequence_id = p_component_sequence_id;
3527:
3528: CURSOR c_get_item_details(cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
3529: SELECT concatenated_segments
3530: FROM mtl_system_items_kfv
3531: WHERE inventory_item_id = cp_inventory_item_id
3532: AND organization_id = cp_organization_id;
3533: BEGIN
3534: -- Initialize this API for error handling

Line 4278: FROM fnd_object_instance_sets instance_set, mtl_system_items_b item1

4274: AND NVL(grants.end_date, SYSDATE+1) >= TRUNC(SYSDATE)
4275: AND grants.instance_type= 'SET'
4276: AND grants.menu_id = cp_assignee_role_id
4277: AND grants.instance_set_id IN ( SELECT instance_set.instance_set_id
4278: FROM fnd_object_instance_sets instance_set, mtl_system_items_b item1
4279: WHERE instance_set.object_id = grants.object_id
4280: AND instance_set.instance_set_name = 'EGO_ORG_CAT_ITEM_' ||
4281: to_char(item1.organization_id) || '_' || to_char(item1.ITEM_CATALOG_GROUP_ID)
4282: AND item1.INVENTORY_ITEM_ID= cp_item_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 4835: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

4831: IS
4832: CURSOR c_status_control_attribute IS
4833: SELECT control_level
4834: FROM MTL_ITEM_ATTRIBUTES
4835: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
4836: BEGIN
4837:
4838: IF G_STATUS_CONTROL_LEVEL IS NULL
4839: THEN

Line 4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4864: l_sourcing_rules_exists NUMBER;
4865: --l_propagated_rev_items_tbl Prop_Rev_Items_Tbl_Type;
4866: --l_prop_rev_items_count NUMBER;
4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;

4866: --l_prop_rev_items_count NUMBER;
4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);

Line 4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);
4875: l_current_struc_revision VARCHAR2(3);

Line 4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);
4875: l_current_struc_revision VARCHAR2(3);
4876: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 4876: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);
4875: l_current_struc_revision VARCHAR2(3);
4876: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4877: l_from_end_item_alternate VARCHAR2(10);
4878: l_from_end_item_revision mtl_item_revisions.revision%TYPE;
4879: l_current_local_revision_id NUMBER;
4880: l_current_local_revision VARCHAR2(3);

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;

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

5235: BEGIN
5236: -- Bug 3311072: Made the query dynamic
5237: -- Modified By LKASTURI
5238: l_sql_stmt := 'SELECT LP.DISPLAY_SEQUENCE, LP.NAME '
5239: || 'FROM pa_ego_phases_v LP, MTL_System_items_vl msiv '
5240: || 'WHERE LP.PROJ_ELEMENT_ID = msiv.CURRENT_PHASE_ID '
5241: || 'AND msiv.INVENTORY_ITEM_ID = :1 '
5242: || 'AND msiv.ORGANIZATION_ID = :2 ';
5243: -- End Changes 3311072