VIEW: APPS.APBV_AP_INVOICE_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT TO_NUMBER(NULL) , INV.DESCRIPTION , TO_NUMBER(NULL) , INV.FINAL_MATCH_FLAG , INV.INCOME_TAX_REGION , TO_NUMBER(NULL) , INV.MATCH_STATUS_FLAG , INV.QUANTITY_INVOICED , INV.TYPE_1099 , INV.UNIT_PRICE , INV.ENCUMBERED_FLAG , INV.STAT_AMOUNT , INV.PA_ADDITION_FLAG , INV.POSTED_AMOUNT , INV.POSTED_BASE_AMOUNT , INV.ACCOUNTING_DATE , INV.PREPAY_AMOUNT_REMAINING , INV.QUANTITY_VARIANCE , INV.BASE_QUANTITY_VARIANCE , INV.AWT_FLAG , INV.AWT_GROSS_AMOUNT , 'Obsolete' , INV.POSTED_FLAG , INV.ASSETS_ADDITION_FLAG , INV.ASSETS_TRACKING_FLAG , '_KF:SQLGL:GL#:GCC3' , INV.AMOUNT , INV.BASE_AMOUNT , INV.INVOICE_ID , INV.INVOICE_LINE_NUMBER , INV.DISTRIBUTION_LINE_NUMBER , INV.CREATION_DATE , INV.CREATED_BY , INV.LAST_UPDATE_DATE , INV.LAST_UPDATED_BY FROM AP_INVOICE_DISTRIBUTIONS INV, GL_CODE_COMBINATIONS GCC3 WHERE INV. DIST_CODE_COMBINATION_ID = GCC3.CODE_COMBINATION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT TO_NUMBER(NULL)
, INV.DESCRIPTION
, TO_NUMBER(NULL)
, INV.FINAL_MATCH_FLAG
, INV.INCOME_TAX_REGION
, TO_NUMBER(NULL)
, INV.MATCH_STATUS_FLAG
, INV.QUANTITY_INVOICED
, INV.TYPE_1099
, INV.UNIT_PRICE
, INV.ENCUMBERED_FLAG
, INV.STAT_AMOUNT
, INV.PA_ADDITION_FLAG
, INV.POSTED_AMOUNT
, INV.POSTED_BASE_AMOUNT
, INV.ACCOUNTING_DATE
, INV.PREPAY_AMOUNT_REMAINING
, INV.QUANTITY_VARIANCE
, INV.BASE_QUANTITY_VARIANCE
, INV.AWT_FLAG
, INV.AWT_GROSS_AMOUNT
, 'OBSOLETE'
, INV.POSTED_FLAG
, INV.ASSETS_ADDITION_FLAG
, INV.ASSETS_TRACKING_FLAG
, '_KF:SQLGL:GL#:GCC3'
, INV.AMOUNT
, INV.BASE_AMOUNT
, INV.INVOICE_ID
, INV.INVOICE_LINE_NUMBER
, INV.DISTRIBUTION_LINE_NUMBER
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
FROM AP_INVOICE_DISTRIBUTIONS INV
, GL_CODE_COMBINATIONS GCC3
WHERE INV. DIST_CODE_COMBINATION_ID = GCC3.CODE_COMBINATION_ID WITH READ ONLY