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.AP_INVOICES_INTERFACE1_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(150)
SUPPLIER_EXCHANGE_RATE	NUMBER
WINE_CIGARETTE	VARCHAR2	(150)
DEDUCTIBLE_TYPE	VARCHAR2	(150)
PRINT_DATE	DATE
IMPORT_DOC_DATE	DATE
CORRECTION_YEAR	VARCHAR2	(150)
CORRECTION_PERIOD	VARCHAR2	(150)
CHECK_VAT_AMOUNT_PAID	VARCHAR2	(150)
LEGAL_TRANSACTION_CATEGORY	VARCHAR2	(150)
TRANSACTION_LETTER	VARCHAR2	(150)
TAX_AUTHORITY_TRANSACTION_TYPE	VARCHAR2	(150)
CUSTOMS_CODE	VARCHAR2	(150)
CUSTOMS_ISSUE_DATE	DATE
CUSTOMS_ISSUE_NUMBER	NUMBER
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
COLLECTION_DOCUMENT_ASSOC	VARCHAR2	(150)
SERIES	VARCHAR2	(150)
CLASS	VARCHAR2	(150)
DOCUMENT_TYPE	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(1207)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      SUPPLIER_EXCHANGE_RATE
,      WINE_CIGARETTE
,      DEDUCTIBLE_TYPE
,      PRINT_DATE
,      IMPORT_DOC_DATE
,      CORRECTION_YEAR
,      CORRECTION_PERIOD
,      CHECK_VAT_AMOUNT_PAID
,      LEGAL_TRANSACTION_CATEGORY
,      TRANSACTION_LETTER
,      TAX_AUTHORITY_TRANSACTION_TYPE
,      CUSTOMS_CODE
,      CUSTOMS_ISSUE_DATE
,      CUSTOMS_ISSUE_NUMBER
,      GLOBAL_ATTRIBUTE17
,      COLLECTION_DOCUMENT_ASSOC
,      SERIES
,      CLASS
,      DOCUMENT_TYPE
,      CONCATENATED_SEGMENTS
FROM APPS.AP_INVOICES_INTERFACE1_DFV;

Dependencies

[top of page]

APPS.AP_INVOICES_INTERFACE1_DFV references the following:

APPS: AP_INVOICES_INTERFACE; FND_NUMBER - show dependent code

APPS.AP_INVOICES_INTERFACE1_DFV is not referenced by any database object