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

Line 221: p_param1 => 'gmd_specifications_b',

217: p_token2 => 'PRO',
218: p_token3 => 'UPD',
219: p_token4 => 'INS',
220: p_token5 => 'ERR',
221: p_param1 => 'gmd_specifications_b',
222: p_param2 => to_char(GMD_QC_MIG12.g_specs_pro_count),
223: p_param3 => to_char(GMD_QC_MIG12.g_specs_upd_count),
224: p_param4 => 0,
225: p_param5 => to_char(GMD_QC_MIG12.g_specs_err_count),

Line 3621: -- gmd_specifications_b owner_organization_id

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

Line 3717: Cursor for gmd_specifications_b.

3713: l_material_detail_id NUMBER;
3714:
3715:
3716: /*=======================================
3717: Cursor for gmd_specifications_b.
3718: Add organization id null check to
3719: select rows that have not migrated.
3720: Org id not null means either it was
3721: migrated or row was created post-migration.

Line 3728: FROM gmd_specifications_b

3724: -- Bug# 5097457
3725: -- Removed owner_organization_id IS NULL from the where clause and added owner_orgn_code IS NOT NULL.
3726: CURSOR get_specs IS
3727: SELECT item_id, owner_organization_id, owner_orgn_code, spec_id
3728: FROM gmd_specifications_b
3729: WHERE migrated_ind IS NULL
3730: AND owner_orgn_code IS NOT NULL;
3731:
3732: l_spec_inv_item_id gmd_specifications_b.inventory_item_id%TYPE;

Line 3732: l_spec_inv_item_id gmd_specifications_b.inventory_item_id%TYPE;

3728: FROM gmd_specifications_b
3729: WHERE migrated_ind IS NULL
3730: AND owner_orgn_code IS NOT NULL;
3731:
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.

Line 3733: l_owner_org_id gmd_specifications_b.owner_organization_id%TYPE;

3729: WHERE migrated_ind IS NULL
3730: AND owner_orgn_code IS NOT NULL;
3731:
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: =======================================*/

Line 3751: l_item_id gmd_specifications_b.item_id%TYPE;

3747: /*=======================================
3748: Cursor to get Item_id for a Lot.
3749: =======================================*/
3750:
3751: l_item_id gmd_specifications_b.item_id%TYPE;
3752:
3753: -- If item_id for lot is not available from lot, get it from the spec.
3754:
3755: CURSOR get_spec_item_id (p_spec_id gmd_specifications.spec_id%TYPE) IS

Line 3755: CURSOR get_spec_item_id (p_spec_id gmd_specifications.spec_id%TYPE) IS

3751: l_item_id gmd_specifications_b.item_id%TYPE;
3752:
3753: -- If item_id for lot is not available from lot, get it from the spec.
3754:
3755: CURSOR get_spec_item_id (p_spec_id gmd_specifications.spec_id%TYPE) IS
3756: SELECT item_id
3757: FROM gmd_specifications_b
3758: WHERE spec_id = p_spec_id;
3759:

Line 3757: FROM gmd_specifications_b

3753: -- If item_id for lot is not available from lot, get it from the spec.
3754:
3755: CURSOR get_spec_item_id (p_spec_id gmd_specifications.spec_id%TYPE) IS
3756: SELECT item_id
3757: FROM gmd_specifications_b
3758: WHERE spec_id = p_spec_id;
3759:
3760: /*=======================================
3761: Cursor to get Item lot control info.

Line 4088: Log Start of gmd_specifications_b.

4084:
4085: x_exception_count := 0;
4086:
4087: /*==============================================
4088: Log Start of gmd_specifications_b.
4089: ==============================================*/
4090:
4091: GMA_COMMON_LOGGING.gma_migration_central_log (
4092: p_run_id => p_migration_run_id,

Line 4095: p_table_name => 'GMD_SPECIFICATIONS',

4091: GMA_COMMON_LOGGING.gma_migration_central_log (
4092: p_run_id => p_migration_run_id,
4093: p_log_level => FND_LOG.LEVEL_EVENT,
4094: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4095: p_table_name => 'GMD_SPECIFICATIONS',
4096: p_token1 => 'TABLE_NAME',
4097: p_param1 => 'GMD_SPECIFICATIONS',
4098: p_context => 'Quality Specifications',
4099: p_app_short_name => 'GMA');

Line 4097: p_param1 => 'GMD_SPECIFICATIONS',

4093: p_log_level => FND_LOG.LEVEL_EVENT,
4094: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
4095: p_table_name => 'GMD_SPECIFICATIONS',
4096: p_token1 => 'TABLE_NAME',
4097: p_param1 => 'GMD_SPECIFICATIONS',
4098: p_context => 'Quality Specifications',
4099: p_app_short_name => 'GMA');
4100:
4101: /*====================================

Line 4102: Migrate gmd_specifications_b.

4098: p_context => 'Quality Specifications',
4099: p_app_short_name => 'GMA');
4100:
4101: /*====================================
4102: Migrate gmd_specifications_b.
4103: ====================================*/
4104:
4105: GMD_QC_MIG12.g_progress_ind := 1;
4106: GMD_QC_MIG12.g_specs_pro_count := 0;

Line 4143: Update gmd_specifications_b.

4139: l_spec_inv_item_id := NULL;
4140: END IF;
4141:
4142: /*==================================
4143: Update gmd_specifications_b.
4144: ==================================*/
4145:
4146: -- Bug# 5097457
4147: -- Added grade_code in the update statement

Line 4148: UPDATE gmd_specifications_b

4144: ==================================*/
4145:
4146: -- Bug# 5097457
4147: -- Added grade_code in the update statement
4148: UPDATE gmd_specifications_b
4149: SET inventory_item_id = l_spec_inv_item_id,
4150: owner_organization_id = l_owner_org_id,
4151: grade_code = grade,
4152: migrated_ind = 1

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

4165: p_run_id => p_migration_run_id,
4166: p_log_level => FND_LOG.LEVEL_ERROR,
4167: p_message_token => 'GMD_MIG_NO_ORG',
4168: p_table_name => NULL,
4169: p_context => 'Quality Specifications - gmd_specifications_b',
4170: p_token1 => 'ORG',
4171: p_token2 => 'ONAME',
4172: p_token3 => 'ROWK',
4173: p_token4 => 'ROWV',

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

4183: GMA_COMMON_LOGGING.gma_migration_central_log (
4184: p_run_id => p_migration_run_id,
4185: p_log_level => FND_LOG.LEVEL_ERROR,
4186: p_message_token => 'GMD_MIG_ODM_ITEM',
4187: p_context => 'Quality Specifications - gmd_specifications_b',
4188: p_token1 => 'ORG',
4189: p_token2 => 'ITEMID',
4190: p_token3 => 'ROWK',
4191: p_token4 => 'ROWV',

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

4202: GMA_COMMON_LOGGING.gma_migration_central_log (
4203: p_run_id => p_migration_run_id,
4204: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
4205: p_message_token => 'GMA_MIGRATION_DB_ERROR',
4206: p_context => 'Quality Specifications - gmd_specifications_b',
4207: p_db_error => SQLERRM,
4208: p_app_short_name => 'GMA');
4209: x_exception_count := x_exception_count + 1;
4210:

Line 4216: Log end of gmd_specifications_b migration.

4212:
4213: END LOOP;
4214:
4215: /*==============================================
4216: Log end of gmd_specifications_b migration.
4217: ==============================================*/
4218:
4219: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
4220: