DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_ASSET_COMPONENTS_B

Line 2802: okl_asset_components_b oacb

2798: oacb.YEAR_MANUFACTURED,
2799: oacb.MODEL_NUMBER,
2800: oacb.id qte_add_on_id
2801: FROM okl_assets_v oab,
2802: okl_asset_components_b oacb
2803: WHERE oab.ID = oacb.ASSET_ID
2804: AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2805: AND oacb.PRIMARY_COMPONENT = 'NO'
2806: AND oacb.ASSET_ID = p_ast_id;

Line 3007: okl_asset_components_b oacb

3003: -- Start : Added by rravikir for Bug#6707125
3004: CURSOR c_get_asset_id(p_qte_id okl_lease_quotes_b.ID%TYPE) IS
3005: SELECT oab.ID asset_id
3006: FROM okl_assets_v oab,
3007: okl_asset_components_b oacb
3008: WHERE oab.ID = oacb.ASSET_ID
3009: AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
3010: AND oacb.PRIMARY_COMPONENT = 'YES'
3011: AND oab.PARENT_OBJECT_ID = p_qte_id;

Line 3532: okl_asset_components_b oacb

3528: oacb.MANUFACTURER_NAME,
3529: oacb.YEAR_MANUFACTURED,
3530: oacb.MODEL_NUMBER
3531: FROM okl_assets_v oab,
3532: okl_asset_components_b oacb
3533: WHERE oab.ID = oacb.ASSET_ID
3534: AND oab.PARENT_OBJECT_CODE = 'LEASEQUOTE'
3535: AND oacb.PRIMARY_COMPONENT = 'YES'
3536: AND oab.PARENT_OBJECT_ID = p_qte_id;