DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 230: from mtl_material_transactions_temp

226:
227: cursor trx_source_line_cursor(k_transaction_temp_id NUMBER)
228: is
229: select distinct trx_source_line_id
230: from mtl_material_transactions_temp
231: where transaction_source_type_id in (2,8,12)
232: and ( nvl(parent_transaction_temp_id,0) = k_transaction_temp_id
233: or
234: (transaction_temp_id = k_transaction_temp_id

Line 237: from mtl_material_transactions_temp

233: or
234: (transaction_temp_id = k_transaction_temp_id
235: and
236: not exists ( select 1
237: from mtl_material_transactions_temp
238: where
239: nvl(parent_transaction_temp_id,0) = k_transaction_temp_id
240: )
241: )