eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on DUAL

Line 855: FROM DUAL;

851:
852: l_new_seq_value NUMBER;
853: CURSOR okl_new_tmpt_set_copy_no IS
854: SELECT OKL_GTS_NAME_SEQ.NEXTVAL next_number
855: FROM DUAL;
856:
857: BEGIN
858:
859: -- Perform the Initializations

Line 2103: ,'RESIDUAL_VALUE'

2099: ,'BOOK_DEPRECIATION'
2100: ,'FEDERAL_DEPRECIATION'
2101: ,'INVESTOR_PRETAX_INCOME'
2102: ,'INVESTOR_RENTAL_ACCRUAL'
2103: ,'RESIDUAL_VALUE'
2104: ,'STATE_DEPRECIATION'
2105: ,'VARIABLE_INTEREST_SCHEDULE'
2106: -- Modified by RGOOTY
2107: -- Bug 4050701: Start

Line 2116: ,'VENDOR_RESIDUAL_SHARING'

2112: -- Bug 4062730: End
2113: -- Bug 4110239: Start
2114: ,'GENERAL_LOSS_PROVISION'
2115: -- Bug 4110239: End
2116: ,'VENDOR_RESIDUAL_SHARING'
2117: --Bug 4616460 added new stream type purpose
2118: ,'ASSET_SALE_RECEIVABLE'
2119: --Bug 4616460 end
2120: -- Bug 5730462: Add a new purpose for EB Tax R12 IA

Line 2221: 'RESIDUAL_VALUE'

2217: FROM FND_LOOKUPS
2218: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2219: AND LOOKUP_CODE IN
2220: (
2221: 'RESIDUAL_VALUE'
2222: )
2223: MINUS
2224: SELECT distinct stb.stream_type_purpose purpose
2225: FROM OKL_ST_GEN_TMPT_LNS gtl

Line 2231: 'RESIDUAL_VALUE'

2227: WHERE gtl.primary_sty_id = stb.id
2228: AND gtl.primary_yn = 'Y'
2229: AND stb.stream_type_purpose IN
2230: (
2231: 'RESIDUAL_VALUE'
2232: )
2233: and GTL.GTT_ID = p_gtt_id;
2234:
2235: --Bug 5139013 dpsingh start

Line 2607: ,'RESIDUAL_GUARANTEED'

2603: ,'PV_RV_GUARANTEED'
2604: ,'PV_RV_INSURED'
2605: ,'PV_RV_UNGUARANTEED'
2606: ,'PV_RV_UNINSURED'
2607: ,'RESIDUAL_GUARANTEED'
2608: ,'RV_INSURANCE_PREMIUM'
2609: )
2610: MINUS
2611: SELECT distinct stb.stream_type_purpose purpose

Line 2624: ,'RESIDUAL_GUARANTEED'

2620: ,'PV_RV_GUARANTEED'
2621: ,'PV_RV_INSURED'
2622: ,'PV_RV_UNGUARANTEED'
2623: ,'PV_RV_UNINSURED'
2624: ,'RESIDUAL_GUARANTEED'
2625: ,'RV_INSURANCE_PREMIUM'
2626: )
2627: and GTL.GTT_ID = p_gtt_id
2628: and sstb.id = gtl.primary_sty_id

Line 2631: 'RESIDUAL_VALUE'

2627: and GTL.GTT_ID = p_gtt_id
2628: and sstb.id = gtl.primary_sty_id
2629: and sstb.stream_Type_purpose IN
2630: (
2631: 'RESIDUAL_VALUE'
2632: )
2633: AND EXISTS
2634: (
2635: SELECT 1

Line 2813: ,'RESIDUAL_GUARANTEED'

2809: ,'PV_RV_UNGUARANTEED'
2810: ,'PV_RV_UNINSURED'
2811: ,'RENEWAL_PROPERTY_TAX'
2812: ,'RENEWAL_RENT'
2813: ,'RESIDUAL_GUARANTEED'
2814: ,'RV_INSURANCE_PREMIUM'
2815: ,'RESIDUAL_VALUE'
2816: ,'STATE_DEPRECIATION'
2817: ,'STIP_LOSS_VALUE'

Line 2815: ,'RESIDUAL_VALUE'

2811: ,'RENEWAL_PROPERTY_TAX'
2812: ,'RENEWAL_RENT'
2813: ,'RESIDUAL_GUARANTEED'
2814: ,'RV_INSURANCE_PREMIUM'
2815: ,'RESIDUAL_VALUE'
2816: ,'STATE_DEPRECIATION'
2817: ,'STIP_LOSS_VALUE'
2818: ,'TERMINATION_VALUE'
2819: -- Purposes specific to DF,ST type

Line 2825: ,'VENDOR_RESIDUAL_SHARING'

2821: ,'PROCESSING_FEE'
2822: ,'PROCESSING_FEE_ACCRUAL'
2823: ,'DOWN_PAYMENT'
2824: ,'INSURANCE_ESTIMATE_PAYMENT'
2825: ,'VENDOR_RESIDUAL_SHARING'
2826: ,'QUOTE_PER_DIEM'
2827: --Bug 4616460 added new stream type purpose
2828: ,'ASSET_SALE_RECEIVABLE'
2829: ,'FLOAT_FACTOR_ADJUSTMENT'

Line 2974: ,'RESIDUAL_GUARANTEED'

2970: ,'PV_RV_UNGUARANTEED'
2971: ,'PV_RV_UNINSURED'
2972: ,'RENEWAL_PROPERTY_TAX'
2973: ,'RENEWAL_RENT'
2974: ,'RESIDUAL_GUARANTEED'
2975: ,'RV_INSURANCE_PREMIUM'
2976: ,'RESIDUAL_VALUE'
2977: ,'STATE_DEPRECIATION'
2978: ,'STIP_LOSS_VALUE'

Line 2976: ,'RESIDUAL_VALUE'

2972: ,'RENEWAL_PROPERTY_TAX'
2973: ,'RENEWAL_RENT'
2974: ,'RESIDUAL_GUARANTEED'
2975: ,'RV_INSURANCE_PREMIUM'
2976: ,'RESIDUAL_VALUE'
2977: ,'STATE_DEPRECIATION'
2978: ,'STIP_LOSS_VALUE'
2979: ,'TERMINATION_VALUE'
2980: -- Purposes specific to OP Type

Line 2986: ,'VENDOR_RESIDUAL_SHARING'

2982: ,'PROCESSING_FEE'
2983: ,'PROCESSING_FEE_ACCRUAL'
2984: ,'DOWN_PAYMENT'
2985: ,'INSURANCE_ESTIMATE_PAYMENT'
2986: ,'VENDOR_RESIDUAL_SHARING'
2987: ,'QUOTE_PER_DIEM'
2988: --Bug 4616460 added new stream type purpose
2989: ,'ASSET_SALE_RECEIVABLE'
2990: --Bug 4616460 end

Line 3167: l_purpose_list_rv VARCHAR2(10000); -- For Residual Value Dependents

3163: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
3164:
3165: l_purpose_list VARCHAR2(10000);
3166: l_purpose_list_rent VARCHAR2(10000); -- For Rent Dependents
3167: l_purpose_list_rv VARCHAR2(10000); -- For Residual Value Dependents
3168: l_purpose_list_vi VARCHAR2(10000); -- For Variable Interest Dependents
3169: i NUMBER := 0;
3170: -- Bug 4129154: End
3171: BEGIN

Line 3204: fin_only_one_as_primary_rec.purpose = 'VENDOR_RESIDUAL_SHARING'

3200: l_purpose_list := '';
3201: FOR fin_only_one_as_primary_rec IN fin_only_one_as_primary_csr(l_gtt_id)
3202: LOOP
3203: IF l_icm = 'FIXED_UPGRADE' AND
3204: fin_only_one_as_primary_rec.purpose = 'VENDOR_RESIDUAL_SHARING'
3205: THEN
3206: -- VR Upgrade. Bug 4756154
3207: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.
3208: -- So, for SGTs with ICM = "Fixed Upgrade", we are removing the validation

Line 3207: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.

3203: IF l_icm = 'FIXED_UPGRADE' AND
3204: fin_only_one_as_primary_rec.purpose = 'VENDOR_RESIDUAL_SHARING'
3205: THEN
3206: -- VR Upgrade. Bug 4756154
3207: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.
3208: -- So, for SGTs with ICM = "Fixed Upgrade", we are removing the validation
3209: -- which checks the mandatory presence of the VENDOR_RESIDUAL_SHARING purpose streams.
3210: NULL;
3211: ELSE

Line 3209: -- which checks the mandatory presence of the VENDOR_RESIDUAL_SHARING purpose streams.

3205: THEN
3206: -- VR Upgrade. Bug 4756154
3207: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.
3208: -- So, for SGTs with ICM = "Fixed Upgrade", we are removing the validation
3209: -- which checks the mandatory presence of the VENDOR_RESIDUAL_SHARING purpose streams.
3210: NULL;
3211: ELSE
3212: l_purpose_list := l_purpose_list ||
3213: OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

Line 3435: ( G_OKL_FIN_PRIMARY_PURPOSES, 'RESIDUAL_VALUE' )

3431: ,p_during_upd_flag
3432: ,l_message
3433: ,p_token1 => 'PRISTREAM'
3434: ,p_value1 => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
3435: ( G_OKL_FIN_PRIMARY_PURPOSES, 'RESIDUAL_VALUE' )
3436: ,p_token2 => G_PURPOSE_TOKEN
3437: ,p_value2 => l_purpose_list_rv
3438: );
3439: l_error_msgs_tbl(l_msgs_count).error_message := l_message;

Line 3717: ,'INVESTOR_RESIDUAL_BUYBACK'

3713: ,'INVESTOR_RECEIVABLE'
3714: ,'INVESTOR_RENT_BUYBACK'
3715: ,'INVESTOR_RENT_DISB_BASIS'
3716: ,'INVESTOR_RENT_PAYABLE'
3717: ,'INVESTOR_RESIDUAL_BUYBACK'
3718: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3719: ,'INVESTOR_RESIDUAL_PAY'
3720: )
3721: AND GTL.GTT_ID = p_gtt_id

Line 3718: ,'INVESTOR_RESIDUAL_DISB_BASIS'

3714: ,'INVESTOR_RENT_BUYBACK'
3715: ,'INVESTOR_RENT_DISB_BASIS'
3716: ,'INVESTOR_RENT_PAYABLE'
3717: ,'INVESTOR_RESIDUAL_BUYBACK'
3718: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3719: ,'INVESTOR_RESIDUAL_PAY'
3720: )
3721: AND GTL.GTT_ID = p_gtt_id
3722: group by stb.stream_type_purpose

Line 3719: ,'INVESTOR_RESIDUAL_PAY'

3715: ,'INVESTOR_RENT_DISB_BASIS'
3716: ,'INVESTOR_RENT_PAYABLE'
3717: ,'INVESTOR_RESIDUAL_BUYBACK'
3718: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3719: ,'INVESTOR_RESIDUAL_PAY'
3720: )
3721: AND GTL.GTT_ID = p_gtt_id
3722: group by stb.stream_type_purpose
3723: having count(stb.stream_type_purpose) > 1;

Line 3747: ,'INVESTOR_RESIDUAL_BUYBACK'

3743: ,'INVESTOR_RECEIVABLE'
3744: ,'INVESTOR_RENT_BUYBACK'
3745: ,'INVESTOR_RENT_DISB_BASIS'
3746: ,'INVESTOR_RENT_PAYABLE'
3747: ,'INVESTOR_RESIDUAL_BUYBACK'
3748: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3749: ,'INVESTOR_RESIDUAL_PAY'
3750: -- Change requested by Satya on Nov 10
3751: ,'PV_RENT_SECURITIZED'

Line 3748: ,'INVESTOR_RESIDUAL_DISB_BASIS'

3744: ,'INVESTOR_RENT_BUYBACK'
3745: ,'INVESTOR_RENT_DISB_BASIS'
3746: ,'INVESTOR_RENT_PAYABLE'
3747: ,'INVESTOR_RESIDUAL_BUYBACK'
3748: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3749: ,'INVESTOR_RESIDUAL_PAY'
3750: -- Change requested by Satya on Nov 10
3751: ,'PV_RENT_SECURITIZED'
3752: ,'PV_RV_SECURITIZED'

Line 3749: ,'INVESTOR_RESIDUAL_PAY'

3745: ,'INVESTOR_RENT_DISB_BASIS'
3746: ,'INVESTOR_RENT_PAYABLE'
3747: ,'INVESTOR_RESIDUAL_BUYBACK'
3748: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3749: ,'INVESTOR_RESIDUAL_PAY'
3750: -- Change requested by Satya on Nov 10
3751: ,'PV_RENT_SECURITIZED'
3752: ,'PV_RV_SECURITIZED'
3753: )

Line 3777: ,'INVESTOR_RESIDUAL_BUYBACK'

3773: ,'INVESTOR_RECEIVABLE'
3774: ,'INVESTOR_RENT_BUYBACK'
3775: ,'INVESTOR_RENT_DISB_BASIS'
3776: ,'INVESTOR_RENT_PAYABLE'
3777: ,'INVESTOR_RESIDUAL_BUYBACK'
3778: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3779: ,'INVESTOR_RESIDUAL_PAY'
3780: -- Change requested by Satya on Nov 10
3781: ,'PV_RENT_SECURITIZED'

Line 3778: ,'INVESTOR_RESIDUAL_DISB_BASIS'

3774: ,'INVESTOR_RENT_BUYBACK'
3775: ,'INVESTOR_RENT_DISB_BASIS'
3776: ,'INVESTOR_RENT_PAYABLE'
3777: ,'INVESTOR_RESIDUAL_BUYBACK'
3778: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3779: ,'INVESTOR_RESIDUAL_PAY'
3780: -- Change requested by Satya on Nov 10
3781: ,'PV_RENT_SECURITIZED'
3782: ,'PV_RV_SECURITIZED'

Line 3779: ,'INVESTOR_RESIDUAL_PAY'

3775: ,'INVESTOR_RENT_DISB_BASIS'
3776: ,'INVESTOR_RENT_PAYABLE'
3777: ,'INVESTOR_RESIDUAL_BUYBACK'
3778: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3779: ,'INVESTOR_RESIDUAL_PAY'
3780: -- Change requested by Satya on Nov 10
3781: ,'PV_RENT_SECURITIZED'
3782: ,'PV_RV_SECURITIZED'
3783: )

Line 4065: FROM DUAL

4061: )
4062: MINUS
4063: (
4064: SELECT 'FEE_RENEWAL' PURPOSE
4065: FROM DUAL
4066: WHERE p_exclude_fr = 'T'
4067: );
4068: l_exclude_fr VARCHAR2(1) := OKL_API.G_TRUE;
4069: BEGIN