DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 278: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf

274: l_internal_code := p_product_id;
275:
276: SELECT code.external_code
277: INTO l_vendor_product_id
278: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf
279: WHERE internal_code = l_internal_code and
280: code.supp_trade_profile_id = prf.supp_trade_profile_id and
281: prf.supplier_site_id = p_supplier_site_id and
282: trunc(sysdate) between code.start_date_active and