APPS.GMDFMVAL_PUB dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 1011: gmd_item_substitution_hdr_b hdr,

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
1015: and hdr.substitution_id = dtl.substitution_id

Line 1471: FROM gmd_item_substitution_hdr_b subs

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
1472: WHERE subs.substitution_id = fm.substitution_id
1473: AND (subs.end_date IS NULL OR subs.end_date > SYSDATE)
1474: AND (subs.substitution_status between 700 and 799 OR
1475: subs.substitution_status between 900 and 999));

Line 1480: FROM gmd_item_substitution_hdr_b im

1476:
1477: -- Bug 5394532
1478: CURSOR get_substitution_orgn(c_substitution_id NUMBER) IS
1479: SELECT owner_organization_id
1480: FROM gmd_item_substitution_hdr_b im
1481: WHERE substitution_id = c_substitution_id;
1482:
1483: x_versioning NUMBER := 0;
1484: x_new_substitution_id NUMBER;