SQL for duration of inspection required
SummaryMeasure key metric
SQL Guru's need some help figuring out what tables to get:
For receiving, we want to measure the duration of a receiving task to capture the receiving (CREATE) and the inspect (TASK) to capture the two dates and perform a duration calculation.
Key information needed in SQL: PO #, Receipt # (Create date), Line #, Item # Outcome of the inspection NOT INSPECTED, ACCEPTED, REJECTED including the date of the transaction showing the inspection being completed