APPS.GMDFMVAL_PUB dependencies on GMD_FORMULA_SUBSTITUTION

Line 1010: FROM gmd_formula_substitution fmsub,

1006: dtl.unit_qty,
1007: hdr.original_uom,
1008: dtl.detail_uom,
1009: hdr.replacement_uom_type /* Added dtl.detail_uom 8271618*/
1010: FROM gmd_formula_substitution fmsub,
1011: gmd_item_substitution_hdr_b hdr,
1012: gmd_item_substitution_dtl dtl
1013: Where fmsub.formula_id = vFormula_id
1014: and fmsub.substitution_id = hdr.substitution_id

Line 1463: FROM gmd_formula_substitution fm

1459: -- Bug# 5354649 Kapil M
1460: -- Bug 5394909 select all except obsoleted substitutions
1461: CURSOR get_substitution IS
1462: SELECT fm.*
1463: FROM gmd_formula_substitution fm
1464: WHERE formula_id = pOldFormula_id
1465: AND associated_flag = 'Y'
1466: AND NOT EXISTS (SELECT 1
1467: FROM gmd_formula_substitution

Line 1467: FROM gmd_formula_substitution

1463: FROM gmd_formula_substitution fm
1464: WHERE formula_id = pOldFormula_id
1465: AND associated_flag = 'Y'
1466: AND NOT EXISTS (SELECT 1
1467: FROM gmd_formula_substitution
1468: WHERE formula_id = pNewFormula_id)
1469: AND EXISTS
1470: (SELECT 1
1471: FROM gmd_item_substitution_hdr_b subs

Line 1538: SELECT gmd_formula_substitution_s.nextval

1534: END IF;
1535: ELSE
1536: x_new_substitution_id := subs_rec.substitution_id;
1537: END IF;
1538: SELECT gmd_formula_substitution_s.nextval
1539: INTO x_newformsubs_id
1540: FROM DUAL;
1541:
1542: -- End of bug# 5354649

Line 1546: INSERT INTO gmd_formula_substitution

1542: -- End of bug# 5354649
1543:
1544: -- Copy all substitution list specific to old formula into
1545: -- new formula
1546: INSERT INTO gmd_formula_substitution
1547: (formula_substitution_id,
1548: substitution_id,
1549: formula_id,
1550: associated_flag,