This discussion is archived
10 Replies Latest reply: Aug 19, 2013 1:04 AM by Chris Hunt

# using po number get year

Currently Being Moderated

Hai how get period by using po Number

Po number IT121300456

output req : 2012-13

how can i get please anybody hep me

• ###### 1. Re: using po number get year
Currently Being Moderated

Look what you've given us.  Basically nothing.

• ###### 2. Re: using po number get year
Currently Being Moderated

Without posting example data, we give solution,

With the help of the Req Output, i Coded like this, post some example data and explain the requirement .

 SELECT 20 || SUBSTR ('IT121300456', 3, 2) || '-' || SUBSTR ('IT121300456', 5, 2)

FROM   DUAL;

• ###### 3. Re: using po number get year
Currently Being Moderated

In other words, where is the year HIDDEN in the PO number?

• ###### 4. Re: using po number get year
Currently Being Moderated

thanku very much bcv

one more doubt how can get po total amount, in po headers level including tax amount ididnt found such column in po_headers_all

• ###### 5. Re: using po number get year
Currently Being Moderated

What are the column available in po table.

to find total amount

Use like this,

Select sum(po_tax_amount) from po_table;

But i can't see your table...

• ###### 6. Re: using po number get year
Currently Being Moderated

Don't post the same question in different threads:

• ###### 7. Re: using po number get year
Currently Being Moderated

To get Amount and amount including tax from po_headers table.

SELECT  po_amount as "total_amount", (po_amount + tax_amount) as "po_amount_including_tax" FROM po_headers;

Let me know if u are facing any problem...

• ###### 8. Re: using po number get year
Currently Being Moderated

there is no such column like po_amount in po_headers_all table then how can i get po total amount(including tax amount) from po_headers_all table  or else tell me how to get data from views table in R12

As we are using sql developer tool to build queries

• ###### 9. Re: using po number get year
Currently Being Moderated

You haven't told us anything that is useful to be able to help you.

• ###### 10. Re: using po number get year
Currently Being Moderated
there is no such column like po_amount in po_headers_all table

Maybe if you told us the structure of the tables you're working with, we wouldn't have to guess at them?

#### Legend

• Correct Answers - 10 points