DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 184: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf

180: l_internal_code := p_product_id;
181:
182: SELECT code.external_code
183: INTO l_vendor_product_id
184: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf
185: WHERE internal_code = l_internal_code and
186: code.supp_trade_profile_id = prf.supp_trade_profile_id and
187: prf.supplier_site_id = p_supplier_site_id and
188: trunc(sysdate) between code.start_date_active and