CIRQIT@XENON> sta inline.sql ESTIMATE_NBR Order_Dat ------------ --------- Organization ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Org_ID Job_ID ---------- --------------------------------------------------------------------------------- Name ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACS_Requestor Order_Cost Shipping Change_Order_Cost Total_Cost Fee ------------------------------------------------------------------------------------------------------ ---------- ---------- ----------------- ---------- ---------- ACTIVITY ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- FUND ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ACCOUNT_CODE ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- BUS_Purpose ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Notes ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ID ---------- 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 EE SSSS 55$$ SS sss 11 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 TT DDD 77!!! DDF sss 12 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 RR FFF 88~~~ ff sss 13 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 YY GGG 999? gg sss 14 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 UU HHH 044% hh sss 15 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 II JJJJ YY() jj sss 16 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 OP KKK 33** kk sss 17 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 [ LLL 22^^ ll sss 18 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 ] ;;; EE5 ;; sss 19 316883 05-APR-11 ACS Great Lakes 2490 316883-2 Anant_5_ACS_15 Brooks ,Steven 70 30 0 100 1.89 \ >>>> 77@ ''' sss 20 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 )))1 aaa 11q 1+1aa@ This is for Job 11 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 (((2 bbb 22q 2-2bb! This is for Job 12 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 ***3 ccc 33qq 3*3cc# This is for Job 13 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 &&&4 ddd 44q 4/4dd$ This is for Job 14 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 ^^^5 eee 55q 5+5ee% This is for Job 15 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 %%%6 fff 66q 6-6ff^ This is for Job 16 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 $$$7 ggg 77q 7*7gg& This is for Job 17 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 ###8 hhh 88q 8/8hh* This is for Job 18 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 @@@9 iii 99q 9+9ii( This is for Job 19 316885 05-APR-11 ACS Mid South 2489 316885-2 Anant_5_ACS_13 Brooks ,Steven 1650 30 0 1680 44.55 !!!11 jjj 100q 10-10jj) This is for Job 20 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 ))) aaa++ 11 1+1aa@ This is for Job 11 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 ((( bbb// 22 2-2bb! This is for Job 12 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 *** ccc** 33 3*3cc# This is for Job 13 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 &&& ddd-- 44 4/4dd$ This is for Job 14 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 ^^^ eee66 55 5+5ee% This is for Job 15 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 %%% fff55## 66 6-6ff^ This is for Job 16 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 $$$ ggg4$$ 77 7*7gg& This is for Job 17 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 ### hhh5% 88 8/8hh* This is for Job 18 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 @@@ iii666 99 9+9ii( This is for Job 19 316878 05-APR-11 ACS Shared Service Center (SSC) 2486 316878-2 Anant_5_ACS_2 Brooks ,Steven 1320 20 0 1340 35.64 !!! jjj9(( 100 10-10jj) This is for Job 20 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 2www aass 55 yyy ddddd 12 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 ese qq@@dd 66 uuu ddddd 13 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 adfga gg##ss 77 iiii ddddd 14 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 afga kk~~ww 88 ooo ddddd 15 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 afg oo()pp 99 ppp ddddd 16 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 asfg uu??bb 00 [[ ddddd 17 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 agfas ss==yy -- ]]] ddddd 18 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 hhh zz$$cc {{ 444 ddddd 19 316877 05-APR-11 ACS Shared Service Center (SSC) 2486 316877-1 Anant_5_ACS_10 Brooks ,Steven 220 30 0 250 5.94 eee jj**mm }} 7677 ddddd 20 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 22 ww $$ ee ssss 11 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 333 ee %% tt ssss 12 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 444 rr ^^ yy ssss 13 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 555 tt && uu ssss 14 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 667 yy *** ii ssss 15 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 888 uu (( oo ssss 16 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 9 iii )) pp ssss 17 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 02@@ oo ~~ [[ ssss 18 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 -`1 pp ``` ]] ssss 19 316876 05-APR-11 ACS Shared Service Center (SSC) 2486 316876-1 Anant_5_ACS_9 Brooks ,Steven 150 20 0 170 4.05 33 [[ ??? \\ ssss 20 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 55 qq ~~~ ddd ethetrewqrgwerg 11 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 66 ww @@@ fff ethetrewqrgwerg 12 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 77 ee ### ggg ethetrewqrgwerg 13 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 88 rr $$$ hhh ethetrewqrgwerg 14 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 99 ttt %% jjj ethetrewqrgwerg 15 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 11 yy ^^^ kkk ethetrewqrgwerg 16 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 22 uu && lll ethetrewqrgwerg 17 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 33 ii **** ;;; ethetrewqrgwerg 18 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 44 oo ((( '' ethetrewqrgwerg 19 316875 05-APR-11 ACS Shared Service Center (SSC) 2486 316875-1 Anant_5_ACS_8 Brooks ,Steven 880 20 0 900 23.76 55 pp )))) eee ethetrewqrgwerg 20 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 EE SSSS 55$$ SS sss 11 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 TT DDD 77!!! DDF sss 12 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 RR FFF 88~~~ ff sss 13 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 YY GGG 999? gg sss 14 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 UU HHH 044% hh sss 15 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 II JJJJ YY() jj sss 16 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 OP KKK 33** kk sss 17 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 [ LLL 22^^ ll sss 18 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 ] ;;; EE5 ;; sss 19 316874 05-APR-11 ACS Shared Service Center (SSC) 2486 316874-1 Anant_5_ACS_7 Brooks ,Steven 20 20 0 40 .54 \ >>>> 77@ ''' sss 20 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 ee -1 *a ~~~~~~ @@$$$$$$$%%%%%%^^^^^^^^^ 11 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 rr -2 *w ```````` @@$$$$$$$%%%%%%^^^^^^^^^ 12 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 tt -3 *e ~~~~~~~~ @@$$$$$$$%%%%%%^^^^^^^^^ 13 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 yy -4 *r ```````` @@$$$$$$$%%%%%%^^^^^^^^^ 14 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 uu -5 *yy ~~~~~~~~~~ @@$$$$$$$%%%%%%^^^^^^^^^ 15 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 ii -6 *t ````````` @@$$$$$$$%%%%%%^^^^^^^^^ 16 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 oo -7 *u ~~~~~~~~~~~ @@$$$$$$$%%%%%%^^^^^^^^^ 17 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 pp -8 *i ````````````` @@$$$$$$$%%%%%%^^^^^^^^^ 18 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 [[ -9 *o ~~~~~~~~ @@$$$$$$$%%%%%%^^^^^^^^^ 19 316872 05-APR-11 ACS Shared Service Center (SSC) 2486 316872-1 Anant_5_ACS_5 Brooks ,Steven 20 30 0 50 .54 }}} -10 *p ``````````` @@$$$$$$$%%%%%%^^^^^^^^^ 20 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 )))1 aaa 11q 1+1aa@ This is for Job 11 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 (((2 bbb 22q 2-2bb! This is for Job 12 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 ***3 ccc 33qq 3*3cc# This is for Job 13 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 &&&4 ddd 44q 4/4dd$ This is for Job 14 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 ^^^5 eee 55q 5+5ee% This is for Job 15 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 %%%6 fff 66q 6-6ff^ This is for Job 16 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 $$$7 ggg 77q 7*7gg& This is for Job 17 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 ###8 hhh 88q 8/8hh* This is for Job 18 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 @@@9 iii 99q 9+9ii( This is for Job 19 316871 05-APR-11 ACS Shared Service Center (SSC) 2486 316871-1 Anant_5_ACS_4 Brooks ,Steven 1650 50 0 1700 44.55 !!!11 jjj 100q 10-10jj) This is for Job 20 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 11q 1! 1100 Paper This is for Job 11 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 22w 2@ 1200 Color This is for Job 12 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 33e 3# 1300 Design This is for Job 13 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 44r 4$ 1400 Equipments This is for Job 14 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 55t 5% 1500 Labour This is for Job 15 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 66y 6^ 1600 Transport This is for Job 16 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 77u 7& 1700 Warehouse This is for Job 17 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 88i 8* 1800 Carrier This is for Job 18 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 99o 9( 1900 Tax This is for Job 19 316870 05-APR-11 ACS Shared Service Center (SSC) 2486 316870-1 Anant_5_ACS_3 Brooks ,Steven 120 40 0 160 3.24 100p 10) 2000 Invoice This is for Job 20 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 ))) aaa 11 1+1aa@ This is for Job 11 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 ((( bbb 22 2-2bb! This is for Job 12 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 *** ccc 33 3*3cc# This is for Job 13 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 &&& ddd 44 4/4dd$ This is for Job 14 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 ^^^ eee 55 5+5ee% This is for Job 15 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 %%% fff 66 6-6ff^ This is for Job 16 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 $$$ ggg 77 7*7gg& This is for Job 17 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 ### hhh 88 8/8hh* This is for Job 18 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 @@@ iii 99 9+9ii( This is for Job 19 316869 05-APR-11 ACS Shared Service Center (SSC) 2486 316869-1 Anant_5_ACS_2 Brooks ,Steven 1980 40 0 2020 53.46 !!! jjj 100 10-10jj) This is for Job 20 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 11 1 1100 Paper This is for Job 11 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 22 2 1200 Color This is for Job 12 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 33 3 1300 Design This is for Job 13 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 44 4 1400 Equipments This is for Job 14 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 55 5 1500 Labour This is for Job 15 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 66 6 1600 Transport This is for Job 16 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 77 7 1700 Warehouse This is for Job 17 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 88 8 1800 Carrier This is for Job 18 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 99 9 1900 Tax This is for Job 19 316868 05-APR-11 ACS Shared Service Center (SSC) 2486 316868-1 Anant_5_ACS_1 Brooks ,Steven 180 50 0 230 4.86 100 10 2000 Invoice This is for Job 20 120 rows selected. Execution Plan ---------------------------------------------------------- Plan hash value: 2056288832 ---------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 8317 | 166 (5)| 00:00:02 | | 1 | SORT ORDER BY | | 1 | 8317 | 166 (5)| 00:00:02 | | 2 | NESTED LOOPS SEMI | | 1 | 8317 | 165 (5)| 00:00:02 | | 3 | NESTED LOOPS | | 1 | 8307 | 163 (5)| 00:00:02 | | 4 | NESTED LOOPS | | 1 | 8276 | 162 (5)| 00:00:02 | | 5 | NESTED LOOPS | | 1 | 8197 | 160 (5)| 00:00:02 | | 6 | NESTED LOOPS | | 1 | 8169 | 159 (5)| 00:00:02 | |* 7 | HASH JOIN | | 1 | 8118 | 157 (5)| 00:00:02 | |* 8 | HASH JOIN | | 1 | 8096 | 126 (5)| 00:00:02 | |* 9 | HASH JOIN | | 1 | 6072 | 94 (5)| 00:00:02 | |* 10 | HASH JOIN | | 1 | 4048 | 63 (5)| 00:00:01 | | 11 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 12 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 13 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 14 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 15 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 16 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 17 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 18 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 19 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 20 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 2 (0)| 00:00:01 | |* 21 | INDEX RANGE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 1 (0)| 00:00:01 | |* 22 | INDEX UNIQUE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 1 (0)| 00:00:01 | | 23 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 24 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 25 | NESTED LOOPS | | | | | | | 26 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 27 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 28 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 29 | TABLE ACCESS BY INDEX ROWID| PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 30 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 31 | TABLE ACCESS BY INDEX ROWID| ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 32 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 33 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 34 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 35 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 36 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 37 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 38 | NESTED LOOPS | | | | | | | 39 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 40 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 41 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 42 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 43 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 44 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 45 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 46 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 47 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 48 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 49 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 50 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 51 | NESTED LOOPS | | | | | | | 52 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 53 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 54 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 55 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 56 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 57 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 58 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 59 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 60 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 61 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 62 | VIEW | | 1 | 22 | 31 (4)| 00:00:01 | | 63 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 64 | NESTED LOOPS | | | | | | | 65 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 66 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 67 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 68 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 70 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 71 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 72 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 73 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 74 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | |* 75 | TABLE ACCESS BY INDEX ROWID | PRODUCT_ORDER | 1 | 51 | 2 (0)| 00:00:01 | |* 76 | INDEX RANGE SCAN | PRODUCT_ORDER_KEY_INDX | 1 | | 1 (0)| 00:00:01 | |* 77 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 28 | 1 (0)| 00:00:01 | |* 78 | INDEX UNIQUE SCAN | PBVORG_PK | 1 | | 0 (0)| 00:00:01 | |* 79 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 79 | 2 (0)| 00:00:01 | |* 80 | INDEX UNIQUE SCAN | ESTIMATE_PK | 1 | | 1 (0)| 00:00:01 | | 81 | TABLE ACCESS BY INDEX ROWID | CIRQIT_USER | 1 | 31 | 1 (0)| 00:00:01 | |* 82 | INDEX UNIQUE SCAN | CIRQIT_USER_PK | 1 | | 0 (0)| 00:00:01 | |* 83 | INDEX RANGE SCAN | ORDER_STATUS_PK | 5220 | 52200 | 2 (0)| 00:00:01 | ---------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - access("I"."ID"="H"."ID") 8 - access("H"."ID"="G"."ID") 9 - access("G"."ID"="E"."ID") 10 - access("E"."ID"="F"."ID") 17 - access("C"."PARENT_ORG_ID"=2485) 18 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 19 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 20 - filter(TRUNC("D"."DISPLAY_ORDER"/100,0)>1) 21 - access("B"."ORG_ID"="D"."ORG_ID" AND "D"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') 22 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') 30 - access("C"."PARENT_ORG_ID"=2485) 31 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 32 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 33 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') 34 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') 43 - access("C"."PARENT_ORG_ID"=2485) 44 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 45 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 46 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') 47 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') 56 - access("C"."PARENT_ORG_ID"=2485) 57 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 58 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 59 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') 60 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') 69 - access("C"."PARENT_ORG_ID"=2485) 70 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 71 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 72 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSAmount%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSAmount%') 73 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSAmount%') 75 - filter("A"."CURRENT_STATUS_NAME"<>'CANC' AND "A"."CURRENT_STATUS_NAME"<>'OREJ') 76 - access("I"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "I"."VERSION_NBR"="A"."VERSION_NBR") filter("E"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "E"."VERSION_NBR"="A"."VERSION_NBR" AND "F"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "F"."VERSION_NBR"="A"."VERSION_NBR" AND "G"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "G"."VERSION_NBR"="A"."VERSION_NBR" AND "H"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "H"."VERSION_NBR"="A"."VERSION_NBR") 77 - filter("D"."PARENT_ORG_ID"=2485) 78 - access("A"."CLIENT_ORG_ID"="D"."ORG_ID") 79 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer' AND TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 80 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR") 82 - access("C"."USER_ID"="B"."SPEC_CONTACT_USER_ID") 83 - access("Y"."ORDER_NBR"="A"."ORDER_NBR" AND "Y"."STATUS_NAME"='OACT') CIRQIT@XENON> spool off