Oh, I didn't see that you could find the part number on the Fender page.
All I saw initially was the one Model number listed on both pages, 0992170. That's why I was assuming it was a duplicate, or an error. You are correct though, different part numbers for sure.
Looks like you are not the first one to ask this: What's the difference? Pickguard question.
Seems like no one knew then either.
Amazon has both: http://www.amazon.com/Fender-Accesso.../dp/B003BG6KXQ http://www.amazon.com/Fender-007-413.../dp/B003B03G34
Colors look different there too, but only slightly. Their photo for 0992 does not have a notch, but the reviews on it clearly state it does (some people complain in their reviews specifically because it does have a notch, and the photo does not.) 007 guard has 0 reviews and seems newer. 0992 has several reviews.
Only major difference I could find was this:
0992 - Date first available at Amazon.com: June 8, 2005
0074 - Date first available at Amazon.com: November 11, 2010