I am about to get a good night's sleep for the first time in weeks. The last 12 days of my life have been obsessed with deciphering the jumble of 10,000+ database objects that is Oracle Financial Apps. All I wanted was to DTS a list of employees over to my HR database. After a boatload of technical problems, I chased down so many promising leads among the tables, views and packages; all them missing at least one bit of information, causing me to start anew.

So I'm not an artist, I'm not a creative writer, but do you want to see something I created that is truly beautiful to me right now? I'll show it to you...

SELECT * from OPENQUERY
(BETSY,
'select * from
APPS.PER_ASSIGNMENTS_F PAF,
HR.PER_ALL_PEOPLE_F HPF,
HR.HR_ALL_ORGANIZATION_UNITS AOU
WHERE PAF.PERSON_ID = HPF.PERSON_ID AND
PAF.ORGANIZATION_ID = AOU.ORGANIZATION_ID AND
AOU.LOCATION_ID = 46937')

Wow, it all looks so simple and obvious now. Nobody will ever know what I suffered through when they at this code. But I know. And now you know.