Title

▼
Monday, 30 June 2025

Query to find invoice number from credit memo

›
 SELECT     rcta.customer_trx_id,     rcta.trx_number,     rcta.trx_date,     rctta.name          transaction_type_name,     rctta.type     ...

Query to find order line number from sales order

›
 SELECT     ooha.org_id,     ooha.order_number,     rtrim(oola.line_number|| '.'|| oola.shipment_number|| '.'|| oola.option_...
Thursday, 26 June 2025

Query to find receipt number from Invoice number (link between ra_customer_trx_all and r_cash_receipts_all)

›
 SELECT     acra.receipt_number,     rcta.trx_number FROM     ar_receivable_applications_all  araa,     ar_cash_receipts_all            acra...

Query to find customer number, site number, transaction type and other details from AR Invoice

›
 SELECT     hou.name              ou_name,     rcta.org_id,     hp.party_id,     --hp.party_number,     hp.party_name,     hp.party_type,   ...
Wednesday, 18 June 2025

How to remove last character in notepad ++

›
1. Open file in Notepad++ 2. Ctrl + H to open the Find and Replace dialog. 3. select Regular expression in Search Mode at the bottom. 4. Fin...
Tuesday, 17 June 2025

Query to find invoice transaction type, class and status

›
 SELECT     rcta.customer_trx_id,     rcta.trx_number,     rcta.trx_date,     apsa.class,     apsa.status,     rctta.name    transaction_typ...

Query to find out schedule request set

›
 SELECT     fcr.request_id,     fcr.description,     fcpt.user_concurrent_program_name     || nvl2(fcr.description, ' ('            ...