DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1401: x_purge_rec.table_name := 'MTL_TRANSACTION_LOT_NUMBERS';

1397: append_report(x_purge_rec, p_option);
1398: end if;
1399:
1400:
1401: x_purge_rec.table_name := 'MTL_TRANSACTION_LOT_NUMBERS';
1402:
1403: SELECT COUNT(*)
1404: into x_records_returned
1405: FROM DUAL

Line 1408: FROM MTL_TRANSACTION_LOT_NUMBERS

1404: into x_records_returned
1405: FROM DUAL
1406: WHERE EXISTS
1407: (SELECT 1
1408: FROM MTL_TRANSACTION_LOT_NUMBERS
1409: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1410: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id );
1411:
1412: x_records_found := x_records_found OR (x_records_returned > 0);