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 1251: FROM eng_revised_items eri1

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

Line 1256: FROM eng_revised_items eri2

1252: WHERE eri1.change_notice = p_change_notice
1253: AND eri1.organization_id = p_local_org_id
1254: AND EXISTS
1255: (SELECT 1
1256: FROM eng_revised_items eri2
1257: WHERE revised_item_sequence_id = p_rev_item_seq_id
1258: AND eri2.revised_item_id = eri1.revised_item_id
1259: AND eri2.scheduled_date = eri1.scheduled_date
1260: AND NVL(eri2.alternate_bom_designator, 'primary') = NVL(eri1.alternate_bom_designator, 'primary'))

Line 1830: FROM eng_revised_items

1826: ge Notice.Bug no 4327321 only revised items will get propagate.No transfer and copy items.*/
1827:
1828: CURSOR c_rev_items IS
1829: SELECT *
1830: FROM eng_revised_items
1831: WHERE change_notice = p_change_notice
1832: AND organization_id = l_org_hierarchy_level_id
1833: AND transfer_or_copy is NULL;
1834:

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

1834:
1835:
1836: /* cursor to pick up Revised component records for the top organization for
1837: the given change notice which have the ACD_type of Disable and have been
1838: implementedfrom eng_revised_items table. These records are not present in
1839: bom_inventory_components table hence this extra cursor. */
1840:
1841: CURSOR c_rev_comps_disable IS
1842: SELECT *

Line 1848: FROM eng_revised_items

1844: WHERE change_notice = p_change_notice
1845: AND ACD_TYPE = 3
1846: AND revised_item_sequence_id in
1847: (SELECT revised_item_sequence_id
1848: FROM eng_revised_items
1849: WHERE change_notice = p_change_notice
1850: AND organization_id = l_org_hierarchy_level_id);
1851:
1852: /* Cursor to Pick all Revised Component Items for the Top Organization for the

Line 1861: FROM eng_revised_items

1857: FROM bom_inventory_components
1858: WHERE change_notice = p_change_notice
1859: AND revised_item_sequence_id in
1860: (SELECT revised_item_sequence_id
1861: FROM eng_revised_items
1862: WHERE change_notice = p_change_notice
1863: AND organization_id = l_org_hierarchy_level_id);
1864:
1865: /* Cursor to Pick all substitute Component Items for the Top Organization for t

Line 1878: FROM eng_revised_items

1874: FROM bom_inventory_components
1875: WHERE change_notice = p_change_notice
1876: AND revised_item_sequence_id in
1877: (SELECT revised_item_sequence_id
1878: FROM eng_revised_items
1879: WHERE change_notice = p_change_notice
1880: AND organization_id = l_org_hierarchy_level_id));
1881:
1882: /* Cursor to Pick all reference designators for the Top Organization for the gi

Line 1895: FROM eng_revised_items

1891: FROM bom_inventory_components
1892: WHERE change_notice = p_change_notice
1893: AND revised_item_sequence_id in
1894: (SELECT revised_item_sequence_id
1895: FROM eng_revised_items
1896: WHERE change_notice = p_change_notice
1897: AND organization_id = l_org_hierarchy_level_id));
1898:
1899: -- Modified query for performance bug 4251776

Line 2412: eng_revised_items eri

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

Line 2606: eng_revised_items eri

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

Line 2888: eng_revised_items eri,

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

Line 3041: eng_revised_items eri,

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

Line 4013: UPDATE eng_revised_items

4009: FROM eng_change_statuses
4010: WHERE status_code = l_status_code
4011: AND rownum = 1;
4012: -- The following update should be moved to init lifecycle
4013: UPDATE eng_revised_items
4014: SET status_code = l_status_code,
4015: status_type = l_new_status_type,
4016: last_update_date = sysdate,
4017: last_updated_by = FND_PROFILE.VALUE('USER_ID'),

Line 4802: FROM eng_revised_items

4798: , transfer_or_copy
4799: , transfer_or_copy_item
4800: , alternate_bom_designator
4801: , revised_item_sequence_id
4802: FROM eng_revised_items
4803: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
4804:
4805: l_ris c_revised_items_data%ROWTYPE;
4806:

Line 4813: FROM eng_revised_items

4809: -- will have to be done otherwise
4810: CURSOR c_rev_items_all (cp_revised_item_sequence_id NUMBER)
4811: IS
4812: SELECT *
4813: FROM eng_revised_items
4814: WHERE (revised_item_sequence_id = cp_revised_item_sequence_id)
4815: /*OR parent_revised_item_seq_id = cp_revised_item_sequence_id)
4816: AND revised_item_sequence_id NOT IN
4817: (SELECT revised_item_sequence_id

Line 4818: FROM eng_revised_items

4814: WHERE (revised_item_sequence_id = cp_revised_item_sequence_id)
4815: /*OR parent_revised_item_seq_id = cp_revised_item_sequence_id)
4816: AND revised_item_sequence_id NOT IN
4817: (SELECT revised_item_sequence_id
4818: FROM eng_revised_items
4819: WHERE parent_revised_item_seq_id = cp_revised_item_sequence_id
4820: AND (transfer_or_copy = 'L' OR transfer_or_copy = 'O')
4821: AND 1 = l_status_master_controlled
4822: )

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

4823: ORDER BY parent_revised_item_seq_id DESC*/;
4824:
4825: -- Cursor to pick up Revised component records for the top organization for
4826: -- the given change notice which have the ACD_type of Disable and have been
4827: -- implemented from eng_revised_items table. These records are not present in
4828: -- bom_inventory_components table hence this extra cursor.
4829:
4830: CURSOR c_plm_rev_comps_disable (cp_revised_item_sequence_id NUMBER)
4831: IS

Line 4843: AND EXISTS (SELECT 1 FROM eng_revised_items eri

4839: AND ecpm.local_organization_id = p_local_organization_id
4840: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4841: AND ecpm.revised_line_id1 = erc.component_sequence_id
4842: AND ecpm.entity_action_status IN (3,4))
4843: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4844: WHERE eri.revised_item_sequence_id = erc.revised_item_sequence_id
4845: AND eri.bill_sequence_id = erc.bill_sequence_id);
4846:
4847:

Line 4862: AND EXISTS (SELECT 1 FROM eng_revised_items eri

4858: AND ecpm.local_organization_id = p_local_organization_id
4859: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4860: AND ecpm.revised_line_id1 = bcb.component_sequence_id
4861: AND ecpm.entity_action_status IN (3,4))
4862: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4863: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
4864: AND eri.bill_sequence_id = bcb.bill_sequence_id);
4865:
4866: BEGIN

Line 5322: from eng_revised_items

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;
5325: EXCEPTION
5326: WHEN OTHERS THEN

Line 5576: FROM eng_revised_items eri

5572: AND organization_id = p_organization_id;
5573: ---added Bug no 4327321 only revised items will get propagate.No transfer and copy items
5574: CURSOR c_prp_revised_item IS
5575: SELECT eri.revised_item_sequence_id
5576: FROM eng_revised_items eri
5577: WHERE eri.change_id = l_global_change_id
5578: AND transfer_or_copy is NULL
5579: AND NOT EXISTS
5580: (SELECT 1