VIEW: APPS.CSD_REPAIR_ACTUAL_LINES_V

Source

View Text - Preformatted

SELECT cral.ROWID , cral.repair_actual_line_id , cral.object_version_number , cr.repair_line_id , cra.repair_actual_id , ced.estimate_detail_id , cral.created_by , cral.creation_date , cral.last_updated_by , cral.last_update_date , cral.last_update_login , cr.repair_number , cral.override_charge_flag , cral.actual_source_code , cral.actual_source_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 , 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 , ced.price_list_header_id , qp.name price_list , stt.name transaction_type , sbt.billing_type , csl1.meaning billing_type_meaning , 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.serial_number_control_code , ced.after_warranty_cost charge ,decode(cral.item_cost,NULL,NULL,0,NULL, (ced.after_warranty_cost - (NVL(abs(ced.quantity_required),0) * NVL(cral.item_cost,0)))) profit_margin ,decode(cral.item_cost,NULL,NULL,0,NULL, (ced.after_warranty_cost - (NVL(abs(ced.quantity_required),0) * NVL(cral.item_cost,0)))/(nvl(abs(ced.quantity_required),0)*nvl(cral.item_cost,0)*100)) profit_margin_percentage , cral.item_cost , ced.purchase_order_num po_number , ced.coverage_bill_rate_id coverage_rate_id , null coverage_type_id , cral.justification_notes , ced.currency_code , cia.incident_number , null 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 , cral.resource_id , decode(cral.resource_id, NULL, NULL, (select resource_code from bom_resources_v where resource_id = cral.resource_id and organization_id = cs_std.get_item_valdn_orgzn_id)) resource_code , msi.lot_control_code , ced.contract_line_id contract_line_id , oeh.order_number , oel.line_number order_line_number , cbtc.billing_category , csl.meaning billing_category_meaning , cral.lot_number lot_number , flv.meaning actual_source_meaning , cral.attribute_category , cral.attribute1 , cral.attribute2 , cral.attribute3 , cral.attribute4 , cral.attribute5 , cral.attribute6 , cral.attribute7 , cral.attribute8 , cral.attribute9 , cral.attribute10 , cral.attribute11 , cral.attribute12 , cral.attribute13 , cral.attribute14 , cral.attribute15 , cral.locator_id , cral.loc_segment1 , cral.loc_segment2 , cral.loc_segment3 , cral.loc_segment4 , cral.loc_segment5 , cral.loc_segment6 , cral.loc_segment7 , cral.loc_segment8 , cral.loc_segment9 , cral.loc_segment10 , cral.loc_segment11 , cral.loc_segment12 , cral.loc_segment13 , cral.loc_segment14 , cral.loc_segment15 , cral.loc_segment16 , cral.loc_segment17 , cral.loc_segment18 , cral.loc_segment19 , cral.loc_segment20 , 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.invoice_to_account_id , hca.account_number , hca.account_name , ced.bill_to_party_id , hz.party_number , hz.party_name , substr(hl1.address1||' '||hl1.address2||' '||hl1.address3||' '||hl1.address4 ||' '|| hl1.city||' '||hl1.state||' '||hl1.country||' '||hl1.postal_code, 1,440) bill_to_party_site , cral.warranty_claim_flag , cral.warranty_number , cral.warranty_status_code , fndl2.meaning warranty_status_meaning , cral.replaced_item_id , msi1.concatenated_segments FROM csd_repairs cr , cs_incidents_all_b cia , cs_estimate_details ced , csd_repair_actuals cra , csd_repair_actual_lines cral , oe_order_headers_all oeh , oe_order_lines_all oel , 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 , cs_lookups csl , fnd_lookups flv , cs_billing_type_categories cbtc , cs_lookups csl1 , hz_cust_accounts hca , hz_parties hz , hz_party_sites hp1 , hz_locations hl1 , fnd_lookups fndl2 , mtl_system_items_vl msi1 WHERE cr.incident_id = cia.incident_id AND cr.repair_line_id = cra.repair_line_id AND cra.repair_actual_id = cral.repair_actual_id AND cral.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 ced.order_header_id = oeh.header_id(+) AND ced.order_line_id = oel.line_id(+) AND csl.lookup_type = 'CS_BILLING_CATEGORY' AND csl.lookup_code = cbtc.billing_category AND csl1.lookup_type = 'MTL_SERVICE_BILLABLE_FLAG' AND csl1.lookup_code = cbtc.billing_type AND sbt.billing_type = cbtc.billing_type AND csl.enabled_flag = 'Y' AND trunc(sysdate) between trunc(nvl(csl.start_date_active,sysdate)) and trunc(nvl(csl.end_date_active,sysdate)) AND flv.lookup_code = cral.actual_source_code AND flv.lookup_type = 'CSD_SOURCE_TYPE' AND flv.enabled_flag = 'Y' AND trunc(sysdate) between trunc(nvl(flv.start_date_active,sysdate)) and trunc(nvl(flv.end_date_active,sysdate)) and hca.cust_account_id (+) = ced.invoice_to_account_id and hz.party_id (+) = ced.bill_to_party_id and hp1.party_site_id(+) = ced.invoice_to_org_id and hp1.location_id = hl1.location_id(+) and cral.warranty_status_code = fndl2.lookup_code(+) and fndl2.lookup_type(+) = 'CSD_WARRANTY_STATUS' and cral.replaced_item_id = msi1.inventory_item_id(+) and msi1.organization_id(+) = cs_std.get_item_valdn_orgzn_id

View Text - HTML Formatted

SELECT CRAL.ROWID
, CRAL.REPAIR_ACTUAL_LINE_ID
, CRAL.OBJECT_VERSION_NUMBER
, CR.REPAIR_LINE_ID
, CRA.REPAIR_ACTUAL_ID
, CED.ESTIMATE_DETAIL_ID
, CRAL.CREATED_BY
, CRAL.CREATION_DATE
, CRAL.LAST_UPDATED_BY
, CRAL.LAST_UPDATE_DATE
, CRAL.LAST_UPDATE_LOGIN
, CR.REPAIR_NUMBER
, CRAL.OVERRIDE_CHARGE_FLAG
, CRAL.ACTUAL_SOURCE_CODE
, CRAL.ACTUAL_SOURCE_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
, 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
, CED.PRICE_LIST_HEADER_ID
, QP.NAME PRICE_LIST
, STT.NAME TRANSACTION_TYPE
, SBT.BILLING_TYPE
, CSL1.MEANING BILLING_TYPE_MEANING
, 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.SERIAL_NUMBER_CONTROL_CODE
, CED.AFTER_WARRANTY_COST CHARGE
, DECODE(CRAL.ITEM_COST
, NULL
, NULL
, 0
, NULL
, (CED.AFTER_WARRANTY_COST - (NVL(ABS(CED.QUANTITY_REQUIRED)
, 0) * NVL(CRAL.ITEM_COST
, 0)))) PROFIT_MARGIN
, DECODE(CRAL.ITEM_COST
, NULL
, NULL
, 0
, NULL
, (CED.AFTER_WARRANTY_COST - (NVL(ABS(CED.QUANTITY_REQUIRED)
, 0) * NVL(CRAL.ITEM_COST
, 0)))/(NVL(ABS(CED.QUANTITY_REQUIRED)
, 0)*NVL(CRAL.ITEM_COST
, 0)*100)) PROFIT_MARGIN_PERCENTAGE
, CRAL.ITEM_COST
, CED.PURCHASE_ORDER_NUM PO_NUMBER
, CED.COVERAGE_BILL_RATE_ID COVERAGE_RATE_ID
, NULL COVERAGE_TYPE_ID
, CRAL.JUSTIFICATION_NOTES
, CED.CURRENCY_CODE
, CIA.INCIDENT_NUMBER
, NULL 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
, CRAL.RESOURCE_ID
, DECODE(CRAL.RESOURCE_ID
, NULL
, NULL
, (SELECT RESOURCE_CODE
FROM BOM_RESOURCES_V
WHERE RESOURCE_ID = CRAL.RESOURCE_ID
AND ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID)) RESOURCE_CODE
, MSI.LOT_CONTROL_CODE
, CED.CONTRACT_LINE_ID CONTRACT_LINE_ID
, OEH.ORDER_NUMBER
, OEL.LINE_NUMBER ORDER_LINE_NUMBER
, CBTC.BILLING_CATEGORY
, CSL.MEANING BILLING_CATEGORY_MEANING
, CRAL.LOT_NUMBER LOT_NUMBER
, FLV.MEANING ACTUAL_SOURCE_MEANING
, CRAL.ATTRIBUTE_CATEGORY
, CRAL.ATTRIBUTE1
, CRAL.ATTRIBUTE2
, CRAL.ATTRIBUTE3
, CRAL.ATTRIBUTE4
, CRAL.ATTRIBUTE5
, CRAL.ATTRIBUTE6
, CRAL.ATTRIBUTE7
, CRAL.ATTRIBUTE8
, CRAL.ATTRIBUTE9
, CRAL.ATTRIBUTE10
, CRAL.ATTRIBUTE11
, CRAL.ATTRIBUTE12
, CRAL.ATTRIBUTE13
, CRAL.ATTRIBUTE14
, CRAL.ATTRIBUTE15
, CRAL.LOCATOR_ID
, CRAL.LOC_SEGMENT1
, CRAL.LOC_SEGMENT2
, CRAL.LOC_SEGMENT3
, CRAL.LOC_SEGMENT4
, CRAL.LOC_SEGMENT5
, CRAL.LOC_SEGMENT6
, CRAL.LOC_SEGMENT7
, CRAL.LOC_SEGMENT8
, CRAL.LOC_SEGMENT9
, CRAL.LOC_SEGMENT10
, CRAL.LOC_SEGMENT11
, CRAL.LOC_SEGMENT12
, CRAL.LOC_SEGMENT13
, CRAL.LOC_SEGMENT14
, CRAL.LOC_SEGMENT15
, CRAL.LOC_SEGMENT16
, CRAL.LOC_SEGMENT17
, CRAL.LOC_SEGMENT18
, CRAL.LOC_SEGMENT19
, CRAL.LOC_SEGMENT20
, 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.INVOICE_TO_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
, HCA.ACCOUNT_NAME
, CED.BILL_TO_PARTY_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, SUBSTR(HL1.ADDRESS1||' '||HL1.ADDRESS2||' '||HL1.ADDRESS3||' '||HL1.ADDRESS4 ||' '|| HL1.CITY||' '||HL1.STATE||' '||HL1.COUNTRY||' '||HL1.POSTAL_CODE
, 1
, 440) BILL_TO_PARTY_SITE
, CRAL.WARRANTY_CLAIM_FLAG
, CRAL.WARRANTY_NUMBER
, CRAL.WARRANTY_STATUS_CODE
, FNDL2.MEANING WARRANTY_STATUS_MEANING
, CRAL.REPLACED_ITEM_ID
, MSI1.CONCATENATED_SEGMENTS
FROM CSD_REPAIRS CR
, CS_INCIDENTS_ALL_B CIA
, CS_ESTIMATE_DETAILS CED
, CSD_REPAIR_ACTUALS CRA
, CSD_REPAIR_ACTUAL_LINES CRAL
, OE_ORDER_HEADERS_ALL OEH
, OE_ORDER_LINES_ALL OEL
, 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
, CS_LOOKUPS CSL
, FND_LOOKUPS FLV
, CS_BILLING_TYPE_CATEGORIES CBTC
, CS_LOOKUPS CSL1
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HZ
, HZ_PARTY_SITES HP1
, HZ_LOCATIONS HL1
, FND_LOOKUPS FNDL2
, MTL_SYSTEM_ITEMS_VL MSI1
WHERE CR.INCIDENT_ID = CIA.INCIDENT_ID
AND CR.REPAIR_LINE_ID = CRA.REPAIR_LINE_ID
AND CRA.REPAIR_ACTUAL_ID = CRAL.REPAIR_ACTUAL_ID
AND CRAL.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 CED.ORDER_HEADER_ID = OEH.HEADER_ID(+)
AND CED.ORDER_LINE_ID = OEL.LINE_ID(+)
AND CSL.LOOKUP_TYPE = 'CS_BILLING_CATEGORY'
AND CSL.LOOKUP_CODE = CBTC.BILLING_CATEGORY
AND CSL1.LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
AND CSL1.LOOKUP_CODE = CBTC.BILLING_TYPE
AND SBT.BILLING_TYPE = CBTC.BILLING_TYPE
AND CSL.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(CSL.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(CSL.END_DATE_ACTIVE
, SYSDATE))
AND FLV.LOOKUP_CODE = CRAL.ACTUAL_SOURCE_CODE
AND FLV.LOOKUP_TYPE = 'CSD_SOURCE_TYPE'
AND FLV.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(FLV.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(FLV.END_DATE_ACTIVE
, SYSDATE))
AND HCA.CUST_ACCOUNT_ID (+) = CED.INVOICE_TO_ACCOUNT_ID
AND HZ.PARTY_ID (+) = CED.BILL_TO_PARTY_ID
AND HP1.PARTY_SITE_ID(+) = CED.INVOICE_TO_ORG_ID
AND HP1.LOCATION_ID = HL1.LOCATION_ID(+)
AND CRAL.WARRANTY_STATUS_CODE = FNDL2.LOOKUP_CODE(+)
AND FNDL2.LOOKUP_TYPE(+) = 'CSD_WARRANTY_STATUS'
AND CRAL.REPLACED_ITEM_ID = MSI1.INVENTORY_ITEM_ID(+)
AND MSI1.ORGANIZATION_ID(+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID