VIEW: APPS.APFV_AP_INVOICES

Source

View Text - Preformatted

SELECT INV.INVOICE_NUM , INV.INVOICE_DATE , INV.DESCRIPTION , INV.AMOUNT_APPLICABLE_TO_DISCOUNT , INV.INVOICE_AMOUNT , INV.FREIGHT_AMOUNT , INV.BASE_AMOUNT , INV.INVOICE_RECEIVED_DATE , INV.POSTING_STATUS , INV.AWT_FLAG , INV.DOC_SEQUENCE_VALUE , INV.SOURCE , '_LA:INV.SOURCE:AP_LOOKUP_CODES:SOURCE:DESCRIPTION' , INV.INVOICE_TYPE_LOOKUP_CODE , '_LA:INV.INVOICE_TYPE_LOOKUP_CODE:AP_LOOKUP_CODES:INVOICE TYPE:DESCRIPTION' , INV.EXCLUSIVE_PAYMENT_FLAG , INV.PAY_GROUP_LOOKUP_CODE , INV.PAY_CURR_INVOICE_AMOUNT , INV.PAYMENT_CROSS_RATE , INV.PAYMENT_CROSS_RATE_TYPE , INV.PAYMENT_CROSS_RATE_DATE , INV.PAYMENT_METHOD_CODE /*changed for dbi */ , INV.PAYMENT_STATUS_FLAG , '_LA:INV.PAYMENT_STATUS_FLAG:AP_LOOKUP_CODES:INVOICE PAYMENT STATUS:DESCRIPTION' , INV.APPROVAL_DESCRIPTION , INV.TERMS_DATE , INV.TAX_AMOUNT , INV.AUTO_TAX_CALC_FLAG , INV.USSGL_TRANSACTION_CODE , INV.APPROVAL_STATUS , INV.APPROVED_AMOUNT , INV.CANCELLED_AMOUNT , INV.CANCELLED_DATE , INV.EXCHANGE_RATE , INV.EXCHANGE_RATE_TYPE , INV.EXCHANGE_DATE , INV.BATCH_ID , INV.VENDOR_ID , INV.VENDOR_SITE_ID , INV.INVOICE_CURRENCY_CODE , INV.PAYMENT_CURRENCY_CODE , INV.TERMS_ID , INV.INVOICE_ID , INV.PO_HEADER_ID , INV.PROJECT_ID , INV.TASK_ID , INV.EXPENDITURE_TYPE , INV.EXPENDITURE_ITEM_DATE , INV.PA_QUANTITY , INV.REFERENCE_1 , INV.REFERENCE_2 ,'_DF:SQLAP:AP_INVOICES:INV' ,'_DF:JG:JG_AP_INVOICES:INV' , INV.CREATION_DATE , INV.CREATED_BY , INV.LAST_UPDATE_DATE , INV.LAST_UPDATED_BY , INV.ORG_ID FROM AP_INVOICES INV WITH READ ONLY

View Text - HTML Formatted

SELECT INV.INVOICE_NUM
, INV.INVOICE_DATE
, INV.DESCRIPTION
, INV.AMOUNT_APPLICABLE_TO_DISCOUNT
, INV.INVOICE_AMOUNT
, INV.FREIGHT_AMOUNT
, INV.BASE_AMOUNT
, INV.INVOICE_RECEIVED_DATE
, INV.POSTING_STATUS
, INV.AWT_FLAG
, INV.DOC_SEQUENCE_VALUE
, INV.SOURCE
, '_LA:INV.SOURCE:AP_LOOKUP_CODES:SOURCE:DESCRIPTION'
, INV.INVOICE_TYPE_LOOKUP_CODE
, '_LA:INV.INVOICE_TYPE_LOOKUP_CODE:AP_LOOKUP_CODES:INVOICE TYPE:DESCRIPTION'
, INV.EXCLUSIVE_PAYMENT_FLAG
, INV.PAY_GROUP_LOOKUP_CODE
, INV.PAY_CURR_INVOICE_AMOUNT
, INV.PAYMENT_CROSS_RATE
, INV.PAYMENT_CROSS_RATE_TYPE
, INV.PAYMENT_CROSS_RATE_DATE
, INV.PAYMENT_METHOD_CODE /*CHANGED FOR DBI */
, INV.PAYMENT_STATUS_FLAG
, '_LA:INV.PAYMENT_STATUS_FLAG:AP_LOOKUP_CODES:INVOICE PAYMENT STATUS:DESCRIPTION'
, INV.APPROVAL_DESCRIPTION
, INV.TERMS_DATE
, INV.TAX_AMOUNT
, INV.AUTO_TAX_CALC_FLAG
, INV.USSGL_TRANSACTION_CODE
, INV.APPROVAL_STATUS
, INV.APPROVED_AMOUNT
, INV.CANCELLED_AMOUNT
, INV.CANCELLED_DATE
, INV.EXCHANGE_RATE
, INV.EXCHANGE_RATE_TYPE
, INV.EXCHANGE_DATE
, INV.BATCH_ID
, INV.VENDOR_ID
, INV.VENDOR_SITE_ID
, INV.INVOICE_CURRENCY_CODE
, INV.PAYMENT_CURRENCY_CODE
, INV.TERMS_ID
, INV.INVOICE_ID
, INV.PO_HEADER_ID
, INV.PROJECT_ID
, INV.TASK_ID
, INV.EXPENDITURE_TYPE
, INV.EXPENDITURE_ITEM_DATE
, INV.PA_QUANTITY
, INV.REFERENCE_1
, INV.REFERENCE_2
, '_DF:SQLAP:AP_INVOICES:INV'
, '_DF:JG:JG_AP_INVOICES:INV'
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
, INV.ORG_ID
FROM AP_INVOICES INV WITH READ ONLY