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

Line 96: ENG_REVISED_ITEMS_PKG.Get_High_Rev_ECO

92:
93: IF l_item_rev IS NOT NULL
94: THEN
95: l_change_notice :=
96: ENG_REVISED_ITEMS_PKG.Get_High_Rev_ECO
97: ( X_Organization_Id => p_organization_id
98: , X_Revised_Item_Id => p_revised_item_id
99: , X_New_Item_Revision => l_item_rev
100: );

Line 130: FROM ENG_REVISED_ITEMS

126: , p_revised_item_id NUMBER
127: , p_new_routing_revision VARCHAR2 )
128: IS
129: SELECT change_notice
130: FROM ENG_REVISED_ITEMS
131: WHERE cancellation_date IS NULL
132: AND implementation_date IS NULL -- Added for bug 3598711, Query to fetch un-implemented ECOs only.
133: AND revised_item_id = p_revised_item_id
134: AND new_routing_revision = p_new_routing_revision

Line 767: FROM ENG_REVISED_ITEMS

763: RETURN BOOLEAN
764: IS
765: CURSOR c_CheckPendingECO
766: IS SELECT 1
767: FROM ENG_REVISED_ITEMS
768: WHERE implementation_date IS NULL
769: AND cancellation_date IS NULL
770: AND change_notice <> p_change_notice
771: AND revised_item_id = p_revised_item_id

Line 1810: FROM ENG_REVISED_ITEMS eri

1806: )
1807: IS
1808:
1809: SELECT 'Rev Item is only Eco for altenate routing'
1810: FROM ENG_REVISED_ITEMS eri
1811: , BOM_OPERATIONAL_ROUTINGS bor
1812: WHERE bor.alternate_routing_designator IS NOT NULL
1813: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
1814: AND eri.routing_sequence_id IS NOT NULL

Line 1993: FROM ENG_REVISED_ITEMS eri

1989: IS
1990:
1991:
1992: SELECT 'Rev Item is only Eco for altenate routing'
1993: FROM ENG_REVISED_ITEMS eri
1994: , BOM_BILL_OF_MATERIALS bom
1995: WHERE bom.alternate_bom_designator IS NOT NULL
1996: AND eri.bill_sequence_id = bom.bill_sequence_id(+)
1997: AND eri.bill_sequence_id IS NOT NULL

Line 2156: FROM eng_revised_items

2152: l_message_name VARCHAR2(80);
2153:
2154: CURSOR CheckDupUnit IS
2155: SELECT 'x'
2156: FROM eng_revised_items
2157: WHERE revised_item_id = p_rev_item_unexp_rec.revised_item_id
2158: AND from_end_item_unit_number = p_revised_item_rec.From_End_Item_Unit_Number
2159: AND revised_item_sequence_id <> NVL(p_rev_item_unexp_rec.revised_item_sequence_id,0)
2160: AND change_notice = p_revised_item_rec.eco_name;

Line 2164: FROM eng_revised_items

2160: AND change_notice = p_revised_item_rec.eco_name;
2161:
2162: CURSOR CheckDupDateUnit IS
2163: SELECT 'x'
2164: FROM eng_revised_items
2165: WHERE revised_item_id = p_rev_item_unexp_rec.revised_item_id
2166: AND from_end_item_unit_number = NVL(p_revised_item_rec.New_From_End_Item_Unit_Number,
2167: (NVL(p_revised_item_rec.From_End_Item_Unit_Number,
2168: FND_API.G_MISS_NUM)))

Line 5996: FROM ENG_REVISED_ITEMS itm,

5992: Revision from Change Order. */
5993:
5994: CURSOR allow_delete_rev IS
5995: SELECT 1
5996: FROM ENG_REVISED_ITEMS itm,
5997: ENG_REVISED_ITEMS sitm
5998: WHERE itm.REVISED_ITEM_ID = sitm.REVISED_ITEM_ID
5999: AND itm.ORGANIZATION_ID = sitm.ORGANIZATION_ID
6000: AND sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id

Line 5997: ENG_REVISED_ITEMS sitm

5993:
5994: CURSOR allow_delete_rev IS
5995: SELECT 1
5996: FROM ENG_REVISED_ITEMS itm,
5997: ENG_REVISED_ITEMS sitm
5998: WHERE itm.REVISED_ITEM_ID = sitm.REVISED_ITEM_ID
5999: AND itm.ORGANIZATION_ID = sitm.ORGANIZATION_ID
6000: AND sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
6001: AND itm.STATUS_TYPE not in (5, 6)

Line 6007: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb

6003: OR itm.FROM_END_ITEM_REV_ID = sitm.new_item_revision_id)
6004: AND (sitm.CURRENT_ITEM_REVISION_ID<>sitm.NEW_ITEM_REVISION_ID)
6005: UNION ALL
6006: SELECT 1
6007: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb
6008: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
6009: AND bsb.assembly_item_id = sitm.revised_item_id
6010: AND bsb.organization_id = sitm.organization_id
6011: AND EXISTS ( SELECT 1

Line 6019: FROM eng_revised_items sitm

6015: OR bic.TO_END_ITEM_REV_ID = sitm.new_item_revision_id
6016: ))
6017: UNION ALL
6018: SELECT 1
6019: FROM eng_revised_items sitm
6020: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
6021: AND EXISTS ( SELECT 1
6022: FROM BOM_COMPONENTS_B bic
6023: WHERE bic.component_item_id = sitm.revised_item_id and

Line 6492: FROM eng_revised_items

6488: l_is_item_unit_controlled BOOLEAN := FALSE;
6489:
6490: CURSOR c_CheckRevisedItem IS
6491: SELECT status_type
6492: FROM eng_revised_items
6493: WHERE revised_item_id = p_revised_item_id
6494: AND organization_id = p_organization_id --* Added for Bug 5174223
6495: AND change_notice = p_change_notice
6496: AND NVL(from_end_item_unit_number, 'NONE')

Line 7355: FROM eng_revised_items

7351: , l_old_revised_item_rec.routing_comment
7352: , l_old_revised_item_rec.eco_for_production
7353: , l_old_rev_item_unexp_rec.change_id
7354: , l_old_rev_item_unexp_rec.status_code
7355: FROM eng_revised_items
7356: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
7357: EXCEPTION
7358: WHEN NO_DATA_FOUND THEN
7359: null;