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


VIEW: APPS.CSD_REPAIR_ESTIMATE_LINES_V

Object Details
Object Name: CSD_REPAIR_ESTIMATE_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSD.CSD_REPAIR_ESTIMATE_LINES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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.

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.CSD_REPAIR_ESTIMATE_LINES_V references the following:

SchemaAPPS
ViewBOM_RESOURCES_V
SynonymCSD_REPAIRS
SynonymCSD_REPAIR_ESTIMATE
SynonymCSD_REPAIR_ESTIMATE_LINES
ViewCSD_SERVICE_CODES_VL
SynonymCS_BILLING_TYPE_CATEGORIES
SynonymCS_ESTIMATE_DETAILS
ViewCS_INCIDENTS_B_SEC
ViewCS_KB_SETS_VL
ViewCS_LOOKUPS
PL/SQL PackageCS_STD - show dependent code
ViewCS_TRANSACTION_TYPES_VL
SynonymCS_TXN_BILLING_TYPES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewMTL_SYSTEM_ITEMS_VL
ViewMTL_UNITS_OF_MEASURE_VL
SynonymOKC_K_HEADERS_B
SynonymQP_LIST_HEADERS_TL
SynonymWIP_ENTITIES
APPS.CSD_REPAIR_ESTIMATE_LINES_V is referenced by following:

SchemaAPPS
Package BodyCSD_REPAIR_ESTIMATE_PVT - show dependent code
Package BodyCSD_WIP_JOB_PVT - show dependent code