Raytheon Eagle

Home
Products
News and Events
Training
About Us
Support and Services
Customer Service App (CSA)
Product Downloads
Publications
Technical Info
Contacts

Technical Info

The EAGLE Support page is an On-line system to help keep the EAGLE Customer Informed. Customers can review and down load AdHoc queries, search the database for solved EAGLE issues, and view tutorials demonstrating new and powerful features.

AdHoc Examples
The following AdHoc queries were developed by Team EAGLE and are available to copy. For assistance in developing custom queries, contact the EAGLE Helpdesk at 520.663.6673 or e-mail us at raytheoneagle@raytheon.com

Task Mean Elapse Time

/* Query to calculate Task Mean Elapse Time for each task. */

SELECT CB.EIACODXA, CB.LSACONXB, CB.ALTLCNXB, CB.LCNTYPXB, CB.TASKCDCA, SUM(CB.SBMMETCB)/60 FROM CB GROUP BY CB.EIACODXA, CB.LSACONXB, CB.ALTLCNXB, CB.LCNTYPXB, CB.TASKCDCA

SMR Codes

/* Use the DISTINCT keyword to query for all unique SMR codes in table HG */ SELECT DISTINCT HG.SMRCODHG FROM HG

Cage / Reference Number

/* This query finds all CAGE/Reference number combinations in table HA for which part applications do not exist in table HG (using the not exists comparison operator in a nested query). */

/* SYBASE Query */
SELECT HA.CAGECDXH, HA.REFNUMHA, HA.ITNAMEHA FROM HA WHERE not exists (Select 1 FROM HG WHERE HA.CAGECDXH = HG.CAGECDXH AND HA.REFNUMHA = HG.REFNUMHA)

/* ORACLE Query */
SELECT HA.CAGECDXH, HA.REFNUMHA, HA.ITNAMEHA FROM HA WHERE not exists (Select 1 FROM HG WHERE HA.EIACODXA = HG.EIACODXA AND HA.CAGECDXH = HG.CAGECDXH AND HA.REFNUMHA = HG.REFNUMHA)

Top Down Breakdown

/* Topdown breakdown query. */
/* SYBASE Query */
SELECT HA.CAGECDXH, HA.REFNUMHA, HA.ITNAMEHA, HG.EIACODXA, HG.LSACONXB, HG.ALTLCNXB, HG.QTYASYHG, HG.SMRCODHG, HO.LCNSEIHO, HO.ALCSEIHO, XC.UOCSEIXC FROM HA, HG, HO, XC WHERE HA.CAGECDXH = HG.CAGECDXH AND HA.REFNUMHA = HG.REFNUMHA AND HG.CAGECDXH = HO.CAGECDHO AND HG.REFNUMHA = HO.REFNUMHO AND HG.EIACODXA = HO.EIACODXA AND HG.LSACONXB = HO.LSACONHO AND HG.ALTLCNXB = HO.ALTLCNHO AND HG.LCNTYPXB = HO.LCNTYPXB AND HO.EIACODXA = XC.EIACODXA AND HO.LCNTYPXB = XC.LCNTYPXB AND HO.LCNSEIHO = XC.LSACONXB AND HO.ALCSEIHO = XC.ALTLCNXB ORDER BY HG.LSACONXB, HG.ALTLCNXB

/* ORACLE Query */
SELECT HA.CAGECDXH, HA.REFNUMHA, HA.ITNAMEHA, HG.EIACODXA, HG.LSACONXB, HG.ALTLCNXB, HG.QTYASYHG, HG.SMRCODHG, HO.LCNSEIHO, HO.ALCSEIHO, XC.UOCSEIXC FROM HA, HG, HO, XC WHERE HA.EIACODXA = HG.EIACODXA AND HA.CAGECDXH = HG.CAGECDXH AND HA.REFNUMHA = HG.REFNUMHA AND HG.CAGECDXH = HO.CAGECDHO AND HG.REFNUMHA = HO.REFNUMHO AND HG.EIACODXA = HO.EIACODXA AND HG.LSACONXB = HO.LSACONHO AND HG.ALTLCNXB = HO.ALTLCNHO AND HG.LCNTYPXB = HO.LCNTYPXB AND HO.EIACODXA = XC.EIACODXA AND HO.LCNTYPXB = XC.LCNTYPXB AND HO.LCNSEIHO = XC.LSACONXB AND HO.ALCSEIHO = XC.ALTLCNXB ORDER BY HG.LSACONXB, HG.ALTLCNXB

RAM Information

/* Reliability, Availability, and Maintainability (RAM) Information */
/* SYBASE Query */
SELECT XB.EIACODXA, XB.LSACONXB, XB.ALTLCNXB, XB.LCNTYPXB, XB.LCNAMEXB, BD.RAMINDBD, BD.TEMTBFBD, BD.TMTBFMBD, BF.FAMOINBF, BF.EFMTBFBF, BF.EFMMMBBF, BF.FMCLASBF, BF.FMRATOBF, BH.TLSACNBH, BH.TALCNCBH, BH.TLCNTYBH, BH.TTASKCBH, BH.TATYPEBH, BH.MAININBH, BH.MAINMBBH FROM XB, BA, BD, BF, BH WHERE XB.EIACODXA *= BA.EIACODXA AND XB.LSACONXB *= BA.LSACONXB AND XB.ALTLCNXB *= BA.ALTLCNXB AND XB.LCNTYPXB *= BA.LCNTYPXB AND BA.EIACODXA *= BD.EIACODXA AND BA.LSACONXB *= BD.LSACONXB AND BA.ALTLCNXB *= BD.ALTLCNXB AND BA.LCNTYPXB *= BD.LCNTYPXB AND BD.EIACODXA *= BF.EIACODXA AND BD.LSACONXB *= BF.LSACONXB AND BD.ALTLCNXB *= BF.ALTLCNXB AND BD.LCNTYPXB *= BF.LCNTYPXB AND BF.EIACODXA *= BH.EIACODXA AND BF.LSACONXB *= BH.LSACONBH AND BF.ALTLCNXB *= BH.ALTLCNBH AND BF.LCNTYPXB *= BH.LCNTYPBH AND BF.FAMOINBF *= BH.FAMOINBH ORDER BY XB.EIACODXA, XB.LSACONXB, XB.ALTLCNXB, XB.LCNTYPXB, BD.RAMINDBD, BF.FAMOINBF, BH.TLSACNBH, BH.TALCNCBH, BH.TLCNTYBH, BH.TTASKCBH

/* ORACLE Query */
SELECT XB.EIACODXA, XB.LSACONXB, XB.ALTLCNXB, XB.LCNTYPXB, XB.LCNAMEXB, BD.RAMINDBD, BD.TEMTBFBD, BD.TMTBFMBD, BF.FAMOINBF, BF.EFMTBFBF, BF.EFMMMBBF, BF.FMCLASBF, BF.FMRATOBF, BH.TLSACNBH, BH.TALCNCBH, BH.TLCNTYBH, BH.TTASKCBH, BH.TATYPEBH, BH.MAININBH, BH.MAINMBBH FROM XB, BA, BD, BF, BH WHERE XB.EIACODXA = BA.EIACODXA (+) AND XB.LSACONXB = BA.LSACONXB (+) AND XB.ALTLCNXB = BA.ALTLCNXB (+) AND XB.LCNTYPXB = BA.LCNTYPXB (+) AND BA.EIACODXA = BD.EIACODXA (+) AND BA.LSACONXB = BD.LSACONXB (+) AND BA.ALTLCNXB = BD.ALTLCNXB (+) AND BA.LCNTYPXB = BD.LCNTYPXB (+) AND BD.EIACODXA = BF.EIACODXA (+) AND BD.LSACONXB = BF.LSACONXB (+) AND BD.ALTLCNXB = BF.ALTLCNXB (+) AND BD.LCNTYPXB = BF.LCNTYPXB (+) AND BF.EIACODXA = BH.EIACODXA (+) AND BF.LSACONXB = BH.LSACONBH (+) AND BF.ALTLCNXB = BH.ALTLCNBH (+) AND BF.LCNTYPXB = BH.LCNTYPBH (+) AND BF.FAMOINBF = BH.FAMOINBH (+) ORDER BY XB.EIACODXA, XB.LSACONXB, XB.ALTLCNXB, XB.LCNTYPXB, BD.RAMINDBD, BF.FAMOINBF, BH.TLSACNBH, BH.TALCNCBH, BH.TLCNTYBH, BH.TTASKCBH

Missing NHA PLISN Data

/* This query finds missing NHA PLISN data. */

SELECT * FROM HH WHERE NOT EXISTS(SELECT 1 FROM HG WHERE HG.EIACODXA = HH.EIACODXA AND HG.PLISNOHG = HH.NHAPLIHH)

Failure Mode Ratio > 1

/* This query finds all Failure Mode Ratio greater then 1 in table BF grouped by End Item, LCN, ALC, and LCN Type). */

/* SYBASE / ORACLE Query */
SELECT EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB, SUM(FMRATOBF) FROM BF WHERE FAMOINBF LIKE 'F%' GROUP BY EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB HAVING SUM(FMRATOBF) > 1

Subtasks without Narratives

/* Find all subtasks in table CB for which narratives have not been written in table CC. */

SELECT CB.EIACODXA, CB.LSACONXB, CB.ALTLCNXB, CB.LCNTYPXB, CB.TASKCDCA, CB.SUBNUMCB, CB.SUBTIDCB FROM CB WHERE CB.RFDEIACB is null AND not exists (SELECT 1 FROM CC WHERE CB.EIACODXA = CC.EIACODXA AND CB.LSACONXB = CC.LSACONXB AND CB.ALTLCNXB = CC.ALTLCNXB AND CB.LCNTYPXB = CC.LCNTYPXB AND CB.TASKCDCA = CC.TASKCDCA AND CB.SUBNUMCB = CC.SUBNUMCB)

Parts without Part Application

/* This query finds parts in table HA that do not have a part application in table HG by performing an outer join. */

/* SYBASE Query */
SELECT HA.CAGECDXH, HA.REFNUMHA, HA.ITNAMEHA, HG.EIACODXA, HG.LSACONXB, HG.ALTLCNXB FROM HA, HG WHERE HA.CAGECDXH *= HG.CAGECDXH AND HA.REFNUMHA *= HG.REFNUMHA

/* ORACLE Query */
SELECT HA.CAGECDXH, HA.REFNUMHA, HA.ITNAMEHA, HG.EIACODXA, HG.LSACONXB, HG.ALTLCNXB FROM HA, HG WHERE HA.EIACODXA = HG.EIACODXA(+) AND HA.CAGECDXH = HG.CAGECDXH(+) AND HA.REFNUMHA = HG.REFNUMHA(+)

Average Predicted Mean Elapsed Time

/* Finds the average predicted mean elapsed time for all tasks */

SELECT CA.EIACODXA, AVG(CA.PRDMETCA) FROM CA GROUP BY CA.EIACODXA

NHA Part Numbers

//* Query to find NHA part numbers from PLISN/NHA PLISN. */

SELECT HG1.CAGECDXH, HG1.REFNUMHA, HG1.EIACODXA, HG1.LSACONXB, HG1.ALTLCNXB, HG1.PLISNOHG, HH.NHAPLIHH, HG2.CAGECDXH, HG2.REFNUMHA, HG2.LSACONXB, HG2.ALTLCNXB, HG2.PLISNOHG FROM HG HG1, HH, HG HG2 WHERE HG1.CAGECDXH = HH.CAGECDXH AND HG1.REFNUMHA = HH.REFNUMHA AND HG1.EIACODXA = HH.EIACODXA AND HG1.LSACONXB = HH.LSACONXB AND HG1.ALTLCNXB = HH.ALTLCNXB AND HG1.LCNTYPXB = HH.LCNTYPXB AND HH.EIACODXA = HG2.EIACODXA AND HH.NHAPLIHH = HG2.PLISNOHG ORDER BY HG1.LSACONXB, HG1.ALTLCNXB

Duplicate PLISNs in Table HG

/* This query searches Table HG for duplicate PLISNs. */

SELECT HG.PLISNOHG FROM HG WHERE HG.PLISNOHG IS NOT NULL GROUP BY HG.PLISNOHG HAVING COUNT(*) > 1

Duplicate PLISNs within a PCCN

/* This query searches for duplicate PLISNs. */

SELECT HG.PLISNOHG,XC.PCCNUMXC FROM HG, HO, XC WHERE HG.PLISNOHG IS NOT NULL AND HG.EIACODXA = HO.EIACODXA AND HG.LSACONXB = HO.LSACONHO AND HG.ALTLCNXB = HO.ALTLCNHO AND HG.LCNTYPXB = HO.LCNTYPXB AND HG.CAGECDXH = HO.CAGECDHO AND HG.REFNUMHA = HO.REFNUMHO AND HO.EIACODXA = XC.EIACODXA AND HO.LCNSEIHO = XC.LSACONXB AND HO.ALCSEIHO = XC.ALTLCNXB AND HO.LCNTYPXB = XC.LCNTYPXB GROUP BY HG.PLISNOHG,XC.PCCNUMXC HAVING COUNT(*) > 1

Failure Mode Ratio < 1

/* This query finds all Failure Mode Ratio less then 1 in table BF grouped by End Item, LCN, ALC, and LCN Type). */

/* SYBASE / ORACLE Query */
SELECT EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB, SUM(FMRATOBF) FROM BF WHERE FAMOINBF LIKE 'F%' GROUP BY EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB HAVING SUM(FMRATOBF) < 1

EAGLE Tutorials
The following tutorials were developed by Team EAGLE to demonstrate powerful new features available in the current EAGLE release. For assistance with these or any other EAGLE tools, contact the EAGLE Helpdesk at 520.663.6673 or e-mail us at raytheoneagle@raytheon.com.

Tutorial on using the Artwork and Drawing Bulk Load Wizard
Tutorial on importing data into the Bill of Materials function.
Tutorial on Cloning Tasks.
Tutorial on the assignment of Provisioning Usable on Codes.