DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_CC_TRX_DETAILS_ARC#

Object Details
Object Name: AP_CC_TRX_DETAILS_ARC#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ARC_REQ_ID NUMBER

ARCHIVE_DATE DATE

TRX_DETAIL_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
TRX_ID NUMBER (15) Yes
TRANSACTION_AMOUNT NUMBER

BILLED_AMOUNT NUMBER

EXT_FOLIO_TYPE VARCHAR2 (80)
FOLIO_TYPE VARCHAR2 (80)
ITEM_SEQ_NUMBER VARCHAR2 (15)
ITEM_DESCRIPTION VARCHAR2 (240)
TRANSACTION_DATE DATE

LEG_NUMBER VARCHAR2 (15)
DEPARTURE_DATE DATE

DEPARTURE_CITY_CODE VARCHAR2 (80)
ARRIVAL_CITY_CODE VARCHAR2 (80)
ARRIVAL_DATE DATE

CARRIER_CODE VARCHAR2 (30)
SERVICE_CLASS_CODE VARCHAR2 (30)
FARE_BASIS_CODE VARCHAR2 (30)
STOPOVER_CODE VARCHAR2 (30)
DOMESTIC_FLAG VARCHAR2 (1)
CONJUNCTION_TICKET_NUMBER VARCHAR2 (80)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AP.AP_CC_TRX_DETAILS_ARC# references the following:

SchemaAP
TableAP_CC_TRX_DETAILS_ARC
AP.AP_CC_TRX_DETAILS_ARC# is referenced by following:

SchemaAPPS
SynonymAP_CC_TRX_DETAILS_ARC