AR invoice details
Introduction: This SQL query is used to fetching the details of an institution Based on their requirements overview: this query gives AR invoice details ELECT SUM(rcl.unit_selling_price* rcl.quantity_invoiced) FROM…
Read MoreFetching and Parsing Data from Other Online Source To Oracle Database Using Web service in Oracle Apex
Overview This Document will Explain How to Fetch and Parse Data from Other Online Source To Oracle Database Using Web service in…
Read MoreCREATE CATALOG AND RECOVER CONTROLFILE WITH CATALOG
CREATE CATALOG AND RECOVER CONTROLFILE WITH CATALOG PRIMARY CATALOG HOSTNAME 192.168.1.33 192.168.1.21 DB PORT 1521 1525 DB NAME VIYANI CATDB In Oracle, A catalog is a collection of…
Read MoreObject Abstraction In PL/SQL
1.Overview This document explains about Object abstraction in PL/SQL. An Object abstraction refers to the high-level description or model of a real-world entity. Abstractions keep our daily lives manageable by…
Read MoreInserting a new Record into an Interactive Grid using Java Scripts
Overview This Document will Explain How to Insert a new Record into an Interactive Grid using Java Scripts. Technologies and Tools Used The following technology has been used to achieve…
Read MoreCALLING API USING JAVA SCRIPT IN ORACLE APEX
1. Overview This Document will Explain How to call a API using java script in oracle apex. Technologies and Tools Used The following technology has been used…
Read MoreFREEZED COLUMN HEADER WITH SCROLLBAR IN CLAASIC REPORT
1. Overview This Document will Explain How to create fixed column header with scrollbar in classic report Technologies and Tools Used The following technology has been…
Read MoreAutomation Testing In Oracle Apex Using Selenium Web Driver
1.Overview This document explains about how to perform unit testing using selenium web driver in Oracle Apex. Selenium Web Driver is a web framework that permits you to execute cross-browser…
Read MoreQuery to get Lot , Sublot information for Sales Order in Oracle Fusion SCM
select MAX(CASE WHEN seq =1 THEN parent_lot_number END) parentlot1, MAX(CASE WHEN seq =2 THEN parent_lot_number END) parentlot2, MAX(CASE WHEN seq =3 THEN parent_lot_number END) parentlot3, MAX(CASE WHEN seq =4 THEN…
Read MoreQuery to Get the Payroll Run Details for Person
SELECT ppf.person_id, ppf.person_number, paam.assignment_number, to_char(ptp.start_date,’YYYY/MM/DD’) startdate, to_char(ptp.end_date,’YYYY/MM/DD’) enddate, ptp.period_name, to_char(trunc(sysdate),’YYYY/MM/DD’) executiondatetime FROM pay_payroll_actions ppa, pay_payroll_rel_actions pra, pay_assigned_payrolls_dn apd, per_all_assignments_m paam, pay_time_periods ptp, pay_rel_groups_dn prg, per_all_people_f ppf, pay_all_payrolls_f py, pay_consolidation_sets pcs,…
Read More