DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 645: FROM ozf_supp_trd_prfls_all ostp,

641: --Get the supplier trade profile value to include price increase value for claim or not
642: BEGIN
643: SELECT nvl(create_claim_price_increase,'N')
644: INTO l_price_change_flag
645: FROM ozf_supp_trd_prfls_all ostp,
646: dpp_transaction_headers_all dtha
647: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
648: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
649: AND ostp.org_id = to_number(dtha.org_id)