Home » SQL & PL/SQL » SQL & PL/SQL » Recursive BOM
Recursive BOM [message #201574] Sun, 05 November 2006 22:43 Go to next message
rameshkumars2k3
Messages: 8
Registered: November 2006
Location: DELHI
Junior Member

Dear All,

We are using a Table name BOM with below mention structure
artno varchar2(25),
partno varchar2(25),
pieces numner(5)

This table used in mentain a Bill of metarial Information.
e.g.
artno partno pieces
1000001 2000001 3
1000001 2000002 1
1000001 2000003 1
1000002 2000001 3
1000002 2000003 4
1000002 2000004 5

means artno 1000001 is made from partno (2000001,2000002,2000003)
with its pieces. This is easy when we want to find requirement
in production of parts, But some artno is made from another artno
then how i find requirement of actual partnos in production.
e.g.
artno partno pieces
1000003 1000001 2
1000003 1000002 1
1000003 2000003 1

here partno 1000001,1000002 are also a finished goods, these are
own BOM.

Please guide me, How can solve its problem.
Re: Recursive BOM [message #201596 is a reply to message #201574] Mon, 06 November 2006 00:31 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
./fa/456/0/ for BOM. This one appears regularly in the forum.
Re: Recursive BOM [message #204592 is a reply to message #201574] Tue, 21 November 2006 06:16 Go to previous message
pravin3032
Messages: 51
Registered: November 2006
Location: eARTH
Member
i just think n think n think and then thunk!!
on what you want exactly.

could you please make it bit simple !

pravin
Previous Topic: passing a clob data to a procedure
Next Topic: DDL in Trigger ?
Goto Forum:
  


Current Time: Sat Dec 03 20:05:00 CST 2016

Total time taken to generate the page: 0.08796 seconds