eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 172: from ozf_supp_trd_prfls_all ostpa

168: IS
169: select distinct vendor_id, vendor_site_id, org_id
170: from dpp_transaction_headers_all dtha
171: where not exists (select supp_trade_profile_id
172: from ozf_supp_trd_prfls_all ostpa
173: where ostpa.supplier_id = dtha.vendor_id
174: and ostpa.supplier_site_id = dtha.vendor_site_id
175: and ostpa.org_id = dtha.org_id);
176:

Line 492: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa

488: --Cursor to retrieve the supplier trade profile id and org_id
489: CURSOR get_supp_trd_prfl_csr (p_transaction_header_id NUMBER)
490: IS
491: SELECT ostpa.supp_trade_profile_id, dtha.org_id
492: FROM dpp_transaction_headers_all dtha, ozf_supp_trd_prfls_all ostpa
493: WHERE dtha.transaction_header_id = p_transaction_header_id
494: AND dtha.vendor_id = ostpa.supplier_id
495: AND dtha.vendor_site_id = ostpa.supplier_site_id
496: AND dtha.org_id = ostpa.org_id;