APPS.CTO_CONFIG_BOM_PK dependencies on OE_ORDER_LINES

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 561: xTableName := 'OE_ORDER_LINES ';

557: IF PG_DEBUG <> 0 THEN
558: oe_debug_pub.add('create_bom_ml: ' || 'Total lead time is: ' || to_char(lTotLeadTime), 1);
559: END IF;
560:
561: xTableName := 'OE_ORDER_LINES ';
562: lStmtNum := 43;
563:
564: begin --Bugfix 2374246
565: select CAL.CALENDAR_DATE

Line 615: they are not in oe_order_lines. Do we need to ?

611: Check profile option 'Inherit Operation_sequence_number'. If it is set
612: to 'Yes', ensure that the childern default the operation sequence number
613: from its parent, if not already assigned.
614: Open : As in prev releases, this does not cover non-ATPable SMCs because
615: they are not in oe_order_lines. Do we need to ?
616: +--------------------------------------------------------------------------*/
617:
618: lOpseqProfile := FND_PROFILE.Value('BOM:CONFIG_INHERIT_OP_SEQ');
619:

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 ;

Line 4031: pLineId in oe_order_lines.line_id%TYPE := NULL,

4027: END update_item_num;
4028:
4029:
4030: function inherit_op_seq_ml(
4031: pLineId in oe_order_lines.line_id%TYPE := NULL,
4032: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
4033: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
4034: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
4035: xErrorMessage out NOCOPY VARCHAR2,

Line 4032: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,

4028:
4029:
4030: function inherit_op_seq_ml(
4031: pLineId in oe_order_lines.line_id%TYPE := NULL,
4032: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
4033: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
4034: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
4035: xErrorMessage out NOCOPY VARCHAR2,
4036: xMessageName out NOCOPY VARCHAR2)