DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on MTL_SYSTEM_ITEMS

Line 181: FROM mtl_system_items

177: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
178: l_eng_item_flag VARCHAR2(1) := 'n';
179: CURSOR eng_item_cur IS
180: SELECT 'y'
181: FROM mtl_system_items
182: WHERE inventory_item_id =
183: (select revised_item_id from eng_revised_items
184: where change_notice = p_change_notice
185: and organization_id = organization_id)