DBA Data[Home] [Help]

APPS.BOM_DELETE_ITEMS dependencies on BOM_OPERATION_SEQUENCES

Line 713: BOM_OPERATION_SEQUENCES BOS

709: AND BOR.ROUTING_SEQUENCE_ID IN(
710: SELECT DISTINCT BOS.ROUTING_SEQUENCE_ID
711: FROM
712: BOM_OPERATIONAL_ROUTINGS BOR,
713: BOM_OPERATION_SEQUENCES BOS
714: WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
715: AND BOS.DISABLE_DATE <= expiration_date
716: AND BOS.ROUTING_SEQUENCE_ID NOT IN(
717: SELECT NVL(ROUTING_SEQUENCE_ID, 0)

Line 750: BOM_OPERATION_SEQUENCES BOS,

746: SYSDATE,
747: userid,
748: last_login_id
749: FROM
750: BOM_OPERATION_SEQUENCES BOS,
751: BOM_DELETE_ENTITIES BDE,
752: BOM_OPERATIONAL_ROUTINGS BOR,
753: BOM_DEPARTMENTS BD
754: WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID