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_ALL2_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(150)
INVOICE_CATEGORY	VARCHAR2	(150)
PRINT_DATE	DATE
IMPORT_DOC_DATE	DATE
TYPE_OF_TRANSACTION	VARCHAR2	(150)
CORRECTION_YEAR	VARCHAR2	(150)
CORRECTION_PERIOD	VARCHAR2	(150)
TRANSACTION_DEADLINE	VARCHAR2	(150)
CHECK_VAT_AMOUNT_PAID	VARCHAR2	(150)
REFERENCE_GROUP	VARCHAR2	(150)
TAX_DATE	DATE
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	VARCHAR2	(150)
TAX_INCLUSIVE_WITH_NOTE	VARCHAR2	(150)
CAI_NUMBER	NUMBER
CAI_DUE_DATE	DATE
DESTINATION_CODE	VARCHAR2	(150)
COLLECTION_DOCUMENT_ASSOC	VARCHAR2	(150)
SERIES	VARCHAR2	(150)
CLASS	VARCHAR2	(150)
CONSOLIDATED_INVOICE	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(1660)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      INVOICE_CATEGORY
,      PRINT_DATE
,      IMPORT_DOC_DATE
,      TYPE_OF_TRANSACTION
,      CORRECTION_YEAR
,      CORRECTION_PERIOD
,      TRANSACTION_DEADLINE
,      CHECK_VAT_AMOUNT_PAID
,      REFERENCE_GROUP
,      TAX_DATE
,      LEGAL_TRANSACTION_CATEGORY
,      TRANSACTION_LETTER
,      TAX_AUTHORITY_TRANSACTION_TYPE
,      CUSTOMS_CODE
,      CUSTOMS_ISSUE_DATE
,      CUSTOMS_ISSUE_NUMBER
,      TAX_INCLUSIVE_WITH_NOTE
,      CAI_NUMBER
,      CAI_DUE_DATE
,      DESTINATION_CODE
,      COLLECTION_DOCUMENT_ASSOC
,      SERIES
,      CLASS
,      CONSOLIDATED_INVOICE
,      CONCATENATED_SEGMENTS
FROM APPS.AP_INVOICES_ALL2_DFV;

Dependencies

[top of page]

APPS.AP_INVOICES_ALL2_DFV references the following:

APPS: AP_INVOICES_ALL; FND_NUMBER - show dependent code

APPS.AP_INVOICES_ALL2_DFV is not referenced by any database object