Oracle Apps Information
-- By Sunil Ingole
Friday, December 5, 2025
Query to get Sales Order Customer details
›
SELECT ooha.order_number , ooha.org_id , ooha.sold_to_org_id bill_cust_account_id , ooha.ship_to_org_id ship_to_site_us...
Query to get Concurrent program details with Value sets
›
SELECT cp.user_concurrent_program_name "Program Name", cp.concurrent_program_name "Short Name", ap.application_name ...
Sunday, November 16, 2025
Update QA_RESULTS table using Interface table- Oracle Apps R12
›
Updating QA_RESULTS using the interface table in Oracle Apps R12 follows below steps: Insert or update records in the QA_RESULTS_INTERFACE...
1 comment:
Friday, February 7, 2025
Query to get Concurrent Program Data Template details
›
SELECT fcpt.user_concurrent_program_name , fcp.concurrent_program_name , fet.user_executable_name executable_name , fe....
Query to get Bill To and Ship To address details of AR Invoice
›
SELECT (SELECT name FROM v$database) instance, ct.trx_number, -- ct.interface_header_attribute1, ct.interface_header_attribute3, ct.old_...
›
Home
View web version