DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 530: Bom_Operational_Routings bor

526: P_Alternate in varchar2,
527: P_Operation in number) is
528: Select round(bos.operation_lead_time_percent, 2) oltp
529: From Bom_Operation_Sequences bos,
530: Bom_Operational_Routings bor
531: Where bor.assembly_item_id = P_Assembly
532: And bor.organization_Id = org_id
533: And (bor.alternate_routing_designator = P_Alternate
534: or

Line 537: FROM bom_operational_routings bor2

533: And (bor.alternate_routing_designator = P_Alternate
534: or
535: (bor.alternate_routing_designator is null AND not exists (
536: SELECT null
537: FROM bom_operational_routings bor2
538: WHERE bor2.assembly_item_id = P_Assembly
539: AND bor2.organization_id = org_id
540: AND bor2.alternate_routing_designator = P_Alternate)
541: ))