[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
/*Fixed for bug#8347410
When query fnd_document_categories_vl use of user_name should not
done since it is translated value. Instead of column 'NAME'
should be used which will not be translated and
unique with language_code
*/
and d.NAME = decode(k_document_category,
1,l_To_Mobile_Receiver,
2,l_To_Mobile_Putaway,
3,l_To_Mobile_Picker)
--and d.SOURCE_LANG = 'US'
and b.document_id = c.document_id
and f.media_id = c.media_id;
select distinct category_id
from mtl_item_categories_v
where organization_id = k_organization_id
and inventory_item_id = k_inventory_item_id;
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
/*Fixed for bug#8347410
When query fnd_document_categories_vl use of user_name should not
done since it is translated value. Instead of column 'NAME'
should be used which will not be translated and
unique with language_code
*/
and d.NAME = decode(k_document_category,
1,l_To_Mobile_Receiver,
2,l_To_Mobile_Putaway,
3,l_To_Mobile_Picker)
--and d.SOURCE_LANG = 'US'
and b.document_id = c.document_id
and f.media_id = c.media_id;
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
/*Fixed for bug#8347410
When query fnd_document_categories_vl use of user_name should not
done since it is translated value. Instead of column 'NAME'
should be used which will not be translated and
unique with language_code
*/
and d.NAME = decode(p_document_category,
1,l_To_Mobile_Receiver,
2,l_To_Mobile_Putaway,
3,l_To_Mobile_Picker)
--and d.SOURCE_LANG = 'US'
and b.document_id = c.document_id
and f.media_id = c.media_id;
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
/*Fixed for bug#8347410
When query fnd_document_categories_vl use of user_name should not
done since it is translated value. Instead of column 'NAME'
should be used which will not be translated and
unique with language_code
*/
and d.NAME = decode(p_document_category,
1,l_To_Mobile_Receiver,
2,l_To_Mobile_Putaway,
3,l_To_Mobile_Picker)
--and d.SOURCE_LANG = 'US'
and b.document_id = c.document_id
and f.media_id = c.media_id;
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
)
)
);
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 = to_char(k_trx_source_line_id) --Performance bug#9743038
and a.DOCUMENT_ID = b.document_id
and b.datatype_id = 1 -- short text
and b.category_id = d.category_id
/*Fixed for bug#8347410
When query fnd_document_categories_vl use of user_name should not
done since it is translated value. Instead of column 'NAME'
should be used which will not be translated and
unique with language_code
*/
and d.NAME = l_To_Mobile_Picker
--and d.SOURCE_LANG = 'US'
and b.document_id = c.document_id
and f.media_id = c.media_id;
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 = to_char(k_trx_source_line_id) --Performance bug#9743038
and a.DOCUMENT_ID = b.document_id
and b.datatype_id = 2 -- long text
and b.category_id = d.category_id
/*Fixed for bug#8347410
When query fnd_document_categories_vl use of user_name should not
done since it is translated value. Instead of column 'NAME'
should be used which will not be translated and
unique with language_code
*/
and d.NAME = l_To_Mobile_Picker
--and d.SOURCE_LANG = 'US'
and b.document_id = c.document_id
and f.media_id = c.media_id;