Lastest Job Offer
Summary
Looking for any feedback on capturing only the latest job offerContent
Hello,
I've found the below logic is working to accurately capture only the latest job offer in OBI. However, I'm also seeing it cause performance issues in reports. Does anyone have any feedback to improve the performance of this logic?
Thanks for any suggestions.
Melissa
("Submission Job Offer"."Submission Job Offer Identifier" IN (SELECT B."OFFERNO" "OFFERNO" FROM (SELECT "Submission Job Offer"."Submission Job Offer Identifier" "OFFERNO", "Submission General Info"."Submission Identifier" "APPLICATIONNO", "Submission Job Offer"."Sequence" "OFFERSEQUENCE" FROM "Recruiting") B, (SELECT "Submission General Info"."Submission Identifier" "APPLICATIONNO", MAX("Submission Job Offer"."Sequence") SEQ FROM "Recruiting" GROUP BY "Submission General Info"."Submission Identifier" ) A WHERE B."APPLICATIONNO" = A."APPLICATIONNO" AND B."OFFERSEQUENCE" = A."SEQ"))