APPS.WIP_WICTPG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1381: x_purge_rec.table_name := 'MTL_TRANSACTION_ACCOUNTS';

1377: end if;
1378:
1379:
1380:
1381: x_purge_rec.table_name := 'MTL_TRANSACTION_ACCOUNTS';
1382:
1383: SELECT COUNT(*)
1384: into x_records_returned
1385: FROM DUAL

Line 1388: FROM MTL_TRANSACTION_ACCOUNTS MTA , MTL_MATERIAL_TRANSACTIONS MMT

1384: into x_records_returned
1385: FROM DUAL
1386: WHERE EXISTS
1387: (SELECT 1
1388: FROM MTL_TRANSACTION_ACCOUNTS MTA , MTL_MATERIAL_TRANSACTIONS MMT
1389: WHERE MMT.TRANSACTION_SOURCE_TYPE_ID + 0 = 5
1390: AND MMT.TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id
1391: AND MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
1392: AND MMT.ORGANIZATION_ID = x_purge_rec.org_id );

Line 2098: x_purge_rec.table_name := 'MTL_TRANSACTION_ACCOUNTS';

2094: append_report(x_purge_rec, p_option);
2095: end if;
2096: l_num_rows := 0;
2097:
2098: x_purge_rec.table_name := 'MTL_TRANSACTION_ACCOUNTS';
2099: SELECT COUNT(*) into l_num_rows
2100: FROM DUAL
2101: WHERE EXISTS (SELECT 1
2102: FROM MTL_TRANSACTION_ACCOUNTS MTA,

Line 2102: FROM MTL_TRANSACTION_ACCOUNTS MTA,

2098: x_purge_rec.table_name := 'MTL_TRANSACTION_ACCOUNTS';
2099: SELECT COUNT(*) into l_num_rows
2100: FROM DUAL
2101: WHERE EXISTS (SELECT 1
2102: FROM MTL_TRANSACTION_ACCOUNTS MTA,
2103: MTL_MATERIAL_TRANSACTIONS MMT
2104: WHERE MMT.TRANSACTION_SOURCE_TYPE_ID + 0 = 5
2105: AND MMT.TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id
2106: AND MMT.REPETITIVE_LINE_ID = x_purge_rec.line_id