You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Employee Expense Attachment

edited May 6, 2025 8:10AM in Expenses

I need to get the attachment from the header in the Expense Report. I am only getting the attachments from the Expense Items. Am I missing a table or join on this?

here's the query i used:
select
EE.EXPENSE_ID,
EER.EXPENSE_REPORT_NUM,
EE.EXPENSE_REPORT_ID as ee_EXPENSE_REPORT_ID,
EER.EXPENSE_REPORT_ID as eer_EXPENSE_REPORT_ID,
TO_CHAR(a.last_update_date, 'YYYY-MM-DD') as LAST_UPDATE_DATE,
c.URL,
c.dm_version_number,
d.datatype_code,
a.pk1_value,
'EXM_EXPENSES' TBL_NAME,
'EXM_EXPENSES' ENTITY_NAME,
NVL(c.FILE_NAME, c.TITLE) as FILE_NAME,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!