APPS.CTO_AUTO_PROCURE_PK dependencies on MRP_SR_ASSIGNMENTS

Line 4186: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3) */

4182: -- Added by Renga Kannan on 03/25/02. took the logic from PO code
4183:
4184: Begin
4185:
4186: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3) */
4187: sourcing_rule_id
4188: INTO l_sourcing_rule_id
4189: FROM mrp_sr_assignments
4190: WHERE inventory_item_id = p_item_id

Line 4189: FROM mrp_sr_assignments

4185:
4186: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3) */
4187: sourcing_rule_id
4188: INTO l_sourcing_rule_id
4189: FROM mrp_sr_assignments
4190: WHERE inventory_item_id = p_item_id
4191: AND assignment_set_id = p_assgn_set_id
4192: AND sourcing_rule_type = 1
4193: AND assignment_type = 3;