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_SPECIFICATIONS_B

Line 229: p_param1 => 'gmd_specifications_b',

225: p_token2 => 'PRO',
226: p_token3 => 'UPD',
227: p_token4 => 'INS',
228: p_token5 => 'ERR',
229: p_param1 => 'gmd_specifications_b',
230: p_param2 => to_char(GMD_QC_MIG12.g_specs_pro_count),
231: p_param3 => to_char(GMD_QC_MIG12.g_specs_upd_count),
232: p_param4 => 0,
233: p_param5 => to_char(GMD_QC_MIG12.g_specs_err_count),

Line 3890: -- gmd_specifications_b owner_organization_id

3886: -- x_exception_count OUT NUMBER - Exception Count
3887: --
3888: -- The following columns will be migrated by the Common migration script.
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

Line 3986: Cursor for gmd_specifications_b.

3982: l_material_detail_id NUMBER;
3983:
3984:
3985: /*=======================================
3986: Cursor for gmd_specifications_b.
3987: Add organization id null check to
3988: select rows that have not migrated.
3989: Org id not null means either it was
3990: migrated or row was created post-migration.

Line 3997: FROM gmd_specifications_b

3993: -- Bug# 5097457
3994: -- Removed owner_organization_id IS NULL from the where clause and added owner_orgn_code IS NOT NULL.
3995: CURSOR get_specs IS
3996: SELECT item_id, owner_organization_id, owner_orgn_code, spec_id
3997: FROM gmd_specifications_b
3998: WHERE migrated_ind IS NULL
3999: AND owner_orgn_code IS NOT NULL;
4000:
4001: l_spec_inv_item_id gmd_specifications_b.inventory_item_id%TYPE;

Line 4001: l_spec_inv_item_id gmd_specifications_b.inventory_item_id%TYPE;

3997: FROM gmd_specifications_b
3998: WHERE migrated_ind IS NULL
3999: AND owner_orgn_code IS NOT NULL;
4000:
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.

Line 4002: l_owner_org_id gmd_specifications_b.owner_organization_id%TYPE;

3998: WHERE migrated_ind IS NULL
3999: AND owner_orgn_code IS NOT NULL;
4000:
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: =======================================*/

Line 4020: l_item_id gmd_specifications_b.item_id%TYPE;

4016: /*=======================================
4017: Cursor to get Item_id for a Lot.
4018: =======================================*/
4019:
4020: l_item_id gmd_specifications_b.item_id%TYPE;
4021:
4022: -- If item_id for lot is not available from lot, get it from the spec.
4023:
4024: CURSOR get_spec_item_id (p_spec_id gmd_specifications.spec_id%TYPE) IS

Line 4026: FROM gmd_specifications_b

4022: -- If item_id for lot is not available from lot, get it from the spec.
4023:
4024: CURSOR get_spec_item_id (p_spec_id gmd_specifications.spec_id%TYPE) IS
4025: SELECT item_id
4026: FROM gmd_specifications_b
4027: WHERE spec_id = p_spec_id;
4028:
4029: /*=======================================
4030: Cursor to get Item lot control info.

Line 4357: Log Start of gmd_specifications_b.

4353:
4354: x_exception_count := 0;
4355:
4356: /*==============================================
4357: Log Start of gmd_specifications_b.
4358: ==============================================*/
4359:
4360: GMA_COMMON_LOGGING.gma_migration_central_log (
4361: p_run_id => p_migration_run_id,

Line 4371: Migrate gmd_specifications_b.

4367: p_context => 'Quality Specifications',
4368: p_app_short_name => 'GMA');
4369:
4370: /*====================================
4371: Migrate gmd_specifications_b.
4372: ====================================*/
4373:
4374: GMD_QC_MIG12.g_progress_ind := 1;
4375: GMD_QC_MIG12.g_specs_pro_count := 0;

Line 4412: Update gmd_specifications_b.

4408: l_spec_inv_item_id := NULL;
4409: END IF;
4410:
4411: /*==================================
4412: Update gmd_specifications_b.
4413: ==================================*/
4414:
4415: -- Bug# 5097457
4416: -- Added grade_code in the update statement

Line 4417: UPDATE gmd_specifications_b

4413: ==================================*/
4414:
4415: -- Bug# 5097457
4416: -- Added grade_code in the update statement
4417: UPDATE gmd_specifications_b
4418: SET inventory_item_id = l_spec_inv_item_id,
4419: owner_organization_id = l_owner_org_id,
4420: grade_code = grade,
4421: migrated_ind = 1

Line 4438: p_context => 'Quality Specifications - gmd_specifications_b',

4434: p_run_id => p_migration_run_id,
4435: p_log_level => FND_LOG.LEVEL_ERROR,
4436: p_message_token => 'GMD_MIG_NO_ORG',
4437: p_table_name => NULL,
4438: p_context => 'Quality Specifications - gmd_specifications_b',
4439: p_token1 => 'ORG',
4440: p_token2 => 'ONAME',
4441: p_token3 => 'ROWK',
4442: p_token4 => 'ROWV',

Line 4456: p_context => 'Quality Specifications - gmd_specifications_b',

4452: GMA_COMMON_LOGGING.gma_migration_central_log (
4453: p_run_id => p_migration_run_id,
4454: p_log_level => FND_LOG.LEVEL_ERROR,
4455: p_message_token => 'GMD_MIG_ODM_ITEM',
4456: p_context => 'Quality Specifications - gmd_specifications_b',
4457: p_token1 => 'ORG',
4458: p_token2 => 'ITEMID',
4459: p_token3 => 'ROWK',
4460: p_token4 => 'ROWV',

Line 4475: p_context => 'Quality Specifications - gmd_specifications_b',

4471: GMA_COMMON_LOGGING.gma_migration_central_log (
4472: p_run_id => p_migration_run_id,
4473: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
4474: p_message_token => 'GMA_MIGRATION_DB_ERROR',
4475: p_context => 'Quality Specifications - gmd_specifications_b',
4476: p_db_error => SQLERRM,
4477: p_app_short_name => 'GMA');
4478: x_exception_count := x_exception_count + 1;
4479:

Line 4485: Log end of gmd_specifications_b migration.

4481:
4482: END LOOP;
4483:
4484: /*==============================================
4485: Log end of gmd_specifications_b migration.
4486: ==============================================*/
4487:
4488: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
4489: