APPS.INV_ATTACHMENTS_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 82

 select f.short_text
 from fnd_attached_documents     a,
      fnd_documents              b,
      fnd_documents_vl           c,
      fnd_document_categories_vl d,
      fnd_documents_short_text   f
 where a.ENTITY_NAME             = 'MTL_CATEGORIES'
 and   a.PK1_VALUE               in (select distinct e.category_id
      				     from   mtl_item_categories_v e
				     where  e.organization_id   = k_organization_id
				     and    e.inventory_item_id = k_inventory_item_id)
 and   a.DOCUMENT_ID             = b.document_id
 and   b.datatype_id             = 1 -- short text
 and   b.category_id             = d.category_id
 and   d.USER_NAME               = decode(k_document_category,
                                            1,'To Mobile Receiver',
                                            2,'To Mobile Putaway',
                                            3,'To Mobile Picker')
 --and   d.SOURCE_LANG             = 'US'
 and   b.document_id             = c.document_id
 and   f.media_id                = c.media_id;

Line: 109

 select distinct category_id
 from mtl_item_categories_v
 where organization_id   = k_organization_id
 and   inventory_item_id = k_inventory_item_id;

Line: 119

 select f.long_text
 from fnd_attached_documents    a,
      fnd_documents             b,
     fnd_documents_vl           c,
     fnd_document_categories_vl d,
     fnd_documents_long_text    f
 where a.ENTITY_NAME             = 'MTL_CATEGORIES'
 and   a.PK1_VALUE               = k_category_id
 and   a.DOCUMENT_ID             = b.document_id
 and   b.datatype_id             = 2 -- long text
 and   b.category_id             = d.category_id
 and   d.USER_NAME               = decode(k_document_category,
                                            1,'To Mobile Receiver',
                                            2,'To Mobile Putaway',
                                            3,'To Mobile Picker')
 --and   d.SOURCE_LANG             = 'US'
 and   b.document_id             = c.document_id
 and   f.media_id                = c.media_id;

Line: 144

 select f.short_text
 from fnd_attached_documents     a,
      fnd_documents              b,
      fnd_documents_vl           c,
      fnd_document_categories_vl d,
      fnd_documents_short_text   f
 where a.ENTITY_NAME             = 'MTL_SYSTEM_ITEMS'
 and   a.PK1_VALUE               = k_organization_id
 and   a.PK2_VALUE               = k_inventory_item_id
 and   a.DOCUMENT_ID             = b.document_id
 and   b.datatype_id             = 1 -- short text
 and   b.category_id             = d.category_id
 and   d.USER_NAME               = decode(p_document_category,
                                          1,'To Mobile Receiver',
                                          2,'To Mobile Putaway',
                                          3,'To Mobile Picker')
 --and   d.SOURCE_LANG             = 'US'
 and   b.document_id             = c.document_id
 and   f.media_id                = c.media_id;

Line: 172

 select f.long_text
 from fnd_attached_documents     a,
      fnd_documents              b,
      fnd_documents_vl           c,
      fnd_document_categories_vl d,
      fnd_documents_long_text    f
 where a.ENTITY_NAME             = 'MTL_SYSTEM_ITEMS'
 and   a.PK1_VALUE               = k_organization_id
 and   a.PK2_VALUE               = k_inventory_item_id
 and   a.DOCUMENT_ID             = b.document_id
 and   b.datatype_id             = 2 -- long text
 and   b.category_id             = d.category_id
 and   d.USER_NAME               = decode(p_document_category,
                                          1,'To Mobile Receiver',
                                          2,'To Mobile Putaway',
                                          3,'To Mobile Picker')
 --and   d.SOURCE_LANG             = 'US'
 and   b.document_id             = c.document_id
 and   f.media_id                = c.media_id;

Line: 197

 select distinct trx_source_line_id
 from   mtl_material_transactions_temp
 where  transaction_source_type_id in (2,8,12)
 and    ( nvl(parent_transaction_temp_id,0) = k_transaction_temp_id
        or
          (transaction_temp_id = k_transaction_temp_id
           and
           not exists ( select 1
                        from   mtl_material_transactions_temp
                        where
                          nvl(parent_transaction_temp_id,0) = k_transaction_temp_id
                      )
          )
        );

Line: 216

select f.short_text
from fnd_attached_documents 	a,
     fnd_documents          	b,
     fnd_documents_vl       	c,
     fnd_document_categories_vl	d,
     fnd_documents_short_text   f
where a.ENTITY_NAME 		= 'OE_ORDER_LINES'
and   a.PK1_VALUE   		= k_trx_source_line_id
and   a.DOCUMENT_ID 		= b.document_id
and   b.datatype_id 		= 1 -- short text
and   b.category_id 		= d.category_id
and   d.USER_NAME           = 'To Mobile Picker'
--and   d.SOURCE_LANG         = 'US'
and   b.document_id 		= c.document_id
and   f.media_id 	     	= c.media_id;

Line: 237

select f.long_text
from fnd_attached_documents     a,
     fnd_documents              b,
     fnd_documents_vl           c,
     fnd_document_categories_vl d,
     fnd_documents_long_text   f
where a.ENTITY_NAME             = 'OE_ORDER_LINES'
and   a.PK1_VALUE               = k_trx_source_line_id
and   a.DOCUMENT_ID             = b.document_id
and   b.datatype_id             = 2 -- long text
and   b.category_id             = d.category_id
and   d.USER_NAME               = 'To Mobile Picker'
--and   d.SOURCE_LANG             = 'US'
and   b.document_id             = c.document_id
and   f.media_id                = c.media_id;