VIEW: APPS.FV_INVOICE_DTL_V

Source

View Text - Preformatted

SELECT ai.invoice_id, ai.vendor_id, ai.vendor_site_id , ai.invoice_num, ai.invoice_date, ai.invoice_type_lookup_code, ai.invoice_amount, ai.wfapproval_status, DECODE(ai.payment_status_flag,'N','Not paid','P','Partially paid','Y','Fully paid'), ap_invoices_utility_pkg.get_holds_count(ai.invoice_id), ai.pay_group_lookup_code, ail.line_number, ail.po_line_location_id, ail.amount,ail.description, ap_invoices_pkg.get_approval_status(ai.invoice_id,ai.invoice_amount,ai.payment_status_flag, ai.invoice_type_lookup_code), aid.distribution_line_number,aid.amount FROM ap_invoices_all ai,ap_invoice_lines_all ail,ap_invoice_distributions_all aid WHERE ai.invoice_id = ail.invoice_id AND ai.invoice_type_lookup_code NOT IN ('QUICKDEFAULT','QUICKMATCH') AND aid.invoice_id=ail.invoice_id AND aid.invoice_line_number = ail.line_number

View Text - HTML Formatted

SELECT AI.INVOICE_ID
, AI.VENDOR_ID
, AI.VENDOR_SITE_ID
, AI.INVOICE_NUM
, AI.INVOICE_DATE
, AI.INVOICE_TYPE_LOOKUP_CODE
, AI.INVOICE_AMOUNT
, AI.WFAPPROVAL_STATUS
, DECODE(AI.PAYMENT_STATUS_FLAG
, 'N'
, 'NOT PAID'
, 'P'
, 'PARTIALLY PAID'
, 'Y'
, 'FULLY PAID')
, AP_INVOICES_UTILITY_PKG.GET_HOLDS_COUNT(AI.INVOICE_ID)
, AI.PAY_GROUP_LOOKUP_CODE
, AIL.LINE_NUMBER
, AIL.PO_LINE_LOCATION_ID
, AIL.AMOUNT
, AIL.DESCRIPTION
, AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID
, AI.INVOICE_AMOUNT
, AI.PAYMENT_STATUS_FLAG
, AI.INVOICE_TYPE_LOOKUP_CODE)
, AID.DISTRIBUTION_LINE_NUMBER
, AID.AMOUNT
FROM AP_INVOICES_ALL AI
, AP_INVOICE_LINES_ALL AIL
, AP_INVOICE_DISTRIBUTIONS_ALL AID
WHERE AI.INVOICE_ID = AIL.INVOICE_ID
AND AI.INVOICE_TYPE_LOOKUP_CODE NOT IN ('QUICKDEFAULT'
, 'QUICKMATCH')
AND AID.INVOICE_ID=AIL.INVOICE_ID
AND AID.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER