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 240: p_param1 => 'gmd_inventory_spec_vrs',

236: p_token2 => 'PRO',
237: p_token3 => 'UPD',
238: p_token4 => 'INS',
239: p_token5 => 'ERR',
240: p_param1 => 'gmd_inventory_spec_vrs',
241: p_param2 => to_char(GMD_QC_MIG12.g_inv_spec_pro_count),
242: p_param3 => to_char(GMD_QC_MIG12.g_inv_spec_upd_count),
243: p_param4 => to_char(GMD_QC_MIG12.g_inv_spec_ins_count),
244: p_param5 => to_char(GMD_QC_MIG12.g_inv_spec_err_count),

Line 253: p_param1 => 'gmd_inventory_spec_vrs',

249: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
250: p_context => 'Quality Specifications',
251: p_token1 => 'TAB',
252: p_token2 => 'DEL',
253: p_param1 => 'gmd_inventory_spec_vrs',
254: p_param2 => to_char(GMD_QC_MIG12.g_inv_spec_del_count),
255: p_app_short_name => 'GMD');
256: END IF;
257:

Line 3624: -- gmd_inventory_spec_vrs organization_id

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

Line 3736: Cursor for gmd_inventory_spec_vrs.

3732: l_spec_inv_item_id gmd_specifications_b.inventory_item_id%TYPE;
3733: l_owner_org_id gmd_specifications_b.owner_organization_id%TYPE;
3734:
3735: /*=======================================
3736: Cursor for gmd_inventory_spec_vrs.
3737: =======================================*/
3738:
3739: CURSOR get_inv_spec IS
3740: SELECT * from gmd_inventory_spec_vrs

Line 3740: SELECT * from gmd_inventory_spec_vrs

3736: Cursor for gmd_inventory_spec_vrs.
3737: =======================================*/
3738:
3739: CURSOR get_inv_spec IS
3740: SELECT * from gmd_inventory_spec_vrs
3741: WHERE migrated_ind IS NULL
3742: ORDER BY orgn_code;
3743:
3744: l_inv_spec gmd_inventory_spec_vrs%ROWTYPE;

Line 3744: l_inv_spec gmd_inventory_spec_vrs%ROWTYPE;

3740: SELECT * from gmd_inventory_spec_vrs
3741: WHERE migrated_ind IS NULL
3742: ORDER BY orgn_code;
3743:
3744: l_inv_spec gmd_inventory_spec_vrs%ROWTYPE;
3745:
3746:
3747: /*=======================================
3748: Cursor to get Item_id for a Lot.

Line 3772: Cursor to check if gmd_inventory_spec_vrs exists.

3768:
3769: l_sublot_ctl ic_item_mst_b.sublot_ctl%TYPE;
3770:
3771: /*====================================================
3772: Cursor to check if gmd_inventory_spec_vrs exists.
3773: ====================================================*/
3774:
3775: l_sample_orgn_code gmd_sampling_events.orgn_code%TYPE;
3776:

Line 3782: FROM gmd_inventory_spec_vrs

3778: -- Commented the following cursor definition and added it with the new where clause.
3779:
3780: /*CURSOR check_inv_spec IS
3781: SELECT spec_vr_id
3782: FROM gmd_inventory_spec_vrs
3783: WHERE orgn_code = l_sample_orgn_code
3784: AND whse_code = l_inv_spec.whse_code
3785: AND location = l_inv_spec.location
3786: AND lot_no = l_inv_spec.lot_no

Line 3791: FROM gmd_inventory_spec_vrs

3787: AND sublot_no = l_inv_spec.sublot_no;*/
3788:
3789: CURSOR check_inv_spec IS
3790: SELECT spec_vr_id
3791: FROM gmd_inventory_spec_vrs
3792: WHERE orgn_code = l_sample_orgn_code
3793: AND spec_id = l_inv_spec.spec_id
3794: AND ( (whse_code IS NULL AND l_inv_spec.whse_code IS NULL) OR
3795: (whse_code = l_inv_spec.whse_code)

Line 3808: l_check_vrid gmd_inventory_spec_vrs.spec_vr_id%TYPE;

3804: (sublot_no = l_inv_spec.sublot_no)
3805: );
3806:
3807:
3808: l_check_vrid gmd_inventory_spec_vrs.spec_vr_id%TYPE;
3809:
3810:
3811: /*=======================================
3812: Cursor to get orgn_codes for sample

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

3812: Cursor to get orgn_codes for sample
3813: that inventory validity rule is tied to.
3814: =======================================*/
3815:
3816: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS
3817: SELECT DISTINCT gse.orgn_code, gse.organization_id
3818: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3819: gmd_inventory_spec_vrs gisv
3820: WHERE gse.sampling_event_id = gesd.sampling_event_id

Line 3819: gmd_inventory_spec_vrs gisv

3815:
3816: CURSOR get_sample_org (v_spec_id gmd_inventory_spec_vrs.spec_vr_id%TYPE) IS
3817: SELECT DISTINCT gse.orgn_code, gse.organization_id
3818: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3819: gmd_inventory_spec_vrs gisv
3820: WHERE gse.sampling_event_id = gesd.sampling_event_id
3821: AND gesd.spec_vr_id = gisv.spec_vr_id
3822: AND gisv.spec_vr_id = v_spec_id;
3823:

Line 4229: Migrate gmd_inventory_spec_vrs.

4225: Quality script.
4226: ===============================================*/
4227:
4228: /*=======================================
4229: Migrate gmd_inventory_spec_vrs.
4230: =======================================*/
4231:
4232: GMA_COMMON_LOGGING.gma_migration_central_log (
4233: p_run_id => p_migration_run_id,

Line 4236: p_table_name => 'GMD_INVENTORY_SPEC_VRS',

4232: GMA_COMMON_LOGGING.gma_migration_central_log (
4233: p_run_id => p_migration_run_id,
4234: p_log_level => FND_LOG.LEVEL_EVENT,
4235: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4236: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
4237: p_token1 => 'TABLE_NAME',
4238: p_param1 => 'GMD_INVENTORY_SPEC_VRS',
4239: p_context => 'Quality Specifications',
4240: p_app_short_name => 'GMA');

Line 4238: p_param1 => 'GMD_INVENTORY_SPEC_VRS',

4234: p_log_level => FND_LOG.LEVEL_EVENT,
4235: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4236: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
4237: p_token1 => 'TABLE_NAME',
4238: p_param1 => 'GMD_INVENTORY_SPEC_VRS',
4239: p_context => 'Quality Specifications',
4240: p_app_short_name => 'GMA');
4241:
4242: GMD_QC_MIG12.g_progress_ind := 2;

Line 4460: Update gmd_inventory_spec_vrs

4456:
4457: IF (l_clone = 0) THEN
4458:
4459: /*================================
4460: Update gmd_inventory_spec_vrs
4461: ================================*/
4462:
4463: UPDATE gmd_inventory_spec_vrs
4464: SET organization_id = l_organization_id,

Line 4463: UPDATE gmd_inventory_spec_vrs

4459: /*================================
4460: Update gmd_inventory_spec_vrs
4461: ================================*/
4462:
4463: UPDATE gmd_inventory_spec_vrs
4464: SET organization_id = l_organization_id,
4465: lot_number = l_lot_number,
4466: parent_lot_number = l_parent_lot_number,
4467: subinventory = l_subinventory,

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

4494: p_run_id => p_migration_run_id,
4495: p_log_level => FND_LOG.LEVEL_EVENT,
4496: p_message_token => 'GMD_MIG_SPEC_DELETE',
4497: p_table_name => NULL,
4498: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4499: p_token1 => 'TAB',
4500: p_token2 => 'ORG',
4501: p_token3 => 'LOT',
4502: p_token4 => 'SUBLOT',

Line 4503: p_param1 => 'gmd_inventory_spec_vrs',

4499: p_token1 => 'TAB',
4500: p_token2 => 'ORG',
4501: p_token3 => 'LOT',
4502: p_token4 => 'SUBLOT',
4503: p_param1 => 'gmd_inventory_spec_vrs',
4504: p_param2 => NVL(l_inv_spec.orgn_code,' '),
4505: p_param3 => NVL(l_inv_spec.lot_no,' '),
4506: p_param4 => NVL(l_inv_spec.sublot_no,' '),
4507: p_app_short_name => 'GMD');

Line 4513: DELETE gmd_inventory_spec_vrs

4509: /*==========================================
4510: This is not marked as an error.
4511: ==========================================*/
4512:
4513: DELETE gmd_inventory_spec_vrs
4514: WHERE spec_vr_id = l_inv_spec.spec_vr_id;
4515:
4516: IF (p_commit = FND_API.G_TRUE) THEN
4517: COMMIT;

Line 4601: UPDATE gmd_inventory_spec_vrs

4597: RAISE ISPEC_MIG_LOT;
4598: END IF;
4599: END IF;
4600:
4601: UPDATE gmd_inventory_spec_vrs
4602: SET organization_id = l_sample_organization_id,
4603: orgn_code = l_sample_orgn_code,
4604: lot_number = l_lot_number,
4605: parent_lot_number = l_parent_lot_number,

Line 4716: INSERT INTO gmd_inventory_spec_vrs (

4712: ELSE
4713: l_text_code := NULL;
4714: END IF;
4715:
4716: INSERT INTO gmd_inventory_spec_vrs (
4717: SPEC_VR_ID,
4718: SPEC_ID,
4719: ORGN_CODE,
4720: LOT_ID,

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

4836: GMA_COMMON_LOGGING.gma_migration_central_log (
4837: p_run_id => p_migration_run_id,
4838: p_log_level => FND_LOG.LEVEL_ERROR,
4839: p_message_token => 'GMD_MIG_NO_ORG',
4840: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4841: p_token1 => 'ORG',
4842: p_token2 => 'ONAME',
4843: p_token3 => 'ROWK',
4844: p_token4 => 'ROWV',

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

4858: p_run_id => p_migration_run_id,
4859: p_log_level => FND_LOG.LEVEL_ERROR,
4860: p_message_token => 'GMD_MIG_WHSE_ERROR',
4861: p_table_name => NULL,
4862: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4863: p_token1 => 'WHSE',
4864: p_token2 => 'WNAME',
4865: p_token3 => 'ROWK',
4866: p_token4 => 'ROWV',

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

4878: p_run_id => p_migration_run_id,
4879: p_log_level => FND_LOG.LEVEL_ERROR,
4880: p_message_token => 'GMD_MIG_ISPEC_SUB_MISMATCH',
4881: p_table_name => NULL,
4882: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4883: p_token1 => 'VRID',
4884: p_token2 => 'ORG',
4885: p_token3 => 'WHSE',
4886: p_token4 => 'ORGID',

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

4899: GMA_COMMON_LOGGING.gma_migration_central_log (
4900: p_run_id => p_migration_run_id,
4901: p_log_level => FND_LOG.LEVEL_ERROR,
4902: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
4903: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4904: p_token1 => 'ROWK',
4905: p_token2 => 'ROWV',
4906: p_token3 => 'FNAME',
4907: p_param1 => 'SPEC_VR_ID',

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

4917: GMA_COMMON_LOGGING.gma_migration_central_log (
4918: p_run_id => p_migration_run_id,
4919: p_log_level => FND_LOG.LEVEL_ERROR,
4920: p_message_token => 'GMD_MIG_LOCATOR_ID',
4921: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4922: p_token1 => 'WHSE',
4923: p_token2 => 'LOCATION',
4924: p_token3 => 'LFIELD',
4925: p_token4 => 'ROWK',

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

4939: GMA_COMMON_LOGGING.gma_migration_central_log (
4940: p_run_id => p_migration_run_id,
4941: p_log_level => FND_LOG.LEVEL_ERROR,
4942: p_message_token => 'GMD_MIG_SUBINV',
4943: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4944: p_token1 => 'LOCATOR',
4945: p_token2 => 'ROWK',
4946: p_token3 => 'ROWV',
4947: p_param1 => to_char(l_locator_id),

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

4957: GMA_COMMON_LOGGING.gma_migration_central_log (
4958: p_run_id => p_migration_run_id,
4959: p_log_level => FND_LOG.LEVEL_ERROR,
4960: p_message_token => 'GMD_MIG_GET_OPM_LOT',
4961: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4962: p_token1 => 'LOTID',
4963: p_token2 => 'ROWK',
4964: p_token3 => 'ROWV',
4965: p_param1 => to_char(l_inv_spec.lot_id),

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

4974: GMA_COMMON_LOGGING.gma_migration_central_log (
4975: p_run_id => p_migration_run_id,
4976: p_log_level => FND_LOG.LEVEL_ERROR,
4977: p_message_token => 'GMD_MIG_GET_ITEM_SPEC',
4978: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4979: p_token1 => 'SPECID',
4980: p_token2 => 'ROWK',
4981: p_token3 => 'ROWV',
4982: p_param1 => to_char(l_inv_spec.spec_id),

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

4992: GMA_COMMON_LOGGING.gma_migration_central_log (
4993: p_run_id => p_migration_run_id,
4994: p_log_level => FND_LOG.LEVEL_ERROR,
4995: p_message_token => 'GMD_MIG_OPM_ITEM',
4996: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
4997: p_token1 => 'ITEMID',
4998: p_token2 => 'ROWK',
4999: p_token3 => 'ROWV',
5000: p_param1 => to_char(l_item_id),

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

5010: GMA_COMMON_LOGGING.gma_migration_central_log (
5011: p_run_id => p_migration_run_id,
5012: p_log_level => FND_LOG.LEVEL_ERROR,
5013: p_message_token => 'GMD_MIG_LOT',
5014: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5015: p_token1 => 'ROWK',
5016: p_token2 => 'ROWV',
5017: p_param1 => 'SPEC_VR_ID',
5018: p_param2 => to_char(l_inv_spec.spec_vr_id),

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

5026: GMA_COMMON_LOGGING.gma_migration_central_log (
5027: p_run_id => p_migration_run_id,
5028: p_log_level => FND_LOG.LEVEL_ERROR,
5029: p_message_token => 'GMD_MIG_STATUS_ID',
5030: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5031: p_token1 => 'STAT',
5032: p_token2 => 'ROWK',
5033: p_token3 => 'ROWV',
5034: p_param1 => l_inv_spec.in_spec_lot_status,

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

5044: GMA_COMMON_LOGGING.gma_migration_central_log (
5045: p_run_id => p_migration_run_id,
5046: p_log_level => FND_LOG.LEVEL_ERROR,
5047: p_message_token => 'GMD_MIG_STATUS_ID',
5048: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5049: p_token1 => 'STAT',
5050: p_token2 => 'ROWK',
5051: p_token3 => 'ROWV',
5052: p_param1 => l_inv_spec.out_of_spec_lot_status,

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

5065: p_run_id => p_migration_run_id,
5066: p_log_level => FND_LOG.LEVEL_ERROR,
5067: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5068: p_table_name => NULL,
5069: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5070: p_token1 => 'ORG',
5071: p_token2 => 'ROWK',
5072: p_token3 => 'ROWV',
5073: p_param1 => l_sample_orgn_code,

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

5084: p_run_id => p_migration_run_id,
5085: p_log_level => FND_LOG.LEVEL_ERROR,
5086: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5087: p_table_name => NULL,
5088: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5089: p_token1 => 'ORG',
5090: p_token2 => 'ROWK',
5091: p_token3 => 'ROWV',
5092: p_param1 => l_sample_orgn_code,

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

5102: GMA_COMMON_LOGGING.gma_migration_central_log (
5103: p_run_id => p_migration_run_id,
5104: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5105: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5106: p_context => 'Quality Specifications - gmd_inventory_spec_vrs',
5107: p_db_error => SQLERRM,
5108: p_app_short_name => 'GMA');
5109: ROLLBACK;
5110: x_exception_count := x_exception_count + 1;

Line 5119: Log end of gmd_inventory_spec_vrs migration.

5115:
5116:
5117:
5118: /*==============================================
5119: Log end of gmd_inventory_spec_vrs migration.
5120: ==============================================*/
5121:
5122: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5123: