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

VIEW: APPS.CSP_GET_SERIAL_NUMBERS_V

Object Details
Object Name: CSP_GET_SERIAL_NUMBERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_GET_SERIAL_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 serial numbers of 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 serial 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
SERIAL_NUMBER VARCHAR2 (30) Yes Serial number
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory name
LOCATOR_ID NUMBER

Locator identifier
LOT_NUMBER VARCHAR2 (80)
Lot number
CURRENT_STATUS NUMBER

Serial number status
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      SERIAL_NUMBER
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOT_NUMBER
,      CURRENT_STATUS
FROM APPS.CSP_GET_SERIAL_NUMBERS_V;

Dependencies

[top of page]

APPS.CSP_GET_SERIAL_NUMBERS_V references the following:

SchemaAPPS
SynonymMTL_SERIAL_NUMBERS

APPS.CSP_GET_SERIAL_NUMBERS_V is not referenced by any database object