Hi Folks,
GoodDay, Please let me know the following interview question. How to develop Supplier Invoice Report? Please a bit brief..
Thanks in Advance,
Ram..
How to develop Supplier Invoice Report..?
SELECT
I.INVOICE_DATE
, I.INVOICE_NUM
, I.TERMS_NAME
, I.PO_NUMBER
--, DECODE(I.RECEIPT_NUMBER,'UNMATCHED',NULL,I.RECEIPT_NUMBER) RECEIPT_NUMBER
, ROUND(I.ACTUAL_INVOICE_AMOUNT) ACTUAL_INVOICE_AMOUNT
, I.INVOICE_ID
FROM
AP_INVOICES_V I
, AP_PAYMENT_SCHEDULES_V PS
WHERE
I.INVOICE_ID = PS.INVOICE_ID
AND PS.AMOUNT_REMAINING != 0
AND I.VENDOR_ID = _VENDOR_ID
AND PS.DUE_DATE BETWEEN :CP_DATE AND :CP_DATE_TO
I.INVOICE_DATE
, I.INVOICE_NUM
, I.TERMS_NAME
, I.PO_NUMBER
--, DECODE(I.RECEIPT_NUMBER,'UNMATCHED',NULL,I.RECEIPT_NUMBER) RECEIPT_NUMBER
, ROUND(I.ACTUAL_INVOICE_AMOUNT) ACTUAL_INVOICE_AMOUNT
, I.INVOICE_ID
FROM
AP_INVOICES_V I
, AP_PAYMENT_SCHEDULES_V PS
WHERE
I.INVOICE_ID = PS.INVOICE_ID
AND PS.AMOUNT_REMAINING != 0
AND I.VENDOR_ID = _VENDOR_ID
AND PS.DUE_DATE BETWEEN :CP_DATE AND :CP_DATE_TO
Who is online
Users browsing this forum: No registered users and 1 guest