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

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

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

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

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 ;

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

3848: END update_item_num;
3849:
3850:
3851: function inherit_op_seq_ml(
3852: pLineId in oe_order_lines.line_id%TYPE := NULL,
3853: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
3854: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
3855: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
3856: xErrorMessage out NOCOPY VARCHAR2,

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

3849:
3850:
3851: function inherit_op_seq_ml(
3852: pLineId in oe_order_lines.line_id%TYPE := NULL,
3853: pOrgId in oe_order_lines.ship_from_org_id%TYPE := NULL,
3854: pModelId in bom_bill_of_materials.assembly_item_id%TYPE := NULL ,
3855: pConfigBillId in bom_inventory_components.bill_sequence_id%TYPE := NULL,
3856: xErrorMessage out NOCOPY VARCHAR2,
3857: xMessageName out NOCOPY VARCHAR2)