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_QUALITY_CONFIG

Line 76: p_param1 => 'gmd_quality_config',

72: p_token2 => 'PRO',
73: p_token3 => 'UPD',
74: p_token4 => 'INS',
75: p_token5 => 'ERR',
76: p_param1 => 'gmd_quality_config',
77: p_param2 => to_char(GMD_QC_MIG12.g_quality_config_pro_count),
78: p_param3 => to_char(GMD_QC_MIG12.g_quality_config_upd_count),
79: p_param4 => to_char(GMD_QC_MIG12.g_quality_config_ins_count),
80: p_param5 => to_char(GMD_QC_MIG12.g_quality_config_err_count),

Line 892: FROM gmd_quality_config

888: FROM ic_whse_mst icw
889: WHERE ( icw.subinventory_ind_flag <> 'Y'
890: OR icw.subinventory_ind_flag IS NULL)
891: AND NOT EXISTS (SELECT organization_id
892: FROM gmd_quality_config
893: WHERE organization_id = icw.organization_id)
894: AND icw.organization_id IS NOT NULL;
895:
896: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS

Line 896: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS

892: FROM gmd_quality_config
893: WHERE organization_id = icw.organization_id)
894: AND icw.organization_id IS NOT NULL;
895:
896: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
897: SELECT qc.*
898: FROM gmd_quality_config qc, sy_orgn_mst m
899: WHERE m.orgn_code = p_orgn_code
900: AND m.organization_id = qc.organization_id;

Line 898: FROM gmd_quality_config qc, sy_orgn_mst m

894: AND icw.organization_id IS NOT NULL;
895:
896: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
897: SELECT qc.*
898: FROM gmd_quality_config qc, sy_orgn_mst m
899: WHERE m.orgn_code = p_orgn_code
900: AND m.organization_id = qc.organization_id;
901:
902: l_config_rec cur_orgn_config%ROWTYPE;

Line 909: INSERT INTO gmd_quality_config(

905:
906: OPEN cur_orgn_config (get_whse_info.orgn_code);
907: FETCH cur_orgn_config INTO l_config_rec;
908: IF cur_orgn_config%FOUND THEN
909: INSERT INTO gmd_quality_config(
910: ORGN_CODE,
911: CONTROL_BATCH_STEP_IND,
912: CONTROL_LOT_ATTRIB_IND,
913: OUT_OF_SPEC_LOT_STATUS,

Line 1027: -- gmd_quality_config - organization_id

1023: --
1024: -- The following columns will be migrated by the Common migration script.
1025: --
1026: -- gmd_test_methods_b - test_qty_uom
1027: -- gmd_quality_config - organization_id
1028: -- gmd_sampling_plans - sample_qty_uom
1029: -- gmd_uom_conversions - from_qty_uom
1030: -- gmd_uom_conversions - from_qty_uom_base
1031: -- gmd_uom_conversions - to_qty_uom

Line 1094: FROM gmd_quality_config

1090: =========================*/
1091:
1092: CURSOR get_quality_config IS
1093: SELECT *
1094: FROM gmd_quality_config
1095: WHERE orgn_code IS NOT NULL
1096: AND migrated_ind IS NULL;
1097:
1098:

Line 1105: FROM gmd_quality_config

1101: ===========================*/
1102:
1103: CURSOR get_null_quality_config IS
1104: SELECT *
1105: FROM gmd_quality_config
1106: WHERE orgn_code IS NULL
1107: AND migrated_ind IS NULL
1108: AND organization_id IS NULL;
1109:

Line 1110: l_config_rec gmd_quality_config%ROWTYPE;

1106: WHERE orgn_code IS NULL
1107: AND migrated_ind IS NULL
1108: AND organization_id IS NULL;
1109:
1110: l_config_rec gmd_quality_config%ROWTYPE;
1111:
1112:
1113: /*================================
1114: Quality Config Migrated Check

Line 1119: FROM gmd_quality_config

1115: ================================*/
1116:
1117: CURSOR check_config_mig IS
1118: SELECT count(1)
1119: FROM gmd_quality_config
1120: WHERE (orgn_code IS NOT NULL AND migrated_ind IS NULL);
1121:
1122: l_config_mig_count NUMBER;
1123:

Line 1149: (SELECT organization_id FROM gmd_quality_config WHERE organization_id = m.organization_id)

1145: CURSOR get_process_org IS
1146: SELECT m.organization_id
1147: FROM sy_orgn_mst_b m
1148: WHERE NOT EXISTS
1149: (SELECT organization_id FROM gmd_quality_config WHERE organization_id = m.organization_id)
1150: AND m.organization_id IS NOT NULL;
1151:
1152:
1153: v_org sy_orgn_mst.organization_id%TYPE;

Line 1192: l_lab_ind gmd_quality_config.quality_lab_ind%TYPE;

1188: FROM sy_orgn_mst
1189: WHERE orgn_code = p_orgn_code;
1190:
1191: d_lab_ind sy_orgn_mst.plant_ind%TYPE;
1192: l_lab_ind gmd_quality_config.quality_lab_ind%TYPE;
1193: l_organization_id sy_orgn_mst.organization_id%TYPE;
1194: l_test_org sy_orgn_mst.organization_id%TYPE;
1195:
1196:

Line 1227: FROM gmd_quality_config

1223: =======================================*/
1224:
1225: CURSOR get_config IS
1226: SELECT *
1227: FROM gmd_quality_config
1228: WHERE migrated_ind = 1;
1229:
1230:
1231: /*=======================================

Line 1247: CURSOR get_parent_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS

1243: /*=======================================
1244: Cursor to get config record.
1245: =======================================*/
1246:
1247: CURSOR get_parent_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
1248: SELECT sample_assignment_type, sample_last_assigned
1249: FROM gmd_quality_config
1250: WHERE orgn_code = p_orgn_code;
1251:

Line 1249: FROM gmd_quality_config

1245: =======================================*/
1246:
1247: CURSOR get_parent_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
1248: SELECT sample_assignment_type, sample_last_assigned
1249: FROM gmd_quality_config
1250: WHERE orgn_code = p_orgn_code;
1251:
1252: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1253: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;

Line 1252: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;

1248: SELECT sample_assignment_type, sample_last_assigned
1249: FROM gmd_quality_config
1250: WHERE orgn_code = p_orgn_code;
1251:
1252: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1253: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;
1254:
1255: /*=======================================
1256: Cursor to get gmd_sampling_plans_b

Line 1253: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;

1249: FROM gmd_quality_config
1250: WHERE orgn_code = p_orgn_code;
1251:
1252: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1253: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;
1254:
1255: /*=======================================
1256: Cursor to get gmd_sampling_plans_b
1257: =======================================*/

Line 1268: Cursor to check if gmd_quality_config

1264: l_sample_plan get_sampling_plan%ROWTYPE;
1265: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;
1266:
1267: /*=======================================
1268: Cursor to check if gmd_quality_config
1269: record exists.
1270: =======================================*/
1271:
1272: CURSOR check_for_config(p_org_id NUMBER) IS

Line 1274: FROM gmd_quality_config

1270: =======================================*/
1271:
1272: CURSOR check_for_config(p_org_id NUMBER) IS
1273: SELECT organization_id
1274: FROM gmd_quality_config
1275: WHERE organization_id = p_org_id;
1276:
1277: l_config_org NUMBER;
1278:

Line 1336: p_table_name => 'GMD_QUALITY_CONFIG',

1332: GMA_COMMON_LOGGING.gma_migration_central_log (
1333: p_run_id => p_migration_run_id,
1334: p_log_level => FND_LOG.LEVEL_EVENT,
1335: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1336: p_table_name => 'GMD_QUALITY_CONFIG',
1337: p_token1 => 'TABLE_NAME',
1338: p_param1 => 'GMD_TEST_METHODS_B',
1339: p_context => 'Quality Setup',
1340: p_app_short_name => 'GMA');

Line 1447: Migrate gmd_quality_config.

1443: LOG_SETUP_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
1444:
1445:
1446: /*=========================================
1447: Migrate gmd_quality_config.
1448: First get profile values.
1449: =========================================*/
1450:
1451: P_exact_match := GMD_QC_MIG12.GET_PROFILE_VALUE('QC$EXACTSPECMATCH');

Line 1541: p_table_name => 'GMD_QUALITY_CONFIG',

1537: GMA_COMMON_LOGGING.gma_migration_central_log (
1538: p_run_id => p_migration_run_id,
1539: p_log_level => FND_LOG.LEVEL_EVENT,
1540: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1541: p_table_name => 'GMD_QUALITY_CONFIG',
1542: p_token1 => 'TABLE_NAME',
1543: p_param1 => 'GMD_QUALITY_CONFIG',
1544: p_context => 'Quality Setup',
1545: p_app_short_name => 'GMA');

Line 1543: p_param1 => 'GMD_QUALITY_CONFIG',

1539: p_log_level => FND_LOG.LEVEL_EVENT,
1540: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1541: p_table_name => 'GMD_QUALITY_CONFIG',
1542: p_token1 => 'TABLE_NAME',
1543: p_param1 => 'GMD_QUALITY_CONFIG',
1544: p_context => 'Quality Setup',
1545: p_app_short_name => 'GMA');
1546:
1547: /*==============================================

Line 1548: Loop through gmd_quality_config. Handle

1544: p_context => 'Quality Setup',
1545: p_app_short_name => 'GMA');
1546:
1547: /*==============================================
1548: Loop through gmd_quality_config. Handle
1549: records with org differently than the record
1550: where org is null. First pass gets
1551: non_null records.
1552: ==============================================*/

Line 1655: UPDATE gmd_quality_config

1651: /*=====================================
1652: Update the Row.
1653: =====================================*/
1654:
1655: UPDATE gmd_quality_config
1656: SET organization_id = l_organization_id,
1657: quality_lab_ind = l_lab_ind,
1658: transaction_reason_id = l_reason_id,
1659: in_spec_lot_status_id = l_in_spec_status_id,

Line 1781: Loop through gmd_quality_config. Handle

1777: END LOOP;
1778:
1779:
1780: /*=========================================
1781: Loop through gmd_quality_config. Handle
1782: record with null org. It will be
1783: unchanged but marked as migrated.
1784: =========================================*/
1785:

Line 1797: if existing gmd_quality_config row

1793: RAISE NO_NULL_RECORD;
1794: ELSE
1795: /*====================================
1796: Do not process the null record
1797: if existing gmd_quality_config row
1798: were not successfully migrated.
1799: ====================================*/
1800: GMD_QC_MIG12.g_quality_config_pro_count := GMD_QC_MIG12.g_quality_config_pro_count + 1;
1801: END IF;

Line 1807: already have a row in gmd_quality_config.

1803: CLOSE get_null_quality_config;
1804:
1805: /*===========================================
1806: Get all process orgs that do not
1807: already have a row in gmd_quality_config.
1808: ===========================================*/
1809:
1810: l_org_count := 0;
1811:

Line 1960: INSERT INTO gmd_quality_config(

1956: l_stbl_assignment_type := 2;
1957: l_stbl_last_assigned := 1;
1958: END IF;
1959:
1960: INSERT INTO gmd_quality_config(
1961: ORGN_CODE,
1962: CONTROL_BATCH_STEP_IND,
1963: CONTROL_LOT_ATTRIB_IND,
1964: OUT_OF_SPEC_LOT_STATUS,

Line 2107: UPDATE gmd_quality_config

2103: CLOSE check_config_mig;
2104:
2105: IF (l_config_mig_count = 0) THEN
2106:
2107: UPDATE gmd_quality_config
2108: SET migrated_ind = 1
2109: WHERE orgn_code IS NULL and migrated_ind IS NULL;
2110:
2111: IF (p_commit = FND_API.G_TRUE) THEN

Line 2144: UPDATE gmd_quality_config

2140: IF (get_parent_config%FOUND) THEN
2141: /*=================================
2142: Overlay the sample values.
2143: =================================*/
2144: UPDATE gmd_quality_config
2145: SET sample_assignment_type = l_p_assign_type,
2146: sample_last_assigned = l_p_last_assign
2147: WHERE organization_id = l_config.organization_id;
2148:

Line 2250: Log end of gmd_quality_config migration.

2246: -- Creates the Quality config rows for warehouse (ic_whse_mst) rows
2247: create_config_rows_for_whse(p_migration_run_id, p_commit);
2248:
2249: /*==============================================
2250: Log end of gmd_quality_config migration.
2251: ==============================================*/
2252: LOG_SETUP_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
2253:
2254: /*==============================================