Home » Applications » Oracle Fusion Apps & E-Business Suite » Query change from 11i to R12 (2 threads merged by bb)
Query change from 11i to R12 (2 threads merged by bb) [message #525082] Wed, 28 September 2011 19:42 Go to next message
hkotinad
Messages: 2
Registered: September 2011
Location: USA
Junior Member
Hi,

Please help me out from the below query.....
In 11i we are using the below Query.

SELECT a.AE_HEADER_ID,a.AE_LINE_NUMBER,
a.AE_LINE_ID, a.AE_LINE_TYPE_CODE,a.CODE_COMBINATION_ID,
a.CURRENCY_CODE,a.ENTERED_DR,a.ENTERED_CR,a.ACCOUNTED_DR,a.ACCOUNTED_CR,a.SOURCE_TABLE,
a.SOURCE_ID,a.LAST_UPDATE_DATE FROM
AP_AE_LINES_ALL a,
AP_AE_LINES_Local_table e, ap_invoice_distributions d
WHERE a.source_table = 'AP_INVOICE_DISTRIBUTIONS'
AND a.source_id = d.invoice_distribution_id AND
a.last_update_date -(sysdate - 10) > 0
AND a.AE_LINE_ID = e.AE_LINE_ID(+)

I need to change this query related to R12 changes.

Please help me whether i need to use xla_ae_lines table from R12. if yes there are AE_LINE_ID, AE_LINE_TYPE_CODE columns are not there in xla_ae_lines table. Pls let me know where to refer the AE_LINE_ID, AE_LINE_TYPE_CODE columns in R 12.
Re: Query change from 11i to R12 [message #525083 is a reply to message #525082] Wed, 28 September 2011 19:50 Go to previous messageGo to next message
BlackSwan
Messages: 22781
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Query change from 11i to R12 [message #525094 is a reply to message #525083] Thu, 29 September 2011 00:43 Go to previous messageGo to next message
Littlefoot
Messages: 19603
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"R12" - does it indicate Oracle Apps.? If so, perhaps we should move this topic into that forum as people who use it (Oracle Apps., I mean) might know better.
Re: Query change from 11i to R12 [message #525169 is a reply to message #525094] Thu, 29 September 2011 17:15 Go to previous messageGo to next message
hkotinad
Messages: 2
Registered: September 2011
Location: USA
Junior Member
Please redirect to correct Group. If wrongly posted in other group.
Re: Query change from 11i to R12 [message #525396 is a reply to message #525169] Sun, 02 October 2011 06:40 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is AP_AE_LINES_Local_table your custom table?
Other tables will have information only for 11i upgraded data.

In R12, the accounting data is stored in XLA tables. You may check the link.

As you are new to this forum, please read Oracle Applications Forum Guide.

By
Vamsi
Previous Topic: [Quality] Can we move Collection plans and values from one instance to another ?
Next Topic: GME_INVENTORY_TXNS_GTMP - global temporary table do módulo OPM
Goto Forum:
  


Current Time: Tue Sep 16 19:17:55 CDT 2014

Total time taken to generate the page: 0.12118 seconds