eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_MSUTIL_PUB dependencies on MRP_SOURCES_V

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

1766:
1767: IF lMrpAssignmentSet is not null THEN
1768:
1769: --
1770: -- If mrp_sources_v does not insert any rows into
1771: -- bom_cto_src_orgs, this means that no sourcing rules are set-up
1772: -- for this model item in this org. Assuming that in this case
1773: -- the item in this org is sourced from itself, inserting a row
1774: -- with the receiving org as the sourcing org

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

1869:
1870: else
1871:
1872: --
1873: -- If mrp_sources_v does not insert any rows into
1874: -- bom_cto_src_orgs, this means that no sourcing rules are set-up
1875: -- for this model item in this org. Assuming that in this case
1876: -- the item in this org is sourced from itself, inserting a row
1877: -- with the receiving org as the sourcing org

Line 1954: v_source_type mrp_sources_v.source_type%type ;

1950:
1951:
1952: v_t_sourcing_info SOURCING_INFO;
1953: v_buy_traversed boolean := false ;
1954: v_source_type mrp_sources_v.source_type%type ;
1955: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1956:
1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1958: l_source_type mrp_sources_v.source_type%type ;

Line 1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;

1953: v_buy_traversed boolean := false ;
1954: v_source_type mrp_sources_v.source_type%type ;
1955: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1956:
1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1958: l_source_type mrp_sources_v.source_type%type ;
1959: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1960: l_curr_rank mrp_sources_v.rank%type ;
1961: v_sourcing_rule_exists varchar2(10) ;

Line 1958: l_source_type mrp_sources_v.source_type%type ;

1954: v_source_type mrp_sources_v.source_type%type ;
1955: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1956:
1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1958: l_source_type mrp_sources_v.source_type%type ;
1959: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1960: l_curr_rank mrp_sources_v.rank%type ;
1961: v_sourcing_rule_exists varchar2(10) ;
1962:

Line 1959: l_curr_assg_type mrp_sources_v.assignment_type%type ;

1955: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1956:
1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1958: l_source_type mrp_sources_v.source_type%type ;
1959: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1960: l_curr_rank mrp_sources_v.rank%type ;
1961: v_sourcing_rule_exists varchar2(10) ;
1962:
1963:

Line 1960: l_curr_rank mrp_sources_v.rank%type ;

1956:
1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1958: l_source_type mrp_sources_v.source_type%type ;
1959: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1960: l_curr_rank mrp_sources_v.rank%type ;
1961: v_sourcing_rule_exists varchar2(10) ;
1962:
1963:
1964: lstmtnumber number ;

Line 2681: from mrp_sources_v msv

2677: nvl(source_type,1) ,
2678: rank,
2679: assignment_id,
2680: assignment_type
2681: from mrp_sources_v msv
2682: where msv.assignment_set_id = gMrpAssignmentSet
2683: and msv.inventory_item_id = p_inventory_item_id
2684: and msv.organization_id = p_organization_id
2685: -- and nvl(msv.source_type,1) <> 3 commented by Renga for BUY odel

Line 2746: ** Source Type values in MRP_SOURCES_V

2742:
2743:
2744: /*
2745: ** Fix for Bug 1610583
2746: ** Source Type values in MRP_SOURCES_V
2747: ** 1 = Transfer From, 2 = Make At, 3 = Buy From.
2748: */
2749:
2750:

Line 2980: -- only explicit sourcing rules from mrp_sources_v view definition

2976: -- MPR_SOURCES_V will return all the sourcing info including the ones
2977: -- that are defined in the item definition
2978: -- we should copy only the explicit sourcing assignments defined by users
2979: -- added another filter condition assignment_id is not null to select
2980: -- only explicit sourcing rules from mrp_sources_v view definition
2981:
2982: BEGIN
2983:
2984: select distinct assignment_id, assignment_type

Line 2986: from mrp_sources_v msv

2982: BEGIN
2983:
2984: select distinct assignment_id, assignment_type
2985: into lAssignmentId, lAssignmentType
2986: from mrp_sources_v msv
2987: where msv.assignment_set_id = lMrpAssignmentSet
2988: and msv.inventory_item_id = pModelItemId
2989: and msv.organization_id = pRcvOrgId
2990: and effective_date <= nvl(disable_date, sysdate)

Line 3488: from mrp_sources_v msv

3484: BEGIN
3485:
3486: select distinct assignment_id, assignment_type
3487: into lAssignmentId, lAssignmentType
3488: from mrp_sources_v msv
3489: where msv.assignment_set_id = lMrpAssignmentSet
3490: and msv.inventory_item_id = pModelItemId
3491: and msv.organization_id = pRcvOrgId
3492: and effective_date <= nvl(disable_date, sysdate)