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

Review Completed Transactions- Transaction Costed Status

edited Feb 14, 2024 11:25PM in Inventory Management 2 comments

Need SQL query to report on "Review Completed Transaction" for Transaction Costed status of Error in Project Attribute Delivery.

Transaction Costed status is coming from below lookup however need help with how to join this to INV_MATERIAL_TXNS

Select *

from fnd_lookups

where lookup_type ='INV_MATERIAL_COST_STATUS'


Howdy, Stranger!

Log In

To view full details, sign in.

Register

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