Oracle Apps Information
-- By Sunil Ingole
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_...
Query to check Standard Purchase Order linked with Blanket Agreement
›
SELECT pha.segment1 po_number , pha.type_lookup_code , pha.enabled_flag , fu.user_name standard_po_created_by , pha.vendor_id , pha.vendor_...
Query to check Sales Order HOLD reasons
›
SELECT ooha.order_number , ooha.ordered_date , ooha.flow_status_code , ooha.credit_card_approval_code , ohd.name "Hold Name" , oh...
Query to get Customer details of Sales Order
›
SELECT ooha.order_number , ooha.ordered_date , ooha.flow_status_code , hp.party_name "Customer Name" , ...
›
Home
View web version