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

VIEW: APPS.CSM_MTL_SEC_INVENTORIES_V

Object Details
Object Name: CSM_MTL_SEC_INVENTORIES_V
Object Type: VIEW
Owner: APPS
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 Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.CSM_MTL_SEC_INVENTORIES_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSM_MTL_SEC_INV_ACC
SynonymCSP_PLANNING_PARAMETERS
SynonymCSP_SEC_INVENTORIES
PL/SQL PackageHZ_FORMAT_PUB - show dependent code
SynonymMTL_SECONDARY_INVENTORIES

APPS.CSM_MTL_SEC_INVENTORIES_V is not referenced by any database object