DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on BOM_OPERATIONAL_ROUTINGS

Line 424: Bom_Operational_Routings bor

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

Line 431: from bom_operational_routings bor2

427: And (bor.alternate_routing_designator = P_Alternate
428: or
429: (bor.alternate_routing_designator is null and not exists (
430: select null
431: from bom_operational_routings bor2
432: where bor2.assembly_item_id = P_Assembly
433: and bor2.organization_id = org_id
434: and bor2.alternate_routing_designator = P_Alternate)
435: ))