DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 2981: FROM okl_cost_adjustments_b

2977: SELECT ADJUSTMENT_SOURCE_ID,
2978: VALUE,
2979: SUPPLIER_ID,
2980: default_subsidy_amount
2981: FROM okl_cost_adjustments_b
2982: WHERE PARENT_OBJECT_CODE = 'ASSET'
2983: AND ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
2984: AND PARENT_OBJECT_ID = p_ast_id;
2985: l_cre_asb_tbl OKL_ASSET_SUBSIDY_PVT.asb_tbl_type;

Line 3588: FROM OKL_COST_ADJUSTMENTS_b cdj,

3584:
3585: --cursor to fetch total trade in amount and description
3586: CURSOR get_ti_amt(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3587: SELECT sum(cdj.value) total_tradein
3588: FROM OKL_COST_ADJUSTMENTS_b cdj,
3589: OKL_ASSETS_B ast
3590: WHERE cdj.parent_object_id = ast.id
3591: AND cdj.parent_object_code = 'ASSET'
3592: AND cdj.adjustment_source_type = 'TRADEIN'