View: APBV_CREDIT_CARD_TRXNS

Product:	AP - Payables
Description:	Based on AP_CREDIT_CARD_TRXNS_ALL, this business view contains credit card transaction data.
Implementation/DBA Data:	APPS.APBV_CREDIT_CARD_TRXNS

View Text

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

Columns