[Home] [Help] [Dependency Information]
Object Name: | CSF_M_INVENTORY_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.
A public view which may be useful for custom reporting or other data
requirements.
This view stores the information about the relationship between a resource(typically and engineer) and a subinventory/locator
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | Yes | The Unique Access Identifier | |
GEN_PK | NUMBER | Yes | Gen PK | |
INVENTORY_ITEM_ID | NUMBER | The inventory item identifier | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | Sub Inventory Code | |
QUANTITY | NUMBER | The Quantity of the Item | ||
INVENTORY_NAME | VARCHAR2 | (40) | Inventory Name | |
SERIAL_NUMBER_CONTROL_CODE | NUMBER | The Serial Number Control Code | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
UOM_CODE | VARCHAR2 | (3) | Code of the Unit of Measure | |
LOCATOR_ID | NUMBER | Locator Identifier | ||
REVISION | VARCHAR2 | (3) | Revision | |
LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
ORGANIZATION_ID | NUMBER | Yes | Organisation Identifier | |
COMMS_NL_TRACKABLE_FLAG | VARCHAR2 | (1) | Comms NL trackable Flag | |
MATERIAL_BILLABLE_FLAG | VARCHAR2 | (30) | ||
BILLING_CATEGORY | VARCHAR2 | (4000) | ||
RESTRICT_LOCATORS_CODE | NUMBER | |||
LOCATION_CONTROL_CODE | NUMBER | |||
RESTRICT_SUBINVENTORIES_CODE | NUMBER | |||
RECOVERED_PART_DISP_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, GEN_PK
, INVENTORY_ITEM_ID
, SUBINVENTORY_CODE
, QUANTITY
, INVENTORY_NAME
, SERIAL_NUMBER_CONTROL_CODE
, DESCRIPTION
, UOM_CODE
, LOCATOR_ID
, REVISION
, LOT_NUMBER
, ORGANIZATION_ID
, COMMS_NL_TRACKABLE_FLAG
, MATERIAL_BILLABLE_FLAG
, BILLING_CATEGORY
, RESTRICT_LOCATORS_CODE
, LOCATION_CONTROL_CODE
, RESTRICT_SUBINVENTORIES_CODE
, RECOVERED_PART_DISP_CODE
FROM APPS.CSF_M_INVENTORY_V;
APPS.CSF_M_INVENTORY_V is not referenced by any database object
|
|
|