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.GMD_QC_MIG12 dependencies on GMD_SAMPLING_EVENTS

Line 44: --| changed GMD_QC_MIGRATE_SAMPLES to replace update gmd_sampling_events with merge

40: --| 07/26/2012 PLOWE Bug 14355581 - LOT INFORMATION IN SAMPLE DIDNT GET MIGRATED PROPERLY
41: --| changed GMD_QC_MIGRATE_SAMPLES code to initialize variables as , in certain cases , these were being used to populate samples
42: --| 01/04/2013, Bug 14198664 - performance issues with patch 13846646.r12.gma.b and script gmdg5msm.sql
43: --| changed GMD_QC_MIGRATE_SAMPLES code to add p_start_rowid/p_end_rowid to support ad_parallel
44: --| changed GMD_QC_MIGRATE_SAMPLES to replace update gmd_sampling_events with merge
45: --=========================================================================== */
46:
47: PROCEDURE LOG_SETUP_COUNTS
48: ( p_migration_run_id IN NUMBER,

Line 166: p_param1 => 'gmd_sampling_events',

162: p_token2 => 'PRO',
163: p_token3 => 'UPD',
164: p_token4 => 'INS',
165: p_token5 => 'ERR',
166: p_param1 => 'gmd_sampling_events',
167: p_param2 => to_char(GMD_QC_MIG12.g_sample_event_pro_count),
168: p_param3 => to_char(GMD_QC_MIG12.g_sample_event_upd_count),
169: p_param4 => 0,
170: p_param5 => to_char(GMD_QC_MIG12.g_sample_event_err_count),

Line 2530: FROM gmd_sampling_events gse , gmd_samples gs

2526:
2527: -- cursor modified while fixing bug 14198664
2528: CURSOR get_sampling_event IS
2529: SELECT gse.sampling_event_id
2530: FROM gmd_sampling_events gse , gmd_samples gs
2531: WHERE gse.migrated_ind IS NULL
2532: AND gs.sampling_event_id = gse.sampling_event_id
2533: and gs.rowid between p_start_rowid and p_end_rowid;
2534:

Line 3482: Log Start of gmd_sampling_events migration.

3478: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3479:
3480:
3481: /*==============================================
3482: Log Start of gmd_sampling_events migration.
3483: ==============================================*/
3484:
3485: GMA_COMMON_LOGGING.gma_migration_central_log (
3486: p_run_id => p_migration_run_id,

Line 3489: p_table_name => 'GMD_SAMPLING_EVENTS',

3485: GMA_COMMON_LOGGING.gma_migration_central_log (
3486: p_run_id => p_migration_run_id,
3487: p_log_level => FND_LOG.LEVEL_EVENT,
3488: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3489: p_table_name => 'GMD_SAMPLING_EVENTS',
3490: p_token1 => 'TABLE_NAME',
3491: p_param1 => 'GMD_SAMPLING_EVENTS',
3492: p_context => 'Quality Samples',
3493: p_app_short_name => 'GMA');

Line 3491: p_param1 => 'GMD_SAMPLING_EVENTS',

3487: p_log_level => FND_LOG.LEVEL_EVENT,
3488: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3489: p_table_name => 'GMD_SAMPLING_EVENTS',
3490: p_token1 => 'TABLE_NAME',
3491: p_param1 => 'GMD_SAMPLING_EVENTS',
3492: p_context => 'Quality Samples',
3493: p_app_short_name => 'GMA');
3494:
3495:

Line 3517: -- Update gmd_sampling_events.

3513: RAISE MIG_GET_SAMPLE_ERROR;
3514: END IF;
3515: CLOSE get_sample_data;
3516: --==============================
3517: -- Update gmd_sampling_events.
3518: --===============================
3519: UPDATE gmd_sampling_events
3520: SET organization_id = l_samp_data.organization_id,
3521: inventory_item_id = l_samp_data.inventory_item_id,

Line 3519: UPDATE gmd_sampling_events

3515: CLOSE get_sample_data;
3516: --==============================
3517: -- Update gmd_sampling_events.
3518: --===============================
3519: UPDATE gmd_sampling_events
3520: SET organization_id = l_samp_data.organization_id,
3521: inventory_item_id = l_samp_data.inventory_item_id,
3522: lot_number = l_samp_data.lot_number,
3523: subinventory = l_samp_data.subinventory,

Line 3542: -- Supress logging of the following message since there are lot of rows in gmd_sampling_events where there is no corresponding sample row.

3538: EXCEPTION
3539:
3540: WHEN MIG_GET_SAMPLE_ERROR THEN
3541: -- Bug# 5462876
3542: -- Supress logging of the following message since there are lot of rows in gmd_sampling_events where there is no corresponding sample row.
3543: /*GMA_COMMON_LOGGING.gma_migration_central_log (
3544: p_run_id => p_migration_run_id,
3545: p_log_level => FND_LOG.LEVEL_ERROR,
3546: p_message_token => 'GMD_MIG_GET_SAMPLE',

Line 3547: p_context => 'Quality Samples - gmd_sampling_events',

3543: /*GMA_COMMON_LOGGING.gma_migration_central_log (
3544: p_run_id => p_migration_run_id,
3545: p_log_level => FND_LOG.LEVEL_ERROR,
3546: p_message_token => 'GMD_MIG_GET_SAMPLE',
3547: p_context => 'Quality Samples - gmd_sampling_events',
3548: p_token1 => 'SAMPLEVT',
3549: p_param1 => to_char(v_samp_event.sampling_event_id),
3550: p_app_short_name => 'GMD'); */
3551: GMD_QC_MIG12.g_sample_event_err_count := GMD_QC_MIG12.g_sample_event_err_count + 1;

Line 3560: p_context => 'Quality Samples - gmd_sampling_events',

3556: GMA_COMMON_LOGGING.gma_migration_central_log (
3557: p_run_id => p_migration_run_id,
3558: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3559: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3560: p_context => 'Quality Samples - gmd_sampling_events',
3561: p_db_error => SQLERRM,
3562: p_app_short_name => 'GMA');
3563: x_exception_count := x_exception_count + 1;
3564:

Line 3574: ( Select * from gmd_sampling_events where migrated_ind is null ) gse

3570:
3571: /* Start of Merged code for trying a fix
3572:
3573: Merge into
3574: ( Select * from gmd_sampling_events where migrated_ind is null ) gse
3575: Using gmd_samples gs On ( gs.rowId BETWEEN p_start_rowid AND p_end_rowid AND
3576: gs.sampling_event_id = gse.sampling_event_id AND
3577: (gs.migrated_ind = 1 OR gs.organization_id IS NOT NULL) )
3578: When Matched then Update

Line 4044: l_sample_orgn_code gmd_sampling_events.orgn_code%TYPE;

4040: /*====================================================
4041: Cursor to check if gmd_inventory_spec_vrs exists.
4042: ====================================================*/
4043:
4044: l_sample_orgn_code gmd_sampling_events.orgn_code%TYPE;
4045:
4046: -- Bug# 5482253
4047: -- Commented the following cursor definition and added it with the new where clause.
4048:

Line 4087: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4083: =======================================*/
4084:
4085: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS
4086: SELECT DISTINCT gse.orgn_code, gse.organization_id
4087: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4088: gmd_inventory_spec_vrs gisv
4089: WHERE gse.sampling_event_id = gesd.sampling_event_id
4090: AND gesd.spec_vr_id = gisv.spec_vr_id
4091: AND gisv.spec_vr_id = v_spec_id;

Line 4093: l_sample_organization_id gmd_sampling_events.organization_id%TYPE;

4089: WHERE gse.sampling_event_id = gesd.sampling_event_id
4090: AND gesd.spec_vr_id = gisv.spec_vr_id
4091: AND gisv.spec_vr_id = v_spec_id;
4092:
4093: l_sample_organization_id gmd_sampling_events.organization_id%TYPE;
4094:
4095:
4096: /*=======================================
4097: Cursor for gmd_wip_spec.

Line 4118: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4114: =======================================*/
4115:
4116: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4117: SELECT DISTINCT gse.orgn_code, gse.organization_id
4118: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4119: gmd_wip_spec_vrs gwsv
4120: WHERE gse.sampling_event_id = gesd.sampling_event_id
4121: AND gesd.spec_vr_id = gwsv.spec_vr_id
4122: AND gwsv.spec_vr_id = v_spec_id;

Line 4197: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4193: =======================================*/
4194:
4195: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4196: SELECT DISTINCT gse.orgn_code, gse.organization_id
4197: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4198: gmd_customer_spec_vrs gcsv
4199: WHERE gse.sampling_event_id = gesd.sampling_event_id
4200: AND gesd.spec_vr_id = gcsv.spec_vr_id
4201: AND gcsv.spec_vr_id = v_spec_id;

Line 4259: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4255: =======================================*/
4256:
4257: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4258: SELECT DISTINCT gse.orgn_code, gse.organization_id
4259: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4260: gmd_supplier_spec_vrs gssv
4261: WHERE gse.sampling_event_id = gesd.sampling_event_id
4262: AND gesd.spec_vr_id = gssv.spec_vr_id
4263: AND gssv.spec_vr_id = v_spec_id;

Line 4319: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,

4315: ==========================================*/
4316:
4317: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4318: SELECT DISTINCT gse.orgn_code, gse.organization_id
4319: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4320: gmd_monitoring_spec_vrs gmsv
4321: WHERE gse.sampling_event_id = gesd.sampling_event_id
4322: AND gesd.spec_vr_id = gmsv.spec_vr_id
4323: AND gmsv.spec_vr_id = v_spec_id;