APPS.WIP_WICTPG dependencies on MTL_DEMAND

Line 1211: x_purge_rec.table_name := 'MTL_DEMAND';

1207: end if ;
1208: */
1209: /* END - Fix for bug#4902938 */
1210:
1211: x_purge_rec.table_name := 'MTL_DEMAND';
1212:
1213: if (x_purge_rec.primary_item_id IS NULL) then
1214:
1215: -- Bug 4880984

Line 1217: -- inventory_item_id is mandatory column in MTL_DEMAND table.

1213: if (x_purge_rec.primary_item_id IS NULL) then
1214:
1215: -- Bug 4880984
1216: -- Removed this SQL as check is redundand. This is because
1217: -- inventory_item_id is mandatory column in MTL_DEMAND table.
1218: -- Assigning value of Zero to x_records_returned instead.
1219: /*
1220: SELECT COUNT(*)
1221: into x_records_returned

Line 1225: FROM MTL_DEMAND

1221: into x_records_returned
1222: FROM DUAL
1223: WHERE EXISTS
1224: (SELECT 1
1225: FROM MTL_DEMAND
1226: WHERE SUPPLY_SOURCE_TYPE = 5
1227: AND INVENTORY_ITEM_ID IS NULL
1228: AND SUPPLY_SOURCE_HEADER_ID = x_purge_rec.wip_entity_id
1229: AND ORGANIZATION_ID = x_purge_rec.org_id);

Line 1241: FROM MTL_DEMAND

1237: into x_records_returned
1238: FROM DUAL
1239: WHERE EXISTS
1240: (SELECT 1
1241: FROM MTL_DEMAND
1242: WHERE SUPPLY_SOURCE_TYPE = 5
1243: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1244: AND SUPPLY_SOURCE_HEADER_ID = x_purge_rec.wip_entity_id
1245: AND ORGANIZATION_ID = x_purge_rec.org_id);

Line 1587: x_purge_rec.table_name := 'MTL_DEMAND_INTERFACE';

1583: p_purge_rec => x_purge_rec,
1584: num_rows => x_num_rows);
1585: end if;
1586:
1587: x_purge_rec.table_name := 'MTL_DEMAND_INTERFACE';
1588:
1589: if (p_option = REPORT_ONLY) then
1590: SELECT COUNT(*) INTO x_num_rows
1591: FROM MTL_DEMAND_INTERFACE

Line 1591: FROM MTL_DEMAND_INTERFACE

1587: x_purge_rec.table_name := 'MTL_DEMAND_INTERFACE';
1588:
1589: if (p_option = REPORT_ONLY) then
1590: SELECT COUNT(*) INTO x_num_rows
1591: FROM MTL_DEMAND_INTERFACE
1592: WHERE ORGANIZATION_ID = x_purge_rec.org_id
1593: AND SUPPLY_SOURCE_TYPE = 5
1594: AND SUPPLY_HEADER_ID = x_purge_rec.wip_entity_id;
1595: else

Line 1596: DELETE FROM MTL_DEMAND_INTERFACE

1592: WHERE ORGANIZATION_ID = x_purge_rec.org_id
1593: AND SUPPLY_SOURCE_TYPE = 5
1594: AND SUPPLY_HEADER_ID = x_purge_rec.wip_entity_id;
1595: else
1596: DELETE FROM MTL_DEMAND_INTERFACE
1597: WHERE ORGANIZATION_ID = x_purge_rec.org_id
1598: AND SUPPLY_SOURCE_TYPE = 5
1599: AND SUPPLY_HEADER_ID = x_purge_rec.wip_entity_id;
1600:

Line 1828: NOT be purged if foreign key references exist in the MTL_DEMAND table.

1824:
1825:
1826: /* Moved WIP_SO_ALLOCATIONS deletion codes to this section so that it will go
1827: through the foreign key verifications to ensure that WIP_SO_ALLOCATIONS will
1828: NOT be purged if foreign key references exist in the MTL_DEMAND table.
1829: Bug # 622330 */
1830:
1831: if (OE_INSTALL.Get_Active_Product = 'OE') then
1832: x_purge_rec.table_name := 'WIP_SO_ALLOCATIONS';