[Home] [Help] [Dependency Information]
Object Name: | OKL_K_HDRS_FULL_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_K_HDRS_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 |
---|---|---|---|---|
CHR_ID | NUMBER | Yes | Contract Identifier | |
CHR_CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | |
CHR_DESCRIPTION | VARCHAR2 | (1995) | ||
VERS_VERSION | VARCHAR2 | (81) | ||
CHR_STS_CODE | VARCHAR2 | (30) | Yes | |
CHR_STS_MEANING | VARCHAR2 | (90) | Yes | |
CHR_START_DATE | VARCHAR2 | (9) | ||
CHR_END_DATE | VARCHAR2 | (9) | ||
KHR_TERM_DURATION | VARCHAR2 | (40) | ||
CHR_CUST_PO_NUMBER | VARCHAR2 | (150) | ||
CHR_INV_ORGANIZATION_ID | NUMBER | Yes | ||
CHR_AUTHORING_ORG_ID | NUMBER | Yes | ||
KHR_GENERATE_ACCRUAL_YN | VARCHAR2 | (3) | ||
KHR_SYNDICATABLE_YN | VARCHAR2 | (3) | ||
KHR_PREFUNDING_ELIGIBLE_YN | VARCHAR2 | (3) | ||
KHR_REVOLVING_CREDIT_YN | VARCHAR2 | (3) | ||
KHR_CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | ||
KHR_CREDIT_ACT_YN | VARCHAR2 | (3) | ||
CHR_TEMPLATE_YN | VARCHAR2 | (3) | Yes | |
CHR_DATE_SIGNED | VARCHAR2 | (9) | ||
KHR_DATE_DEAL_TRANSFERRED | VARCHAR2 | (9) | ||
KHR_ACCEPTED_DATE | VARCHAR2 | (9) | ||
KHR_EXPECTED_DELIVERY_DATE | VARCHAR2 | (9) | ||
KHR_AMD_CODE | VARCHAR2 | (30) | ||
KHR_DEAL_TYPE | VARCHAR2 | (30) | ||
CHR_ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | ||
CHR_ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | ||
CHR_ORIG_SYSTEM_ID1 | NUMBER | |||
MLA_CONTRACT_NUMBER | VARCHAR2 | (0) | ||
MLA_GVR_CHR_ID_REFERRED | NUMBER | |||
MLA_GVR_ID | NUMBER | |||
CUST_ID | NUMBER | |||
CUST_OBJECT1_ID1 | VARCHAR2 | (40) | ||
CUST_OBJECT1_ID2 | VARCHAR2 | (200) | ||
CUST_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | ||
CUST_NAME | CHAR | (9) | ||
LESSOR_ID | NUMBER | |||
LESSOR_OBJECT1_ID1 | VARCHAR2 | (40) | ||
LESSOR_OBJECT1_ID2 | VARCHAR2 | (200) | ||
LESSOR_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | ||
LESSOR_NAME | CHAR | (11) | ||
CHR_CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_NAME | VARCHAR2 | (80) | Yes | |
KHR_CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
KHR_CURRENCY_CONVERSION_RATE | VARCHAR2 | (40) | Currency conversion rate | |
KHR_CURRENCY_CONVERSION_DATE | VARCHAR2 | (9) | Currency conversion date | |
KHR_ASSIGNABLE_YN | VARCHAR2 | (3) | ||
KHR_PDT_ID | NUMBER | |||
PRODUCT_NAME | VARCHAR2 | (150) | ||
PRODUCT_DESCRIPTION | VARCHAR2 | (1995) | ||
KHR_KHR_ID | NUMBER | |||
PROGRAM_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
CL_CONTRACT_NUMBER | VARCHAR2 | (0) | ||
CL_GVR_CHR_ID_REFERRED | NUMBER | |||
CL_GVR_ID | NUMBER | |||
BOOKS_SHORT_NAME | VARCHAR2 | (20) | Yes | |
BOOKS_SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
OPER_UNITS_NAME | VARCHAR2 | (240) | Yes | |
CUST_SITE_DESCRIPTION | VARCHAR2 | (4000) | ||
CONTACT_ID | NUMBER | |||
CONTACT_OBJECT1_ID1 | VARCHAR2 | (40) | ||
CONTACT_OBJECT1_ID2 | VARCHAR2 | (200) | ||
CONTACT_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | ||
CONTACT_NAME | CHAR | (12) | ||
RG_LARLES_ID | NUMBER | |||
R_LARLES_ID | NUMBER | |||
R_LARLES_RULE_INFORMATION1 | VARCHAR2 | (450) | ||
COL_LARLES_FORM_LEFT_PROMPT | CHAR | (27) | ||
RG_LAREBL_ID | NUMBER | |||
R_LAREBL_ID | NUMBER | |||
R_LAREBL_RULE_INFORMATION1 | VARCHAR2 | (450) | ||
COL_LAREBL_FORM_LEFT_PROMPT | CHAR | (27) | ||
CUSTOMER_ACCOUNT | CHAR | (16) | ||
CHR_CUST_ACCT_ID | NUMBER | (15) | ||
RG_LATOWN_ID | NUMBER | |||
R_LATOWN_ID | NUMBER | |||
R_LATOWN_RULE_INFORMATION1 | VARCHAR2 | (450) | ||
COL_LATOWN_FORM_LEFT_PROMPT | CHAR | (27) | ||
RG_LANNTF_ID | NUMBER | |||
R_LANNTF_ID | NUMBER | |||
R_LANNTF_RULE_INFORMATION1 | VARCHAR2 | (450) | ||
COL_LANNTF_FORM_LEFT_PROMPT | CHAR | (27) | ||
RG_LACPLN_ID | NUMBER | |||
R_LACPLN_ID | NUMBER | |||
R_LACPLN_RULE_INFORMATION1 | VARCHAR2 | (450) | ||
COL_LACPLN_FORM_LEFT_PROMPT | CHAR | (27) | ||
RG_LAPACT_ID | NUMBER | |||
R_LAPACT_ID | NUMBER | |||
R_LAPACT_RULE_INFORMATION1 | VARCHAR2 | (450) | ||
COL_LAPACT_FORM_LEFT_PROMPT | CHAR | (27) | ||
INTEREST_CALCULATION_BASIS | VARCHAR2 | (150) | Interest calculation basis code | |
INTEREST_CALCULATION_MEANING | VARCHAR2 | (4000) | Interest calculation basis meaning | |
REVENUE_RECOGNITION_METHOD | VARCHAR2 | (150) | Revenue recognition method code | |
REVENUE_RECOGNITION_MEANING | VARCHAR2 | (4000) | Revenue recognition method meaning | |
ORG_ID | NUMBER | Yes | Operating Unit Identifier | |
LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES |
Cut, paste (and edit) the following text to query this object:
SELECT CHR_ID
, CHR_CONTRACT_NUMBER
, CHR_DESCRIPTION
, VERS_VERSION
, CHR_STS_CODE
, CHR_STS_MEANING
, CHR_START_DATE
, CHR_END_DATE
, KHR_TERM_DURATION
, CHR_CUST_PO_NUMBER
, CHR_INV_ORGANIZATION_ID
, CHR_AUTHORING_ORG_ID
, KHR_GENERATE_ACCRUAL_YN
, KHR_SYNDICATABLE_YN
, KHR_PREFUNDING_ELIGIBLE_YN
, KHR_REVOLVING_CREDIT_YN
, KHR_CONVERTED_ACCOUNT_YN
, KHR_CREDIT_ACT_YN
, CHR_TEMPLATE_YN
, CHR_DATE_SIGNED
, KHR_DATE_DEAL_TRANSFERRED
, KHR_ACCEPTED_DATE
, KHR_EXPECTED_DELIVERY_DATE
, KHR_AMD_CODE
, KHR_DEAL_TYPE
, CHR_ORIG_SYSTEM_REFERENCE1
, CHR_ORIG_SYSTEM_SOURCE_CODE
, CHR_ORIG_SYSTEM_ID1
, MLA_CONTRACT_NUMBER
, MLA_GVR_CHR_ID_REFERRED
, MLA_GVR_ID
, CUST_ID
, CUST_OBJECT1_ID1
, CUST_OBJECT1_ID2
, CUST_JTOT_OBJECT1_CODE
, CUST_NAME
, LESSOR_ID
, LESSOR_OBJECT1_ID1
, LESSOR_OBJECT1_ID2
, LESSOR_JTOT_OBJECT1_CODE
, LESSOR_NAME
, CHR_CURRENCY_CODE
, CURRENCY_NAME
, KHR_CURRENCY_CONVERSION_TYPE
, KHR_CURRENCY_CONVERSION_RATE
, KHR_CURRENCY_CONVERSION_DATE
, KHR_ASSIGNABLE_YN
, KHR_PDT_ID
, PRODUCT_NAME
, PRODUCT_DESCRIPTION
, KHR_KHR_ID
, PROGRAM_CONTRACT_NUMBER
, CL_CONTRACT_NUMBER
, CL_GVR_CHR_ID_REFERRED
, CL_GVR_ID
, BOOKS_SHORT_NAME
, BOOKS_SET_OF_BOOKS_ID
, OPER_UNITS_NAME
, CUST_SITE_DESCRIPTION
, CONTACT_ID
, CONTACT_OBJECT1_ID1
, CONTACT_OBJECT1_ID2
, CONTACT_JTOT_OBJECT1_CODE
, CONTACT_NAME
, RG_LARLES_ID
, R_LARLES_ID
, R_LARLES_RULE_INFORMATION1
, COL_LARLES_FORM_LEFT_PROMPT
, RG_LAREBL_ID
, R_LAREBL_ID
, R_LAREBL_RULE_INFORMATION1
, COL_LAREBL_FORM_LEFT_PROMPT
, CUSTOMER_ACCOUNT
, CHR_CUST_ACCT_ID
, RG_LATOWN_ID
, R_LATOWN_ID
, R_LATOWN_RULE_INFORMATION1
, COL_LATOWN_FORM_LEFT_PROMPT
, RG_LANNTF_ID
, R_LANNTF_ID
, R_LANNTF_RULE_INFORMATION1
, COL_LANNTF_FORM_LEFT_PROMPT
, RG_LACPLN_ID
, R_LACPLN_ID
, R_LACPLN_RULE_INFORMATION1
, COL_LACPLN_FORM_LEFT_PROMPT
, RG_LAPACT_ID
, R_LAPACT_ID
, R_LAPACT_RULE_INFORMATION1
, COL_LAPACT_FORM_LEFT_PROMPT
, INTEREST_CALCULATION_BASIS
, INTEREST_CALCULATION_MEANING
, REVENUE_RECOGNITION_METHOD
, REVENUE_RECOGNITION_MEANING
, ORG_ID
, LEGAL_ENTITY_ID
FROM APPS.OKL_K_HDRS_FULL_UV;
|
|
|