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 493: from oe_order_lines_all oel,

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

Line 507: into lOEValidationOrg from oe_order_lines_all oel

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

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

1332: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1333: ||to_char(option_number)),
1334: oeh.order_number
1335: into v_missed_item,v_missed_line_number,v_order_number
1336: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1337: where msi.organization_id = oel.ship_from_org_id
1338: and msi.inventory_item_id = oel.inventory_item_id
1339: and oel.header_id = oeh.header_id
1340: and oel.line_id = v_missed_line_id;

Line 1629: from oe_order_lines_all oel

1625:
1626: else
1627: select oel.line_number || '.' || oel.shipment_number
1628: into v_problem_model_line_num
1629: from oe_order_lines_all oel
1630: where line_id = pLineId ;
1631:
1632: end if;
1633:

Line 1776: from oe_order_lines_all oel

1772:
1773:
1774: select oel.line_number || '.' || oel.shipment_number
1775: into v_problem_model_line_num
1776: from oe_order_lines_all oel
1777: where line_id = pLineId ;
1778:
1779:
1780: v_table_count := g_t_dropped_item_type.count + 1 ;