APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_TECH_PARAMETERS_B

Line 1676: FROM gmd_tech_parameters_b

1672: P_entity_id NUMBER) IS
1673:
1674: CURSOR cur_get_param (v_density VARCHAR2) IS
1675: SELECT tech_parm_id
1676: FROM gmd_tech_parameters_b
1677: WHERE tech_parm_name = v_density
1678: AND organization_id = P_orgn_id;
1679:
1680: CURSOR cur_get_value (v_tech_parm_id NUMBER) IS

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

1868: PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER) IS
1869: CURSOR Cur_get_type IS
1870: SELECT a.*, c.line_id line, b.tech_parm_id tech, b.tech_parm_name name,b.sort_seq,
1871: c.inventory_item_id,c.detail_uom
1872: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1873: WHERE a.tech_parm_id = b.tech_parm_id
1874: AND c.line_id = V_line_id;
1875: CURSOR Cur_get_item (V_inv_item_id NUMBER) IS
1876: SELECT primary_uom_code