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 1738: FROM ENG_REVISED_ITEMS eri

1734: )
1735: IS
1736:
1737: SELECT 'Rev Item is only Eco for altenate routing'
1738: FROM ENG_REVISED_ITEMS eri
1739: , BOM_OPERATIONAL_ROUTINGS bor
1740: WHERE bor.alternate_routing_designator IS NOT NULL
1741: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
1742: AND eri.routing_sequence_id IS NOT NULL

Line 1921: FROM ENG_REVISED_ITEMS eri

1917: IS
1918:
1919:
1920: SELECT 'Rev Item is only Eco for altenate routing'
1921: FROM ENG_REVISED_ITEMS eri
1922: , BOM_BILL_OF_MATERIALS bom
1923: WHERE bom.alternate_bom_designator IS NOT NULL
1924: AND eri.bill_sequence_id = bom.bill_sequence_id(+)
1925: AND eri.bill_sequence_id IS NOT NULL

Line 2084: FROM eng_revised_items

2080: l_message_name VARCHAR2(80);
2081:
2082: CURSOR CheckDupUnit IS
2083: SELECT 'x'
2084: FROM eng_revised_items
2085: WHERE revised_item_id = p_rev_item_unexp_rec.revised_item_id
2086: AND from_end_item_unit_number = p_revised_item_rec.From_End_Item_Unit_Number
2087: AND revised_item_sequence_id <> NVL(p_rev_item_unexp_rec.revised_item_sequence_id,0)
2088: AND change_notice = p_revised_item_rec.eco_name;

Line 2092: FROM eng_revised_items

2088: AND change_notice = p_revised_item_rec.eco_name;
2089:
2090: CURSOR CheckDupDateUnit IS
2091: SELECT 'x'
2092: FROM eng_revised_items
2093: WHERE revised_item_id = p_rev_item_unexp_rec.revised_item_id
2094: AND from_end_item_unit_number = NVL(p_revised_item_rec.New_From_End_Item_Unit_Number,
2095: (NVL(p_revised_item_rec.From_End_Item_Unit_Number,
2096: FND_API.G_MISS_NUM)))

Line 5911: FROM ENG_REVISED_ITEMS itm,

5907: -- Checking for additional references when removing the 'New Revision'
5908: -- Bug 4946817: Fixed performance issues
5909: CURSOR allow_delete_rev IS
5910: SELECT 1
5911: FROM ENG_REVISED_ITEMS itm,
5912: ENG_REVISED_ITEMS sitm
5913: WHERE itm.REVISED_ITEM_ID = sitm.REVISED_ITEM_ID
5914: AND itm.ORGANIZATION_ID = sitm.ORGANIZATION_ID
5915: AND sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id

Line 5912: ENG_REVISED_ITEMS sitm

5908: -- Bug 4946817: Fixed performance issues
5909: CURSOR allow_delete_rev IS
5910: SELECT 1
5911: FROM ENG_REVISED_ITEMS itm,
5912: ENG_REVISED_ITEMS sitm
5913: WHERE itm.REVISED_ITEM_ID = sitm.REVISED_ITEM_ID
5914: AND itm.ORGANIZATION_ID = sitm.ORGANIZATION_ID
5915: AND sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
5916: AND itm.STATUS_TYPE not in (5, 6)

Line 5921: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb

5917: AND (itm.CURRENT_ITEM_REVISION_ID = sitm.new_item_revision_id
5918: OR itm.FROM_END_ITEM_REV_ID = sitm.new_item_revision_id)
5919: UNION ALL
5920: SELECT 1
5921: FROM ENG_REVISED_ITEMS sitm , bom_structures_b bsb
5922: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
5923: AND bsb.assembly_item_id = sitm.revised_item_id
5924: AND bsb.organization_id = sitm.organization_id
5925: AND EXISTS ( SELECT 1

Line 5933: FROM eng_revised_items sitm

5929: OR bic.TO_END_ITEM_REV_ID = sitm.new_item_revision_id
5930: ))
5931: UNION ALL
5932: SELECT 1
5933: FROM eng_revised_items sitm
5934: WHERE sitm.revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
5935: AND EXISTS ( SELECT 1
5936: FROM BOM_COMPONENTS_B bic
5937: WHERE bic.component_item_id = sitm.revised_item_id and

Line 6406: FROM eng_revised_items

6402: l_is_item_unit_controlled BOOLEAN := FALSE;
6403:
6404: CURSOR c_CheckRevisedItem IS
6405: SELECT status_type
6406: FROM eng_revised_items
6407: WHERE revised_item_id = p_revised_item_id
6408: AND organization_id = p_organization_id --* Added for Bug 5174223
6409: AND change_notice = p_change_notice
6410: AND NVL(from_end_item_unit_number, 'NONE')

Line 7253: FROM eng_revised_items

7249: , l_old_revised_item_rec.routing_comment
7250: , l_old_revised_item_rec.eco_for_production
7251: , l_old_rev_item_unexp_rec.change_id
7252: , l_old_rev_item_unexp_rec.status_code
7253: FROM eng_revised_items
7254: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
7255: EXCEPTION
7256: WHEN NO_DATA_FOUND THEN
7257: null;