DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 3087: ,hz_customer_profiles hcp

3083: ,pol.asset_number
3084: ,hcp.credit_classification
3085: FROM okl_pool_srch_v pol
3086: ,fnd_lookups lkup
3087: ,hz_customer_profiles hcp
3088: WHERE
3089: -- pre-req
3090: pol.currency_code = p_currency_code
3091: AND pol.sts_code IN ('BOOKED','EVERGREEN')

Line 3876: ,hz_customer_profiles hcp

3872: -- mvasudev, 09/28/2004, Bug#3909240
3873: ,pocv.stream_type_purpose
3874: ,hcp.credit_classification
3875: FROM okl_pool_contents_uv pocv
3876: ,hz_customer_profiles hcp
3877: -- pool_number
3878: WHERE pocv.pol_id = p_pol_id
3879: -- customer
3880: AND NVL(pocv.cust_object1_id1,G_DEFAULT_NUM) = NVL(p_cust_object1_id1, NVL(pocv.cust_object1_id1,G_DEFAULT_NUM))