APPS.CTO_ATP_INTERFACE_PK dependencies on MRP_SOURCES_V

Line 3161: ** Source Type values in MRP_SOURCES_V

3157: p_transit_lead_time := 0 ;
3158:
3159: /*
3160: ** Fix for Bug 1610583
3161: ** Source Type values in MRP_SOURCES_V
3162: ** 1 = Transfer From, 2 = Make At, 3 = Buy From.
3163: */
3164: -- If the sourcing is defined in the org level the source_type
3165: -- will be null. Still we need to see that sourcing rule. So the condition

Line 3184: from mrp_sources_v msv

3180: p_sourcing_org
3181: , v_sourcing_rule_id
3182: , v_source_type
3183: , p_transit_lead_time
3184: from mrp_sources_v msv
3185: where msv.assignment_set_id = gMrpAssignmentSet
3186: and msv.inventory_item_id = p_inventory_item_id
3187: and msv.organization_id = p_organization_id
3188: and nvl(effective_date,sysdate) <= nvl(disable_date, sysdate)

Line 3242: from mrp_sources_v msv

3238: oe_debug_pub.add('query_sourcing_org: ' || ' came into too_many when finding source ' || to_char(l_stmt_num) , 1 );
3239: END IF;
3240: select count(*)
3241: into v_sourcing_rule_count
3242: from mrp_sources_v msv
3243: where msv.assignment_set_id = gMrpAssignmentSet
3244: and msv.inventory_item_id = p_inventory_item_id
3245: and msv.organization_id = p_organization_id
3246: and nvl(msv.source_type,1) <> 3