[Home] [Help] [Dependency Information]
Object Name: | CSD_REPAIR_ESTIMATE_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSD.CSD_REPAIR_ESTIMATE_LINES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
REPAIR_LINE_ID | NUMBER | (15) | Yes | |
REPAIR_NUMBER | VARCHAR2 | (30) | Yes | |
REPAIR_ESTIMATE_ID | NUMBER | Yes | ||
REPAIR_ESTIMATE_LINE_ID | NUMBER | Yes | ||
ESTIMATE_DETAIL_ID | NUMBER | (15) | Yes | |
AUTO_PROCESS_RMA | VARCHAR2 | (1) | ||
REPAIR_MODE | VARCHAR2 | (30) | ||
REPAIR_TYPE_ID | NUMBER | (15) | ||
INCIDENT_ID | NUMBER | (15) | Yes | |
INVENTORY_ITEM_ID | NUMBER | (15) | ||
PRODUCT | VARCHAR2 | (40) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
CREATED_BY | NUMBER | 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 | 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 | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | ||
UNIT_MEASURE_TL | VARCHAR2 | (25) | Yes | |
ESTIMATE_QUANTITY | NUMBER | |||
REPAIR_QUANTITY | NUMBER | (15) | Yes | |
CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
APPROVAL_STATUS | VARCHAR2 | (30) | ||
STATUS | VARCHAR2 | (30) | Yes | |
PROMISE_DATE | DATE | |||
CONTEXT | VARCHAR2 | (240) | ||
ATTRIBUTE1 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (100) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (100) | Descriptive flexfield segment | |
PRICE_LIST_HEADER_ID | NUMBER | |||
PRICE_LIST | VARCHAR2 | (240) | ||
TRANSACTION_TYPE | VARCHAR2 | (90) | Yes | |
BILLING_TYPE | VARCHAR2 | (30) | Yes | |
BILLING_TYPE_MEANING | VARCHAR2 | (80) | Yes | |
BILLING_CATEGORY | VARCHAR2 | (30) | Yes | |
TXN_BILLING_TYPE_ID | NUMBER | (15) | ||
ORDER_HEADER_ID | NUMBER | |||
ORDER_LINE_ID | NUMBER | |||
RETURN_REASON_CODE | VARCHAR2 | (30) | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | ||
CONTRACT_ID | NUMBER | |||
INVOICE_TO_ORG_ID | NUMBER | (15) | ||
SELLING_PRICE | NUMBER | |||
NO_CHARGE_FLAG | VARCHAR2 | (1) | ||
BUSINESS_PROCESS_ID | NUMBER | (15) | Yes | |
LOT_CONTROL_CODE | NUMBER | |||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | |||
CHARGE | NUMBER | |||
PROFIT_MARGIN_PERCENTAGE | VARCHAR2 | (40) | ||
PROFIT_MARGIN | VARCHAR2 | (40) | ||
ITEM_COST | NUMBER | |||
ESTIMATE_DATE | DATE | Yes | ||
ESTIMATE_STATUS | VARCHAR2 | (30) | Yes | |
PO_NUMBER | VARCHAR2 | (50) | ||
COVERAGE_RATE_ID | NUMBER | |||
COVERAGE_TYPE_ID | VARCHAR2 | (0) | ||
JUSTIFICATION_NOTES | VARCHAR2 | (240) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | |
RMA_NUMBER | VARCHAR2 | (0) | ||
TRANSACTION_TYPE_ID | NUMBER | |||
ORIGINAL_SOURCE_ID | NUMBER | (15) | Yes | |
ORIGINAL_SOURCE_CODE | VARCHAR2 | (10) | Yes | |
SOURCE_ID | NUMBER | (15) | ||
SOURCE_CODE | VARCHAR2 | (10) | ||
LINE_TYPE_ID | NUMBER | (15) | ||
ITEM_REVISION | VARCHAR2 | (3) | ||
LINE_CATEGORY_CODE | VARCHAR2 | (30) | ||
COVERAGE_ID | NUMBER | |||
COVERAGE_TXN_GROUP_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
SHIP_TO_ORG_ID | NUMBER | (15) | ||
INTERFACE_TO_OE_FLAG | VARCHAR2 | (1) | ||
INSTALLED_CP_RETURN_BY_DATE | DATE | |||
RESOURCE_ID | NUMBER | |||
RESOURCE_CODE | VARCHAR2 | (10) | ||
OVERRIDE_CHARGE_FLAG | VARCHAR2 | (1) | ||
EST_LINE_SOURCE_TYPE_CODE | VARCHAR2 | (30) | Source type of estimate line. Lookup code from CSD_EST_LINE_SOURCE_TYPE | |
EST_LINE_SOURCE_DESC | VARCHAR2 | (80) | Yes | Displayable name of source type. Lookup meaning for ESTIMATE_LINE_SOURCE_TYPE |
EST_LINE_SOURCE_ID1 | NUMBER | (15) | Source id of estimate line. | |
EST_LINE_SOURCE_NAME1 | VARCHAR2 | (500) | Source name of estimate line. | |
EST_LINE_SOURCE_ID2 | NUMBER | (15) | For future use. | |
EST_LINE_SOURCE_NAME2 | VARCHAR2 | (0) | For future use. | |
RO_SERVICE_CODE_ID | NUMBER | (15) | Foreign key to CSD_RO_SERVICE_CODES table | |
PRICING_CONTEXT | VARCHAR2 | (30) | ||
PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE16 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE17 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE18 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE19 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE20 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE21 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE22 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE23 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE24 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE25 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE26 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE27 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE28 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE29 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE30 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE31 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE32 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE33 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE34 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE35 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE36 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE37 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE38 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE39 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE40 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE41 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE42 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE43 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE44 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE45 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE46 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE47 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE48 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE49 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE50 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE51 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE52 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE53 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE54 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE55 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE56 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE57 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE58 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE59 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE60 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE61 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE62 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE63 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE64 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE65 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE66 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE67 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE68 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE69 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE70 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE71 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE72 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE73 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE74 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE75 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE76 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE77 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE78 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE79 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE80 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE81 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE82 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE83 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE84 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE85 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE86 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE87 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE88 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE89 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE90 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE91 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE92 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE93 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE94 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE95 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE96 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE97 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE98 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE99 | VARCHAR2 | (150) | ||
PRICING_ATTRIBUTE100 | VARCHAR2 | (150) | ||
CONTRACT_DISCOUNT_AMOUNT | NUMBER | Contract Discount Amount | ||
CONTRACT_LINE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REPAIR_LINE_ID
, REPAIR_NUMBER
, REPAIR_ESTIMATE_ID
, REPAIR_ESTIMATE_LINE_ID
, ESTIMATE_DETAIL_ID
, AUTO_PROCESS_RMA
, REPAIR_MODE
, REPAIR_TYPE_ID
, INCIDENT_ID
, INVENTORY_ITEM_ID
, PRODUCT
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, UNIT_OF_MEASURE_CODE
, UNIT_MEASURE_TL
, ESTIMATE_QUANTITY
, REPAIR_QUANTITY
, CUSTOMER_PRODUCT_ID
, SERIAL_NUMBER
, APPROVAL_REQUIRED_FLAG
, APPROVAL_STATUS
, STATUS
, PROMISE_DATE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PRICE_LIST_HEADER_ID
, PRICE_LIST
, TRANSACTION_TYPE
, BILLING_TYPE
, BILLING_TYPE_MEANING
, BILLING_CATEGORY
, TXN_BILLING_TYPE_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, RETURN_REASON_CODE
, CONTRACT_NUMBER
, CONTRACT_ID
, INVOICE_TO_ORG_ID
, SELLING_PRICE
, NO_CHARGE_FLAG
, BUSINESS_PROCESS_ID
, LOT_CONTROL_CODE
, SERIAL_NUMBER_CONTROL_CODE
, CHARGE
, PROFIT_MARGIN_PERCENTAGE
, PROFIT_MARGIN
, ITEM_COST
, ESTIMATE_DATE
, ESTIMATE_STATUS
, PO_NUMBER
, COVERAGE_RATE_ID
, COVERAGE_TYPE_ID
, JUSTIFICATION_NOTES
, CURRENCY_CODE
, INCIDENT_NUMBER
, RMA_NUMBER
, TRANSACTION_TYPE_ID
, ORIGINAL_SOURCE_ID
, ORIGINAL_SOURCE_CODE
, SOURCE_ID
, SOURCE_CODE
, LINE_TYPE_ID
, ITEM_REVISION
, LINE_CATEGORY_CODE
, COVERAGE_ID
, COVERAGE_TXN_GROUP_ID
, ORGANIZATION_ID
, SHIP_TO_ORG_ID
, INTERFACE_TO_OE_FLAG
, INSTALLED_CP_RETURN_BY_DATE
, RESOURCE_ID
, RESOURCE_CODE
, OVERRIDE_CHARGE_FLAG
, EST_LINE_SOURCE_TYPE_CODE
, EST_LINE_SOURCE_DESC
, EST_LINE_SOURCE_ID1
, EST_LINE_SOURCE_NAME1
, EST_LINE_SOURCE_ID2
, EST_LINE_SOURCE_NAME2
, RO_SERVICE_CODE_ID
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, PRICING_ATTRIBUTE16
, PRICING_ATTRIBUTE17
, PRICING_ATTRIBUTE18
, PRICING_ATTRIBUTE19
, PRICING_ATTRIBUTE20
, PRICING_ATTRIBUTE21
, PRICING_ATTRIBUTE22
, PRICING_ATTRIBUTE23
, PRICING_ATTRIBUTE24
, PRICING_ATTRIBUTE25
, PRICING_ATTRIBUTE26
, PRICING_ATTRIBUTE27
, PRICING_ATTRIBUTE28
, PRICING_ATTRIBUTE29
, PRICING_ATTRIBUTE30
, PRICING_ATTRIBUTE31
, PRICING_ATTRIBUTE32
, PRICING_ATTRIBUTE33
, PRICING_ATTRIBUTE34
, PRICING_ATTRIBUTE35
, PRICING_ATTRIBUTE36
, PRICING_ATTRIBUTE37
, PRICING_ATTRIBUTE38
, PRICING_ATTRIBUTE39
, PRICING_ATTRIBUTE40
, PRICING_ATTRIBUTE41
, PRICING_ATTRIBUTE42
, PRICING_ATTRIBUTE43
, PRICING_ATTRIBUTE44
, PRICING_ATTRIBUTE45
, PRICING_ATTRIBUTE46
, PRICING_ATTRIBUTE47
, PRICING_ATTRIBUTE48
, PRICING_ATTRIBUTE49
, PRICING_ATTRIBUTE50
, PRICING_ATTRIBUTE51
, PRICING_ATTRIBUTE52
, PRICING_ATTRIBUTE53
, PRICING_ATTRIBUTE54
, PRICING_ATTRIBUTE55
, PRICING_ATTRIBUTE56
, PRICING_ATTRIBUTE57
, PRICING_ATTRIBUTE58
, PRICING_ATTRIBUTE59
, PRICING_ATTRIBUTE60
, PRICING_ATTRIBUTE61
, PRICING_ATTRIBUTE62
, PRICING_ATTRIBUTE63
, PRICING_ATTRIBUTE64
, PRICING_ATTRIBUTE65
, PRICING_ATTRIBUTE66
, PRICING_ATTRIBUTE67
, PRICING_ATTRIBUTE68
, PRICING_ATTRIBUTE69
, PRICING_ATTRIBUTE70
, PRICING_ATTRIBUTE71
, PRICING_ATTRIBUTE72
, PRICING_ATTRIBUTE73
, PRICING_ATTRIBUTE74
, PRICING_ATTRIBUTE75
, PRICING_ATTRIBUTE76
, PRICING_ATTRIBUTE77
, PRICING_ATTRIBUTE78
, PRICING_ATTRIBUTE79
, PRICING_ATTRIBUTE80
, PRICING_ATTRIBUTE81
, PRICING_ATTRIBUTE82
, PRICING_ATTRIBUTE83
, PRICING_ATTRIBUTE84
, PRICING_ATTRIBUTE85
, PRICING_ATTRIBUTE86
, PRICING_ATTRIBUTE87
, PRICING_ATTRIBUTE88
, PRICING_ATTRIBUTE89
, PRICING_ATTRIBUTE90
, PRICING_ATTRIBUTE91
, PRICING_ATTRIBUTE92
, PRICING_ATTRIBUTE93
, PRICING_ATTRIBUTE94
, PRICING_ATTRIBUTE95
, PRICING_ATTRIBUTE96
, PRICING_ATTRIBUTE97
, PRICING_ATTRIBUTE98
, PRICING_ATTRIBUTE99
, PRICING_ATTRIBUTE100
, CONTRACT_DISCOUNT_AMOUNT
, CONTRACT_LINE_ID
FROM APPS.CSD_REPAIR_ESTIMATE_LINES_V;
|
|
|