APPS.GMD_LCF_FETCH_PKG dependencies on GMD_TECH_PARAMETERS_B

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 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 446: FROM gmd_tech_parameters_b a, gmd_lcf_tech_data_gtmp b, gmd_lcf_details_gtmp c

442:
443: PROCEDURE load_tech_values (V_orgn_id IN NUMBER, V_formulation_spec_id IN NUMBER, V_date IN DATE) IS
444: CURSOR Cur_get_type IS
445: SELECT a.*, b.line_id, b.tech_parm_id tech, c.inventory_item_id
446: FROM gmd_tech_parameters_b a, gmd_lcf_tech_data_gtmp b, gmd_lcf_details_gtmp c
447: WHERE a.tech_parm_id = b.tech_parm_id
448: AND b.line_id = c.line_id;
449:
450: CURSOR Cur_get_value (V_inventory_item_id NUMBER, V_tech_parm_id NUMBER) IS

Line 461: FROM gmd_tech_parameters_b

457: AND a.organization_id = V_orgn_id;
458:
459: CURSOR Cur_get_cost_method (P_orgn_id NUMBER) IS
460: SELECT Cost_Type, cost_source
461: FROM gmd_tech_parameters_b
462: WHERE organization_id = P_orgn_id
463: AND Default_cost_parameter = 1;
464:
465: l_density_parameter VARCHAR2(240);

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 488: FROM gmd_tech_parameters_b b, gmd_lcf_details_gtmp c,

484: -- at once no need to loop through.
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:

Line 549: gmd_lcf_details_gtmp c, gmd_tech_parameters_b d

545: (LINE_ID,TECH_PARM_ID,TECH_PARM_NAME,VALUE,NUM_DATA,QCASSY_TYP_ID)
546: SELECT c.line_id,a.tech_parm_id,d.tech_parm_name,
547: a.num_data,a.num_data,d.qcassy_typ_id
548: FROM gmd_technical_data_vl a,
549: gmd_lcf_details_gtmp c, gmd_tech_parameters_b d
550: WHERE a.tech_parm_id = d.tech_parm_id
551: AND d.tech_parm_name = l_density_parameter
552: AND a.organization_id = V_orgn_id
553: AND a.inventory_item_id = c.inventory_item_id;

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;