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 1726: -- If mrp_sources_v does not insert any rows into

1722: lStmtNumber := 140;
1723: IF lMrpAssignmentSet is not null THEN
1724:
1725: --
1726: -- If mrp_sources_v does not insert any rows into
1727: -- bom_cto_src_orgs, this means that no sourcing rules are set-up
1728: -- for this model item in this org. Assuming that in this case
1729: -- the item in this org is sourced from itself, inserting a row
1730: -- with the receiving org as the sourcing org

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

1826:
1827: -- Bugfix 16315202: This else is not needed. Added an end if before.
1828: -- else
1829: -- --
1830: -- -- If mrp_sources_v does not insert any rows into
1831: -- -- bom_cto_src_orgs, this means that no sourcing rules are set-up
1832: -- -- for this model item in this org. Assuming that in this case
1833: -- -- the item in this org is sourced from itself, inserting a row
1834: -- -- with the receiving org as the sourcing org

Line 1904: v_source_type mrp_sources_v.source_type%type ;

1900:
1901:
1902: v_t_sourcing_info SOURCING_INFO;
1903: v_buy_traversed boolean := false ;
1904: v_source_type mrp_sources_v.source_type%type ;
1905: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1906:
1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1908: l_source_type mrp_sources_v.source_type%type ;

Line 1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;

1903: v_buy_traversed boolean := false ;
1904: v_source_type mrp_sources_v.source_type%type ;
1905: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1906:
1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1908: l_source_type mrp_sources_v.source_type%type ;
1909: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1910: l_curr_rank mrp_sources_v.rank%type ;
1911: v_sourcing_rule_exists varchar2(10) ;

Line 1908: l_source_type mrp_sources_v.source_type%type ;

1904: v_source_type mrp_sources_v.source_type%type ;
1905: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1906:
1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1908: l_source_type mrp_sources_v.source_type%type ;
1909: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1910: l_curr_rank mrp_sources_v.rank%type ;
1911: v_sourcing_rule_exists varchar2(10) ;
1912:

Line 1909: l_curr_assg_type mrp_sources_v.assignment_type%type ;

1905: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1906:
1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1908: l_source_type mrp_sources_v.source_type%type ;
1909: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1910: l_curr_rank mrp_sources_v.rank%type ;
1911: v_sourcing_rule_exists varchar2(10) ;
1912:
1913:

Line 1910: l_curr_rank mrp_sources_v.rank%type ;

1906:
1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1908: l_source_type mrp_sources_v.source_type%type ;
1909: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1910: l_curr_rank mrp_sources_v.rank%type ;
1911: v_sourcing_rule_exists varchar2(10) ;
1912:
1913:
1914: lstmtnumber number ;

Line 2671: from mrp_sources_v msv

2667: nvl(source_type,1) ,
2668: rank,
2669: assignment_id,
2670: assignment_type
2671: from mrp_sources_v msv
2672: where msv.assignment_set_id = gMrpAssignmentSet
2673: and msv.inventory_item_id = p_inventory_item_id
2674: and msv.organization_id = p_organization_id
2675: -- and nvl(msv.source_type,1) <> 3 commented by Renga for BUY odel

Line 2736: ** Source Type values in MRP_SOURCES_V

2732:
2733:
2734: /*
2735: ** Fix for Bug 1610583
2736: ** Source Type values in MRP_SOURCES_V
2737: ** 1 = Transfer From, 2 = Make At, 3 = Buy From.
2738: */
2739:
2740:

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

2966: -- MPR_SOURCES_V will return all the sourcing info including the ones
2967: -- that are defined in the item definition
2968: -- we should copy only the explicit sourcing assignments defined by users
2969: -- added another filter condition assignment_id is not null to select
2970: -- only explicit sourcing rules from mrp_sources_v view definition
2971:
2972: BEGIN
2973:
2974: select distinct assignment_id, assignment_type

Line 2976: from mrp_sources_v msv

2972: BEGIN
2973:
2974: select distinct assignment_id, assignment_type
2975: into lAssignmentId, lAssignmentType
2976: from mrp_sources_v msv
2977: where msv.assignment_set_id = lMrpAssignmentSet
2978: and msv.inventory_item_id = pModelItemId
2979: and msv.organization_id = pRcvOrgId
2980: and effective_date <= nvl(disable_date, sysdate)

Line 3705: from mrp_sources_v msv

3701: BEGIN
3702:
3703: select distinct assignment_id, assignment_type
3704: into lAssignmentId, lAssignmentType
3705: from mrp_sources_v msv
3706: where msv.assignment_set_id = lMrpAssignmentSet
3707: and msv.inventory_item_id = pModelItemId
3708: and msv.organization_id = pRcvOrgId
3709: and effective_date <= nvl(disable_date, sysdate)