[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CS_CHARGE_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CS.CS_CHARGE_DETAILS_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 |
|---|---|---|---|---|
| ESTIMATE_DETAIL_ID | NUMBER | (15) | Yes | Unique identifier for the charge record |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ORIGINAL_SOURCE_CODE | VARCHAR2 | (10) | Yes | Original source Code for the charge line eg - Debrief, Depot Repair |
| ORIGINAL_SOURCE_ID | NUMBER | (15) | Yes | Original source ID for the charge line eg - Debrief, Depot Repair |
| ORIGINAL_SOURCE_CODE_MEANING | VARCHAR2 | (80) | Original Source Code Meaning | |
| SOURCE_CODE | VARCHAR2 | (10) | Current Source Code for the charge line eg - Debrief, Depot Repair | |
| SOURCE_ID | NUMBER | (15) | Current source ID for the charge line eg - Debrief, Depot Repair | |
| INCIDENT_ID | NUMBER | (15) | Yes | Unique identifier for service request |
| PARTY_ID | NUMBER | (15) | Party_Id Of Service Request | |
| ACCOUNT_ID | NUMBER | Account_Id Of Service Request | ||
| LINE_NUMBER | NUMBER | Line number of the charge | ||
| INVENTORY_ITEM_ID | NUMBER | (15) | Product used in inventory by the charge line | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial number of the returned product | |
| QUANTITY_REQUIRED | NUMBER | Quantity of the product used | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | UOM of the product | |
| SELLING_PRICE | NUMBER | Selling price of product in Order Management | ||
| AFTER_WARRANTY_COST | NUMBER | Cost after applying contract coverages or manual discounts | ||
| FUNC_CURR_AFT_WARR_COST | NUMBER | Not Used | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Pricing Attributes descriptive flexfield structure defining column | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE16 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE17 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE18 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE19 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE20 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE21 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE22 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE23 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE24 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE25 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE26 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE27 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE28 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE29 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE30 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE31 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE32 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE33 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE34 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE35 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE36 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE37 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE38 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE39 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE40 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE41 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE42 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE43 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE44 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE45 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE46 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE47 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE48 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE49 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE50 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE51 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE52 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE53 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE54 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE55 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE56 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE57 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE58 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE59 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE60 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE61 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE62 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE63 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE64 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE65 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE66 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE67 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE68 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE69 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE70 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE71 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE72 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE73 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE74 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE75 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE76 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE77 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE78 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE79 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE80 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE81 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE82 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE83 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE84 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE85 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE86 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE87 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE88 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE89 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE90 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE91 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE92 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE93 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE94 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE95 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE96 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE97 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE98 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE99 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE100 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| INC_ORG_ID | NUMBER | Service Request Org_Id | ||
| COVERAGE_BILL_RATE_ID | NUMBER | Bill rate for the coverage being used. Only in conjunction with contracts | ||
| EST_TAX_AMOUNT | NUMBER | (15) | Estimated Tax Amount | |
| TAX_CODE | VARCHAR2 | (30) | Tax Codes | |
| BUSINESS_PROCESS_ID | NUMBER | (15) | Yes | Transaction group for the charge |
| BUSINESS_PROCESS_NAME | VARCHAR2 | (90) | Yes | Transaction group name |
| ORDER_TYPE_ID | NUMBER | (15) | Order Type of the transaction group | |
| TTYPE | VARCHAR2 | (90) | Name of the transaction type | |
| MATERIAL_BILLABLE_FLAG | VARCHAR2 | (30) | Billing Flag for the Transaction (e.g. 'M', 'L', or 'E') | |
| MATERIAL_BILLABLE_DESC | VARCHAR2 | (80) | Description of the Material Billabe Flag | |
| TXN_BILLING_TYPE_ID | NUMBER | (15) | ID of the Transaction Billing type on the Charge line | |
| REVISION_FLAG | VARCHAR2 | (1) | Install Base revision flag. Not used in 11.5.6. | |
| CUSTOMER_PRODUCT_ID | NUMBER | (15) | Installed base reference, if any, for the product chosen; needed for certain transactions | |
| ORDER_HEADER_ID | NUMBER | Order Management information for sales order created | ||
| ORDER_LINE_ID | NUMBER | Order Line Information for Sales Order in Order Management | ||
| INSTALLED_CP_RETURN_BY_DATE | DATE | Expected return date for the installed product | ||
| NEW_CP_RETURN_BY_DATE | DATE | Expected return date for the new product | ||
| INTERFACE_TO_OE_FLAG | VARCHAR2 | (1) | Indicates whether line has been interfaced to Order Entry/Shipping for sales order creation | |
| ROLLUP_FLAG | VARCHAR2 | (1) | Indicates whether the item used should be rolled up to an item defined in a profile option for that item type- Material, Labor, Expense | |
| ADD_TO_ORDER_FLAG | VARCHAR2 | (1) | Indicates whether the line is to be added to an existing order or a new order | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | Reason for return | |
| PRICE_LIST_HEADER_ID | NUMBER | Price List identifier | ||
| INVOICE_TO_ORG_ID | NUMBER | (15) | Bill-to Information | |
| SHIP_TO_ORG_ID | NUMBER | (15) | Ship-To Information | |
| LINE_TYPE_ID | NUMBER | (15) | Identifier of Line Type In Order Management | |
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Line Category Code in Order Management . It can have return or Order | |
| LINE_TYPE_NAME | VARCHAR2 | (30) | Line Type Name | |
| PRICE_LIST_NAME | VARCHAR2 | (240) | Price List Name | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| CONVERSION_RATE | NUMBER | Conversion rate | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Conversion type code | |
| CONVERSION_RATE_DATE | DATE | conversion date | ||
| ORDER_NUM | NUMBER | Order Number | ||
| ORDER_DATE | DATE | Order Date | ||
| ORDER_LINE_NUM | NUMBER | Order Line Number | ||
| BILL_TO_ADDRESS | VARCHAR2 | (220) | Bill To Address | |
| BCITY | VARCHAR2 | (60) | Bill To City | |
| BSTATE | VARCHAR2 | (60) | Bill To State | |
| BCOUNTRY | VARCHAR2 | (60) | Bill To Country | |
| BPOSTAL_CODE | VARCHAR2 | (60) | Bill To Postal Code | |
| SHIP_TO_ADDRESS | VARCHAR2 | (220) | Ship To Address | |
| SCITY | VARCHAR2 | (60) | Ship To City | |
| SSTATE | VARCHAR2 | (60) | Ship To State | |
| SCOUNTRY | VARCHAR2 | (60) | Ship To Country | |
| SPOSTAL_CODE | VARCHAR2 | (60) | Ship To Postal Code | |
| CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
| COVERAGE_TXN_GROUP_ID | NUMBER | Coverage Transaction Group Id | ||
| COVERAGE | VARCHAR2 | (150) | Coverage Name | |
| COVERAGE_ID | NUMBER | Coverage identifier | ||
| CONTRACT_ID | NUMBER | Identifier for the contract | ||
| EXCEPTION_COVERAGE_USED | VARCHAR2 | (1) | Flag to Indicate if exception coverage is Used | |
| RATE_TYPE | VARCHAR2 | (4000) | Rate Type | |
| CUST_PO_NUMBER | VARCHAR2 | (50) | Purchase Order Number | |
| OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
| NO_CHARGE_FLAG | VARCHAR2 | (1) | No Charge Flag, This flag indicates a zero charge for this row. | |
| ORG_ID | NUMBER | Billing Operating Unit of the Charge line. | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item revision from Inventory. Only used when the Item is revision controlled. | |
| TRANSACTION_INVENTORY_ORG | NUMBER | Transaction Inventory Org (Warehouse) to ship the item from | ||
| TRANSACTION_SUB_INVENTORY | VARCHAR2 | (10) | Not Used | |
| CHARGE_LINE_TYPE | VARCHAR2 | (30) | Charge Line Type | |
| BILL_TO_CONTACT_ID | NUMBER | Bill to Contact for the selected Bill to Party Site | ||
| SHIP_TO_CONTACT_ID | NUMBER | Ship to Contact for the selected Ship to Party Site | ||
| INVOICE_TO_ACCOUNT_ID | NUMBER | Bill to Account for the Order in OM | ||
| SHIP_TO_ACCOUNT_ID | NUMBER | Ship to Account for the Order in OM | ||
| LIST_PRICE | NUMBER | List Price (per unit) as calculate from the Price list | ||
| CONTRACT_DISCOUNT_AMOUNT | NUMBER | Amount discounted by the contract from the list price | ||
| BILL_TO_PARTY_ID | NUMBER | Bil to Party Id of the Charge line | ||
| SHIP_TO_PARTY_ID | NUMBER | Ship to Party Id of the Charge line | ||
| TRANSACTION_TYPE_ID | NUMBER | Transaction Type Id for the Charge Line. This is a FK to CS_TRANSACTION_TYPES.transaction_type_id. | ||
| GENERATED_BY_BCA_ENGINE_FLAG | VARCHAR2 | (1) | Indicates Charge line was created by the Auto Charges API. | |
| ACTIVITY_START_DATE_TIME | DATE | Labor Activity Start Datetime | ||
| ACTIVITY_END_DATE_TIME | DATE | Labor Activity End Datetime | ||
| SUBMIT_RESTRICTION_MESSAGE | VARCHAR2 | (2000) | Auto Submission Restriction Message | |
| SUBMIT_ERROR_MESSAGE | VARCHAR2 | (2000) | Submit to Sales Order Error Message | |
| SUBMIT_FROM_SYSTEM | VARCHAR2 | (30) | System used to submit the charge line | |
| LINE_SUBMITTED | VARCHAR2 | (1) | Charge line has been submitted | |
| LINE_STATUS | VARCHAR2 | (10) | Line Status | |
| TOTAL_ESTIMATE | NUMBER | Total Estimate | ||
| TOTAL_UNSUBMITTED | NUMBER | Total Unsubmitted | ||
| TOTAL_SUBMITTED | NUMBER | Total Submitted | ||
| LINE_STATUS_MEANING | VARCHAR2 | (80) | Line Status Meaning | |
| CONTRACT_LINE_ID | NUMBER | |||
| RATE_TYPE_CODE | VARCHAR2 | (40) | ||
| INSTRUMENT_PAYMENT_USE_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) | ||
| PARENT_INSTANCE_ID | NUMBER | (15) |
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
, ORIGINAL_SOURCE_CODE
, ORIGINAL_SOURCE_ID
, ORIGINAL_SOURCE_CODE_MEANING
, SOURCE_CODE
, SOURCE_ID
, INCIDENT_ID
, PARTY_ID
, ACCOUNT_ID
, LINE_NUMBER
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, QUANTITY_REQUIRED
, UNIT_OF_MEASURE_CODE
, SELLING_PRICE
, AFTER_WARRANTY_COST
, FUNC_CURR_AFT_WARR_COST
, 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
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INC_ORG_ID
, COVERAGE_BILL_RATE_ID
, EST_TAX_AMOUNT
, TAX_CODE
, BUSINESS_PROCESS_ID
, BUSINESS_PROCESS_NAME
, ORDER_TYPE_ID
, TTYPE
, MATERIAL_BILLABLE_FLAG
, MATERIAL_BILLABLE_DESC
, TXN_BILLING_TYPE_ID
, REVISION_FLAG
, CUSTOMER_PRODUCT_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, INSTALLED_CP_RETURN_BY_DATE
, NEW_CP_RETURN_BY_DATE
, INTERFACE_TO_OE_FLAG
, ROLLUP_FLAG
, ADD_TO_ORDER_FLAG
, RETURN_REASON_CODE
, PRICE_LIST_HEADER_ID
, INVOICE_TO_ORG_ID
, SHIP_TO_ORG_ID
, LINE_TYPE_ID
, LINE_CATEGORY_CODE
, LINE_TYPE_NAME
, PRICE_LIST_NAME
, CURRENCY_CODE
, CONVERSION_RATE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE
, ORDER_NUM
, ORDER_DATE
, ORDER_LINE_NUM
, BILL_TO_ADDRESS
, BCITY
, BSTATE
, BCOUNTRY
, BPOSTAL_CODE
, SHIP_TO_ADDRESS
, SCITY
, SSTATE
, SCOUNTRY
, SPOSTAL_CODE
, CONTRACT_NUMBER
, COVERAGE_TXN_GROUP_ID
, COVERAGE
, COVERAGE_ID
, CONTRACT_ID
, EXCEPTION_COVERAGE_USED
, RATE_TYPE
, CUST_PO_NUMBER
, OBJECT_VERSION_NUMBER
, NO_CHARGE_FLAG
, ORG_ID
, ITEM_REVISION
, TRANSACTION_INVENTORY_ORG
, TRANSACTION_SUB_INVENTORY
, CHARGE_LINE_TYPE
, BILL_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID
, INVOICE_TO_ACCOUNT_ID
, SHIP_TO_ACCOUNT_ID
, LIST_PRICE
, CONTRACT_DISCOUNT_AMOUNT
, BILL_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, TRANSACTION_TYPE_ID
, GENERATED_BY_BCA_ENGINE_FLAG
, ACTIVITY_START_DATE_TIME
, ACTIVITY_END_DATE_TIME
, SUBMIT_RESTRICTION_MESSAGE
, SUBMIT_ERROR_MESSAGE
, SUBMIT_FROM_SYSTEM
, LINE_SUBMITTED
, LINE_STATUS
, TOTAL_ESTIMATE
, TOTAL_UNSUBMITTED
, TOTAL_SUBMITTED
, LINE_STATUS_MEANING
, CONTRACT_LINE_ID
, RATE_TYPE_CODE
, INSTRUMENT_PAYMENT_USE_ID
, SHIPPING_METHOD
, ARRIVAL_DATE_TIME
, COST
, AVAILABLE_QUANTITY
, RETURN_TYPE
, LOCATION_ID
, PARENT_INSTANCE_ID
FROM APPS.CS_CHARGE_DETAILS_V;
APPS
CS_BUSINESS_PROCESSES
CS_ESTIMATE_DETAILS
CS_INCIDENTS_ALL_B
CS_LOOKUPS
CS_TRANSACTION_TYPES_B
CS_TRANSACTION_TYPES_TL
CS_TXN_BILLING_OETXN_ALL
CS_TXN_BILLING_TYPES
FND_GLOBAL
- show dependent code
HZ_LOCATIONS
HZ_PARTY_SITES
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_TRANSACTION_TYPES_TL
OKC_K_HEADERS_ALL_B
OKC_K_LINES_TL
OKS_ENT_BILL_RATES_V
OKS_ENT_UTIL_PVT
- show dependent code
QP_LIST_HEADERS_TL
APPS.CS_CHARGE_DETAILS_V is not referenced by any database object
|
|
|
|