FND Design Data [Home] [Help]

View: APFV_EXPENSE_REPORTS

Product: AP - Payables
Description: Business view
Implementation/DBA Data: ViewAPPS.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