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

VIEW: CSM.CSF_M_INVENTORY_INQ#

Object Details
Object Name: CSF_M_INVENTORY_INQ#
Object Type: VIEW
Owner: CSM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (30)
GEN_PK NUMBER

INVENTORY_ITEM_ID NUMBER

SUBINVENTORY_CODE VARCHAR2 (10)
QUANTITY NUMBER

INVENTORY_NAME VARCHAR2 (4000)
SERIAL_NUMBER_CONTROL_CODE NUMBER

DESCRIPTION VARCHAR2 (240)
UOM_CODE VARCHAR2 (3)
LOCATOR_ID NUMBER

REVISION VARCHAR2 (3)
LOT_NUMBER VARCHAR2 (80)
ORGANIZATION_ID NUMBER

COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
MATERIAL_BILLABLE_FLAG VARCHAR2 (30)
BILLING_CATEGORY VARCHAR2 (4000)
DMLTYPE$$ VARCHAR2 (1)
SEQNO$$ NUMBER

TRANID$$ NUMBER (10)
VERSION$$ NUMBER (10)
RESTRICT_LOCATORS_CODE NUMBER

LOCATION_CONTROL_CODE NUMBER

RESTRICT_SUBINVENTORIES_CODE NUMBER

RECOVERED_PART_DISP_CODE VARCHAR2 (30)
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# references the following:

SchemaCSM
TableCSF_M_INVENTORY_INQ
CSM.CSF_M_INVENTORY_INQ# is referenced by following:

SchemaAPPS
SynonymCSF_M_INVENTORY_INQ