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

VIEW: CS.CS_REPAIRS_ALL#

Object Details
Object Name: CS_REPAIRS_ALL#
Object Type: VIEW
Owner: CS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REPAIR_LINE_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
REPAIR_NUMBER VARCHAR2 (30)
PROGRAM_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

RMA_HEADER_ID NUMBER (15)
RMA_LINE_ID NUMBER (15)
RMA_CUSTOMER_ID NUMBER

RMA_NUMBER NUMBER

RMA_TYPE_ID NUMBER

RMA_DATE DATE

RMA_LINE_NUMBER NUMBER

REPAIR_DURATION NUMBER

RECEIVED_DATE DATE
Yes
MTL_TRANSACTION_ID NUMBER

SHIPPED_DATE DATE

ESTIMATE_ID NUMBER (15)
WIP_ENTITY_ID NUMBER (15)
GROUP_ID NUMBER

REPAIR_HEADER_ID NUMBER (15)
REPAIR_ORDER_LINE_ID NUMBER

REPLACE_HEADER_ID NUMBER (15)
LOANER_HEADER_ID NUMBER (15)
CUSTOMER_PRODUCT_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15) Yes
SERIAL_NUMBER VARCHAR2 (30)
QUANTITY_RECEIVED NUMBER
Yes
QUANTITY_COMPLETE NUMBER

QUANTITY_SCRAPPED NUMBER

QUANTITY_REPLACED NUMBER

REPAIR_UNIT_OF_MEASURE_CODE VARCHAR2 (3)
STATUS VARCHAR2 (30) Yes
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)
CONTEXT VARCHAR2 (30)
ORG_ID NUMBER

ORGANIZATION_ID NUMBER

RECVD_ORGANIZATION_ID NUMBER
Yes
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
ALLOW_JOB VARCHAR2 (1)
INCIDENT_ID NUMBER (15)
ESTIMATE_BUSINESS_GROUP_ID NUMBER (15)
DIAGNOSIS_ID NUMBER (15)
DIAGNOSED_BY_ID NUMBER (15)
JOB_COMPLETION_DATE DATE

PROMISED_DELIVERY_DATE DATE

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
Query Text

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


SELECT REPAIR_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      REPAIR_NUMBER
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      RMA_HEADER_ID
,      RMA_LINE_ID
,      RMA_CUSTOMER_ID
,      RMA_NUMBER
,      RMA_TYPE_ID
,      RMA_DATE
,      RMA_LINE_NUMBER
,      REPAIR_DURATION
,      RECEIVED_DATE
,      MTL_TRANSACTION_ID
,      SHIPPED_DATE
,      ESTIMATE_ID
,      WIP_ENTITY_ID
,      GROUP_ID
,      REPAIR_HEADER_ID
,      REPAIR_ORDER_LINE_ID
,      REPLACE_HEADER_ID
,      LOANER_HEADER_ID
,      CUSTOMER_PRODUCT_ID
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      QUANTITY_RECEIVED
,      QUANTITY_COMPLETE
,      QUANTITY_SCRAPPED
,      QUANTITY_REPLACED
,      REPAIR_UNIT_OF_MEASURE_CODE
,      STATUS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      ORG_ID
,      ORGANIZATION_ID
,      RECVD_ORGANIZATION_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      ALLOW_JOB
,      INCIDENT_ID
,      ESTIMATE_BUSINESS_GROUP_ID
,      DIAGNOSIS_ID
,      DIAGNOSED_BY_ID
,      JOB_COMPLETION_DATE
,      PROMISED_DELIVERY_DATE
,      PROJECT_ID
,      TASK_ID
FROM CS.CS_REPAIRS_ALL#;

Dependencies

[top of page]

CS.CS_REPAIRS_ALL# references the following:

SchemaCS
TableCS_REPAIRS_ALL
CS.CS_REPAIRS_ALL# is referenced by following:

SchemaAPPS
SynonymCS_REPAIRS_ALL