Load Java source code in oracle database
Load Java source code in oracle databaseCREATE OR REPLACE AND RESOLVE JAVA SOURCECompile java code in oracle databaseCall java in oracle apps database...
All Posts
Query to get price list details in Oracle EBS
SELECT qpa.product_attr_value inventory_item_id,
spl.list_header_id price_list_id,
qplt.name price_list_name,
spll.start_date_active start_date_active,
spl...Query to find all APIs of Oracle Apps modules
SELECT SUBSTR (a.OWNER, 1, 20),
SUBSTR (a.NAME, 1, 30),
SUBSTR (a.TYPE, 1, 20),
SUBSTR (u.status, 1, 10) Stat,
u.last_ddl_time,
SUBSTR (text, 1, 80) Desc...Oracle R12 shipping status query
--Delivery status
SELECT STATUS_CODE, meaning, delivery_id
FROM wsh_new_deliveries wnd,
apps.fnd_lookup_values_vl flv
WHERE flv.LOOKUP_CODE = wnd.STATUS_CODE
AND lookup_type = 'D...OAF customizations queries
--Query to list all pages under any top/directory
set serveroutput on;
DECLARE
BEGIN
jdr_utils.listdocuments ('/oracle/apps/per', TRUE);
END;
Query to list all customizations on a OAF page
--...Oracle apps list of concurrent programs in a Request Set
SELECT rs.user_request_set_name "Set Name",
rs.request_set_name "Set code",
rs.description "Description",
rss.display_sequence stage...R12 AR cash receipt SLA and GL details query
SELECT rct.receipt_number,
b.name batch_name,
h.name journal_name,
b.description batch_description,
h.je_category,
h.je_source,
h.period...Oracle apps AR Applications and SLA details
--AR Applications and xla
SELECT ard.source_id,
xdl.SOURCE_DISTRIBUTION_TYPE,
xal.ACCOUNTING_CLASS_CODE,
ard.SOURCE_ID,
ard.SOURCE_TABLE,
ard.SOURCE_TYPE,
rct...Oracle EBS query to get AP Invoice SLA Details
--AP invoice and SLA details
SELECT hou.name operating_unit,
aia.invoice_num,
aia.invoice_currency_code,
aia.creation_date,
aia.invoice_d...Oracle EBS query to get AR Invoice SLA Details
--Query to get AR invoice SLA details
SELECT rct.trx_number,
rct.customer_trx_id,
rctd.cust_trx_line_gl_dist_id,
xal.entered_dr,
xal.entered_cr,
xal.code_combination...Query to get Organization Hierarchy in Oracle apps
SELECT LPAD (' ', 10 * (LEVEL - 1)) || org.name hierarchy,
org.organization_id
FROM hr_all_organization_units org, per_org_structure_elements pose
WHERE 1 = ...Oracle apps query to find incompatible programs blocking a concurrent request
SELECT fsrn.program,
fsrn.request_id, -- fstr.concurrent_program_id,
fstr.program incompatible_program,
fstr.request_id incompatible_prog_r...