VIEW: APPS.APFV_AP_INVOICE_DISTRIBUTIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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