Person details are coming as blank in the report
Hi Team,
We have a requirement to build a query with Card program name,Transaction Amount,Transaction Date, Employee Name and Employee Number.
We used below in the query:
EXM_CARD_PROGRAMS
EXM_CREDIT_CARD_TRXNS
exm_cards
Per_all_people_f
Per_person_names_f
When we add person tables with card tables the person_id is coming as blank.
Kindly help us on to build a query for the above mentioned columns.
Thanks,
Thirumala Rao
Tagged:
0