DBA Data[Home] [Help]

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

2355: l_revised_item_tbl(i).new_revised_item_revision :=
2356: ri.new_item_revision;
2357: SELECT DESCRIPTION
2358: INTO l_rev_description
2359: FROM mtl_item_revisions
2360: WHERE inventory_item_id = ri.revised_item_id
2361: AND organization_id = ri.organization_id
2362: AND revision = ri.new_item_revision ;
2363: l_revised_item_tbl(i).New_Revised_Item_Rev_Desc :=

Line 4562: from mtl_item_revisions

4558: THEN
4559: BEGIN
4560: select revision
4561: into l_pk3_name
4562: from mtl_item_revisions
4563: where inventory_item_id = l_pk1_value
4564: AND organization_id = p_local_organization_id
4565: and revision = ( select revision
4566: from mtl_item_revisions

Line 4566: from mtl_item_revisions

4562: from mtl_item_revisions
4563: where inventory_item_id = l_pk1_value
4564: AND organization_id = p_local_organization_id
4565: and revision = ( select revision
4566: from mtl_item_revisions
4567: where revision_id = l_pk3_value);
4568: EXCEPTION
4569: WHEN NO_DATA_FOUND THEN
4570: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4878: l_from_end_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);
4881: l_current_lifecycle_seq NUMBER;
4882: l_current_lifecycle_name VARCHAR2(150);

Line 4890: l_rev_description mtl_item_revisions.description%type;

4886: l_status_master_controlled NUMBER;
4887: l_sql_stmt VARCHAR2(2000);
4888: l_revised_item_count NUMBER := 1;
4889: l_local_bill_sequence_id NUMBER;
4890: l_rev_description mtl_item_revisions.description%type;
4891: l_rev_label mtl_item_revisions.revision_label%type; -- Fixed bug10255737, can update revision label correctly
4892: l_structure_exists_flag NUMBER;
4893: l_rev_item_status_type NUMBER;
4894: l_new_item_revision_exists NUMBER;

Line 4891: l_rev_label mtl_item_revisions.revision_label%type; -- Fixed bug10255737, can update revision label correctly

4887: l_sql_stmt VARCHAR2(2000);
4888: l_revised_item_count NUMBER := 1;
4889: l_local_bill_sequence_id NUMBER;
4890: l_rev_description mtl_item_revisions.description%type;
4891: l_rev_label mtl_item_revisions.revision_label%type; -- Fixed bug10255737, can update revision label correctly
4892: l_structure_exists_flag NUMBER;
4893: l_rev_item_status_type NUMBER;
4894: l_new_item_revision_exists NUMBER;
4895: l_from_end_item_minor_rev VARCHAR2(3);

Line 5113: from mtl_item_revisions

5109: THEN
5110: BEGIN
5111: select 1
5112: into l_new_revision_exists
5113: from mtl_item_revisions
5114: where revision = l_new_item_revision
5115: and inventory_item_id = ri.revised_item_id
5116: and organization_id = p_local_organization_id;
5117: EXCEPTION

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

5297: ELSE
5298: l_revised_item_tbl(l_revised_item_count).new_revised_item_revision := l_new_item_revision;
5299: SELECT DESCRIPTION, revision_label
5300: INTO l_rev_description, l_rev_label
5301: FROM mtl_item_revisions
5302: WHERE inventory_item_id = ri.revised_item_id
5303: AND organization_id = ri.organization_id
5304: AND revision = l_new_item_revision ;
5305: l_revised_item_tbl(l_revised_item_count).New_Revised_Item_Rev_Desc := l_rev_description;

Line 5448: from mtl_item_revisions

5444: -- This is the revision id to which the revision specific lines would be added
5445: BEGIN
5446: select revision_id
5447: into l_local_line_rev_id
5448: from mtl_item_revisions
5449: where inventory_item_id = (select revised_item_id
5450: from eng_revised_items
5451: where revised_item_sequence_id = l_revised_item_unexp_rec.revised_item_sequence_id)
5452: and revised_item_sequence_id = l_revised_item_unexp_rec.revised_item_sequence_id;