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...
Load Java source code in oracle databaseCREATE OR REPLACE AND RESOLVE JAVA SOURCECompile java code in oracle databaseCall java in oracle apps database...
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...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...--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...--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
--...SELECT rs.user_request_set_name "Set Name",
rs.request_set_name "Set code",
rs.description "Description",
rss.display_sequence stage...SELECT rct.receipt_number,
b.name batch_name,
h.name journal_name,
b.description batch_description,
h.je_category,
h.je_source,
h.period...--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...--AP invoice and SLA details
SELECT hou.name operating_unit,
aia.invoice_num,
aia.invoice_currency_code,
aia.creation_date,
aia.invoice_d...--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...SELECT LPAD (' ', 10 * (LEVEL - 1)) || org.name hierarchy,
org.organization_id
FROM hr_all_organization_units org, per_org_structure_elements pose
WHERE 1 = ...SELECT fsrn.program,
fsrn.request_id, -- fstr.concurrent_program_id,
fstr.program incompatible_program,
fstr.request_id incompatible_prog_r...