Showing posts with label AR Transaction Note. Show all posts
Showing posts with label AR Transaction Note. Show all posts

Wednesday, 17 August 2016

API to insert notes in AR transactions

To insert notes into AR transaction kindly used ARP_NOTES_PKG.insert_p API.
This API will take record variable as input parameter. we need to assigned value to it as shown in below given script.

================================================
DECLARE
  l_notes_rec ar_notes%rowtype;
begin

  --apps initialize
  mo_global.init('AR');
  mo_global.set_policy_context('S', '204');
  --
   l_notes_rec.customer_trx_id        := 1545557; -- Customer_trx_id
  l_notes_rec.note_type              := 'MAINTAIN';
  l_notes_rec.text                   := 'Test for AR note';
  l_notes_rec.customer_call_topic_id := NULL;
  l_notes_rec.call_action_id         := NULL;
  l_notes_rec.customer_call_id       := NULL;
 -- call API to insert note
  ARP_NOTES_PKG.insert_p(l_notes_rec);
--
  commit;
  dbms_output.put_line('Note inserted reference note id : ' || l_notes_rec.note_id);
END;
==================================================

screenshot for AR invoice workbench transaction notes.



===================================================
One can query this record from backend by using below given query.

select * from ar_notes_v 
where customer_trx_id=1545557;
===================================================

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...