APPS.GMDFMVAL_PUB dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 1026: ,gmd_item_substitution_hdr_b hdr

1022: ,vSubstitute_item_id Number) IS
1023:
1024: SELECT hdr.original_qty, dtl.unit_qty, hdr.original_uom
1025: FROM gmd_formula_substitution fmsub
1026: ,gmd_item_substitution_hdr_b hdr
1027: ,gmd_item_substitution_dtl dtl
1028: Where fmsub.formula_id = vFormula_id
1029: and fmsub.substitution_id = hdr.substitution_id
1030: and hdr.substitution_id = dtl.substitution_id

Line 1320: FROM gmd_item_substitution_hdr_b subs

1316: AND NOT EXISTS (SELECT 1
1317: FROM gmd_formula_substitution
1318: WHERE formula_id = pNewFormula_id)
1319: AND EXISTS (SELECT 1
1320: FROM gmd_item_substitution_hdr_b subs
1321: WHERE subs.substitution_id = fm.substitution_id
1322: AND (subs.end_date IS NULL OR subs.end_date > SYSDATE)
1323: AND ( subs.substitution_status between 700 and 799
1324: OR subs.substitution_status between 900 and 999));

Line 1329: FROM gmd_item_substitution_hdr_b im

1325:
1326: -- Bug 5394532
1327: CURSOR get_substitution_orgn(c_substitution_id NUMBER) IS
1328: SELECT owner_organization_id
1329: FROM gmd_item_substitution_hdr_b im
1330: WHERE substitution_id = c_substitution_id;
1331:
1332:
1333: x_versioning NUMBER := 0;