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 Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (150)
INVOICE_CATEGORY 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)
TRANSACTION_DEADLINE 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
,      INVOICE_CATEGORY
,      SUPPLIER_EXCHANGE_RATE
,      WINE_CIGARETTE
,      DEDUCTIBLE_TYPE
,      PRINT_DATE
,      IMPORT_DOC_DATE
,      CORRECTION_YEAR
,      CORRECTION_PERIOD
,      TRANSACTION_DEADLINE
,      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:

SchemaAPPS
SynonymAP_INVOICES_INTERFACE
PL/SQL PackageFND_NUMBER - show dependent code

APPS.AP_INVOICES_INTERFACE1_DFV is not referenced by any database object