APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_INVENTORY_SPEC_VRS

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

66:
67: /* Bug 3473559; Added Hint for spec_id */
68:
69: CURSOR cr_match_spec IS
70: SELECT /*+ INDEX ( b GMD_INVENTORY_SPEC_VRS_N1 ) */
71: a.spec_id,b.spec_vr_id,a.grade_code,revision,decode(a.grade_code,
72: p_inventory_spec_rec.grade_code,1,2),
73: b.locator_id,b.subinventory,b.parent_lot_number,b.lot_number,
74: b.organization_id

Line 75: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b

71: a.spec_id,b.spec_vr_id,a.grade_code,revision,decode(a.grade_code,
72: p_inventory_spec_rec.grade_code,1,2),
73: b.locator_id,b.subinventory,b.parent_lot_number,b.lot_number,
74: b.organization_id
75: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b
76: WHERE
77: a.inventory_item_id = p_inventory_spec_rec.inventory_item_id
78: AND ((p_inventory_spec_rec.revision = a.revision) OR ( p_inventory_spec_rec.revision IS NULL AND a.revision IS NULL)
79: OR (p_inventory_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

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

102: SELECT a.spec_id,b.spec_vr_id,a.grade_code,revision,decode(a.grade_code,
103: p_inventory_spec_rec.grade_code,1,2),
104: b.locator_id,b.subinventory,b.parent_lot_number,b.lot_number,
105: b.organization_id
106: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c
107: WHERE
108: a.inventory_item_id = p_inventory_spec_rec.inventory_item_id
109: AND ((p_inventory_spec_rec.revision = a.revision) OR ( p_inventory_spec_rec.revision IS NULL AND a.revision IS NULL)
110: OR (p_inventory_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))