DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.OKL_INV_FORMATS_ALL_V

Object Details
Object Name: OKL_INV_FORMATS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_INV_FORMATS_ALL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


describes the presentation of invoice information
contains several INVOICE TYPE


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
NAME VARCHAR2 (150) Yes Name
DESCRIPTION VARCHAR2 (1995)
User entered description
CONTRACT_LEVEL_YN VARCHAR2 (3) Yes are the invoices described to be created 1 per contract
START_DATE DATE

Start date
END_DATE DATE

End date
ILT_ID NUMBER

Foreign key to table OKL_INVC_LINE_TYPES_B
ORG_ID NUMBER (15)
Operating Unit identifier
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OPERATING_UNIT VARCHAR2 (240) Yes Operating Unit
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      NAME
,      DESCRIPTION
,      CONTRACT_LEVEL_YN
,      START_DATE
,      END_DATE
,      ILT_ID
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OPERATING_UNIT
FROM APPS.OKL_INV_FORMATS_ALL_V;

Dependencies

[top of page]

APPS.OKL_INV_FORMATS_ALL_V references the following:

SchemaAPPS
ViewHR_OPERATING_UNITS
SynonymOKL_INVOICE_FORMATS_TL
SynonymOKL_INV_FORMATS_ALL_B

APPS.OKL_INV_FORMATS_ALL_V is not referenced by any database object