APPS.CTO_AUTO_PROCURE_PK dependencies on MRP_SR_ASSIGNMENTS

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

3772: -- Added by Renga Kannan on 03/25/02. took the logic from PO code
3773:
3774: Begin
3775:
3776: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3) */
3777: sourcing_rule_id
3778: INTO l_sourcing_rule_id
3779: FROM mrp_sr_assignments
3780: WHERE inventory_item_id = p_item_id

Line 3779: FROM mrp_sr_assignments

3775:
3776: SELECT /*+ INDEX(MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS_N3) */
3777: sourcing_rule_id
3778: INTO l_sourcing_rule_id
3779: FROM mrp_sr_assignments
3780: WHERE inventory_item_id = p_item_id
3781: AND assignment_set_id = p_assgn_set_id
3782: AND sourcing_rule_type = 1
3783: AND assignment_type = 3;