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


VIEW: APPS.CSD_RO_V

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

Columns
Name Datatype Length Mandatory Comments
REPAIR_NUMBER VARCHAR2 (30) Yes
INCIDENT_NUMBER VARCHAR2 (64) Yes
INCIDENT_ID NUMBER (15) Yes
REFERENCE_NUMBER VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER (15) Yes
ITEM VARCHAR2 (40)
CUSTOMER_ID NUMBER (15)
SERIAL_NUMBER VARCHAR2 (30)
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
DATE_CLOSED DATE

PROMISE_DATE DATE

STATUS VARCHAR2 (30) Yes
REPAIR_LINE_ID NUMBER (15) Yes
QUANTITY NUMBER (15) Yes
UNIT_OF_MEASURE VARCHAR2 (3) Yes
ACCOUNT_NUMBER VARCHAR2 (30) Yes
ACCOUNT_NAME VARCHAR2 (240)
Query Text

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


SELECT REPAIR_NUMBER
,      INCIDENT_NUMBER
,      INCIDENT_ID
,      REFERENCE_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM
,      CUSTOMER_ID
,      SERIAL_NUMBER
,      CREATION_DATE
,      DATE_CLOSED
,      PROMISE_DATE
,      STATUS
,      REPAIR_LINE_ID
,      QUANTITY
,      UNIT_OF_MEASURE
,      ACCOUNT_NUMBER
,      ACCOUNT_NAME
FROM APPS.CSD_RO_V;

Dependencies

[top of page]

APPS.CSD_RO_V references the following:

SchemaAPPS
ViewCSD_REPAIRS_V
PL/SQL PackageCS_STD - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHZ_CUST_ACCOUNTS
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
PL/SQL PackagePA_PROJECT_UTILS - show dependent code
PL/SQL PackagePA_SECURITY - show dependent code
PL/SQL PackagePA_TASK_UTILS - show dependent code

APPS.CSD_RO_V is not referenced by any database object