DBA Data[Home] [Help]

APPS.INV_ATTACHMENTS_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 198: from mtl_material_transactions_temp

194:
195: cursor trx_source_line_cursor(k_transaction_temp_id NUMBER)
196: is
197: select distinct trx_source_line_id
198: from mtl_material_transactions_temp
199: where transaction_source_type_id in (2,8,12)
200: and ( nvl(parent_transaction_temp_id,0) = k_transaction_temp_id
201: or
202: (transaction_temp_id = k_transaction_temp_id

Line 205: from mtl_material_transactions_temp

201: or
202: (transaction_temp_id = k_transaction_temp_id
203: and
204: not exists ( select 1
205: from mtl_material_transactions_temp
206: where
207: nvl(parent_transaction_temp_id,0) = k_transaction_temp_id
208: )
209: )