CIRQIT@XENON> sta noinline.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 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 11 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 12 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 13 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 14 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 15 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 16 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 17 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 18 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 19 316882 05-APR-11 ACS Shared Service Center (SSC) 2486 316882-2 Anant_5_ACS_8 Brooks ,Steven 990 30 0 1020 26.73 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 130 rows selected. Execution Plan ---------------------------------------------------------- Plan hash value: 1638279263 --------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 8295 | 135 (6)| 00:00:02 | | 1 | SORT ORDER BY | | 1 | 8295 | 135 (6)| 00:00:02 | | 2 | NESTED LOOPS SEMI | | 1 | 8295 | 134 (5)| 00:00:02 | | 3 | NESTED LOOPS | | 1 | 8285 | 132 (5)| 00:00:02 | | 4 | NESTED LOOPS | | 1 | 8254 | 131 (5)| 00:00:02 | | 5 | NESTED LOOPS | | 1 | 8175 | 129 (5)| 00:00:02 | | 6 | NESTED LOOPS | | 1 | 8147 | 128 (5)| 00:00:02 | |* 7 | HASH JOIN | | 1 | 8096 | 126 (5)| 00:00:02 | |* 8 | HASH JOIN | | 1 | 6072 | 94 (5)| 00:00:02 | |* 9 | HASH JOIN | | 1 | 4048 | 63 (5)| 00:00:01 | | 10 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 11 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 12 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 13 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 14 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 15 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 16 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 17 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 18 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 19 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 2 (0)| 00:00:01 | |* 20 | INDEX RANGE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 1 (0)| 00:00:01 | |* 21 | INDEX UNIQUE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 1 (0)| 00:00:01 | | 22 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 23 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 24 | NESTED LOOPS | | | | | | | 25 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 26 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 27 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 28 | TABLE ACCESS BY INDEX ROWID| PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 29 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 30 | TABLE ACCESS BY INDEX ROWID| ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 31 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 32 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 33 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 34 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 35 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 36 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 37 | NESTED LOOPS | | | | | | | 38 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 39 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 40 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 41 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 42 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 43 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 44 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 45 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 46 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 47 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 48 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 49 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 50 | NESTED LOOPS | | | | | | | 51 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 52 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 53 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 54 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 55 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 56 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 57 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_INDX | 26 | | 4 (0)| 00:00:01 | |* 58 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 59 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 60 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | |* 61 | TABLE ACCESS BY INDEX ROWID | PRODUCT_ORDER | 1 | 51 | 2 (0)| 00:00:01 | |* 62 | INDEX RANGE SCAN | PRODUCT_ORDER_KEY_INDX | 1 | | 1 (0)| 00:00:01 | |* 63 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 28 | 1 (0)| 00:00:01 | |* 64 | INDEX UNIQUE SCAN | PBVORG_PK | 1 | | 0 (0)| 00:00:01 | |* 65 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 79 | 2 (0)| 00:00:01 | |* 66 | INDEX UNIQUE SCAN | ESTIMATE_PK | 1 | | 1 (0)| 00:00:01 | | 67 | TABLE ACCESS BY INDEX ROWID | CIRQIT_USER | 1 | 31 | 1 (0)| 00:00:01 | |* 68 | INDEX UNIQUE SCAN | CIRQIT_USER_PK | 1 | | 0 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | ORDER_STATUS_PK | 5220 | 52200 | 2 (0)| 00:00:01 | --------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - access("H"."ID"="G"."ID") 8 - access("G"."ID"="E"."ID") 9 - access("E"."ID"="F"."ID") 16 - access("C"."PARENT_ORG_ID"=2485) 17 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 18 - 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')) 19 - filter(TRUNC("D"."DISPLAY_ORDER"/100,0)>1) 20 - access("B"."ORG_ID"="D"."ORG_ID" AND "D"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') 21 - 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%') 29 - access("C"."PARENT_ORG_ID"=2485) 30 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 31 - 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')) 32 - 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%') 33 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') 42 - access("C"."PARENT_ORG_ID"=2485) 43 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 44 - 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')) 45 - 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%') 46 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') 55 - access("C"."PARENT_ORG_ID"=2485) 56 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 57 - 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')) 58 - 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%') 59 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') 61 - filter("A"."CURRENT_STATUS_NAME"<>'CANC' AND "A"."CURRENT_STATUS_NAME"<>'OREJ') 62 - access("H"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "H"."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") 63 - filter("D"."PARENT_ORG_ID"=2485) 64 - access("A"."CLIENT_ORG_ID"="D"."ORG_ID") 65 - 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')) 66 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."VERSION_NBR") 68 - access("C"."USER_ID"="B"."SPEC_CONTACT_USER_ID") 69 - access("Y"."ORDER_NBR"="A"."ORDER_NBR" AND "Y"."STATUS_NAME"='OACT') CIRQIT@XENON> sool off SP2-0042: unknown command "sool off" - rest of line ignored. CIRQIT@XENON> spool off