Solved

I need a query for categories and description from oracle

Posted on 2012-03-28
2
599 Views
Last Modified: 2012-06-27
SELECT b.concatenated_segments, c.category_set_name
, b.segment1
, b.segment2
,c.description
,b.*
FROM apps.mtl_item_categories a
, apps.mtl_categories_kfv b
, apps.mtl_category_sets_vl c
, apps.mtl_system_items_vl d
WHERE a.category_id = b.category_id
AND a.category_set_id = c.category_set_id
AND c.category_set_name = 'Purchasing'
AND a.inventory_item_id =d.inventory_item_id
AND a.organization_id = d.organization_id
and a.inventory_item_id='92967'
and a.organization_id=103

i am not getting the description
PACKAGING.PALLET.DEFAULT
po-item-category.docx
0
Comment
Question by:pardeshirahul
2 Comments
 
LVL 7

Accepted Solution

by:
Piloute earned 500 total points
ID: 37777723
hummm,

are you sure you're posting at the right place ? smells like apps to me (not database)...

P
0
 

Author Comment

by:pardeshirahul
ID: 37777965
yes this is for Oracle APplications not database
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question