[Home] [Help] [Dependency Information]
Object Name: | OKL_K_HEADERS_FULL_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_K_HEADERS_FULL_UV |
Subobject Name: | |
Status: | VALID |
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 |
---|---|---|---|---|
ID | VARCHAR2 | (40) | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
INV_ORGANIZATION_ID | NUMBER | Yes | Foreign key to MTL_SYSTEM_ITEMS | |
ORG_ID | NUMBER | Yes | Organization ID | |
STS_CODE | VARCHAR2 | (30) | Yes | Indicates status of Contract Header. Refers to Code in OKC_STATUSES_B |
STS_CODE_MEANING | VARCHAR2 | (0) | Status meaning | |
QCL_ID | VARCHAR2 | (40) | ID of QA check list applicable to this contract. Refers to OKC_QA_CHECK_LISTS_B.ID | |
SCS_CODE | VARCHAR2 | (30) | Yes | Indicates subclass of the Contract. Refers to code in okc_subclasses |
SCS_CODE_MEANING | VARCHAR2 | (0) | Sub class meaning | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract (RFP,Proposal etc.) Legal Identifier. |
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier of Currency code. Refers to CURRENCY_CODE in FND_CURRENCIES | |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | A unique internal name for the contract number | |
ARCHIVED_YN | VARCHAR2 | (3) | Yes | Indicates if the contract has been SOFT deleted. Future use column. Valid values Y and N |
DELETED_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns |
CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (3) | Indicates if a Purchase Order is required. Valid values Y and N | |
PRE_PAY_REQ_YN | VARCHAR2 | (3) | Indicates if Contract pre-payment is required . Valid values Y and N | |
CUST_PO_NUMBER | VARCHAR2 | (150) | Customer's Purchase Order Number | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description | |
DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description | |
DPAS_RATING | VARCHAR2 | (24) | DPAS ( Defense Priorities and Allocations System) rating. Indicates standard followed for government contracts | |
COGNOMEN | VARCHAR2 | (300) | Cognomen field | |
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Indicates if this contract is a Template. Valid values are Y and N |
TEMPLATE_USED | VARCHAR2 | (120) | Denotes if a template was used to create contract | |
DATE_APPROVED | DATE | Date contract was approved | ||
DATETIME_CANCELLED | DATE | Date / Time Contract was cancelled | ||
AUTO_RENEW_DAYS | NUMBER | (4) | Number of days before automatic renewal of contract | |
DATE_ISSUED | DATE | Date contract Issued | ||
DATETIME_RESPONDED | DATE | Date / time response sent | ||
NON_RESPONSE_REASON | VARCHAR2 | (3) | Used with contract RFP | |
NON_RESPONSE_EXPLAIN | VARCHAR2 | (1995) | Used with contract RFP | |
RFP_TYPE | VARCHAR2 | (30) | RFP Type | |
CHR_TYPE | VARCHAR2 | (30) | Yes | Indicates the type of the contract such as response, award etc. Contract classification based on this column is not implemented and hence this column is always defaulted to one value 'CYA' |
KEEP_ON_MAIL_LIST | VARCHAR2 | (3) | Keep us on the mailing list | |
SET_ASIDE_REASON | VARCHAR2 | (3) | Used with contract RFP | |
SET_ASIDE_PERCENT | NUMBER | (5) | Percent set aside for reason specified | |
RESPONSE_COPIES_REQ | NUMBER | (2) | Number of proposal copies required | |
DATE_CLOSE_PROJECTED | DATE | Date that contract is expected to be signed | ||
DATETIME_PROPOSED | DATE | Date / time proposal sent | ||
DATE_SIGNED | DATE | Date contract was signed | ||
DATE_TERMINATED | DATE | Date contract terminated | ||
DATE_RENEWED | DATE | Date contract was renewed | ||
TRN_CODE | VARCHAR2 | (30) | Contract Termination code. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE='OKC_TERMINATION_REASON' | |
START_DATE | DATE | The beginning of the active period, one second after midnight on the date indicated | ||
END_DATE | DATE | The end of the active period, one second before midnight on the date indicated | ||
AUTHORING_ORG_ID | NUMBER | Yes | Authoring Organization ID | |
BUY_OR_SELL | VARCHAR2 | (3) | Buy or Sell | |
ISSUE_OR_RECEIVE | VARCHAR2 | (3) | Issue or Receive | |
ESTIMATED_AMOUNT | NUMBER | Estimated amount of contract | ||
CHR_ID_RENEWED_TO | NUMBER | Indicates the contract header that is the renewal of this contract header. Only present in renewed contracts | ||
ESTIMATED_AMOUNT_RENEWED | NUMBER | The estimated amount of the contract of which this contract is a renewal. Only present in renewal contracts | ||
CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | Currency code from FND_CURRENCIES. The currency for the contract of which this contract is a renewal. Only present in renewal contracts | |
USER_ACCESS_LEVEL | VARCHAR2 | (4000) | Access level for the user | |
UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Identifies original source of data | |
UPG_ORIG_SYSTEM_REF_ID | NUMBER | Unique Id from original system | ||
APPLICATION_ID | NUMBER | Application Identifier | ||
RESOLVED_UNTIL | DATE | Date till which time-values have been resolved for long contracts | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | Identifier of the source system | |
ORIG_SYSTEM_ID1 | NUMBER | Unique identifier in the source system | ||
ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Unique identifier in the source system | |
PROGRAM_APPLICATION_ID | NUMBER | Standard Who Column | ||
PROGRAM_ID | NUMBER | Standard Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
REQUEST_ID | NUMBER | Standard Who Column | ||
PRICE_LIST_ID | NUMBER | Identifier of the Price List used for pricing this Contract. Quickcodes : LIST_HEADER_ID from QP_LIST_HEADERS_B | ||
PRICING_DATE | DATE | Effective date used for pricing this Contract | ||
TOTAL_LINE_LIST_PRICE | NUMBER | Sum of the list price of all the priced lines in the Contract | ||
SIGN_BY_DATE | DATE | Date by which the Contract must be signed | ||
USER_ESTIMATED_AMOUNT | NUMBER | User updateable estimated amount of the contract | ||
GOVERNING_CONTRACT_YN | VARCHAR2 | (3) | Indicates if this contract is a governing contract or not - Not Used . Valid values Y and N | |
CUST_ACCT_ID | NUMBER | (15) | Contract customer account | |
CONVERSION_TYPE | VARCHAR2 | (30) | Contract currency conversion type | |
CONVERSION_RATE | NUMBER | Rate for converting amount to functional currency | ||
CONVERSION_RATE_DATE | DATE | Valid date for conversion rate | ||
CONVERSION_EURO_RATE | NUMBER | This column identifies the Euro conversion rate for foreign currency contracts of the Euro countries | ||
BILL_TO_SITE_USE_ID | NUMBER | (15) | Stores account site use identifier. This column is used to identify the billing address of the customer account. References HZ_CUST_ACCT_SITES_ALL.SITE_USE_ID where SITE_USE_CODE='BILL_TO' | |
INV_RULE_ID | NUMBER | (15) | Stores invoicing rule identifier. This column is used to bill invoices in Advance or Arrears. References RA_RULES.RULE_ID where TYPE='I' | |
RENEWAL_TYPE_CODE | VARCHAR2 | (30) | Unique identifier of Contract renewal type. Refers to lookup_code from fnd_lookups where lookup_type = OKC_RENEWAL_TYPE | |
RENEWAL_NOTIFY_TO | NUMBER | Resource to notify after contract renewal | ||
RENEWAL_END_DATE | DATE | New contract end date after renewal | ||
SHIP_TO_SITE_USE_ID | NUMBER | (15) | Stores account site use identifier. This column is used to identify the shipping address of the customer account. References HZ_CUST_ACCT_SITES_ALL.SITE_USE_ID where SITE_USE_CODE='SHIP_TO' | |
PAYMENT_TERM_ID | NUMBER | (15) | Stores Payment terms identifier. This column is used to identify the payment terms for the invoice. References AP_TERMS_TL.TERM_ID | |
KHR_OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
ISG_ID | VARCHAR2 | (40) | Unique identifier for sales region | |
VPA_KHR_ID | VARCHAR2 | (40) | Foreign key to table OKL_K_HEADERS | |
PDT_ID | VARCHAR2 | (40) | Foreign key to table OKL_PRODUCTS | |
PRODUCT_NAME | VARCHAR2 | (0) | Product Name | |
PRODUCT_DESCRIPTION | VARCHAR2 | (0) | Product Description | |
AMD_CODE | VARCHAR2 | (30) | Acceptance method code. This is a foreign key to FND_LOOKUP code 'OKL_ACCEPTANCE_METHOD' | |
DATE_FIRST_ACTIVITY | DATE | Date of first activity on the contract | ||
GENERATE_ACCRUAL_YN | VARCHAR2 | (3) | Indicates whether to generate accrual or not | |
GENERATE_ACCRUAL_OVERRIDE_YN | VARCHAR2 | (3) | Indicates whether to override generation of accrual or not | |
DATE_REFINANCED | DATE | The date finance closed if this was a rollover, restructure, renew or refinance contract | ||
CREDIT_ACT_YN | VARCHAR2 | (3) | Indicates whether contract is consumer credit act deal or not | |
TERM_DURATION | NUMBER | (10) | The duration of the contract in months | |
CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | Indicates whether the contract account is a converted account or not | |
DATE_CONVERSION_EFFECTIVE | DATE | Date on which the deal conversion becomes active | ||
SYNDICATABLE_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for syndication or not | |
SALESTYPE_YN | VARCHAR2 | (3) | Indicates whether it is a sales type contract or not | |
DATE_DEAL_TRANSFERRED | DATE | Date on which the deal was transferred from one lessee to another | ||
DATETIME_PROPOSAL_EFFECTIVE | DATE | Date on which the proposal becomes effective | ||
DATETIME_PROPOSAL_INEFFECTIVE | DATE | Date on which the proposal becomes ineffective | ||
DATE_PROPOSAL_ACCEPTED | DATE | Date on which notification of acceptance of the proposal was received | ||
PRE_TAX_YIELD | NUMBER | Yield before tax | ||
AFTER_TAX_YIELD | NUMBER | Yield after tax | ||
IMPLICIT_INTEREST_RATE | NUMBER | Implicit interest rate | ||
IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | Implicit non-IDC interest rate | ||
TARGET_PRE_TAX_YIELD | NUMBER | Target pre tax yield | ||
TARGET_AFTER_TAX_YIELD | NUMBER | Target after tax yield | ||
TARGET_IMPLICIT_INTEREST_RATE | NUMBER | Target implicit interest rate | ||
TARGET_IMPLICIT_NONIDC_INTRATE | NUMBER | Target implicit non-IDC interest rate | ||
DATE_LAST_INTERIM_INTEREST_CAL | DATE | Last Interim interest calculation date | ||
DEAL_TYPE | VARCHAR2 | (30) | Book Classification of the contract | |
PRE_TAX_IRR | NUMBER | Pre tax IRR for the contract | ||
AFTER_TAX_IRR | NUMBER | After tax IRR for the contract | ||
EXPECTED_DELIVERY_DATE | DATE | Earliest date by which a line (financial asset) under this contract will be delivered to the lessee | ||
ACCEPTED_DATE | DATE | Earliest date by which all the lines on the contract will be accepted | ||
PREFUNDING_ELIGIBLE_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for pre-funding or not | |
REVOLVING_CREDIT_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for a revolving line of credit or not | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
MULTI_GAAP_YN | VARCHAR2 | (3) | Indicates whether contract is eligible for Multi-GAAP accounting | |
RECOURSE_CODE | VARCHAR2 | (30) | Recource Code | |
LESSOR_SERV_ORG_CODE | VARCHAR2 | (30) | Lessor service organization code | |
ASSIGNABLE_YN | VARCHAR2 | (3) | Indicates whether the lease contract can e assigned to an investor agreement | |
SECURITIZED_CODE | VARCHAR2 | (30) | Securitized code | |
SECURITIZATION_TYPE | VARCHAR2 | (30) | Type of securitization | |
SUB_PRE_TAX_YIELD | NUMBER | Subsidized pre-tax yield | ||
SUB_AFTER_TAX_YIELD | NUMBER | Subsidized after tax yield | ||
SUB_IMPL_INTEREST_RATE | NUMBER | Subsidized implicit interest rate | ||
SUB_IMPL_NON_IDC_INT_RATE | NUMBER | Subsidized non IDC implicit interest rate | ||
SUB_PRE_TAX_IRR | NUMBER | Subsidized pre-tax IRR | ||
SUB_AFTER_TAX_IRR | NUMBER | Subsidized after tax yield | ||
TOT_CL_TRANSFER_AMT | NUMBER | Total creditline transfer amount | ||
TOT_CL_NET_TRANSFER_AMT | NUMBER | Total creditline net transfer amount | ||
TOT_CL_LIMIT | NUMBER | Total creditline limit | ||
TOT_CL_FUNDING_AMT | NUMBER | Total creditline funding amount | ||
CRS_ID | NUMBER | Change request identifier | ||
TEMPLATE_TYPE_CODE | VARCHAR2 | (30) | Template type code | |
TRADEIN_DESCRIPTION | VARCHAR2 | (1995) | Description of trade in | |
TRADEIN_AMOUNT | NUMBER | Tradein amount | ||
DATE_TRADEIN | DATE | Date on which tradein amount is applied | ||
DATE_FUNDING_EXPECTED | DATE | Date on which funding is expected for a lease contract | ||
LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign key to XLE_ENTITY_PROFILES | ||
CUSTOMER_CPL_ID | VARCHAR2 | (0) | Contract party role Identifier | |
CUSTOMER_OBJECT1_ID1 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view | |
CUSTOMER_OBJECT1_ID2 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view | |
CUSTOMER_JTOT_OBJECT1_CODE | VARCHAR2 | (0) | Refers to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns | |
CUSTOMER_NAME | VARCHAR2 | (0) | Customer Name | |
CUSTOMER_ACCOUNT | VARCHAR2 | (0) | Customer Account | |
MLA_CONTRACT_NUMBER | VARCHAR2 | (0) | Master Lease Agreement Number | |
MLA_CHR_ID | VARCHAR2 | (0) | Contract Identifier of Master Lease Agreement | |
MLA_GVR_ID | VARCHAR2 | (0) | Governance Identifier of Master Lease Agreement | |
CREDIT_LINE_CONTRACT_NUMBER | VARCHAR2 | (0) | Credit Line Number | |
CREDIT_LINE_CHR_ID | VARCHAR2 | (0) | Contract Identifier of Credit Line | |
CREDIT_GVR_ID | VARCHAR2 | (0) | Governance Identifier of Credit Line | |
VPA_CONTRACT_NUMBER | VARCHAR2 | (0) | Vendor Program Agreement Number | |
LEGAL_ENTITY_NAME | VARCHAR2 | (0) | Legal Entity Name | |
OPERATING_UNIT_NAME | VARCHAR2 | (0) | Operating Unit Name | |
LEGAL_ADDRESS | VARCHAR2 | (0) | Legal Address | |
LEGAL_ADDRESS_ID | VARCHAR2 | (0) | Legal Address Identifier | |
SALES_REPRESENTATIVE_NAME | VARCHAR2 | (0) | Sales Representative Name | |
REP_CONTACT_ID | NUMBER | Sales Representative Contact Identifier | ||
REP_CONTACT_OBJECT1_ID1 | NUMBER | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view | ||
REP_CONTACT_OBJECT1_ID2 | NUMBER | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view | ||
REP_CONTACT_JTOT_OBJECT1_CODE | VARCHAR2 | (0) | Refers to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns | |
LEDGER_NAME | VARCHAR2 | (0) | Ledger Name | |
LEDGER_ID | NUMBER | Ledger Identifier | ||
INTEREST_CALC_MEANING | VARCHAR2 | (0) | Interest Calculation Basis | |
REVENUE_RECOGNITION_MEANING | VARCHAR2 | (0) | Revenue Recognition Method | |
BOOK_CLASS_MEANING | VARCHAR2 | (0) | Book Classification | |
PROGRAM_TEMPLATE_NAME | VARCHAR2 | (0) | Program Template Name | |
PROGRAM_TEMPLATE_CHR_ID | VARCHAR2 | (0) | Program Template Contract Identifier | |
ORIGINATION_QUOTE_NAME | VARCHAR2 | (0) | Origination Quote | |
ORIGINATION_QUOTE_ID | VARCHAR2 | (0) | Origination Quote Identifier | |
LEASE_APPLICATION_NAME | VARCHAR2 | (0) | Lease Application Name | |
LEASE_APPLICATION_ID | VARCHAR2 | (0) | Lease Application Identifier | |
REPLACES_CONTRACT_NUMBER | VARCHAR2 | (0) | Replaces Contract Number | |
REPLACES_CHR_ID | VARCHAR2 | (0) | Replaces Contract Identifier | |
LEGACY_NUMBER | VARCHAR2 | (0) | Legacy Contract Number | |
ELIG_FOR_PREFUNDING_MEANING | VARCHAR2 | (0) | Eligible for Prefunding Yes/No flag meaning | |
CAP_INTERIM_INTERST_MEANING | VARCHAR2 | (0) | Capitalize Interim Interest Yes/No flag meaning | |
CONVERTED_ACCT_MEANING | VARCHAR2 | (0) | Converted Account Yes/No flag meaning | |
PRIVATE_ACT_BOND_MEANING | VARCHAR2 | (0) | Private Activity Bond Yes/No flag meaning | |
CONSUMER_CREDIT_ACT_MEANING | VARCHAR2 | (0) | Consumer Credit Act Deal Yes/No flag meaning | |
NON_NOTIFICATION_MEANING | VARCHAR2 | (0) | Non notification Yes/No flag meaning | |
ASSIGNABLE_MEANING | VARCHAR2 | (0) | Investor Assignable Yes/No flag meaning | |
LESSOR_INSURED_MEANING | VARCHAR2 | (0) | Lessor insured meaning | |
LESSOR_PAYEE_MEANING | VARCHAR2 | (0) | Lessor Payee meaning | |
CURRENCY_CONV_TYPE_MEANING | VARCHAR2 | (0) | Currency Conversion Type meaning | |
ACCEPTANCE_METHOD_MEANING | VARCHAR2 | (0) | Acceptance Method meaning | |
REBOOK_LIMIT_DATE | DATE | Rebook Limit Date | ||
REBOOK_LIMIT_DATE_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LAREBL | |
REBOOK_LIMIT_DATE_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition Code of Rule Group LAREBL | |
REBOOK_LIMIT_DATE_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LAREBL | |
REBOOK_LIMIT_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LAREBL | |
REBOOK_LIMIT_RUL_INF1 | VARCHAR2 | (0) | Rule Information1 of Rule LAREBL | |
TAX_OWNER_CODE | VARCHAR2 | (0) | Tax Owner Code | |
TAX_OWNER_MEANING | VARCHAR2 | (0) | Tax Owner Meaning | |
TAX_OWNER_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LATOWN | |
TAX_OWNER_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition Code of Rule Group LATOWN | |
TAX_OWNER_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LATOWN | |
TAX_OWNER_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LATOWN | |
TAX_OWNER_RUL_INF1 | VARCHAR2 | (0) | Rule Information1 of Rule LATOWN | |
CAP_INTERIM_INT_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LACPLN | |
CAP_INTERIM_INT_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition Code of Rule Group LACPLN | |
CAP_INTERIM_INT_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LACPLN | |
CAP_INTERIM_INT_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LACPLN | |
CAP_INTERIM_INT_RUL_INF1 | VARCHAR2 | (0) | Rule Information1 of Rule LACPLN | |
PRV_ACT_BOND_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LAPACT | |
PRV_ACT_BOND_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition Code of Rule Group LAPACT | |
PRV_ACT_BOND_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LAPACT | |
PRV_ACT_BOND_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LAPACT | |
PRV_ACT_BOND_RUL_INF1 | VARCHAR2 | (0) | Rule Information1 of Rule LAPACT | |
NNTF_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LANNTF | |
NNTF_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition of Rule Group LANNTF | |
NNTF_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LANNTF | |
NNTF_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LANNTF | |
NNTF_RUL_INF1 | VARCHAR2 | (0) | Rule Information1 of Rule LANNTF | |
BILL_TO_ADDRESS_DESC | VARCHAR2 | (0) | Bill-To Address | |
SPLIT_FROM_CONTRACT_NUMBER | VARCHAR2 | (0) | Split From Contract Number | |
SPLIT_FROM_CHR_ID | VARCHAR2 | (0) | Split From Contract Identifier | |
SOURCE_CODE | VARCHAR2 | (0) | Source Code | |
SOURCE_CHR_ID | VARCHAR2 | (0) | Source Contract Identifier | |
SOURCE_CONTRACT_NUMBER | VARCHAR2 | (0) | Source Contract Number | |
PRODUCT_SUBCLASS_CODE | VARCHAR2 | (0) | Product Sub class code | |
BILL_TO_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LABILL | |
BILL_TO_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LABILL | |
BILL_TO_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition of Rule Group LABILL | |
BILL_TO_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LABILL | |
BILL_TO_RUL_INF1 | NUMBER | Rule Information1of Rule LABILL | ||
RELEASED_ASSET_MEANING | VARCHAR2 | (0) | Re-leased Asset Yes/No flag meaning | |
RLES_RGD_CODE | VARCHAR2 | (0) | Rule Group Definition of Rule Group LARLES | |
RLES_RGP_ID | VARCHAR2 | (0) | Rule Group Identifier of Rule Group LARLES | |
RLES_RUL_ID | VARCHAR2 | (0) | Rule Identifier of Rule LARLES | |
RLES_RUL_INF1 | VARCHAR2 | (0) | Rule Information1 of Rule LARLES | |
RLES_RUL_INF_CAT | VARCHAR2 | (0) | Rule Information Category of Rule LARLES | |
LAST_ACTIVATION_DATE | DATE | Last Activation Date |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, INV_ORGANIZATION_ID
, ORG_ID
, STS_CODE
, STS_CODE_MEANING
, QCL_ID
, SCS_CODE
, SCS_CODE_MEANING
, CONTRACT_NUMBER
, CURRENCY_CODE
, CONTRACT_NUMBER_MODIFIER
, ARCHIVED_YN
, DELETED_YN
, CUST_PO_NUMBER_REQ_YN
, PRE_PAY_REQ_YN
, CUST_PO_NUMBER
, SHORT_DESCRIPTION
, DESCRIPTION
, DPAS_RATING
, COGNOMEN
, TEMPLATE_YN
, TEMPLATE_USED
, DATE_APPROVED
, DATETIME_CANCELLED
, AUTO_RENEW_DAYS
, DATE_ISSUED
, DATETIME_RESPONDED
, NON_RESPONSE_REASON
, NON_RESPONSE_EXPLAIN
, RFP_TYPE
, CHR_TYPE
, KEEP_ON_MAIL_LIST
, SET_ASIDE_REASON
, SET_ASIDE_PERCENT
, RESPONSE_COPIES_REQ
, DATE_CLOSE_PROJECTED
, DATETIME_PROPOSED
, DATE_SIGNED
, DATE_TERMINATED
, DATE_RENEWED
, TRN_CODE
, START_DATE
, END_DATE
, AUTHORING_ORG_ID
, BUY_OR_SELL
, ISSUE_OR_RECEIVE
, ESTIMATED_AMOUNT
, CHR_ID_RENEWED_TO
, ESTIMATED_AMOUNT_RENEWED
, CURRENCY_CODE_RENEWED
, USER_ACCESS_LEVEL
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, APPLICATION_ID
, RESOLVED_UNTIL
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRICE_LIST_ID
, PRICING_DATE
, TOTAL_LINE_LIST_PRICE
, SIGN_BY_DATE
, USER_ESTIMATED_AMOUNT
, GOVERNING_CONTRACT_YN
, CUST_ACCT_ID
, CONVERSION_TYPE
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, CONVERSION_EURO_RATE
, BILL_TO_SITE_USE_ID
, INV_RULE_ID
, RENEWAL_TYPE_CODE
, RENEWAL_NOTIFY_TO
, RENEWAL_END_DATE
, SHIP_TO_SITE_USE_ID
, PAYMENT_TERM_ID
, KHR_OBJECT_VERSION_NUMBER
, ISG_ID
, VPA_KHR_ID
, PDT_ID
, PRODUCT_NAME
, PRODUCT_DESCRIPTION
, AMD_CODE
, DATE_FIRST_ACTIVITY
, GENERATE_ACCRUAL_YN
, GENERATE_ACCRUAL_OVERRIDE_YN
, DATE_REFINANCED
, CREDIT_ACT_YN
, TERM_DURATION
, CONVERTED_ACCOUNT_YN
, DATE_CONVERSION_EFFECTIVE
, SYNDICATABLE_YN
, SALESTYPE_YN
, DATE_DEAL_TRANSFERRED
, DATETIME_PROPOSAL_EFFECTIVE
, DATETIME_PROPOSAL_INEFFECTIVE
, DATE_PROPOSAL_ACCEPTED
, PRE_TAX_YIELD
, AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE
, TARGET_PRE_TAX_YIELD
, TARGET_AFTER_TAX_YIELD
, TARGET_IMPLICIT_INTEREST_RATE
, TARGET_IMPLICIT_NONIDC_INTRATE
, DATE_LAST_INTERIM_INTEREST_CAL
, DEAL_TYPE
, PRE_TAX_IRR
, AFTER_TAX_IRR
, EXPECTED_DELIVERY_DATE
, ACCEPTED_DATE
, PREFUNDING_ELIGIBLE_YN
, REVOLVING_CREDIT_YN
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, MULTI_GAAP_YN
, RECOURSE_CODE
, LESSOR_SERV_ORG_CODE
, ASSIGNABLE_YN
, SECURITIZED_CODE
, SECURITIZATION_TYPE
, SUB_PRE_TAX_YIELD
, SUB_AFTER_TAX_YIELD
, SUB_IMPL_INTEREST_RATE
, SUB_IMPL_NON_IDC_INT_RATE
, SUB_PRE_TAX_IRR
, SUB_AFTER_TAX_IRR
, TOT_CL_TRANSFER_AMT
, TOT_CL_NET_TRANSFER_AMT
, TOT_CL_LIMIT
, TOT_CL_FUNDING_AMT
, CRS_ID
, TEMPLATE_TYPE_CODE
, TRADEIN_DESCRIPTION
, TRADEIN_AMOUNT
, DATE_TRADEIN
, DATE_FUNDING_EXPECTED
, LEGAL_ENTITY_ID
, CUSTOMER_CPL_ID
, CUSTOMER_OBJECT1_ID1
, CUSTOMER_OBJECT1_ID2
, CUSTOMER_JTOT_OBJECT1_CODE
, CUSTOMER_NAME
, CUSTOMER_ACCOUNT
, MLA_CONTRACT_NUMBER
, MLA_CHR_ID
, MLA_GVR_ID
, CREDIT_LINE_CONTRACT_NUMBER
, CREDIT_LINE_CHR_ID
, CREDIT_GVR_ID
, VPA_CONTRACT_NUMBER
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_NAME
, LEGAL_ADDRESS
, LEGAL_ADDRESS_ID
, SALES_REPRESENTATIVE_NAME
, REP_CONTACT_ID
, REP_CONTACT_OBJECT1_ID1
, REP_CONTACT_OBJECT1_ID2
, REP_CONTACT_JTOT_OBJECT1_CODE
, LEDGER_NAME
, LEDGER_ID
, INTEREST_CALC_MEANING
, REVENUE_RECOGNITION_MEANING
, BOOK_CLASS_MEANING
, PROGRAM_TEMPLATE_NAME
, PROGRAM_TEMPLATE_CHR_ID
, ORIGINATION_QUOTE_NAME
, ORIGINATION_QUOTE_ID
, LEASE_APPLICATION_NAME
, LEASE_APPLICATION_ID
, REPLACES_CONTRACT_NUMBER
, REPLACES_CHR_ID
, LEGACY_NUMBER
, ELIG_FOR_PREFUNDING_MEANING
, CAP_INTERIM_INTERST_MEANING
, CONVERTED_ACCT_MEANING
, PRIVATE_ACT_BOND_MEANING
, CONSUMER_CREDIT_ACT_MEANING
, NON_NOTIFICATION_MEANING
, ASSIGNABLE_MEANING
, LESSOR_INSURED_MEANING
, LESSOR_PAYEE_MEANING
, CURRENCY_CONV_TYPE_MEANING
, ACCEPTANCE_METHOD_MEANING
, REBOOK_LIMIT_DATE
, REBOOK_LIMIT_DATE_RGP_ID
, REBOOK_LIMIT_DATE_RGD_CODE
, REBOOK_LIMIT_DATE_RUL_ID
, REBOOK_LIMIT_RUL_INF_CAT
, REBOOK_LIMIT_RUL_INF1
, TAX_OWNER_CODE
, TAX_OWNER_MEANING
, TAX_OWNER_RGP_ID
, TAX_OWNER_RGD_CODE
, TAX_OWNER_RUL_ID
, TAX_OWNER_RUL_INF_CAT
, TAX_OWNER_RUL_INF1
, CAP_INTERIM_INT_RGP_ID
, CAP_INTERIM_INT_RGD_CODE
, CAP_INTERIM_INT_RUL_ID
, CAP_INTERIM_INT_RUL_INF_CAT
, CAP_INTERIM_INT_RUL_INF1
, PRV_ACT_BOND_RGP_ID
, PRV_ACT_BOND_RGD_CODE
, PRV_ACT_BOND_RUL_ID
, PRV_ACT_BOND_RUL_INF_CAT
, PRV_ACT_BOND_RUL_INF1
, NNTF_RGP_ID
, NNTF_RGD_CODE
, NNTF_RUL_ID
, NNTF_RUL_INF_CAT
, NNTF_RUL_INF1
, BILL_TO_ADDRESS_DESC
, SPLIT_FROM_CONTRACT_NUMBER
, SPLIT_FROM_CHR_ID
, SOURCE_CODE
, SOURCE_CHR_ID
, SOURCE_CONTRACT_NUMBER
, PRODUCT_SUBCLASS_CODE
, BILL_TO_RGP_ID
, BILL_TO_RUL_ID
, BILL_TO_RGD_CODE
, BILL_TO_RUL_INF_CAT
, BILL_TO_RUL_INF1
, RELEASED_ASSET_MEANING
, RLES_RGD_CODE
, RLES_RGP_ID
, RLES_RUL_ID
, RLES_RUL_INF1
, RLES_RUL_INF_CAT
, LAST_ACTIVATION_DATE
FROM APPS.OKL_K_HEADERS_FULL_UV;
APPS.OKL_K_HEADERS_FULL_UV is not referenced by any database object
|
|
|