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_LINES_ALL4_DFV

Object Details

Object Name:	RA_CUSTOMER_TRX_LINES_ALL4_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_NUMBER	NUMBER
EXPORT_DATE	DATE
ADJUSTMENT_INVOICE_FLAG	VARCHAR2	(150)
ADJUSTMENT_INVOICE_FLAG_DUMMY	VARCHAR2	(150)
ORIGINAL_INVOICE_NUMBER	VARCHAR2	(150)
CONTRACT_IDENTIFICATION	VARCHAR2	(150)
BELOW_THRESHOLD_REPORTING_FLAG	VARCHAR2	(150)
REPORTING_EXCLUSION_FLAG	VARCHAR2	(150)
PAYMENT_MODE	VARCHAR2	(150)
SOURCE_TRANSACTION_NUMBER	VARCHAR2	(150)
SOURCE_LINE_NUMBER	VARCHAR2	(150)
LEGAL_JUST_MESSAGE1	VARCHAR2	(150)
LEGAL_JUST_MESSAGE2	VARCHAR2	(150)
LEGAL_JUST_MESSAGE3	VARCHAR2	(150)
TAX_BASE_AMOUNT	NUMBER
TAX_BASE_RATE	NUMBER
CHARGED_TAX_AMOUNT	VARCHAR2	(150)
CALCULATED_TAX_AMOUNT	VARCHAR2	(150)
OPERATION_FISC_CODE	VARCHAR2	(150)
ITEM_ORIGIN	VARCHAR2	(150)
ITEM_FISCAL_TYPE	VARCHAR2	(150)
FEDERAL_TRIB_SITUATION	VARCHAR2	(150)
STATE_TRIB_SITUATION	VARCHAR2	(150)
ITEM_ORG	VARCHAR2	(150)
ITEM_FISC	VARCHAR2	(150)
FED_TRIB	VARCHAR2	(150)
STAT_TRIB	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(2446)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      EXPORT_NUMBER
,      EXPORT_DATE
,      ADJUSTMENT_INVOICE_FLAG
,      ADJUSTMENT_INVOICE_FLAG_DUMMY
,      ORIGINAL_INVOICE_NUMBER
,      CONTRACT_IDENTIFICATION
,      BELOW_THRESHOLD_REPORTING_FLAG
,      REPORTING_EXCLUSION_FLAG
,      PAYMENT_MODE
,      SOURCE_TRANSACTION_NUMBER
,      SOURCE_LINE_NUMBER
,      LEGAL_JUST_MESSAGE1
,      LEGAL_JUST_MESSAGE2
,      LEGAL_JUST_MESSAGE3
,      TAX_BASE_AMOUNT
,      TAX_BASE_RATE
,      CHARGED_TAX_AMOUNT
,      CALCULATED_TAX_AMOUNT
,      OPERATION_FISC_CODE
,      ITEM_ORIGIN
,      ITEM_FISCAL_TYPE
,      FEDERAL_TRIB_SITUATION
,      STATE_TRIB_SITUATION
,      ITEM_ORG
,      ITEM_FISC
,      FED_TRIB
,      STAT_TRIB
,      CONCATENATED_SEGMENTS
FROM APPS.RA_CUSTOMER_TRX_LINES_ALL4_DFV;

Dependencies

[top of page]

APPS.RA_CUSTOMER_TRX_LINES_ALL4_DFV references the following:

APPS: FND_NUMBER - show dependent code; RA_CUSTOMER_TRX_LINES_ALL

APPS.RA_CUSTOMER_TRX_LINES_ALL4_DFV is not referenced by any database object