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

VIEW: APPS.IC_LOCT_INV_RPTVW1

Object Details
Object Name: IC_LOCT_INV_RPTVW1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMI.IC_LOCT_INV_RPTVW1
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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


Lot Inventory report view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
WHSE_CODE VARCHAR2 (4) Yes Code for the warehouse in which the inventory is located.
ITEM_NO VARCHAR2 (32) Yes Number of the item.
LOT_NO VARCHAR2 (32) Yes Number of the lot.
SUBLOT_NO VARCHAR2 (32)
Number of the sublot.
WHSE_NAME VARCHAR2 (40) Yes Name of the warehouse.
ITEM_DESC1 VARCHAR2 (70) Yes Description of the item.
ITEM_UM VARCHAR2 (4) Yes Item's primary UOM.
ITEM_UM2 VARCHAR2 (4)
Item's secondary UOM, if dual UOM controlled.
LOT_CREATED DATE
Yes The date the lot was created.
EXPIRE_DATE DATE

The date the lot expires.
LOCATION VARCHAR2 (16) Yes The location of the inventory.
LOCT_QTY1 NUMBER

The quantity onhand, in the item's primary UOM.
LOCT_QTY2 NUMBER

The quantity onhand, in the item's secondary UOM, if dual UOM controlled.
DELETE_MARK NUMBER (5) Yes Delete mark. 0=Not deleted, 1=Deleted.
Query Text

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


SELECT WHSE_CODE
,      ITEM_NO
,      LOT_NO
,      SUBLOT_NO
,      WHSE_NAME
,      ITEM_DESC1
,      ITEM_UM
,      ITEM_UM2
,      LOT_CREATED
,      EXPIRE_DATE
,      LOCATION
,      LOCT_QTY1
,      LOCT_QTY2
,      DELETE_MARK
FROM APPS.IC_LOCT_INV_RPTVW1;

Dependencies

[top of page]

APPS.IC_LOCT_INV_RPTVW1 references the following:

SchemaAPPS
SynonymIC_ITEM_MST
SynonymIC_LOCT_INV
SynonymIC_LOTS_MST
SynonymIC_WHSE_MST

APPS.IC_LOCT_INV_RPTVW1 is not referenced by any database object