Home » Applications » Oracle Fusion Apps & E-Business Suite » Exploding the BOM Item in Report - Urgent
 Exploding the BOM Item in Report - Urgent [message #367223] |
Mon, 22 May 2000 22:38  |
Rajaganapathy Mohan
Messages: 5
Registered: January 2000
|
Junior Member |
|
|
Hai all,
I have a very peculiar requirement here.I have created a delivery order report and iam displaying the items associated with this delivery in the report.Now my requirement is if my item is a KIT item and then i have to explode the item in the report as follows
Item Description qty
Com1 Computer 3
---Key1 Keyboard 4
---monitor1 monitor 5
---mouse1 mouse 3
Printer1 Printer 8
Speak1 speadkers 10
This is the output required(ie) Com1 is a KIT item and it has to be exploded in the report
Anybody who has done this before....Pls help me out
Rgds,
Mohan
|
|
|
|
| Re: Exploding the BOM Item in Report - Urgent [message #367280 is a reply to message #367223] |
Tue, 14 November 2000 00:28  |
usha elizabeth
Messages: 3
Registered: November 2000
|
Junior Member |
|
|
Hi,
You could use the recursive functions which oracle
supports. The query could be as follows.
EXAMPLE
--------
select level,task_id,parent_task_id from pa_tasks
start parent_task_id = is null
connect by parent_task_id =prior task_id
* where level no. (1,2,3...) is auto generated by oracle
* parent_task_id is the root node , start clause
helps you specify where to start the hierarchy
* connect, mentions the relation in the hierarchy
(ie. the previous child is the current parent)
I think this eg. should solve your problem. I have
used this extensively in BOM
|
|
|
|
Goto Forum:
Current Time: Sun May 04 06:07:59 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
