RI module

[ricardorauber]

Does anyone have any information or anything that is about the EBS RI module? This module does not exist in ERTM (metalink session focused on e-business suite) and also evil there are relationships in FND tables or even bank views (eg dba_tables).

My problem, at the moment, is to integrate the transactions of the INV with the PO and RI but, in the case of return, the RI has 2 lines and the only one then the inv It ends up doubling the lines!

[ricardorauber]

Example:

Select all

 
SELECT mmt.transaction_id, 
       mmt.rcv_transaction_id, 
       poh.segment1 oc, 
       ri.invoice_num nf 
  FROM mtl_material_transactions mmt, 
       rcv_transactions          rcv, 
       po_headers_all            poh, 
       po_lines_all              pol, 
       po_distributions_all      pd, 
       rec_distributions         rd, 
       rec_invoice_lines         ril, 
       rec_invoices              ri 
 WHERE mmt.rcv_transaction_id = rcv.transaction_id 
   AND rcv.po_header_id = poh.po_header_id 
   AND poh.po_header_id = pol.po_header_id 
   AND rcv.po_line_id = pol.po_line_id 
   AND pd.po_header_id = poh.po_header_id 
   AND pd.po_line_id = pol.po_line_id 
   AND rd.po_distribution_id = pd.po_distribution_id 
   AND rd.invoice_line_id = ril.invoice_line_id 
   AND ri.invoice_id = ril.invoice_id 
   AND ri.operation_id = rd.operation_id 
   AND mmt.transaction_id = 4003 

Result:

Select all

 
TRANSACTION_ID RCV_TRANSACTION_ID OC                                  NF 
-------------- ------------------ -------------------- ----------------- 
          4003               1002 21                    -1300000080201,0 
          4003               1002 21                               325,0 

[ricardorauber]

I got all RI documentation in Metalink!

seek by doc ID 420054.1

: -O

[dr_gori]

Dude ... what a show!
If it's just text, how can I drop the doc here in the forum?
: -O

[ricardorauber]

I got all the PDFs of EBS TRM! They are files with all ER diagram and data dictionary! It has texts and images.

[pmilanez]

ricardoruber, ball show!
I found several things in ERTM but nothing consolidated as a data dictionary.

Can you send me by e-mail (pmilanez@gmail.com)? Or make available to the staff?


ABS

[ricardorauber]

Sorry for the delay but I sent you by e-mail the TRM and the user guide of Ri, hug!

[Porva]

Taking an old topic ..

Ricardoruber, could you also send me this material please?

rafanunes1981@yahoo.com


Valeus

[bellotj]

Taking an old topic ..

Ricardoruber, could you also send me this material please?

bellotj@hotmail.com

I await and thank you

[J.A.CUNHA]

Ricardoruber,
If possible, could you go too?

Thanks anyway!

E-mail: j.a.cunha @ gmail. with

Note: I put spaces in the email, otherwise I could not send ...