ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2373869E053B46B63588994Y SELECT VAR.INTEREST_CALC_START_DATE DATE_FROM, VAR.INTEREST_CALC_END_DATE DATE_TO, DECODE(VAR.CALC_METHOD_CODE,'REAMORT','Y','N') COMPOSITE, LKP.MEANING INTEREST_CALCULATION, VAR.CALC_METHOD_CODE INTEREST_CALC_MTHD_CODE, VAR.INTEREST_RATE, SUM(VAR.INTEREST_AMT) INTEREST_AMOUNT, VAR.KHR_ID KHR_ID, CHR.CONTRACT_NUMBER CONTRACT_NUMBER, CHR.STS_CODE CONTRACT_STATUS, CHR.START_DATE CONTRACT_EFFECTIVE_FROM, CHR.END_DATE CONTRACT_EFFECTIVE_TO, CHR.CURRENCY_CODE CONTRACT_CURRENCY_CODE, CHR.AUTHORING_ORG_ID ORG_ID, CHR.CUST_ACCT_ID CUST_ACCOUNT_ID FROM OKL_VAR_INT_PARAMS_ALL VAR, FND_LOOKUPS LKP, OKC_K_HEADERS_ALL_B CHR WHERE VAR.KHR_ID = :P_CONTRACT_ID AND LKP.LOOKUP_TYPE = 'OKL_BPD_VAR_RATE_CALC_CODE' AND LKP.LOOKUP_CODE = VAR.CALC_METHOD_CODE AND VAR.KHR_ID = CHR.ID GROUP BY VAR.INTEREST_CALC_START_DATE, VAR.INTEREST_CALC_END_DATE, VAR.CALC_METHOD_CODE, LKP.MEANING, VAR.INTEREST_RATE, VAR.KHR_ID, CHR.CONTRACT_NUMBER, CHR.STS_CODE, CHR.START_DATE, CHR.END_DATE, CHR.CURRENCY_CODE, CHR.AUTHORING_ORG_ID, CHR.CUST_ACCT_ID ORDER BY CHR.START_DATE OKL OKLVARSCHED AR OKL جدول الأسعار المتغيرة Application: إدارة الإيجار Source: Short Name: OKLVARSCHED DB package: D OKL Variabler Zinssatzplan Application: Lease and Finance Management Source: Short Name: OKLVARSCHED DB package: F OKL Echéancier de taux variable Application: Lease and Finance Management Source: Short Name: OKLVARSCHED DB package: US OKL Variable Rate Schedule Application: Lease and Finance Management Source: Short Name: OKLVARSCHED DB package: ZHS OKL 可变利率明细表 Application: Oracle Lease and Finance Management Source: Short Name: OKLVARSCHED DB package: BI Publisher :p_contract_id