DBA Data[Home] [Help]

APPS.GMD_SPREAD_CALCULATE_PKG dependencies on GMD_TECHNICAL_PARAMETER_GTMP

Line 19: FROM gmd_material_details_gtmp d, gmd_technical_parameter_gtmp p

15: V_orgn_id IN NUMBER,
16: X_return_status OUT NOCOPY VARCHAR2) IS
17: CURSOR Cur_get_prod IS
18: SELECT d.*, p.tech_parm_name, p.data_type, p.lm_unit_code,p.sort_seq,p.tech_parm_id
19: FROM gmd_material_details_gtmp d, gmd_technical_parameter_gtmp p
20: WHERE d.entity_id = V_entity_id
21: AND p.data_type > 3 AND (p.data_type = 4 OR d.line_type = 1);
22: l_count NUMBER;
23: j NUMBER;