Pulling Segment Names in query
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)