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

TABLE: CSM.CSF_M_INVENTORY_INQ

Object Details
Object Name: CSF_M_INVENTORY_INQ
Object Type: TABLE
Owner: CSM
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (30)
Name of the Client(FNDUSER)
GEN_PK NUMBER

Generic Primary key
INVENTORY_ITEM_ID NUMBER

The inventory item identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code
QUANTITY NUMBER

The Quantity of the Item
INVENTORY_NAME VARCHAR2 (4000)
Inventory Item name
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial Number Control code
DESCRIPTION VARCHAR2 (240)
Item 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

Organisation Identifier
COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
Identifies an items as network logistics trackable
MATERIAL_BILLABLE_FLAG VARCHAR2 (30)
Flag indicating type of billable service
BILLING_CATEGORY VARCHAR2 (4000)
Billing Category of service material
DMLTYPE$$ VARCHAR2 (1)
Type of the DML operation performed at the client
SEQNO$$ NUMBER

Sequence Nmber to uniquely identify this record, among the records, which were performed
TRANID$$ NUMBER (10)
Id of the synch session in which this record was populated
VERSION$$ NUMBER (10)
The identifier of the Version Number
RESTRICT_LOCATORS_CODE NUMBER

Code of Restrict Locators
LOCATION_CONTROL_CODE NUMBER

Code for Location control
RESTRICT_SUBINVENTORIES_CODE NUMBER

Code for Restrict Subinventory
RECOVERED_PART_DISP_CODE VARCHAR2 (30)
Code for Recovered Part
Query Text

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


SELECT CLID$$CS
,      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
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      RESTRICT_LOCATORS_CODE
,      LOCATION_CONTROL_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      RECOVERED_PART_DISP_CODE
FROM CSM.CSF_M_INVENTORY_INQ;

Dependencies

[top of page]

CSM.CSF_M_INVENTORY_INQ does not reference any database object

CSM.CSF_M_INVENTORY_INQ is referenced by following:

SchemaCSM
ViewCSF_M_INVENTORY_INQ#