APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_INVENTORY_SPEC_VRS

Line 72: SELECT /*+ INDEX ( b GMD_INVENTORY_SPEC_VRS_N1 ) */

68:
69: /* Bug 3473559; Added Hint for spec_id */
70:
71: CURSOR cr_match_spec IS
72: SELECT /*+ INDEX ( b GMD_INVENTORY_SPEC_VRS_N1 ) */
73: a.spec_id,b.spec_vr_id,a.grade,decode(a.grade,
74: p_inventory_spec_rec.grade,1,2),
75: b.location,b.whse_code,b.sublot_no,b.lot_no,
76: b.orgn_code

Line 77: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b

73: a.spec_id,b.spec_vr_id,a.grade,decode(a.grade,
74: p_inventory_spec_rec.grade,1,2),
75: b.location,b.whse_code,b.sublot_no,b.lot_no,
76: b.orgn_code
77: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b
78: WHERE
79: a.item_id = p_inventory_spec_rec.item_id
80: AND a.delete_mark = 0
81: AND ((l_check_for_given_grade = 'Y' and p_inventory_spec_rec.grade = a.grade ) OR (l_check_for_null_grade = 'Y' AND a.grade IS NULL )

Line 104: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c

100: SELECT a.spec_id,b.spec_vr_id,a.grade,decode(a.grade,
101: p_inventory_spec_rec.grade,1,2),
102: b.location,b.whse_code,b.sublot_no,b.lot_no,
103: b.orgn_code
104: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c
105: WHERE
106: a.item_id = p_inventory_spec_rec.item_id
107: AND a.delete_mark = 0
108: AND ((l_check_for_given_grade = 'Y' and p_inventory_spec_rec.grade = a.grade )