DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 62: FROM MTL_TRANSACTION_LOT_NUMBERS

58: into l_records_found
59: FROM DUAL
60: WHERE EXISTS
61: (SELECT 1
62: FROM MTL_TRANSACTION_LOT_NUMBERS
63: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
64: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id );
65:
66: if (l_records_found <> 0) then

Line 67: arg_table_name := arg_table_name||' MTL_TRANSACTION_LOT_NUMBERS *';

63: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
64: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id );
65:
66: if (l_records_found <> 0) then
67: arg_table_name := arg_table_name||' MTL_TRANSACTION_LOT_NUMBERS *';
68: l_flag := FALSE;
69: end if;
70:
71: l_stmt_num := 340;