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 84: p_param1 => 'gmd_quality_config',

80: p_token2 => 'PRO',
81: p_token3 => 'UPD',
82: p_token4 => 'INS',
83: p_token5 => 'ERR',
84: p_param1 => 'gmd_quality_config',
85: p_param2 => to_char(GMD_QC_MIG12.g_quality_config_pro_count),
86: p_param3 => to_char(GMD_QC_MIG12.g_quality_config_upd_count),
87: p_param4 => to_char(GMD_QC_MIG12.g_quality_config_ins_count),
88: p_param5 => to_char(GMD_QC_MIG12.g_quality_config_err_count),

Line 900: FROM gmd_quality_config

896: FROM ic_whse_mst icw
897: WHERE ( icw.subinventory_ind_flag <> 'Y'
898: OR icw.subinventory_ind_flag IS NULL)
899: AND NOT EXISTS (SELECT organization_id
900: FROM gmd_quality_config
901: WHERE organization_id = icw.organization_id)
902: AND icw.organization_id IS NOT NULL;
903:
904: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS

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

900: FROM gmd_quality_config
901: WHERE organization_id = icw.organization_id)
902: AND icw.organization_id IS NOT NULL;
903:
904: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
905: SELECT qc.*
906: FROM gmd_quality_config qc, sy_orgn_mst m
907: WHERE m.orgn_code = p_orgn_code
908: AND m.organization_id = qc.organization_id;

Line 906: FROM gmd_quality_config qc, sy_orgn_mst m

902: AND icw.organization_id IS NOT NULL;
903:
904: CURSOR cur_orgn_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
905: SELECT qc.*
906: FROM gmd_quality_config qc, sy_orgn_mst m
907: WHERE m.orgn_code = p_orgn_code
908: AND m.organization_id = qc.organization_id;
909:
910: l_config_rec cur_orgn_config%ROWTYPE;

Line 917: INSERT INTO gmd_quality_config(

913:
914: OPEN cur_orgn_config (get_whse_info.orgn_code);
915: FETCH cur_orgn_config INTO l_config_rec;
916: IF cur_orgn_config%FOUND THEN
917: INSERT INTO gmd_quality_config(
918: ORGN_CODE,
919: CONTROL_BATCH_STEP_IND,
920: CONTROL_LOT_ATTRIB_IND,
921: OUT_OF_SPEC_LOT_STATUS,

Line 1035: -- gmd_quality_config - organization_id

1031: --
1032: -- The following columns will be migrated by the Common migration script.
1033: --
1034: -- gmd_test_methods_b - test_qty_uom
1035: -- gmd_quality_config - organization_id
1036: -- gmd_sampling_plans - sample_qty_uom
1037: -- gmd_uom_conversions - from_qty_uom
1038: -- gmd_uom_conversions - from_qty_uom_base
1039: -- gmd_uom_conversions - to_qty_uom

Line 1102: FROM gmd_quality_config

1098: =========================*/
1099:
1100: CURSOR get_quality_config IS
1101: SELECT *
1102: FROM gmd_quality_config
1103: WHERE orgn_code IS NOT NULL
1104: AND migrated_ind IS NULL;
1105:
1106:

Line 1113: FROM gmd_quality_config

1109: ===========================*/
1110:
1111: CURSOR get_null_quality_config IS
1112: SELECT *
1113: FROM gmd_quality_config
1114: WHERE orgn_code IS NULL
1115: AND migrated_ind IS NULL
1116: AND organization_id IS NULL;
1117:

Line 1118: l_config_rec gmd_quality_config%ROWTYPE;

1114: WHERE orgn_code IS NULL
1115: AND migrated_ind IS NULL
1116: AND organization_id IS NULL;
1117:
1118: l_config_rec gmd_quality_config%ROWTYPE;
1119:
1120:
1121: /*================================
1122: Quality Config Migrated Check

Line 1127: FROM gmd_quality_config

1123: ================================*/
1124:
1125: CURSOR check_config_mig IS
1126: SELECT count(1)
1127: FROM gmd_quality_config
1128: WHERE (orgn_code IS NOT NULL AND migrated_ind IS NULL);
1129:
1130: l_config_mig_count NUMBER;
1131:

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

1153: CURSOR get_process_org IS
1154: SELECT m.organization_id
1155: FROM sy_orgn_mst_b m
1156: WHERE NOT EXISTS
1157: (SELECT organization_id FROM gmd_quality_config WHERE organization_id = m.organization_id)
1158: AND m.organization_id IS NOT NULL;
1159:
1160:
1161: v_org sy_orgn_mst.organization_id%TYPE;

Line 1200: l_lab_ind gmd_quality_config.quality_lab_ind%TYPE;

1196: FROM sy_orgn_mst
1197: WHERE orgn_code = p_orgn_code;
1198:
1199: d_lab_ind sy_orgn_mst.plant_ind%TYPE;
1200: l_lab_ind gmd_quality_config.quality_lab_ind%TYPE;
1201: l_organization_id sy_orgn_mst.organization_id%TYPE;
1202: l_test_org sy_orgn_mst.organization_id%TYPE;
1203:
1204:

Line 1235: FROM gmd_quality_config

1231: =======================================*/
1232:
1233: CURSOR get_config IS
1234: SELECT *
1235: FROM gmd_quality_config
1236: WHERE migrated_ind = 1;
1237:
1238:
1239: /*=======================================

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

1251: /*=======================================
1252: Cursor to get config record.
1253: =======================================*/
1254:
1255: CURSOR get_parent_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
1256: SELECT sample_assignment_type, sample_last_assigned
1257: FROM gmd_quality_config
1258: WHERE orgn_code = p_orgn_code;
1259:

Line 1257: FROM gmd_quality_config

1253: =======================================*/
1254:
1255: CURSOR get_parent_config (p_orgn_code gmd_quality_config.orgn_code%TYPE) IS
1256: SELECT sample_assignment_type, sample_last_assigned
1257: FROM gmd_quality_config
1258: WHERE orgn_code = p_orgn_code;
1259:
1260: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1261: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;

Line 1260: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;

1256: SELECT sample_assignment_type, sample_last_assigned
1257: FROM gmd_quality_config
1258: WHERE orgn_code = p_orgn_code;
1259:
1260: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1261: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;
1262:
1263: /*=======================================
1264: Cursor to get gmd_sampling_plans_b

Line 1261: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;

1257: FROM gmd_quality_config
1258: WHERE orgn_code = p_orgn_code;
1259:
1260: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1261: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;
1262:
1263: /*=======================================
1264: Cursor to get gmd_sampling_plans_b
1265: =======================================*/

Line 1276: Cursor to check if gmd_quality_config

1272: l_sample_plan get_sampling_plan%ROWTYPE;
1273: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;
1274:
1275: /*=======================================
1276: Cursor to check if gmd_quality_config
1277: record exists.
1278: =======================================*/
1279:
1280: CURSOR check_for_config(p_org_id NUMBER) IS

Line 1282: FROM gmd_quality_config

1278: =======================================*/
1279:
1280: CURSOR check_for_config(p_org_id NUMBER) IS
1281: SELECT organization_id
1282: FROM gmd_quality_config
1283: WHERE organization_id = p_org_id;
1284:
1285: l_config_org NUMBER;
1286:

Line 1344: p_table_name => 'GMD_QUALITY_CONFIG',

1340: GMA_COMMON_LOGGING.gma_migration_central_log (
1341: p_run_id => p_migration_run_id,
1342: p_log_level => FND_LOG.LEVEL_EVENT,
1343: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1344: p_table_name => 'GMD_QUALITY_CONFIG',
1345: p_token1 => 'TABLE_NAME',
1346: p_param1 => 'GMD_TEST_METHODS_B',
1347: p_context => 'Quality Setup',
1348: p_app_short_name => 'GMA');

Line 1455: Migrate gmd_quality_config.

1451: LOG_SETUP_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
1452:
1453:
1454: /*=========================================
1455: Migrate gmd_quality_config.
1456: First get profile values.
1457: =========================================*/
1458:
1459: P_exact_match := GMD_QC_MIG12.GET_PROFILE_VALUE('QC$EXACTSPECMATCH');

Line 1549: p_table_name => 'GMD_QUALITY_CONFIG',

1545: GMA_COMMON_LOGGING.gma_migration_central_log (
1546: p_run_id => p_migration_run_id,
1547: p_log_level => FND_LOG.LEVEL_EVENT,
1548: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1549: p_table_name => 'GMD_QUALITY_CONFIG',
1550: p_token1 => 'TABLE_NAME',
1551: p_param1 => 'GMD_QUALITY_CONFIG',
1552: p_context => 'Quality Setup',
1553: p_app_short_name => 'GMA');

Line 1551: p_param1 => 'GMD_QUALITY_CONFIG',

1547: p_log_level => FND_LOG.LEVEL_EVENT,
1548: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1549: p_table_name => 'GMD_QUALITY_CONFIG',
1550: p_token1 => 'TABLE_NAME',
1551: p_param1 => 'GMD_QUALITY_CONFIG',
1552: p_context => 'Quality Setup',
1553: p_app_short_name => 'GMA');
1554:
1555: /*==============================================

Line 1556: Loop through gmd_quality_config. Handle

1552: p_context => 'Quality Setup',
1553: p_app_short_name => 'GMA');
1554:
1555: /*==============================================
1556: Loop through gmd_quality_config. Handle
1557: records with org differently than the record
1558: where org is null. First pass gets
1559: non_null records.
1560: ==============================================*/

Line 1663: UPDATE gmd_quality_config

1659: /*=====================================
1660: Update the Row.
1661: =====================================*/
1662:
1663: UPDATE gmd_quality_config
1664: SET organization_id = l_organization_id,
1665: quality_lab_ind = l_lab_ind,
1666: transaction_reason_id = l_reason_id,
1667: in_spec_lot_status_id = l_in_spec_status_id,

Line 1789: Loop through gmd_quality_config. Handle

1785: END LOOP;
1786:
1787:
1788: /*=========================================
1789: Loop through gmd_quality_config. Handle
1790: record with null org. It will be
1791: unchanged but marked as migrated.
1792: =========================================*/
1793:

Line 1805: if existing gmd_quality_config row

1801: RAISE NO_NULL_RECORD;
1802: ELSE
1803: /*====================================
1804: Do not process the null record
1805: if existing gmd_quality_config row
1806: were not successfully migrated.
1807: ====================================*/
1808: GMD_QC_MIG12.g_quality_config_pro_count := GMD_QC_MIG12.g_quality_config_pro_count + 1;
1809: END IF;

Line 1815: already have a row in gmd_quality_config.

1811: CLOSE get_null_quality_config;
1812:
1813: /*===========================================
1814: Get all process orgs that do not
1815: already have a row in gmd_quality_config.
1816: ===========================================*/
1817:
1818: l_org_count := 0;
1819:

Line 1968: INSERT INTO gmd_quality_config(

1964: l_stbl_assignment_type := 2;
1965: l_stbl_last_assigned := 1;
1966: END IF;
1967:
1968: INSERT INTO gmd_quality_config(
1969: ORGN_CODE,
1970: CONTROL_BATCH_STEP_IND,
1971: CONTROL_LOT_ATTRIB_IND,
1972: OUT_OF_SPEC_LOT_STATUS,

Line 2115: UPDATE gmd_quality_config

2111: CLOSE check_config_mig;
2112:
2113: IF (l_config_mig_count = 0) THEN
2114:
2115: UPDATE gmd_quality_config
2116: SET migrated_ind = 1
2117: WHERE orgn_code IS NULL and migrated_ind IS NULL;
2118:
2119: IF (p_commit = FND_API.G_TRUE) THEN

Line 2152: UPDATE gmd_quality_config

2148: IF (get_parent_config%FOUND) THEN
2149: /*=================================
2150: Overlay the sample values.
2151: =================================*/
2152: UPDATE gmd_quality_config
2153: SET sample_assignment_type = l_p_assign_type,
2154: sample_last_assigned = l_p_last_assign
2155: WHERE organization_id = l_config.organization_id;
2156:

Line 2258: Log end of gmd_quality_config migration.

2254: -- Creates the Quality config rows for warehouse (ic_whse_mst) rows
2255: create_config_rows_for_whse(p_migration_run_id, p_commit);
2256:
2257: /*==============================================
2258: Log end of gmd_quality_config migration.
2259: ==============================================*/
2260: LOG_SETUP_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
2261:
2262: /*==============================================