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

     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

  • July 4, 2018 | 17 views
  • Comments