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 157: from bom_cto_order_lines

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

Line 166: bom_cto_order_lines bcol

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

Line 185: select line_id , inventory_item_id , config_creation from bom_cto_order_lines

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

Line 195: v_config_creation bom_cto_order_lines.config_creation%type ;

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

Line 238: from bom_cto_order_lines

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

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

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

Line 743: from bom_cto_order_lines_upg

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

Line 752: bom_cto_order_lines_upg bcol

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

Line 770: from bom_cto_order_lines_upg

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

Line 781: v_config_creation bom_cto_order_lines_upg.config_creation%type ;

777:
778: v_current_model_line_id number ;
779: v_current_model_item_id number ;
780: v_current_config_item_id number;
781: v_config_creation bom_cto_order_lines_upg.config_creation%type ;
782:
783:
784: v_group_reference_id number ;
785: v_orgs_list cto_oss_source_pk.orgs_list ;

Line 828: from bom_cto_order_lines_upg

824:
825: lStmtNumber := 40;
826: select ship_from_org_id
827: into lShipFromOrgId
828: from bom_cto_order_lines_upg
829: where line_id = v_model_lines.line_id;
830:
831: lStmtNumber := 50;
832: IF PG_DEBUG <> 0 THEN

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

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

Line 1347: lProgramId bom_cto_order_lines.program_id%type ;

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

Line 1359: lConfigCreation bom_cto_order_lines.config_creation%type ;

1355: and model_item_id = pModelItemId
1356: and rcv_org_id = l_curr_src_org;
1357:
1358:
1359: lConfigCreation bom_cto_order_lines.config_creation%type ;
1360: lPerformMatch bom_cto_order_lines.perform_match%type ;
1361: lOptionSpecific bom_cto_order_lines.option_specific%type ;
1362:
1363: vx_concat_org_id varchar2(200) ;

Line 1360: lPerformMatch bom_cto_order_lines.perform_match%type ;

1356: and rcv_org_id = l_curr_src_org;
1357:
1358:
1359: lConfigCreation bom_cto_order_lines.config_creation%type ;
1360: lPerformMatch bom_cto_order_lines.perform_match%type ;
1361: lOptionSpecific bom_cto_order_lines.option_specific%type ;
1362:
1363: vx_concat_org_id varchar2(200) ;
1364: v_group_reference_id number ;

Line 1361: lOptionSpecific bom_cto_order_lines.option_specific%type ;

1357:
1358:
1359: lConfigCreation bom_cto_order_lines.config_creation%type ;
1360: lPerformMatch bom_cto_order_lines.perform_match%type ;
1361: lOptionSpecific bom_cto_order_lines.option_specific%type ;
1362:
1363: vx_concat_org_id varchar2(200) ;
1364: v_group_reference_id number ;
1365: v_100_procured varchar2(1) := 'N' ;

Line 1400: from bom_cto_order_lines

1396: select ato_line_id,
1397: program_id
1398: into lTopAtoLineId,
1399: lProgramId
1400: from bom_cto_order_lines
1401: where line_id = pLineId;
1402: */
1403:
1404: /* BUG#1957336 Changes introduced by sushant for preconfigure bom */

Line 1410: from bom_cto_order_lines

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

Line 1485: --- from the bom_cto_order_lines_table flag

1481:
1482: --- The following if condition is added by Renga Kannan
1483: --- If the line is part of buy model then we need not look at the sourcing info
1484: --- we can keep the parents rcv org as the org for this item also. This can be identified
1485: --- from the bom_cto_order_lines_table flag
1486:
1487:
1488: lStmtNumber := 32;
1489:

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

1987: END IF;
1988:
1989:
1990: if( p_mode = 'AUTOCONFIG' ) then
1991: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines
1992: where line_id = p_line_id ;
1993:
1994: else
1995: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg

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

1991: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines
1992: where line_id = p_line_id ;
1993:
1994: else
1995: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg
1996: where line_id = p_line_id ;
1997:
1998: end if ;
1999:

Line 5168: from bom_cto_order_lines_upg

5164: select inventory_item_id,
5165: nvl(config_creation,1)
5166: into xModelItemId,
5167: l_config_creation
5168: from bom_cto_order_lines_upg
5169: where line_id=pModelLineId;
5170:
5171: ELSE
5172:

Line 5177: from bom_cto_order_lines

5173: select inventory_item_id,
5174: nvl(config_creation,1)
5175: into xModelItemId,
5176: l_config_creation
5177: from bom_cto_order_lines
5178: where line_id=pModelLineId;
5179: END IF;
5180:
5181: if l_config_creation in ('2','3') then