[Home] [Help] [Dependency Information]
Object Name: | JTM_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 | |||
ORGANIZATION_ID | NUMBER | Yes | ||
SECONDARY_INVENTORY_NAME | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (50) | ||
QUANTITY_TRACKED | NUMBER | Yes | ||
ASSET_INVENTORY | NUMBER | Yes | ||
DISABLE_DATE | DATE | |||
SUBINVENTORY_USAGE | NUMBER | |||
DEPRECIABLE_FLAG | NUMBER | |||
LOCATION_ID | NUMBER | (15) | ||
STATUS_ID | NUMBER | |||
LOCATOR_TYPE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, ORGANIZATION_ID
, SECONDARY_INVENTORY_NAME
, DESCRIPTION
, QUANTITY_TRACKED
, ASSET_INVENTORY
, DISABLE_DATE
, SUBINVENTORY_USAGE
, DEPRECIABLE_FLAG
, LOCATION_ID
, STATUS_ID
, LOCATOR_TYPE
FROM APPS.JTM_MTL_SEC_INVENTORIES_V;
APPS.JTM_MTL_SEC_INVENTORIES_V is not referenced by any database object
|
|
|