DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1110: Bom_Operational_Routings bor

1106: P_Alternate in varchar2,
1107: P_Operation in number) is
1108: Select round(bos.operation_lead_time_percent, 2) oltp
1109: From Bom_Operation_Sequences bos,
1110: Bom_Operational_Routings bor
1111: Where bor.assembly_item_id = P_Assembly
1112: And bor.organization_Id = org_id
1113: And (bor.alternate_routing_designator = P_Alternate
1114: or

Line 1117: FROM bom_operational_routings bor2

1113: And (bor.alternate_routing_designator = P_Alternate
1114: or
1115: (bor.alternate_routing_designator is null AND not exists (
1116: SELECT null
1117: FROM bom_operational_routings bor2
1118: WHERE bor2.assembly_item_id = P_Assembly
1119: AND bor2.organization_id = org_id
1120: AND bor2.alternate_routing_designator = P_Alternate)
1121: ))