Employee Expense Attachment
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,
Tagged:
0