eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WICTPG dependencies on DUAL

Line 624: FROM DUAL WHERE EXISTS (

620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
621: x_purge_rec.info := fnd_message.get;
622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
623: SELECT COUNT(*) into l_num_rows
624: FROM DUAL WHERE EXISTS (
625: SELECT out_wmta.transaction_id
626: FROM wip_move_txn_allocations out_wmta
627: WHERE out_wmta.organization_id = p_purge_request.organization_id
628: AND out_wmta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id

Line 876: FROM DUAL WHERE EXISTS (

872: x_purge_rec.info := fnd_message.get;
873: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
874:
875: SELECT COUNT(*) into l_num_rows
876: FROM DUAL WHERE EXISTS (
877: SELECT out_wta.transaction_id
878: FROM wip_txn_allocations out_wta
879: WHERE out_wta.organization_id = p_purge_request.organization_id
880: AND out_wta.repetitive_schedule_id = p_purge_request.repetitive_schedule_id

Line 1080: from dual

1076: */
1077:
1078: select count(*)
1079: into x_records_returned
1080: from dual
1081: where (0,0,0,0,0,0,0,0,0,0) <>
1082: (select sum(NVL(TL_RESOURCE_IN, 0) - NVL(TL_RESOURCE_OUT, 0) - NVL(TL_RESOURCE_VAR,0)),
1083: sum(NVL(TL_OVERHEAD_IN, 0) - NVL(TL_OVERHEAD_OUT, 0) - NVL(TL_OVERHEAD_VAR,0)),
1084: sum(NVL(TL_OUTSIDE_PROCESSING_IN,0) - NVL(TL_OUTSIDE_PROCESSING_OUT, 0) - NVL(TL_OUTSIDE_PROCESSING_VAR,0)),

Line 1111: FROM DUAL

1107: x_purge_rec.table_name := 'CST_STD_COST_ADJ_VALUES';
1108:
1109: SELECT COUNT(*)
1110: into x_records_returned
1111: FROM DUAL
1112: WHERE EXISTS
1113: (SELECT 1
1114: FROM CST_STD_COST_ADJ_VALUES
1115: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id);

Line 1129: FROM DUAL

1125:
1126:
1127: SELECT COUNT(*)
1128: into x_records_returned
1129: FROM DUAL
1130: WHERE EXISTS
1131: (SELECT 1
1132: FROM PO_DISTRIBUTIONS_ALL
1133: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id

Line 1149: FROM DUAL

1145: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';
1146:
1147: SELECT COUNT(*)
1148: into x_records_returned
1149: FROM DUAL
1150: WHERE EXISTS
1151: (SELECT 1
1152: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL
1153: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id);

Line 1167: FROM DUAL

1163: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';
1164:
1165: SELECT COUNT(*)
1166: into x_records_returned
1167: FROM DUAL
1168: WHERE EXISTS
1169: (SELECT 1
1170: FROM PO_REQUISITION_LINES_ALL
1171: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id );

Line 1185: FROM DUAL

1181: x_purge_rec.table_name := 'RCV_TRANSACTIONS';
1182:
1183: SELECT COUNT(*)
1184: into x_records_returned
1185: FROM DUAL
1186: WHERE EXISTS
1187: (SELECT 1
1188: FROM RCV_TRANSACTIONS
1189: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id );

Line 1222: FROM DUAL

1218: -- Assigning value of Zero to x_records_returned instead.
1219: /*
1220: SELECT COUNT(*)
1221: into x_records_returned
1222: FROM DUAL
1223: WHERE EXISTS
1224: (SELECT 1
1225: FROM MTL_DEMAND
1226: WHERE SUPPLY_SOURCE_TYPE = 5

Line 1238: FROM DUAL

1234: else
1235:
1236: SELECT COUNT(*)
1237: into x_records_returned
1238: FROM DUAL
1239: WHERE EXISTS
1240: (SELECT 1
1241: FROM MTL_DEMAND
1242: WHERE SUPPLY_SOURCE_TYPE = 5

Line 1264: FROM DUAL

1260: if (x_purge_rec.primary_item_id IS NULL) then
1261:
1262: SELECT COUNT(*)
1263: into x_records_returned
1264: FROM DUAL
1265: WHERE EXISTS
1266: (SELECT 1
1267: FROM MTL_USER_SUPPLY
1268: WHERE SOURCE_TYPE_ID = 4

Line 1276: FROM DUAL

1272: else
1273:
1274: SELECT COUNT(*)
1275: into x_records_returned
1276: FROM DUAL
1277: WHERE EXISTS
1278: (SELECT 1
1279: FROM MTL_USER_SUPPLY
1280: WHERE SOURCE_TYPE_ID = 4

Line 1299: FROM DUAL

1295: if (x_purge_rec.primary_item_id IS NULL) then
1296:
1297: SELECT COUNT(*)
1298: into x_records_returned
1299: FROM DUAL
1300: WHERE EXISTS
1301: (SELECT 1
1302: FROM MTL_USER_DEMAND
1303: WHERE SOURCE_TYPE_ID = 4

Line 1309: FROM DUAL

1305: AND INVENTORY_ITEM_ID IS NULL );
1306: else
1307: SELECT COUNT(*)
1308: into x_records_returned
1309: FROM DUAL
1310: WHERE EXISTS
1311: (SELECT 1
1312: FROM MTL_USER_DEMAND
1313: WHERE SOURCE_TYPE_ID = 4

Line 1332: FROM DUAL

1328: if (x_purge_rec.primary_item_id IS NULL) then
1329:
1330: SELECT COUNT(*)
1331: into x_records_returned
1332: FROM DUAL
1333: WHERE EXISTS
1334: (SELECT 1
1335: FROM MTL_SERIAL_NUMBERS
1336: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id

Line 1342: FROM DUAL

1338: else
1339:
1340: SELECT COUNT(*)
1341: into x_records_returned
1342: FROM DUAL
1343: WHERE EXISTS
1344: (SELECT 1
1345: FROM MTL_SERIAL_NUMBERS
1346: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id

Line 1365: FROM DUAL

1361: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS';
1362:
1363: SELECT COUNT(*)
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

Line 1385: FROM DUAL

1381: x_purge_rec.table_name := 'MTL_TRANSACTION_ACCOUNTS';
1382:
1383: SELECT COUNT(*)
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

Line 1405: FROM DUAL

1401: x_purge_rec.table_name := 'MTL_TRANSACTION_LOT_NUMBERS';
1402:
1403: SELECT COUNT(*)
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

Line 1424: FROM DUAL

1420: x_purge_rec.table_name := 'MTL_UNIT_TRANSACTIONS';
1421:
1422: SELECT COUNT(*)
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

Line 2007: from sys.dual

2003: individula cost columns in WIP_PERIOD_BALANCES is zero as it was in the earlier sql.
2004: */
2005:
2006: select count(*) into l_num_rows
2007: from sys.dual
2008: where (0,0,0,0,0,0,0,0,0,0) <>
2009: (select sum(NVL(TL_RESOURCE_IN, 0) - NVL(TL_RESOURCE_OUT, 0)
2010: - NVL(TL_RESOURCE_VAR,0)),
2011: sum(NVL(TL_OVERHEAD_IN, 0) - NVL(TL_OVERHEAD_OUT, 0)

Line 2044: FROM DUAL

2040: x_purge_rec.info := fnd_message.get;
2041:
2042: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ALL';
2043: SELECT COUNT(*) into l_num_rows
2044: FROM DUAL
2045: WHERE EXISTS (SELECT 1
2046: FROM PO_DISTRIBUTIONS_ALL
2047: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2048: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id

Line 2060: FROM DUAL

2056: l_num_rows := 0;
2057:
2058: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';
2059: SELECT COUNT(*) into l_num_rows
2060: FROM DUAL
2061: WHERE EXISTS (SELECT 1
2062: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL
2063: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2064: and WIP_ENTITY_ID = x_purge_rec.wip_entity_id);

Line 2073: FROM DUAL

2069: l_num_rows := 0;
2070:
2071: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';
2072: SELECT COUNT(*) into l_num_rows
2073: FROM DUAL
2074: WHERE EXISTS (SELECT 1
2075: FROM PO_REQUISITION_LINES_ALL
2076: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2077: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id);

Line 2087: FROM DUAL

2083:
2084:
2085: x_purge_rec.table_name := 'RCV_TRANSACTIONS';
2086: SELECT COUNT(*) into l_num_rows
2087: FROM DUAL
2088: WHERE EXISTS (SELECT 1
2089: FROM RCV_TRANSACTIONS
2090: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2091: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id);

Line 2100: FROM DUAL

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,
2103: MTL_MATERIAL_TRANSACTIONS MMT
2104: WHERE MMT.TRANSACTION_SOURCE_TYPE_ID + 0 = 5

Line 2122: FROM DUAL

2118: x_purge_rec.info := fnd_message.get;
2119:
2120: x_purge_rec.table_name := 'MTL_MATERIAL_TXN_ALLOCATIONS';
2121: SELECT COUNT(*) into l_num_rows
2122: FROM DUAL
2123: WHERE EXISTS (SELECT 1
2124: FROM MTL_MATERIAL_TXN_ALLOCATIONS
2125: WHERE REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2126: AND ORGANIZATION_ID = x_purge_rec.org_id);

Line 2297: select Wip_purge_temp_s.nextval into x_group_id from dual;

2293: x_from_date date;
2294:
2295: begin
2296: -- generate a group ID
2297: select Wip_purge_temp_s.nextval into x_group_id from dual;
2298:
2299: -- find jobs
2300: if (p_purge_type in (PURGE_JOBS, PURGE_LOTBASED, PURGE_ALL)) then
2301:

Line 2350: from dual ;

2346: x_sql_stm1 := x_sql_stm1 || ' and wdj.date_closed <= :l_cutoff_date ' ;
2347: else
2348: select p_cutoff_date - nvl(p_days_before_cutoff, 0)
2349: into x_from_date
2350: from dual ;
2351:
2352: x_sql_stm1 := x_sql_stm1 ||
2353: ' and wdj.date_closed between :l_from_date and :l_cutoff_date ' ;
2354: end if ;

Line 2480: from dual ;

2476: x_sql_stm2 := x_sql_stm2 || ' and wrs.date_closed <= :l_cutoff_date ' ;
2477: else
2478: select p_cutoff_date - nvl(p_days_before_cutoff, 0)
2479: into x_from_date
2480: from dual ;
2481:
2482: x_sql_stm2 := x_sql_stm2 ||
2483: ' and wrs.date_closed between :l_from_date and :l_cutoff_date ' ;
2484: end if ;