DBA Data[Home] [Help]

APPS.BOMPBEXP dependencies on BOM_OPERATIONAL_ROUTINGS

Line 285: Bom_Operational_Routings bor

281: P_Alternate in varchar2,
282: P_Operation in number) is
283: Select round(bos.operation_lead_time_percent, 2) oltp
284: From Bom_Operation_Sequences bos,
285: Bom_Operational_Routings bor
286: Where bor.assembly_item_id = P_Assembly
287: And bor.organization_Id = P_Org_Id
288: And (bor.alternate_routing_designator = P_Alternate
289: or

Line 292: from bom_operational_routings bor2

288: And (bor.alternate_routing_designator = P_Alternate
289: or
290: (bor.alternate_routing_designator is null and not exists (
291: select null
292: from bom_operational_routings bor2
293: where bor2.assembly_item_id = P_Assembly
294: and bor2.organization_id = P_Org_Id
295: and bor2.alternate_routing_designator = P_Alternate)
296: ))