[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:	OKL.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

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

ARP_ADDR_LABEL_PKG - show dependent code

FND_CURRENCIES_TL

GL_LEDGERS_PUBLIC_V

HR_OPERATING_UNITS

HZ_LOCATIONS

HZ_PARTY_SITES

HZ_PARTY_SITE_USES

OKC_CONTACTS

OKC_K_HEADERS_B

OKC_K_HEADERS_V

OKC_K_PARTY_ROLES_B

OKC_K_VERS_NUMBERS

OKC_RULES_B

OKC_RULE_GROUPS_B

OKC_STATUSES_B

OKC_STATUSES_TL

OKC_UTIL - show dependent code

OKL_ACCOUNTING_UTIL - show dependent code

OKL_K_HEADERS

OKL_PRODUCTS

OKL_PRODUCT_PARAMETERS_V

OKL_SYS_ACCT_OPTS_ALL

APPS

OKL_AEL_GL_CTR_V

OKL_CS_LC_CONTRACT_PVT - show dependent code

OKL_DEAL_CREAT_PVT - show dependent code