DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on MTL_MATERIAL_TRANSACTIONS

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 211: from mtl_material_transactions mmt

207: and wjdi.substitution_type = p_substitution_type
208: and wjdi.operation_seq_num = p_operation_seq_num
209: and wjdi.inventory_item_id_old = p_inventory_item_id_old
210: and exists (select 1
211: from mtl_material_transactions mmt
212: where mmt.transaction_source_id = wjdi.wip_entity_id
213: and mmt.organization_id = wjdi.organization_id
214: and mmt.operation_seq_num = wjdi.operation_seq_num
215: and mmt.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);

Line 326: from mtl_material_transactions mmt

322: and wjdi.substitution_type = p_substitution_type
323: and wjdi.operation_seq_num = p_operation_seq_num
324: and wjdi.inventory_item_id_old = p_inventory_item_id_old
325: and exists (select 1
326: from mtl_material_transactions mmt
327: where mmt.transaction_source_id = wjdi.wip_entity_id
328: and mmt.organization_id = wjdi.organization_id
329: and mmt.operation_seq_num = wjdi.operation_seq_num
330: and mmt.inventory_item_id = wjdi.inventory_item_id_old);