DBA Data[Home] [Help]

APPS.BOMPKMUD dependencies on BOM_OPERATIONAL_ROUTINGS

Line 750: bom_operational_routings r

746: eng_revised_items_interface ri
747: WHERE ci.operation_seq_num NOT IN (
748: SELECT o.operation_seq_num
749: FROM bom_operation_sequences o,
750: bom_operational_routings r
751: WHERE NVL(TRUNC(o.disable_date), NVL(ri.scheduled_date,
752: TRUNC(SYSDATE)) + 1)
753: > NVL(ri.scheduled_date,TRUNC(SYSDATE))
754: AND r.common_routing_sequence_id =

Line 762: FROM bom_operational_routings rr

758: OR
759: (r.alternate_routing_designator IS NULL
760: AND NOT EXISTS (
761: SELECT NULL
762: FROM bom_operational_routings rr
763: WHERE rr.alternate_routing_designator =
764: l.alternate_designator
765: AND rr.assembly_item_id =
766: l.assembly_item_id