APPS.OKL_K_HDRS_FULL_UV
[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | UI view for LLA Contract Details Page |
| Implementation/DBA Data: |
APPS.OKL_K_HDRS_FULL_UV
|
SELECT CHR.ID CHR_ID
, CHR.CONTRACT_NUMBER CHR_CONTRACT_NUMBER
, CHR.DESCRIPTION CHR_DESCRIPTION
, VERS.MAJOR_VERSION||'.'||VERS.MINOR_VERSION VERS_VERSION
, CHR.STS_CODE CHR_STS_CODE
, STSTL.MEANING CHR_STS_MEANING
, TO_CHAR(CHR.START_DATE) CHR_START_DATE
, TO_CHAR(CHR.END_DATE) CHR_END_DATE
, TO_CHAR(KHR.TERM_DURATION) KHR_TERM_DURATION
, CHR.CUST_PO_NUMBER CHR_CUST_PO_NUMBER
, CHR.INV_ORGANIZATION_ID CHR_INV_ORGANIZATION_ID
, CHR.AUTHORING_ORG_ID CHR_AUTHORING_ORG_ID
, KHR.GENERATE_ACCRUAL_YN KHR_GENERATE_ACCRUAL_YN
, KHR.SYNDICATABLE_YN KHR_SYNDICATABLE_YN
, KHR.PREFUNDING_ELIGIBLE_YN KHR_PREFUNDING_ELIGIBLE_YN
, KHR.REVOLVING_CREDIT_YN KHR_REVOLVING_CREDIT_YN
, KHR.CONVERTED_ACCOUNT_YN KHR_CONVERTED_ACCOUNT_YN
, KHR.CREDIT_ACT_YN KHR_CREDIT_ACT_YN
, CHR.TEMPLATE_YN CHR_TEMPLATE_YN
, TO_CHAR(CHR.DATE_SIGNED) CHR_DATE_SIGNED
, TO_CHAR(KHR.DATE_DEAL_TRANSFERRED) KHR_DATE_DEAL_TRANSFERRED
, TO_CHAR(KHR.ACCEPTED_DATE) KHR_ACCEPTED_DATE
, TO_CHAR(KHR.EXPECTED_DELIVERY_DATE) KHR_EXPECTED_DELIVERY_DATE
, KHR.AMD_CODE KHR_AMD_CODE
, KHR.DEAL_TYPE KHR_DEAL_TYPE
, CHR.ORIG_SYSTEM_REFERENCE1 CHR_ORIG_SYSTEM_REFERENCE1
, CHR.ORIG_SYSTEM_SOURCE_CODE CHR_ORIG_SYSTEM_SOURCE_CODE
, CHR.ORIG_SYSTEM_ID1 CHR_ORIG_SYSTEM_ID1
, TO_CHAR(NULL) MLA_CONTRACT_NUMBER
, TO_NUMBER(NULL) MLA_GVR_CHR_ID_REFERRED
, TO_NUMBER(NULL) MLA_GVR_ID
, CUST.ID CUST_ID
, CUST.OBJECT1_ID1 CUST_OBJECT1_ID1
, CUST.OBJECT1_ID2 CUST_OBJECT1_ID2
, CUST.JTOT_OBJECT1_CODE CUST_JTOT_OBJECT1_CODE
, 'CUST_NAME' CUST_NAME
, LESSOR.ID LESSOR_ID
, LESSOR.OBJECT1_ID1 LESSOR_OBJECT1_ID1
, LESSOR.OBJECT1_ID2 LESSOR_OBJECT1_ID2
, LESSOR.JTOT_OBJECT1_CODE LESSOR_JTOT_OBJECT1_CODE
, 'LESSOR_NAME' LESSOR_NAME
, CHR.CURRENCY_CODE CHR_CURRENCY_CODE
, CURRENCY.NAME CURRENCY_NAME
, KHR.CURRENCY_CONVERSION_TYPE KHR_CURRENCY_CONVERSION_TYPE
, TO_CHAR(KHR.CURRENCY_CONVERSION_RATE ) KHR_CURRENCY_CONVERSION_RATE
, TO_CHAR(KHR.CURRENCY_CONVERSION_DATE) KHR_CURRENCY_CONVERSION_DATE
, KHR.ASSIGNABLE_YN KHR_ASSIGNABLE_YN
, KHR.PDT_ID KHR_PDT_ID
, PRODUCT.NAME PRODUCT_NAME
, PRODUCT.DESCRIPTION PRODUCT_DESCRIPTION
, KHR.KHR_ID KHR_KHR_ID
, PROGRAM.CONTRACT_NUMBER PROGRAM_CONTRACT_NUMBER
, TO_CHAR(NULL) CL_CONTRACT_NUMBER
, TO_NUMBER(NULL) CL_GVR_CHR_ID_REFERRED
, TO_NUMBER(NULL) CL_GVR_ID
, BOOKS.SHORT_NAME BOOKS_SHORT_NAME
, BOOKS.LEDGER_ID BOOKS_SET_OF_BOOKS_ID
, OPER_UNITS.NAME OPER_UNITS_NAME
, CUST_SITE.DESCRIPTION CUST_SITE_DESCRIPTION
, CONTACT.ID CONTACT_ID
, CONTACT.OBJECT1_ID1 CONTACT_OBJECT1_ID1
, CONTACT.OBJECT1_ID2 CONTACT_OBJECT1_ID2
, CONTACT.JTOT_OBJECT1_CODE CONTACT_JTOT_OBJECT1_CODE
, 'CONTACT_NAME' CONTACT_NAME
, RG_LARLES.ID RG_LARLES_ID
, R_LARLES.ID R_LARLES_ID
, R_LARLES.RULE_INFORMATION1 R_LARLES_RULE_INFORMATION1
, 'COL_LARLES_FORM_LEFT_PROMPT' COL_LARLES_FROM_LEFT_PROMPT
, RG_LAREBL.ID RG_LAREBL_ID
, R_LAREBL.ID R_LAREBL_ID
, R_LAREBL.RULE_INFORMATION1 R_LAREBL_RULE_INFORMATION1
, 'COL_LAREBL_FORM_LEFT_PROMPT' COL_LAREBL_FORM_LEFT_PROMPT
, 'CUSTOMER_ACCOUNT' CUSTOMER_ACCOUNT
, CHR.CUST_ACCT_ID CHR_CUST_ACCT_ID
, RG_LATOWN.ID RG_LATOWN_ID
, R_LATOWN.ID R_LATOWN_ID
, R_LATOWN.RULE_INFORMATION1 R_LATOWN_RULE_INFORMATION1
, 'COL_LATOWN_FORM_LEFT_PROMPT' COL_LATOWN_FORM_LEFT_PROMPT
, RG_LANNTF.ID RG_LANNTF_ID
, R_LANNTF.ID R_LANNTF_ID
, R_LANNTF.RULE_INFORMATION1 R_LANNTF_RULE_INFORMATION1
, 'COL_LANNTF_FORM_LEFT_PROMPT' COL_LANNTF_FORM_LEFT_PROMPT
, RG_LACPLN.ID RG_LACPLN_ID
, R_LACPLN.ID R_LACPLN_ID
, R_LACPLN.RULE_INFORMATION1 R_LACPLN_RULE_INFORMATION1
, 'COL_LACPLN_FORM_LEFT_PROMPT' COL_LACPLN_FORM_LEFT_PROMPT
, RG_LAPACT.ID RG_LAPACT_ID
, R_LAPACT.ID R_LAPACT_ID
, R_LAPACT.RULE_INFORMATION1 R_LAPACT_RULE_INFORMATION1
, 'COL_LAPACT_FORM_LEFT_PROMPT' COL_LAPACT_FORM_LEFT_PROMPT
, PPV.INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS
, PPV.INTEREST_CALCULATION_MEANING INTEREST_CALCULATION_MEANING
, PPV.REVENUE_RECOGNITION_METHOD REVENUE_RECOGNITION_METHOD
, PPV.REVENUE_RECOGNITION_MEANING REVENUE_RECOGNITION_MEANING
, CHR.ORG_ID ORG_ID
, KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_V CHR
, OKL_K_HEADERS KHR
, OKC_K_PARTY_ROLES_V CUST
, OKC_K_PARTY_ROLES_V LESSOR
, OKC_CONTACTS_V CONTACT
, FND_CURRENCIES_VL CURRENCY
, OKX_CUST_SITE_USES_V CUST_SITE
, OKC_STATUSES_B STS
, OKC_STATUSES_TL STSTL
, OKC_K_VERS_NUMBERS_V VERS
, OKL_PRODUCTS_V PRODUCT
, OKC_K_HEADERS_V PROGRAM
, GL_LEDGERS_PUBLIC_V BOOKS
, HR_OPERATING_UNITS OPER_UNITS
, OKL_SYS_ACCT_OPTS_ALL SAOB
, OKC_RULE_GROUPS_B RG_LARLES
, OKC_RULES_B R_LARLES
, OKC_RULE_GROUPS_B RG_LAREBL
, OKC_RULES_B R_LAREBL
, OKC_RULE_GROUPS_B RG_LATOWN
, OKC_RULES_B R_LATOWN
, OKC_RULE_GROUPS_B RG_LANNTF
, OKC_RULES_B R_LANNTF
, OKC_RULE_GROUPS_B RG_LACPLN
, OKC_RULES_B R_LACPLN
, OKC_RULE_GROUPS_B RG_LAPACT
, OKC_RULES_B R_LAPACT
, OKL_PRODUCT_PARAMETERS_V PPV
WHERE CHR.ID=KHR.ID
AND CURRENCY.CURRENCY_CODE = CHR.CURRENCY_CODE
AND STS.CODE = CHR.STS_CODE
AND STSTL.CODE = STS.CODE
AND STSTL.LANGUAGE = USERENV('LANG')
AND VERS.CHR_ID = CHR.ID
AND PRODUCT.ID (+) = KHR.PDT_ID
AND PROGRAM.ID (+) = KHR.KHR_ID
AND CUST_SITE.PARTY_ID(+) = CUST.OBJECT1_ID1
AND CUST_SITE.SITE_USE_CODE(+) = 'LEGAL'
AND CHR.ID=CUST.CHR_ID (+)
AND CHR.ID=CUST.DNZ_CHR_ID (+)
AND CUST.RLE_CODE(+) ='LESSEE'
AND CHR.ID=LESSOR.CHR_ID (+)
AND CHR.ID=LESSOR.DNZ_CHR_ID (+)
AND LESSOR.RLE_CODE(+) ='LESSOR'
AND LESSOR.ID = CONTACT.CPL_ID(+)
AND CONTACT.CRO_CODE (+) = 'SALESPERSON'
AND OPER_UNITS.ORGANIZATION_ID = CHR.AUTHORING_ORG_ID
AND BOOKS.LEDGER_ID = SAOB.SET_OF_BOOKS_ID
AND SAOB.ORG_ID = CHR.AUTHORING_ORG_ID
AND RG_LARLES.CHR_ID(+) = CHR.ID
AND RG_LARLES.DNZ_CHR_ID(+) = CHR.ID
AND RG_LARLES.ID = R_LARLES.RGP_ID(+)
AND RG_LARLES.RGD_CODE(+) = 'LARLES'
AND R_LARLES.RULE_INFORMATION_CATEGORY(+) = 'LARLES'
AND RG_LAREBL.CHR_ID(+) = CHR.ID
AND RG_LAREBL.DNZ_CHR_ID(+) = CHR.ID
AND RG_LAREBL.ID = R_LAREBL.RGP_ID(+)
AND RG_LAREBL.RGD_CODE(+) = 'LAREBL'
AND R_LAREBL.RULE_INFORMATION_CATEGORY(+) = 'LAREBL'
AND RG_LATOWN.CHR_ID(+) = CHR.ID
AND RG_LATOWN.DNZ_CHR_ID(+) = CHR.ID
AND RG_LATOWN.ID = R_LATOWN.RGP_ID(+)
AND RG_LATOWN.RGD_CODE(+) = 'LATOWN'
AND R_LATOWN.RULE_INFORMATION_CATEGORY(+) = 'LATOWN'
AND RG_LANNTF.CHR_ID(+) = CHR.ID
AND RG_LANNTF.DNZ_CHR_ID(+) = CHR.ID
AND RG_LANNTF.ID = R_LANNTF.RGP_ID(+)
AND RG_LANNTF.RGD_CODE(+) = 'LANNTF'
AND R_LANNTF.RULE_INFORMATION_CATEGORY(+) = 'LANNTF'
AND RG_LACPLN.CHR_ID(+) = CHR.ID
AND RG_LACPLN.DNZ_CHR_ID(+) = CHR.ID
AND RG_LACPLN.ID = R_LACPLN.RGP_ID(+)
AND RG_LACPLN.RGD_CODE(+) = 'LACPLN'
AND R_LACPLN.RULE_INFORMATION_CATEGORY(+) = 'LACPLN'
AND RG_LAPACT.CHR_ID(+) = CHR.ID
AND RG_LAPACT.DNZ_CHR_ID(+) = CHR.ID
AND RG_LAPACT.ID = R_LAPACT.RGP_ID(+)
AND RG_LAPACT.RGD_CODE(+) = 'LAPACT'
AND R_LAPACT.RULE_INFORMATION_CATEGORY(+) = 'LAPACT'
AND KHR.PDT_ID = PPV.ID(+)