DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_ASSET_COMPONENTS_B

Line 2764: okl_asset_components_b oacb

2760: oacb.YEAR_MANUFACTURED,
2761: oacb.MODEL_NUMBER,
2762: oacb.id qte_add_on_id
2763: FROM okl_assets_v oab,
2764: okl_asset_components_b oacb
2765: WHERE oab.ID = oacb.ASSET_ID
2766: AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2767: AND oacb.PRIMARY_COMPONENT = 'NO'
2768: AND oacb.ASSET_ID = p_ast_id;

Line 2969: okl_asset_components_b oacb

2965: -- Start : Added by rravikir for Bug#6707125
2966: CURSOR c_get_asset_id(p_qte_id okl_lease_quotes_b.ID%TYPE) IS
2967: SELECT oab.ID asset_id
2968: FROM okl_assets_v oab,
2969: okl_asset_components_b oacb
2970: WHERE oab.ID = oacb.ASSET_ID
2971: AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2972: AND oacb.PRIMARY_COMPONENT = 'YES'
2973: AND oab.PARENT_OBJECT_ID = p_qte_id;

Line 3486: okl_asset_components_b oacb

3482: oacb.MANUFACTURER_NAME,
3483: oacb.YEAR_MANUFACTURED,
3484: oacb.MODEL_NUMBER
3485: FROM okl_assets_v oab,
3486: okl_asset_components_b oacb
3487: WHERE oab.ID = oacb.ASSET_ID
3488: AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
3489: AND oacb.PRIMARY_COMPONENT = 'YES'
3490: AND oab.PARENT_OBJECT_ID = p_qte_id;