DBA Data[Home] [Help]

APPS.DPP_BUSINESSEVENTS_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 564: FROM ozf_supp_trd_prfls_all ostp,

560: --Retrieve the gl_cost_adjustment_acct
561: BEGIN
562: SELECT ostp.gl_cost_adjustment_acct
563: INTO l_cost_adj_acct
564: FROM ozf_supp_trd_prfls_all ostp,
565: dpp_transaction_headers_all dtha
566: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
567: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
568: AND ostp.org_id = to_number(dtha.org_id)

Line 799: FROM ozf_supp_trd_prfls_all ostp,

795: --Added code for DPP Price Increase Enhancement
796: BEGIN
797: SELECT nvl(create_claim_price_increase,'N')
798: INTO l_price_change_flag
799: FROM ozf_supp_trd_prfls_all ostp,
800: dpp_transaction_headers_all dtha
801: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
802: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
803: AND ostp.org_id = to_number(dtha.org_id)