APPS.CTO_CONFIG_ROUTING_PK dependencies on OE_ORDER_LINES_ALL

Line 374: xTableName := 'OE_ORDER_LINES_ALL';

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

Line 433: from oe_order_lines_all oel,

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

Line 446: into lOEValidationOrg from oe_order_lines_all oel

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