[Home] [Help]
[Dependency Information]
| Object Name: | CSD_RO_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | CSD.CSD_RO_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| 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) |
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;
APPS
CSD_REPAIRS_V
CS_STD
- show dependent code
FND_GLOBAL
- show dependent code
FND_PROFILE
- show dependent code
HZ_CUST_ACCOUNTS
PA_CROSS_BUSINESS_GRP
- show dependent code
PA_PROJECT_UTILS
- show dependent code
PA_SECURITY
- show dependent code
PA_TASK_UTILS
- show dependent code
APPS.CSD_RO_V is not referenced by any database object
|
|
|
|