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 BOM_CTO_ORDER_LINES

Line 12: | 1. Populate temporary tables bom_cto_order_lines and

Line 72: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;

68: | Modified for MOAC project
69: +-----------------------------------------------------------------------------*/
70:
71: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_MSUTIL_PUB';
72: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
73: gMrpAssignmentSet number ;
74:
75: gUserId number := nvl(fnd_global.user_id, -1);
76: gLoginId number := nvl(fnd_global.login_id, -1);

Line 154: from bom_cto_order_lines

150: config_creation,
151: perform_match,
152: config_item_id,
153: option_specific
154: from bom_cto_order_lines
155: where ato_line_id = pTopAtoLineId
156: and bom_item_type = 1
157: and nvl(wip_supply_type,0) <> 6
158: order by plan_level;

Line 163: bom_cto_order_lines bcol

159:
160: cursor c_parent_src_orgs is
161: select distinct bcso.organization_id
162: from bom_cto_src_orgs bcso,
163: bom_cto_order_lines bcol
164: where bcol.line_id = lLineId
165: and bcol.parent_ato_line_id = bcso.line_id
166: and ( bcso.create_bom = 'Y' or bcso.organization_type in ( '3' , '4') ) ; /* 3598139 Buy Models may not have a bom */
167:

Line 182: select line_id , inventory_item_id , config_creation from bom_cto_order_lines

178: where top_model_line_id = pTopAtoLineId;
179:
180:
181: cursor get_each_type1_model is
182: select line_id , inventory_item_id , config_creation from bom_cto_order_lines
183: where bom_item_type = 1 and nvl(wip_supply_type, 1) <> 6
184: and ato_line_id = pTopAtoLineId order by plan_level ;
185:
186:

Line 192: v_config_creation bom_cto_order_lines.config_creation%type ;

188: v_t_org_list CTO_MSUTIL_PUB.org_list;
189:
190: v_current_model_line_id number ;
191: v_current_model_item_id number ;
192: v_config_creation bom_cto_order_lines.config_creation%type ;
193:
194:
195: v_group_reference_id number ;
196: v_orgs_list cto_oss_source_pk.orgs_list ;

Line 235: from bom_cto_order_lines

231:
232: lStmtNumber := 40;
233: select ship_from_org_id
234: into lShipFromOrgId
235: from bom_cto_order_lines
236: where line_id = v_model_lines.line_id;
237:
238: lStmtNumber := 50;
239: IF PG_DEBUG <> 0 THEN

Line 630: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol

626:
627: /*Update Create_BOM Flag for Shared Costing Organizations */
628: update bom_cto_src_orgs_b bcso_b1 set create_bom = 'Y'
629: where ( organization_id , line_id ) in ( select mp.cost_organization_id , bcso_b.line_id
630: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol
631: where bcso_b.top_model_line_id = pTopAtoLineId
632: and bcol.ato_line_id = pTopAtoLineId
633: and bcol.line_id = bcso_b.line_id
634: and bcol.config_creation in ( 1 , 2 )

Line 740: from bom_cto_order_lines_upg

736: config_creation,
737: perform_match,
738: config_item_id,
739: option_specific
740: from bom_cto_order_lines_upg
741: where ato_line_id = pTopAtoLineId
742: and bom_item_type = 1
743: and nvl(wip_supply_type,0) <> 6
744: order by plan_level;

Line 749: bom_cto_order_lines_upg bcol

745:
746: cursor c_parent_src_orgs is
747: select distinct bcso.organization_id
748: from bom_cto_src_orgs bcso,
749: bom_cto_order_lines_upg bcol
750: where bcol.line_id = lLineId
751: and bcol.parent_ato_line_id = bcso.line_id
752: and bcso.create_bom = 'Y';
753:

Line 767: from bom_cto_order_lines_upg

763:
764:
765: cursor get_each_type1_model is
766: select line_id , inventory_item_id , config_creation, config_item_id
767: from bom_cto_order_lines_upg
768: where bom_item_type = 1 and nvl(wip_supply_type, 1) <> 6
769: and ato_line_id = pTopAtoLineId order by plan_level ;
770:
771:

Line 778: v_config_creation bom_cto_order_lines_upg.config_creation%type ;

774:
775: v_current_model_line_id number ;
776: v_current_model_item_id number ;
777: v_current_config_item_id number;
778: v_config_creation bom_cto_order_lines_upg.config_creation%type ;
779:
780:
781: v_group_reference_id number ;
782: v_orgs_list cto_oss_source_pk.orgs_list ;

Line 823: from bom_cto_order_lines_upg

819:
820: lStmtNumber := 40;
821: select ship_from_org_id
822: into lShipFromOrgId
823: from bom_cto_order_lines_upg
824: where line_id = v_model_lines.line_id;
825:
826: lStmtNumber := 50;
827: IF PG_DEBUG <> 0 THEN

Line 1094: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol

1090:
1091: /*Update Create_BOM Flag for Shared Costing Organizations */
1092: update bom_cto_src_orgs_b bcso_b1 set create_bom = 'Y'
1093: where ( organization_id , line_id ) in ( select mp.cost_organization_id , bcso_b.line_id
1094: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol
1095: where bcso_b.top_model_line_id = pTopAtoLineId
1096: and bcol.ato_line_id = pTopAtoLineId
1097: and bcol.line_id = bcso_b.line_id
1098: and bcol.config_creation in ( 1 , 2 )

Line 1343: lProgramId bom_cto_order_lines.program_id%type ;

1339: -- End of addition on 08/26/01 for procuring configuration
1340:
1341: multiorg_error exception;
1342: po_multiorg_error exception;
1343: lProgramId bom_cto_order_lines.program_id%type ;
1344:
1345: v_source_type_code oe_order_lines_all.source_type_code%type ;
1346:
1347: CURSOR c_circular_src IS

Line 1355: lConfigCreation bom_cto_order_lines.config_creation%type ;

1351: and model_item_id = pModelItemId
1352: and rcv_org_id = l_curr_src_org;
1353:
1354:
1355: lConfigCreation bom_cto_order_lines.config_creation%type ;
1356: lPerformMatch bom_cto_order_lines.perform_match%type ;
1357: lOptionSpecific bom_cto_order_lines.option_specific%type ;
1358:
1359: vx_concat_org_id varchar2(200) ;

Line 1356: lPerformMatch bom_cto_order_lines.perform_match%type ;

1352: and rcv_org_id = l_curr_src_org;
1353:
1354:
1355: lConfigCreation bom_cto_order_lines.config_creation%type ;
1356: lPerformMatch bom_cto_order_lines.perform_match%type ;
1357: lOptionSpecific bom_cto_order_lines.option_specific%type ;
1358:
1359: vx_concat_org_id varchar2(200) ;
1360: v_group_reference_id number ;

Line 1357: lOptionSpecific bom_cto_order_lines.option_specific%type ;

1353:
1354:
1355: lConfigCreation bom_cto_order_lines.config_creation%type ;
1356: lPerformMatch bom_cto_order_lines.perform_match%type ;
1357: lOptionSpecific bom_cto_order_lines.option_specific%type ;
1358:
1359: vx_concat_org_id varchar2(200) ;
1360: v_group_reference_id number ;
1361: v_100_procured varchar2(1) := 'N' ;

Line 1396: from bom_cto_order_lines

1392: select ato_line_id,
1393: program_id
1394: into lTopAtoLineId,
1395: lProgramId
1396: from bom_cto_order_lines
1397: where line_id = pLineId;
1398: */
1399:
1400:

Line 1407: from bom_cto_order_lines

1403: select ato_line_id,parent_ato_line_id, nvl(program_id,0)
1404: , config_creation , perform_match , option_specific /* added by sushant for preconfigure bom identification */
1405: into lTopAtoLineId,l_parent_ato_line_id, lProgramId
1406: , lConfigCreation, lPerformMatch , lOptionSpecific
1407: from bom_cto_order_lines
1408: where line_id = pLineId;
1409:
1410: -- Get the source type of its parent Model line
1411: -- If the parent model is of buy type we should not look for

Line 1492: --- from the bom_cto_order_lines_table flag

1488:
1489: --- The following if condition is added by Renga Kannan
1490: --- If the line is part of buy model then we need not look at the sourcing info
1491: --- we can keep the parents rcv org as the org for this item also. This can be identified
1492: --- from the bom_cto_order_lines_table flag
1493:
1494:
1495: lStmtNumber := 32;
1496:

Line 2016: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines

2012: END IF;
2013:
2014:
2015: if( p_mode = 'AUTOCONFIG' ) then
2016: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines
2017: where line_id = p_line_id ;
2018:
2019: else
2020: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg

Line 2020: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg

2016: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines
2017: where line_id = p_line_id ;
2018:
2019: else
2020: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg
2021: where line_id = p_line_id ;
2022:
2023: end if ;
2024:

Line 4638: from bom_cto_order_lines_upg

4634: select inventory_item_id,
4635: nvl(config_creation,1)
4636: into xModelItemId,
4637: l_config_creation
4638: from bom_cto_order_lines_upg
4639: where line_id=pModelLineId;
4640:
4641: ELSE
4642:

Line 4647: from bom_cto_order_lines

4643: select inventory_item_id,
4644: nvl(config_creation,1)
4645: into xModelItemId,
4646: l_config_creation
4647: from bom_cto_order_lines
4648: where line_id=pModelLineId;
4649: END IF;
4650:
4651: if l_config_creation in ('2','3') then