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 869: FROM DUAL;

865:
866: l_new_seq_value NUMBER;
867: CURSOR okl_new_tmpt_set_copy_no IS
868: SELECT OKL_GTS_NAME_SEQ.NEXTVAL next_number
869: FROM DUAL;
870:
871: BEGIN
872:
873: -- Perform the Initializations

Line 2118: ,'RESIDUAL_VALUE'

2114: ,'BOOK_DEPRECIATION'
2115: ,'FEDERAL_DEPRECIATION'
2116: ,'INVESTOR_PRETAX_INCOME'
2117: ,'INVESTOR_RENTAL_ACCRUAL'
2118: ,'RESIDUAL_VALUE'
2119: ,'STATE_DEPRECIATION'
2120: ,'VARIABLE_INTEREST_SCHEDULE'
2121: -- Modified by RGOOTY
2122: -- Bug 4050701: Start

Line 2131: ,'VENDOR_RESIDUAL_SHARING'

2127: -- Bug 4062730: End
2128: -- Bug 4110239: Start
2129: ,'GENERAL_LOSS_PROVISION'
2130: -- Bug 4110239: End
2131: ,'VENDOR_RESIDUAL_SHARING'
2132: --Bug 4616460 added new stream type purpose
2133: ,'ASSET_SALE_RECEIVABLE'
2134: --Bug 4616460 end
2135: -- Bug 5730462: Add a new purpose for EB Tax R12 IA

Line 2236: 'RESIDUAL_VALUE'

2232: FROM FND_LOOKUPS
2233: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2234: AND LOOKUP_CODE IN
2235: (
2236: 'RESIDUAL_VALUE'
2237: )
2238: MINUS
2239: SELECT distinct stb.stream_type_purpose purpose
2240: FROM OKL_ST_GEN_TMPT_LNS gtl

Line 2246: 'RESIDUAL_VALUE'

2242: WHERE gtl.primary_sty_id = stb.id
2243: AND gtl.primary_yn = 'Y'
2244: AND stb.stream_type_purpose IN
2245: (
2246: 'RESIDUAL_VALUE'
2247: )
2248: and GTL.GTT_ID = p_gtt_id;
2249:
2250: --Bug 5139013 dpsingh start

Line 2622: ,'RESIDUAL_GUARANTEED'

2618: ,'PV_RV_GUARANTEED'
2619: ,'PV_RV_INSURED'
2620: ,'PV_RV_UNGUARANTEED'
2621: ,'PV_RV_UNINSURED'
2622: ,'RESIDUAL_GUARANTEED'
2623: ,'RV_INSURANCE_PREMIUM'
2624: )
2625: MINUS
2626: SELECT distinct stb.stream_type_purpose purpose

Line 2639: ,'RESIDUAL_GUARANTEED'

2635: ,'PV_RV_GUARANTEED'
2636: ,'PV_RV_INSURED'
2637: ,'PV_RV_UNGUARANTEED'
2638: ,'PV_RV_UNINSURED'
2639: ,'RESIDUAL_GUARANTEED'
2640: ,'RV_INSURANCE_PREMIUM'
2641: )
2642: and GTL.GTT_ID = p_gtt_id
2643: and sstb.id = gtl.primary_sty_id

Line 2646: 'RESIDUAL_VALUE'

2642: and GTL.GTT_ID = p_gtt_id
2643: and sstb.id = gtl.primary_sty_id
2644: and sstb.stream_Type_purpose IN
2645: (
2646: 'RESIDUAL_VALUE'
2647: )
2648: AND EXISTS
2649: (
2650: SELECT 1

Line 2828: ,'RESIDUAL_GUARANTEED'

2824: ,'PV_RV_UNGUARANTEED'
2825: ,'PV_RV_UNINSURED'
2826: ,'RENEWAL_PROPERTY_TAX'
2827: ,'RENEWAL_RENT'
2828: ,'RESIDUAL_GUARANTEED'
2829: ,'RV_INSURANCE_PREMIUM'
2830: ,'RESIDUAL_VALUE'
2831: ,'STATE_DEPRECIATION'
2832: ,'STIP_LOSS_VALUE'

Line 2830: ,'RESIDUAL_VALUE'

2826: ,'RENEWAL_PROPERTY_TAX'
2827: ,'RENEWAL_RENT'
2828: ,'RESIDUAL_GUARANTEED'
2829: ,'RV_INSURANCE_PREMIUM'
2830: ,'RESIDUAL_VALUE'
2831: ,'STATE_DEPRECIATION'
2832: ,'STIP_LOSS_VALUE'
2833: ,'TERMINATION_VALUE'
2834: -- Purposes specific to DF,ST type

Line 2840: ,'VENDOR_RESIDUAL_SHARING'

2836: ,'PROCESSING_FEE'
2837: ,'PROCESSING_FEE_ACCRUAL'
2838: ,'DOWN_PAYMENT'
2839: ,'INSURANCE_ESTIMATE_PAYMENT'
2840: ,'VENDOR_RESIDUAL_SHARING'
2841: ,'QUOTE_PER_DIEM'
2842: --Bug 4616460 added new stream type purpose
2843: ,'ASSET_SALE_RECEIVABLE'
2844: ,'FLOAT_FACTOR_ADJUSTMENT'

Line 2989: ,'RESIDUAL_GUARANTEED'

2985: ,'PV_RV_UNGUARANTEED'
2986: ,'PV_RV_UNINSURED'
2987: ,'RENEWAL_PROPERTY_TAX'
2988: ,'RENEWAL_RENT'
2989: ,'RESIDUAL_GUARANTEED'
2990: ,'RV_INSURANCE_PREMIUM'
2991: ,'RESIDUAL_VALUE'
2992: ,'STATE_DEPRECIATION'
2993: ,'STIP_LOSS_VALUE'

Line 2991: ,'RESIDUAL_VALUE'

2987: ,'RENEWAL_PROPERTY_TAX'
2988: ,'RENEWAL_RENT'
2989: ,'RESIDUAL_GUARANTEED'
2990: ,'RV_INSURANCE_PREMIUM'
2991: ,'RESIDUAL_VALUE'
2992: ,'STATE_DEPRECIATION'
2993: ,'STIP_LOSS_VALUE'
2994: ,'TERMINATION_VALUE'
2995: -- Purposes specific to OP Type

Line 3001: ,'VENDOR_RESIDUAL_SHARING'

2997: ,'PROCESSING_FEE'
2998: ,'PROCESSING_FEE_ACCRUAL'
2999: ,'DOWN_PAYMENT'
3000: ,'INSURANCE_ESTIMATE_PAYMENT'
3001: ,'VENDOR_RESIDUAL_SHARING'
3002: ,'QUOTE_PER_DIEM'
3003: --Bug 4616460 added new stream type purpose
3004: ,'ASSET_SALE_RECEIVABLE'
3005: --Bug 4616460 end

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

3178: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
3179:
3180: l_purpose_list VARCHAR2(10000);
3181: l_purpose_list_rent VARCHAR2(10000); -- For Rent Dependents
3182: l_purpose_list_rv VARCHAR2(10000); -- For Residual Value Dependents
3183: l_purpose_list_vi VARCHAR2(10000); -- For Variable Interest Dependents
3184: i NUMBER := 0;
3185: -- Bug 4129154: End
3186: BEGIN

Line 3219: fin_only_one_as_primary_rec.purpose = 'VENDOR_RESIDUAL_SHARING'

3215: l_purpose_list := '';
3216: FOR fin_only_one_as_primary_rec IN fin_only_one_as_primary_csr(l_gtt_id)
3217: LOOP
3218: IF l_icm = 'FIXED_UPGRADE' AND
3219: fin_only_one_as_primary_rec.purpose = 'VENDOR_RESIDUAL_SHARING'
3220: THEN
3221: -- VR Upgrade. Bug 4756154
3222: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.
3223: -- So, for SGTs with ICM = "Fixed Upgrade", we are removing the validation

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

3218: IF l_icm = 'FIXED_UPGRADE' AND
3219: fin_only_one_as_primary_rec.purpose = 'VENDOR_RESIDUAL_SHARING'
3220: THEN
3221: -- VR Upgrade. Bug 4756154
3222: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.
3223: -- So, for SGTs with ICM = "Fixed Upgrade", we are removing the validation
3224: -- which checks the mandatory presence of the VENDOR_RESIDUAL_SHARING purpose streams.
3225: NULL;
3226: ELSE

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

3220: THEN
3221: -- VR Upgrade. Bug 4756154
3222: -- OKL.H only introduced the VENDOR_RESIDUAL_SHARING, OKL.G doesnot have this purpose at all.
3223: -- So, for SGTs with ICM = "Fixed Upgrade", we are removing the validation
3224: -- which checks the mandatory presence of the VENDOR_RESIDUAL_SHARING purpose streams.
3225: NULL;
3226: ELSE
3227: l_purpose_list := l_purpose_list ||
3228: OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

Line 3450: ( G_OKL_FIN_PRIMARY_PURPOSES, 'RESIDUAL_VALUE' )

3446: ,p_during_upd_flag
3447: ,l_message
3448: ,p_token1 => 'PRISTREAM'
3449: ,p_value1 => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
3450: ( G_OKL_FIN_PRIMARY_PURPOSES, 'RESIDUAL_VALUE' )
3451: ,p_token2 => G_PURPOSE_TOKEN
3452: ,p_value2 => l_purpose_list_rv
3453: );
3454: l_error_msgs_tbl(l_msgs_count).error_message := l_message;

Line 3732: ,'INVESTOR_RESIDUAL_BUYBACK'

3728: ,'INVESTOR_RECEIVABLE'
3729: ,'INVESTOR_RENT_BUYBACK'
3730: ,'INVESTOR_RENT_DISB_BASIS'
3731: ,'INVESTOR_RENT_PAYABLE'
3732: ,'INVESTOR_RESIDUAL_BUYBACK'
3733: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3734: ,'INVESTOR_RESIDUAL_PAY'
3735: )
3736: AND GTL.GTT_ID = p_gtt_id

Line 3733: ,'INVESTOR_RESIDUAL_DISB_BASIS'

3729: ,'INVESTOR_RENT_BUYBACK'
3730: ,'INVESTOR_RENT_DISB_BASIS'
3731: ,'INVESTOR_RENT_PAYABLE'
3732: ,'INVESTOR_RESIDUAL_BUYBACK'
3733: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3734: ,'INVESTOR_RESIDUAL_PAY'
3735: )
3736: AND GTL.GTT_ID = p_gtt_id
3737: group by stb.stream_type_purpose

Line 3734: ,'INVESTOR_RESIDUAL_PAY'

3730: ,'INVESTOR_RENT_DISB_BASIS'
3731: ,'INVESTOR_RENT_PAYABLE'
3732: ,'INVESTOR_RESIDUAL_BUYBACK'
3733: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3734: ,'INVESTOR_RESIDUAL_PAY'
3735: )
3736: AND GTL.GTT_ID = p_gtt_id
3737: group by stb.stream_type_purpose
3738: having count(stb.stream_type_purpose) > 1;

Line 3762: ,'INVESTOR_RESIDUAL_BUYBACK'

3758: ,'INVESTOR_RECEIVABLE'
3759: ,'INVESTOR_RENT_BUYBACK'
3760: ,'INVESTOR_RENT_DISB_BASIS'
3761: ,'INVESTOR_RENT_PAYABLE'
3762: ,'INVESTOR_RESIDUAL_BUYBACK'
3763: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3764: ,'INVESTOR_RESIDUAL_PAY'
3765: -- Change requested by Satya on Nov 10
3766: ,'PV_RENT_SECURITIZED'

Line 3763: ,'INVESTOR_RESIDUAL_DISB_BASIS'

3759: ,'INVESTOR_RENT_BUYBACK'
3760: ,'INVESTOR_RENT_DISB_BASIS'
3761: ,'INVESTOR_RENT_PAYABLE'
3762: ,'INVESTOR_RESIDUAL_BUYBACK'
3763: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3764: ,'INVESTOR_RESIDUAL_PAY'
3765: -- Change requested by Satya on Nov 10
3766: ,'PV_RENT_SECURITIZED'
3767: ,'PV_RV_SECURITIZED'

Line 3764: ,'INVESTOR_RESIDUAL_PAY'

3760: ,'INVESTOR_RENT_DISB_BASIS'
3761: ,'INVESTOR_RENT_PAYABLE'
3762: ,'INVESTOR_RESIDUAL_BUYBACK'
3763: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3764: ,'INVESTOR_RESIDUAL_PAY'
3765: -- Change requested by Satya on Nov 10
3766: ,'PV_RENT_SECURITIZED'
3767: ,'PV_RV_SECURITIZED'
3768: )

Line 3792: ,'INVESTOR_RESIDUAL_BUYBACK'

3788: ,'INVESTOR_RECEIVABLE'
3789: ,'INVESTOR_RENT_BUYBACK'
3790: ,'INVESTOR_RENT_DISB_BASIS'
3791: ,'INVESTOR_RENT_PAYABLE'
3792: ,'INVESTOR_RESIDUAL_BUYBACK'
3793: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3794: ,'INVESTOR_RESIDUAL_PAY'
3795: -- Change requested by Satya on Nov 10
3796: ,'PV_RENT_SECURITIZED'

Line 3793: ,'INVESTOR_RESIDUAL_DISB_BASIS'

3789: ,'INVESTOR_RENT_BUYBACK'
3790: ,'INVESTOR_RENT_DISB_BASIS'
3791: ,'INVESTOR_RENT_PAYABLE'
3792: ,'INVESTOR_RESIDUAL_BUYBACK'
3793: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3794: ,'INVESTOR_RESIDUAL_PAY'
3795: -- Change requested by Satya on Nov 10
3796: ,'PV_RENT_SECURITIZED'
3797: ,'PV_RV_SECURITIZED'

Line 3794: ,'INVESTOR_RESIDUAL_PAY'

3790: ,'INVESTOR_RENT_DISB_BASIS'
3791: ,'INVESTOR_RENT_PAYABLE'
3792: ,'INVESTOR_RESIDUAL_BUYBACK'
3793: ,'INVESTOR_RESIDUAL_DISB_BASIS'
3794: ,'INVESTOR_RESIDUAL_PAY'
3795: -- Change requested by Satya on Nov 10
3796: ,'PV_RENT_SECURITIZED'
3797: ,'PV_RV_SECURITIZED'
3798: )

Line 4080: FROM DUAL

4076: )
4077: MINUS
4078: (
4079: SELECT 'FEE_RENEWAL' PURPOSE
4080: FROM DUAL
4081: WHERE p_exclude_fr = 'T'
4082: );
4083: l_exclude_fr VARCHAR2(1) := OKL_API.G_TRUE;
4084: BEGIN