APPS.CTO_MSUTIL_PUB dependencies on OE_ORDER_LINES_ALL

Line 1349: v_source_type_code oe_order_lines_all.source_type_code%type ;

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
1352: select 'Y'
1353: from bom_cto_src_orgs bcso

Line 1464: from oe_order_lines_all

1460: END IF;
1461: else
1462: select source_type_code
1463: into v_source_type_code
1464: from oe_order_lines_all
1465: where line_id = pLineId ;
1466:
1467: IF PG_DEBUG <> 0 THEN
1468: oe_debug_pub.add('populate_plan_level: ' || ' non pc bom source type code = '|| v_source_type_code ,1);

Line 4546: from oe_order_lines_all

4542:
4543:
4544: begin
4545: select source_type_code into v_source_type_code
4546: from oe_order_lines_all
4547: where line_id = p_top_ato_line_id ;
4548: exception
4549: when others then
4550: v_source_type_code := 'INTERNAL' ;

Line 4646: from oe_order_lines_all

4642:
4643:
4644: begin
4645: select source_type_code into v_source_type_code
4646: from oe_order_lines_all
4647: where line_id = p_top_ato_line_id ;
4648: exception
4649: when others then
4650: v_source_type_code := 'INTERNAL' ;

Line 5230: from oe_order_lines_all oel where oel.line_id = pModelLineid )

5226: )
5227: UNION /* added for bug 4291847. item should be enabled in validation org of operating unit where the order was entered */
5228: ( select
5229: to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oel.org_id),-99)) ou_id
5230: from oe_order_lines_all oel where oel.line_id = pModelLineid )
5231: );
5232:
5233:
5234: -- Printing Orgs