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 2632: wip_entities we

2628: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2629: AND EXISTS -- serialized discrete job and serialized transaction
2630: (SELECT 'X'
2631: FROM wip_discrete_jobs wdj,
2632: wip_entities we
2633: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2634: AND wdj.wip_entity_id = we.wip_entity_id
2635: AND we.entity_type = WIP_CONSTANTS.DISCRETE
2636: AND wdj.serialization_start_op IS NOT NULL

Line 2714: wip_entities we,

2710: AND msn.wip_entity_id = wmti.wip_entity_id)
2711: AND wmti.primary_quantity <>
2712: (SELECT COUNT(*)
2713: FROM wip_serial_move_interface wsmi,
2714: wip_entities we,
2715: mtl_serial_numbers msn,
2716: mtl_object_genealogy mog
2717: WHERE wsmi.transaction_id = wmti.transaction_id
2718: AND wsmi.assembly_serial_number = msn.serial_number