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 SY_ORGN_MST

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 1142: Changed from mtl_parms to sy_orgn_mst

1138: v_orgs T_orgtable;
1139:
1140: /*======================================
1141: Cursor to get process orgs.
1142: Changed from mtl_parms to sy_orgn_mst
1143: ======================================*/
1144:
1145: CURSOR get_process_org IS
1146: SELECT m.organization_id

Line 1147: FROM sy_orgn_mst_b m

1143: ======================================*/
1144:
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:

Line 1153: v_org sy_orgn_mst.organization_id%TYPE;

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;
1154: l_org_count NUMBER;
1155:
1156:
1157: /*=================================

Line 1186: CURSOR get_lab_info(p_orgn_code sy_orgn_mst.orgn_code%TYPE) IS

1182: /*==================================
1183: Cursor to get Lab indicator.
1184: ==================================*/
1185:
1186: CURSOR get_lab_info(p_orgn_code sy_orgn_mst.orgn_code%TYPE) IS
1187: SELECT plant_ind
1188: FROM sy_orgn_mst
1189: WHERE orgn_code = p_orgn_code;
1190:

Line 1188: FROM sy_orgn_mst

1184: ==================================*/
1185:
1186: CURSOR get_lab_info(p_orgn_code sy_orgn_mst.orgn_code%TYPE) IS
1187: SELECT plant_ind
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;

Line 1191: d_lab_ind sy_orgn_mst.plant_ind%TYPE;

1187: SELECT plant_ind
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:

Line 1193: l_organization_id sy_orgn_mst.organization_id%TYPE;

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:
1197: /*=======================================

Line 1194: l_test_org sy_orgn_mst.organization_id%TYPE;

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:
1197: /*=======================================
1198: Cursor to get orgn_code.

Line 1203: CURSOR get_orgn_code(v_organization_id sy_orgn_mst.organization_id%TYPE) IS

1199: =======================================*/
1200:
1201: -- Bug# 5438990
1202: -- changed column organization_code to orgn_code in the select statement
1203: CURSOR get_orgn_code(v_organization_id sy_orgn_mst.organization_id%TYPE) IS
1204: SELECT orgn_code
1205: FROM sy_orgn_mst
1206: WHERE organization_id = v_organization_id;
1207:

Line 1205: FROM sy_orgn_mst

1201: -- Bug# 5438990
1202: -- changed column organization_code to orgn_code in the select statement
1203: CURSOR get_orgn_code(v_organization_id sy_orgn_mst.organization_id%TYPE) IS
1204: SELECT orgn_code
1205: FROM sy_orgn_mst
1206: WHERE organization_id = v_organization_id;
1207:
1208: -- Bug# 5438990
1209: --l_orgn_code mtl_parameters.organization_code%TYPE;

Line 1210: l_orgn_code sy_orgn_mst.orgn_code%TYPE;

1206: WHERE organization_id = v_organization_id;
1207:
1208: -- Bug# 5438990
1209: --l_orgn_code mtl_parameters.organization_code%TYPE;
1210: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
1211:
1212: /*=======================================
1213: Placeholders for Log Messages.
1214: =======================================*/

Line 1218: l_org_error sy_orgn_mst.organization_id%TYPE;

1214: =======================================*/
1215:
1216: l_valfield VARCHAR2(80);
1217: l_value VARCHAR2(80);
1218: l_org_error sy_orgn_mst.organization_id%TYPE;
1219:
1220:
1221: /*=======================================
1222: Cursor to get config records.

Line 7036: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;

7032: SELECT default_stability_study_org
7033: FROM gmd_migrate_parms;
7034:
7035:
7036: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;
7037: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7038: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7039:
7040: /*=========================================

Line 7037: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;

7033: FROM gmd_migrate_parms;
7034:
7035:
7036: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;
7037: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7038: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7039:
7040: /*=========================================
7041: Cursor to get gmd_ss_material_sources.

Line 7038: l_ss_org_id sy_orgn_mst.organization_id%TYPE;

7034:
7035:
7036: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;
7037: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7038: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7039:
7040: /*=========================================
7041: Cursor to get gmd_ss_material_sources.
7042: Get org id null to exclude records