eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.APBV_CREDIT_CARD_TRXNS

Source

View Text - Preformatted


SELECT ACCTA.CARD_ID , ACCTA.TRX_ID , ACCTA.VALIDATE_CODE , ACCTA.CARD_PROGRAM_ID , ACCTA.EXPENSED_AMOUNT , ACCTA.REFERENCE_NUMBER , ACCTA.TRANSACTION_TYPE , ACCTA.TRANSACTION_DATE , ACCTA.TRANSACTION_AMOUNT , ACCTA.DEBIT_FLAG , ACCTA.BILLED_DATE , ACCTA.BILLED_AMOUNT , ACCTA.BILLED_DECIMAL , ACCTA.BILLED_CURRENCY_CODE , ACCTA.POSTED_DATE , ACCTA.POSTED_AMOUNT , ACCTA.POSTED_DECIMAL , ACCTA.POSTED_CURRENCY_CODE , ACCTA.CURRENCY_CONVERSION_EXPONENT , ACCTA.CURRENCY_CONVERSION_RATE , ACCTA.MIS_INDUSTRY_CODE , ACCTA.SIC_CODE , ACCTA.MERCHANT_TAX_ID , ACCTA.MERCHANT_REFERENCE , ACCTA.MERCHANT_NAME1 , ACCTA.MERCHANT_NAME2 , ACCTA.MERCHANT_ADDRESS1 , ACCTA.MERCHANT_ADDRESS2 , ACCTA.MERCHANT_ADDRESS3 , ACCTA.MERCHANT_ADDRESS4 , ACCTA.MERCHANT_CITY , ACCTA.MERCHANT_PROVINCE_STATE , ACCTA.MERCHANT_POSTAL_CODE , ACCTA.MERCHANT_COUNTRY , ACCTA.TOTAL_TAX , ACCTA.LOCAL_TAX , ACCTA.NATIONAL_TAX , ACCTA.OTHER_TAX , ACCTA.ORG_ID , ACCTA.LAST_UPDATE_DATE , ACCTA.LAST_UPDATED_BY , ACCTA.CREATION_DATE , ACCTA.CREATED_BY , ACCTA.FOLIO_TYPE , ACCTA.ATM_CASH_ADVANCE , ACCTA.ATM_TRANSACTION_DATE , ACCTA.ATM_FEE_AMOUNT , ACCTA.ATM_TYPE , ACCTA.ATM_ID , ACCTA.ATM_NETWORK_ID , ACCTA.RESTAURANT_FOOD_AMOUNT , ACCTA.RESTAURANT_BEVERAGE_AMOUNT , ACCTA.RESTAURANT_TIP_AMOUNT , ACCTA.CAR_RENTAL_DATE , ACCTA.CAR_RETURN_DATE , ACCTA.CAR_RENTAL_LOCATION , ACCTA.CAR_RENTAL_STATE , ACCTA.CAR_RETURN_LOCATION , ACCTA.CAR_RETURN_STATE , ACCTA.CAR_RENTER_NAME , ACCTA.CAR_RENTAL_DAYS , ACCTA.CAR_RENTAL_AGREEMENT_NUMBER , ACCTA.CAR_CLASS , ACCTA.CAR_TOTAL_MILEAGE , ACCTA.CAR_GAS_AMOUNT , ACCTA.CAR_INSURANCE_AMOUNT , ACCTA.CAR_MILEAGE_AMOUNT , ACCTA.CAR_DAILY_RATE , ACCTA.HOTEL_ARRIVAL_DATE , ACCTA.HOTEL_DEPART_DATE , ACCTA.HOTEL_CHARGE_DESC , ACCTA.HOTEL_GUEST_NAME , ACCTA.HOTEL_STAY_DURATION , ACCTA.HOTEL_ROOM_RATE , ACCTA.HOTEL_NO_SHOW_FLAG , ACCTA.HOTEL_ROOM_AMOUNT , ACCTA.HOTEL_TELEPHONE_AMOUNT , ACCTA.HOTEL_ROOM_TAX , ACCTA.HOTEL_BAR_AMOUNT , ACCTA.HOTEL_MOVIE_AMOUNT , ACCTA.HOTEL_GIFT_SHOP_AMOUNT , ACCTA.HOTEL_LAUNDRY_AMOUNT , ACCTA.HOTEL_HEALTH_AMOUNT , ACCTA.HOTEL_RESTAURANT_AMOUNT , ACCTA.HOTEL_BUSINESS_AMOUNT , ACCTA.HOTEL_PARKING_AMOUNT , ACCTA.HOTEL_ROOM_SERVICE_AMOUNT , ACCTA.HOTEL_TIP_AMOUNT , ACCTA.HOTEL_MISC_AMOUNT , ACCTA.HOTEL_CITY , ACCTA.HOTEL_STATE , ACCTA.HOTEL_FOLIO_NUMBER , ACCTA.HOTEL_ROOM_TYPE , ACCTA.AIR_DEPARTURE_DATE , ACCTA.AIR_DEPARTURE_CITY , ACCTA.AIR_ROUTING , ACCTA.AIR_ARRIVAL_CITY , ACCTA.AIR_STOPOVER_FLAG , ACCTA.AIR_BASE_FARE_AMOUNT , ACCTA.AIR_FARE_BASIS_CODE , ACCTA.AIR_SERVICE_CLASS , ACCTA.AIR_CARRIER_ABBREVIATION , ACCTA.AIR_CARRIER_CODE , ACCTA.AIR_TICKET_ISSUER , ACCTA.AIR_ISSUER_CITY , ACCTA.AIR_PASSENGER_NAME , ACCTA.AIR_REFUND_TICKET_NUMBER , ACCTA.AIR_EXCHANGED_TICKET_NUMBER , ACCTA.AIR_AGENCY_NUMBER , ACCTA.AIR_TICKET_NUMBER , ACCTA.FINANCIAL_CATEGORY , ACCTA.PAYMENT_FLAG , ACCTA.RECORD_TYPE , ACCTA.MERCHANT_ACTIVITY , ACCTA.CATEGORY , ACCTA.REPORT_HEADER_ID , ACCTA.EXPENSE_STATUS , ACCTA.COMPANY_PREPAID_INVOICE_ID , ACCTA.INACTIVE_EMP_WF_ITEM_KEY , ACCTA.LOCATION_ID , ACCTA.REQUEST_ID , ACCTA.MERCHANT_COUNTRY_CODE , ACCTA.DISPUTE_DATE , ACCTA.PAYMENT_DUE_FROM_CODE , ACCTA.TRX_AVAILABLE_DATE , ACCTA.CARD_ACCEPTOR_ID , ACCTA.TRXN_DETAIL_FLAG , DECODE(ACCTA.CATEGORY, NULL, 'UNUSED', 'MATCHED','RESOLVED_DISPUTES', 'CREDIT','RESOLVED_DISPUTES', 'DISPUTED','DISPUTED', DECODE(ACCTA.REPORT_HEADER_ID, NULL, 'UNUSED', DECODE(ACCTA.billed_amount - nvl(ACCTA.expensed_amount,ACCTA.billed_amount), 0, NVL(ACCTA.CATEGORY,'UNUSED'), 'BUSINESS_AND_PERSONAL'))) FROM AP_CREDIT_CARD_TRXNS_ALL ACCTA WHERE '_SEC:ACCTA.ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT ACCTA.CARD_ID
, ACCTA.TRX_ID
, ACCTA.VALIDATE_CODE
, ACCTA.CARD_PROGRAM_ID
, ACCTA.EXPENSED_AMOUNT
, ACCTA.REFERENCE_NUMBER
, ACCTA.TRANSACTION_TYPE
, ACCTA.TRANSACTION_DATE
, ACCTA.TRANSACTION_AMOUNT
, ACCTA.DEBIT_FLAG
, ACCTA.BILLED_DATE
, ACCTA.BILLED_AMOUNT
, ACCTA.BILLED_DECIMAL
, ACCTA.BILLED_CURRENCY_CODE
, ACCTA.POSTED_DATE
, ACCTA.POSTED_AMOUNT
, ACCTA.POSTED_DECIMAL
, ACCTA.POSTED_CURRENCY_CODE
, ACCTA.CURRENCY_CONVERSION_EXPONENT
, ACCTA.CURRENCY_CONVERSION_RATE
, ACCTA.MIS_INDUSTRY_CODE
, ACCTA.SIC_CODE
, ACCTA.MERCHANT_TAX_ID
, ACCTA.MERCHANT_REFERENCE
, ACCTA.MERCHANT_NAME1
, ACCTA.MERCHANT_NAME2
, ACCTA.MERCHANT_ADDRESS1
, ACCTA.MERCHANT_ADDRESS2
, ACCTA.MERCHANT_ADDRESS3
, ACCTA.MERCHANT_ADDRESS4
, ACCTA.MERCHANT_CITY
, ACCTA.MERCHANT_PROVINCE_STATE
, ACCTA.MERCHANT_POSTAL_CODE
, ACCTA.MERCHANT_COUNTRY
, ACCTA.TOTAL_TAX
, ACCTA.LOCAL_TAX
, ACCTA.NATIONAL_TAX
, ACCTA.OTHER_TAX
, ACCTA.ORG_ID
, ACCTA.LAST_UPDATE_DATE
, ACCTA.LAST_UPDATED_BY
, ACCTA.CREATION_DATE
, ACCTA.CREATED_BY
, ACCTA.FOLIO_TYPE
, ACCTA.ATM_CASH_ADVANCE
, ACCTA.ATM_TRANSACTION_DATE
, ACCTA.ATM_FEE_AMOUNT
, ACCTA.ATM_TYPE
, ACCTA.ATM_ID
, ACCTA.ATM_NETWORK_ID
, ACCTA.RESTAURANT_FOOD_AMOUNT
, ACCTA.RESTAURANT_BEVERAGE_AMOUNT
, ACCTA.RESTAURANT_TIP_AMOUNT
, ACCTA.CAR_RENTAL_DATE
, ACCTA.CAR_RETURN_DATE
, ACCTA.CAR_RENTAL_LOCATION
, ACCTA.CAR_RENTAL_STATE
, ACCTA.CAR_RETURN_LOCATION
, ACCTA.CAR_RETURN_STATE
, ACCTA.CAR_RENTER_NAME
, ACCTA.CAR_RENTAL_DAYS
, ACCTA.CAR_RENTAL_AGREEMENT_NUMBER
, ACCTA.CAR_CLASS
, ACCTA.CAR_TOTAL_MILEAGE
, ACCTA.CAR_GAS_AMOUNT
, ACCTA.CAR_INSURANCE_AMOUNT
, ACCTA.CAR_MILEAGE_AMOUNT
, ACCTA.CAR_DAILY_RATE
, ACCTA.HOTEL_ARRIVAL_DATE
, ACCTA.HOTEL_DEPART_DATE
, ACCTA.HOTEL_CHARGE_DESC
, ACCTA.HOTEL_GUEST_NAME
, ACCTA.HOTEL_STAY_DURATION
, ACCTA.HOTEL_ROOM_RATE
, ACCTA.HOTEL_NO_SHOW_FLAG
, ACCTA.HOTEL_ROOM_AMOUNT
, ACCTA.HOTEL_TELEPHONE_AMOUNT
, ACCTA.HOTEL_ROOM_TAX
, ACCTA.HOTEL_BAR_AMOUNT
, ACCTA.HOTEL_MOVIE_AMOUNT
, ACCTA.HOTEL_GIFT_SHOP_AMOUNT
, ACCTA.HOTEL_LAUNDRY_AMOUNT
, ACCTA.HOTEL_HEALTH_AMOUNT
, ACCTA.HOTEL_RESTAURANT_AMOUNT
, ACCTA.HOTEL_BUSINESS_AMOUNT
, ACCTA.HOTEL_PARKING_AMOUNT
, ACCTA.HOTEL_ROOM_SERVICE_AMOUNT
, ACCTA.HOTEL_TIP_AMOUNT
, ACCTA.HOTEL_MISC_AMOUNT
, ACCTA.HOTEL_CITY
, ACCTA.HOTEL_STATE
, ACCTA.HOTEL_FOLIO_NUMBER
, ACCTA.HOTEL_ROOM_TYPE
, ACCTA.AIR_DEPARTURE_DATE
, ACCTA.AIR_DEPARTURE_CITY
, ACCTA.AIR_ROUTING
, ACCTA.AIR_ARRIVAL_CITY
, ACCTA.AIR_STOPOVER_FLAG
, ACCTA.AIR_BASE_FARE_AMOUNT
, ACCTA.AIR_FARE_BASIS_CODE
, ACCTA.AIR_SERVICE_CLASS
, ACCTA.AIR_CARRIER_ABBREVIATION
, ACCTA.AIR_CARRIER_CODE
, ACCTA.AIR_TICKET_ISSUER
, ACCTA.AIR_ISSUER_CITY
, ACCTA.AIR_PASSENGER_NAME
, ACCTA.AIR_REFUND_TICKET_NUMBER
, ACCTA.AIR_EXCHANGED_TICKET_NUMBER
, ACCTA.AIR_AGENCY_NUMBER
, ACCTA.AIR_TICKET_NUMBER
, ACCTA.FINANCIAL_CATEGORY
, ACCTA.PAYMENT_FLAG
, ACCTA.RECORD_TYPE
, ACCTA.MERCHANT_ACTIVITY
, ACCTA.CATEGORY
, ACCTA.REPORT_HEADER_ID
, ACCTA.EXPENSE_STATUS
, ACCTA.COMPANY_PREPAID_INVOICE_ID
, ACCTA.INACTIVE_EMP_WF_ITEM_KEY
, ACCTA.LOCATION_ID
, ACCTA.REQUEST_ID
, ACCTA.MERCHANT_COUNTRY_CODE
, ACCTA.DISPUTE_DATE
, ACCTA.PAYMENT_DUE_FROM_CODE
, ACCTA.TRX_AVAILABLE_DATE
, ACCTA.CARD_ACCEPTOR_ID
, ACCTA.TRXN_DETAIL_FLAG
, DECODE(ACCTA.CATEGORY
, NULL
, 'UNUSED'
, 'MATCHED'
, 'RESOLVED_DISPUTES'
, 'CREDIT'
, 'RESOLVED_DISPUTES'
, 'DISPUTED'
, 'DISPUTED'
, DECODE(ACCTA.REPORT_HEADER_ID
, NULL
, 'UNUSED'
, DECODE(ACCTA.BILLED_AMOUNT - NVL(ACCTA.EXPENSED_AMOUNT
, ACCTA.BILLED_AMOUNT)
, 0
, NVL(ACCTA.CATEGORY
, 'UNUSED')
, 'BUSINESS_AND_PERSONAL')))
FROM AP_CREDIT_CARD_TRXNS_ALL ACCTA
WHERE '_SEC:ACCTA.ORG_ID' IS NOT NULL WITH READ ONLY