APPS.WIP_WICTPG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1361: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS';

1357: /* append_report(x_purge_rec, p_option); */
1358: fnd_file.put_line(FND_FILE.LOG,'Note: job/schedule '||x_purge_rec.wip_entity_id||' has Serial Number reference');
1359: end if;
1360:
1361: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS';
1362:
1363: SELECT COUNT(*)
1364: into x_records_returned
1365: FROM DUAL

Line 1368: FROM MTL_MATERIAL_TRANSACTIONS

1364: into x_records_returned
1365: FROM DUAL
1366: WHERE EXISTS
1367: (SELECT 1
1368: FROM MTL_MATERIAL_TRANSACTIONS
1369: WHERE TRANSACTION_SOURCE_TYPE_ID + 0 = 5
1370: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id
1371: AND ORGANIZATION_ID = x_purge_rec.org_id );
1372:

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 1635: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

1631: num_rows => x_num_rows);
1632: end if;
1633:
1634:
1635: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
1636:
1637: if (x_purge_rec.primary_item_id IS NULL) then
1638: if (p_option = REPORT_ONLY) then
1639: SELECT COUNT(*)

Line 1641: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1637: if (x_purge_rec.primary_item_id IS NULL) then
1638: if (p_option = REPORT_ONLY) then
1639: SELECT COUNT(*)
1640: INTO x_num_rows
1641: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1642: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1643: AND INVENTORY_ITEM_ID IS NULL
1644: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1645: else

Line 1646: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1642: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1643: AND INVENTORY_ITEM_ID IS NULL
1644: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1645: else
1646: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1647: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1648: AND INVENTORY_ITEM_ID IS NULL
1649: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1650:

Line 1659: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1655:
1656: if (p_option = REPORT_ONLY) then
1657: SELECT COUNT(*)
1658: INTO x_num_rows
1659: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1660: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1661: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1662: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1663: else

Line 1664: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1660: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1661: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1662: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1663: else
1664: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1665: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1666: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1667: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1668:

Line 2103: MTL_MATERIAL_TRANSACTIONS MMT

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
2107: AND MMT.TRANSACTION_ID = MTA.TRANSACTION_ID