What's new in Customer Journeys?

Connect and learn more! ×
SQL Reporting Transactions — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Reporting Transactions

Question
13
Views
0
Comments

Hi I need to check a Approved documents of records transactions. But I couldnt Get The Transaction Id which matches with my Document_Code from Hrc_Txn_Header and Hrc_Txn_Data How Can I Get this ID on sql and match with my document code from HR_DOCUMENTS_OF_RECORD HDR



(SELECT txnh.subject_id,

               txnd.COMPLETED_DATE     APPROVED_DATE,

               txnh.PROCESS_ID,

               txnh.OBJECT_ID,

               txnh.Transaction_Id

          FROM (SELECT *

                  FROM Fusion.Hrc_Txn_Header txn

                 WHERE transaction_id =

                       (SELECT MAX (txne.transaction_id)

                          FROM Fusion.Hrc_Txn_Header txne

                         WHERE txn.OBJECT_ID = txne.OBJECT_ID)) Txnh,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!