APPS.CTO_CONFIG_BOM_PK dependencies on OE_ORDER_LINES_ALL

Line 322: v_header_id oe_order_lines_all.header_id%type ;

318:
319: g_futuredate DATE := to_date('01/01/2099','MM/DD/YYYY');
320:
321:
322: v_header_id oe_order_lines_all.header_id%type ;
323:
324:
325: l_return_status varchar2(10) ;
326: l_msg_count number ;

Line 491: from oe_order_lines_all oel,

487: BUG:3484511
488: -----------
489: select nvl(master_organization_id,-99) --bugfix 2646849: master_organization_id can be 0
490: into lOEValidationOrg
491: from oe_order_lines_all oel,
492: oe_system_parameters_all ospa
493: where oel.line_id = pLineid
494: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
495: and oel.inventory_item_id = pModelId;

Line 505: into lOEValidationOrg from oe_order_lines_all oel

501: END IF;
502:
503:
504: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
505: into lOEValidationOrg from oe_order_lines_all oel
506: where oel.line_id = pLineId ;
507:
508:
509: end if ;

Line 1310: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh

1306: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1307: ||to_char(option_number)),
1308: oeh.order_number
1309: into v_missed_item,v_missed_line_number,v_order_number
1310: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1311: where msi.organization_id = oel.ship_from_org_id
1312: and msi.inventory_item_id = oel.inventory_item_id
1313: and oel.header_id = oeh.header_id
1314: and oel.line_id = v_missed_line_id;

Line 1603: from oe_order_lines_all oel

1599:
1600: else
1601: select oel.line_number || '.' || oel.shipment_number
1602: into v_problem_model_line_num
1603: from oe_order_lines_all oel
1604: where line_id = pLineId ;
1605:
1606: end if;
1607:

Line 1750: from oe_order_lines_all oel

1746:
1747:
1748: select oel.line_number || '.' || oel.shipment_number
1749: into v_problem_model_line_num
1750: from oe_order_lines_all oel
1751: where line_id = pLineId ;
1752:
1753:
1754: v_table_count := g_t_dropped_item_type.count + 1 ;