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_STABILITY_STUDIES_B

Line 7172: -- gmd_stability_studies_b organization_id

7168: --
7169: -- The following columns will be migrated by the Common migration script.
7170: --
7171: -- gmd_ss_storage_package quantity_uom
7172: -- gmd_stability_studies_b organization_id
7173: -- gmd_stability_studies_b lab_organization_id
7174: -- gmd_ss_material_sources source_organization_id
7175: -- gmd_ss_material_sources sample_quantity_uom
7176: -- gmd_ss_variants sample_quantity_uom

Line 7173: -- gmd_stability_studies_b lab_organization_id

7169: -- The following columns will be migrated by the Common migration script.
7170: --
7171: -- gmd_ss_storage_package quantity_uom
7172: -- gmd_stability_studies_b organization_id
7173: -- gmd_stability_studies_b lab_organization_id
7174: -- gmd_ss_material_sources source_organization_id
7175: -- gmd_ss_material_sources sample_quantity_uom
7176: -- gmd_ss_variants sample_quantity_uom
7177: --=========================================================================== */

Line 7218: Cursor for gmd_stability_studies_b.

7214: NULL_DEFAULT_LAB EXCEPTION;
7215:
7216:
7217: /*=====================================
7218: Cursor for gmd_stability_studies_b.
7219: =====================================*/
7220:
7221: -- Bug# 5109234
7222: -- Removed organization_id IS NULL from the where clause and added orgn_code IS NOT NULL.

Line 7226: FROM gmd_stability_studies_b

7222: -- Removed organization_id IS NULL from the where clause and added orgn_code IS NOT NULL.
7223: CURSOR get_stab IS
7224: SELECT orgn_code, organization_id, item_id, qc_lab_orgn_code,
7225: lab_organization_id, ss_id
7226: FROM gmd_stability_studies_b
7227: WHERE migrated_ind IS NULL
7228: AND orgn_code IS NOT NULL;
7229:
7230: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 7234: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;

7230: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7231: l_splan_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7232: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7233: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7234: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
7235: l_subinv mtl_item_locations.subinventory_code%TYPE;
7236: lsub_organization_id mtl_item_locations.organization_id%TYPE;
7237: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;

Line 7237: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;

7233: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7234: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
7235: l_subinv mtl_item_locations.subinventory_code%TYPE;
7236: lsub_organization_id mtl_item_locations.organization_id%TYPE;
7237: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
7239:
7240:
7241: /*=====================================

Line 7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;

7234: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
7235: l_subinv mtl_item_locations.subinventory_code%TYPE;
7236: lsub_organization_id mtl_item_locations.organization_id%TYPE;
7237: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
7239:
7240:
7241: /*=====================================
7242: Cursor for gmd_storage_plan_details.

Line 7269: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv

7265: =====================================*/
7266:
7267: CURSOR get_stab_study_org(p_package_id gmd_ss_storage_package.package_id%TYPE) IS
7268: SELECT distinct gssb.orgn_code, gsv.package_id
7269: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv
7270: WHERE gssb.ss_id = gsv.ss_id
7271: AND gsv.package_id = p_package_id;
7272:
7273: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;

Line 7273: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;

7269: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv
7270: WHERE gssb.ss_id = gsv.ss_id
7271: AND gsv.package_id = p_package_id;
7272:
7273: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7274: l_gsv_package_id gmd_ss_variants.package_id%TYPE;
7275:
7276: /*=====================================
7277: Cursor for gmd_ss_storage_package.

Line 7331: CURSOR get_stab_study (p_ss_id gmd_stability_studies_b.ss_id%TYPE) IS

7327: /*===============================================
7328: Cursor to get stability study org and item.
7329: ===============================================*/
7330:
7331: CURSOR get_stab_study (p_ss_id gmd_stability_studies_b.ss_id%TYPE) IS
7332: SELECT orgn_code, item_id
7333: FROM gmd_stability_studies_b
7334: WHERE ss_id = p_ss_id;
7335:

Line 7333: FROM gmd_stability_studies_b

7329: ===============================================*/
7330:
7331: CURSOR get_stab_study (p_ss_id gmd_stability_studies_b.ss_id%TYPE) IS
7332: SELECT orgn_code, item_id
7333: FROM gmd_stability_studies_b
7334: WHERE ss_id = p_ss_id;
7335:
7336: l_ss_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7337: l_ss_item_id gmd_stability_studies_b.item_id%TYPE;

Line 7336: l_ss_orgn_code gmd_stability_studies_b.orgn_code%TYPE;

7332: SELECT orgn_code, item_id
7333: FROM gmd_stability_studies_b
7334: WHERE ss_id = p_ss_id;
7335:
7336: l_ss_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7337: l_ss_item_id gmd_stability_studies_b.item_id%TYPE;
7338:
7339: l_lot_number mtl_lot_numbers.lot_number%TYPE;
7340: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;

Line 7337: l_ss_item_id gmd_stability_studies_b.item_id%TYPE;

7333: FROM gmd_stability_studies_b
7334: WHERE ss_id = p_ss_id;
7335:
7336: l_ss_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7337: l_ss_item_id gmd_stability_studies_b.item_id%TYPE;
7338:
7339: l_lot_number mtl_lot_numbers.lot_number%TYPE;
7340: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
7341: l_failure_count NUMBER;

Line 7643: p_table_name => 'GMD_STABILITY_STUDIES_B',

7639: GMA_COMMON_LOGGING.gma_migration_central_log (
7640: p_run_id => p_migration_run_id,
7641: p_log_level => FND_LOG.LEVEL_EVENT,
7642: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7643: p_table_name => 'GMD_STABILITY_STUDIES_B',
7644: p_token1 => 'TABLE_NAME',
7645: p_param1 => 'GMD_STABILITY_STUDIES_B',
7646: p_context => 'Quality Stability Studies',
7647: p_app_short_name => 'GMA');

Line 7645: p_param1 => 'GMD_STABILITY_STUDIES_B',

7641: p_log_level => FND_LOG.LEVEL_EVENT,
7642: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7643: p_table_name => 'GMD_STABILITY_STUDIES_B',
7644: p_token1 => 'TABLE_NAME',
7645: p_param1 => 'GMD_STABILITY_STUDIES_B',
7646: p_context => 'Quality Stability Studies',
7647: p_app_short_name => 'GMA');
7648:
7649: /*=====================================

Line 7650: Migrate gmd_stability_studies_b.

7646: p_context => 'Quality Stability Studies',
7647: p_app_short_name => 'GMA');
7648:
7649: /*=====================================
7650: Migrate gmd_stability_studies_b.
7651: =====================================*/
7652:
7653: GMD_QC_MIG12.g_stab_pro_count := 0;
7654: GMD_QC_MIG12.g_stab_upd_count := 0;

Line 7697: UPDATE gmd_stability_studies_b

7693: ELSE
7694: l_inventory_item_id := NULL;
7695: END IF;
7696:
7697: UPDATE gmd_stability_studies_b
7698: SET inventory_item_id = l_inventory_item_id,
7699: organization_id = l_stab_org_id,
7700: migrated_ind = 1
7701: WHERE ss_id = l_stab_rec.ss_id;

Line 7715: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

7711: GMA_COMMON_LOGGING.gma_migration_central_log (
7712: p_run_id => p_migration_run_id,
7713: p_log_level => FND_LOG.LEVEL_ERROR,
7714: p_message_token => 'GMD_MIG_NO_ORG',
7715: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7716: p_token1 => 'ORG',
7717: p_token2 => 'ONAME',
7718: p_token3 => 'ROWK',
7719: p_token4 => 'ROWV',

Line 7733: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

7729: GMA_COMMON_LOGGING.gma_migration_central_log (
7730: p_run_id => p_migration_run_id,
7731: p_log_level => FND_LOG.LEVEL_ERROR,
7732: p_message_token => 'GMD_MIG_NO_ORG',
7733: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7734: p_token1 => 'ORG',
7735: p_token2 => 'ONAME',
7736: p_token3 => 'ROWK',
7737: p_token4 => 'ROWV',

Line 7751: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

7747: GMA_COMMON_LOGGING.gma_migration_central_log (
7748: p_run_id => p_migration_run_id,
7749: p_log_level => FND_LOG.LEVEL_ERROR,
7750: p_message_token => 'GMD_MIG_ODM_ITEM',
7751: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7752: p_token1 => 'ORG',
7753: p_token2 => 'ITEMID',
7754: p_token3 => 'ROWK',
7755: p_token4 => 'ROWV',

Line 7770: p_context => 'Quality Stability Studies - gmd_stability_studies_b',

7766: GMA_COMMON_LOGGING.gma_migration_central_log (
7767: p_run_id => p_migration_run_id,
7768: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7769: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7770: p_context => 'Quality Stability Studies - gmd_stability_studies_b',
7771: p_db_error => SQLERRM,
7772: p_app_short_name => 'GMA');
7773: x_exception_count := x_exception_count + 1;
7774: ROLLBACK;

Line 7783: Log End of gmd_stability_studies_b.

7779:
7780:
7781:
7782: /*==============================================
7783: Log End of gmd_stability_studies_b.
7784: ==============================================*/
7785:
7786: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7787:

Line 8510: AND ss_id IN (select ss_id from gmd_stability_studies_b where orgn_code = l_stab_orgn_code);

8506:
8507: UPDATE gmd_ss_variants
8508: SET package_id = l_package_id
8509: WHERE package_id = l_store_pack.package_id
8510: AND ss_id IN (select ss_id from gmd_stability_studies_b where orgn_code = l_stab_orgn_code);
8511:
8512: -- AND ss_id = (select ss_id from gmd_stability_studies_b where organization_id = l_ss_org_id);
8513:
8514:

Line 8512: -- AND ss_id = (select ss_id from gmd_stability_studies_b where organization_id = l_ss_org_id);

8508: SET package_id = l_package_id
8509: WHERE package_id = l_store_pack.package_id
8510: AND ss_id IN (select ss_id from gmd_stability_studies_b where orgn_code = l_stab_orgn_code);
8511:
8512: -- AND ss_id = (select ss_id from gmd_stability_studies_b where organization_id = l_ss_org_id);
8513:
8514:
8515: FETCH get_stab_study_org INTO l_stab_orgn_code, l_gsv_package_id;
8516: