SELECT count(*) into v_asl_site_count FROM po_lookup_codes plc, hr_org_units_no_join hou, hr_org_units_no_join hou1, hr_all_organization_units_tl hout, hr_all_organization_units_tl hout1, po_vendors pv, po_vendor_sites_all pvs, mtl_manufacturers mm, mtl_manufacturers mm1, mtl_parameters mp, mtl_parameters mp1, po_asl_statuses past, po_approved_supplier_list…
Read MoreThe below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party_name supplier_name ,SUP.segment1 supplier_number ,ZR.TAX_REGIME_CODE ,ZR.REGISTRATION_NUMBER tax_registration_number ,ZR.EFFECTIVE_FROM…
Read Moredeclare l_request_req_id NUMBER; begin BEGIN l_request_req_id := apps.fnd_request.submit_request (application => ‘PO’ –Application, , program => ‘REQIMPORT’ –Program, , argument1 => ” –Interface Source code, , argument2 => 1032 –Batch ID,…
Read MoreASL Setup Validation ASL (Approved supplier list) setup validation for Local and Global The local setup we have to pass the parameter location code, item and Vendor code for global…
Read MoreDECLARE paslrec po_approved_supplier_list_rec; paarec po_asl_attributes_rec; padrec po_asl_documents_rec; chvrec chv_authorizations_rec; psicrec po_supplier_item_capacity_rec; psitrec po_supplier_item_tolerance_rec; x_errors po_asl_api_error_rec; x_session_key NUMBER; x_return_status VARCHAR2 (30); x_return_msg VARCHAR2 (2000); BEGIN — Populating values in paslrec paslrec…
Read MoreThis blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create Contact of Suppliers and…
Read MoreSELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”, aerh.total “Amount”, aerh.default_currency_code “Currency”, (SELECT meaning FROM…
Read MoreSELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, (TRUNC (SYSDATE) – TRUNC (h.report_submitted_date)) days_old, …
Read Moreselect (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id order by creation_date …
Read MoreSELECT flag, vendor_num, vendor_name, vendor_site_id, vendor_site_code, state_code, project_code, transaction_type, transaction_num, doc_category_name, document_num, po_number, transaction_date, gl_date, status, description, currency, SUM(entered_dr) entered_dr, SUM(entered_cr) entered_cr, SUM(accounted_dr) accounted_dr, SUM(accounted_cr) accounted_cr FROM (SELECT 1 flag,…
Read More