APPS.GMD_SUBSTITUTION_PUB dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 8: FROM gmd_item_substitution_hdr_b

4: -- Common cursors used
5: CURSOR get_substitution_id(vSubstitution_name VARCHAR2
6: ,vSubstitution_version NUMBER) IS
7: SELECT substitution_id
8: FROM gmd_item_substitution_hdr_b
9: WHERE substitution_name = vSubstitution_name
10: AND substitution_version = vSubstitution_version;
11:
12: CURSOR validate_formula_item(vFormula_id NUMBER,

Line 54: FROM gmd_item_substitution_hdr_b

50: FUNCTION is_update_allowed(p_substitution_id IN NUMBER)
51: RETURN BOOLEAN IS
52: CURSOR get_subs_info(vSubstitution_id NUMBER) IS
53: SELECT substitution_status
54: FROM gmd_item_substitution_hdr_b
55: WHERE substitution_id = p_substitution_id;
56:
57: l_status_code GMD_STATUS.Status_Code%TYPE;
58: l_delete_mark NUMBER := 0;

Line 125: FROM gmd_item_substitution_hdr_b

121: ,vPreference NUMBER
122: ,vStart_date DATE
123: ,vEnd_date DATE) IS
124: SELECT 1
125: FROM gmd_item_substitution_hdr_b
126: WHERE substitution_id <> vSubstitution_id
127: AND original_inventory_item_id = vOriginal_item_id
128: AND preference = vPreference
129: AND vStart_date >= start_date

Line 693: FROM gmd_item_substitution_hdr_b

689: RETURN NUMBER IS
690: l_item_id NUMBER := 0;
691: BEGIN
692: SELECT original_inventory_item_id INTO l_item_id
693: FROM gmd_item_substitution_hdr_b
694: Where substitution_id = vSubstitution_id;
695:
696: RETURN l_item_id;
697: END get_original_item_id;

Line 1217: From gmd_item_substitution_hdr_b

1213: Where substitution_id = vSubstitution_id;
1214:
1215: CURSOR get_substitution_hdr_dtl(vSubstitution_id NUMBER) IS
1216: Select original_inventory_item_id, replacement_uom_type
1217: From gmd_item_substitution_hdr_b
1218: Where substitution_id = vSubstitution_id;
1219:
1220:
1221: -- local variables