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 271: FROM fm_matl_dtl

267: /* Cursor Definitions. */
268: /* =================== */
269: CURSOR get_product IS
270: SELECT inventory_item_id
271: FROM fm_matl_dtl
272: WHERE formula_id = pformula_id
273: AND line_type = 1;
274:
275: 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 351: FROM fm_matl_dtl

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

Line 751: from fm_form_mst h, fm_matl_dtl d

747: /* Cursor that returns multiple formulas for */
748: /* an item. */
749: CURSOR get_fmitem_cur(pitem_id IN NUMBER) IS
750: select h.formula_no, h.formula_vers, h.formula_id
751: from fm_form_mst h, fm_matl_dtl d
752: where d.inventory_item_id = pitem_id
753: AND h.formula_id = d.formula_id;
754:
755: /* Cursor that returns formulaline_ids for a formula */

Line 758: from fm_matl_dtl

754:
755: /* Cursor that returns formulaline_ids for a formula */
756: CURSOR get_fmline_cur(pformula_id IN NUMBER) IS
757: select formulaline_id
758: from fm_matl_dtl
759: where formula_id = pformula_id;
760:
761: /* Cursor that formula_no and version for a formula_id */
762: CURSOR get_formula_no(pformula_id IN NUMBER) IS

Line 907: from fm_matl_dtl

903: /* the entire row instead of just formulaline ids */
904: /* Cursor that returns formulaline details for a formula */
905: CURSOR get_fmline_cur(pformula_id IN NUMBER) IS
906: select *
907: from fm_matl_dtl
908: where formula_id = pformula_id
909: order by line_type, line_no;
910:
911: BEGIN

Line 950: from fm_matl_dtl

946: xFormulaDetail_tbl OUT NOCOPY formula_detail_tbl) IS
947:
948: CURSOR get_fmline_cur(vformula_id IN NUMBER) IS
949: select *
950: from fm_matl_dtl
951: where formula_id = vformula_id
952: order by line_type, line_no;
953:
954: X_count Number := 0;

Line 992: SELECT * FROM fm_matl_dtl WHERE formulaline_id = vFormulaline_id;

988: pDate in DATE,
989: xFormulaDetail_tbl Out NOCOPY formula_detail_tbl) IS
990:
991: CURSOR Cur_retrieve_fmline(vFormulaline_id Number) IS
992: SELECT * FROM fm_matl_dtl WHERE formulaline_id = vFormulaline_id;
993:
994: CURSOR get_item_substitution(vFormula_id Number, vFormulaline_id Number, vItem_id Number, vDate Date) IS
995: SELECT *
996: FROM gmd_material_effectivities_vw vw

Line 1031: get_fmline_rec fm_matl_dtl%ROWTYPE;

1027: l_sub_original_qty NUMBER;
1028: l_sub_replace_qty NUMBER;
1029: l_original_item_uom VARCHAR2(4);
1030:
1031: get_fmline_rec fm_matl_dtl%ROWTYPE;
1032: l_new_qty NUMBER;
1033: l_integer_scale_ratio NUMBER := 1;
1034:
1035: l_subst_recs NUMBER := 0; /* Added in Bug No.7460898 */

Line 2278: FROM fm_matl_dtl d, mtl_system_items_b i

2274: CURSOR cur_check_expr(p_org_id NUMBER) IS
2275: SELECT 1
2276: FROM SYS.DUAL
2277: WHERE EXISTS (SELECT 1
2278: FROM fm_matl_dtl d, mtl_system_items_b i
2279: WHERE recipe_enabled_flag = 'Y'
2280: AND i.ORGANIZATION_ID = p_org_id
2281: AND d.formula_id = V_formula_id
2282: AND i.inventory_item_id = d.inventory_item_id

Line 2327: FROM fm_matl_dtl

2323: -------------------------------------------------------------------
2324: --Cursor returns the sum of total quantity of a formaula
2325: CURSOR cur_check_total_output IS
2326: SELECT SUM(qty)
2327: FROM fm_matl_dtl
2328: WHERE formula_id = V_formula_id
2329: AND line_type > 0;
2330:
2331: l_total_output NUMBER;

Line 2364: FROM fm_matl_dtl d, mtl_system_items_b i

2360: CURSOR cur_check_inactive IS
2361: SELECT 1
2362: FROM SYS.DUAL
2363: WHERE EXISTS (SELECT 1
2364: FROM fm_matl_dtl d, mtl_system_items_b i
2365: WHERE d.formula_id = V_formula_id
2366: AND i.inventory_item_id = d.inventory_item_id
2367: AND i.recipe_enabled_flag = 'N'
2368: AND i.organization_id = d.organization_id); -- Bug # 5040915 Kapil M