Query to get employee details who are not submitted the iExpense details for approval

Query to get employee details who are not submitted the iExpense details for approval

 

Introduction

This post is about to get employee details who are not submitted the iExpense details for approval query.

 

SELECT ppx.employee_number,

ppx.full_name,

ppx.email_address,

acct.transaction_amount,

acct.transaction_date,

acct.billed_date,

TRUNC(sysdate – NVL(acct.POSTED_DATE,acct.BILLED_DATE))                            AS Age_of_Txn,

AP_WEB_DB_CCARD_PKG.GetLocation(acct.merchant_city , acct.merchant_province_state) AS LOCATION,

acct.REPORT_HEADER_ID

FROM AP_CREDIT_CARD_TRXNS_ALL acct,

ap_cards_all acc,

per_people_x ppx

WHERE acct.CARD_ID        =acc.CARD_ID

AND acct.card_program_id  = acc.card_program_id

AND acc.EMPLOYEE_ID       =ppx.PERSON_ID

AND acc.org_id            = acct.org_id

–and  acct.REPORT_HEADER_ID =1070648

and  acct.REPORT_HEADER_ID is null

AND acct.org_id               =  p_organization_id

 

Summary

This post Is described about employee get details who are not submitted the iExpense details for approval query.

 

Know more about post :- Doyen.ebiz@gmail.com