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_WIP_SPEC_VRS

Line 269: p_param1 => 'gmd_wip_spec_vrs',

265: p_token2 => 'PRO',
266: p_token3 => 'UPD',
267: p_token4 => 'INS',
268: p_token5 => 'ERR',
269: p_param1 => 'gmd_wip_spec_vrs',
270: p_param2 => to_char(GMD_QC_MIG12.g_wip_spec_pro_count),
271: p_param3 => to_char(GMD_QC_MIG12.g_wip_spec_upd_count),
272: p_param4 => to_char(GMD_QC_MIG12.g_wip_spec_ins_count),
273: p_param5 => to_char(GMD_QC_MIG12.g_wip_spec_err_count),

Line 282: p_param1 => 'gmd_wip_spec_vrs',

278: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
279: p_context => 'Quality Specifications',
280: p_token1 => 'TAB',
281: p_token2 => 'DEL',
282: p_param1 => 'gmd_wip_spec_vrs',
283: p_param2 => to_char(GMD_QC_MIG12.g_wip_spec_del_count),
284: p_app_short_name => 'GMD');
285: END IF;
286:

Line 3625: -- gmd_wip_spec_vrs organization_id

3621: -- gmd_specifications_b owner_organization_id
3622: -- gmd_spec_tests_b test_qty_uom
3623: -- gmd_spec_tests_b to_qty_uom
3624: -- gmd_inventory_spec_vrs organization_id
3625: -- gmd_wip_spec_vrs organization_id
3626: -- gmd_customer_spec_vrs organization_id
3627: -- gmd_supplier_spec_vrs organization_id
3628: -- gmd_monitoring_spec_vrs organization_id
3629: -- gmd_monitoring_spec_vrs resource_organization_id

Line 3834: SELECT * from gmd_wip_spec_vrs

3830:
3831: -- Bug# 5109249
3832: -- Commented the organization_id from the where clause
3833: CURSOR get_wip_spec IS
3834: SELECT * from gmd_wip_spec_vrs
3835: WHERE migrated_ind IS NULL
3836: --AND organization_id IS NULL
3837: ORDER BY orgn_code;
3838:

Line 3839: l_wip_spec gmd_wip_spec_vrs%ROWTYPE;

3835: WHERE migrated_ind IS NULL
3836: --AND organization_id IS NULL
3837: ORDER BY orgn_code;
3838:
3839: l_wip_spec gmd_wip_spec_vrs%ROWTYPE;
3840: l_wip_org_id gmd_wip_spec_vrs.organization_id%TYPE;
3841:
3842: /*=======================================
3843: Cursor to get orgn_codes for sample

Line 3840: l_wip_org_id gmd_wip_spec_vrs.organization_id%TYPE;

3836: --AND organization_id IS NULL
3837: ORDER BY orgn_code;
3838:
3839: l_wip_spec gmd_wip_spec_vrs%ROWTYPE;
3840: l_wip_org_id gmd_wip_spec_vrs.organization_id%TYPE;
3841:
3842: /*=======================================
3843: Cursor to get orgn_codes for sample
3844: that wip validity rule is tied to.

Line 3847: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS

3843: Cursor to get orgn_codes for sample
3844: that wip validity rule is tied to.
3845: =======================================*/
3846:
3847: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3848: SELECT DISTINCT gse.orgn_code, gse.organization_id
3849: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3850: gmd_wip_spec_vrs gwsv
3851: WHERE gse.sampling_event_id = gesd.sampling_event_id

Line 3850: gmd_wip_spec_vrs gwsv

3846:
3847: CURSOR get_wip_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3848: SELECT DISTINCT gse.orgn_code, gse.organization_id
3849: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3850: gmd_wip_spec_vrs gwsv
3851: WHERE gse.sampling_event_id = gesd.sampling_event_id
3852: AND gesd.spec_vr_id = gwsv.spec_vr_id
3853: AND gwsv.spec_vr_id = v_spec_id;
3854:

Line 3865: FROM gmd_wip_spec_vrs

3861: -- Commented the following cursor definition and added it with the new where clause.
3862:
3863: /*CURSOR check_wip_spec IS
3864: SELECT spec_vr_id
3865: FROM gmd_wip_spec_vrs
3866: WHERE orgn_code = l_sample_orgn_code;*/
3867:
3868: CURSOR check_wip_spec IS
3869: SELECT spec_vr_id

Line 3870: FROM gmd_wip_spec_vrs

3866: WHERE orgn_code = l_sample_orgn_code;*/
3867:
3868: CURSOR check_wip_spec IS
3869: SELECT spec_vr_id
3870: FROM gmd_wip_spec_vrs
3871: WHERE orgn_code = l_sample_orgn_code
3872: AND spec_id = l_wip_spec.spec_id
3873: AND ( (batch_id IS NULL AND l_wip_spec.batch_id IS NULL) OR
3874: (batch_id = l_wip_spec.batch_id)

Line 3926: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS

3922: Cursor to get orgn_codes for sample
3923: that customer validity rule is tied to.
3924: =======================================*/
3925:
3926: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3927: SELECT DISTINCT gse.orgn_code, gse.organization_id
3928: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3929: gmd_customer_spec_vrs gcsv
3930: WHERE gse.sampling_event_id = gesd.sampling_event_id

Line 3988: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS

3984: Cursor to get orgn_codes for sample
3985: that supplier validity rule is tied to.
3986: =======================================*/
3987:
3988: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3989: SELECT DISTINCT gse.orgn_code, gse.organization_id
3990: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3991: gmd_supplier_spec_vrs gssv
3992: WHERE gse.sampling_event_id = gesd.sampling_event_id

Line 5126: Migrate gmd_wip_spec_vrs.

5122: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5123:
5124:
5125: /*================================
5126: Migrate gmd_wip_spec_vrs.
5127: ================================*/
5128:
5129: GMA_COMMON_LOGGING.gma_migration_central_log (
5130: p_run_id => p_migration_run_id,

Line 5133: p_table_name => 'GMD_WIP_SPEC_VRS',

5129: GMA_COMMON_LOGGING.gma_migration_central_log (
5130: p_run_id => p_migration_run_id,
5131: p_log_level => FND_LOG.LEVEL_EVENT,
5132: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5133: p_table_name => 'GMD_WIP_SPEC_VRS',
5134: p_token1 => 'TABLE_NAME',
5135: p_param1 => 'GMD_WIP_SPEC_VRS',
5136: p_context => 'Quality Specifications',
5137: p_app_short_name => 'GMA');

Line 5135: p_param1 => 'GMD_WIP_SPEC_VRS',

5131: p_log_level => FND_LOG.LEVEL_EVENT,
5132: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5133: p_table_name => 'GMD_WIP_SPEC_VRS',
5134: p_token1 => 'TABLE_NAME',
5135: p_param1 => 'GMD_WIP_SPEC_VRS',
5136: p_context => 'Quality Specifications',
5137: p_app_short_name => 'GMA');
5138:
5139: GMD_QC_MIG12.g_progress_ind := 3;

Line 5206: Update gmd_wip_spec_vrs.

5202:
5203: IF (l_wip_spec.orgn_code IS NOT NULL) THEN
5204: l_organization_id := l_wip_org_id;
5205: /*=====================================
5206: Update gmd_wip_spec_vrs.
5207: =====================================*/
5208: UPDATE gmd_wip_spec_vrs
5209: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5210: in_spec_lot_status_id = l_in_spec_status_id,

Line 5208: UPDATE gmd_wip_spec_vrs

5204: l_organization_id := l_wip_org_id;
5205: /*=====================================
5206: Update gmd_wip_spec_vrs.
5207: =====================================*/
5208: UPDATE gmd_wip_spec_vrs
5209: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5210: in_spec_lot_status_id = l_in_spec_status_id,
5211: organization_id = l_organization_id,
5212: material_detail_id = l_material_detail_id, -- Bug# 5482253

Line 5239: DELETE gmd_wip_spec_vrs

5235: /*==========================================
5236: This is not marked as an error.
5237: ==========================================*/
5238:
5239: DELETE gmd_wip_spec_vrs
5240: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5241:
5242: IF (p_commit = FND_API.G_TRUE) THEN
5243: COMMIT;

Line 5278: Update gmd_wip_spec_vrs.

5274: RAISE WIP_SAMPLE_ORG;
5275: END IF;
5276:
5277: /*=====================================
5278: Update gmd_wip_spec_vrs.
5279: =====================================*/
5280: UPDATE gmd_wip_spec_vrs
5281: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5282: in_spec_lot_status_id = l_in_spec_status_id,

Line 5280: UPDATE gmd_wip_spec_vrs

5276:
5277: /*=====================================
5278: Update gmd_wip_spec_vrs.
5279: =====================================*/
5280: UPDATE gmd_wip_spec_vrs
5281: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5282: in_spec_lot_status_id = l_in_spec_status_id,
5283: organization_id = l_sample_organization_id,
5284: orgn_code = l_sample_orgn_code,

Line 5336: INSERT INTO gmd_wip_spec_vrs

5332: ELSE
5333: l_text_code := NULL;
5334: END IF;
5335:
5336: INSERT INTO gmd_wip_spec_vrs
5337: (
5338: SPEC_VR_ID,
5339: SPEC_ID,
5340: ORGN_CODE,

Line 5475: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5471: GMA_COMMON_LOGGING.gma_migration_central_log (
5472: p_run_id => p_migration_run_id,
5473: p_log_level => FND_LOG.LEVEL_ERROR,
5474: p_message_token => 'GMD_MIG_NO_ORG',
5475: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5476: p_token1 => 'ORG',
5477: p_token2 => 'ONAME',
5478: p_token3 => 'ROWK',
5479: p_token4 => 'ROWV',

Line 5493: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5489: GMA_COMMON_LOGGING.gma_migration_central_log (
5490: p_run_id => p_migration_run_id,
5491: p_log_level => FND_LOG.LEVEL_ERROR,
5492: p_message_token => 'GMD_MIG_STATUS_ID',
5493: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5494: p_token1 => 'STAT',
5495: p_token2 => 'ROWK',
5496: p_token3 => 'ROWV',
5497: p_param1 => l_wip_spec.in_spec_lot_status,

Line 5510: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5506: GMA_COMMON_LOGGING.gma_migration_central_log (
5507: p_run_id => p_migration_run_id,
5508: p_log_level => FND_LOG.LEVEL_ERROR,
5509: p_message_token => 'GMD_MIG_STATUS_ID',
5510: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5511: p_token1 => 'STAT',
5512: p_token2 => 'ROWK',
5513: p_token3 => 'ROWV',
5514: p_param1 => l_wip_spec.out_of_spec_lot_status,

Line 5528: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5524: p_run_id => p_migration_run_id,
5525: p_log_level => FND_LOG.LEVEL_EVENT,
5526: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5527: p_table_name => NULL,
5528: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5529: p_token1 => 'TAB',
5530: p_param1 => 'gmd_wip_spec_vrs',
5531: p_app_short_name => 'GMD');
5532:

Line 5530: p_param1 => 'gmd_wip_spec_vrs',

5526: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5527: p_table_name => NULL,
5528: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5529: p_token1 => 'TAB',
5530: p_param1 => 'gmd_wip_spec_vrs',
5531: p_app_short_name => 'GMD');
5532:
5533: WHEN WIP_SAMPLE_ORG THEN
5534: GMA_COMMON_LOGGING.gma_migration_central_log (

Line 5539: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5535: p_run_id => p_migration_run_id,
5536: p_log_level => FND_LOG.LEVEL_ERROR,
5537: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5538: p_table_name => NULL,
5539: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5540: p_token1 => 'ORG',
5541: p_token2 => 'ROWK',
5542: p_token3 => 'ROWV',
5543: p_param1 => l_sample_orgn_code,

Line 5556: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5552: p_run_id => p_migration_run_id,
5553: p_log_level => FND_LOG.LEVEL_ERROR,
5554: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5555: p_table_name => NULL,
5556: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5557: p_token1 => 'ORG',
5558: p_token2 => 'ROWK',
5559: p_token3 => 'ROWV',
5560: p_param1 => l_sample_orgn_code,

Line 5574: p_context => 'Quality Specifications - gmd_wip_spec_vrs',

5570: GMA_COMMON_LOGGING.gma_migration_central_log (
5571: p_run_id => p_migration_run_id,
5572: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5573: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5574: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5575: p_db_error => SQLERRM,
5576: p_app_short_name => 'GMA');
5577: ROLLBACK;
5578: x_exception_count := x_exception_count + 1;

Line 5588: Log end of gmd_wip_spec_vrs migration.

5584:
5585:
5586:
5587: /*==============================================
5588: Log end of gmd_wip_spec_vrs migration.
5589: ==============================================*/
5590:
5591: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5592: