DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 461: ozf_supp_trd_prfls_all ostp

457: apssa.state,
458: apssa.zip,
459: apssa.country
460: FROM ap_supplier_sites_all apssa,
461: ozf_supp_trd_prfls_all ostp
462: WHERE apssa.vendor_id = to_NUMBER(p_search_text1)
463: AND ostp.supplier_id = apssa.vendor_id
464: AND ostp.supplier_site_id = apssa.vendor_site_id
465: AND ostp.org_id = apssa.org_id

Line 713: FROM ozf_supp_trd_prfls_all

709:
710: BEGIN
711: SELECT supp_trade_profile_id
712: INTO l_supp_trade_profile_id
713: FROM ozf_supp_trd_prfls_all
714: WHERE supplier_id = to_number(l_search_criteria_tbl(3).search_text)
715: AND supplier_site_id = to_number(l_search_criteria_tbl(4).search_text)
716: AND org_id = l_search_criteria_tbl(1).search_text;
717: EXCEPTION