Home » SQL & PL/SQL » SQL & PL/SQL » i need help due_date query
i need help due_date query [message #263221] Wed, 29 August 2007 07:31 Go to next message
seenujanu
Messages: 53
Registered: August 2006
Location: chennai
Member
Hi friends,

i need help the query

i had a table with column names and table name is po_transcations_company and transcation_id , company_id , company_name, bill_to, site_to, currency, due_date and who columns, AUTHORIZATION_STATUS

AUTHORIZATION_STATUS with data approved, rejected ,inprogress,requires for reapproval

i need the query for not reported by due date
means the payment doesnt do after the due date those records i need from the po_transcations_company

thanks in advance

regards

seenu

[mod-edit] removed illiterate IM words.

[Updated on: Wed, 29 August 2007 07:39] by Moderator

Report message to a moderator

Re: i need help abt due_date query [message #263223 is a reply to message #263221] Wed, 29 August 2007 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I really don't understand what you want.

Regards
Michel
Re: i need help due_date query [message #263226 is a reply to message #263221] Wed, 29 August 2007 07:42 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
select * from po_transcations_company
where nvl(due_date,to_date('09/02/2007','mm/dd/yyyy')) > to_date('09/01/2007','mm/dd/yyyy');

Re: i need help due_date query [message #263237 is a reply to message #263221] Wed, 29 August 2007 08:26 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Please provide some sample data and your require output
Re: i need help due_date query [message #263591 is a reply to message #263221] Thu, 30 August 2007 08:19 Go to previous messageGo to next message
seenujanu
Messages: 53
Registered: August 2006
Location: chennai
Member

Hi Friends\Seniors,

This is the Table with Data....
COMPANY_ID  COMPANY	YEAR	DUE_DATE	       STATUS	CURRENCY_CODE	CREATE_DATE	       LAST_UPDATE_DATE	LAST_UPDATED_BY		
10001	Lanscer ltd	2005	01.11.2005 16:06:25	Scheduled	USD	08.01.2005 16:06:00	07.12.2006 10:07:17	1005150
10002	Wipro ltd	2006	01.06.2006 00:00:00	Rejected	USD	08.02.2006 16:06:25	08.11.2006 16:41:44	1005150
10003	Sector Ltd	2006	01.10.2006 16:06:25	Approved	INR	01.01.2006 16:40:22	09.11.2006 11:04:19	1005151
10004	Creative ltd	2007	20.12.2007 00:00:00	Approved	USD	21.01.2007 16:27:06	21.04.2005 16:27:06	-1
10005	Simpsons ltd	2007	01.07.2007 00:00:00	Scheduled	USD	21.01.2007 16:27:06	21.04.2007 16:27:06	-1
10005	Signs ltd	2007	01.12.2007 00:00:00	Scheduled	USD	21.01.2007 16:27:06	21.04.2007 16:27:06	-1

and i need the records of the Due Dates based on the Year 

Thanks in Advance

Regards

Seenu
Re: i need help due_date query [message #263592 is a reply to message #263591] Thu, 30 August 2007 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i need the records of the Due Dates based on the Year

What does this mean? Try to explain us this as if you explain it to your mother.

In addition, post create table and insert statements in order to allow us to test our solution and post the result you want with this test case.

Regards
Michel
Re: i need help due_date query [message #263601 is a reply to message #263591] Thu, 30 August 2007 08:39 Go to previous message
lenin_babu55
Messages: 12
Registered: August 2007
Junior Member
select due_date from <tablename> where year=&year;

--------this gives the due_date regarding to that year

select year,due_date from <tablename> group by year,due_date;

i am not getting question clearly ............

but i try up to my knowledge

better to post it clearly

[mod-edit] removed illiterate IM speak.

[Updated on: Thu, 30 August 2007 13:02] by Moderator

Report message to a moderator

Previous Topic: Alter Materialized View on prebuilt table
Next Topic: inserting data between records
Goto Forum:
  


Current Time: Sat Dec 10 20:44:47 CST 2016

Total time taken to generate the page: 0.14039 seconds