DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_LOT_NUMBERS

Line 654: FROM mtl_lot_numbers mln,

650: AND msi.lot_control_code = WIP_CONSTANTS.LOT)
651: -- This is the first time to complete this assembly to this lot number
652: AND NOT EXISTS
653: (SELECT 'X'
654: FROM mtl_lot_numbers mln,
655: wip_discrete_jobs wdj
656: WHERE wdj.wip_entity_id = wmti.wip_entity_id
657: AND wdj.organization_id = wmti.organization_id
658: AND mln.inventory_item_id = wmti.primary_item_id

Line 695: FROM mtl_lot_numbers mln,

691: AND msi.shelf_life_code = WIP_CONSTANTS.USER_DEFINED_EXP)
692: -- This is the first time to complete this assembly to this lot number
693: AND NOT EXISTS
694: (SELECT 'X'
695: FROM mtl_lot_numbers mln,
696: wip_discrete_jobs wdj
697: WHERE wdj.wip_entity_id = wmti.wip_entity_id
698: AND wdj.organization_id = wmti.organization_id
699: AND mln.inventory_item_id = wmti.primary_item_id