APPS.CTO_MSUTIL_PUB dependencies on OE_ORDER_LINES_ALL

Line 1345: v_source_type_code oe_order_lines_all.source_type_code%type ;

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
1348: select 'Y'
1349: from bom_cto_src_orgs bcso

Line 1471: from oe_order_lines_all

1467: else
1468:
1469: select source_type_code
1470: into v_source_type_code
1471: from oe_order_lines_all
1472: where line_id = pLineId ;
1473:
1474: IF PG_DEBUG <> 0 THEN
1475: oe_debug_pub.add('populate_plan_level: ' || ' non pc bom source type code = '|| v_source_type_code ,1);

Line 4029: from oe_order_lines_all

4025:
4026:
4027: begin
4028: select source_type_code into v_source_type_code
4029: from oe_order_lines_all
4030: where line_id = p_top_ato_line_id ;
4031: exception
4032: when others then
4033: v_source_type_code := 'INTERNAL' ;

Line 4129: from oe_order_lines_all

4125:
4126:
4127: begin
4128: select source_type_code into v_source_type_code
4129: from oe_order_lines_all
4130: where line_id = p_top_ato_line_id ;
4131: exception
4132: when others then
4133: v_source_type_code := 'INTERNAL' ;

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

4696: )
4697: UNION /* added for bug 4291847. item should be enabled in validation org of operating unit where the order was entered */
4698: ( select
4699: to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',oel.org_id),-99)) ou_id
4700: from oe_order_lines_all oel where oel.line_id = pModelLineid )
4701: );
4702:
4703:
4704: -- Printing Orgs