[Home] [Help] [Dependency Information]
Object Name: | ISC_DR_CURR_01_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | ISC_DR_CURR_01_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | NONE |
Refresh Mode: | DEMAND |
Refresh Method: | COMPLETE |
Build Mode: | DEFERRED |
Fast Refreshable: | NO |
ENI_OLTP_ITEM_STAR
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;
|
|
|