DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_ITEM_REVISIONS

Line 547: mtl_item_revisions mir

543: AND ((wmti.entity_type = WIP_CONSTANTS.REPETITIVE
544: AND NOT EXISTS
545: (SELECT 'X'
546: FROM wip_repetitive_schedules wrs,
547: mtl_item_revisions mir
548: WHERE wrs.organization_id = wmti.organization_id
549: AND wrs.repetitive_schedule_id = wmti.repetitive_schedule_id
550: AND mir.organization_id = wmti.organization_id
551: AND mir.inventory_item_id = wmti.primary_item_id

Line 561: mtl_item_revisions mir

557: WIP_CONSTANTS.LOTBASED)
558: AND NOT EXISTS
559: (SELECT 'X'
560: FROM wip_discrete_jobs wdj,
561: mtl_item_revisions mir
562: WHERE wdj.organization_id = wmti.organization_id
563: AND wdj.wip_entity_id = wmti.wip_entity_id
564: AND mir.organization_id = wmti.organization_id
565: AND mir.inventory_item_id = wmti.primary_item_id