[Home] [Help] [Dependency Information]
Object Name: | CSM_MTL_SEC_INVENTORIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | Yes | ||
SECONDARY_INVENTORY_NAME | VARCHAR2 | (10) | Yes | |
ORGANIZATION_ID | NUMBER | Yes | ||
DESCRIPTION | VARCHAR2 | (50) | ||
ASSET_INVENTORY | NUMBER | Yes | ||
SOURCE_TYPE | NUMBER | |||
DISABLE_DATE | DATE | |||
LOCATOR_TYPE | NUMBER | |||
QUANTITY_TRACKED | NUMBER | Yes | ||
SUBINVENTORY_USAGE | NUMBER | |||
DEPRECIABLE_FLAG | NUMBER | |||
LOCATION_ID | NUMBER | (15) | ||
STATUS_ID | NUMBER | |||
ADDRESS | VARCHAR2 | (4000) | ||
STOCK_SITE_TYPE | VARCHAR2 | (30) | ||
AUTORECEIPT_FLAG | VARCHAR2 | (30) | Yes | |
RETURN_ORG | NUMBER | (35) | ||
RETURN_SUBINV | VARCHAR2 | (10) | ||
CONDITION_TYPE | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, SECONDARY_INVENTORY_NAME
, ORGANIZATION_ID
, DESCRIPTION
, ASSET_INVENTORY
, SOURCE_TYPE
, DISABLE_DATE
, LOCATOR_TYPE
, QUANTITY_TRACKED
, SUBINVENTORY_USAGE
, DEPRECIABLE_FLAG
, LOCATION_ID
, STATUS_ID
, ADDRESS
, STOCK_SITE_TYPE
, AUTORECEIPT_FLAG
, RETURN_ORG
, RETURN_SUBINV
, CONDITION_TYPE
FROM APPS.CSM_MTL_SEC_INVENTORIES_V;
APPS.CSM_MTL_SEC_INVENTORIES_V is not referenced by any database object
|
|
|