APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_REVISED_ITEMS

Line 1565: eng_revised_items eri,

1561: BEGIN
1562:
1563: SELECT COUNT(1) INTO l_Count
1564: FROM
1565: eng_revised_items eri,
1566: mtl_system_items_kfv msi,
1567: mtl_parameters mp
1568: WHERE
1569: eri.revised_item_id = msi.inventory_item_id AND

Line 2276: ,eng_revised_items eri

2272: --This cursor for redlining of BOM Components.
2273: Cursor c_component(p_rev_item_id NUMBER, p_component_item_id NUMBER, p_bill_sequence_id NUMBER) IS
2274: SELECT bic.effectivity_date, bic.operation_seq_num, bic.from_end_item_unit_number
2275: FROM bom_inventory_components bic
2276: ,eng_revised_items eri
2277: WHERE eri.revised_item_id = p_rev_item_id
2278: AND eri.organization_id = p_organization_id
2279: AND eri.bill_sequence_id = p_bill_sequence_id
2280: AND bic.component_item_id = p_component_item_id

Line 2286: ,eng_revised_items erj

2282: AND bic.bill_sequence_id = eri.bill_sequence_id
2283: AND bic.revised_item_sequence_id = eri.revised_item_sequence_id
2284: AND eri.implementation_date = (SELECT MAX(erj.implementation_date)
2285: FROM bom_inventory_components bcc
2286: ,eng_revised_items erj
2287: WHERE erj.revised_item_id = p_rev_item_id
2288: AND erj.organization_id = p_organization_id
2289: AND erj.bill_sequence_id = p_bill_sequence_id
2290: AND bcc.component_item_id = p_component_item_id

Line 4274: ,eng_revised_items eri

4270: ,bsc.enforce_int_requirements
4271: ,bsc.program_id
4272: FROM
4273: bom_inventory_components bic
4274: ,eng_revised_items eri
4275: ,mtl_item_flexfields mif
4276: ,bom_substitute_components bsc
4277: WHERE
4278: eri.change_id = p_change_id AND

Line 4310: ,eng_revised_items eri

4306: ,brd.attribute15
4307: ,brd.original_system_reference
4308: FROM
4309: bom_inventory_components bic
4310: ,eng_revised_items eri
4311: ,bom_reference_designators brd
4312: WHERE
4313: eri.change_id = p_change_id AND
4314: eri.revised_item_id = p_revised_item_id AND

Line 4366: ,eng_revised_items eri

4362: ,bic.unit_price
4363: ,bic.original_system_reference
4364: FROM
4365: bom_inventory_components bic
4366: ,eng_revised_items eri
4367: ,mtl_item_flexfields mif
4368: WHERE
4369: eri.change_id = p_change_id AND
4370: eri.revised_item_id = p_revised_item_id AND

Line 4435: eng_revised_items eri

4431: ,eri.revised_item_sequence_id
4432: ,eriv.revised_item_status
4433: ,eri.organization_id
4434: FROM
4435: eng_revised_items eri
4436: ,mtl_item_flexfields mif
4437: ,mtl_item_flexfields mif1
4438: ,eng_revised_items_v eriv
4439: WHERE

Line 4438: ,eng_revised_items_v eriv

4434: FROM
4435: eng_revised_items eri
4436: ,mtl_item_flexfields mif
4437: ,mtl_item_flexfields mif1
4438: ,eng_revised_items_v eriv
4439: WHERE
4440: eri.change_id = p_change_id AND
4441: mif.inventory_item_id = eri.revised_item_id AND
4442: mif.organization_id = eri.organization_id AND

Line 4471: ,eng_revised_items eri

4467: ,bev.bom_implementation_date
4468: ,bst.structure_type_name
4469: FROM
4470: bom_explosions_v bev
4471: ,eng_revised_items eri
4472: ,bom_structure_types_b bst
4473: ,mtl_system_items_vl msl
4474: WHERE
4475: eri.change_id = p_change_id AND

Line 4489: eng_Revised_items

4485: CURSOR c_change_id(p_revised_item_sequence_id IN NUMBER) IS
4486: SELECT
4487: change_id
4488: FROM
4489: eng_Revised_items
4490: WHERE
4491: revised_item_sequence_id = p_revised_item_sequence_id;
4492:
4493: BEGIN

Line 5351: FROM eng_revised_items eri

5347: AND eec.last_update_date >= l_from_date
5348: AND eec.last_update_date <= l_to_date
5349: UNION
5350: SELECT eri.change_id
5351: FROM eng_revised_items eri
5352: WHERE eri.last_update_date <> eri.creation_date
5353: AND eri.last_update_date >= l_from_date
5354: AND eri.last_update_date <= l_to_date ) eci;
5355: