Procurement - EBS (MOSC)

MOSC Banner

My customer would like to see purchase order number(s) added to the query/report below...help needed

edited Feb 11, 2014 2:21PM in Procurement - EBS (MOSC) 2 commentsAnswered

My customer would like to see purchase order number(s) added to this report.   I'm using SQL Developer currently to create ad-hoc reports and I'm not familiar enough with the EBS data model yet to know exactly where to pull the info in from.   Help!

select /*csv*/ aps.vendor_name,

aca.check_number,

aca.amount check_total_amount,

aca.check_date,

aca.currency_code check_currency,

aia.invoice_amount,

aia.invoice_num,

aia.invoice_date,

glcc.segment1||'.'||glcc.segment2||'.'||glcc.segment3||'.'||glcc.segment4 gl_account

from ap.ap_checks_all aca,

ap.ap_invoice_payments_all aipa,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center