Product: | AP - Payables |
---|---|
Description: | Business view |
Implementation/DBA Data: | APPS.APFV_AP_INVOICE_DISTRIBUTIONS |
SELECT TO_NUMBER(NULL)
, DIST.DESCRIPTION
, TO_NUMBER(NULL)
, DIST.FINAL_MATCH_FLAG
, '_LA:DIST.FINAL_MATCH_FLAG:AP_LOOKUP_CODES:FINAL MATCH CODE:DESCRIPTION'
, DIST.INCOME_TAX_REGION
, TO_NUMBER(NULL)
, DIST.MATCH_STATUS_FLAG
, DIST.DIST_MATCH_TYPE
, '_LA:DIST.DIST_MATCH_TYPE:AP_LOOKUP_CODES:MATCH_STATUS:DESCRIPTION'
, '_DF:SQLAP:AP_INVOICE_DISTRIBUTIONS:DIST'
, '_DF:JG:JG_AP_INVOICE_DISTRIBUTIONS:DIST'
, TO_NUMBER(NULL)
, DIST.QUANTITY_INVOICED
, DIST.TYPE_1099
, DIST.UNIT_PRICE
, DIST.ENCUMBERED_FLAG
, DIST.LINE_TYPE_LOOKUP_CODE
, '_LA:DIST.LINE_TYPE_LOOKUP_CODE:AP_LOOKUP_CODES:INVOICE DISTRIBUTION TYPE:DESCRIPTION'
, TO_NUMBER(NULL)
, DIST.STAT_AMOUNT
, DIST.PA_ADDITION_FLAG
, '_LA:DIST.PA_ADDITION_FLAG:PA_LOOKUPS:PA_ADDITION_FLAG:MEANING'
, DIST.POSTED_AMOUNT
, DIST.POSTED_BASE_AMOUNT
, DIST.ACCOUNTING_DATE
, DIST.PREPAY_AMOUNT_REMAINING
, DIST.QUANTITY_VARIANCE
, DIST.BASE_QUANTITY_VARIANCE
, DIST.AWT_FLAG
, DIST.AWT_GROSS_AMOUNT
, 'OBSOLETE'
, DIST.POSTED_FLAG
, DIST.ASSETS_ADDITION_FLAG
, DIST.ASSETS_TRACKING_FLAG
, DIST.DIST_CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC3'
, DIST.AMOUNT
, DIST.BASE_AMOUNT
, DIST.JUSTIFICATION
, DIST.INVOICE_ID
, DIST.INVOICE_LINE_NUMBER
, DIST.DISTRIBUTION_LINE_NUMBER
, DIST.PO_DISTRIBUTION_ID
, DIST.CREATION_DATE
, DIST.CREATED_BY
, DIST.LAST_UPDATE_DATE
, DIST.LAST_UPDATED_BY
FROM AP_INVOICE_DISTRIBUTIONS DIST
, GL_CODE_COMBINATIONS GCC3
WHERE DIST.DIST_CODE_COMBINATION_ID = GCC3.CODE_COMBINATION_ID WITH READ ONLY