DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1190: Bom_Operational_Routings bor

1186: P_Alternate in varchar2,
1187: P_Operation in number) is
1188: Select round(bos.operation_lead_time_percent, 2) oltp
1189: From Bom_Operation_Sequences bos,
1190: Bom_Operational_Routings bor
1191: Where bor.assembly_item_id = P_Assembly
1192: And bor.organization_Id = org_id
1193: And (bor.alternate_routing_designator = P_Alternate
1194: or

Line 1197: FROM bom_operational_routings bor2

1193: And (bor.alternate_routing_designator = P_Alternate
1194: or
1195: (bor.alternate_routing_designator is null AND not exists (
1196: SELECT null
1197: FROM bom_operational_routings bor2
1198: WHERE bor2.assembly_item_id = P_Assembly
1199: AND bor2.organization_id = org_id
1200: AND bor2.alternate_routing_designator = P_Alternate)
1201: ))