DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on MTL_UNIT_TRANSACTIONS

Line 1420: x_purge_rec.table_name := 'MTL_UNIT_TRANSACTIONS';

1416: end if;
1417:
1418:
1419:
1420: x_purge_rec.table_name := 'MTL_UNIT_TRANSACTIONS';
1421:
1422: SELECT COUNT(*)
1423: into x_records_returned
1424: FROM DUAL

Line 1427: FROM MTL_UNIT_TRANSACTIONS

1423: into x_records_returned
1424: FROM DUAL
1425: WHERE EXISTS
1426: (SELECT 1
1427: FROM MTL_UNIT_TRANSACTIONS
1428: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1429: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id );
1430:
1431: x_records_found := x_records_found OR (x_records_returned > 0);