[Home] [Help] [Dependency Information]
Object Name: | CSF_M_INVENTORY_INQ |
---|---|
Object Type: | TABLE |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
CSM.CSF_M_INVENTORY_INQ does not reference any database object
CSM.CSF_M_INVENTORY_INQ is referenced by following:
|
|
|