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 277: p_param1 => 'gmd_wip_spec_vrs',

273: p_token2 => 'PRO',
274: p_token3 => 'UPD',
275: p_token4 => 'INS',
276: p_token5 => 'ERR',
277: p_param1 => 'gmd_wip_spec_vrs',
278: p_param2 => to_char(GMD_QC_MIG12.g_wip_spec_pro_count),
279: p_param3 => to_char(GMD_QC_MIG12.g_wip_spec_upd_count),
280: p_param4 => to_char(GMD_QC_MIG12.g_wip_spec_ins_count),
281: p_param5 => to_char(GMD_QC_MIG12.g_wip_spec_err_count),

Line 290: p_param1 => 'gmd_wip_spec_vrs',

286: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
287: p_context => 'Quality Specifications',
288: p_token1 => 'TAB',
289: p_token2 => 'DEL',
290: p_param1 => 'gmd_wip_spec_vrs',
291: p_param2 => to_char(GMD_QC_MIG12.g_wip_spec_del_count),
292: p_app_short_name => 'GMD');
293: END IF;
294:

Line 3894: -- gmd_wip_spec_vrs organization_id

3890: -- gmd_specifications_b owner_organization_id
3891: -- gmd_spec_tests_b test_qty_uom
3892: -- gmd_spec_tests_b to_qty_uom
3893: -- gmd_inventory_spec_vrs organization_id
3894: -- gmd_wip_spec_vrs organization_id
3895: -- gmd_customer_spec_vrs organization_id
3896: -- gmd_supplier_spec_vrs organization_id
3897: -- gmd_monitoring_spec_vrs organization_id
3898: -- gmd_monitoring_spec_vrs resource_organization_id

Line 4103: SELECT * from gmd_wip_spec_vrs

4099:
4100: -- Bug# 5109249
4101: -- Commented the organization_id from the where clause
4102: CURSOR get_wip_spec IS
4103: SELECT * from gmd_wip_spec_vrs
4104: WHERE migrated_ind IS NULL
4105: --AND organization_id IS NULL
4106: ORDER BY orgn_code;
4107:

Line 4108: l_wip_spec gmd_wip_spec_vrs%ROWTYPE;

4104: WHERE migrated_ind IS NULL
4105: --AND organization_id IS NULL
4106: ORDER BY orgn_code;
4107:
4108: l_wip_spec gmd_wip_spec_vrs%ROWTYPE;
4109: l_wip_org_id gmd_wip_spec_vrs.organization_id%TYPE;
4110:
4111: /*=======================================
4112: Cursor to get orgn_codes for sample

Line 4109: l_wip_org_id gmd_wip_spec_vrs.organization_id%TYPE;

4105: --AND organization_id IS NULL
4106: ORDER BY orgn_code;
4107:
4108: l_wip_spec gmd_wip_spec_vrs%ROWTYPE;
4109: l_wip_org_id gmd_wip_spec_vrs.organization_id%TYPE;
4110:
4111: /*=======================================
4112: Cursor to get orgn_codes for sample
4113: that wip validity rule is tied to.

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

4112: Cursor to get orgn_codes for sample
4113: that wip validity rule is tied to.
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

Line 4119: gmd_wip_spec_vrs gwsv

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;
4123:

Line 4134: FROM gmd_wip_spec_vrs

4130: -- Commented the following cursor definition and added it with the new where clause.
4131:
4132: /*CURSOR check_wip_spec IS
4133: SELECT spec_vr_id
4134: FROM gmd_wip_spec_vrs
4135: WHERE orgn_code = l_sample_orgn_code;*/
4136:
4137: CURSOR check_wip_spec IS
4138: SELECT spec_vr_id

Line 4139: FROM gmd_wip_spec_vrs

4135: WHERE orgn_code = l_sample_orgn_code;*/
4136:
4137: CURSOR check_wip_spec IS
4138: SELECT spec_vr_id
4139: FROM gmd_wip_spec_vrs
4140: WHERE orgn_code = l_sample_orgn_code
4141: AND spec_id = l_wip_spec.spec_id
4142: AND ( (batch_id IS NULL AND l_wip_spec.batch_id IS NULL) OR
4143: (batch_id = l_wip_spec.batch_id)

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

4191: Cursor to get orgn_codes for sample
4192: that customer validity rule is tied to.
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

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

4253: Cursor to get orgn_codes for sample
4254: that supplier validity rule is tied to.
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

Line 5395: Migrate gmd_wip_spec_vrs.

5391: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5392:
5393:
5394: /*================================
5395: Migrate gmd_wip_spec_vrs.
5396: ================================*/
5397:
5398: GMA_COMMON_LOGGING.gma_migration_central_log (
5399: p_run_id => p_migration_run_id,

Line 5402: p_table_name => 'GMD_WIP_SPEC_VRS',

5398: GMA_COMMON_LOGGING.gma_migration_central_log (
5399: p_run_id => p_migration_run_id,
5400: p_log_level => FND_LOG.LEVEL_EVENT,
5401: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5402: p_table_name => 'GMD_WIP_SPEC_VRS',
5403: p_token1 => 'TABLE_NAME',
5404: p_param1 => 'GMD_WIP_SPEC_VRS',
5405: p_context => 'Quality Specifications',
5406: p_app_short_name => 'GMA');

Line 5404: p_param1 => 'GMD_WIP_SPEC_VRS',

5400: p_log_level => FND_LOG.LEVEL_EVENT,
5401: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5402: p_table_name => 'GMD_WIP_SPEC_VRS',
5403: p_token1 => 'TABLE_NAME',
5404: p_param1 => 'GMD_WIP_SPEC_VRS',
5405: p_context => 'Quality Specifications',
5406: p_app_short_name => 'GMA');
5407:
5408: GMD_QC_MIG12.g_progress_ind := 3;

Line 5475: Update gmd_wip_spec_vrs.

5471:
5472: IF (l_wip_spec.orgn_code IS NOT NULL) THEN
5473: l_organization_id := l_wip_org_id;
5474: /*=====================================
5475: Update gmd_wip_spec_vrs.
5476: =====================================*/
5477: UPDATE gmd_wip_spec_vrs
5478: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5479: in_spec_lot_status_id = l_in_spec_status_id,

Line 5477: UPDATE gmd_wip_spec_vrs

5473: l_organization_id := l_wip_org_id;
5474: /*=====================================
5475: Update gmd_wip_spec_vrs.
5476: =====================================*/
5477: UPDATE gmd_wip_spec_vrs
5478: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5479: in_spec_lot_status_id = l_in_spec_status_id,
5480: organization_id = l_organization_id,
5481: material_detail_id = l_material_detail_id, -- Bug# 5482253

Line 5508: DELETE gmd_wip_spec_vrs

5504: /*==========================================
5505: This is not marked as an error.
5506: ==========================================*/
5507:
5508: DELETE gmd_wip_spec_vrs
5509: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5510:
5511: IF (p_commit = FND_API.G_TRUE) THEN
5512: COMMIT;

Line 5547: Update gmd_wip_spec_vrs.

5543: RAISE WIP_SAMPLE_ORG;
5544: END IF;
5545:
5546: /*=====================================
5547: Update gmd_wip_spec_vrs.
5548: =====================================*/
5549: UPDATE gmd_wip_spec_vrs
5550: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5551: in_spec_lot_status_id = l_in_spec_status_id,

Line 5549: UPDATE gmd_wip_spec_vrs

5545:
5546: /*=====================================
5547: Update gmd_wip_spec_vrs.
5548: =====================================*/
5549: UPDATE gmd_wip_spec_vrs
5550: SET out_of_spec_lot_status_id = l_out_spec_status_id,
5551: in_spec_lot_status_id = l_in_spec_status_id,
5552: organization_id = l_sample_organization_id,
5553: orgn_code = l_sample_orgn_code,

Line 5605: INSERT INTO gmd_wip_spec_vrs

5601: ELSE
5602: l_text_code := NULL;
5603: END IF;
5604:
5605: INSERT INTO gmd_wip_spec_vrs
5606: (
5607: SPEC_VR_ID,
5608: SPEC_ID,
5609: ORGN_CODE,

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

5740: GMA_COMMON_LOGGING.gma_migration_central_log (
5741: p_run_id => p_migration_run_id,
5742: p_log_level => FND_LOG.LEVEL_ERROR,
5743: p_message_token => 'GMD_MIG_NO_ORG',
5744: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5745: p_token1 => 'ORG',
5746: p_token2 => 'ONAME',
5747: p_token3 => 'ROWK',
5748: p_token4 => 'ROWV',

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

5758: GMA_COMMON_LOGGING.gma_migration_central_log (
5759: p_run_id => p_migration_run_id,
5760: p_log_level => FND_LOG.LEVEL_ERROR,
5761: p_message_token => 'GMD_MIG_STATUS_ID',
5762: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5763: p_token1 => 'STAT',
5764: p_token2 => 'ROWK',
5765: p_token3 => 'ROWV',
5766: p_param1 => l_wip_spec.in_spec_lot_status,

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

5775: GMA_COMMON_LOGGING.gma_migration_central_log (
5776: p_run_id => p_migration_run_id,
5777: p_log_level => FND_LOG.LEVEL_ERROR,
5778: p_message_token => 'GMD_MIG_STATUS_ID',
5779: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5780: p_token1 => 'STAT',
5781: p_token2 => 'ROWK',
5782: p_token3 => 'ROWV',
5783: p_param1 => l_wip_spec.out_of_spec_lot_status,

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

5793: p_run_id => p_migration_run_id,
5794: p_log_level => FND_LOG.LEVEL_EVENT,
5795: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5796: p_table_name => NULL,
5797: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5798: p_token1 => 'TAB',
5799: p_param1 => 'gmd_wip_spec_vrs',
5800: p_app_short_name => 'GMD');
5801:

Line 5799: p_param1 => 'gmd_wip_spec_vrs',

5795: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5796: p_table_name => NULL,
5797: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5798: p_token1 => 'TAB',
5799: p_param1 => 'gmd_wip_spec_vrs',
5800: p_app_short_name => 'GMD');
5801:
5802: WHEN WIP_SAMPLE_ORG THEN
5803: GMA_COMMON_LOGGING.gma_migration_central_log (

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

5804: p_run_id => p_migration_run_id,
5805: p_log_level => FND_LOG.LEVEL_ERROR,
5806: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5807: p_table_name => NULL,
5808: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5809: p_token1 => 'ORG',
5810: p_token2 => 'ROWK',
5811: p_token3 => 'ROWV',
5812: p_param1 => l_sample_orgn_code,

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

5821: p_run_id => p_migration_run_id,
5822: p_log_level => FND_LOG.LEVEL_ERROR,
5823: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5824: p_table_name => NULL,
5825: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5826: p_token1 => 'ORG',
5827: p_token2 => 'ROWK',
5828: p_token3 => 'ROWV',
5829: p_param1 => l_sample_orgn_code,

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

5839: GMA_COMMON_LOGGING.gma_migration_central_log (
5840: p_run_id => p_migration_run_id,
5841: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5842: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5843: p_context => 'Quality Specifications - gmd_wip_spec_vrs',
5844: p_db_error => SQLERRM,
5845: p_app_short_name => 'GMA');
5846: ROLLBACK;
5847: x_exception_count := x_exception_count + 1;

Line 5857: Log end of gmd_wip_spec_vrs migration.

5853:
5854:
5855:
5856: /*==============================================
5857: Log end of gmd_wip_spec_vrs migration.
5858: ==============================================*/
5859:
5860: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5861: