VIEW: AP.AP_CC_TRX_DETAILS#

Source

View Text - Preformatted

select TRX_DETAIL_ID TRX_DETAIL_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, TRX_ID TRX_ID, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, BILLED_AMOUNT BILLED_AMOUNT, EXT_FOLIO_TYPE EXT_FOLIO_TYPE, FOLIO_TYPE FOLIO_TYPE, ITEM_SEQ_NUMBER ITEM_SEQ_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, TRANSACTION_DATE TRANSACTION_DATE, LEG_NUMBER LEG_NUMBER, DEPARTURE_DATE DEPARTURE_DATE, DEPARTURE_CITY_CODE DEPARTURE_CITY_CODE, ARRIVAL_CITY_CODE ARRIVAL_CITY_CODE, ARRIVAL_DATE ARRIVAL_DATE, CARRIER_CODE CARRIER_CODE, SERVICE_CLASS_CODE SERVICE_CLASS_CODE, FARE_BASIS_CODE FARE_BASIS_CODE, STOPOVER_CODE STOPOVER_CODE, DOMESTIC_FLAG DOMESTIC_FLAG, CONJUNCTION_TICKET_NUMBER CONJUNCTION_TICKET_NUMBER from "AP"."AP_CC_TRX_DETAILS"

View Text - HTML Formatted

SELECT TRX_DETAIL_ID TRX_DETAIL_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, TRX_ID TRX_ID
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, BILLED_AMOUNT BILLED_AMOUNT
, EXT_FOLIO_TYPE EXT_FOLIO_TYPE
, FOLIO_TYPE FOLIO_TYPE
, ITEM_SEQ_NUMBER ITEM_SEQ_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, TRANSACTION_DATE TRANSACTION_DATE
, LEG_NUMBER LEG_NUMBER
, DEPARTURE_DATE DEPARTURE_DATE
, DEPARTURE_CITY_CODE DEPARTURE_CITY_CODE
, ARRIVAL_CITY_CODE ARRIVAL_CITY_CODE
, ARRIVAL_DATE ARRIVAL_DATE
, CARRIER_CODE CARRIER_CODE
, SERVICE_CLASS_CODE SERVICE_CLASS_CODE
, FARE_BASIS_CODE FARE_BASIS_CODE
, STOPOVER_CODE STOPOVER_CODE
, DOMESTIC_FLAG DOMESTIC_FLAG
, CONJUNCTION_TICKET_NUMBER CONJUNCTION_TICKET_NUMBER
FROM "AP"."AP_CC_TRX_DETAILS"