APPS.WIP_MOVE_VALIDATOR dependencies on WIP_ENTITIES

Line 152: -- validate wip_entity_id against wip_entities table. The caller have an

148: load_errors;
149:
150: END organization_id;
151:
152: -- validate wip_entity_id against wip_entities table. The caller have an
153: -- option to provide either wip_entity_id or wip_entity_name. If the caller
154: -- pass wip_entity_id, the id need to be valid. If the caller pass
155: -- wip_entity_name, we will derive the wip_entity_id. If the caller pass both,
156: -- both value must be consistent to each other. Moreover, the wip_entity_id

Line 178: FROM wip_entities we

174: -- Derive WIP_ENTITY_ID if user provided only WIP_ENTITY_NAME
175: UPDATE wip_move_txn_interface wmti
176: SET wmti.wip_entity_id =
177: (SELECT we.wip_entity_id
178: FROM wip_entities we
179: WHERE we.wip_entity_name = wmti.wip_entity_name
180: AND we.organization_id = wmti.organization_id
181: AND entity_type IN (WIP_CONSTANTS.DISCRETE,
182: WIP_CONSTANTS.REPETITIVE,

Line 203: FROM wip_entities we

199: AND ((wmti.wip_entity_id IS NULL) -- cannot derive WIP_ENTITY_ID
200: OR
201: (NOT EXISTS
202: (SELECT 'X'
203: FROM wip_entities we
204: WHERE we.wip_entity_name = NVL(wmti.wip_entity_name,
205: we.wip_entity_name)
206: AND we.wip_entity_id = wmti.wip_entity_id
207: AND we.organization_id = wmti.organization_id

Line 226: FROM wip_entities we

222: UPDATE wip_move_txn_interface wmti
223: SET (wmti.entity_type, wmti.primary_item_id) =
224: (SELECT we.entity_type,
225: we.primary_item_id
226: FROM wip_entities we
227: WHERE we.wip_entity_id = wmti.wip_entity_id)
228: WHERE wmti.group_id = g_group_id
229: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
230: AND wmti.process_status = WIP_CONSTANTS.RUNNING;

Line 2700: wip_entities we

2696: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2697: AND EXISTS -- serialized discrete job and serialized transaction
2698: (SELECT 'X'
2699: FROM wip_discrete_jobs wdj,
2700: wip_entities we
2701: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2702: AND wdj.wip_entity_id = we.wip_entity_id
2703: AND we.entity_type = WIP_CONSTANTS.DISCRETE
2704: AND wdj.serialization_start_op IS NOT NULL

Line 2782: wip_entities we,

2778: AND msn.wip_entity_id = wmti.wip_entity_id)
2779: AND wmti.primary_quantity <>
2780: (SELECT COUNT(*)
2781: FROM wip_serial_move_interface wsmi,
2782: wip_entities we,
2783: mtl_serial_numbers msn,
2784: mtl_object_genealogy mog
2785: WHERE wsmi.transaction_id = wmti.transaction_id
2786: AND wsmi.assembly_serial_number = msn.serial_number