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


VIEW: CS.CS_ESTIMATE_DETAILS#

Object Details
Object Name: CS_ESTIMATE_DETAILS#
Object Type: VIEW
Owner: CS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ESTIMATE_DETAIL_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
ESTIMATE_ID NUMBER (15)
LINE_NUMBER NUMBER

INVENTORY_ITEM_ID NUMBER (15)
SERIAL_NUMBER VARCHAR2 (30)
QUANTITY_REQUIRED NUMBER

UNIT_OF_MEASURE_CODE VARCHAR2 (3)
SELLING_PRICE NUMBER

AFTER_WARRANTY_COST NUMBER

DIAGNOSIS_ID NUMBER (15)
ESTIMATE_BUSINESS_GROUP_ID NUMBER (15)
TRANSACTION_TYPE_ID NUMBER

CUSTOMER_PRODUCT_ID NUMBER (15)
ORDER_HEADER_ID NUMBER

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
INSTALLED_CP_RETURN_BY_DATE DATE

NEW_CP_RETURN_BY_DATE DATE

INTERFACE_TO_OE_FLAG VARCHAR2 (1)
ROLLUP_FLAG VARCHAR2 (1)
ADD_TO_ORDER VARCHAR2 (1)
SYSTEM_ID NUMBER (15)
RMA_HEADER_ID NUMBER (15)
RMA_NUMBER NUMBER (30)
RMA_LINE_ID NUMBER (15)
RMA_LINE_NUMBER NUMBER (30)
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)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CONTEXT VARCHAR2 (30)
TECHNICIAN_ID NUMBER (15)
TXN_START_TIME DATE

TXN_END_TIME DATE

ORGANIZATION_ID NUMBER

COVERAGE_BILL_RATE_ID NUMBER

COVERAGE_BILLING_TYPE_ID NUMBER (15)
TIME_ZONE_ID NUMBER (15)
TXN_BILLING_TYPE_ID NUMBER (15)
BUSINESS_PROCESS_ID NUMBER (15) Yes
INCIDENT_ID NUMBER (15) Yes
ORIGINAL_SOURCE_ID NUMBER (15) Yes
ORIGINAL_SOURCE_CODE VARCHAR2 (10) Yes
SOURCE_ID NUMBER (15)
SOURCE_CODE VARCHAR2 (10)
CONTRACT_ID NUMBER

COVERAGE_ID NUMBER

COVERAGE_TXN_GROUP_ID NUMBER

INVOICE_TO_ORG_ID NUMBER (15)
SHIP_TO_ORG_ID NUMBER (15)
PURCHASE_ORDER_NUM VARCHAR2 (50)
LINE_TYPE_ID NUMBER (15)
LINE_CATEGORY_CODE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15)
CONVERSION_RATE NUMBER

CONVERSION_TYPE_CODE VARCHAR2 (30)
CONVERSION_RATE_DATE DATE

RETURN_REASON_CODE VARCHAR2 (30)
ORDER_LINE_ID NUMBER

PRICE_LIST_HEADER_ID NUMBER

FUNC_CURR_AFT_WARR_COST NUMBER

ORIG_SYSTEM_REFERENCE VARCHAR2 (50)
ORIG_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
ADD_TO_ORDER_FLAG VARCHAR2 (1)
EXCEPTION_COVERAGE_USED VARCHAR2 (1)
TAX_CODE VARCHAR2 (30)
EST_TAX_AMOUNT NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER

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_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)
PRICING_ATTRIBUTE60 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

UPGRADED_STATUS_FLAG VARCHAR2 (1)
ORIG_SYSTEM_REFERENCE_ID NUMBER

NO_CHARGE_FLAG VARCHAR2 (1)
ORG_ID NUMBER

ITEM_REVISION VARCHAR2 (3)
TRANS_INV_ORGANIZATION_ID NUMBER

TRANS_SUBINVENTORY VARCHAR2 (10)
ACTIVITY_DATE DATE

ACTIVITY_START_TIME DATE

ACTIVITY_END_TIME DATE

GENERATED_BY_BCA_ENGINE_FLAG VARCHAR2 (1)
TRANSACTION_INVENTORY_ORG NUMBER

TRANSACTION_SUB_INVENTORY VARCHAR2 (10)
ACTIVITY_START_DATE_TIME DATE

ACTIVITY_END_DATE_TIME DATE

CHARGE_LINE_TYPE VARCHAR2 (30)
SHIP_TO_CONTACT_ID NUMBER

BILL_TO_CONTACT_ID NUMBER

SHIP_TO_ACCOUNT_ID NUMBER

INVOICE_TO_ACCOUNT_ID NUMBER

LIST_PRICE NUMBER

CONTRACT_DISCOUNT_AMOUNT NUMBER

BILL_TO_PARTY_ID NUMBER

SHIP_TO_PARTY_ID NUMBER

SUBMIT_RESTRICTION_MESSAGE VARCHAR2 (2000)
SUBMIT_ERROR_MESSAGE VARCHAR2 (2000)
SUBMIT_FROM_SYSTEM VARCHAR2 (30)
LINE_SUBMITTED VARCHAR2 (1)
CONTRACT_LINE_ID NUMBER

RATE_TYPE_CODE VARCHAR2 (40)
INSTRUMENT_PAYMENT_USE_ID NUMBER (15)
PARENT_INSTANCE_ID NUMBER (15)
SHIPPING_METHOD VARCHAR2 (240)
ARRIVAL_DATE_TIME DATE

COST NUMBER (15)
AVAILABLE_QUANTITY NUMBER (15)
RETURN_TYPE VARCHAR2 (240)
LOCATION_ID NUMBER (15)
SHIPPING_DISTANCE VARCHAR2 (50)
NEED_BY_DATE DATE

PROJECT_ID NUMBER

PROJECT_TASK_ID NUMBER

EXPENDITURE_ORG_ID NUMBER

Query Text

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


SELECT ESTIMATE_DETAIL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ESTIMATE_ID
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      QUANTITY_REQUIRED
,      UNIT_OF_MEASURE_CODE
,      SELLING_PRICE
,      AFTER_WARRANTY_COST
,      DIAGNOSIS_ID
,      ESTIMATE_BUSINESS_GROUP_ID
,      TRANSACTION_TYPE_ID
,      CUSTOMER_PRODUCT_ID
,      ORDER_HEADER_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      INSTALLED_CP_RETURN_BY_DATE
,      NEW_CP_RETURN_BY_DATE
,      INTERFACE_TO_OE_FLAG
,      ROLLUP_FLAG
,      ADD_TO_ORDER
,      SYSTEM_ID
,      RMA_HEADER_ID
,      RMA_NUMBER
,      RMA_LINE_ID
,      RMA_LINE_NUMBER
,      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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      TECHNICIAN_ID
,      TXN_START_TIME
,      TXN_END_TIME
,      ORGANIZATION_ID
,      COVERAGE_BILL_RATE_ID
,      COVERAGE_BILLING_TYPE_ID
,      TIME_ZONE_ID
,      TXN_BILLING_TYPE_ID
,      BUSINESS_PROCESS_ID
,      INCIDENT_ID
,      ORIGINAL_SOURCE_ID
,      ORIGINAL_SOURCE_CODE
,      SOURCE_ID
,      SOURCE_CODE
,      CONTRACT_ID
,      COVERAGE_ID
,      COVERAGE_TXN_GROUP_ID
,      INVOICE_TO_ORG_ID
,      SHIP_TO_ORG_ID
,      PURCHASE_ORDER_NUM
,      LINE_TYPE_ID
,      LINE_CATEGORY_CODE
,      CURRENCY_CODE
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE_DATE
,      RETURN_REASON_CODE
,      ORDER_LINE_ID
,      PRICE_LIST_HEADER_ID
,      FUNC_CURR_AFT_WARR_COST
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_LINE_REFERENCE
,      ADD_TO_ORDER_FLAG
,      EXCEPTION_COVERAGE_USED
,      TAX_CODE
,      EST_TAX_AMOUNT
,      OBJECT_VERSION_NUMBER
,      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_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
,      PRICING_ATTRIBUTE60
,      SECURITY_GROUP_ID
,      UPGRADED_STATUS_FLAG
,      ORIG_SYSTEM_REFERENCE_ID
,      NO_CHARGE_FLAG
,      ORG_ID
,      ITEM_REVISION
,      TRANS_INV_ORGANIZATION_ID
,      TRANS_SUBINVENTORY
,      ACTIVITY_DATE
,      ACTIVITY_START_TIME
,      ACTIVITY_END_TIME
,      GENERATED_BY_BCA_ENGINE_FLAG
,      TRANSACTION_INVENTORY_ORG
,      TRANSACTION_SUB_INVENTORY
,      ACTIVITY_START_DATE_TIME
,      ACTIVITY_END_DATE_TIME
,      CHARGE_LINE_TYPE
,      SHIP_TO_CONTACT_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_ACCOUNT_ID
,      INVOICE_TO_ACCOUNT_ID
,      LIST_PRICE
,      CONTRACT_DISCOUNT_AMOUNT
,      BILL_TO_PARTY_ID
,      SHIP_TO_PARTY_ID
,      SUBMIT_RESTRICTION_MESSAGE
,      SUBMIT_ERROR_MESSAGE
,      SUBMIT_FROM_SYSTEM
,      LINE_SUBMITTED
,      CONTRACT_LINE_ID
,      RATE_TYPE_CODE
,      INSTRUMENT_PAYMENT_USE_ID
,      PARENT_INSTANCE_ID
,      SHIPPING_METHOD
,      ARRIVAL_DATE_TIME
,      COST
,      AVAILABLE_QUANTITY
,      RETURN_TYPE
,      LOCATION_ID
,      SHIPPING_DISTANCE
,      NEED_BY_DATE
,      PROJECT_ID
,      PROJECT_TASK_ID
,      EXPENDITURE_ORG_ID
FROM CS.CS_ESTIMATE_DETAILS#;

Dependencies

[top of page]

CS.CS_ESTIMATE_DETAILS# references the following:

SchemaCS
TableCS_ESTIMATE_DETAILS
CS.CS_ESTIMATE_DETAILS# is referenced by following:

SchemaAPPS
SynonymCS_ESTIMATE_DETAILS