[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKS_K_LINES_B |
|---|---|
| Object Type: | TABLE |
| Owner: | OKS |
| FND Design Data: |  OKS.OKS_K_LINES_B
|
| Subobject Name: | |
| Status: | VALID |
Information specific to Service Contracts lines, are stored as a single row, for each Service contract line & sub line in OKS_K_LINES_B.
All information related to Contract Lines is stored in tables OKC_K_LINES_B & OKS_K_LINES_B. There is a mandatory one-to-one mapping between the two tables.
OKS_K_LINES_B.cle_id = OKC_K_LINES_B.id
OKS_K_LINES_B maps to OKS_K_HEADERS_B in the following way
OKS_K_LINES_B.dnz_chr_id = OKS_K_HEADERS_B.chr_id
With OKC_K_HEADERS_B
OKS_K_HEADERS_B.chr_id = OKC_K_HEADERS_B.id
Following are the line types for which information is stored in OKS_K_LINES_B
Service Contract Line
Service
Warranty
Extended Warranty
Subscription
Usage
Service Contract Sub line
- If contract line is Service
Item
Product
Party
Site
System
Customer
- If contract line is Warranty and Extended Warranty
Product
- If contract line is Usage
Product Counter lines
Service Counter lines
- In addition to above line types it stores following line types
Coverage
Business process
Reaction Times
Service activity billing types
Bill Rate
Data gets populated in the table, based on the line type of the contract line or sub line.
Line level accounting rules, Payment methods, tax details, price details for covered levels (in case of Service/Extended Warranty Lines), Price details for Subscription lines.
Usage type, estimation method, default readings, Price locking details etc. for Usage lines.
Key processes which create, modify & query records in this table are
Authoring
Billing
Termination
Mass Change
Renewals
Coverage's & Entitlements
Pricing
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKS_K_LINES_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ID
|
| OKS_K_LINES_B_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
CLE_ID
|
| OKS_K_LINES_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DNZ_CHR_ID
|
| OKS_K_LINES_B_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PM_PROGRAM_ID
|
| OKS_K_LINES_B_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COVERAGE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | Unique identifier for Service Contract line in OKS_K_LINES_B | |
| CLE_ID | NUMBER | Yes | Unique Identifier for Contract Line. | |
| DNZ_CHR_ID | NUMBER | Yes | Unique Identifier for Contract Header, denomalized for efficiency. | |
| DISCOUNT_LIST | NUMBER | This stores the discount for a coverage business process. The source is the modifiers of type "Discount List". (References QP_LIST_HEADERS_B. LIST_HEADER_ID where LIST_TYPE_CODE = 'DLT') | ||
| ACCT_RULE_ID | NUMBER | Revenue recognition rule identifier. References RA_RULES.RULE_ID | ||
| PAYMENT_TYPE | VARCHAR2 | (30) | This column stores Payment Method. Valid values are 'CCR': 'Credit Card ''COM': 'Commitment' References FND_LOOKUPS, where LOOKUP_TYPE = "OKS_PAYMENT_METHODS" | |
| CC_NO | VARCHAR2 | (80) | Stores the Credit card number if PAYMENT_METHOD = 'CCR'. Stores the Credit card number if PAYMENT_METHOD = 'CCR'. The masking mechanism is based on profile option 'OKS: Credit Card Display Privileges'. Credit card numbers are masked after a Contract is submitted for approval. Valid values are 'ALL' - Credit card number is grayed out, but not encrypted.'LIMITED' - Credit card number is grayed out. All digits except for the last four are masked. 'NONE' - Currently behaves the same as 'LIMITED'NULL - No Masking is done | |
| CC_EXPIRY_DATE | DATE | Stores expiration date of Credit Card | ||
| CC_BANK_ACCT_ID | NUMBER | This column holds the Bank Account ID, and is created when integrating with iPayment Server to authorize the payment. It is populated at the time of QA Check. References AP_BANK_ACCOUNTS_ALL.BACK_ACCOUNT_ID | ||
| CC_AUTH_CODE | VARCHAR2 | (150) | Credit Card Authorization Code is retrieved from iPayment Server while authorizing the amount. This is populated at the time of QA Check.References IBY_TRXN_SUMMARIES_ALL.BEPCODE | |
| COMMITMENT_ID | NUMBER | If Payment Type is Commitment number, then commitment id is stored in this Column. References RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID | ||
| LOCKED_PRICE_LIST_ID | NUMBER | Price list header id for locked price list, associated with a Usage line or Usage sub line. (References QP_LIST_HEADERS.LIST_HEADER_ID) | ||
| USAGE_EST_YN | VARCHAR2 | (1) | Valid values are 'Y' or 'N'. 'Y' indicates estimation needs to be done for a billing period | |
| USAGE_EST_METHOD | VARCHAR2 | (30) | Estimation method used for Usage contract line and sub line . Valid values are 'CSR': Counter Estimation. 'AMCV': Average Monthly Counter Volume. (References FND_LOOKUPS where LOOKUP_TYPE = OKS_CTR_EST_METHOD) | |
| USAGE_EST_START_DATE | DATE | Start Date of the Estimation period for Usage lines | ||
| TERMN_METHOD | VARCHAR2 | (30) | Termination method used while terminating Usage contract lines and sub lines.Valid values are 'AMOUNT': Amount Based Termination. 'COUNTER': Counter Based Termination. (References FND_LOOKUPS where LOOKUP_TYPE = 'OKS_TRM_METHOD') | |
| UBT_AMOUNT | NUMBER | Contract line amount or sub line amount not accounted for (unbilled) computed during termination | ||
| CREDIT_AMOUNT | NUMBER | Credit amount generated against the invoice while terminating the contract line or sub line. | ||
| SUPPRESSED_CREDIT | NUMBER | Valid values are 'Y' and 'N'. 'Y', indicates credit to be suppressed. The credit memo can be unsuppressed and interfaced to AR by running the concurrent program 'Service Contracts program to process suppress credit'. | ||
| OVERRIDE_AMOUNT | NUMBER | After a contract line or sub line is terminated, a customer may receive a credit amount. The value in this column is used to specify termination penalties; it is always subtracted from that credit amount. The value in this column is never greater than the credit amount. | ||
| CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (1) | Valid values are 'Y' and 'N'. If this value is checked i.e. 'Y', customer PO number is required. This validation occurs at the time of QA check. | |
| CUST_PO_NUMBER | VARCHAR2 | (150) | Customer purchase order number specified at the contract line level. | |
| GRACE_DURATION | NUMBER | Not Used | ||
| GRACE_PERIOD | VARCHAR2 | (30) | Not Used | |
| INV_PRINT_FLAG | VARCHAR2 | (1) | Valid values are 'Y 'and 'N'. 'Y' indicates contract lines in AR to be printed on the invoice. Used by 'Main Billing' concurrent program. | |
| PRICE_UOM | VARCHAR2 | (30) | Stores the unit of measure that you want to use to override the default unit of measure used by pricing engine to derive price for a sub line. Example: A service item 'X' has a monthly price of $40 and a yearly price of $420. When a contract is created with 'X' service item for '1 year', contract price would be $420. If you want to override the price with a monthly price, 'Price UOM' in the Authoring form enables to do so. Pricing engine considers monthly price and the new contract price would be $480. | |
| TAX_AMOUNT | NUMBER | Stores tax amount and derived by OKS_TAX_UTIL_PVT.GET_TAX API. | ||
| TAX_INCLUSIVE_YN | VARCHAR2 | (1) | Stores tax inclusive flag derived by OKS_TAX_UTIL_PVT.GET_TAX API. Valid values are 'Y' or 'N'. If value is 'Y', tax is included in the price of the item. In such a case, column tax amount will be NULL or zero. | |
| TAX_STATUS | VARCHAR2 | (30) | Valid values are: 'R': Required- Indicates that a Tax code is mandatory. 'S': Standard - Standard tax code to be used and 'E': Exempt - Indicates that the Contract line value is exempt from tax. If this option is selected, a tax exemption id must be entered.Valid values are in FND_LOOKUPS.LOOKUP_CODE, where LOOKUP_TYPE = 'TAX_CONTROL_FLAG' | |
| TAX_CODE | NUMBER | This stores tax code for Tax status 'R' and 'S'. If TAX_STATUS = 'R', this value is mandatory. (References AR_VAT_TAX_ALL_B.VAT_TAX_ID) | ||
| TAX_EXEMPTION_ID | NUMBER | This stores the tax exemption id of the customer exemption number.If TAX_STATUS = 'E', a value must be entered for this column. References RA_TAX_EXEMPTIONS_ALL.TAX_EXEMPTION_ID | ||
| IB_TRANS_TYPE | VARCHAR2 | (10) | Not Used | |
| IB_TRANS_DATE | DATE | Not Used | ||
| PROD_PRICE | NUMBER | Not Used | ||
| SERVICE_PRICE | NUMBER | Not Used | ||
| CLVL_LIST_PRICE | NUMBER | Amount defined for the product or item in the price list. This value is displayed in 'List Price' field in 'Covered Level' block of Price Calculation window at sub line level. References QP_LIST_LINES.OPERAND. | ||
| CLVL_QUANTITY | NUMBER | Number of instances of the product or item that is being covered by the Service. This value is displayed in 'Quantity' field in 'Covered Level' block of Price Calculation window at sub line level. | ||
| CLVL_EXTENDED_AMT | NUMBER | Computed amount derived by multiplying CLVL_LIST_PRICE and CLVL_QUANTITY. This value is displayed in 'Extended Amount' field in 'Covered Level' block of Price Calculation window at sub line level. | ||
| CLVL_UOM_CODE | VARCHAR2 | (3) | Unit of measure of the product or item used for pricing.This value is displayed in 'UOM' field in 'Covered Level' block of Price Calculation window at sub line level. This column is used in conjunction with CLVL_QUANTITY.References MTL_UNITS_OF_MEASURE_TL.UOM_CODE. | |
| TOPLVL_OPERAND_CODE | VARCHAR2 | (30) | Specifies the pricing application method. References QP_LOOKUPS, where LOOKUP_TYPE = 'ARITHMETIC_OPERATOR'. Valid values are 'PERCENT_PRICE' - Percent, 'UNIT_PRICE' - Unit Price.This value is displayed in 'Operator' field in 'Top Line Level' block of Price Calculation window at sub line level. | |
| TOPLVL_OPERAND_VAL | NUMBER | Value of the service item defined in the price list. This column in conjunction with TOPLVL_OPERAND_CODE specifies the price of an item. This value is displayed in 'Operand' field in 'Top Line Level' block of Price Calculation window at sub line level. | ||
| TOPLVL_QUANTITY | NUMBER | Stores quantity associated with the contract line or sub line. For a service line, this value is the duration of the service line. | ||
| TOPLVL_UOM_CODE | VARCHAR2 | (3) | Stores the actual time unit of measure used while computing the price of a line. This column is used in conjunction with TOPLVL_PRICE_QTY. Please refer to example provided for TOPLVL_PRICE_QTY, this column's value would be 'month'.This value is displayed in 'UOM' field in 'Top Line Level' block of Price Calculation window at sub line level. This value is also displayed in 'UOM' field of Price Calculation window for a Subscription line.References MTL_UNITS_OF_MEASURE_TL.UOM_CODE. | |
| TOPLVL_ADJ_PRICE | NUMBER | Price per unit after the pricing engine applies discounts and surcharges. This value is displayed in 'Adjusted Price' field in 'Top Line Level' block of Price Calculation window at sub line level. This value is also displayed in 'Adjusted Price' field of Price Calculation window for a Subscription line. | ||
| TOPLVL_PRICE_QTY | NUMBER | Stores the actual quantity used while computing the price of a line. Example: A price is defined for a service item in the price list for 'month' and a contract is created for '1 year', the quantity is 12 since monthly price is used to compute the price.This value is displayed in 'Quantity' field in 'Top Line Level' block of Price Calculation window at sub line level. This value is also displayed in 'Quantity' field of Price Calculation window for a Subscription line. | ||
| AVERAGING_INTERVAL | NUMBER | Stores the Averaging interval of billing cycle for usage line type 'Actual Per Period'. Service Contracts Averaging concurrent program uses this value to average the counter quantity to raise credit memos | ||
| SETTLEMENT_INTERVAL | VARCHAR2 | (30) | Settlement is done for usage line billed by using default quantity; The process is done either at the end of the period or end of billing cycle. Valid values are 'Billing Period' and 'End Of Usage'(References FND_LOOKUPS where LOOKUP_TYPE = OKS_SETTLEMENT_INTERVAL | |
| MINIMUM_QUANTITY | NUMBER | Minimum quantity for a usage line to be billed for a billing period,If actual quantity is less than minimum quantity, then minimum quantity is billed. | ||
| DEFAULT_QUANTITY | NUMBER | Default Quantity for a usage line to be billed for a billing period, If there is no reading captured | ||
| AMCV_FLAG | VARCHAR2 | (1) | This flag is applicable for usage lines. Valid values are 'Y' or 'N'. 'Y' indicates AMCV method to derive quantity for billing. 'N' indicates to bill the default quantity | |
| FIXED_QUANTITY | NUMBER | Stores the fixed quantity to be billed for a billing period for usage line type 'FRT'. | ||
| USAGE_DURATION | NUMBER | Not Used. | ||
| USAGE_PERIOD | VARCHAR2 | (3) | Time UOM Period for Usage lines to prorate default and minimum quantity for billing. Valid values are Day, Week, Month, Quarter and Year | |
| LEVEL_YN | VARCHAR2 | (1) | Valid values are 'Y' and 'N'. If 'Y' then, counter quantities are leveled for a usage line and billed. 'N' indicates to bill the captured quantity. | |
| USAGE_TYPE | VARCHAR2 | (10) | Valid values for Usage contract line types are: FRT: Fixed. Fixed quantity to be billed all billing periods. VRT: Actual per period. Captured counter within the billing period is honored for billing. QTY: Actual by quantity. Latest captured counter quantity is honored for billing. NPR: Price negotiated. Billing honors Amount which is proportionate for all billable periods | |
| UOM_QUANTIFIED | VARCHAR2 | (3) | Not Used. | |
| BASE_READING | NUMBER | Start reading of the counter for a Usage line. References CS_CTR_COUNTER_VALUES_V. NET_READING. This column need not be zero. | ||
| BILLING_SCHEDULE_TYPE | VARCHAR2 | (10) | Valid values are 'E': 'Equal Amount' -Billing Schedule is created for contract line and is instantiated to sub lines. Effectivity of Contract line and sub line must be the same.'T': 'Top Level' - Billing Schedule is created for contract line and is instantiated to sub lines. . Effectivity of Contract line and sub line need not be the same.'P': 'Covered Level' - Billing Schedule is created for contract sub line. User specifies billing amount for the billing period.Reference FND_LOOKUPS where LOOKUP_TYPE = 'OKS_BILLSCH_LEVEL' | |
| FULL_CREDIT | VARCHAR2 | (1) | Valid values are 'Y' and 'N'. 'Y' indicates, the customer receives a full reimbursement of the charged amount for the specified billing period. 'N' indicates effectivity based credit amount. | |
| LOCKED_PRICE_LIST_LINE_ID | NUMBER | Price list line id of the locked price list associated with a Usage line or sub line (References QP_LIST_LINES.LIST_LINE_ID) | ||
| BREAK_UOM | VARCHAR2 | (3) | Time code Units of Measure used to prorate price breaks at the time of usage billing. | |
| PRORATE | VARCHAR2 | (5) | Proration method to be used while Pricing usage lines or sub lines. Valid values are 'ALL': Proration will be done for all price breaks. 'NONE': No proration will be done (References FND_LOOKUPS where LOOKUP_TYPE = OKS_PBL_PRORATE) | |
| COVERAGE_TYPE | VARCHAR2 | (30) | Coverage type code for coverage. e.g. 'G' for 'Gold' coverage type. Coverage Importance level is derived from this field. (References OKS_COV_TYPES_B. CODE). | |
| EXCEPTION_COV_ID | NUMBER | Coverage template id used as exception coverage. (References OKC_K_LINES_B.ID). Currently does not drive any functionality. | ||
| LIMIT_UOM_QUANTIFIED | VARCHAR2 | (3) | Not Used. | |
| DISCOUNT_AMOUNT | NUMBER | Maximum discount amount applicable to a service activity billing type for a business process. During discount calculation OKS_CON_COVERAGE_PUB.apply_contract_coverage procedure returns the lower amount between Discount amount and Discount percent amount. For example, Let's say the Discount amount is $1500 and Discount percent is 10%. If the Labor, Material or Expense cost is $10000, then the customer will get $1000 discount. | ||
| DISCOUNT_PERCENT | NUMBER | Discount percentage applicable to service activity billing type for a business process. | ||
| OFFSET_DURATION | NUMBER | Offset duration to determine start date for a business process. | ||
| OFFSET_PERIOD | VARCHAR2 | (3) | Offset period to determine start date for a business process. | |
| INCIDENT_SEVERITY_ID | NUMBER | Indicates the severity for a reaction and resolution time. (References CS_INCIDENT_SEVERITIES_B. INCIDENT_SEVERITY_ID) | ||
| PDF_ID | NUMBER | Workflow Id referred in reaction time.(References OKC_PROCESS_DEFS_B.ID). Currently does not drive any functionality. | ||
| WORK_THRU_YN | VARCHAR2 | (1) | Flag used to indicate whether to work beyond coverage times when a service request is logged and is used to derive the React By and Resolve By date & time. Valid values are 'Y' and 'N'. | |
| REACT_ACTIVE_YN | VARCHAR2 | (1) | Flag to identify if the reaction/resolution time is active for a severity. Valid values are 'Y' and 'N'. | |
| TRANSFER_OPTION | VARCHAR2 | (30) | Transfer option code to determine action to be taken for service contract during transfer of item instance in Installed Base. (References FND_LOOKUPS for lookup type 'OKS_TRANSFER_OPTIONS'). Seeded values are: 'NO_CHANGE' - No Change. 'TERM' - Terminate. 'TERM_NO_REL' - Terminate If Not Related. 'TRANS' - Transfer. 'TRANS_NO_REL' - Transfer If Not Related | |
| PROD_UPGRADE_YN | VARCHAR2 | (1) | Flag to indicate free upgrade in coverage. Currently does not drive any functionality. | |
| INHERITANCE_TYPE | VARCHAR2 | (30) | Inheritance code for warranty coverage. Seeded values are 'F' - 'Full Duration' 'R' - 'Remaining Duration'. When an item instance is replaced, the duration of the warranty for the new item instance is derived from this value.(References FND_LOOKUPS for lookup type 'OKSWHETYPE'.) | |
| PM_PROGRAM_ID | NUMBER | Stores the associated Preventive maintenance program id in coverage. This is based on Maintenance Requirement of type 'Program' defined in AHL. (References AHL_MR_HEADERS_B.MR_HEADER_ID) | ||
| PM_CONF_REQ_YN | VARCHAR2 | (1) | Flag to indicate if customer confirmation is required to perform the activities associated to a Preventive Maintenance program. Valid values are 'Y' and 'N'. | |
| PM_SCH_EXISTS_YN | VARCHAR2 | (1) | Flag to indicate if schedules exist for the Preventive Maintenance program in instantiated coverage. Valid values are 'Y' and 'N'. | |
| ALLOW_BT_DISCOUNT | VARCHAR2 | (1) | Flag to indicate whether to allow full discount for all service activity billing types of a business process. This is only applicable for warranty coverage. Valid values are 'Y' and 'N'. | |
| APPLY_DEFAULT_TIMEZONE | VARCHAR2 | (1) | Flag to indicate whether the coverage times of the default time zone are applicable to all other time zones not specified for the coverage business process. Valid values are 'Y' and 'N'. | |
| SYNC_DATE_INSTALL | VARCHAR2 | (1) | Flag to indicate whether to synchronize a warranty contract start date with the installed date of the item instance when the installation dates changes. Valid values are 'Y' and 'N'. | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | |
| SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. | ||
| REQUEST_ID | NUMBER | Unique Identifier of a concurrent request. | ||
| CREATED_BY | NUMBER | (15) | Yes | ID of the user whom created the record. |
| CREATION_DATE | DATE | Yes | Date the record was created. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | ID of the last user who updated the record. |
| LAST_UPDATE_DATE | DATE | Yes | Date the record was last updated. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | OS ID of the user who last updated the record. | |
| TRXN_EXTENSION_ID | NUMBER | Payments - Payment FK for credit cards | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | Tax code | |
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | Exemption certificate number | |
| EXEMPT_REASON_CODE | VARCHAR2 | (30) | The reason for this exemption | |
| COVERAGE_ID | NUMBER | Stores Identifier of coverage | ||
| STANDARD_COV_YN | VARCHAR2 | (1) | Indicates whether the contract coverage is a standard or customized coverage. | |
| ORIG_SYSTEM_ID1 | NUMBER | Identifier of Source Record | ||
| ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Identifier of Source system | |
| ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | Identifier of Source system |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CLE_ID
, DNZ_CHR_ID
, DISCOUNT_LIST
, ACCT_RULE_ID
, PAYMENT_TYPE
, CC_NO
, CC_EXPIRY_DATE
, CC_BANK_ACCT_ID
, CC_AUTH_CODE
, COMMITMENT_ID
, LOCKED_PRICE_LIST_ID
, USAGE_EST_YN
, USAGE_EST_METHOD
, USAGE_EST_START_DATE
, TERMN_METHOD
, UBT_AMOUNT
, CREDIT_AMOUNT
, SUPPRESSED_CREDIT
, OVERRIDE_AMOUNT
, CUST_PO_NUMBER_REQ_YN
, CUST_PO_NUMBER
, GRACE_DURATION
, GRACE_PERIOD
, INV_PRINT_FLAG
, PRICE_UOM
, TAX_AMOUNT
, TAX_INCLUSIVE_YN
, TAX_STATUS
, TAX_CODE
, TAX_EXEMPTION_ID
, IB_TRANS_TYPE
, IB_TRANS_DATE
, PROD_PRICE
, SERVICE_PRICE
, CLVL_LIST_PRICE
, CLVL_QUANTITY
, CLVL_EXTENDED_AMT
, CLVL_UOM_CODE
, TOPLVL_OPERAND_CODE
, TOPLVL_OPERAND_VAL
, TOPLVL_QUANTITY
, TOPLVL_UOM_CODE
, TOPLVL_ADJ_PRICE
, TOPLVL_PRICE_QTY
, AVERAGING_INTERVAL
, SETTLEMENT_INTERVAL
, MINIMUM_QUANTITY
, DEFAULT_QUANTITY
, AMCV_FLAG
, FIXED_QUANTITY
, USAGE_DURATION
, USAGE_PERIOD
, LEVEL_YN
, USAGE_TYPE
, UOM_QUANTIFIED
, BASE_READING
, BILLING_SCHEDULE_TYPE
, FULL_CREDIT
, LOCKED_PRICE_LIST_LINE_ID
, BREAK_UOM
, PRORATE
, COVERAGE_TYPE
, EXCEPTION_COV_ID
, LIMIT_UOM_QUANTIFIED
, DISCOUNT_AMOUNT
, DISCOUNT_PERCENT
, OFFSET_DURATION
, OFFSET_PERIOD
, INCIDENT_SEVERITY_ID
, PDF_ID
, WORK_THRU_YN
, REACT_ACTIVE_YN
, TRANSFER_OPTION
, PROD_UPGRADE_YN
, INHERITANCE_TYPE
, PM_PROGRAM_ID
, PM_CONF_REQ_YN
, PM_SCH_EXISTS_YN
, ALLOW_BT_DISCOUNT
, APPLY_DEFAULT_TIMEZONE
, SYNC_DATE_INSTALL
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TRXN_EXTENSION_ID
, TAX_CLASSIFICATION_CODE
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE
, COVERAGE_ID
, STANDARD_COV_YN
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, ORIG_SYSTEM_SOURCE_CODE
FROM OKS.OKS_K_LINES_B;
OKS.OKS_K_LINES_B does not reference any database object
OKS.OKS_K_LINES_B is referenced by following:
APPS
OKS_K_LINES_B
|
|
|
|