APPS.CTO_UTILITY_PK dependencies on MRP_SOURCES_V

Line 24: | FiXed the where condition in MRP_SOURCES_V query.

20: | Modified on 08-AUG-2000 by Sushant Sawant
21: | Modified on 11-JAN-2001 by Sushant Sawant
22: | removed multilevel profile query
23: | Modified on 30-APR-2001 By Renga Kannan
24: | FiXed the where condition in MRP_SOURCES_V query.
25: | The where condition for the field source_type is added
26: | with nvl function.
27: |
28: |

Line 754: from mrp_sources_v msv

750: l_curr_src_org,
751: l_curr_assg_type,
752: l_curr_rank,
753: l_source_type
754: from mrp_sources_v msv
755: where msv.assignment_set_id = lMrpAssignmentSet
756: and msv.inventory_item_id = pModelItemId
757: and msv.organization_id = l_curr_RcvOrgId
758: --and nvl(msv.source_type,1) <> 3 -- Commented by Renga Kannan on 08/21/01

Line 802: from mrp_sources_v msv

798: lStmtNumber := 52;
799:
800: select count(*)
801: into l_sourcing_rule_count
802: from mrp_sources_v msv
803: where msv.assignment_set_id = lMrpAssignmentSet
804: and msv.inventory_item_id = pModelItemId
805: and msv.organization_id = l_curr_RcvOrgId
806: and nvl(msv.source_type,1) <> 3

Line 1068: -- If mrp_sources_v does not insert any rows into

1064:
1065: END IF; /* check for DROP SHIP , BUY_ITEM_FLAG is not Y */
1066:
1067: --
1068: -- If mrp_sources_v does not insert any rows into
1069: -- bom_cto_src_orgs, this means that no sourcing rules are set-up
1070: -- for this model item in this org. Assuming that in this case
1071: -- the item in this org is sourced from itself, inserting a row
1072: -- with the receiving org as the sourcing org

Line 1747: from mrp_sources_v msv

1743: BEGIN
1744:
1745: select distinct assignment_id, assignment_type
1746: into lAssignmentId, lAssignmentType
1747: from mrp_sources_v msv
1748: where msv.assignment_set_id = lMrpAssignmentSet
1749: and msv.inventory_item_id = pModelItemId
1750: and msv.organization_id = pRcvOrgId
1751: and effective_date <= nvl(disable_date, sysdate)

Line 3250: ** Source Type values in MRP_SOURCES_V

3246:
3247:
3248: /*
3249: ** Fix for Bug 1610583
3250: ** Source Type values in MRP_SOURCES_V
3251: ** 1 = Transfer From, 2 = Make At, 3 = Buy From.
3252: */
3253:
3254:

Line 3279: from mrp_sources_v msv

3275: p_sourcing_org
3276: , v_sourcing_rule_id
3277: , v_source_type
3278: , p_transit_lead_time
3279: from mrp_sources_v msv
3280: where msv.assignment_set_id = gMrpAssignmentSet
3281: and msv.inventory_item_id = p_inventory_item_id
3282: and msv.organization_id = p_organization_id
3283: -- and nvl(msv.source_type,1) <> 3 commented by Renga for BUY odel

Line 3355: from mrp_sources_v msv

3351: oe_debug_pub.add('query_sourcing_org: ' || ' came into too_many when finding source ' || to_char(l_stmt_num) , 1 );
3352: END IF;
3353: select count(*)
3354: into v_sourcing_rule_count
3355: from mrp_sources_v msv
3356: where msv.assignment_set_id = gMrpAssignmentSet
3357: and msv.inventory_item_id = p_inventory_item_id
3358: and msv.organization_id = p_organization_id
3359: and nvl(msv.source_type,1) <> 3