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

1146: v_orgs T_orgtable;
1147:
1148: /*======================================
1149: Cursor to get process orgs.
1150: Changed from mtl_parms to sy_orgn_mst
1151: ======================================*/
1152:
1153: CURSOR get_process_org IS
1154: SELECT m.organization_id

Line 1155: FROM sy_orgn_mst_b m

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

Line 1161: v_org sy_orgn_mst.organization_id%TYPE;

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;
1162: l_org_count NUMBER;
1163:
1164:
1165: /*=================================

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

1190: /*==================================
1191: Cursor to get Lab indicator.
1192: ==================================*/
1193:
1194: CURSOR get_lab_info(p_orgn_code sy_orgn_mst.orgn_code%TYPE) IS
1195: SELECT plant_ind
1196: FROM sy_orgn_mst
1197: WHERE orgn_code = p_orgn_code;
1198:

Line 1196: FROM sy_orgn_mst

1192: ==================================*/
1193:
1194: CURSOR get_lab_info(p_orgn_code sy_orgn_mst.orgn_code%TYPE) IS
1195: SELECT plant_ind
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;

Line 1199: d_lab_ind sy_orgn_mst.plant_ind%TYPE;

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

Line 1201: l_organization_id sy_orgn_mst.organization_id%TYPE;

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

Line 1202: l_test_org sy_orgn_mst.organization_id%TYPE;

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

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

1207: =======================================*/
1208:
1209: -- Bug# 5438990
1210: -- changed column organization_code to orgn_code in the select statement
1211: CURSOR get_orgn_code(v_organization_id sy_orgn_mst.organization_id%TYPE) IS
1212: SELECT orgn_code
1213: FROM sy_orgn_mst
1214: WHERE organization_id = v_organization_id;
1215:

Line 1213: FROM sy_orgn_mst

1209: -- Bug# 5438990
1210: -- changed column organization_code to orgn_code in the select statement
1211: CURSOR get_orgn_code(v_organization_id sy_orgn_mst.organization_id%TYPE) IS
1212: SELECT orgn_code
1213: FROM sy_orgn_mst
1214: WHERE organization_id = v_organization_id;
1215:
1216: -- Bug# 5438990
1217: --l_orgn_code mtl_parameters.organization_code%TYPE;

Line 1218: l_orgn_code sy_orgn_mst.orgn_code%TYPE;

1214: WHERE organization_id = v_organization_id;
1215:
1216: -- Bug# 5438990
1217: --l_orgn_code mtl_parameters.organization_code%TYPE;
1218: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
1219:
1220: /*=======================================
1221: Placeholders for Log Messages.
1222: =======================================*/

Line 1226: l_org_error sy_orgn_mst.organization_id%TYPE;

1222: =======================================*/
1223:
1224: l_valfield VARCHAR2(80);
1225: l_value VARCHAR2(80);
1226: l_org_error sy_orgn_mst.organization_id%TYPE;
1227:
1228:
1229: /*=======================================
1230: Cursor to get config records.

Line 7305: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;

7301: SELECT default_stability_study_org
7302: FROM gmd_migrate_parms;
7303:
7304:
7305: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;
7306: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7307: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7308:
7309: /*=========================================

Line 7306: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;

7302: FROM gmd_migrate_parms;
7303:
7304:
7305: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;
7306: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7307: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7308:
7309: /*=========================================
7310: Cursor to get gmd_ss_material_sources.

Line 7307: l_ss_org_id sy_orgn_mst.organization_id%TYPE;

7303:
7304:
7305: l_def_ss_org sy_orgn_mst.orgn_code%TYPE;
7306: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7307: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7308:
7309: /*=========================================
7310: Cursor to get gmd_ss_material_sources.
7311: Get org id null to exclude records