VIEW: APPS.CE_AP_FC_EXP_REPORTS_V

Source

View Text - Preformatted

SELECT h.report_header_id, h.week_end_date, l.currency_code, l.exchange_rate, l.exchange_date, l.project_id, l.expenditure_item_date, l.org_id, l.set_of_books_id, nvl(l.amount,0), nvl(l.amount,0)*nvl(l.exchange_rate,1), decode(h.hold_lookup_code,null,'N','Y'), h.source, h.invoice_num, 'AP' || h.report_header_id from AP_EXPENSE_REPORT_HEADERS_ALL h, AP_EXPENSE_REPORT_LINES_ALL l WHERE h.report_header_id = l.report_header_id and (h.org_id = l.org_id or h.org_id IS NULL) and vouchno = 0

View Text - HTML Formatted

SELECT H.REPORT_HEADER_ID
, H.WEEK_END_DATE
, L.CURRENCY_CODE
, L.EXCHANGE_RATE
, L.EXCHANGE_DATE
, L.PROJECT_ID
, L.EXPENDITURE_ITEM_DATE
, L.ORG_ID
, L.SET_OF_BOOKS_ID
, NVL(L.AMOUNT
, 0)
, NVL(L.AMOUNT
, 0)*NVL(L.EXCHANGE_RATE
, 1)
, DECODE(H.HOLD_LOOKUP_CODE
, NULL
, 'N'
, 'Y')
, H.SOURCE
, H.INVOICE_NUM
, 'AP' || H.REPORT_HEADER_ID
FROM AP_EXPENSE_REPORT_HEADERS_ALL H
, AP_EXPENSE_REPORT_LINES_ALL L
WHERE H.REPORT_HEADER_ID = L.REPORT_HEADER_ID
AND (H.ORG_ID = L.ORG_ID OR H.ORG_ID IS NULL)
AND VOUCHNO = 0