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.GME_POST_MIGRATION dependencies on DUAL

Line 143: SELECT wip_entities_s.NEXTVAL INTO l_wip_entity_id FROM DUAL;

139: END IF;
140: /* Process batch header record */
141: build_batch_hdr(p_batch_header_mig => get_batches,
142: x_batch_header => l_batch_header);
143: SELECT wip_entities_s.NEXTVAL INTO l_wip_entity_id FROM DUAL;
144: l_batch_header.plant_code := NULL;
145: l_batch_header.batch_status := 1;
146: l_batch_header.enforce_step_dependency := 0;
147: l_batch_header.terminated_ind := 0;

Line 221: SELECT gem5_line_id_s.NEXTVAL INTO l_mtl_dtl_tbl(i).material_detail_id FROM DUAL;

217: IF (l_organization_id <> l_mtl_dtl_tbl(i).organization_id) THEN
218: l_subinventory := NULL;
219: END IF;
220: END IF;
221: SELECT gem5_line_id_s.NEXTVAL INTO l_mtl_dtl_tbl(i).material_detail_id FROM DUAL;
222: l_mtl_dtl_tbl(i).batch_id := l_batch_header.batch_id;
223: l_mtl_dtl_tbl(i).actual_qty := 0;
224: l_mtl_dtl_tbl(i).wip_plan_qty := NULL;
225: l_mtl_dtl_tbl(i).backordered_qty := 0;

Line 254: SELECT gme_batch_step_s.NEXTVAL INTO l_steps_tbl(i).batchstep_id FROM DUAL;

250: build_steps(p_steps_mig => l_steps_mig_tbl,
251: x_steps => l_steps_tbl);
252: FOR i IN 1..l_steps_tbl.count LOOP
253: l_old_batchstep_id := l_steps_tbl(i).batchstep_id;
254: SELECT gme_batch_step_s.NEXTVAL INTO l_steps_tbl(i).batchstep_id FROM DUAL;
255: l_steps_tbl(i).batch_id := l_batch_header.batch_id;
256: l_steps_tbl(i).step_status := 1;
257: l_steps_tbl(i).actual_start_date := NULL;
258: l_steps_tbl(i).actual_cmplt_date := NULL;

Line 273: SELECT gme_batch_step_activity_s.NEXTVAL INTO l_activities_tbl(j).batchstep_activity_id FROM DUAL;

269: gme_debug.put_line('No. of activities = '||l_activities_mig_tbl.count);
270: END IF;
271: FOR j IN (l_actv_count + 1)..l_activities_tbl.count LOOP
272: l_old_bstep_activ_id := l_activities_tbl(j).batchstep_activity_id;
273: SELECT gme_batch_step_activity_s.NEXTVAL INTO l_activities_tbl(j).batchstep_activity_id FROM DUAL;
274: l_activities_tbl(j).batch_id := l_batch_header.batch_id;
275: l_activities_tbl(j).batchstep_id := l_steps_tbl(i).batchstep_id;
276: l_activities_tbl(j).actual_start_date := NULL;
277: l_activities_tbl(j).actual_cmplt_date := NULL;

Line 290: SELECT gem5_batchstepline_id_s.NEXTVAL INTO l_resources_tbl(k).batchstep_resource_id FROM DUAL;

286: gme_debug.put_line('No. of resources = '||l_resources_mig_tbl.count);
287: END IF;
288: FOR k IN (l_rsrc_count + 1)..l_resources_tbl.count LOOP
289: l_old_bstep_rsrc_id := l_resources_tbl(k).batchstep_resource_id;
290: SELECT gem5_batchstepline_id_s.NEXTVAL INTO l_resources_tbl(k).batchstep_resource_id FROM DUAL;
291: l_resources_tbl(k).batch_id := l_batch_header.batch_id;
292: l_resources_tbl(k).batchstep_id := l_steps_tbl(i).batchstep_id;
293: l_resources_tbl(k).batchstep_activity_id := l_activities_tbl(j).batchstep_activity_id;
294: l_resources_tbl(k).actual_start_date := NULL;

Line 307: SELECT gme_process_parameters_id_s.NEXTVAL INTO l_proc_param_tbl(m).process_param_id FROM DUAL;

303: IF (g_debug <= gme_debug.g_log_statement) THEN
304: gme_debug.put_line('No. of process params = '||l_proc_param_mig_tbl.count);
305: END IF;
306: FOR m IN (l_pprm_count + 1)..l_proc_param_tbl.count LOOP
307: SELECT gme_process_parameters_id_s.NEXTVAL INTO l_proc_param_tbl(m).process_param_id FROM DUAL;
308: l_proc_param_tbl(m).batch_id := l_batch_header.batch_id;
309: l_proc_param_tbl(m).batchstep_id := l_steps_tbl(i).batchstep_id;
310: l_proc_param_tbl(m).batchstep_activity_id := l_activities_tbl(j).batchstep_activity_id;
311: l_proc_param_tbl(m).batchstep_resource_id := l_resources_tbl(k).batchstep_resource_id;

Line 323: SELECT gem5_poc_trans_id_s.NEXTVAL INTO l_rsrc_txns_tbl(n).poc_trans_id FROM DUAL;

319: IF (g_debug <= gme_debug.g_log_statement) THEN
320: gme_debug.put_line('No. of rsrc txns = '||l_rsrc_txns_mig_tbl.count);
321: END IF;
322: FOR n IN (l_rtxn_count + 1)..l_rsrc_txns_tbl.count LOOP
323: SELECT gem5_poc_trans_id_s.NEXTVAL INTO l_rsrc_txns_tbl(n).poc_trans_id FROM DUAL;
324: l_rsrc_txns_tbl(n).orgn_code := NULL;
325: l_rsrc_txns_tbl(n).doc_id := l_batch_header.batch_id;
326: l_rsrc_txns_tbl(n).line_id := l_resources_tbl(k).batchstep_resource_id;
327: END LOOP; /* Resource Txns Loop */

Line 1303: SELECT gem5_wip_trans_id_s.NEXTVAL INTO l_step_txfrs_tbl(i).wip_trans_id FROM DUAL;

1299: OPEN Cur_step_txfrs;
1300: FETCH Cur_step_txfrs BULK COLLECT INTO l_step_txfrs_mig_tbl;
1301: CLOSE Cur_step_txfrs;
1302: FOR i IN 1..l_step_txfrs_mig_tbl.count LOOP
1303: SELECT gem5_wip_trans_id_s.NEXTVAL INTO l_step_txfrs_tbl(i).wip_trans_id FROM DUAL;
1304: l_step_txfrs_tbl(i).batch_id := p_new_batch_id;
1305: l_step_txfrs_tbl(i).batchstep_no := l_step_txfrs_mig_tbl(i).batchstep_no;
1306: l_step_txfrs_tbl(i).transfer_step_no := l_step_txfrs_mig_tbl(i).transfer_step_no;
1307: l_step_txfrs_tbl(i).line_type := l_step_txfrs_mig_tbl(i).line_type;

Line 1514: FROM DUAL

1510: AND NOT(s.step_status = m.step_status)
1511: ORDER BY s.batchstep_no;
1512: CURSOR Cur_verify_phantoms(v_batch_id NUMBER) IS
1513: SELECT 1
1514: FROM DUAL
1515: WHERE EXISTS (SELECT batch_id
1516: FROM gme_material_details
1517: WHERE batch_id = v_batch_id
1518: AND phantom_type > 0

Line 2114: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;

2110: IF (l_mtl_rec.mtl_transactions_enabled_flag <> 'Y') THEN
2111: l_msg_name := 'GME_MIG_ITEM_NOT_TXNS_ENABLED';
2112: RAISE defined_error;
2113: END IF;
2114: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;
2115: IF (g_debug <= gme_debug.g_log_statement) THEN
2116: gme_debug.put_line('Transaction header ID = '||gme_common_pvt.g_transaction_header_id);
2117: END IF;
2118: l_mmti_rec.transaction_source_id := l_mtl_rec.batch_id;

Line 2474: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;

2470: l_msg_name := 'GME_NO_OPEN_PERIODS_TXN';
2471: RAISE defined_error;
2472: END IF;
2473: l_mmti_rec.transaction_date := l_date;
2474: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;
2475: IF (g_debug <= gme_debug.g_log_statement) THEN
2476: gme_debug.put_line('Transaction header ID for reservation is '||gme_common_pvt.g_transaction_header_id);
2477: END IF;
2478: l_in_subinventory := l_subinventory;

Line 3028: l_issue_rec.transaction_interface_id FROM DUAL;

3024: l_issue_rec.transaction_date := l_date;
3025: END IF;
3026: /* Create a misc issue in original org/sub/loc and then a reciept in final org/sub/loc */
3027: SELECT mtl_material_transactions_s.NEXTVAL INTO
3028: l_issue_rec.transaction_interface_id FROM DUAL;
3029: l_issue_rec.transaction_header_id := gme_common_pvt.g_transaction_header_id;
3030: l_issue_rec.source_code := 'OPM_GME_MIGRATION';
3031: l_issue_rec.source_line_id := p_txn_rec.trans_id;
3032: l_issue_rec.source_header_id := p_txn_rec.doc_id;

Line 3114: l_receipt_rec.transaction_interface_id FROM DUAL;

3110: ELSE
3111: l_receipt_rec.transaction_date := l_date;
3112: END IF;
3113: SELECT mtl_material_transactions_s.NEXTVAL INTO
3114: l_receipt_rec.transaction_interface_id FROM DUAL;
3115: l_receipt_rec.organization_id := p_batch_org_id;
3116: /* We are creating a receipt txn in a sub which has the same name as org. This will always exist */
3117: BEGIN
3118: SELECT whse_code