Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How to query TASK_IDs related to FA_ADJUSTMENTS table?

Summary:


Content (please ensure you mask any confidential information):

I need to find TASK_IDs related to FA_ADJUSTMENTS transactions.

Joining FA_ADJUSTMENTS and FA_ASSET_INVOICES, the most of TASK_IDs in records are zero.

Is there other table which contains TASK_IDs?

The business user told me "he can see them in the 'Source Lines' tab sheet of ERP UI".

Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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