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

VIEW: APPS.CLN_INV_LOT_NUM_V

Object Details
Object Name: CLN_INV_LOT_NUM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCLN.CLN_INV_LOT_NUM_V
Subobject Name:
Status: VALID

View Type

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


View used to get disctinct values of lot numbers for value-sets.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOT_NUMBER VARCHAR2 (80) Yes Lot Number
ORGANIZATION_ID NUMBER
Yes Organization ID
Query Text

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


SELECT LOT_NUMBER
,      ORGANIZATION_ID
FROM APPS.CLN_INV_LOT_NUM_V;

Dependencies

[top of page]

APPS.CLN_INV_LOT_NUM_V references the following:

SchemaAPPS
SynonymMTL_LOT_NUMBERS

APPS.CLN_INV_LOT_NUM_V is not referenced by any database object