[Home] [Help] [Dependency Information]
Object Name: | ISC_DR_CURR_01_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.ISC_DR_CURR_01_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_DR_CURR_01_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ITEM_ORG_ID
REPAIR_ORGANIZATION_ID |
ISC_DR_CURR_01_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
CUSTOMER_ID
PRODUCT_CATEGORY_ID |
ISC_DR_CURR_01_MV_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PRODUCT_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPAIR_LINE_ID | NUMBER | (15) | Yes | Repair Order identifier |
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | Inventory Item id |
REPAIR_ORGANIZATION_ID | NUMBER | (15) | Yes | repair organization identifier |
MASTER_ORGANIZATION_ID | NUMBER | (15) | Yes | Master organization identifier |
ITEM_ORG_ID | VARCHAR2 | (25) | Yes | Item Org Identifier |
PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
REPAIR_TYPE_ID | NUMBER | (15) | Repair type Identifier | |
CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number of the Item coming for repair | |
REPAIR_NUMBER | VARCHAR2 | (30) | Yes | Repair Order Number |
QUANTITY | NUMBER | (15) | Yes | Ordered quantity |
STATUS | VARCHAR2 | (1) | Yes | Status code of the repair order |
FLOW_STATUS_ID | NUMBER | Flow Status code of the repair order | ||
PROMISE_DATE | DATE | Promise date of delivery of the repaired broken product. This only stores date and not the timestamp. | ||
UOM_CODE | VARCHAR2 | (3) | Yes | Unit of Measure for the quantity field |
INCIDENT_NUMBER | VARCHAR2 | (64) | ||
INCIDENT_ID | NUMBER | (15) | ||
PAST_DUE_DAYS | NUMBER | Whole Number of days by which the order is past due | ||
PAST_DUE_FLAG | CHAR | (1) | Indicates if this repair order is past due or not | |
DAYS_UNTIL_PROMISED | NUMBER | Whole number of days by which the order is promised |
Cut, paste (and edit) the following text to query this object:
SELECT REPAIR_LINE_ID
, INVENTORY_ITEM_ID
, REPAIR_ORGANIZATION_ID
, MASTER_ORGANIZATION_ID
, ITEM_ORG_ID
, PRODUCT_CATEGORY_ID
, REPAIR_TYPE_ID
, CUSTOMER_ID
, SERIAL_NUMBER
, REPAIR_NUMBER
, QUANTITY
, STATUS
, FLOW_STATUS_ID
, PROMISE_DATE
, UOM_CODE
, INCIDENT_NUMBER
, INCIDENT_ID
, PAST_DUE_DAYS
, PAST_DUE_FLAG
, DAYS_UNTIL_PROMISED
FROM APPS.ISC_DR_CURR_01_MV;
APPS.ISC_DR_CURR_01_MV does not reference any database object
APPS.ISC_DR_CURR_01_MV is referenced by following:
|
|
|