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

VIEW: APPS.CSP_GET_LOT_NUMBERS_V

Object Details
Object Name: CSP_GET_LOT_NUMBERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_GET_LOT_NUMBERS_V
Subobject Name:
Status: VALID

View Type

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


The view is used for getting lot numbers for an item at the locator, subinventory or organization as per the level specified. This view should be called with a WHERE clause specifying the organization, subinventory or the locator for which the lot numbers for the item should be fetched.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
REVISION VARCHAR2 (3)
Item revision
LOT_NUMBER VARCHAR2 (80) Yes Lot number
SUBINVENTORY_CODE VARCHAR2 (10) Yes Subinventory name
LOCATOR_ID NUMBER

Locator identifier
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      LOCATOR_ID
FROM APPS.CSP_GET_LOT_NUMBERS_V;

Dependencies

[top of page]

APPS.CSP_GET_LOT_NUMBERS_V references the following:

SchemaAPPS
SynonymMTL_LOT_NUMBERS
ViewMTL_ONHAND_QUANTITIES

APPS.CSP_GET_LOT_NUMBERS_V is not referenced by any database object