APPS.GMDFMVAL_PUB dependencies on FM_MATL_DTL

Line 87: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE := 0;

83: xreturn_code OUT NOCOPY NUMBER) IS
84:
85: /* Local variables. */
86: /* ================ */
87: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE := 0;
88:
89: /* Cursor Definitions. */
90: /* =================== */
91: CURSOR get_formulalineid IS

Line 93: FROM fm_matl_dtl

89: /* Cursor Definitions. */
90: /* =================== */
91: CURSOR get_formulalineid IS
92: SELECT formulaline_id
93: FROM fm_matl_dtl
94: WHERE formulaline_id = pformulaline_id;
95:
96: /* ================================================ */
97: BEGIN

Line 272: FROM fm_matl_dtl

268: /* Cursor Definitions. */
269: /* =================== */
270: CURSOR get_product IS
271: SELECT inventory_item_id
272: FROM fm_matl_dtl
273: WHERE formula_id = pformula_id
274: AND line_type = 1;
275:
276: CURSOR get_uom IS

Line 332: /* Validates before inserting detail line into fm_matl_dtl */

328: /* RETURNS NUMBER */
329: /* 0 Success */
330: /* */
331: /* Description: */
332: /* Validates before inserting detail line into fm_matl_dtl */
333: /* table. */
334: /* If this record that has same formula_id, line_type , */
335: /* and line_no we cannot make an insert. */
336: /* In such cases we return a non zero value. */

Line 352: FROM fm_matl_dtl

348: /* Cursor Definitions. */
349: /* =================== */
350: CURSOR detail_line_cur IS
351: SELECT formula_id
352: FROM fm_matl_dtl
353: WHERE formula_id = pformula_id
354: AND line_type = pline_type
355: AND line_no = pline_no;
356:

Line 762: fm_matl_dtl d

758: /* an item. */
759: CURSOR get_fmitem_cur(pitem_id IN NUMBER) IS
760: select h.formula_no, h.formula_vers, h.formula_id
761: from fm_form_mst h,
762: fm_matl_dtl d
763: where d.inventory_item_id = pitem_id AND
764: h.formula_id = d.formula_id;
765:
766: /* Cursor that returns formulaline_ids for a formula */

Line 769: from fm_matl_dtl

765:
766: /* Cursor that returns formulaline_ids for a formula */
767: CURSOR get_fmline_cur(pformula_id IN NUMBER) IS
768: select formulaline_id
769: from fm_matl_dtl
770: where formula_id = pformula_id;
771:
772: /* Cursor that formula_no and version for a formula_id */
773: CURSOR get_formula_no(pformula_id IN NUMBER) IS

Line 923: from fm_matl_dtl

919: /* the entire row instead of just formulaline ids */
920: /* Cursor that returns formulaline details for a formula */
921: CURSOR get_fmline_cur(pformula_id IN NUMBER) IS
922: select *
923: from fm_matl_dtl
924: where formula_id = pformula_id
925: order by line_type, line_no;
926:
927: BEGIN

Line 963: from fm_matl_dtl

959: xFormulaDetail_tbl OUT NOCOPY formula_detail_tbl) IS
960:
961: CURSOR get_fmline_cur(vformula_id IN NUMBER) IS
962: select *
963: from fm_matl_dtl
964: where formula_id = vformula_id
965: order by line_type, line_no;
966:
967: X_count Number := 0;

Line 1005: FROM fm_matl_dtl

1001: xFormulaDetail_tbl Out NOCOPY formula_detail_tbl) IS
1002:
1003: CURSOR Cur_retrieve_fmline(vFormulaline_id Number) IS
1004: SELECT *
1005: FROM fm_matl_dtl
1006: WHERE formulaline_id = vFormulaline_id;
1007:
1008: CURSOR get_item_substitution (vFormula_id Number
1009: ,vItem_id Number

Line 1046: get_fmline_rec fm_matl_dtl%ROWTYPE;

1042: l_sub_original_qty NUMBER;
1043: l_sub_replace_qty NUMBER;
1044: l_original_item_uom VARCHAR2(4);
1045:
1046: get_fmline_rec fm_matl_dtl%ROWTYPE;
1047: l_new_qty NUMBER;
1048: l_integer_scale_ratio NUMBER := 1;
1049:
1050: l_subst_recs NUMBER := 0; /* Added in Bug No.7460898 */

Line 2116: FROM fm_matl_dtl d,

2112: CURSOR cur_check_expr(p_org_id NUMBER) IS
2113: SELECT 1
2114: FROM SYS.DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM fm_matl_dtl d,
2117: mtl_system_items_b i
2118: WHERE recipe_enabled_flag ='Y'
2119: AND i.ORGANIZATION_ID = p_org_id
2120: AND d.formula_id = V_formula_id

Line 2165: FROM fm_matl_dtl

2161: -------------------------------------------------------------------
2162: --Cursor returns the sum of total quantity of a formaula
2163: CURSOR cur_check_total_output IS
2164: SELECT SUM(qty)
2165: FROM fm_matl_dtl
2166: WHERE formula_id = V_formula_id
2167: AND line_type > 0;
2168:
2169: l_total_output NUMBER;

Line 2200: WHERE EXISTS (SELECT 1 FROM fm_matl_dtl d,

2196: --Cursor fetches 1 if context formula has experied item(s)
2197: CURSOR cur_check_inactive IS
2198: SELECT 1
2199: FROM SYS.DUAL
2200: WHERE EXISTS (SELECT 1 FROM fm_matl_dtl d,
2201: mtl_system_items_b i
2202: WHERE d.formula_id = V_formula_id
2203: AND i.inventory_item_id = d.inventory_item_id
2204: AND i.recipe_enabled_flag = 'N'