View: CSD_REPAIR_ESTIMATE_LINES_V

Product:	CSD - Depot Repair
Description:	Fetches all the estimate lines for repair orders.
Implementation/DBA Data:	APPS.CSD_REPAIR_ESTIMATE_LINES_V

View Text

SELECT CREL.ROWID
, CR.REPAIR_LINE_ID
, CR.REPAIR_NUMBER
, CRE.REPAIR_ESTIMATE_ID
, CREL.REPAIR_ESTIMATE_LINE_ID
, CED.ESTIMATE_DETAIL_ID
, CR.AUTO_PROCESS_RMA
, CR.REPAIR_MODE
, CR.REPAIR_TYPE_ID
, CR.INCIDENT_ID
, CED.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS PRODUCT
, MSI.DESCRIPTION
, CREL.CREATED_BY
, CREL.CREATION_DATE
, CREL.LAST_UPDATED_BY
, CREL.LAST_UPDATE_DATE
, CREL.LAST_UPDATE_LOGIN
, CREL.OBJECT_VERSION_NUMBER
, CED.UNIT_OF_MEASURE_CODE
, UOM.UNIT_OF_MEASURE_TL
, CED.QUANTITY_REQUIRED ESTIMATE_QUANTITY
, CR.QUANTITY REPAIR_QUANTITY
, CED.CUSTOMER_PRODUCT_ID
, CED.SERIAL_NUMBER
, CR.APPROVAL_REQUIRED_FLAG
, CR.APPROVAL_STATUS
, CR.STATUS
, CR.PROMISE_DATE
, CREL.CONTEXT
, CREL.ATTRIBUTE1
, CREL.ATTRIBUTE2
, CREL.ATTRIBUTE3
, CREL.ATTRIBUTE4
, CREL.ATTRIBUTE5
, CREL.ATTRIBUTE6
, CREL.ATTRIBUTE7
, CREL.ATTRIBUTE8
, CREL.ATTRIBUTE9
, CREL.ATTRIBUTE10
, CREL.ATTRIBUTE11
, CREL.ATTRIBUTE12
, CREL.ATTRIBUTE13
, CREL.ATTRIBUTE14
, CREL.ATTRIBUTE15
, CED.PRICE_LIST_HEADER_ID
, QP.NAME PRICE_LIST
, STT.NAME TRANSACTION_TYPE
, SBT.BILLING_TYPE
, CSL.MEANING BILLING_TYPE_MEANING
, CBTC.BILLING_CATEGORY
, CED.TXN_BILLING_TYPE_ID
, CED.ORDER_HEADER_ID
, CED.ORDER_LINE_ID
, CED.RETURN_REASON_CODE
, OKH.CONTRACT_NUMBER
, CED.CONTRACT_ID
, CED.INVOICE_TO_ORG_ID
, CED.SELLING_PRICE
, CED.NO_CHARGE_FLAG
, CED.BUSINESS_PROCESS_ID
, MSI.LOT_CONTROL_CODE
, MSI.SERIAL_NUMBER_CONTROL_CODE
, CED.AFTER_WARRANTY_COST CHARGE
, DECODE(CED.AFTER_WARRANTY_COST
, NULL
, NULL
, 0
, NULL
, (CED.AFTER_WARRANTY_COST - (NVL(ABS(CED.QUANTITY_REQUIRED)
, 0) * NVL(CREL.ITEM_COST
, 0)))/(NVL( CED.AFTER_WARRANTY_COST
, 1))*100) PROFIT_MARGIN_PERCENTAGE
, DECODE(CREL.ITEM_COST
, NULL
, NULL
, 0
, NULL
, (CED.AFTER_WARRANTY_COST - (NVL(ABS(CED.QUANTITY_REQUIRED)
, 0) * NVL(CREL.ITEM_COST
, 0)))) PROFIT_MARGIN
, CREL.ITEM_COST
, CRE.ESTIMATE_DATE
, CRE.ESTIMATE_STATUS
, CED.PURCHASE_ORDER_NUM PO_NUMBER
, CED.COVERAGE_BILL_RATE_ID COVERAGE_RATE_ID
, CED.COVERAGE_BILLING_TYPE_ID COVERAGE_TYPE_ID
, CREL.JUSTIFICATION_NOTES
, CED.CURRENCY_CODE
, CIA.INCIDENT_NUMBER
, CED.RMA_NUMBER
, CED.TRANSACTION_TYPE_ID
, CED.ORIGINAL_SOURCE_ID
, CED.ORIGINAL_SOURCE_CODE
, CED.SOURCE_ID
, CED.SOURCE_CODE
, CED.LINE_TYPE_ID
, CED.ITEM_REVISION
, CED.LINE_CATEGORY_CODE
, CED.COVERAGE_ID
, CED.COVERAGE_TXN_GROUP_ID
, CED.ORGANIZATION_ID
, CED.SHIP_TO_ORG_ID
, CED.INTERFACE_TO_OE_FLAG
, CED.INSTALLED_CP_RETURN_BY_DATE
, CREL.RESOURCE_ID
, DECODE(CREL.RESOURCE_ID
, NULL
, NULL
, (SELECT RESOURCE_CODE
FROM BOM_RESOURCES_V
WHERE RESOURCE_ID = CREL.RESOURCE_ID
AND ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID)) RESOURCE_CODE
, NVL(CREL.OVERRIDE_CHARGE_FLAG
, 'N')
, CREL.EST_LINE_SOURCE_TYPE_CODE EST_LINE_SOURCE_TYPE_CODE
, FNDL.MEANING EST_LINE_SOURCE_DESC
, CREL.EST_LINE_SOURCE_ID1 EST_LINE_SOURCE_ID1
, DECODE(EST_LINE_SOURCE_TYPE_CODE
, 'SERVICE_CODE'
, CSC.NAME
, 'SOLUTION'
, KB.NAME
, NULL) EST_LINE_SOURCE_NAME1
, CREL.EST_LINE_SOURCE_ID2 EST_LINE_SOURCE_ID2
, NULL EST_LINE_SOURCE_NAME2
, CREL.RO_SERVICE_CODE_ID RO_SERVICE_CODE_ID
, CED.PRICING_CONTEXT
, CED.PRICING_ATTRIBUTE1
, CED.PRICING_ATTRIBUTE2
, CED.PRICING_ATTRIBUTE3
, CED.PRICING_ATTRIBUTE4
, CED.PRICING_ATTRIBUTE5
, CED.PRICING_ATTRIBUTE6
, CED.PRICING_ATTRIBUTE7
, CED.PRICING_ATTRIBUTE8
, CED.PRICING_ATTRIBUTE9
, CED.PRICING_ATTRIBUTE10
, CED.PRICING_ATTRIBUTE11
, CED.PRICING_ATTRIBUTE12
, CED.PRICING_ATTRIBUTE13
, CED.PRICING_ATTRIBUTE14
, CED.PRICING_ATTRIBUTE15
, CED.PRICING_ATTRIBUTE16
, CED.PRICING_ATTRIBUTE17
, CED.PRICING_ATTRIBUTE18
, CED.PRICING_ATTRIBUTE19
, CED.PRICING_ATTRIBUTE20
, CED.PRICING_ATTRIBUTE21
, CED.PRICING_ATTRIBUTE22
, CED.PRICING_ATTRIBUTE23
, CED.PRICING_ATTRIBUTE24
, CED.PRICING_ATTRIBUTE25
, CED.PRICING_ATTRIBUTE26
, CED.PRICING_ATTRIBUTE27
, CED.PRICING_ATTRIBUTE28
, CED.PRICING_ATTRIBUTE29
, CED.PRICING_ATTRIBUTE30
, CED.PRICING_ATTRIBUTE31
, CED.PRICING_ATTRIBUTE32
, CED.PRICING_ATTRIBUTE33
, CED.PRICING_ATTRIBUTE34
, CED.PRICING_ATTRIBUTE35
, CED.PRICING_ATTRIBUTE36
, CED.PRICING_ATTRIBUTE37
, CED.PRICING_ATTRIBUTE38
, CED.PRICING_ATTRIBUTE39
, CED.PRICING_ATTRIBUTE40
, CED.PRICING_ATTRIBUTE41
, CED.PRICING_ATTRIBUTE42
, CED.PRICING_ATTRIBUTE43
, CED.PRICING_ATTRIBUTE44
, CED.PRICING_ATTRIBUTE45
, CED.PRICING_ATTRIBUTE46
, CED.PRICING_ATTRIBUTE47
, CED.PRICING_ATTRIBUTE48
, CED.PRICING_ATTRIBUTE49
, CED.PRICING_ATTRIBUTE50
, CED.PRICING_ATTRIBUTE51
, CED.PRICING_ATTRIBUTE52
, CED.PRICING_ATTRIBUTE53
, CED.PRICING_ATTRIBUTE54
, CED.PRICING_ATTRIBUTE55
, CED.PRICING_ATTRIBUTE56
, CED.PRICING_ATTRIBUTE57
, CED.PRICING_ATTRIBUTE58
, CED.PRICING_ATTRIBUTE59
, CED.PRICING_ATTRIBUTE60
, CED.PRICING_ATTRIBUTE61
, CED.PRICING_ATTRIBUTE62
, CED.PRICING_ATTRIBUTE63
, CED.PRICING_ATTRIBUTE64
, CED.PRICING_ATTRIBUTE65
, CED.PRICING_ATTRIBUTE66
, CED.PRICING_ATTRIBUTE67
, CED.PRICING_ATTRIBUTE68
, CED.PRICING_ATTRIBUTE69
, CED.PRICING_ATTRIBUTE70
, CED.PRICING_ATTRIBUTE71
, CED.PRICING_ATTRIBUTE72
, CED.PRICING_ATTRIBUTE73
, CED.PRICING_ATTRIBUTE74
, CED.PRICING_ATTRIBUTE75
, CED.PRICING_ATTRIBUTE76
, CED.PRICING_ATTRIBUTE77
, CED.PRICING_ATTRIBUTE78
, CED.PRICING_ATTRIBUTE79
, CED.PRICING_ATTRIBUTE80
, CED.PRICING_ATTRIBUTE81
, CED.PRICING_ATTRIBUTE82
, CED.PRICING_ATTRIBUTE83
, CED.PRICING_ATTRIBUTE84
, CED.PRICING_ATTRIBUTE85
, CED.PRICING_ATTRIBUTE86
, CED.PRICING_ATTRIBUTE87
, CED.PRICING_ATTRIBUTE88
, CED.PRICING_ATTRIBUTE89
, CED.PRICING_ATTRIBUTE90
, CED.PRICING_ATTRIBUTE91
, CED.PRICING_ATTRIBUTE92
, CED.PRICING_ATTRIBUTE93
, CED.PRICING_ATTRIBUTE94
, CED.PRICING_ATTRIBUTE95
, CED.PRICING_ATTRIBUTE96
, CED.PRICING_ATTRIBUTE97
, CED.PRICING_ATTRIBUTE98
, CED.PRICING_ATTRIBUTE99
, CED.PRICING_ATTRIBUTE100
, CED.CONTRACT_DISCOUNT_AMOUNT
, CED.CONTRACT_LINE_ID CONTRACT_LINE_ID
FROM CSD_REPAIRS CR
, CS_INCIDENTS_B_SEC CIA
, CS_ESTIMATE_DETAILS CED
, CSD_REPAIR_ESTIMATE CRE
, CSD_REPAIR_ESTIMATE_LINES CREL
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_UNITS_OF_MEASURE_VL UOM
, CS_TRANSACTION_TYPES_VL STT
, CS_TXN_BILLING_TYPES SBT
, QP_LIST_HEADERS_TL QP
, OKC_K_HEADERS_B OKH
, CSD_SERVICE_CODES_VL CSC
, FND_LOOKUPS FNDL
, CS_KB_SETS_VL KB
, CS_BILLING_TYPE_CATEGORIES CBTC
, CS_LOOKUPS CSL
WHERE CR.INCIDENT_ID = CIA.INCIDENT_ID
AND CR.REPAIR_LINE_ID = CRE.REPAIR_LINE_ID
AND CRE.REPAIR_ESTIMATE_ID = CREL.REPAIR_ESTIMATE_ID
AND CREL.ESTIMATE_DETAIL_ID = CED.ESTIMATE_DETAIL_ID
AND CED.ORIGINAL_SOURCE_CODE = 'DR'
AND CED.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CED.UNIT_OF_MEASURE_CODE = UOM.UOM_CODE
AND CED.PRICE_LIST_HEADER_ID = QP.LIST_HEADER_ID(+)
AND QP.LANGUAGE(+) = USERENV('LANG')
AND CED.CONTRACT_ID = OKH.ID(+)
AND SBT.TXN_BILLING_TYPE_ID = CED.TXN_BILLING_TYPE_ID
AND SBT.TRANSACTION_TYPE_ID = STT.TRANSACTION_TYPE_ID
AND CREL.EST_LINE_SOURCE_TYPE_CODE = FNDL.LOOKUP_CODE
AND FNDL.LOOKUP_TYPE = 'CSD_SOURCE_TYPE'
AND CREL.EST_LINE_SOURCE_ID1 = CSC.SERVICE_CODE_ID(+)
AND CREL.EST_LINE_SOURCE_ID1 =KB.SET_ID(+)
AND CED.CHARGE_LINE_TYPE = 'ESTIMATE'
AND CSL.LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
AND CSL.LOOKUP_CODE = CBTC.BILLING_TYPE
AND CBTC.BILLING_TYPE = SBT.BILLING_TYPE

Columns