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_SPREAD_FETCH_PKG dependencies on GMD_TECHNICAL_PARAMETER_GTMP

Line 761: DELETE FROM gmd_technical_parameter_gtmp;

757:
758: l_rec Cur_get_folder_cols%ROWTYPE;
759: l_count11 number;
760: BEGIN
761: DELETE FROM gmd_technical_parameter_gtmp;
762: l_category_set_id := TO_NUMBER (FND_PROFILE.VALUE ('GMD_TECH_CATG_SET'));
763: IF (V_folder_name IS NOT NULL) THEN
764: OPEN Cur_get_folder_cols;
765: LOOP

Line 768: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP

764: OPEN Cur_get_folder_cols;
765: LOOP
766: FETCH Cur_get_folder_cols INTO l_rec;
767: EXIT WHEN Cur_get_folder_cols%NOTFOUND;
768: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
769: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,
770: DATA_TYPE,EXPRESSION_CHAR,LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,
771: UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
772: VALUES (V_entity_id,l_rec.tech_parm_name,l_rec.tech_parm_id,l_rec.parm_description,l_rec.sequence,l_rec.qcassy_typ_id,

Line 780: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP

776: END LOOP;
777: CLOSE Cur_get_folder_cols;
778:
779: ELSIF (V_sprd_id IS NOT NULL) THEN
780: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
781: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
782: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,OPTIMIZE_TYPE,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
783: SELECT a.sprd_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,b.qcassy_typ_id,
784: b.data_type,b.expression_char,b.lm_unit_code,

Line 820: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP

816: OPEN Cur_get_item_count;
817: FETCH Cur_get_item_count INTO l_count;
818: CLOSE Cur_get_item_count;
819: IF (l_count > 0) THEN
820: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
821: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
822: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
823: SELECT V_entity_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,
824: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,

Line 838: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP

834: OPEN Cur_get_category_count;
835: FETCH Cur_get_category_count INTO l_count;
836: CLOSE Cur_get_category_count;
837: IF (l_count > 0) THEN
838: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
839: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
840: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
841: SELECT V_entity_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,
842: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,

Line 852: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP

848: AND a.category_id = l_category_id
849: AND a.organization_id = V_orgn_id;
850: ELSE
851: --If organization has the parameters then insert
852: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
853: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
854: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
855: SELECT V_entity_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,
856: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,

Line 1062: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1058: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1059: SELECT a.sprd_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1060: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1061: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1062: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1063: WHERE a.tech_parm_id = b.tech_parm_id
1064: AND a.sprd_id = V_entity_id
1065: AND a.line_id = c.sprd_line_id
1066: AND a.organization_id = V_orgn_id

Line 1101: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1097: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1098: SELECT V_entity_id,c.line_id,a.tech_parm_name, a.tech_parm_id,
1099: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1100: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1101: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1102: WHERE a.tech_parm_id = b.tech_parm_id
1103: AND a.organization_id = V_orgn_id
1104: AND a.inventory_item_id = c.inventory_item_id
1105: AND c.parent_line_id = V_matl_detl_id

Line 1164: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1160: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1161: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1162: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1163: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1164: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1165: WHERE a.tech_parm_id = b.tech_parm_id
1166: AND a.organization_id = V_orgn_id
1167: AND a.inventory_item_id = c.inventory_item_id
1168: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1279: FROM gmd_technical_parameter_gtmp

1275: last_updated_by,last_update_date,created_by,creation_date)
1276: SELECT X_sprd_id, V_orgn_id,tech_parm_name,tech_parm_id,sort_seq,data_type,
1277: expression_char,lowerbound_num,upperbound_num,signif_figures,optimize_type,
1278: l_user_id,sysdate,l_user_id,sysdate
1279: FROM gmd_technical_parameter_gtmp
1280: WHERE entity_id = V_entity_id;
1281:
1282: FOR l_rec IN Cur_sprd_insert LOOP
1283: OPEN Cur_line_id;

Line 1520: FROM gmd_technical_parameter_gtmp

1516: PROCEDURE load_quality_data (V_line_id IN NUMBER, V_orgn_id IN NUMBER,V_plant_id IN NUMBER) IS
1517:
1518: CURSOR Cur_get_qmdata IS
1519: SELECT *
1520: FROM gmd_technical_parameter_gtmp
1521: WHERE qcassy_typ_id IS NOT NULL;
1522:
1523: CURSOR Cur_get_data IS
1524: SELECT *

Line 1792: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1788: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1789: SELECT V_entity_id,c.line_id,b.tech_parm_name,a.tech_parm_id,
1790: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1791: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1792: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1793: WHERE a.tech_parm_id = b.tech_parm_id
1794: AND a.organization_id = V_orgn_id
1795: AND a.inventory_item_id = c.inventory_item_id
1796: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1824: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1820:
1821: PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER) IS
1822: CURSOR Cur_get_type IS
1823: SELECT a.*, c.line_id line, b.tech_parm_id tech, b.tech_parm_name name,b.sort_seq, c.inventory_item_id
1824: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1825: WHERE a.tech_parm_id = b.tech_parm_id
1826: AND c.line_id = V_line_id;
1827: l_value NUMBER;
1828: l_parm_value VARCHAR2(240);