OraFAQ Forum: SQL & PL/SQL » Running settlement of inward vs outward quantity

Home » SQL & PL/SQL » SQL & PL/SQL » Running settlement of inward vs outward quantity (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running settlement of inward vs outward quantity [message #671249]

Mon, 20 August 2018 01:23

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Hello friends,

I have some inward and outward data which i would like compare and print side by side. I do not have any relation between inward and outward, i need to distribute on the basis of quantity. Is there any function or formula to get below output.

-------------------------------------------------------------------------------------
                 Inward                  |                       Outward
-------------------------------------------------------------------------------------
INW_No	        INW_Date	Qty	 |	OUT_No	        OUT_Date	Qty
-------------------------------------------------------------------------------------
INW/1	      01/07/2018	1000	 |	OUT/1	      01/07/2018	500
				         |      OUT/2	      01/07/2018	500
-------------------------------------------------------------------------------------
INW/2	      01/07/2018	500	 |	OUT/2	      01/07/2018	250
				         |      OUT/3	      01/07/2018	250
-------------------------------------------------------------------------------------

Thank you,
Chintan

Report message to a moderator

[Message index]

		Running settlement of inward vs outward quantity By: chintan.patel on Mon, 20 August 2018 01:23
		Re: Running settlement of inward vs outward quantity By: Michel Cadot on Mon, 20 August 2018 03:12
		Re: Running settlement of inward vs outward quantity By: Bill B on Mon, 20 August 2018 05:25
		Re: Running settlement of inward vs outward quantity By: chintan.patel on Mon, 20 August 2018 06:38
		Re: Running settlement of inward vs outward quantity By: Bill B on Mon, 20 August 2018 07:18
		Re: Running settlement of inward vs outward quantity By: chintan.patel on Mon, 20 August 2018 07:32
		Re: Running settlement of inward vs outward quantity By: Bill B on Mon, 20 August 2018 07:33
		Re: Running settlement of inward vs outward quantity By: Bill B on Mon, 20 August 2018 07:38
		Re: Running settlement of inward vs outward quantity By: chintan.patel on Mon, 20 August 2018 07:46
		Re: Running settlement of inward vs outward quantity By: Michel Cadot on Mon, 20 August 2018 07:51
		Re: Running settlement of inward vs outward quantity By: Bill B on Mon, 20 August 2018 07:51
		Re: Running settlement of inward vs outward quantity By: Solomon Yakobson on Mon, 20 August 2018 18:49
		Re: Running settlement of inward vs outward quantity By: chintan.patel on Tue, 21 August 2018 06:02
		Re: Running settlement of inward vs outward quantity By: quirks on Tue, 21 August 2018 08:02

Previous Topic:	Relation between two gold
Next Topic:	consistency constraint ON store Procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 21:20:55 CDT 2024