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


VIEW: APPS.CS_CHARGE_DETAILS_V

Object Details
Object Name: CS_CHARGE_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_CHARGE_DETAILS_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
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)
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
,      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
FROM APPS.CS_CHARGE_DETAILS_V;

Dependencies

[top of page]

APPS.CS_CHARGE_DETAILS_V references the following:

SchemaAPPS
SynonymCS_BUSINESS_PROCESSES
SynonymCS_ESTIMATE_DETAILS
SynonymCS_INCIDENTS_ALL_B
ViewCS_LOOKUPS
SynonymCS_TRANSACTION_TYPES_B
SynonymCS_TRANSACTION_TYPES_TL
SynonymCS_TXN_BILLING_OETXN_ALL
SynonymCS_TXN_BILLING_TYPES
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_TRANSACTION_TYPES_TL
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_LINES_TL
ViewOKS_ENT_BILL_RATES_V
PL/SQL PackageOKS_ENT_UTIL_PVT - show dependent code
SynonymQP_LIST_HEADERS_TL

APPS.CS_CHARGE_DETAILS_V is not referenced by any database object