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


VIEW: APPS.OKL_K_HDRS_FULL_UV

Object Details
Object Name: OKL_K_HDRS_FULL_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_K_HDRS_FULL_UV
Subobject Name:
Status: VALID

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
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
Query Text

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;

Dependencies

[top of page]

APPS.OKL_K_HDRS_FULL_UV references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_LEDGERS_PUBLIC_V
ViewHR_OPERATING_UNITS
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
SynonymHZ_PARTY_SITE_USES
ViewOKC_CONTACTS_V
ViewOKC_K_HEADERS_V
ViewOKC_K_PARTY_ROLES_V
ViewOKC_K_VERS_NUMBERS_V
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B
SynonymOKC_STATUSES_B
SynonymOKC_STATUSES_TL
PL/SQL PackageOKC_UTIL - show dependent code
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_K_HEADERS
ViewOKL_PRODUCTS_V
ViewOKL_PRODUCT_PARAMETERS_V
SynonymOKL_SYS_ACCT_OPTS_ALL
APPS.OKL_K_HDRS_FULL_UV is referenced by following:

SchemaAPPS
ViewOKL_AEL_GL_CTR_V
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
Package BodyOKL_DEAL_CREAT_PVT - show dependent code