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


VIEW: APPS.CSD_REPAIR_JOBS_V

Object Details
Object Name: CSD_REPAIR_JOBS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSD.CSD_REPAIR_JOBS_V
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.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
REPAIR_LINE_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REPAIR_NUMBER VARCHAR2 (30) Yes
INCIDENT_ID NUMBER (15) Yes
INCIDENT_NUMBER VARCHAR2 (64) Yes
CUSTOMER_ID NUMBER (15)
CALLER_TYPE VARCHAR2 (30) Yes
INVENTORY_ITEM_ID NUMBER (15) Yes
ITEM VARCHAR2 (40)
ITEM_DESC VARCHAR2 (240)
ORGANIZATION_ID NUMBER
Yes
UNIT_OF_MEASURE VARCHAR2 (3) Yes
REPAIR_ORDER_QUANTITY NUMBER (15) Yes Repair Order Quantity
RELEASED_QUANTITY NUMBER

REMAINING_QUANTITY NUMBER

QUANTITY_IN_WIP NUMBER

RECEIVED_QUANTITY NUMBER

Received Quantity
QUANTITY_SHIPPED NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
CUSTOMER_PRODUCT_ID NUMBER (15)
REFERENCE_NUMBER VARCHAR2 (30)
SERIAL_NUMBER VARCHAR2 (30)
RESOURCE_ID NUMBER (15)
RESOURCE_NAME VARCHAR2 (0)
JOB_TITLE VARCHAR2 (0)
REPAIR_TYPE_ID NUMBER (15)
REPAIR_TYPE VARCHAR2 (80) Yes
INSTANCE_ID NUMBER (15)
APPROVAL_REQUIRED_FLAG VARCHAR2 (1) Yes
APPROVAL_STATUS VARCHAR2 (30)
APPROVAL_STATUS_MEANING VARCHAR2 (80)
STATUS VARCHAR2 (30) Yes
STATUS_MEANING VARCHAR2 (80) Yes Job Status
DATE_CLOSED DATE

PROMISE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PARTY_NAME VARCHAR2 (360)
PARTY_NUMBER VARCHAR2 (30)
SEVERITY_ID NUMBER (15) Yes Severity Identifier
SEVERITY VARCHAR2 (90) Yes
URGENCY_ID NUMBER (15)
Urgency Identifier
URGENCY VARCHAR2 (90)
INCIDENT_TYPE VARCHAR2 (90) Yes
INCIDENT_STATUS VARCHAR2 (90) Yes
INCIDENT_DATE DATE

SUPERCESSION_PRODUCT_ID NUMBER

Supercession Product Identifier
SUPERCESSION_PRODUCT VARCHAR2 (40)
Supercession Product
SUPERCESSION_PRODUCT_DESC VARCHAR2 (240)
Supercession Product Description
ACCOUNT_ID NUMBER

Account Identifier
ACCOUNT_NUMBER VARCHAR2 (30)
Account Number
Query Text

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


SELECT ROW_ID
,      REPAIR_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REPAIR_NUMBER
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      CUSTOMER_ID
,      CALLER_TYPE
,      INVENTORY_ITEM_ID
,      ITEM
,      ITEM_DESC
,      ORGANIZATION_ID
,      UNIT_OF_MEASURE
,      REPAIR_ORDER_QUANTITY
,      RELEASED_QUANTITY
,      REMAINING_QUANTITY
,      QUANTITY_IN_WIP
,      RECEIVED_QUANTITY
,      QUANTITY_SHIPPED
,      PROJECT_ID
,      TASK_ID
,      CUSTOMER_PRODUCT_ID
,      REFERENCE_NUMBER
,      SERIAL_NUMBER
,      RESOURCE_ID
,      RESOURCE_NAME
,      JOB_TITLE
,      REPAIR_TYPE_ID
,      REPAIR_TYPE
,      INSTANCE_ID
,      APPROVAL_REQUIRED_FLAG
,      APPROVAL_STATUS
,      APPROVAL_STATUS_MEANING
,      STATUS
,      STATUS_MEANING
,      DATE_CLOSED
,      PROMISE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PARTY_NAME
,      PARTY_NUMBER
,      SEVERITY_ID
,      SEVERITY
,      URGENCY_ID
,      URGENCY
,      INCIDENT_TYPE
,      INCIDENT_STATUS
,      INCIDENT_DATE
,      SUPERCESSION_PRODUCT_ID
,      SUPERCESSION_PRODUCT
,      SUPERCESSION_PRODUCT_DESC
,      ACCOUNT_ID
,      ACCOUNT_NUMBER
FROM APPS.CSD_REPAIR_JOBS_V;

Dependencies

[top of page]

APPS.CSD_REPAIR_JOBS_V references the following:

SchemaAPPS
SynonymCSD_REPAIRS
ViewCSD_REPAIR_TYPES_VL
SynonymCSI_ITEM_INSTANCES
SynonymCS_INCIDENTS_ALL_B
ViewCS_INCIDENT_SEVERITIES_VL
ViewCS_INCIDENT_STATUSES_VL
ViewCS_INCIDENT_TYPES_VL
ViewCS_INCIDENT_URGENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
ViewMTL_SYSTEM_ITEMS_VL
SynonymPER_ALL_PEOPLE_F

APPS.CSD_REPAIR_JOBS_V is not referenced by any database object