[Home] [Help]
2777: SELECT name
2778: FROM OKC_K_LINES_V
2779: WHERE id = p_fin_line_id;
2780: --get asset add ons
2781: CURSOR c_get_asset_addons(p_ast_id okl_assets_b.ID%TYPE) IS
2782: SELECT oab.ID,
2783: oab.ASSET_NUMBER,
2784: oab.INSTALL_SITE_ID,
2785: oab.RATE_CARD_ID,
3010: AND oacb.PRIMARY_COMPONENT = 'YES'
3011: AND oab.PARENT_OBJECT_ID = p_qte_id;
3012: -- End : Added by rravikir for Bug#6707125
3013:
3014: CURSOR c_get_asset_subsidy(p_ast_id okl_assets_b.ID%TYPE) IS
3015: SELECT ADJUSTMENT_SOURCE_ID,
3016: VALUE,
3017: SUPPLIER_ID,
3018: default_subsidy_amount
3183: l_down_payment_receiver VARCHAR2(30);
3184: l_dp_exists BOOLEAN := FALSE;
3185:
3186: --cursor to fetch asset down payment adjustment details
3187: CURSOR get_asset_dp_details(p_ast_id IN okl_Assets_b.id%TYPE) IS
3188: SELECT
3189: id
3190: ,parent_object_code
3191: ,parent_object_id
3332: l_chr_id okl_k_headers.id%TYPE;
3333: l_ti_exists BOOLEAN := false;
3334:
3335: --cursor to fetch asset trade in adjustment details
3336: CURSOR get_asset_ti_details(p_ast_id IN okl_Assets_b.id%TYPE) IS
3337: SELECT
3338: id
3339: ,parent_object_code
3340: ,parent_object_id
3535: AND oacb.PRIMARY_COMPONENT = 'YES'
3536: AND oab.PARENT_OBJECT_ID = p_qte_id;
3537:
3538: --Get asset rent payment details
3539: CURSOR c_get_asset_payment_dtls(p_ast_id okl_assets_b.ID%TYPE) IS
3540: SELECT ocf.STY_ID payment_type_id,
3541: ocf.DUE_ARREARS_YN Arrears_YN,
3542: cfl.FQY_CODE Frequency_Code,
3543: cfl.START_DATE,
3549: OKL_CASH_FLOWS ocf,
3550: OKL_CASH_FLOW_LEVELS cfl
3551: WHERE cfl.caf_id = ocf.ID
3552: AND ocf.CFO_ID = cfo.ID
3553: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3554: AND cfo.OTY_CODE = 'QUOTED_ASSET'
3555: AND cfo.SOURCE_ID = p_ast_id
3556: -- sechawla 5-nov-09 Bug 9044309
3557: ORDER BY
3559: --sechawla 5-nov-09 End Bug 9044309
3560:
3561:
3562: --Get asset billed down payment details
3563: CURSOR c_get_asset_dppayment_dtls(p_ast_id okl_assets_b.ID%TYPE) IS
3564: SELECT ocf.STY_ID payment_type_id,
3565: ocf.DUE_ARREARS_YN Arrears_YN,
3566: cfl.FQY_CODE Frequency_Code,
3567: cfl.START_DATE,
3573: OKL_CASH_FLOWS ocf,
3574: OKL_CASH_FLOW_LEVELS cfl
3575: WHERE cfl.caf_id = ocf.ID
3576: AND ocf.CFO_ID = cfo.ID
3577: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3578: AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'
3579: AND cfo.SOURCE_ID = p_ast_id;
3580:
3581: --Get asset estimated property tax payment details
3578: AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'
3579: AND cfo.SOURCE_ID = p_ast_id;
3580:
3581: --Get asset estimated property tax payment details
3582: CURSOR c_get_asset_eptpayment_dtls(p_ast_id okl_assets_b.ID%TYPE) IS
3583: SELECT ocf.STY_ID payment_type_id,
3584: ocf.DUE_ARREARS_YN Arrears_YN,
3585: cfl.FQY_CODE Frequency_Code,
3586: cfl.START_DATE,
3592: OKL_CASH_FLOWS ocf,
3593: OKL_CASH_FLOW_LEVELS cfl
3594: WHERE cfl.caf_id = ocf.ID
3595: AND ocf.CFO_ID = cfo.ID
3596: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3597: AND cfo.OTY_CODE = 'QUOTED_ASSET_PROPERTY_TAX'
3598: AND cfo.SOURCE_ID = p_ast_id;
3599:
3600: --Get quote level payment details
3636: --cursor to fetch total trade in amount and description
3637: CURSOR get_ti_amt(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3638: SELECT sum(cdj.value) total_tradein
3639: FROM OKL_COST_ADJUSTMENTS_b cdj,
3640: OKL_ASSETS_B ast
3641: WHERE cdj.parent_object_id = ast.id
3642: AND cdj.parent_object_code = 'ASSET'
3643: AND cdj.adjustment_source_type = 'TRADEIN'
3644: AND ast.parent_object_id = p_qte_id
3647: --cursor to fetch trade in description for any one asset
3648: CURSOR get_ti_desc(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3649: SELECT cdj.description
3650: FROM OKL_COST_ADJUSTMENTS_V cdj,
3651: OKL_ASSETS_B ast
3652: WHERE cdj.parent_object_id = ast.id
3653: AND cdj.parent_object_code = 'ASSET'
3654: AND cdj.adjustment_source_type = 'TRADEIN'
3655: AND ast.parent_object_id = p_qte_id