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.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_REVISED_ITEMS

Line 2193: eng_revised_items eri,

2189: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');
2190: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' REVISION: '|| p_revision || ' ORG CODE: '|| p_org_code);
2191: SELECT COUNT(1) INTO l_Count
2192: FROM
2193: eng_revised_items eri,
2194: mtl_system_items_kfv msi,
2195: mtl_parameters mp
2196: WHERE
2197: eri.revised_item_id = msi.inventory_item_id AND

Line 2959: ,eng_revised_items eri

2955: -- This is added as part of Bug 10423301
2956: Cursor c_unimplemented_component(p_rev_item_id NUMBER, p_component_item_id NUMBER, p_bill_sequence_id NUMBER) IS
2957: SELECT bic.effectivity_date, bic.operation_seq_num, bic.from_end_item_unit_number
2958: FROM bom_inventory_components bic
2959: ,eng_revised_items eri
2960: WHERE eri.revised_item_id = p_rev_item_id
2961: AND eri.organization_id = p_organization_id
2962: AND eri.bill_sequence_id = p_bill_sequence_id
2963: AND bic.component_item_id = p_component_item_id

Line 2969: ,eng_revised_items erj

2965: AND bic.bill_sequence_id = eri.bill_sequence_id
2966: AND bic.revised_item_sequence_id = eri.revised_item_sequence_id
2967: AND eri.scheduled_date = (SELECT MAX(erj.scheduled_date)
2968: FROM bom_inventory_components bcc
2969: ,eng_revised_items erj
2970: WHERE erj.revised_item_id = p_rev_item_id
2971: AND erj.organization_id = p_organization_id
2972: AND erj.bill_sequence_id = p_bill_sequence_id
2973: AND bcc.component_item_id = p_component_item_id

Line 2986: ,eng_revised_items eri

2982: --This cursor is for redlining of Implemented BOM Components.
2983: Cursor c_implemented_component(p_rev_item_id NUMBER, p_component_item_id NUMBER, p_bill_sequence_id NUMBER) IS
2984: SELECT bic.effectivity_date, bic.operation_seq_num, bic.from_end_item_unit_number
2985: FROM bom_inventory_components bic
2986: ,eng_revised_items eri
2987: WHERE eri.revised_item_id = p_rev_item_id
2988: AND eri.organization_id = p_organization_id
2989: AND eri.bill_sequence_id = p_bill_sequence_id
2990: AND bic.component_item_id = p_component_item_id

Line 2996: ,eng_revised_items erj

2992: AND bic.bill_sequence_id = eri.bill_sequence_id
2993: AND bic.revised_item_sequence_id = eri.revised_item_sequence_id
2994: AND eri.implementation_date = (SELECT MAX(erj.implementation_date)
2995: FROM bom_inventory_components bcc
2996: ,eng_revised_items erj
2997: WHERE erj.revised_item_id = p_rev_item_id
2998: AND erj.organization_id = p_organization_id
2999: AND erj.bill_sequence_id = p_bill_sequence_id
3000: AND bcc.component_item_id = p_component_item_id

Line 3127: FROM eng_revised_items

3123:
3124: IF(l_eco_exist <> FND_API.G_TRUE AND p_bom_update_without_eco = FND_API.G_TRUE) THEN
3125:
3126: /*SELECT COUNT(1) INTO l_count
3127: FROM eng_revised_items
3128: WHERE revised_item_id = l_assembly_item_id
3129: AND organization_id = p_organization_id;*/ -- Commented this query for Bug 9527466
3130:
3131: /*Above query was returning a row if item has Change Order associated,but we need

Line 3138: FROM eng_revised_items eri,

3134: INV_EBI_UTIL.debug_line('STEP 110:BOM exists without Change Order and p_bom_update_without_eco ' || p_bom_update_without_eco);
3135:
3136: --Start of Bug 9527466
3137: SELECT COUNT(1) INTO l_count
3138: FROM eng_revised_items eri,
3139: bom_inventory_components bic
3140: WHERE eri.revised_item_id = l_assembly_item_id
3141: AND eri.organization_id = p_organization_id
3142: AND eri.bill_sequence_id = l_bill_sequence_id

Line 5217: ,eng_revised_items eri

5213: ,bsc.enforce_int_requirements
5214: ,bsc.program_id
5215: FROM
5216: bom_inventory_components bic
5217: ,eng_revised_items eri
5218: ,mtl_item_flexfields mif
5219: ,bom_substitute_components bsc
5220: WHERE
5221: eri.change_id = p_change_id AND

Line 5253: ,eng_revised_items eri

5249: ,brd.attribute15
5250: ,brd.original_system_reference
5251: FROM
5252: bom_inventory_components bic
5253: ,eng_revised_items eri
5254: ,bom_reference_designators brd
5255: WHERE
5256: eri.change_id = p_change_id AND
5257: eri.revised_item_id = p_revised_item_id AND

Line 5309: ,eng_revised_items eri

5305: ,bic.unit_price
5306: ,bic.original_system_reference
5307: FROM
5308: bom_inventory_components bic
5309: ,eng_revised_items eri
5310: ,mtl_item_flexfields mif
5311: WHERE
5312: eri.change_id = p_change_id AND
5313: eri.revised_item_id = p_revised_item_id AND

Line 5378: eng_revised_items eri

5374: ,eri.revised_item_sequence_id
5375: ,eriv.revised_item_status
5376: ,eri.organization_id
5377: FROM
5378: eng_revised_items eri
5379: ,mtl_item_flexfields mif
5380: ,mtl_item_flexfields mif1
5381: ,eng_revised_items_v eriv
5382: WHERE

Line 5381: ,eng_revised_items_v eriv

5377: FROM
5378: eng_revised_items eri
5379: ,mtl_item_flexfields mif
5380: ,mtl_item_flexfields mif1
5381: ,eng_revised_items_v eriv
5382: WHERE
5383: eri.change_id = p_change_id AND
5384: mif.inventory_item_id = eri.revised_item_id AND
5385: mif.organization_id = eri.organization_id AND

Line 5414: ,eng_revised_items eri

5410: ,bev.bom_implementation_date
5411: ,bst.structure_type_name
5412: FROM
5413: bom_explosions_v bev
5414: ,eng_revised_items eri
5415: ,bom_structure_types_vl bst
5416: ,mtl_system_items_vl msl
5417: WHERE
5418: eri.change_id = p_change_id AND

Line 5432: eng_Revised_items

5428: CURSOR c_change_id(p_revised_item_sequence_id IN NUMBER) IS
5429: SELECT
5430: change_id
5431: FROM
5432: eng_Revised_items
5433: WHERE
5434: revised_item_sequence_id = p_revised_item_sequence_id;
5435:
5436: BEGIN

Line 6320: FROM eng_revised_items eri

6316: AND eec.last_update_date >= l_from_date
6317: AND eec.last_update_date <= l_to_date
6318: UNION
6319: SELECT eri.change_id
6320: FROM eng_revised_items eri
6321: WHERE eri.last_update_date <> eri.creation_date
6322: AND eri.last_update_date >= l_from_date
6323: AND eri.last_update_date <= l_to_date ) eci;
6324: