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.

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

VIEW: APPS.RA_CUSTOMER_TRX_ALL3_DFV

Object Details

Object Name:	RA_CUSTOMER_TRX_ALL3_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
EXPORT_CERTIFICATE_NUMBER	VARCHAR2	(150)
EXPORT_NAME	VARCHAR2	(150)
EXPORT_METHOD	VARCHAR2	(150)
EXPORT_TYPE	VARCHAR2	(150)
EXPORT_DATE	DATE
ORIGINAL_TRANSACTION_NUMBER	VARCHAR2	(150)
LEGACY_UNIFORM_INVOICE	VARCHAR2	(150)
TAX_DATE	DATE
TRANSACTION_DEADLINE	VARCHAR2	(150)
TRANSACTION_DATE	DATE
TRANSMISSION_OF_PROPERTY	VARCHAR2	(150)
YEAR_OF_AMTS_RECEIVED_IN_CASH	VARCHAR2	(150)
PROPERTY_LOCATION	VARCHAR2	(150)
CORRECTION_YEAR	VARCHAR2	(150)
CORRECTION_PERIOD	VARCHAR2	(150)
INVOICE_TYPE	VARCHAR2	(150)
REFERENCE_GROUP	VARCHAR2	(150)
BANK_ACCOUNT_NUMBER	VARCHAR2	(150)
COPY_STATUS	VARCHAR2	(150)
ORIGINAL_TRANSACTION_TYPE_ID	VARCHAR2	(150)
CAI_NUMBER	NUMBER
CAI_DUE_DATE	DATE
NUMERIC_BAR_CODE	VARCHAR2	(150)
INTEREST_TYPE	VARCHAR2	(150)
INTEREST_RATE_AMT	NUMBER
INTEREST_PERIOD	NUMBER
INTEREST_FORMULA	VARCHAR2	(150)
GRACE_DAYS	NUMBER
PENALTY_TYPE	VARCHAR2	(150)
PENALTY_RATE_AMT	NUMBER
ISSUE_DATE	DATE
FREIGHT_ACC_EXP	NUMBER
INSURANCE_ACC_EXP	NUMBER
OTHER_ACC_EXP	NUMBER
LICENSE_PLATE	VARCHAR2	(150)
VOLUME_QUANTITY	NUMBER
VOLUME_TYPE	VARCHAR2	(150)
VOLUME_NUMBER	VARCHAR2	(150)
TOTAL_GR_WEIGHT	NUMBER
TOTAL_NT_WEIGHT	NUMBER
ISS_DATE	VARCHAR2	(150)
ORIGINAL_TRANSACTION_TYPE	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(2748)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      EXPORT_CERTIFICATE_NUMBER
,      EXPORT_NAME
,      EXPORT_METHOD
,      EXPORT_TYPE
,      EXPORT_DATE
,      ORIGINAL_TRANSACTION_NUMBER
,      LEGACY_UNIFORM_INVOICE
,      TAX_DATE
,      TRANSACTION_DEADLINE
,      TRANSACTION_DATE
,      TRANSMISSION_OF_PROPERTY
,      YEAR_OF_AMTS_RECEIVED_IN_CASH
,      PROPERTY_LOCATION
,      CORRECTION_YEAR
,      CORRECTION_PERIOD
,      INVOICE_TYPE
,      REFERENCE_GROUP
,      BANK_ACCOUNT_NUMBER
,      COPY_STATUS
,      ORIGINAL_TRANSACTION_TYPE_ID
,      CAI_NUMBER
,      CAI_DUE_DATE
,      NUMERIC_BAR_CODE
,      INTEREST_TYPE
,      INTEREST_RATE_AMT
,      INTEREST_PERIOD
,      INTEREST_FORMULA
,      GRACE_DAYS
,      PENALTY_TYPE
,      PENALTY_RATE_AMT
,      ISSUE_DATE
,      FREIGHT_ACC_EXP
,      INSURANCE_ACC_EXP
,      OTHER_ACC_EXP
,      LICENSE_PLATE
,      VOLUME_QUANTITY
,      VOLUME_TYPE
,      VOLUME_NUMBER
,      TOTAL_GR_WEIGHT
,      TOTAL_NT_WEIGHT
,      ISS_DATE
,      ORIGINAL_TRANSACTION_TYPE
,      CONCATENATED_SEGMENTS
FROM APPS.RA_CUSTOMER_TRX_ALL3_DFV;

Dependencies

[top of page]

APPS.RA_CUSTOMER_TRX_ALL3_DFV references the following:

APPS: FND_NUMBER - show dependent code; RA_CUSTOMER_TRX_ALL

APPS.RA_CUSTOMER_TRX_ALL3_DFV is not referenced by any database object