DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_COST_ADJUSTMENTS_V

Line 3165: FROM OKL_COST_ADJUSTMENTS_V

3161: ,short_description
3162: ,description
3163: ,comments
3164: ,percent_basis_value
3165: FROM OKL_COST_ADJUSTMENTS_V
3166: WHERE parent_object_id = p_ast_id
3167: AND parent_object_code = 'ASSET'
3168: AND adjustment_source_type = 'DOWN_PAYMENT';
3169:

Line 3314: FROM OKL_COST_ADJUSTMENTS_V

3310: ,short_description
3311: ,description
3312: ,comments
3313: ,percent_basis_value
3314: FROM OKL_COST_ADJUSTMENTS_V
3315: WHERE parent_object_id = p_ast_id
3316: AND parent_object_code = 'ASSET'
3317: AND adjustment_source_type = 'TRADEIN';
3318:

Line 3462: l_ti_desc OKL_COST_ADJUSTMENTS_V.description%TYPE;

3458: lx_rulv_tbl okl_la_payments_pvt.rulv_tbl_type;
3459: l_payment_type_id Number;
3460: l_eot_type VARCHAR2(40);
3461: l_ti_amt NUMBER := NULL;
3462: l_ti_desc OKL_COST_ADJUSTMENTS_V.description%TYPE;
3463:
3464: --Cursor declarations
3465: --Get asset line details
3466: CURSOR c_get_asset_dtls(p_qte_id okl_lease_quotes_b.ID%TYPE) IS

Line 3599: FROM OKL_COST_ADJUSTMENTS_V cdj,

3595:
3596: --cursor to fetch trade in description for any one asset
3597: CURSOR get_ti_desc(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3598: SELECT cdj.description
3599: FROM OKL_COST_ADJUSTMENTS_V cdj,
3600: OKL_ASSETS_B ast
3601: WHERE cdj.parent_object_id = ast.id
3602: AND cdj.parent_object_code = 'ASSET'
3603: AND cdj.adjustment_source_type = 'TRADEIN'