ATA = JASC CODES
ATA - AIR TRANSPORT ASSOCIATION
JASC - JOINT AIRCRAFT SYSTEM/COMPONENT
Integrity check for ATA/JASC codes.
Null or Undefined ATA/Jasc codes are set to Zero
JASC CODES #2 & #3 are not provided in the FAA data.
*/
UPDATE M70_SDR_TRANSIT M70
SET JASC_NBR_1 = 0
WHERE JASC_NBR_1 NOT IN
(SELECT TR57.JASC_NBR FROM TR57_JASC TR57
WHERE TR57.JASC_NBR = NVL(M70.JASC_NBR_1,9999)) ;
COMMIT;
/*