DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on BOM_OPERATIONAL_ROUTINGS

Line 428: Bom_Operational_Routings bor

424: P_Alternate in varchar2,
425: P_Operation in number) is
426: Select round(bos.operation_lead_time_percent, 2) oltp
427: From Bom_Operation_Sequences bos,
428: Bom_Operational_Routings bor
429: Where bor.assembly_item_id = P_Assembly
430: And bor.organization_Id = org_id
431: And (bor.alternate_routing_designator = P_Alternate
432: or

Line 435: from bom_operational_routings bor2

431: And (bor.alternate_routing_designator = P_Alternate
432: or
433: (bor.alternate_routing_designator is null and not exists (
434: select null
435: from bom_operational_routings bor2
436: where bor2.assembly_item_id = P_Assembly
437: and bor2.organization_id = org_id
438: and bor2.alternate_routing_designator = P_Alternate)
439: ))