APPS.GMD_TECH_PARAMS dependencies on LM_ITEM_DAT

Line 279: FROM lm_item_dat i, fm_matl_dtl f

275: CURSOR Cur_lm_attrib IS
276: SELECT i.orgn_code, i.item_id, i.tech_parm_name, i.num_data,
277: i.text_data, i.boolean_data, NVL(f.tpformula_id,0) tpformula_id,
278: f.line_type, f.line_no
279: FROM lm_item_dat i, fm_matl_dtl f
280: WHERE orgn_code = p_lab_type
281: AND i.item_id = f.item_id
282: AND f.formula_id = p_formula_id
283: AND NVL(i.formula_id,0) = NVL(f.tpformula_id,0)

Line 952: FROM lm_item_dat

948: AND plant_ind = 2 ;
949:
950: CURSOR cur_check_item_data IS
951: SELECT 1
952: FROM lm_item_dat
953: WHERE orgn_code = x_lab_type
954: AND lot_id = 0
955: AND delete_mark = 0
956: AND (NVL(formula_id,0) = NVL(pformula_id,0)

Line 1003: /* Check to see if there is any item tech data in lm_item_dat */

999: RAISE NO_LAB_TYPE;
1000: END IF;
1001: END IF;
1002:
1003: /* Check to see if there is any item tech data in lm_item_dat */
1004: OPEN cur_check_item_data;
1005: FETCH cur_check_item_data into x_value;
1006:
1007: /* If there is no data in lm_item_dat, see if there are qc results for this item */

Line 1007: /* If there is no data in lm_item_dat, see if there are qc results for this item */

1003: /* Check to see if there is any item tech data in lm_item_dat */
1004: OPEN cur_check_item_data;
1005: FETCH cur_check_item_data into x_value;
1006:
1007: /* If there is no data in lm_item_dat, see if there are qc results for this item */
1008: IF cur_check_item_data%NOTFOUND THEN
1009: OPEN cur_get_qcvalue;
1010: FETCH cur_get_qcvalue into x_value;
1011: