DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 191: from mtl_material_transactions_temp mmtt

187: and wjdi.substitution_type = p_substitution_type
188: and wjdi.operation_seq_num = p_operation_seq_num
189: and wjdi.inventory_item_id_old = p_inventory_item_id_old
190: and exists (select 1
191: from mtl_material_transactions_temp mmtt
192: where mmtt.transaction_source_id = wjdi.wip_entity_id
193: and mmtt.organization_id = wjdi.organization_id
194: and mmtt.operation_seq_num = wjdi.operation_seq_num
195: and mmtt.inventory_item_id = wjdi.inventory_item_id_old);

Line 289: from mtl_material_transactions_temp mmtt

285: and wjdi.substitution_type = p_substitution_type
286: and wjdi.operation_seq_num = p_operation_seq_num
287: and wjdi.inventory_item_id_old = p_inventory_item_id_old
288: and exists (select 1
289: from mtl_material_transactions_temp mmtt
290: where mmtt.transaction_source_id = wjdi.wip_entity_id
291: and mmtt.organization_id = wjdi.organization_id
292: and mmtt.operation_seq_num = wjdi.operation_seq_num
293: and mmtt.inventory_item_id = wjdi.inventory_item_id_old);