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 ENG_REVISED_ITEMS

Line 366: from eng_revised_items

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;
369: EXCEPTION
370: WHEN OTHERS THEN

Line 1143: FROM eng_revised_items eri, bom_structures_b bsb

1139: IS
1140: SELECT eri.revised_item_id, eri.revised_item_sequence_id, eri.alternate_bom_designator
1141: , eri.change_notice, eri.from_end_item_rev_id, eri.from_end_item_strc_rev_id
1142: , bsb.source_bill_sequence_id, eri.bill_sequence_id
1143: FROM eng_revised_items eri, bom_structures_b bsb
1144: WHERE eri.bill_sequence_id = bsb.bill_sequence_id
1145: AND ((eri.revised_item_sequence_id = v_rev_item_seq_id
1146: AND eri.bill_sequence_id IS NOT NULL
1147: AND (eri.transfer_or_copy IS NULL

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 1179: from eng_revised_items

1175:
1176: /*CURSOR c_tolc_items
1177: IS
1178: select *
1179: from eng_revised_items
1180: where (parent_revised_item_seq_id = p_rev_item_seq_id
1181: or revised_item_sequence_id = p_rev_item_seq_id)
1182: and transfer_or_copy is not null
1183: AND revised_item_sequence_id NOT IN (SELECT revised_item_sequence_id

Line 1184: FROM eng_revised_items

1180: where (parent_revised_item_seq_id = p_rev_item_seq_id
1181: or revised_item_sequence_id = p_rev_item_seq_id)
1182: and transfer_or_copy is not null
1183: AND revised_item_sequence_id NOT IN (SELECT revised_item_sequence_id
1184: FROM eng_revised_items
1185: WHERE parent_revised_item_seq_id = p_rev_item_seq_id
1186: AND (transfer_or_copy = 'L' OR transfer_or_copy = 'O')
1187: AND 1 = p_status_master_controlled);*/
1188:

Line 1253: FROM eng_revised_items eri1

1249: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if revised item already exists in local Change');
1250:
1251: SELECT G_VAL_TRUE
1252: into l_local_revised_item_exists
1253: FROM eng_revised_items eri1
1254: WHERE eri1.change_notice = p_change_notice
1255: AND eri1.organization_id = p_local_org_id
1256: AND EXISTS
1257: (SELECT 1

Line 1258: FROM eng_revised_items eri2

1254: WHERE eri1.change_notice = p_change_notice
1255: AND eri1.organization_id = p_local_org_id
1256: AND EXISTS
1257: (SELECT 1
1258: FROM eng_revised_items eri2
1259: WHERE revised_item_sequence_id = p_rev_item_seq_id
1260: AND eri2.organization_id = p_local_org_id -- bug 10146196 added
1261: AND eri2.revised_item_id = eri1.revised_item_id
1262: AND eri2.scheduled_date = eri1.scheduled_date

Line 1849: FROM eng_revised_items

1845: ge Notice.Bug no 4327321 only revised items will get propagate.No transfer and copy items.*/
1846:
1847: CURSOR c_rev_items IS
1848: SELECT *
1849: FROM eng_revised_items
1850: WHERE change_notice = p_change_notice
1851: AND organization_id = l_org_hierarchy_level_id
1852: AND transfer_or_copy is NULL;
1853:

Line 1857: implementedfrom eng_revised_items table. These records are not present in

1853:
1854:
1855: /* cursor to pick up Revised component records for the top organization for
1856: the given change notice which have the ACD_type of Disable and have been
1857: implementedfrom eng_revised_items table. These records are not present in
1858: bom_inventory_components table hence this extra cursor. */
1859:
1860: CURSOR c_rev_comps_disable IS
1861: SELECT *

Line 1867: FROM eng_revised_items

1863: WHERE change_notice = p_change_notice
1864: AND ACD_TYPE = 3
1865: AND revised_item_sequence_id in
1866: (SELECT revised_item_sequence_id
1867: FROM eng_revised_items
1868: WHERE change_notice = p_change_notice
1869: AND organization_id = l_org_hierarchy_level_id);
1870:
1871: /* Cursor to Pick all Revised Component Items for the Top Organization for the

Line 1880: FROM eng_revised_items

1876: FROM bom_inventory_components
1877: WHERE change_notice = p_change_notice
1878: AND revised_item_sequence_id in
1879: (SELECT revised_item_sequence_id
1880: FROM eng_revised_items
1881: WHERE change_notice = p_change_notice
1882: AND organization_id = l_org_hierarchy_level_id);
1883:
1884: /* Cursor to Pick all substitute Component Items for the Top Organization for t

Line 1897: FROM eng_revised_items

1893: FROM bom_inventory_components
1894: WHERE change_notice = p_change_notice
1895: AND revised_item_sequence_id in
1896: (SELECT revised_item_sequence_id
1897: FROM eng_revised_items
1898: WHERE change_notice = p_change_notice
1899: AND organization_id = l_org_hierarchy_level_id));
1900:
1901: /* Cursor to Pick all reference designators for the Top Organization for the gi

Line 1914: FROM eng_revised_items

1910: FROM bom_inventory_components
1911: WHERE change_notice = p_change_notice
1912: AND revised_item_sequence_id in
1913: (SELECT revised_item_sequence_id
1914: FROM eng_revised_items
1915: WHERE change_notice = p_change_notice
1916: AND organization_id = l_org_hierarchy_level_id));
1917:
1918: -- Modified query for performance bug 4251776

Line 2463: eng_revised_items eri

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;
2467:

Line 2663: eng_revised_items eri

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;
2667:

Line 2956: eng_revised_items eri,

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
2960: AND eri.revised_item_id = msi.inventory_item_id

Line 3121: eng_revised_items eri,

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
3125: AND eri.revised_item_id = msi.inventory_item_id

Line 4138: UPDATE eng_revised_items

4134: FROM eng_change_statuses
4135: WHERE status_code = l_status_code
4136: AND rownum = 1;
4137: -- The following update should be moved to init lifecycle
4138: UPDATE eng_revised_items
4139: SET status_code = l_status_code,
4140: status_type = l_new_status_type,
4141: last_update_date = sysdate,
4142: last_updated_by = FND_PROFILE.VALUE('USER_ID'),

Line 4929: FROM eng_revised_items

4925: , transfer_or_copy
4926: , transfer_or_copy_item
4927: , alternate_bom_designator
4928: , revised_item_sequence_id
4929: FROM eng_revised_items
4930: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
4931:
4932: l_ris c_revised_items_data%ROWTYPE;
4933:

Line 4940: FROM eng_revised_items

4936: -- will have to be done otherwise
4937: CURSOR c_rev_items_all (cp_revised_item_sequence_id NUMBER)
4938: IS
4939: SELECT *
4940: FROM eng_revised_items
4941: WHERE (revised_item_sequence_id = cp_revised_item_sequence_id)
4942: /*OR parent_revised_item_seq_id = cp_revised_item_sequence_id)
4943: AND revised_item_sequence_id NOT IN
4944: (SELECT revised_item_sequence_id

Line 4945: FROM eng_revised_items

4941: WHERE (revised_item_sequence_id = cp_revised_item_sequence_id)
4942: /*OR parent_revised_item_seq_id = cp_revised_item_sequence_id)
4943: AND revised_item_sequence_id NOT IN
4944: (SELECT revised_item_sequence_id
4945: FROM eng_revised_items
4946: WHERE parent_revised_item_seq_id = cp_revised_item_sequence_id
4947: AND (transfer_or_copy = 'L' OR transfer_or_copy = 'O')
4948: AND 1 = l_status_master_controlled
4949: )

Line 4954: -- implemented from eng_revised_items table. These records are not present in

4950: ORDER BY parent_revised_item_seq_id DESC*/;
4951:
4952: -- Cursor to pick up Revised component records for the top organization for
4953: -- the given change notice which have the ACD_type of Disable and have been
4954: -- implemented from eng_revised_items table. These records are not present in
4955: -- bom_inventory_components table hence this extra cursor.
4956:
4957: CURSOR c_plm_rev_comps_disable (cp_revised_item_sequence_id NUMBER)
4958: IS

Line 4970: AND EXISTS (SELECT 1 FROM eng_revised_items eri

4966: AND ecpm.local_organization_id = p_local_organization_id
4967: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4968: AND ecpm.revised_line_id1 = erc.component_sequence_id
4969: AND ecpm.entity_action_status IN (3,4))
4970: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4971: WHERE eri.revised_item_sequence_id = erc.revised_item_sequence_id
4972: AND eri.bill_sequence_id = erc.bill_sequence_id);
4973:
4974:

Line 4989: AND EXISTS (SELECT 1 FROM eng_revised_items eri

4985: AND ecpm.local_organization_id = p_local_organization_id
4986: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4987: AND ecpm.revised_line_id1 = bcb.component_sequence_id
4988: AND ecpm.entity_action_status IN (3,4))
4989: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4990: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
4991: AND eri.bill_sequence_id = bcb.bill_sequence_id);
4992:
4993: BEGIN

Line 5450: from eng_revised_items

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;
5453: EXCEPTION
5454: WHEN OTHERS THEN

Line 5717: FROM eng_revised_items eri

5713: AND organization_id = p_organization_id;
5714: ---added Bug no 4327321 only revised items will get propagate.No transfer and copy items
5715: CURSOR c_prp_revised_item IS
5716: SELECT eri.revised_item_sequence_id
5717: FROM eng_revised_items eri
5718: WHERE eri.change_id = l_global_change_id
5719: AND transfer_or_copy is NULL
5720: AND NOT EXISTS
5721: (SELECT 1