Incident number to invoice number / amount
Hi All, Hope everyone is doing great. EBS R12.2 with project accounting model implemented. Need an help, what am trying to accomplish is to get to invoice number / amount from the time when customer raises an incident, approved internally, goes to the sales / work order, inventory and job done and then invoice received / amount. Am using the below query where i can get up from incidents to order number and rest of fields. How can i be able to get to the invoice number / invoice amount associated with the incident number. Attached the sql query am