DBA Data[Home] [Help]

APPS.DPP_BUSINESSEVENTS_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 1090: FROM ozf_supp_trd_prfls_all ostp,

1086: --Retrieve the gl_cost_adjustment_acct
1087: BEGIN
1088: SELECT ostp.gl_cost_adjustment_acct
1089: INTO l_cost_adj_acct
1090: FROM ozf_supp_trd_prfls_all ostp,
1091: dpp_transaction_headers_all dtha
1092: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
1093: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
1094: AND ostp.org_id = to_number(dtha.org_id)

Line 1325: FROM ozf_supp_trd_prfls_all ostp,

1321: --Added code for DPP Price Increase Enhancement
1322: BEGIN
1323: SELECT nvl(create_claim_price_increase,'N')
1324: INTO l_price_change_flag
1325: FROM ozf_supp_trd_prfls_all ostp,
1326: dpp_transaction_headers_all dtha
1327: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
1328: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
1329: AND ostp.org_id = to_number(dtha.org_id)