DBA Data[Home] [Help]

APPS.BOMPKMUD dependencies on BOM_OPERATIONAL_ROUTINGS

Line 751: bom_operational_routings r

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

Line 763: FROM bom_operational_routings rr

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