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 756: from mrp_sources_v msv

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

Line 804: from mrp_sources_v msv

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

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

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

Line 1749: from mrp_sources_v msv

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

Line 3252: ** Source Type values in MRP_SOURCES_V

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

Line 3281: from mrp_sources_v msv

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

Line 3357: from mrp_sources_v msv

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