APPS.PMI_COST_ANALZ_PACK dependencies on FM_MATL_DTL

Line 200: SELECT distinct line_type from fm_matl_dtl

196: item_id_vi IN ic_perd_bal.item_id%TYPE)
197: RETURN NUMBER
198: IS
199: CURSOR line_type_cur IS
200: SELECT distinct line_type from fm_matl_dtl
201: WHERE item_id = item_id_vi
202: order by line_type desc;
203: l_line_type fm_matl_dtl.line_type%type;
204: l_line_type1 fm_matl_dtl.line_type%type := null;

Line 203: l_line_type fm_matl_dtl.line_type%type;

199: CURSOR line_type_cur IS
200: SELECT distinct line_type from fm_matl_dtl
201: WHERE item_id = item_id_vi
202: order by line_type desc;
203: l_line_type fm_matl_dtl.line_type%type;
204: l_line_type1 fm_matl_dtl.line_type%type := null;
205: BEGIN
206: open line_type_cur;
207: LOOP

Line 204: l_line_type1 fm_matl_dtl.line_type%type := null;

200: SELECT distinct line_type from fm_matl_dtl
201: WHERE item_id = item_id_vi
202: order by line_type desc;
203: l_line_type fm_matl_dtl.line_type%type;
204: l_line_type1 fm_matl_dtl.line_type%type := null;
205: BEGIN
206: open line_type_cur;
207: LOOP
208: FETCH line_type_cur into l_line_type;

Line 272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;

268: RETURN NUMBER
269: IS
270: /* Declare and Initialize variables */
271: primary_product_v ic_item_mst.item_id%TYPE := 0;
272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;
273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';

Line 309: fm_matl_dtl

305: CURSOR primary_product_cur(formula_id_p fm_form_mst.formula_id%TYPE)
306: IS
307: SELECT item_id
308: FROM
309: fm_matl_dtl
310: WHERE
311: formula_id = formula_id_p
312: AND line_type = 1
313: ORDER BY

Line 322: fm_matl_dtl

318: item_id_p ic_item_mst.item_id%TYPE)
319: IS
320: SELECT qty, item_um
321: FROM
322: fm_matl_dtl
323: WHERE
324: formula_id = formula_id_p
325: AND line_type = 1
326: AND item_id = item_id_p

Line 352: /* Select primary product from fm_matl_dtl for the formula_id */

348: all_linear:=pkg_var_all_linear;
349: GOTO post_scaling;
350: END IF;
351:
352: /* Select primary product from fm_matl_dtl for the formula_id */
353: OPEN primary_product_cur(formula_id_vi);
354: FETCH primary_product_cur INTO primary_product_v;
355: CLOSE primary_product_cur;
356:

Line 491: FROM fm_matl_dtl

487: /* products are primary items per scaling routine */
488:
489: CURSOR prod_cur(formula_id_p fm_form_mst.formula_id%TYPE) IS
490: SELECT formulaline_id, item_id, qty, 0 as scaled_qty, scale_type, item_um
491: FROM fm_matl_dtl
492: WHERE formula_id = formula_id_p
493: AND line_type in (1,2)
494: ORDER BY line_type;
495:

Line 498: FROM fm_matl_dtl

494: ORDER BY line_type;
495:
496: CURSOR ing_cur(formula_id_p fm_form_mst.formula_id%TYPE) IS
497: SELECT formulaline_id, item_id, qty, 0 as scaled_qty, scale_type, item_um
498: FROM fm_matl_dtl
499: WHERE formula_id = formula_id_p
500: AND line_type = -1;
501:
502: BEGIN

Line 511: fm_matl_dtl

507: conversions to fm_yield_type */
508:
509: SELECT count(*) INTO num_fixed_items_v
510: FROM
511: fm_matl_dtl
512: WHERE
513: formula_id = cost_formula_id_v
514: AND scale_type = 0;
515:

Line 654: /* Select the fm_qty from the fm_matl_dtl table if the batch

650: /* error during scaling, return null */
651: variance_v := 0;
652: RETURN NULL;
653: ELSE
654: /* Select the fm_qty from the fm_matl_dtl table if the batch
655: formulaline_id is non-zero, otherwise fm_qty is 0 */
656: IF batch_formulaline_id_v <> 0 THEN
657: BEGIN
658: /* Should fetch only one row */

Line 662: FROM fm_matl_dtl

658: /* Should fetch only one row */
659: SELECT qty, line_type, scale_type, item_um
660: INTO fm_qty_v, fm_line_type_v, fm_scale_type_v,
661: fm_qty_um_v
662: FROM fm_matl_dtl
663: WHERE formula_id = formula_id_vi
664: AND item_id = batch_item_id_v
665: AND formulaline_id = batch_formulaline_id_v;
666: