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_INVENTORY_SPEC_VRS

Line 248: p_param1 => 'gmd_inventory_spec_vrs',

244: p_token2 => 'PRO',
245: p_token3 => 'UPD',
246: p_token4 => 'INS',
247: p_token5 => 'ERR',
248: p_param1 => 'gmd_inventory_spec_vrs',
249: p_param2 => to_char(GMD_QC_MIG12.g_inv_spec_pro_count),
250: p_param3 => to_char(GMD_QC_MIG12.g_inv_spec_upd_count),
251: p_param4 => to_char(GMD_QC_MIG12.g_inv_spec_ins_count),
252: p_param5 => to_char(GMD_QC_MIG12.g_inv_spec_err_count),

Line 261: p_param1 => 'gmd_inventory_spec_vrs',

257: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
258: p_context => 'Quality Specifications',
259: p_token1 => 'TAB',
260: p_token2 => 'DEL',
261: p_param1 => 'gmd_inventory_spec_vrs',
262: p_param2 => to_char(GMD_QC_MIG12.g_inv_spec_del_count),
263: p_app_short_name => 'GMD');
264: END IF;
265:

Line 3893: -- gmd_inventory_spec_vrs organization_id

3889: --
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

Line 4005: Cursor for gmd_inventory_spec_vrs.

4001: l_spec_inv_item_id gmd_specifications_b.inventory_item_id%TYPE;
4002: l_owner_org_id gmd_specifications_b.owner_organization_id%TYPE;
4003:
4004: /*=======================================
4005: Cursor for gmd_inventory_spec_vrs.
4006: =======================================*/
4007:
4008: CURSOR get_inv_spec IS
4009: SELECT * from gmd_inventory_spec_vrs

Line 4009: SELECT * from gmd_inventory_spec_vrs

4005: Cursor for gmd_inventory_spec_vrs.
4006: =======================================*/
4007:
4008: CURSOR get_inv_spec IS
4009: SELECT * from gmd_inventory_spec_vrs
4010: WHERE migrated_ind IS NULL
4011: ORDER BY orgn_code;
4012:
4013: l_inv_spec gmd_inventory_spec_vrs%ROWTYPE;

Line 4013: l_inv_spec gmd_inventory_spec_vrs%ROWTYPE;

4009: SELECT * from gmd_inventory_spec_vrs
4010: WHERE migrated_ind IS NULL
4011: ORDER BY orgn_code;
4012:
4013: l_inv_spec gmd_inventory_spec_vrs%ROWTYPE;
4014:
4015:
4016: /*=======================================
4017: Cursor to get Item_id for a Lot.

Line 4041: Cursor to check if gmd_inventory_spec_vrs exists.

4037:
4038: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
4039:
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:

Line 4051: FROM gmd_inventory_spec_vrs

4047: -- Commented the following cursor definition and added it with the new where clause.
4048:
4049: /*CURSOR check_inv_spec IS
4050: SELECT spec_vr_id
4051: FROM gmd_inventory_spec_vrs
4052: WHERE orgn_code = l_sample_orgn_code
4053: AND whse_code = l_inv_spec.whse_code
4054: AND location = l_inv_spec.location
4055: AND lot_no = l_inv_spec.lot_no

Line 4060: FROM gmd_inventory_spec_vrs

4056: AND sublot_no = l_inv_spec.sublot_no;*/
4057:
4058: CURSOR check_inv_spec IS
4059: SELECT spec_vr_id
4060: FROM gmd_inventory_spec_vrs
4061: WHERE orgn_code = l_sample_orgn_code
4062: AND spec_id = l_inv_spec.spec_id
4063: AND ( (whse_code IS NULL AND l_inv_spec.whse_code IS NULL) OR
4064: (whse_code = l_inv_spec.whse_code)

Line 4077: l_check_vrid gmd_inventory_spec_vrs.spec_vr_id%TYPE;

4073: (sublot_no = l_inv_spec.sublot_no)
4074: );
4075:
4076:
4077: l_check_vrid gmd_inventory_spec_vrs.spec_vr_id%TYPE;
4078:
4079:
4080: /*=======================================
4081: Cursor to get orgn_codes for sample

Line 4085: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS

4081: Cursor to get orgn_codes for sample
4082: that inventory validity rule is tied to.
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

Line 4088: gmd_inventory_spec_vrs gisv

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

Line 4498: Migrate gmd_inventory_spec_vrs.

4494: Quality script.
4495: ===============================================*/
4496:
4497: /*=======================================
4498: Migrate gmd_inventory_spec_vrs.
4499: =======================================*/
4500:
4501: GMA_COMMON_LOGGING.gma_migration_central_log (
4502: p_run_id => p_migration_run_id,

Line 4505: p_table_name => 'GMD_INVENTORY_SPEC_VRS',

4501: GMA_COMMON_LOGGING.gma_migration_central_log (
4502: p_run_id => p_migration_run_id,
4503: p_log_level => FND_LOG.LEVEL_EVENT,
4504: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4505: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
4506: p_token1 => 'TABLE_NAME',
4507: p_param1 => 'GMD_INVENTORY_SPEC_VRS',
4508: p_context => 'Quality Specifications',
4509: p_app_short_name => 'GMA');

Line 4507: p_param1 => 'GMD_INVENTORY_SPEC_VRS',

4503: p_log_level => FND_LOG.LEVEL_EVENT,
4504: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4505: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
4506: p_token1 => 'TABLE_NAME',
4507: p_param1 => 'GMD_INVENTORY_SPEC_VRS',
4508: p_context => 'Quality Specifications',
4509: p_app_short_name => 'GMA');
4510:
4511: GMD_QC_MIG12.g_progress_ind := 2;

Line 4729: Update gmd_inventory_spec_vrs

4725:
4726: IF (l_clone = 0) THEN
4727:
4728: /*================================
4729: Update gmd_inventory_spec_vrs
4730: ================================*/
4731:
4732: UPDATE gmd_inventory_spec_vrs
4733: SET organization_id = l_organization_id,

Line 4732: UPDATE gmd_inventory_spec_vrs

4728: /*================================
4729: Update gmd_inventory_spec_vrs
4730: ================================*/
4731:
4732: UPDATE gmd_inventory_spec_vrs
4733: SET organization_id = l_organization_id,
4734: lot_number = l_lot_number,
4735: parent_lot_number = l_parent_lot_number,
4736: subinventory = l_subinventory,

Line 4767: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

4763: p_run_id => p_migration_run_id,
4764: p_log_level => FND_LOG.LEVEL_EVENT,
4765: p_message_token => 'GMD_MIG_SPEC_DELETE',
4766: p_table_name => NULL,
4767: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4768: p_token1 => 'TAB',
4769: p_token2 => 'ORG',
4770: p_token3 => 'LOT',
4771: p_token4 => 'SUBLOT',

Line 4772: p_param1 => 'gmd_inventory_spec_vrs',

4768: p_token1 => 'TAB',
4769: p_token2 => 'ORG',
4770: p_token3 => 'LOT',
4771: p_token4 => 'SUBLOT',
4772: p_param1 => 'gmd_inventory_spec_vrs',
4773: p_param2 => NVL(l_inv_spec.orgn_code,' '),
4774: p_param3 => NVL(l_inv_spec.lot_no,' '),
4775: p_param4 => NVL(l_inv_spec.sublot_no,' '),
4776: p_app_short_name => 'GMD');

Line 4782: DELETE gmd_inventory_spec_vrs

4778: /*==========================================
4779: This is not marked as an error.
4780: ==========================================*/
4781:
4782: DELETE gmd_inventory_spec_vrs
4783: WHERE spec_vr_id = l_inv_spec.spec_vr_id;
4784:
4785: IF (p_commit = FND_API.G_TRUE) THEN
4786: COMMIT;

Line 4870: UPDATE gmd_inventory_spec_vrs

4866: RAISE ISPEC_MIG_LOT;
4867: END IF;
4868: END IF;
4869:
4870: UPDATE gmd_inventory_spec_vrs
4871: SET organization_id = l_sample_organization_id,
4872: orgn_code = l_sample_orgn_code,
4873: lot_number = l_lot_number,
4874: parent_lot_number = l_parent_lot_number,

Line 4985: INSERT INTO gmd_inventory_spec_vrs (

4981: ELSE
4982: l_text_code := NULL;
4983: END IF;
4984:
4985: INSERT INTO gmd_inventory_spec_vrs (
4986: SPEC_VR_ID,
4987: SPEC_ID,
4988: ORGN_CODE,
4989: LOT_ID,

Line 5109: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5105: GMA_COMMON_LOGGING.gma_migration_central_log (
5106: p_run_id => p_migration_run_id,
5107: p_log_level => FND_LOG.LEVEL_ERROR,
5108: p_message_token => 'GMD_MIG_NO_ORG',
5109: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5110: p_token1 => 'ORG',
5111: p_token2 => 'ONAME',
5112: p_token3 => 'ROWK',
5113: p_token4 => 'ROWV',

Line 5131: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5127: p_run_id => p_migration_run_id,
5128: p_log_level => FND_LOG.LEVEL_ERROR,
5129: p_message_token => 'GMD_MIG_WHSE_ERROR',
5130: p_table_name => NULL,
5131: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5132: p_token1 => 'WHSE',
5133: p_token2 => 'WNAME',
5134: p_token3 => 'ROWK',
5135: p_token4 => 'ROWV',

Line 5151: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5147: p_run_id => p_migration_run_id,
5148: p_log_level => FND_LOG.LEVEL_ERROR,
5149: p_message_token => 'GMD_MIG_ISPEC_SUB_MISMATCH',
5150: p_table_name => NULL,
5151: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5152: p_token1 => 'VRID',
5153: p_token2 => 'ORG',
5154: p_token3 => 'WHSE',
5155: p_token4 => 'ORGID',

Line 5172: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5168: GMA_COMMON_LOGGING.gma_migration_central_log (
5169: p_run_id => p_migration_run_id,
5170: p_log_level => FND_LOG.LEVEL_ERROR,
5171: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
5172: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5173: p_token1 => 'ROWK',
5174: p_token2 => 'ROWV',
5175: p_token3 => 'FNAME',
5176: p_param1 => 'SPEC_VR_ID',

Line 5190: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5186: GMA_COMMON_LOGGING.gma_migration_central_log (
5187: p_run_id => p_migration_run_id,
5188: p_log_level => FND_LOG.LEVEL_ERROR,
5189: p_message_token => 'GMD_MIG_LOCATOR_ID',
5190: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5191: p_token1 => 'WHSE',
5192: p_token2 => 'LOCATION',
5193: p_token3 => 'LFIELD',
5194: p_token4 => 'ROWK',

Line 5212: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5208: GMA_COMMON_LOGGING.gma_migration_central_log (
5209: p_run_id => p_migration_run_id,
5210: p_log_level => FND_LOG.LEVEL_ERROR,
5211: p_message_token => 'GMD_MIG_SUBINV',
5212: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5213: p_token1 => 'LOCATOR',
5214: p_token2 => 'ROWK',
5215: p_token3 => 'ROWV',
5216: p_param1 => to_char(l_locator_id),

Line 5230: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5226: GMA_COMMON_LOGGING.gma_migration_central_log (
5227: p_run_id => p_migration_run_id,
5228: p_log_level => FND_LOG.LEVEL_ERROR,
5229: p_message_token => 'GMD_MIG_GET_OPM_LOT',
5230: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5231: p_token1 => 'LOTID',
5232: p_token2 => 'ROWK',
5233: p_token3 => 'ROWV',
5234: p_param1 => to_char(l_inv_spec.lot_id),

Line 5247: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5243: GMA_COMMON_LOGGING.gma_migration_central_log (
5244: p_run_id => p_migration_run_id,
5245: p_log_level => FND_LOG.LEVEL_ERROR,
5246: p_message_token => 'GMD_MIG_GET_ITEM_SPEC',
5247: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5248: p_token1 => 'SPECID',
5249: p_token2 => 'ROWK',
5250: p_token3 => 'ROWV',
5251: p_param1 => to_char(l_inv_spec.spec_id),

Line 5265: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5261: GMA_COMMON_LOGGING.gma_migration_central_log (
5262: p_run_id => p_migration_run_id,
5263: p_log_level => FND_LOG.LEVEL_ERROR,
5264: p_message_token => 'GMD_MIG_OPM_ITEM',
5265: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5266: p_token1 => 'ITEMID',
5267: p_token2 => 'ROWK',
5268: p_token3 => 'ROWV',
5269: p_param1 => to_char(l_item_id),

Line 5283: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5279: GMA_COMMON_LOGGING.gma_migration_central_log (
5280: p_run_id => p_migration_run_id,
5281: p_log_level => FND_LOG.LEVEL_ERROR,
5282: p_message_token => 'GMD_MIG_LOT',
5283: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5284: p_token1 => 'ROWK',
5285: p_token2 => 'ROWV',
5286: p_param1 => 'SPEC_VR_ID',
5287: p_param2 => to_char(l_inv_spec.spec_vr_id),

Line 5299: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5295: GMA_COMMON_LOGGING.gma_migration_central_log (
5296: p_run_id => p_migration_run_id,
5297: p_log_level => FND_LOG.LEVEL_ERROR,
5298: p_message_token => 'GMD_MIG_STATUS_ID',
5299: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5300: p_token1 => 'STAT',
5301: p_token2 => 'ROWK',
5302: p_token3 => 'ROWV',
5303: p_param1 => l_inv_spec.in_spec_lot_status,

Line 5317: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5313: GMA_COMMON_LOGGING.gma_migration_central_log (
5314: p_run_id => p_migration_run_id,
5315: p_log_level => FND_LOG.LEVEL_ERROR,
5316: p_message_token => 'GMD_MIG_STATUS_ID',
5317: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5318: p_token1 => 'STAT',
5319: p_token2 => 'ROWK',
5320: p_token3 => 'ROWV',
5321: p_param1 => l_inv_spec.out_of_spec_lot_status,

Line 5338: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5334: p_run_id => p_migration_run_id,
5335: p_log_level => FND_LOG.LEVEL_ERROR,
5336: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5337: p_table_name => NULL,
5338: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5339: p_token1 => 'ORG',
5340: p_token2 => 'ROWK',
5341: p_token3 => 'ROWV',
5342: p_param1 => l_sample_orgn_code,

Line 5357: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5353: p_run_id => p_migration_run_id,
5354: p_log_level => FND_LOG.LEVEL_ERROR,
5355: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5356: p_table_name => NULL,
5357: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5358: p_token1 => 'ORG',
5359: p_token2 => 'ROWK',
5360: p_token3 => 'ROWV',
5361: p_param1 => l_sample_orgn_code,

Line 5375: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',

5371: GMA_COMMON_LOGGING.gma_migration_central_log (
5372: p_run_id => p_migration_run_id,
5373: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5374: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5375: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5376: p_db_error => SQLERRM,
5377: p_app_short_name => 'GMA');
5378: ROLLBACK;
5379: x_exception_count := x_exception_count + 1;

Line 5388: Log end of gmd_inventory_spec_vrs migration.

5384:
5385:
5386:
5387: /*==============================================
5388: Log end of gmd_inventory_spec_vrs migration.
5389: ==============================================*/
5390:
5391: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5392: