DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on MTL_SERIAL_NUMBERS

Line 147: FROM MTL_SERIAL_NUMBERS

143: into l_records_found
144: FROM DUAL
145: WHERE EXISTS
146: (SELECT 1
147: FROM MTL_SERIAL_NUMBERS
148: WHERE INVENTORY_ITEM_ID = arg_item_id
149: AND ORIGINAL_WIP_ENTITY_ID = arg_wip_entity_id);
150:
151: if (l_records_found <> 0) then

Line 152: arg_table_name := arg_table_name||' MTL_SERIAL_NUMBERS *';

148: WHERE INVENTORY_ITEM_ID = arg_item_id
149: AND ORIGINAL_WIP_ENTITY_ID = arg_wip_entity_id);
150:
151: if (l_records_found <> 0) then
152: arg_table_name := arg_table_name||' MTL_SERIAL_NUMBERS *';
153: l_flag := FALSE;
154: end if;
155:
156: