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 Mandatory Comments
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)
CHECK_VAT_AMOUNT_PAID VARCHAR2 (150)
IMPORT_DOC_NUM 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
,      CHECK_VAT_AMOUNT_PAID
,      IMPORT_DOC_NUM
,      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:

SchemaAPPS
SynonymAP_INVOICES_ALL
PL/SQL PackageFND_NUMBER - show dependent code

APPS.AP_INVOICES_ALL2_DFV is not referenced by any database object