APPS.GMD_LCF_FETCH_PKG dependencies on GMD_FORMULATION_SPECS

Line 24: FROM gmd_tech_parameters_b a, gmd_formulation_specs b

20: AND b.formulation_spec_id = V_formulation_spec_id
21: AND a.data_type IN (5,6,12)
22: UNION
23: SELECT a.tech_parm_name,a.lm_unit_code,b.tech_parm_id,a.data_type
24: FROM gmd_tech_parameters_b a, gmd_formulation_specs b
25: WHERE a.tech_parm_id = b.tech_parm_id
26: AND b.formulation_spec_id = V_formulation_spec_id
27: AND a.data_type IN (5,6,12);
28:

Line 489: gmd_formulation_specs e

485: INSERT INTO GMD_LCF_TECH_DATA_GTMP
486: (LINE_ID,TECH_PARM_ID,TECH_PARM_NAME,QCASSY_TYP_ID)
487: SELECT c.line_id,b.tech_parm_id,b.tech_parm_name,b.qcassy_typ_id
488: FROM gmd_tech_parameters_b b, gmd_lcf_details_gtmp c,
489: gmd_formulation_specs e
490: WHERE b.tech_parm_id = e.tech_parm_id
491: AND e.formulation_spec_id = V_formulation_spec_id;
492:
493: gmd_api_grp.fetch_parm_values (P_orgn_id => V_orgn_id

Line 581: FROM gmd_formulation_specs

577: AND b.organization_id = V_organization_id;
578:
579: CURSOR Cur_get_spec IS
580: SELECT std_uom
581: FROM gmd_formulation_specs
582: WHERE formulation_spec_id = V_formulation_spec_id;
583:
584: CURSOR Cur_get_formula IS
585: SELECT a.*, b.concatenated_segments, b.description, b.primary_uom_code

Line 907: FROM gmd_formulation_specs

903:
904: --Formulation specification details.
905: CURSOR Cur_get_formulation IS
906: SELECT *
907: FROM gmd_formulation_specs
908: WHERE formulation_spec_id = V_formulation_spec_id;
909:
910: --Line id to be used to identify the specific line id number so that
911: --we can pass the value as 1 for that item and 0 to others.