Payables and Cash Management - EBS (MOSC)

MOSC Banner

Pulling Segment Names in query

edited Apr 24, 2014 12:00PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

Hello,

I am building a query that joins the AP_DISTRIBUTIONS_ALL , GL_CODE_COMBINATIONS, and FND_FLEX_VALUES_VL tables (among others).  My intent is to have a view that shows payment history by vendor and applcable GL distribution with the Segement descriptions.  We use six segments that are applicable for my purpose.  For example, here are my joins:

FROM ((((AP.AP_INVOICE_DISTRIBUTIONS_ALL INNER JOIN GL_CODE_COMBINATIONS ON

      AP.AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID =

     GL_CODE_COMBINATIONS.CODE_COMBINATION_ID)

     INNER JOIN AP.AP_INVOICES_ALL ON

     AP.AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID=AP_INVOICES_ALL.INVOICE_ID)

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