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 Go to next message
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 Go to previous message
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
Previous Topic: dataType translation oracle to Pro*c
Next Topic: oracle reports2.5
Goto Forum:
  


Current Time: Fri Mar 29 06:19:57 CDT 2024