VIEW: APPS.CE_DISC_PROJECT_INV_V

Source

View Text - Preformatted

SELECT -(ce.AMOUNT * (aid.amount / ai.invoice_amount)), ce.BASE_AMOUNT * (aid.amount / ai.invoice_amount), ce.TRX_DATE, ce.CURRENCY_CODE, ce.PAYMENT_PRIORITY, ce.VENDOR_TYPE, ce.PAYGROUP, ce.ORG_ID, aid.PROJECT_ID, ce.ON_HOLD, ce.INVOICE_NUM, ce.PAYMENT_NUM, ce.REFERENCE_ID FROM CE_DISC_INVOICES_V ce, AP_INVOICE_DISTRIBUTIONS_ALL aid, AP_INVOICES_ALL ai WHERE aid.invoice_id = ce.invoice_id AND ai.invoice_id = ce.invoice_id AND aid.project_id is not null

View Text - HTML Formatted

SELECT -(CE.AMOUNT * (AID.AMOUNT / AI.INVOICE_AMOUNT))
, CE.BASE_AMOUNT * (AID.AMOUNT / AI.INVOICE_AMOUNT)
, CE.TRX_DATE
, CE.CURRENCY_CODE
, CE.PAYMENT_PRIORITY
, CE.VENDOR_TYPE
, CE.PAYGROUP
, CE.ORG_ID
, AID.PROJECT_ID
, CE.ON_HOLD
, CE.INVOICE_NUM
, CE.PAYMENT_NUM
, CE.REFERENCE_ID
FROM CE_DISC_INVOICES_V CE
, AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_INVOICES_ALL AI
WHERE AID.INVOICE_ID = CE.INVOICE_ID
AND AI.INVOICE_ID = CE.INVOICE_ID
AND AID.PROJECT_ID IS NOT NULL