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_ITEM_REVISIONS

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 290: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'

286: FROM eng_attachment_changes eac, fnd_attached_documents fad
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)

Line 355: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')

351: l_pk3_value := NULL;
352: l_local_attachment_id := -1;
353: l_return_status := FND_API.G_RET_STS_SUCCESS;
354: -- set the pk3 value if the attachment belongs to item revision
355: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')
356: THEN
357: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.new_item_revision_id'|| p_revised_item_unexp_rec.new_item_revision_id);
358: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.CURRENT_item_revision_id'|| p_revised_item_unexp_rec.CURRENT_item_revision_id);
359:

Line 364: into l_pk3_value from mtl_item_revisions

360: -- Bug : 5355614
361: -- For item attachment changes with new revisions we need to get the correct revision id (eng_attachment_changes.pk3_value)
362: BEGIN
363: select revision_id
364: into l_pk3_value from mtl_item_revisions
365: where inventory_item_id = (select revised_item_id
366: from eng_revised_items
367: where revised_item_sequence_id = p_revised_item_unexp_rec.Revised_Item_Sequence_Id)
368: and revised_item_sequence_id = p_revised_item_unexp_rec.Revised_Item_Sequence_Id;

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 786: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'

782: FROM eng_attachment_changes eac, fnd_attached_documents fad
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)

Line 854: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')

850: l_local_attachment_id := -1;
851: l_rev_mismatch := G_VAL_FALSE;
852:
853: -- set the pk3 value if the attachment belongs to item revision
854: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')
855: THEN
856: l_pk3_value := p_local_line_rev_id;
857:
858: BEGIN

Line 861: FROM MTL_ITEM_REVISIONS

857:
858: BEGIN
859: SELECT revision
860: INTO l_local_revision
861: FROM MTL_ITEM_REVISIONS
862: WHERE revision_id = p_local_line_rev_id;
863: EXCEPTION
864: WHEN NO_DATA_FOUND THEN
865: l_local_revision := NULL;

Line 892: FROM MTL_ITEM_REVISIONS

888: THEN
889: BEGIN
890: SELECT revision
891: INTO l_global_revision
892: FROM MTL_ITEM_REVISIONS
893: WHERE revision_id = p_global_current_item_rev_id;
894: EXCEPTION
895: WHEN NO_DATA_FOUND THEN
896: l_global_revision := NULL;

Line 2307: FROM mtl_item_revisions

2303: l_revised_item_tbl(i).new_revised_item_revision :=
2304: ri.new_item_revision;
2305: SELECT DESCRIPTION
2306: INTO l_rev_description
2307: FROM mtl_item_revisions
2308: WHERE inventory_item_id = ri.revised_item_id
2309: AND organization_id = ri.organization_id
2310: AND revision = ri.new_item_revision ;
2311: l_revised_item_tbl(i).New_Revised_Item_Rev_Desc :=

Line 4437: from mtl_item_revisions

4433: THEN
4434: BEGIN
4435: select revision
4436: into l_pk3_name
4437: from mtl_item_revisions
4438: where inventory_item_id = l_pk1_value
4439: AND organization_id = p_local_organization_id
4440: and revision = ( select revision
4441: from mtl_item_revisions

Line 4441: from mtl_item_revisions

4437: from mtl_item_revisions
4438: where inventory_item_id = l_pk1_value
4439: AND organization_id = p_local_organization_id
4440: and revision = ( select revision
4441: from mtl_item_revisions
4442: where revision_id = l_pk3_value);
4443: EXCEPTION
4444: WHEN NO_DATA_FOUND THEN
4445: l_return_status := FND_API.G_RET_STS_ERROR;

Line 4747: l_new_item_revision mtl_item_revisions.revision%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;
4751: l_from_end_item_alternate VARCHAR2(10);

Line 4752: l_from_end_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);
4755: l_current_lifecycle_seq NUMBER;
4756: l_current_lifecycle_name VARCHAR2(150);

Line 4764: l_rev_description mtl_item_revisions.description%type;

4760: l_status_master_controlled NUMBER;
4761: l_sql_stmt VARCHAR2(2000);
4762: l_revised_item_count NUMBER := 1;
4763: l_local_bill_sequence_id NUMBER;
4764: l_rev_description mtl_item_revisions.description%type;
4765: l_structure_exists_flag NUMBER;
4766: l_rev_item_status_type NUMBER;
4767: l_new_item_revision_exists NUMBER;
4768: l_from_end_item_minor_rev VARCHAR2(3);

Line 4986: from mtl_item_revisions

4982: THEN
4983: BEGIN
4984: select 1
4985: into l_new_revision_exists
4986: from mtl_item_revisions
4987: where revision = l_new_item_revision
4988: and inventory_item_id = ri.revised_item_id
4989: and organization_id = p_local_organization_id;
4990: EXCEPTION

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 5174: FROM mtl_item_revisions

5170: ELSE
5171: l_revised_item_tbl(l_revised_item_count).new_revised_item_revision := l_new_item_revision;
5172: SELECT DESCRIPTION
5173: INTO l_rev_description
5174: FROM mtl_item_revisions
5175: WHERE inventory_item_id = ri.revised_item_id
5176: AND organization_id = ri.organization_id
5177: AND revision = l_new_item_revision ;
5178: l_revised_item_tbl(l_revised_item_count).New_Revised_Item_Rev_Desc := l_rev_description;

Line 5320: from mtl_item_revisions

5316: -- This is the revision id to which the revision specific lines would be added
5317: BEGIN
5318: select revision_id
5319: into l_local_line_rev_id
5320: from mtl_item_revisions
5321: where inventory_item_id = (select revised_item_id
5322: from eng_revised_items
5323: where revised_item_sequence_id = l_revised_item_unexp_rec.revised_item_sequence_id)
5324: and revised_item_sequence_id = l_revised_item_unexp_rec.revised_item_sequence_id;