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

VIEW: CSM.CSF_M_DEBRIEF_PARTS_INQ#

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

[View Source]

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

ISSUING_SUB_INVENTORY_CODE VARCHAR2 (10)
ISSUING_INVENTORY_ORG_ID NUMBER

INVENTORY_ITEM_ID NUMBER

TXN_BILLING_TYPE_ID NUMBER

TASK_ASSIGNMENT_ID NUMBER

RESOURCE_ID NUMBER

ITEM_SERIAL_NUMBER VARCHAR2 (30)
QUANTITY NUMBER

UOM_CODE VARCHAR2 (3)
ITEM_REVISION VARCHAR2 (3)
ITEM_LOTNUMBER VARCHAR2 (80)
BUSINESS_PROCESS_ID NUMBER

INSTANCE_ID NUMBER

LAST_UPDATE_DATE DATE

DMLTYPE$$ VARCHAR2 (1)
SEQNO$$ NUMBER

TRANID$$ NUMBER (10)
VERSION$$ NUMBER (10)
ITEM_NAME VARCHAR2 (4000)
ITEM_DESCRIPTION VARCHAR2 (240)
TRANSACTION_TYPE_ID NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

MATERIAL_REASON_CODE VARCHAR2 (30)
SERVICE_DATE DATE

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
RETURN_REASON_CODE VARCHAR2 (30)
DISPOSITION_CODE VARCHAR2 (30)
ISSUING_LOCATOR_ID NUMBER

PARENT_PRODUCT_ID NUMBER

REMOVED_PRODUCT_ID NUMBER

DEBRIEF_HEADER_ID NUMBER

RETURN_DATE DATE

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

SERVER_LAST_UPDATE_DATE DATE

FREE_FORM_ITEM VARCHAR2 (40)
DEBRIEF_LINE_NUMBER NUMBER

CARRIER_CODE VARCHAR2 (80)
USAGE_TYPE VARCHAR2 (30)
WAYBILL VARCHAR2 (60)
MATERIAL_TRANSACTION_ID NUMBER

SHIPPING_METHOD VARCHAR2 (60)
SHIPPING_NUMBER VARCHAR2 (60)
RETURN_ORGANIZATION_ID NUMBER

RETURN_SUBINVENTORY_NAME VARCHAR2 (10)
STATUS_OF_RECEIVED_PART VARCHAR2 (30)
CHANNEL_CODE VARCHAR2 (30)
COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
RECOVERED_SERIAL_NUMBER VARCHAR2 (4000)
PARENT_SERIAL_NUMBER VARCHAR2 (4000)
Query Text

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


SELECT CLID$$CS
,      DEBRIEF_LINE_ID
,      ISSUING_SUB_INVENTORY_CODE
,      ISSUING_INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      TXN_BILLING_TYPE_ID
,      TASK_ASSIGNMENT_ID
,      RESOURCE_ID
,      ITEM_SERIAL_NUMBER
,      QUANTITY
,      UOM_CODE
,      ITEM_REVISION
,      ITEM_LOTNUMBER
,      BUSINESS_PROCESS_ID
,      INSTANCE_ID
,      LAST_UPDATE_DATE
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      TRANSACTION_TYPE_ID
,      SERIAL_NUMBER_CONTROL_CODE
,      MATERIAL_REASON_CODE
,      SERVICE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      RETURN_REASON_CODE
,      DISPOSITION_CODE
,      ISSUING_LOCATOR_ID
,      PARENT_PRODUCT_ID
,      REMOVED_PRODUCT_ID
,      DEBRIEF_HEADER_ID
,      RETURN_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SERVER_LAST_UPDATE_DATE
,      FREE_FORM_ITEM
,      DEBRIEF_LINE_NUMBER
,      CARRIER_CODE
,      USAGE_TYPE
,      WAYBILL
,      MATERIAL_TRANSACTION_ID
,      SHIPPING_METHOD
,      SHIPPING_NUMBER
,      RETURN_ORGANIZATION_ID
,      RETURN_SUBINVENTORY_NAME
,      STATUS_OF_RECEIVED_PART
,      CHANNEL_CODE
,      COMMS_NL_TRACKABLE_FLAG
,      RECOVERED_SERIAL_NUMBER
,      PARENT_SERIAL_NUMBER
FROM CSM.CSF_M_DEBRIEF_PARTS_INQ#;

Dependencies

[top of page]

CSM.CSF_M_DEBRIEF_PARTS_INQ# references the following:

SchemaCSM
TableCSF_M_DEBRIEF_PARTS_INQ
CSM.CSF_M_DEBRIEF_PARTS_INQ# is referenced by following:

SchemaAPPS
SynonymCSF_M_DEBRIEF_PARTS_INQ