DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_ASSETS_V

Line 2763: FROM okl_assets_v oab,

2759: oacb.MANUFACTURER_NAME,
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'

Line 2968: FROM okl_assets_v oab,

2964:
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'

Line 3485: FROM okl_assets_v oab,

3481: oacb.NUMBER_OF_UNITS,
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'