APPS.GMD_LCF_FETCH_PKG dependencies on GMD_TECHNICAL_REQS

Line 18: FROM gmd_tech_parameters_b a, gmd_technical_reqs b

14: PROCEDURE calculate (V_formulation_spec_id IN NUMBER, V_line_id IN NUMBER,
15: X_return_status OUT NOCOPY VARCHAR2) IS
16: CURSOR Cur_get_prod IS
17: SELECT a.tech_parm_name,a.lm_unit_code,b.tech_parm_id,a.data_type
18: FROM gmd_tech_parameters_b a, gmd_technical_reqs b
19: WHERE a.tech_parm_id = b.tech_parm_id
20: AND b.formulation_spec_id = V_formulation_spec_id
21: AND a.data_type IN (5,6,12)
22: UNION

Line 479: FROM gmd_technical_reqs b,gmd_lcf_details_gtmp c, gmd_tech_parameters_b d

475: IF (V_orgn_id IS NOT NULL) THEN
476: INSERT INTO GMD_LCF_TECH_DATA_GTMP
477: (LINE_ID,TECH_PARM_ID,TECH_PARM_NAME,QCASSY_TYP_ID)
478: SELECT c.line_id,b.tech_parm_id,d.tech_parm_name,d.qcassy_typ_id
479: FROM gmd_technical_reqs b,gmd_lcf_details_gtmp c, gmd_tech_parameters_b d
480: WHERE b.tech_parm_id = d.tech_parm_id
481: AND b.formulation_spec_id = V_formulation_spec_id;
482:
483: -- if tech params data type is not 12 then insert the values from item tech data tables

Line 968: FROM gmd_technical_reqs a, gmd_tech_parameters_b b

964:
965: --Get the technical requirements defined for particular formulation specification.
966: CURSOR Cur_get_tech_req (V_formulation_spec_id NUMBER) IS
967: SELECT a.tech_parm_id,a.min_value, a.max_value, b.tech_parm_name
968: FROM gmd_technical_reqs a, gmd_tech_parameters_b b
969: WHERE a.tech_parm_id = b.tech_parm_id
970: AND (a.min_value IS NOT NULL OR a.max_value IS NOT NULL)
971: AND a.formulation_spec_id = V_formulation_spec_id;
972: -- ORDER BY a.tech_parm_id;