eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: APFV_EXPENSE_REPORTS

Product:	AP - Payables
Description:	Business view
Implementation/DBA Data:	APPS.APFV_EXPENSE_REPORTS

View Text

SELECT INV.DESCRIPTION
, INV.SOURCE
, INV.INVOICE_NUM
, INV.VOUCHER_NUM
, INV.INVOICE_DATE
, NVL(INV.INVOICE_AMOUNT
, 0) TOTAL
, INV_HOLDS.HOLD_LOOKUP_CODE
, '_LA:INV_HOLDS.HOLD_LOOKUP_CODE:AP_LOOKUP_CODES:HOLD CODE:DESCRIPTION'
, ASS.SUPERVISOR_ID
, SUP.EMPLOYEE_NUMBER
, SUP.FIRST_NAME
, SUP.LAST_NAME
, SUP.FULL_NAME
, POV.EMPLOYEE_ID
, EMP.EMPLOYEE_NUMBER
, EMP.FIRST_NAME
, EMP.LAST_NAME
, POV.VENDOR_NAME
, '_DF:SQLAP:AP_INVOICES:INV'
, '_DF:JG:JG_AP_INVOICES:INV'
, INV_DIST.DISTRIBUTION_LINE_NUMBER
, INV_DIST.DESCRIPTION
, NVL(INV_DIST.AMOUNT
, 0 ) AMOUNT
, INV_DIST.RECEIPT_CURRENCY_CODE
, INV_DIST.LINE_TYPE_LOOKUP_CODE
, '_LA:INV_DIST.LINE_TYPE_LOOKUP_CODE:AP_LOOKUP_CODES:INVOICE DISTRIBUTION TYPE:DESCRIPTION'
, '_DF:SQLAP:AP_INVOICE_DISTRIBUTIONS:INV_DIST'
, '_DF:JG:JG_AP_INVOICE_DISTRIBUTIONS:INV_DIST'
, '_KF:SQLGL:GL#:EXP_GCC'
, INV_DIST.EXCHANGE_DATE
, INV_DIST.EXCHANGE_RATE
, INV_DIST.EXCHANGE_RATE_TYPE
, INV_DIST.RECEIPT_MISSING_FLAG
, INV_DIST.RECEIPT_REQUIRED_FLAG
, INV_DIST.JUSTIFICATION
, INV.VAT_CODE
, INV.ORG_ID
, INV.SET_OF_BOOKS_ID
, INV.INVOICE_ID
FROM AP_INVOICES INV
, AP_HOLDS_ALL INV_HOLDS
, GL_CODE_COMBINATIONS EXP_GCC
, PO_VENDORS POV
, PER_ALL_PEOPLE_F EMP
, PER_ALL_PEOPLE_F SUP
, PER_ALL_ASSIGNMENTS_F ASS
, AP_INVOICE_DISTRIBUTIONS_ALL INV_DIST
WHERE INV.VENDOR_ID = POV.VENDOR_ID
AND (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'STANDARD'
AND INV.SOURCE = 'CREDIT CARD'))
AND INV.INVOICE_ID = INV_DIST.INVOICE_ID
AND EXP_GCC.CODE_COMBINATION_ID = INV_DIST.DIST_CODE_COMBINATION_ID
AND INV.INVOICE_ID = INV_HOLDS.INVOICE_ID (+)
AND POV.EMPLOYEE_ID = EMP.PERSON_ID
AND ASS.PERSON_ID = EMP.PERSON_ID
AND ASS.SUPERVISOR_ID = SUP.PERSON_ID(+)
AND ASS.ASSIGNMENT_TYPE = 'E'
AND INV.INVOICE_DATE BETWEEN ASS.EFFECTIVE_START_DATE (+)
AND ASS.EFFECTIVE_END_DATE (+)
AND ASS.EFFECTIVE_START_DATE BETWEEN SUP.EFFECTIVE_START_DATE (+)
AND SUP.EFFECTIVE_END_DATE (+)
AND ASS.EFFECTIVE_START_DATE BETWEEN EMP.EFFECTIVE_START_DATE (+)
AND EMP.EFFECTIVE_END_DATE (+) WITH READ ONLY

Columns

Name
REPORT_DESCRIPTION
SOURCE
REPORT_INVOICE_NUMBER
VOUCHER_NUMBER
REPORT_WEEK_END_DATE
REPORT_TOTAL
REPORT_HOLD
"_LA:REPORT_HOLD_DESCRIPTION"
MANAGER_EMPLOYEE_ID
MANAGER_EMPLOYEE_NUMBER
MANAGER_FIRST_NAME
MANAGER_LAST_NAME
MANAGER_FULL_NAME
EMPLOYEE_ID
EMPLOYEE_NUMBER
EMPLOYEE_FIRST_NAME
EMPLOYEE_LAST_NAME
EMPLOYEE_FULL_NAME
"_DF:INV"
"_DF:INV_GLBL"
DISTRIBUTION_LINE_NUMBER
LINE_ITEM_DESCRIPTION
LINE_AMOUNT
LINE_CURRENCY_CODE
LINE_TYPE
"_LA:LINE_TYPE_DESCRIPTION"
"_DF:LINE"
"_DF:LINE_GLBL"
"_KF:ACCOUNT_NAME"
EXCHANGE_DATE
EXCHANGE_RATE
EXCHANGE_RATE_TYPE
RECEIPT_MISSING_FLAG
RECEIPT_REQUIRED_FLAG
JUSTIFICATION
LINE_VAT
ORGANIZATION_ID
SET_OF_BOOKS_ID
INVOICE_ID