DBA Data[Home] [Help]

APPS.JAI_AVLIST_VALIDATE_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 81: jai_cmn_cus_addresses

77: SELECT
78: price_list_id excise_av_list
79: , vat_price_list_id vat_av_list
80: FROM
81: jai_cmn_cus_addresses
82: WHERE customer_id = pn_party_id
83: AND address_id = NVL(pn_party_site_id,0);
84:
85: -- Get excise&vat price_list_id based on vendor&site or vendorr&null site