APPS.CTO_CONFIG_ROUTING_PK dependencies on OE_ORDER_LINES_ALL

Line 375: xTableName := 'OE_ORDER_LINES_ALL';

371: +---------------------------------------------------------------*/
372:
373: /**** comment begins --------------------------------------------------------+
374:
375: xTableName := 'OE_ORDER_LINES_ALL';
376: lStmtNum := 10;
377:
378: select CAL.CALENDAR_DATE
379: into lEstRelDate

Line 429: from oe_order_lines_all oel,

425: BUG:3484511
426: -----------
427: select nvl(master_organization_id,-99) --bugfix 2646849: master_organization_id can be 0
428: into lOEValidationOrg
429: from oe_order_lines_all oel,
430: oe_system_parameters_all ospa
431: where oel.line_id = pLineid
432: and nvl(oel.org_id, -1) = nvl(ospa.org_id, -1) --bug 1531691
433: and oel.inventory_item_id = pModelId;

Line 442: into lOEValidationOrg from oe_order_lines_all oel

438: END IF;
439:
440:
441: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
442: into lOEValidationOrg from oe_order_lines_all oel
443: where oel.line_id = pLineId ;
444:
445: end if ;
446: