Query to get Customer Bank Account Details
SELECT cust.party_name customer_name,
cust_acct.account_number,
cust_uses.site_use_code,
cust_loc.address1,
cust_loc.address2,
cust_loc.address3,
...All Posts
Query to get description of GL Code Combination
SELECT GCC.CONCATENATED_SEGMENTS ACCOUNT,
GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (GCC.CHART_OF_ACCOUNTS_ID,
GCC.CODE_COMBINATION_ID)
...PL-SQL code to add responsibility to application user
PL-SQL code to add responsibility to application user Oracle apps EBS add responsibility to user from backendScript to add responsibility to user...
PL-SQL code to reset application user password
PL-SQL code to reset application user passwordOracle apps Reset application user password from backend For more reusable queries, click https://lights...
PL-SQL code to write a file
PL-SQL code to write a fileOracle apps ebs plsql to write a filehow to write a file using plsql...
PL-SQL code to read a file
PL-SQL code to read a fileOracle apps ebs plsql to read a filehow to read a file using plsql...
Query to find second and third highest value
SELECT *
FROM (SELECT ROWNUM row_num, b.*
FROM ( SELECT e.*
FROM emp e
ORDER BY empid DESC) b)
WHERE row_num IN (2, 3)PL-SQL Procedure to send email with attachment
CREATE OR REPLACE PROCEDURE XXSEND_EMAIL (p_filename1 IN VARCHAR2,
v_subjectline IN VARCHAR2,
o_errbuf...PL-SQL to delete Concurrent Program and Executable
PL-SQL to delete Concurrent Program and ExecutableHow to delete Concurrent Program and Executable in Oracle Apps EBSDelete concurrent program Example:...
Query to get the details of the lock in the database
SELECT NVL (s.username, 'Internal') username,
NVL (s.terminal, 'None') terminal,
l.SID || ',' || s.serial# KILL,
s.audsid ...PL-SQL code to delete XML/BI Publisher template and Data Definition
SET SERVEROUTPUT ON
DECLARE
-- Change the following two parameters
var_templatecode VARCHAR2 (100) := 'XXTEST'; -- Template Code
boo_deletedatadef BOOLEAN := FALSE;
-- del...Query to find Purchase Order and Invoice Details
SELECT a.org_id "ORG ID",
e.vendor_name "VENDOR NAME",
UPPER (e.vendor_type_lookup_code) "VENDOR TYPE",
f.vendor_site_code ...