WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
KLASH	1701927951	klash	1	06-Jan-15 15:01	11.2.0.4.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
oradb11	Linux x86 64-bit	48	24	2	126.13

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	3179	07-Jan-15 10:00:18	717	6.2
End Snap:	3180	07-Jan-15 11:00:30	839	6.4
Elapsed:		60.21 (mins)
DB Time:		299.40 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	5.0	0.3	0.00	0.01
DB CPU(s):	4.8	0.3	0.00	0.01
Redo size (bytes):	8,597,075.5	547,800.9
Logical read (blocks):	580,001.5	36,957.4
Block changes:	75,908.9	4,836.9
Physical read (blocks):	296.9	18.9
Physical write (blocks):	708.7	45.2
Read IO requests:	32.5	2.1
Write IO requests:	59.1	3.8
Read IO (MB):	2.3	0.2
Write IO (MB):	5.5	0.4
User calls:	856.5	54.6
Parses (SQL):	190.8	12.2
Hard parses (SQL):	14.2	0.9
SQL Work Area (MB):	145.4	9.3
Logons:	0.4	0.0
Executes (SQL):	16,995.7	1,083.0
Rollbacks:	1.4	0.1
Transactions:	15.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	99.75	Soft Parse %:	92.56
Execute to Parse %:	98.88	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	95.39	% Non-Parse CPU:	97.39

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

Host CPU

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
48	24	2	7.00	7.35	9.8	0.5	1.4	89.7

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
10.0	96.9	0.0

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	117.7	35.1	82.6
Database Requests:	91.6	32.5	59.1
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	22.3	0.0	22.3
Total (MB):	16.4	2.4	14.0
Database (MB):	7.9	2.3	5.5
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	8.5	0.0	8.5
Database (blocks):	1,005.5	296.9	708.7
Via Buffer Cache (blocks):	1,004.9	296.8	708.1
Direct (blocks):	0.7	0.1	0.6

Memory Statistics

	Begin	End
Host Mem (MB):	129,156.5	129,156.5
SGA use (MB):	43,008.0	43,008.0
PGA use (MB):	2,613.2	2,440.5
% Host Mem used for SGA+PGA:	35.32	35.19

Cache Sizes

	Begin	End
Buffer Cache:	25,600M	25,600M	Std Block Size:	8K
Shared Pool Size:	12,477M	12,449M	Log Buffer:	147,576K

Shared Pool Statistics

	Begin	End
Memory Usage %:	62.05	65.66
% SQL with executions>1:	94.05	93.62
% Memory for SQL w/exec>1:	84.97	85.38

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 17963.8s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 99.5% of Total DB time 17,963.83 (s)
• Total FG Wait Time: 596.24 (s) DB CPU time: 17,283.32 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 80.0% of Total DB Time (s): 17,964
• Captured PL/SQL account for 38.8% of Total DB Time (s): 17,964

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 82.2% of Total CPU Time (s): 17,283
• Captured PL/SQL account for 40.2% of Total CPU Time (s): 17,283

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 11.7% of Total User I/O Wait Time (s): 331
• Captured PL/SQL account for 3.0% of Total User I/O Wait Time (s): 331

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 2,095,298,266
• Captured SQL account for 66.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 1,072,490
• Captured SQL account for 2.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 117,242
• Captured SQL account for 18.2% of Total
• Total UnOptimized Read Requests: 117,242
• Captured SQL account for 18.2% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 61,398,137
• Captured SQL account for 10.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 689,262
• Captured SQL account for 42.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0fp5gfr2cqnf0	SELECT CCODE, empcode, empname, fname, DESIGNATION, desigcode, DEPT, deptcode, WDAYS, EMP_UNIT_SAL, EMP_SAL, EMP_TOTAL, MAKEUP FROM (SELECT CCODE, empcode, empname, fname, PRODUCTION.DESIGCODE_VALIDATION(desigcode) DESIGNATION, desigcode, HRM.DEPTCODE_VALIDATION(deptcode) DEPT, deptcode, DAYS WDAYS, EMP_UNIT_SAL, EMP_SAL, EMP_SAL*DAYS EMP_TOTAL, CASE WHEN ROUND((EMP_UNIT_SAL*((EMP_SAL*DAYS)-U_EMPSUM_SAL))/DECODE(U_EMPSUM_SAL, 0, 1, U_EMPSUM_SAL))<0 and EMP_UNIT_SAL>0 and DAYS>0 THEN 0 when ROUND((EMP_UNIT_SAL*((EMP_SAL*DAYS)-U_EMPSUM_SAL))/DECODE(U_EMPSUM_SAL, 0, 1, U_EMPSUM_SAL))>=0 and EMP_UNIT_SAL>0 and DAYS>0 THEN ROUND((EMP_UNIT_SAL*((EMP_SAL*DAYS)-U_EMPSUM_SAL))/DECODE(U_EMPSUM_SAL, 0, 1, U_EMPSUM_SAL)) ELSE (EMP_SAL*DAYS) END MAKEUP FROM ( SELECT DISTINCT w.ccode, w.empcode, w.empname, w.fname, decode(e.desigcode, NULL, w.desigcode, e.desigcode) desigcode, decode(e.deptcode, NULL, w.deptcode, e.deptcode)deptcode, (26-GET_EMP_ABS_datewise(w.em pcode, :fdate, :tdate)) days, NVL(SUM (ROUND (amt, 2)) OVER (PARTITION BY w.ccode, w.empcode, w.empname, w.fname ), 0)U_EMPSUM_sal, NVL(SUM (ROUND (amt, 2)) OVER (PARTITION BY w.ccode, w.empcode, w.empname, w.fname, decode(e.desigcode, NULL, w.desigcode, e.desigcode) , decode(e.deptcode, NULL, w.deptcode, e.deptcode) ), 0)emp_unit_sal, NVL(round(hrm.GET_EMPCODE_SALARY(w.empcode)/26, 0), 0)emp_sal FROM (select distinct t.empcode, e.ccode, e.empname, e.fname, e.desigcode, e.deptcode from daily_attendance t, tblhrmemployee e where t.dated BETWEEN :fdate AND :tdate and t.timein is not null and e.emptype=:EMPTYPE AND E.DESIGCODE IN (72, 87, 114, 115, 108, 202) and e.empcode=t.empcode and e.deptcode!=1102 and decode(e.ccode, 4, 21, e.ccode)=:cc) w, (SELECT DISTINCT a.ccode, b.emp_code empcode, e.empname, e.fname, e.desigcode, SUM (ROUND ((a.stitched_qty / 12), 2) * get_plane_opration_rate(a.planno, b.opration_id)) amt, DECODE (a.unit_num, 2547, 2514, a.unit_num) deptcode FROM opr_wages_emp_master a, opr_wages_emp_dtl b, hrm.tblhrmemployee e WHERE a.opr_main_id = b.opr_main_id AND b.emp_code IS NOT NULL AND E.DESIGCODE IN (72, 87, 114, 115, 108, 202) AND e.empcode = b.emp_code AND production.get_emptype (b.emp_code) =:EMPTYPE AND a.dated BETWEEN :fdate AND :tdate AND a.ccode = :cc --AND NVL (a.paid, 'N') = 'N' GROUP BY a.ccode, e.empname, e.fname, b.emp_code, e.desigcode, DECODE(a.unit_num, 2547, 2514, a.unit_num) UNION ALL SELECT DISTINCT a.ccode, md.empcode empcode, e.empname, e.fname, e.desigcode, SUM(ROUND ((a.stitched_qty / 12), 2)* get_plane_opration_rate(a.planno, opration)) amt, DECODE (a.unit_num, 2547, 2514, a.unit_num) deptcode FROM opr_wages_emp_master a, opr_wages_emp_m md, hrm.tblhrmemployee e WHERE a.opr_main_id = md.opr_main_id AND e.empcode = md.empcode AND get_emptype (md.empcode) = :EMPTYPE AND E.DESIGCODE IN (72, 87, 114, 115, 108, 202) AND ddate BETWEEN :fdate AND :tdate AND a.ccode = :cc -- AND NVL (dpaid, 'N') = 'N' GROU P BY a.ccode, e.empname, e.fname, md.empcode, e.desigcode, DECODE(a.unit_num, 2547, 2514, a.unit_num) UNION ALL SELECT DISTINCT a.ccode, a.empcode empcode, e.empname, e.fname, e.desigcode, a.amt, a.unit_no FROM production.opr_wages_emp_add a, tblhrmemployee e WHERE a.empcode = e.empcode AND production.get_emptype (a.empcode) =:EMPTYPE AND E.DESIGCODE IN (72, 87, 114, 115, 108, 202) AND a.dated BETWEEN :fdate AND :tdate AND a.ccode = :cc -- AND NVL (a.paid, 'N') = 'N' ) e where w.empcode=e.empcode(+) )) WHERE MAKEUP>0 and (:P_UNIT IS NULL OR deptcode=:P_UNIT) ORDER BY empcode, 6 DESC
0hdxxufz5jb36	INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."YARN_BAG_STK_LOC" select t.LOC_ID, t.BAG_NO, sum(t.BAG_QTY)BAG_QTY from yarn_po_stock_barcode t group by t.LOC_ID, t.BAG_NO having sum(t.BAG_QTY)>0
0k8522rmdzg4k	獥汥捴⁰物癩汥来⌠晲潭⁳祳慵瑨␠睨敲攠⡧牡湴敥⌽㨱爠杲慮瑥攣㴱⤠慮搠灲楶楬敧攣㸰
0qjt2sznvf0r9	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.MV_SHIPPING'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
17x173b8v53p7	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.MV_STITCHING'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
18z93abjz28am	SELECT PONO, 'A' O, 'REQUIRED' TTYPE, HIT_TYPE, HIT_NO, DELIVERY_DATE, NULL SHIPMODE, '0' MANUL_INV_NO, NULL ETA_DATE, S1, S2, S3, S4, S5, S6, S7, S8, S9, S10, S11, S12, S13, S14, S15, S16, S17, S18, S19, S20 FROM PRODUCTION.KCL_PO_HITS WHERE PONO = : PONO UNION ALL SELECT PONO, 'A' O, 'PREPACK RATIO' TTYPE, HIT_TYPE, 0, NULL, NULL, NULL, NULL, SUM(S1/PACK_QTY) S1, SUM(S2/PACK_QTY) S2, SUM(S3/PACK_QTY) S3, SUM(S4/PACK_QTY) S4, SUM(S5/PACK_QTY) S5, SUM(S6/PACK_QTY) S6, SUM(S7/PACK_QTY) S7, SUM(S8/PACK_QTY) S8, SUM(S9/PACK_QTY) S9, SUM(S10/PACK_QTY) S10, SUM(S11/PACK_QTY) S11, SUM(S12/PACK_QTY) S12, SUM(S13/PACK_QTY) S13, SUM(S14/PACK_QTY) S14, SUM(S15/PACK_QTY) S15, SUM(S16/PACK_QTY) S16, SUM(S17/PACK_QTY) S17, SUM(S18/PACK_QTY) S18, SUM(S19/PACK_QTY) S19, SUM(S20/PACK_QTY) S20 FROM PRODUCTION.KCL_PO_HITS WHERE PONO = : PONO AND HIT_TYPE = 'PREPACK' GROUP BY PONO , HIT_TYPE UNION ALL SELECT PONO, O, TTYPE, HIT_TYPE, HIT_NO, SHIP_DATE, SHIPMODE, MANUL_INV_NO, ETA_DATE, SUM(S1) S1 , SUM(S2) S2, SUM(S3) S3, SUM(S4) S4, SUM(S5) S5, SUM(S6) S6, SUM(S7) S7, SUM(S8) S8, SUM(S9) S9, SUM(S10) S10, SUM(S11) S11, SUM(S12) S12, SUM(S13), SUM(S14) S14, SUM(S15) S15, SUM(S16) S16, SUM(S17) S17, SUM(S18) S18, SUM(S19) S19, SUM(S20) S20 FROM( SELECT M.PONO, 'B' O, 'SHIPPED' TTYPE, D.HIT_TYPE, D.HIT_NO, E.INV_DATE SHIP_DATE, E.SHIP_MODE SHIPMODE, E.INV_NO_M MANUL_INV_NO, E.ETA_DATE ETA_DATE, NVL(SUM(D.S1*(D.TCTN -D.FCTN+1)), 0) S1, NVL(SUM(D.S2*(D.TCTN -D.FCTN+1)), 0) S2, NVL(SUM(D.S3*(D.TCTN -D.FCTN+1)), 0) S3, NVL(SUM(D.S4*(D.TCTN -D.FCTN+1)), 0) S4, NVL(SUM(D.S5*(D.TCTN -D.FCTN+1)), 0) S5, NVL(SUM(D.S6*(D.TCTN -D.FCTN+1)), 0) S6, NVL(SUM(D.S7*(D.TCTN -D.FCTN+1)), 0) S7, NVL(SUM(D.S8*(D.TCTN -D.FCTN+1)), 0) S8, NVL(SUM(D.S9*(D.TCTN -D.FCTN+1)), 0) S9, NVL(SUM(D.S10*(D.TCTN -D.FCTN+1)), 0) S10, NVL(SUM(D.S11*(D.TCTN -D.FCTN+1)), 0) S11, NVL(SUM(D.S12*(D.TCTN -D.FCTN+1)), 0) S12, NVL(SUM(D.S13*(D.TCTN -D.FCTN+1)), 0) S13, NVL(SUM(D.S14*(D.TCTN -D.FC TN+1)), 0) S14, NVL(SUM(D.S15*(D.TCTN -D.FCTN+1)), 0) S15, NVL(SUM(D.S16*(D.TCTN -D.FCTN+1)), 0) S16, NVL(SUM(D.S17*(D.TCTN -D.FCTN+1)), 0) S17, NVL(SUM(D.S18*(D.TCTN -D.FCTN+1)), 0) S18, NVL(SUM(D.S19*(D.TCTN -D.FCTN+1)), 0) S19, NVL(SUM(D.S20*(D.TCTN -D.FCTN+1)), 0) S20 FROM WPL_DTL D, WPL_MST M, EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NOT NULL AND D.HIT_NO IS NOT NULL AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' GROUP BY M.PONO, 'B' , 'SHIPPED', D.HIT_TYPE, D.HIT_NO, E.INV_DATE, E.SHIP_MODE, E.INV_NO_M, E.ETA_DATE UNION ALL -----------------SPLIT PACKING LIST SELECT M.PONO, 'B' O, 'SHIPPED' TTYPE, S.HIT_TYPE, S.HIT_NO, E.INV_DATE SHIP_DATE, E.SHIP_MODE SHIPMODE, E.INV_NO_M MANUL_INV_NO, E.ETA_DATE ETA_DATE, NVL(SUM(S.S1), 0) S1, NVL(SUM(S.S2), 0) S2, NVL(SUM(S.S3), 0) S3, NVL(SUM(S.S4), 0) S4, NVL(SUM(S.S5), 0) S5, NVL(SUM(S.S6), 0) S6, NVL(SUM(S.S7), 0) S 7, NVL(SUM(S.S8), 0) S8, NVL(SUM(S.S9), 0) S9, NVL(SUM(S.S10), 0) S10, NVL(SUM(S.S11), 0) S11, NVL(SUM(S.S12), 0) S12, NVL(SUM(S.S13), 0) S13, NVL(SUM(S.S14), 0) S14, NVL(SUM(S.S15), 0) S15, NVL(SUM(S.S16), 0) S16, NVL(SUM(S.S17), 0) S17, NVL(SUM(S.S18), 0) S18, NVL(SUM(S.S19), 0) S19, NVL(SUM(S.S20), 0) S20 FROM WPL_MST M, WPL_DTL D, WPL_SPLIT S, EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO=D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NULL AND D.HIT_NO IS NULL AND D.PK=S.FK AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' AND S.HIT_TYPE IS NOT NULL AND S.HIT_NO IS NOT NULL GROUP BY M.PONO, 'B' , 'SHIPPED', S.HIT_TYPE, S.HIT_NO, E.INV_DATE, E.SHIP_MODE, E.INV_NO_M, E.ETA_DATE ) GROUP BY PONO , O , TTYPE , HIT_TYPE , HIT_NO , SHIP_DATE , SHIPMODE , MANUL_INV_NO , ETA_DATE UNION ALL SELECT PONO, O, TTYPE, HIT_TYPE, HIT_NO, SYSDATE, NULL, NULL, NULL, SUM(S1) S1, SUM(S2) S2, SUM(S3) S3, SUM(S4) S4, SUM(S5) S5, SUM(S6 ) S6, SUM(S7) S7, SUM(S8) S8, SUM(S9) S9, SUM(S10) S10, SUM(S11) S11, SUM(S12) S12, SUM(S13) S13, SUM(S14) S14, SUM(S15) S15, SUM(S16) S16, SUM(S17) S17, SUM(S18) S18, SUM(S19) S19, SUM(S20) S20 FROM ( SELECT M.PONO, 'BB' O, 'TOTAL' TTYPE, D.HIT_TYPE, D.HIT_NO, SYSDATE, NVL(SUM(D.S1*(D.TCTN -D.FCTN+1)), 0) S1, NVL(SUM(D.S2*(D.TCTN -D.FCTN+1)), 0) S2, NVL(SUM(D.S3*(D.TCTN -D.FCTN+1)), 0) S3, NVL(SUM(D.S4*(D.TCTN -D.FCTN+1)), 0) S4, NVL(SUM(D.S5*(D.TCTN -D.FCTN+1)), 0) S5, NVL(SUM(D.S6*(D.TCTN -D.FCTN+1)), 0) S6, NVL(SUM(D.S7*(D.TCTN -D.FCTN+1)), 0) S7, NVL(SUM(D.S8*(D.TCTN -D.FCTN+1)), 0) S8, NVL(SUM(D.S9*(D.TCTN -D.FCTN+1)), 0) S9, NVL(SUM(D.S10*(D.TCTN -D.FCTN+1)), 0) S10, NVL(SUM(D.S11*(D.TCTN -D.FCTN+1)), 0) S11, NVL(SUM(D.S12*(D.TCTN -D.FCTN+1)), 0) S12, NVL(SUM(D.S13*(D.TCTN -D.FCTN+1)), 0) S13, NVL(SUM(D.S14*(D.TCTN -D.FCTN+1)), 0) S14, NVL(SUM(D.S15*(D.TCTN -D.FCTN+1)), 0) S15, NVL(SUM(D.S16*(D.TCTN -D.FCTN+1)), 0) S16, NVL(SUM(D.S17*(D.TCTN -D. FCTN+1)), 0) S17, NVL(SUM(D.S18*(D.TCTN -D.FCTN+1)), 0) S18, NVL(SUM(D.S19*(D.TCTN -D.FCTN+1)), 0) S19, NVL(SUM(D.S20*(D.TCTN -D.FCTN+1)), 0) S20 FROM WPL_DTL D, WPL_MST M , EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NOT NULL AND D.HIT_NO IS NOT NULL AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' GROUP BY M.PONO, 'BB' , 'TOTAL', D.HIT_TYPE, D.HIT_NO UNION ALL SELECT M.PONO, 'BB' O, 'TOTAL' TTYPE, S.HIT_TYPE, S.HIT_NO, SYSDATE, NVL(SUM(S.S1), 0) S1, NVL(SUM(S.S2), 0) S2, NVL(SUM(S.S3), 0) S3, NVL(SUM(S.S4), 0) S4, NVL(SUM(S.S5), 0) S5, NVL(SUM(S.S6), 0) S6, NVL(SUM(S.S7), 0) S7, NVL(SUM(S.S8), 0) S8, NVL(SUM(S.S9), 0) S9, NVL(SUM(S.S10), 0) S10, NVL(SUM(S.S11), 0) S11, NVL(SUM(S.S12), 0) S12, NVL(SUM(S.S13), 0) S13, NVL(SUM(S.S14), 0) S14, NVL(SUM(S.S15), 0) S15, NVL(SUM(S.S16), 0) S16, NVL(SUM(S.S17), 0) S17, NVL(SUM(S.S18), 0) S18, NVL(SUM(S.S19), 0) S19, NVL(SUM(S.S20), 0) S20 FROM WPL_MST M, WPL_DTL D, WPL_SPLIT S, EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO=D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NULL AND D.HIT_NO IS NULL AND D.PK=S.FK AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' AND S.HIT_TYPE IS NOT NULL AND S.HIT_NO IS NOT NULL GROUP BY M.PONO, 'BB' , 'TOTAL', S.HIT_TYPE, S.HIT_NO -- END SHIPPED HITWISE TOTAL ------------------------------- ) GROUP BY PONO , O , TTYPE , HIT_TYPE , HIT_NO , SYSDATE union all SELECT PONO, O, TTYPE, HIT_TYPE, HIT_NO, SYSDATE, NULL, NULL, NULL, SUM(S1) S1, SUM(S2) S2, SUM(S3) S3, SUM(S4) S4, SUM(S5) S5, SUM(S6) S6, SUM(S7) S7, SUM(S8) S8, SUM(S9) S9, SUM(S10) S10, SUM(S11) S11, SUM(S12) S12, SUM(S13) S13, SUM(S14) S14, SUM(S15) S15, SUM(S16) S16, SUM(S17) S17, SUM(S18) S18, SUM(S19) S19, SUM(S20) S20 FROM ( SELECT M.PONO, 'BBBBB' O, 'RATIO BALANCE (STOCK)' TTYPE, D.HIT_TYPE, D.HIT_NO, SYSDATE, NVL(SUM(D.S1*(D.TCTN -D.FCTN+1)), 0) S 1, NVL(SUM(D.S2*(D.TCTN -D.FCTN+1)), 0) S2, NVL(SUM(D.S3*(D.TCTN -D.FCTN+1)), 0) S3, NVL(SUM(D.S4*(D.TCTN -D.FCTN+1)), 0) S4, NVL(SUM(D.S5*(D.TCTN -D.FCTN+1)), 0) S5, NVL(SUM(D.S6*(D.TCTN -D.FCTN+1)), 0) S6, NVL(SUM(D.S7*(D.TCTN -D.FCTN+1)), 0) S7, NVL(SUM(D.S8*(D.TCTN -D.FCTN+1)), 0) S8, NVL(SUM(D.S9*(D.TCTN -D.FCTN+1)), 0) S9, NVL(SUM(D.S10*(D.TCTN -D.FCTN+1)), 0) S10, NVL(SUM(D.S11*(D.TCTN -D.FCTN+1)), 0) S11, NVL(SUM(D.S12*(D.TCTN -D.FCTN+1)), 0) S12, NVL(SUM(D.S13*(D.TCTN -D.FCTN+1)), 0) S13, NVL(SUM(D.S14*(D.TCTN -D.FCTN+1)), 0) S14, NVL(SUM(D.S15*(D.TCTN -D.FCTN+1)), 0) S15, NVL(SUM(D.S16*(D.TCTN -D.FCTN+1)), 0) S16, NVL(SUM(D.S17*(D.TCTN -D.FCTN+1)), 0) S17, NVL(SUM(D.S18*(D.TCTN -D.FCTN+1)), 0) S18, NVL(SUM(D.S19*(D.TCTN -D.FCTN+1)), 0) S19, NVL(SUM(D.S20*(D.TCTN -D.FCTN+1)), 0) S20 FROM WPL_DTL D, WPL_MST M , EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NOT NULL AND D.HIT_N O IS NOT NULL AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO and d.hit_type='PREPACK' AND E.APPROVED=1 AND E.CANCEL_STATUS='N' GROUP BY M.PONO, 'BBBBB' , 'RATIO BALANCE (STOCK)', D.HIT_TYPE, D.HIT_NO UNION ALL SELECT M.PONO, 'BBBBB' O, 'RATIO BALANCE (STOCK)' TTYPE, S.HIT_TYPE, S.HIT_NO, SYSDATE, NVL(SUM(S.S1), 0) S1, NVL(SUM(S.S2), 0) S2, NVL(SUM(S.S3), 0) S3, NVL(SUM(S.S4), 0) S4, NVL(SUM(S.S5), 0) S5, NVL(SUM(S.S6), 0) S6, NVL(SUM(S.S7), 0) S7, NVL(SUM(S.S8), 0) S8, NVL(SUM(S.S9), 0) S9, NVL(SUM(S.S10), 0) S10, NVL(SUM(S.S11), 0) S11, NVL(SUM(S.S12), 0) S12, NVL(SUM(S.S13), 0) S13, NVL(SUM(S.S14), 0) S14, NVL(SUM(S.S15), 0) S15, NVL(SUM(S.S16), 0) S16, NVL(SUM(S.S17), 0) S17, NVL(SUM(S.S18), 0) S18, NVL(SUM(S.S19), 0) S19, NVL(SUM(S.S20), 0) S20 FROM WPL_MST M, WPL_DTL D, WPL_SPLIT S, EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO=D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NULL AND D.HIT_NO IS NULL AND D.PK=S.FK and s.hit_type='PREPACK' AND P.INV_NO= E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' AND S.HIT_TYPE IS NOT NULL AND S.HIT_NO IS NOT NULL GROUP BY M.PONO, 'BBBBB' , 'RATIO BALANCE (STOCK)', S.HIT_TYPE, S.HIT_NO union all ------------ SELECT PONO, O, TTYPE, HIT_TYPE, HIT_NO, SYSDATE, -TRUNC(NVL(SUM(S1)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S1, -TRUNC(NVL(SUM(S2)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S2, -TRUNC(NVL(SUM(S3)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S3, -TRUNC(NVL(SUM(S4)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S4, -TRUNC(NVL(SUM(S5)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S5, -TRUNC(NVL(SUM(S6)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S6, -TRUNC(NVL(SUM(S7)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S7, -TRUNC(NVL(SUM(S8)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S8, -TRUNC(NVL(SUM(S9)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S9, -TRUNC(NVL(SUM(S10)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S10, -TRUNC(NVL(SUM(S11)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S11, -TRUNC(NVL(SUM(S12)/ge t_qty_po(:PONO), 0))*get_qty_po(:PONO) S12, -TRUNC(NVL(SUM(S13)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S13, -TRUNC(NVL(SUM(S14)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S14, -TRUNC(NVL(SUM(S15)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S15, -TRUNC(NVL(SUM(S16)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S16, -TRUNC(NVL(SUM(S17)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S17, -TRUNC(NVL(SUM(S18)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S18, -TRUNC(NVL(SUM(S19)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S19, -TRUNC(NVL(SUM(S20)/get_qty_po(:PONO), 0))*get_qty_po(:PONO) S20 FROM ( SELECT M.PONO, 'BBBBB' O, 'RATIO BALANCE (STOCK)' TTYPE, D.HIT_TYPE, D.HIT_NO, SYSDATE, NVL(SUM(D.S1*(D.TCTN -D.FCTN+1)), 0) S1, NVL(SUM(D.S2*(D.TCTN -D.FCTN+1)), 0) S2, NVL(SUM(D.S3*(D.TCTN -D.FCTN+1)), 0) S3, NVL(SUM(D.S4*(D.TCTN -D.FCTN+1)), 0) S4, NVL(SUM(D.S5*(D.TCTN -D.FCTN+1)), 0) S5, NVL(SUM(D.S6*(D.TCTN -D.FCTN+1)), 0) S6, NVL(SUM(D.S7*(D.TCTN -D.FCTN+1)), 0) S7, NVL(SUM(D.S8*(D.TCTN -D.FCTN+1)) , 0) S8, NVL(SUM(D.S9*(D.TCTN -D.FCTN+1)), 0) S9, NVL(SUM(D.S10*(D.TCTN -D.FCTN+1)), 0) S10, NVL(SUM(D.S11*(D.TCTN -D.FCTN+1)), 0) S11, NVL(SUM(D.S12*(D.TCTN -D.FCTN+1)), 0) S12, NVL(SUM(D.S13*(D.TCTN -D.FCTN+1)), 0) S13, NVL(SUM(D.S14*(D.TCTN -D.FCTN+1)), 0) S14, NVL(SUM(D.S15*(D.TCTN -D.FCTN+1)), 0) S15, NVL(SUM(D.S16*(D.TCTN -D.FCTN+1)), 0) S16, NVL(SUM(D.S17*(D.TCTN -D.FCTN+1)), 0) S17, NVL(SUM(D.S18*(D.TCTN -D.FCTN+1)), 0) S18, NVL(SUM(D.S19*(D.TCTN -D.FCTN+1)), 0) S19, NVL(SUM(D.S20*(D.TCTN -D.FCTN+1)), 0) S20 FROM WPL_DTL D, WPL_MST M , EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NOT NULL AND D.HIT_NO IS NOT NULL AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO --and d.hit_type='PREPACK' AND E.APPROVED=1 AND E.CANCEL_STATUS='N' GROUP BY M.PONO, 'BBBBB' , 'RATIO BALANCE (STOCK)', D.HIT_TYPE, D.HIT_NO UNION ALL SELECT M.PONO, 'BBBBB' O, 'RATIO BALANCE (STOCK)' TTYPE, S.HIT_TYPE, S.HIT_NO, SYSDATE, NVL(SUM(S.S1), 0) S1, NVL(SUM(S.S2), 0) S2, NVL(SUM(S.S3), 0) S3, NVL(SUM(S.S4), 0) S4, NVL(SUM(S.S5), 0) S5, NVL(SUM(S.S6), 0) S6, NVL(SUM(S.S7), 0) S7, NVL(SUM(S.S8), 0) S8, NVL(SUM(S.S9), 0) S9, NVL(SUM(S.S10), 0) S10, NVL(SUM(S.S11), 0) S11, NVL(SUM(S.S12), 0) S12, NVL(SUM(S.S13), 0) S13, NVL(SUM(S.S14), 0) S14, NVL(SUM(S.S15), 0) S15, NVL(SUM(S.S16), 0) S16, NVL(SUM(S.S17), 0) S17, NVL(SUM(S.S18), 0) S18, NVL(SUM(S.S19), 0) S19, NVL(SUM(S.S20), 0) S20 FROM WPL_MST M, WPL_DTL D, WPL_SPLIT S, EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO=D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NULL AND D.HIT_NO IS NULL AND D.PK=S.FK AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO --and d.hit_type='PREPACK' AND E.APPROVED=1 AND E.CANCEL_STATUS='N' AND S.HIT_TYPE IS NOT NULL AND S.HIT_NO IS NOT NULL GROUP BY M.PONO, 'BBBBB' , 'RATIO BALANCE (STOCK)', S.HIT_TYPE, S.HIT_NO ) GROUP BY PONO, O, TTYPE, HIT_TYPE, HIT_NO, SYSDATE -------- /* SELECT PONO, 'BBBBB' O, 'RATIO BALANCE' TTYPE, HIT_TYPE, HIT_NO, SYSDATE , -SUM(S1/PACK_QTY)*get_qty_po(:PONO) S1, -SUM(S2/PACK_QTY)*get_qty_po(:PONO) S2, -SUM(S3/PACK_QTY)*get_qty_po(:PONO) S3, -SUM(S4/PACK_QTY)*get_qty_po(:PONO) S4, -SUM(S5/PACK_QTY)*get_qty_po(:PONO) S5, -SUM(S6/PACK_QTY)*get_qty_po(:PONO) S6, -SUM(S7/PACK_QTY)*get_qty_po(:PONO) S7, -SUM(S8/PACK_QTY)*get_qty_po(:PONO) S8, -SUM(S9/PACK_QTY)*get_qty_po(:PONO) S9, -SUM(S10/PACK_QTY)*get_qty_po(:PONO) S10, -SUM(S11/PACK_QTY)*get_qty_po(:PONO) S11, -SUM(S12/PACK_QTY)*get_qty_po(:PONO) S12, -SUM(S13/PACK_QTY)*get_qty_po(:PONO) S13, -SUM(S14/PACK_QTY)*get_qty_po(:PONO) S14, -SUM(S15/PACK_QTY)*get_qty_po(:PONO) S15, -SUM(S16/PACK_QTY)*get_qty_po(:PONO) S16, -SUM(S17/PACK_QTY)*get_qty_po(:PONO) S17, -SUM(S18/PACK_QTY)*get_qty_po(:PONO) S18, -SUM(S19/PACK_QTY)*get_qty_po(:PONO) S19, -SUM(S20/PACK_QTY)*get_qty_po(:PONO) S20 FROM PRODUCTION.KCL_PO_HITS WHERE PONO=:PONO AND HIT_TYPE='PREPACK' GROUP BY PONO, HIT_TYPE, hit_no */ ) GROUP BY PONO , O , TT YPE , HIT_TYPE , HIT_NO , SYSDATE union all SELECT PONO, 'BBBB' O, 'PREPACK AS PER TOTAL' TTYPE, HIT_TYPE, HIT_NO, SYSDATE , to_char((NVL(SUM(S1/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S2/PACK_QTY)*get_qty_po(:PONO), 0)+NVL(SUM(S3/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S4/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S5/PACK_QTY)*get_qty_po(:PONO), 0) + NVL(SUM(S6/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S7/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S8/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S9/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S10/PACK_QTY)*get_qty_po(:PONO), 0) + NVL(SUM(S11/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S12/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S13/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S14/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S15/PACK_QTY)*get_qty_po(:PONO), 0) + NVL(SUM(S16/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S17/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S18/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S19/PACK_QTY)*get_qty_po(:PONO), 0) +NVL(SUM(S20/P ACK_QTY)*get_qty_po(:PONO), 0) )/(NVL(SUM(S1/PACK_QTY), 0)+NVL(SUM(S2/PACK_QTY), 0)+NVL(SUM(S3/PACK_QTY), 0) +NVL(SUM(S4/PACK_QTY), 0)+NVL(SUM(S5/PACK_QTY), 0)+ NVL(SUM(S6/PACK_QTY), 0)+NVL(SUM(S7/PACK_QTY), 0)+NVL(SUM(S8/PACK_QTY), 0)+NVL(SUM(S9/PACK_QTY), 0)+NVL(SUM(S10/PACK_QTY), 0)+ NVL(SUM(S11/PACK_QTY), 0)+NVL(SUM(S12/PACK_QTY), 0)+NVL(SUM(S13/PACK_QTY), 0)+NVL(SUM(S14/PACK_QTY), 0)+ NVL(SUM(S15/PACK_QTY), 0) + NVL(SUM(S16/PACK_QTY), 0) +NVL(SUM(S17/PACK_QTY), 0)+NVL(SUM(S18/PACK_QTY), 0)+NVL(SUM(S19/PACK_QTY), 0)+NVL(SUM(S20/PACK_QTY), 0) )) SHIPMODE, 'PACKED QTY' MANUL_INV_NO, NULL ETA_DATE, SUM(S1/PACK_QTY)*get_qty_po(:PONO) S1, SUM(S2/PACK_QTY)*get_qty_po(:PONO) S2, SUM(S3/PACK_QTY)*get_qty_po(:PONO) S3, SUM(S4/PACK_QTY)*get_qty_po(:PONO) S4, SUM(S5/PACK_QTY)*get_qty_po(:PONO) S5, SUM(S6/PACK_QTY)*get_qty_po(:PONO) S6, SUM(S7/PACK_QTY)*get_qty_po(:PONO) S7, SUM(S8/PACK_QTY)*get_qty_po(:PONO) S8, SUM(S9/PACK_QTY)*get_qty_po(:PONO) S9, SUM(S10/PACK_QTY)*get_qty_po(:PONO) S10 , SUM(S11/PACK_QTY)*get_qty_po(:PONO) S11, SUM(S12/PACK_QTY)*get_qty_po(:PONO) S12, SUM(S13/PACK_QTY)*get_qty_po(:PONO) S13, SUM(S14/PACK_QTY)*get_qty_po(:PONO) S14, SUM(S15/PACK_QTY)*get_qty_po(:PONO) S15, SUM(S16/PACK_QTY)*get_qty_po(:PONO) S16, SUM(S17/PACK_QTY)*get_qty_po(:PONO) S17, SUM(S18/PACK_QTY)*get_qty_po(:PONO) S18, SUM(S19/PACK_QTY)*get_qty_po(:PONO) S19, SUM(S20/PACK_QTY)*get_qty_po(:PONO) S20 FROM PRODUCTION.KCL_PO_HITS WHERE PONO = : PONO AND HIT_TYPE = 'PREPACK' GROUP BY PONO , HIT_TYPE , hit_no UNION ALL SELECT PONO, 'C' O, 'BALANCE TO SHIP' TTYPE, HIT_TYPE, HIT_NO, SYSDATE , NULL SHIPMODE, NULL MANUL_INV_NO, NULL ETA_DATE, SUM(S1) S1, SUM(S2) S2, SUM(S3) S3, SUM(S4) S4, SUM(S5) S5, SUM(S6) S6, SUM(S7) S7, SUM(S8) S8, SUM(S9) S9, SUM(S10) S10, SUM(S11) S11, SUM(S12) S12, SUM(S13) S13, SUM(S14) S14, SUM(S15) S15, SUM(S16) S16, SUM(S17) S17, SUM(S18) S18, SUM(S19) S19, SUM(S20) S20 FROM ( SELECT PONO, HIT_TYPE, HIT_NO, -S1 S1, -S2 S2, -S3 S3, -S4 S4, -S5 S5, -S 6 S6, -S7 S7, -S8 S8, -S9 S9, -S10 S10, -S11 S11, -S12 S12, -S13 S13, -S14 S14, -S15 S15, -S16 S16, -S17 S17, -S18 S18, -S19 S19, -S20 S20 FROM PRODUCTION.KCL_PO_HITS WHERE PONO=:PONO UNION ALL SELECT M.PONO, D.HIT_TYPE, D.HIT_NO, NVL(SUM(D.S1*(D.TCTN -D.FCTN+1)), 0) S1, NVL(SUM(D.S2*(D.TCTN -D.FCTN+1)), 0) S2, NVL(SUM(D.S3*(D.TCTN -D.FCTN+1)), 0) S3, NVL(SUM(D.S4*(D.TCTN -D.FCTN+1)), 0) S4, NVL(SUM(D.S5*(D.TCTN -D.FCTN+1)), 0) S5, NVL(SUM(D.S6*(D.TCTN -D.FCTN+1)), 0) S6, NVL(SUM(D.S7*(D.TCTN -D.FCTN+1)), 0) S7, NVL(SUM(D.S8*(D.TCTN -D.FCTN+1)), 0) S8, NVL(SUM(D.S9*(D.TCTN -D.FCTN+1)), 0) S9, NVL(SUM(D.S10*(D.TCTN -D.FCTN+1)), 0) S10, NVL(SUM(D.S11*(D.TCTN -D.FCTN+1)), 0) S11, NVL(SUM(D.S12*(D.TCTN -D.FCTN+1)), 0) S12, NVL(SUM(D.S13*(D.TCTN -D.FCTN+1)), 0) S13, NVL(SUM(D.S14*(D.TCTN -D.FCTN+1)), 0) S14, NVL(SUM(D.S15*(D.TCTN -D.FCTN+1)), 0) S15, NVL(SUM(D.S16*(D.TCTN -D.FCTN+1)), 0) S16, NVL(SUM(D.S17*(D.TCTN -D.FCTN+1)), 0) S17, NVL(SUM(D.S18*(D.TCT N -D.FCTN+1)), 0) S18, NVL(SUM(D.S19*(D.TCTN -D.FCTN+1)), 0) S19, NVL(SUM(D.S20*(D.TCTN -D.FCTN+1)), 0) S20 FROM WPL_DTL D, WPL_MST M, EXPINV_MST E, EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NOT NULL AND D.HIT_NO IS NOT NULL AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' GROUP BY M.PONO, D.HIT_TYPE, D.HIT_NO UNION ALL SELECT M.PONO, S.HIT_TYPE, S.HIT_NO, NVL(SUM(S.S1), 0) S1, NVL(SUM(S.S2), 0) S2, NVL(SUM(S.S3), 0) S3, NVL(SUM(S.S4), 0) S4, NVL(SUM(S.S5), 0) S5, NVL(SUM(S.S6), 0) S6, NVL(SUM(S.S7), 0) S7, NVL(SUM(S.S8), 0) S8, NVL(SUM(S.S9), 0) S9, NVL(SUM(S.S10), 0) S10, NVL(SUM(S.S11), 0) S11, NVL(SUM(S.S12), 0) S12, NVL(SUM(S.S13), 0) S13, NVL(SUM(S.S14), 0) S14, NVL(SUM(S.S15), 0) S15, NVL(SUM(S.S16), 0) S16, NVL(SUM(S.S17), 0) S17, NVL(SUM(S.S18), 0) S18, NVL(SUM(S.S19), 0) S19, NVL(SUM(S.S20), 0) S20 FROM WPL_MST M, WPL_DTL D, WPL_SPLIT S, EXPINV_MST E, EXPINV_DTL_P L P WHERE M.PL_NO=D.PL_NO AND M.PONO=:PONO AND M.PACK_TYPE='WP' AND D.HIT_TYPE IS NULL AND D.HIT_NO IS NULL AND D.PK=S.FK AND P.INV_NO=E.INV_NO AND P.PL_NO=M.PL_NO AND E.APPROVED=1 AND E.CANCEL_STATUS='N' AND S.HIT_TYPE IS NOT NULL AND S.HIT_NO IS NOT NULL GROUP BY M.PONO, S.HIT_TYPE, S.HIT_NO ) HIT_BAL GROUP BY PONO , 'BALANCE TO SHIP' , HIT_TYPE , HIT_NO , SYSDATE , '0' , '0' , '0' ORDER BY 1 ASC, 4 DESC, 5 ASC , HIT_TYPE DESC , HIT_NO , O ASC
1fj9bs9ng5mbu	SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), 0), NVL(SUM(C2), 0) FROM (SELECT /*+ NO_PARALLEL("MLOG$_PRODUCTION_ACHIEVEME") FULL("MLOG$_PRODUCTION_ACHIEVEME") NO_PARALLEL_INDEX("MLOG$_PRODUCTION_ACHIEVEME") */ 1 AS C1, 1 AS C2 FROM "PRODUCTION"."MLOG$_PRODUCTION_ACHIEVEME" SAMPLE BLOCK (0.007245 , 1) SEED (1) "MLOG$_PRODUCTION_ACHIEVEME") SAMPLESUB
1t8bh6fd2yug3	SELECT DISTINCT R.RATE FROM PRODUCTION.RES_WAGES_PLANOPR R WHERE R.PLANNO = :B2 AND R.OPERATION_ID=:B1
1w12wdb3vzc9h	select /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version) from idl_sb4$ where obj#=:1 and version > 0 and version<=:2 and (part=0 or part=2) and piece#=0
1ytt2nppswspc	select /*+ NO_CPU_COSTING */ MM.A, mm.col, mm.ACT_SIZE, mm.REQ_QTY, MM.TO_CUT_PCS TO_CUT_PC, (MM.TO_CUT_PCS-ab.qty1) RJ_QTY, ab.qty1-NVL(UA.MISSED_QTY, 0) QTY1, nvl(S.S_QTY, 0) S_QTY, NVL(UA.MISSED_QTY, 0) MISS_QTY, round(mm.REQ_QTY + (mm.REQ_QTY*max(tp.waste)/100), 0) req_2, Z.REJ_QTY, ST_QTY, s.cut_status, s.ind_status, s.stit_status, s.plan_status, nvl(WR.WHQTY, 0)whqty, nvl(SR.WRQTY, 0)wrqty, (nvl(WR.WHQTY, 0)-nvl(SR.WRQTY, 0))netwhqty from LS_ACT_CUT_PCS_VIEW1 MM, tblplanorder tp, plan_status s, ( select m.planno, d.g_size, m.garment_id , NVL(sum(d.qty), 0) QTY1, D.HITID from stit_rec_issue_m m, stit_rec_issue_d d where d.doc_id=m.doc_id and m.document_type='STR' and m.planno=:plan AND D.HITID=:P_HIT and d.status=0 group by m.planno, d.g_size, m.garment_id, D.HITID ) ab , ( select V.COL, t.plan_no, t.g_size, v.garment_id, count(t.g_size) MISSED_Qty, V.HITID from missed_gmt_id t, LS_act_cut_pcs_view1 v where t.plan_no = :plan AND V.HITID=:P_HIT AND v.PLAN_NO=t.plan_no and V. ACT_SIZE=T.G_SIZE group by t.plan_no, t.g_size, V.COL, v.garment_id, V.HITID ORDER BY V.COL )UA, ( select v.planno, v.g_size, nvl(sum(v.rej_qty), 0) rej_qty from LS_cut_stch_iss_bal_v v where v.planno=:plan AND V.HITID=:P_HIT group by v.planno, v.g_size ) z , ( select --t.ACT_SIZE COL, v.s col, round(sum(v.s1)/ nvl(GET_PLAN_COUNTGMT(v.plan_no), 1), 0) S_QTY, V.HIT_ID from LS_SHIP_SIZE_VIEW v /*, act_cut_pcs_view t*/ where --t.PLAN_NO=v.plan_no -- and v.plan_no= :PLAN AND V.HIT_ID=:P_HIT --and t.COL=v.S group by v.s, v.plan_no, V.HIT_ID--t.ACT_SIZE order by v.S ) S, ( SELECT T.ACT_SIZE COL, T.GARMENT_ID, SUM(V.QTY) WHQTY, T.HITID FROM LS_STITCH_RECIVE_WHAREHOUSE V, LS_ACT_CUT_PCS_VIEW1 T WHERE T.PLAN_NO=V.PLANNO AND T.PLAN_NO= :PLAN AND V.HITID=:P_HIT AND V.HITID=T.HITID AND T.COL=V.COL_SIZE and v.garment_id(+)=t.garment_id GROUP BY T.ACT_SIZE, V.COL_SIZE, T.GARMENT_ID, T.HITID HAVING SUM(V.QTY)>0 ORDER BY V.COL_SIZE ) WR, ( select d.g_size COL, v.garment_id, SUM(d.qty)WRQTY, D. HITID from stit_rec_issue_m m, stit_rec_issue_d d, LS_ACT_CUT_PCS_VIEW1 v where m.document_type='SRW' and m.doc_id=d.doc_id and m.planno=:PLAN and v.PLAN_NO=m.planno and v.COL=d.col_size and m.garment_id=v.garment_id AND D.HITID=:P_HIT AND D.HITID=V.HITID group by d.g_size , v.GARMENT_ID, D.HITID, d.col_size HAVING SUM(d.QTY)>0 ORDER BY d.col_size )SR, ( select d.g_size, m.garment_id, sum(d.stitched_qty) ST_QTY, D.HITID from cut_suply_bundl_m m, cut_suply_bundl d where d.doc_id=m.doc_id and d.ent_type='IITS' and m.planno=:PLAN AND D.HITID=:P_HIT and d.status=0 and d.stitched_qty is not null group by m.planno, d.g_size, m.garment_id, D.HITID, d.col_size order by d.col_size ) h where tp.plan_no =MM.plan_no AND MM.PLAN_NO = :PLAN AND MM.HITID=:P_HIT and ab.g_size(+)=mm.ACT_SIZE AND UA.G_SIZE(+)=mm.ACT_SIZE and z.g_size(+)=mm.ACT_SIZE and S.COL(+)=mM.COL and h.g_size(+)=mM.act_size and wr.col(+)=mM.act_size and sr.col(+)=mM.act_size --AND MM.REQ_QTY>0 and tp.waste is not null and m m.garment_id=ab.garment_id(+) and mm.garment_id=ua.garment_id(+) and mm.garment_id=h.garment_id(+) and mm.garment_id=sr.garment_id(+) and mm.garment_id=wr.garment_id(+) and mm.plan_no=s.plan_no(+) group by mm.col, MM.PLAN_NO, mm.ACT_SIZE, mm.REQ_QTY, ab.qty1, rej_qty, S.S_QTY, MM.TO_CUT_PCS, ST_QTY, MISSED_QTY, MM.A , s.cut_status, s.ind_status, s.stit_status, s.plan_status, WR.WHQTY, SR.WRQTY, MM.HITID Order by 1
228ak5wrhrzt8	SELECT ITEM_DESC, ITEM_CODE, UNIT_CODE, NVL(SUM(DECODE(D.ENTRYTYPE, 'RE', 1, 'IR', 1, 'SR', 1, 'TF', 1, 'RR', -1, 'IS', -1, 'SP', -1, 'TR', -1, 0) * QTY), 0) BQTY FROM ITEM I, STORE_DETAIL D, STORE_MASTER M WHERE M.SRNO=D.SRNO AND I.ITEM_CODE = D.ITEMCODE (+) AND I.SUB_CODE > 2100 AND D.CCODE = :1 AND D.ENTRYTYPE IN ('RE', 'IR', 'SR', 'TF', 'RR', 'IS', 'SP', 'TR') AND M.SUBSTOREID=:2 GROUP BY ITEM_DESC, ITEM_CODE, UNIT_CODE ORDER BY 1
2gfstk6ra0b71	SELECT CCODE_VALIDATION(UNIT) FROM PRODUCTION.TBLPLANSHEET WHERE PLAN_NO = :b1
2jzkmzmzxza9p	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.yarn_bag_stk_loc'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2q4xbuu7qhbd9	SELECT CASE WHEN :B7 =0 THEN NVL((((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_WASTE(:B5 , :B3 , :B2 ))*100)* KNT_YARN_RATE(:B5 , :B3 , :B2 )), 0) ELSE NVL(((((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_WASTE(:B5 , :B3 , :B2 ))*100)/KNT_YDY_WASTE(:B5 , :B3 , :B2 )*100)) * KNT_YARN_RATE(:B5 , :B3 , :B2 ), 0) END + NVL((((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_WASTE(:B5 , :B3 , :B2 ))*100)* KNT_YDY_RATE(:B5 , :B3 , :B2 )), 0)+ CASE WHEN :B6 =22 THEN NVL((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_CONSUMPTION(:B5 , :B3 , :B2 )*KNT_KNT_RATE(:B5 , :B3 , :B2 ) ), 0) WHEN :B6 =2 THEN DECODE(KNT_KNT_OPR_VAL(:B2 , 'OPR'), 'D', (STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 )*100)*(KNT_KNT_OPR_VAL(:B2 , 'CON')/KNT_KNT_OPR_VAL(:B2 , 'VAL'))*KNT_KNT_RATE(:B5 , :B3 , :B2 ), 'M', (STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 )*100)*KNT_KNT_OPR_VAL(:B2 , 'CON')*KNT_KNT_RATE(:B5 , :B3 , :B2 )) ELSE NVL((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)*KNT_KNT_RATE(:B5 , :B3 , :B2 ) ), 0) END + NVL((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)*DYE_DYEING_RATE(:B5 , :B3 , :B2 , :B1 )), 0)+ NVL((STK*PRT_PRINT_RATE(:B5 , :B3 , :B2 , :B1 )), 0) + NVL(STK*FIN_FINISH_RATE(:B5 , :B3 , :B2 , :B1 ), 0) FROM ( SELECT NVL(SUM(B.NW_IN), 0) STK FROM FAB_SR_MAST A , FAB_SR_DTL B WHERE A.SUP_REC_NO = B.SUP_REC_NO AND A.STOCK_TYPE IN ('FFB', 'FFA') AND A.CCODE = :B5 AND A.SUP_TARGET='RECEIVED' AND TO_DATE(A.ENTRY_DATE, 'DD-MM-YY')<= TO_DATE(:B4 , 'DD-MM-YY') AND PLANNO=:B3 AND FABRIC_CODE=:B2 AND COLOR=:B1 )
2xbwahn0u2umy	select max(bitand(nvl(option$, 0), 17)) from sysauth$ auth where privilege#=:1 connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:2 and privilege#>0 and privilege# in ( 2, 774, 778, 781, 783, 787, 789, 790, 794, 798, 801, 804, 808, 810, 816, 827, 828, 833, 834, 837 )) or (grantee#=1 and privilege#>0) group by privilege#
2zwn3h2hr377k	SELECT SUM(VALUE)/ SUM(STKKG) FROM ( SELECT A.CCODE, B.PLANNO, B.FABRIC_CODE, GET_FABRIC(B.FABRIC_CODE) FABRUC, B.COLOR, NVL(SUM(B.NW_IN), 0) STK , PRODUCTION.FINISH_FABRIC_REC(A.CCODE, B.PLANNO, B.FABRIC_CODE, B.COLOR, SYSDATE) VALUE, PRODUCTION.FINISH_FABRIC_REC(A.CCODE, B.PLANNO, B.FABRIC_CODE, B.COLOR, SYSDATE) /NVL(SUM(B.NW_IN), 0) PKGRATE , P.UNIT_CODE, DECODE(P.UNIT_CODE, 1, NVL(SUM(B.NW_IN), 0), 0) STKKG FROM FAB_SR_MAST A , FAB_SR_DTL B, TBLPLAN_CUT_DYE_KNT P WHERE A.SUP_REC_NO = B.SUP_REC_NO AND A.STOCK_TYPE IN ('FFB', 'FFA') AND A.CCODE = 9 AND A.SUP_TARGET='RECEIVED' AND TO_DATE(A.ENTRY_DATE, 'DD-MM-YY')<= SYSDATE AND B.PLANNO=:B1 AND B.PLANNO=P.PLAN_NO AND B.FABRIC_CODE=P.FABRIC_CODE AND B.COLOR=P.COLOR GROUP BY A.CCODE, B.PLANNO, B.FABRIC_CODE, B.COLOR, P.UNIT_CODE )
38vxaybzk778b	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.wages_sheet_mv'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
39m4sx9k63ba2	獥汥捴 ⨫⁩湤數⡩摬彵戲␠楟楤江畢㈱⤠⬪⼠灩散攣ⱬ敮杴栬灩散攠晲潭⁩摬彵戲␠睨敲攠潢樣㴺ㄠ慮搠灡牴㴺㈠慮搠癥牳楯渽㨳牤敲⁢礠灩散攣
42w5jvwyztq0h	SELECT NVL(GET_PLAN_PO_QTY(:B2 , :B1 ), 0) FROM DUAL
4uw118z2skgz1	SELECT WM_CONCAT(PROCESS_NAME) FROM ( SELECT DISTINCT P.PROCESS_NAME, FR.ORD FROM RND_SR_DTL D, PRODUCTION.SD_FINISH_ROUT FR, PRODUCTION.FINISH_ROUT P WHERE D.SUP_REC_NO=:B2 AND D.PK=FR.PK AND D.PK=:B1 AND FR.PROCESS_ID=P.PROCESS_ID ORDER BY ORD )
56yz6gvp45yh8	select distinct cus.cus_name as cust_name, asz.acc_desc as cust_account, s.style_no, s.cus_id, s.account_no, s.story_id, s.user_name, sc.color_id, tpc.color_desc color, decode(sc.sample_of, 'C', 'Customer', 'K', 'Klash', null) sample_of, cm.pat_id, cm.cut_id, nvl(pm.stitch_pcs, 1) stitch_pcs, refc.demandno, upper(pm.pat_name) patmaster, upper(lm.name) layman, s.orderid, get_rnd_cost_dem.get_yarn_cost(refc.demandno) yarn_cost, get_rnd_cost_dem.get_yarn_dye_cost(refc.demandno) yarn_dye_cost, get_rnd_cost_dem.get_knit_cost(refc.demandno) knit_cost, get_rnd_cost_dem.get_fabric_cost(refc.demandno) fabric_cost from sample s, sample_color sc, smp_cut_m cm, smp_cut_d cd, smp_pack_m pm, smp_ref_card refc, smp_patmaster pm, smp_laymaster lm, customer cus, acc_size asz, tblplan_color tpc where s.style_no = sc.style_no and cm.pkid = cd.fkid and cm.pat_id = pm.pat_id and cm.cut_id = lm.id and sc.co_code = tpc.cno and s.cus_id = cus.cus_id and s.account_no = asz.acc_id a nd cus.cus_id = asz.cus_id and sc.color_id = cm.colorid (+) and sc.style_no = cm.style (+) and sc.color_id = pm.colorid (+) and sc.style_no = pm.style (+) and sc.color_id = refc.colorid (+) and sc.style_no = refc.style (+) and sc.sample_of is not null and s.style_no like : p_style || '%' ORDER BY 7 ASC, 1 ASC, 2 ASC, 15 ASC, 16 ASC, 10 ASC, 3 ASC , s.user_name , 1 , 2 , 3
5n4u7kgq4hwgm	INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."MV_SHIPPING" select t.ccode, c.c_name, s.plan_no, 'BY- ' || e.ship_mode ship_mode, e.inv_date ship_date, t.pono, t.pl_no, trunc(t.pl_date) PL_DATE, m.style, nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) CMT_RATE, e.inv_no, e.inv_no_m, GetPL_Qty_PCS(t.pl_no) PCS, GetPL_Qty_PCS(t.pl_no)*nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) AMOUNT, get_cmt_contract_no(t.ccode, s.plan_no, g.garment_id)contract_no , g.garment_id , t.po_close from wpl_mst t, tblplanorder s, kcl_po_main m, expinv_mst e, dye.cdtl c, expinv_dtl_pl ed, tblplanpics g where t.pack_type = 'WP' and s.order_no = t.pono and e.inv_no = ed.inv_no and ed.pl_no = t.pl_no and m.pono = s.order_no AND E.CANCEL_STATUS='N' and e.approved=1 and g.plan_no=s.plan_no and t.ccode=c.c_code --and s.plan_no LIKE NVL(:planno, '%') --and t.pl_no not in (select r.pl_no from expsal_inv r) -- and trunc(e.inv_date) between nvl(:FDATE , to_date(sysdate-10000, 'DD-MM-RRRR')) AND nvl(:TDATE , to_date(sysdate, 'DD-MM-RRRR')) --and t.ccode=decode(:P_cCODE, 4, 15, NULL, T.CCODE, :P_CCODE) union all select t.ccode, c.c_name, s.plan_no, 'BY- ' || e.ship_mode ship_mode, e.inv_date ship_date, t.pono, t.pl_no, trunc(t.pl_date) PL_DATE, m.style, nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) CMT_RATE, e.inv_no, e.inv_no_m, PL.TOTAL_QTY PCS , PL.TOTAL_QTY*nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) AMOUNT, get_cmt_contract_no(t.ccode, s.plan_no, g.garment_id)contract_no , g.garment_id, t.po_close from wpl_mst t, wpl_dtl_aeopo pl, tblplanorder s, kcl_po_main m, expinv_mst e, dye.cdtl c, expinv_dtl_pl ed, tblplanpics g where t.pack_type = 'WP' and s.order_no = pl.pono and e.inv_no = ed.inv_no and ed.pl_no = t.pl_no and m.pono = s.order_no AND E.CANCEL_STATUS='N' -- and t.unit_12 LIKE NVL(:unit_12, '%') --and c.c_code = e.ccode and e.approved=1 and t.ccode=c.c_code --and s.plan_no LIKE NVL( :planno, '%') and pl.pl_no=t.pl_no and g.plan_no=s.plan_no --and t.pl_no not in (select r.pl_no from expsal_inv r) -- and trunc(e.inv_date) between nvl(:FDATE , to_date(sysdate-10000, 'DD-MM-RRRR')) AND nvl(:TDATE , to_date(sysdate, 'DD-MM-RRRR')) --and t.ccode=decode(:P_CCODE, 4, 15, NULL, T.CCODE, :P_CCODE) union all select m.ccode, c.c_name, m.plan_no, 'LOCAL' ship_mode, m.cdate ship_date, ' ' pono, ' ' pl_no, m.cdate PL_DATE, ' ' style, nvl(get_cmt_rate(m.ccode, m.plan_no, m.gmt_id), 0) CMT_RATE, 0 inv_no, ' ' inv_no_m, m.plan_qty PCS , m.plan_qty*nvl(get_cmt_rate(m.ccode, m.plan_no, m.gmt_id), 0) AMOUNT, get_cmt_contract_no(m.ccode, m.plan_no, m.gmt_id)contract_no , m.gmt_id garment_id, ' 'po_close from tblcontractmast m, dye.cdtl c where m.ccode=c.c_code and m.remarks='LOCALCMT' and m.sam_pcs is not null --and t.pl_no not in (select r.pl_no from expsal_inv r) -- and trunc(m.cdate) between nvl(:FDATE , to_date(sysdate-10000, 'DD-MM-RRRR')) AND nvl(:TDATE , to_d ate(sysdate, 'DD-MM-RRRR')) -- and m.ccode=decode(:P_CCODE, 4, 15, NULL, m.CCODE, :P_CCODE)
5p06akzdb4y5s	select log, oldest, oldest_pk, oldest_oid, oldest_new, youngest+1/86400, flag, yscn, oldest_seq, oscn, oscn_pk, oscn_oid, oscn_new, oscn_seq from sys.mlog$ where mowner = :1 and master = :2
5vfp7a4yfq4ud	獥汥捴ⁱ⹰污湟湯ⱱ⹣潬ⱱ⹳楺ⱱ⹯牤ⱳ畭⡱⹰潟煴礩灯影瑹ⱳ畭⡱⹰污湟煴礩⁰污湟煴礬焮捵瑟煴礬ੱ⹩湤影瑹ⱱ⹲敪彡畤琬焮獴影瑹ⱱ⹭楳影瑹ⱱ⹢慬彵湩琬焮睨影瑹ⱱ⹴牟煴礬焮獨影瑹ⱱ⹢慬彷栬ੱ⹣畴彳瑡瑵猬焮楮摟獴慴畳ⱱ⹳瑩瑟獴慴畳ⱱ⹰污湟獴慴畳Ⱐ獵洨焮汯损獡氩汯损獡氊੦牯洠⠊獥汥捴⹰污湟湯Ɐ⹯牤敲彮漬ਠ†††愮捯氬ਠ†††愮卩稬ਠ†††種潲搬ਠ†††獵洨種匱⤠偏影瑹Ⰺ†††⁳畭⡺⹓ㄩ‫⁲潵湤⡳畭⡺⹓ㄩ‪ 漮睡獴攩 ‱〰Ⱐ〩⁐污湟煴礬ਠ†††湶氨捴⹣畴影瑹Ⱐ〩⁣畴影瑹Ⰺ†††癬⡩湤⹩湤影瑹Ⱐ〩⁩湤影瑹Ⰺ†††癬⡣琮捵瑟煴礬‰⤠ⴠ湶氨楮搮楮摟煴礬‰⤠剥機慵摴Ⰺ†††癬⡳琮獴影瑹Ⱐ〩⁳瑟煴礬ਠ†††湶氨浩献浩影瑹ⰰ⤠浩獟煴礬ਠ†††湶氨獴⹳瑟煴礬‰⤭湶氨睨⹷桟煴礬〩扡江畮楴Ⰺ†††癬⡷栮睨影瑹ⰰ⤠睨影瑹Ⰺ†††癬⡴牟睨⹴牟煴礬〩⁴牟煴礬ਠ†††獨⹳桟煴礬ਠ†††湶氨䱏䍓⹌佃当䅌ⰰ⤠汯损獡氬ਠ†††⡮癬⡷栮睨影瑹ⰰ⤫湶氨瑲彷栮瑲影瑹ⰰ⤩⵮癬⡳栮獨影瑹ⰰ⤭湶氨䱏䍓⹌佃当䅌ⰰ⤠扡江睨Ⰺ†††⁳⹣畴彳瑡瑵猬献楮摟獴慴畳ⱳ⹳瑩瑟獴慴畳ⱳ⹰污湟獴慴畳ਊ⁦牯洠正江灯彭慩渠洬慣损獩穥彶楥眠愬瑢汰污湯牤敲Ɒ污湟獴慴畳⁳Ⰺ⠊獥汥捴†灯湯Ⱨ慲楤Ᵽ潬Ɱ癬⡳畭⡳楺⤬〩⁳ㄬ牮牤⁦牯洠⠊卅䱅䍔⁴⹰潮漬琮条物搬䑅䍏䑅⡲測ㄬ❓ㄧⰲⰧ匲✬㌬❓㌧Ⱐ㐬❓㐧ⰵⰧ匵✬㘬❓㘧ⰷⰧ匷✬㠬❓㠧Ⱐ㤬❓㤧Ⰺ†††††††††††††㄰Ⱗ匱〧ⰱㄬ❓ㄱ✬ㄲⰧ匱㈧ⰱ㌬❓ㄳ✬ㄴⰧ匱㐧ⰱ㔬❓ㄵ✬ㄶⰧ匱㘧ⰱ㜬❓ㄷ✬ਠ††††††††††††‱㠬❓ㄸ✬ㄹⰧ匱㤧ⰲ〬❓㈰✊†††††††††††††⤠捯氬ਠ††††䑅䍏䑅⡲測†ㄬ匱ⰲⱓ㈬㌬匳ⰴⱓ㐬㔬匵ⰶⱓ㘬㜬匷ⰸⱓ㠬㤬匹ⰱ〬匱〬ㄱⱓㄱⰱ㈬匱㈬ㄳⱓㄳⰱ㐬匱㐬ㄵⱓㄵⰊ††††††††††‱㘬匱㘬ㄷⱓㄷⰱ㠬匱㠬ㄹⱓㄹⰲ〬匲《ਠ††††††††††⤠卩稬牮ਠ†⁆剏䴠†正江灯彨楴猠琬瑢汰污湯牤敲Ⰺ††††† 卅䱅䍔⁌䕖䕌⁲渊††††††䙒位†⁤畡氊†††††⁃低久䍔⁂夠䱅噅䰠㰽′〩ਠ††††⁷桥牥 ††††††漮灬慮彮漽㩐䱁上†††††慮搠漮潲摥牟湯㵴⹰潮漊††††† †††††††† ††††††††⁧牯異⁢礠灯湯Ⱨ慲楤Ᵽ潬Ⱳ渊⤠稬ਊ⡳敬散琠捤⹣潬彳楺攬捤⹣畴彳楺攬湶氨獵洨捤⹢摬影瑹⤬〩ⴊੳ畭⠊⡳敬散琠湶氨獵洨摤⹲数影瑹⤬〩†晲潭⁣畴彪扣慲摟洠浭Ᵽ畴彪扣慲摟摤搠摤੷桥牥⁤搮摯损楤㵭洮摯损楤੡湤 洮灬慮彮漽㩐䱁上慮搠摤⹰步祟牥昽捤⹰步礊慮搠摤⹣畴彳楺攠楳潴畬氊਩⤊ਠ捵瑟煴礠晲潭⁣畴彪扣慲摟洠捭Ᵽ畴彪扣慲摟摤搠捤੷桥牥⁣搮摯损楤㵣洮摯损楤੡湤⁣洮灬慮彮漽㩐䱁上慮搠捤⹣畴彳楺攠楳潴畬氊杲潵瀠批†捤⹣潬彳楺攬捤⹣畴彳楺攠⥣琬ਊਨ⁳敬散琠獤⹣潬彳楺攬獤⹧彳楺攬獵洨獤⹱瑹⤠楮摟煴礠晲潭⁳瑩瑟牥损楳獵敟搠獤ⱳ瑩瑟牥损楳獵敟洠浤੷桥牥搮摯损楤㵳搮摯损楤੡湤搮摯捵浥湴彴祰攽❓呒✊慮搠獤⹳瑡瑵猽《慮搠浤⹰污湮漽㩐䱁上杲潵瀠批†獤⹣潬彳楺攬獤⹧彳楺攊⥩湤Ⰺਨ獥汥捴⁢搮捯江獩穥Ɫ搮束獩穥Ɱ癬⡳畭⡢搮獴楴捨敤影瑹⤬〩⁳瑟煴礠晲潭⁣畴彳異汹形畮摬⁢搬捵瑟獵灬祟扵湤江洠浳੷桥牥献摯损楤㵢搮摯损楤੡湤献敮瑲祟瑹灥㴧䥉呓✊慮搠浳⹰污湮漽㩐䱁上杲潵瀠批⁢搮捯江獩穥Ɫ搮束獩穥਩⁳琬ਠⴭ睡牥桯畳攠獴慲琊⡳敬散琠捯氬湶氨獵洨獩稩ⰰ⤠睨影瑹⁦牯洠⠊卅䱅䍔⁄䕃佄䔨牮ⰱⰧ匱✬㈬❓㈧ⰳⰧ匳✬‴Ⱗ匴✬㔬❓㔧ⰶⰧ匶✬㜬❓㜧ⰸⰧ匸✬‹Ⱗ匹✬ਠ††††††††††††‱〬❓㄰✬ㄱⰧ匱ㄧⰱ㈬❓ㄲ✬ㄳⰧ匱㌧ⰱ㐬❓ㄴ✬ㄵⰧ匱㔧ⰱ㘬❓ㄶ✬ㄷⰧ匱㜧Ⰺ†††††††††††††ㄸⰧ匱㠧ⰱ㤬❓ㄹ✬㈰Ⱗ匲〧ਠ†††††††††††† ⁣潬Ⰺ††††⁄䕃佄䔨牮Ⱐ‱ⱓㄬ㈬匲ⰳⱓ㌬㐬匴ⰵⱓ㔬㘬匶ⰷⱓ㜬㠬匸ⰹⱓ㤬㄰ⱓ㄰ⰱㄬ匱ㄬㄲⱓㄲⰱ㌬匱㌬ㄴⱓㄴⰱ㔬匱㔬ਠ††††††††††ㄶⱓㄶⰱ㜬匱㜬ㄸⱓㄸⰱ㤬匱㤬㈰ⱓ㈰ਊ†††††††††† ⁓楺ਠ†⁆剏䴠†睡牥桯畳敟牥损搠琬睡牥桯畳敟牥挠漬ਠ†††††⡓䕌䕃吠䱅噅䰠牮ਠ†††††⁆剏䴠†摵慬ਠ†††††䍏乎䕃吠䉙⁌䕖䕌‼㴠㈰⤊†††††睨敲攠ਠ†††††⹰污湮漽㩐䱁上†††††慮搠漮摯损楤㵴⹤潣彩搊†††††慮搠漮摯捵浥湴彴祰攽❗剓✊††畮楯渠慬氊††ਠ†⁓䕌䕃吠䑅䍏䑅⡲測ㄬ❓ㄧⰲⰧ匲✬㌬❓㌧Ⱐ㐬❓㐧ⰵⰧ匵✬㘬❓㘧ⰷⰧ匷✬㠬❓㠧Ⱐ㤬❓㤧Ⰺ†††††††††††††㄰Ⱗ匱〧ⰱㄬ❓ㄱ✬ㄲⰧ匱㈧ⰱ㌬❓ㄳ✬ㄴⰧ匱㐧ⰱ㔬❓ㄵ✬ㄶⰧ匱㘧ⰱ㜬❓ㄷ✬ਠ††††††††††††‱㠬❓ㄸ✬ㄹⰧ匱㤧ⰲ〬❓㈰✊†††††††††††††⤠捯氬ਠ††††䑅䍏䑅⡲測†ㄬⵓㄬ㈬ⵓ㈬㌬ⵓ㌬㐬ⵓ㐬㔬ⵓ㔬㘬ⵓ㘬㜬ⵓ㜬㠬ⵓ㠬㤬ⵓ㤬㄰Ⱝ匱〬ㄱⰭ匱ㄬㄲⰭ匱㈬ㄳⰊ††††‭匱㌬ㄴⰭ匱㐬ㄵⰭ匱㔬ㄶⰭ匱㘬ㄷⰭ匱㜬ㄸⰭ匱㠬ㄹⰭ匱㤬㈰Ⱝ匲《ਠ††††††††††⤠獩稊††䙒位†⁷慲敨潵獥彲散彤⁴ⱷ慲敨潵獥彲散Ⰺ††††† 卅䱅 䍔⁌䕖䕌⁲渊††††††䙒位†⁤畡氊†††††⁃低久䍔⁂夠䱅噅䰠㰽′〩ਠ††††⁷桥牥 ††††††漮灬慮湯㴺偌䅎ਠ††††⁡湤⹤潣彩搽琮摯损楤ਠ††††⁡湤⹤潣畭敮瑟瑹灥㴧坈匧†††ਠ†††††⤠ਠ††††††††ਠ††††††††杲潵瀠批⁣潬ਠ††††† 睨††‬ਭⴭ敮搠睡牥桯畳攊ਭⵓ瑡牴映卨楰ਊਨ卅䱅䍔⁄䕃佄䔨牮ⰱⰧ匱✬㈬❓㈧ⰳⰧ匳✬‴Ⱗ匴✬㔬❓㔧ⰶⰧ匶✬㜬❓㜧ⰸⰧ匸✬‹Ⱗ匹✬ਠ††††††††††††‱〬❓㄰✬ㄱⰧ匱ㄧⰱ㈬❓ㄲ✬ㄳⰧ匱㌧ⰱ㐬❓ㄴ✬ㄵⰧ匱㔧ⰱ㘬❓ㄶ✬ㄷⰧ匱㜧Ⰺ†††††††††††††ㄸⰧ匱㠧ⰱ㤬❓ㄹ✬㈰Ⱗ匲〧ਠ†††††††††††† ⁣潬Ⰺ††††⁄䕃佄䔨牮Ⱐ‱ⱳ畭⡓ㄩⰲⱳ畭⡓㈩ⰳⱳ畭⡓㌩ⰴⱳ畭⡓㐩ⰵⱳ畭⡓㔩Ⰺ††††‶ⱳ畭⡓㘩ⰷⱳ畭⡓㜩ⰸⱳ畭⡓㠩ⰹⱳ畭⡓㤩ⰱ〬獵洨匱〩ⰱㄬ獵洨匱ㄩⰱ㈊††††‬獵洨匱㈩ⰱ㌬獵洨匱㌩ⰱ㐬獵洨匱㐩ⰱ㔬獵洨匱㔩Ⰺ††††††††††‱㘬獵洨匱㘩ⰱ㜬獵洨匱㜩ⰱ㠬獵洨匱㠩ⰱ㤬獵洨匱㤩ⰲ〬獵洨匲〩ਊ†††††††††† ⁳桟煴礠晲潭 ਨ卅䱅䍔†⹰江湯Ⱐ洮灯湯Ⱐ洮捣潤攬ਠ††††††††††††††乖䰠⡓啍 搮猱‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㈠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㈬ਠ††††††††††††††乖䰠⡓啍 搮猳‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猳Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㐠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㐬ਠ††††††††††††††乖䰠⡓啍 搮猵‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猵Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㘠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㘬ਠ††††††††††††††乖䰠⡓啍 搮猷‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猷Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㠠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㠬ਠ††††††††††††††乖䰠⡓啍 搮猹‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猹Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㄰‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱〬ਠ††††††††††††††乖䰠⡓啍 搮猱ㄠ⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄱⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄲ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㈬ਠ††††††††††††††乖䰠⡓啍 搮猱㌠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄳⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄴ‪ 搮瑣瑮 ‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㐬ਠ††††††††††††††乖䰠⡓啍 搮猱㔠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄵⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄶ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㘬ਠ††††††††††††††乖䰠⡓啍 搮猱㜠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄷⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄸ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㠬ਠ††††††††††††††乖䰠⡓啍 搮猱㤠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄹⰊ††††††††††††††⁎噌 单䴠⡤⹳㈰‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猲《†††䙲潭†ਠ†††數灩浰⹷灬彭獴†††††洬ਠ†††數灩浰⹷灬彤瑬†††††搬ਠ†††灲潤畣瑩潮⹴扬灬慮潲摥爠灳Ⰺ†††⁥硰業瀮數灩湶彭獴†††⁥Ⰺ†††⁥硰業瀮數灩湶彤瑬彰氠†⁰ਠ坈䕒䔠洮灬彮漠㴠搮灬彮漊†⁁乄⹰慣歟瑹灥‽‧坐✊†⁁乄⹰潮漠㴠灳⹯牤敲彮漊†⁁乄⁰⹩湶彮漠㴠攮楮癟湯ਠ†䅎䐠攮捡湣敬彳瑡瑵猠㴠❎✊†⁁乄⹰慣歟瑹灥‽‧坐✊†⁁乄⁥⹡灰牯癥搠㴠ㄊ†⁡湤⹰江湯㵰⹰江湯ਠ††⁁乄⁰献灬慮彮漠㴺偌䅎ਠ䝒何倠䉙⹰江湯Ⱐ洮灯湯Ⱐ洮捣潤攊ੵ湩潮⁡汬ਊ卅䱅䍔†⹰江湯Ⱐ洮灯湯Ⱐ洮捣潤攬ਠ††††††††††††††乖䰠⡓啍 搮猱‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㈠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㈬ਠ††††††††††††††乖䰠⡓啍 搮猳‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猳Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㐠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㐬ਠ††††††††††††††乖䰠⡓啍 搮猵‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猵Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㘠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㘬ਠ††††††††††††††乖䰠⡓啍 搮猷‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猷Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㠠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㠬ਠ††††††††††††††乖䰠⡓啍 搮猹‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猹Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㄰‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱〬ਠ††††††††††††††乖䰠⡓啍 搮猱ㄠ⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄱⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄲ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㈬ਠ††††††††††††††乖䰠⡓啍 搮猱㌠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩 ⁳ㄳⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄴ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㐬ਠ††††††††††††††乖䰠⡓啍 搮猱㔠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄵⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄶ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㘬ਠ††††††††††††††乖䰠⡓啍 搮猱㜠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄷⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄸ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㠬ਠ††††††††††††††乖䰠⡓啍 搮猱㤠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄹⰊ††††††††††††††⁎噌 单䴠⡤⹳㈰‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猲《†††䙲潭†ਠ†††數灩浰⹷灬彭獴†††††洬ਠ†††數灩浰⹷灬彤瑬†††††搬ਠ†††灲潤畣瑩潮⹴扬灬慮潲摥爠灳Ⰺ†††⁥硰業瀮數灩湶彭獴†††⁥Ⰺ†††⁥硰業瀮數灩湶彤瑬彰氠†⁰ਠ坈䕒䔠洮灬彮漠㴠搮灬彮漊†⁁乄⹰慣歟瑹灥‽‧坐✊†⁁乄⁤⹰潮漱‽⁰献潲摥牟湯ਠ†䅎䐠瀮楮癟湯‽⁥⹩湶彮漊†⁁乄⁥⹣慮捥江獴慴畳‽‧丧ਠ†䅎䐠洮灡捫彴祰攠㴠❗倧ਠ†䅎䐠攮慰灲潶敤‽‱ਠ†慮搠洮灬彮漽瀮灬彮漊†††䅎䐠灳⹰污湟湯‽㩐䱁上⁇剏啐⁂夠洮灬彮漬⹰潮漬⹣捯摥ਊ畮楯渠慬氊ਊ††††††††† ††††††††††ਠ†††††††††‭ⴠ䙏删䕍䕒䥃䅎⁅䅇䰊獥汥捴⹰江湯Ⱐ搮灯湯Ⱐ洮捣潤攬ਠ†††乖䰨单䴨搮獉⤬‰⤠猱Ⰺ†††⁎噌⡓啍⡤⹳㈩Ⱐ〩⁳㈬ਠ†††乖䰨单䴨搮猳⤬‰⤠猳Ⰺ†††⁎噌⡓啍⡤⹳㐩Ⱐ〩⁳㐬ਠ†††乖䰨单䴨搮猵⤬‰⤠猵Ⰺ†††⁎噌⡓啍⡤⹳㘩Ⱐ〩⁳㘬ਠ†††乖䰨单䴨搮猷⤬‰⤠猷Ⰺ†††⁎噌⡓啍⡤⹳㠩Ⱐ〩⁳㠬ਠ†††乖䰨单䴨搮猹⤬‰⤠猹Ⰺ†††⁎噌⡓啍⡤⹳㄰⤬‰⤠猱〬ਠ†††乖䰨单䴨搮猱ㄩⰠ〩⁳ㄱⰊ†††⁎噌⡓啍⡤⹳ㄲ⤬‰⤠猱㈬ਠ†††乖䰨单䴨搮猱㌩Ⱐ〩⁳ㄳⰊ†††⁎噌⡓啍⡤⹳ㄴ⤬‰⤠猱㐬ਠ†††乖䰨单䴨搮猱㔩Ⱐ〩⁳ㄵⰊ†††⁎噌⡓啍⡤⹳ㄶ⤬‰⤠猱㘬ਠ†††乖䰨单䴨搮猱㜩Ⱐ〩⁳ㄷⰊ†††⁎噌⡓啍⡤⹳ㄸ⤬‰⤠猱㠬ਠ†††乖䰨单䴨搮猱㤩Ⱐ〩⁳ㄹⰊ†††⁎噌⡓啍⡤⹳㈰⤬‰⤠猲《ਠ⁦牯洠數灩浰⹷灬彭獴†††††洬ਠ†††坐䱟䑔䱟䅅佐传††††⁤Ⰺ†††⁰牯摵捴楯渮瑢汰污湯牤敲⁰猬ਠ†††數灩浰⹥硰楮癟浳琠†††攬ਠ†††數灩浰⹥硰楮癟摴江灬††瀊⁗䡅剅⹰江湯‽⁤⹰江湯ਠ†䅎䐠洮灡捫彴祰攠㴠❗倧ਠ†䅎䐠搮灯湯‽⁰献潲摥牟湯ਠ†䅎䐠瀮楮 癟湯‽⁥⹩湶彮漊†⁁乄⁥⹣慮捥江獴慴畳‽‧丧ਠ†䅎䐠洮灡捫彴祰攠㴠❗倧ਠ†䅎䐠攮慰灲潶敤‽‱ਠ†䅎䐠灳⹰污湟湯‽›偌䅎ਠ⁡湤⁰⹰江湯㵭⹰江湯ਠ䝒何倠䉙⹰江湯Ⱐ搮灯湯Ⱐ洮捣潤攊†ਠ⁵湩潮⁡汬 ਭⴭ䙯爠䵓†੓䕌䕃吠洮灬彮漬ਠ†††洮灯湯Ⰺ†††⹣捯摥Ⰺ†††⁎噌⡓啍⡤⹳ㄩⰠ〩⁳ㄬਠ†††乖䰨单䴨搮猲⤬‰⤠猲Ⰺ†††⁎噌⡓啍⡤⹳㌩Ⱐ〩⁳㌬ਠ†††乖䰨单䴨搮猴⤬‰⤠猴Ⰺ†††⁎噌⡓啍⡤⹳㔩Ⱐ〩⁳㔬ਠ†††乖䰨单䴨搮猶⤬‰⤠猶Ⰺ†††⁎噌⡓啍⡤⹳㜩Ⱐ〩⁳㜬ਠ†††乖䰨单䴨搮猸⤬‰⤠猸Ⰺ†††⁎噌⡓啍⡤⹳㤩Ⱐ〩⁳㤬ਠ†††乖䰨单䴨搮猱〩Ⱐ〩⁳㄰Ⰺ†††⁎噌⡓啍⡤⹳ㄱ⤬‰⤠猱ㄬਠ†††乖䰨单䴨搮猱㈩Ⱐ〩⁳ㄲⰊ†††⁎噌⡓啍⡤⹳ㄳ⤬‰⤠猱㌬ਠ†††乖䰨单䴨搮猱㐩Ⱐ〩⁳ㄴⰊ†††⁎噌⡓啍⡤⹳ㄵ⤬‰⤠猱㔬ਠ†††乖䰨单䴨搮猱㘩Ⱐ〩⁳ㄶⰊ†††⁎噌⡓啍⡤⹳ㄷ⤬‰⤠猱㜬ਠ†††乖䰨单䴨搮猱㠩Ⱐ〩⁳ㄸⰊ†††⁎噌⡓啍⡤⹳ㄹ⤬‰⤠猱㤬ਠ†††乖䰨单䴨搮猲〩Ⱐ〩⁳㈰ਊ†䙒位⁥硰業瀮睰江浳琠††††Ⰺ†††⁥硰業瀮睰江摴氠††††⁤Ⰺ†††⁰牯摵捴楯渮瑢汰污湯牤敲⁰猬ਠ†††數灩浰⹥硰楮癟浳琠†††攬ਠ†††數灩浰⹥硰楮癟摴江灬††瀊⁗䡅剅⹰江湯‽⁤⹰江湯ਠ†䅎䐠洮灡捫彴祰攠㴠❗倧ਠ†慮搠湶氨搮湥瑟睧琬‰⤠㸠《†⁡湤癬⡤⹧牯獳彷杴Ⱐ〩‾‰ਠ†† †⁡湤⹰潮漠㴠灳⹯牤敲彮漊†††ਠ†䅎䐠瀮楮癟湯‽⁥⹩湶彮漊†⁁乄⁥⹣慮捥江獴慴畳‽‧丧ਠ†䅎䐠洮灡捫彴祰攠㴠❗倧ਠ†䅎䐠攮慰灲潶敤‽‱ਠ†䅎䐠灳⹯牤敲彮漠㴠洮灯湯ਠ†䅎䐠瀮灬彮漠㴠洮灬彮漊†⁁乄⁰献灬慮彮漠㴠㩐䱁上⁇剏啐⁂夠洮灬彮漬⹰潮漬⹣捯摥਩Ⱘ卅䱅䍔⁌䕖䕌⁲渊††††††䙒位†⁤畡氊†††††⁃低久䍔⁂夠䱅噅䰠㰽′〩ਠ†††††ਠ†††杲潵瀠批⁲渠† 獨Ⰺਭⵥ湤⁓桩瀊ⴭⴭ獴慲琠汯捡氭ⴭਊ⡓䕌䕃吠䑅䍏䑅⡲測ㄬ❓ㄧⰲⰧ匲✬㌬❓㌧Ⱐ㐬❓㐧ⰵⰧ匵✬㘬❓㘧ⰷⰧ匷✬㠬❓㠧Ⱐ㤬❓㤧Ⰺ†††††††††††††㄰Ⱗ匱〧ⰱㄬ❓ㄱ✬ㄲⰧ匱㈧ⰱ㌬❓ㄳ✬ㄴⰧ匱㐧ⰱ㔬❓ㄵ✬ㄶⰧ匱㘧ⰱ㜬❓ㄷ✬ਠ††††††††††††‱㠬❓ㄸ✬ㄹⰧ匱㤧ⰲ〬❓㈰✊†††††††††††††⤠捯氬ਠ††††䑅䍏䑅⡲測†ㄬ獵洨匱⤬㈬獵洨匲⤬㌬獵洨匳⤬㐬獵洨匴⤬㔬獵洨匵⤬ਠ††††㘬獵洨匶⤬㜬獵洨匷⤬㠬獵洨匸⤬㤬獵洨匹⤬㄰ⱳ畭⡓㄰⤬ㄱⱳ畭⡓ㄱ⤬ㄲਠ††††ⱳ畭⡓ㄲ⤬ㄳⱳ畭⡓ㄳ⤬ㄴⱳ畭⡓ ㄴ⤬ㄵⱳ畭⡓ㄵ⤬ਠ††††††††††ㄶⱳ畭⡓ㄶ⤬ㄷⱳ畭⡓ㄷ⤬ㄸⱳ畭⡓ㄸ⤬ㄹⱳ畭⡓ㄹ⤬㈰ⱳ畭⡓㈰⤊ਠ††††††††††⤠䱏䍟十䰠晲潭 ਨ卅䱅䍔†⹰江湯Ⱐ洮灯湯Ⱐ洮捣潤攬ਠ††††††††††††††乖䰠⡓啍 搮猱‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㈠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㈬ਠ††††††††††††††乖䰠⡓啍 搮猳‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猳Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㐠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㐬ਠ††††††††††††††乖䰠⡓啍 搮猵‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猵Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㘠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㘬ਠ††††††††††††††乖䰠⡓啍 搮猷‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猷Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㠠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳㠬ਠ††††††††††††††乖䰠⡓啍 搮猹‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猹Ⰺ††††††††††††††⁎噌 单䴠⡤⹳㄰‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱〬ਠ††††††††††††††乖䰠⡓啍 搮猱ㄠ⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄱⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄲ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㈬ਠ††††††††††††††乖䰠⡓啍 搮猱㌠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄳⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄴ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㐬ਠ††††††††††††††乖䰠⡓啍 搮猱㔠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄵⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄶ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㘬ਠ††††††††††††††乖䰠⡓啍 搮猱㜠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄷⰊ††††††††††††††⁎噌 单䴠⡤⹳ㄸ‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猱㠬ਠ††††††††††††††乖䰠⡓啍 搮猱㤠⨠⡤⹴捴渠ⴠ搮晣瑮‫‱⤩Ⱐ〩⁳ㄹⰊ††††††††††††††⁎噌 单䴠⡤⹳㈰‪ 搮瑣瑮‭⁤⹦捴渠⬠ㄩ⤬‰⤠猲《†††䙲潭†ਠ†††數灩浰⹷灬彭獴†††††洬ਠ†††數灩浰⹷灬彤瑬†††††搬ਠ†††灲潤畣瑩潮⹴扬灬慮潲摥爠灳Ⱬ捬彰潟浡楮ਠ坈䕒䔠洮灬彮漠㴠搮灬彮漊慮搠欮灯湯㵰献潲摥牟湯੡湤⹰潮漽洮灯湯੡湤⹣畳彩搠楮⠴㌬㜵⤊†⁁乄⹰慣歟瑹灥‽‧坐✊†⁁乄⹰潮漠㴠灳⹯牤 敲彮漊†⁁乄⹰慣歟瑹灥‽‧坐✊†††䅎䐠灳⹰污湟湯‽㩐䱁上⁇剏啐⁂夠洮灬彮漬⹰潮漬⹣捯摥ਊ⤬⡓䕌䕃吠䱅噅䰠牮ਠ†††††⁆剏䴠†摵慬ਠ†††††䍏乎䕃吠䉙⁌䕖䕌‼㴠㈰⤊††††† †††⁧牯異⁢礠牮 䱏䍓Ⰺਭⴭ敮搠汯捡氭ⴭⴊⴭ⁓瑡牴映睨⁴牡湳晥爠ਊ⡓䕌䕃吠䑅䍏䑅⡲測ㄬ❓ㄧⰲⰧ匲✬㌬❓㌧Ⱐ㐬❓㐧ⰵⰧ匵✬㘬❓㘧ⰷⰧ匷✬㠬❓㠧Ⱐ㤬❓㤧Ⰺ†††††††††††††㄰Ⱗ匱〧ⰱㄬ❓ㄱ✬ㄲⰧ匱㈧ⰱ㌬❓ㄳ✬ㄴⰧ匱㐧ⰱ㔬❓ㄵ✬ㄶⰧ匱㘧ⰱ㜬❓ㄷ✬ਠ††††††††††††‱㠬❓ㄸ✬ㄹⰧ匱㤧ⰲ〬❓㈰✊†††††††††††††⤠捯氬ਠ††††䑅䍏䑅⡲測†ㄬ獵洨匱⤬㈬獵洨匲⤬㌬獵洨匳⤬㐬獵洨匴⤬㔬獵洨匵⤬ਠ††††㘬獵洨匶⤬㜬獵洨匷⤬㠬獵洨匸⤬㤬獵洨匹⤬㄰ⱳ畭⡓㄰⤬ㄱⱳ畭⡓ㄱ⤬ㄲਠ††††ⱳ畭⡓ㄲ⤬ㄳⱳ畭⡓ㄳ⤬ㄴⱳ畭⡓ㄴ⤬ㄵⱳ畭⡓ㄵ⤬ਠ††††††††††ㄶⱳ畭⡓ㄶ⤬ㄷⱳ畭⡓ㄷ⤬ㄸⱳ畭⡓ㄸ⤬ㄹⱳ畭⡓ㄹ⤬㈰ⱳ畭⡓㈰⤊ਠ††††††††††⤠瑲影瑹⁦牯洠ਨੳ敬散琠湶氨琮猱ⰰ⥳ㄬ湶氨琮猲ⰰ⥳㈬湶氨琮猳ⰰ⥳㌬湶氨琮猴ⰰ⥳㐬湶氨琮猵ⰰ⥳㔊Ɱ癬⡴⹳㘬〩猶Ɱ癬⡴⹳㜬〩猷Ɱ癬⡴⹳㠬〩猸Ɱ癬⡴⹳㤬〩猹Ɱ癬⡴⹳㄰ⰰ⥳㄰ਬ湶氨琮猱ㄬ〩猱ㄬ湶氨琮猱㈬〩猱㈬湶氨琮猱㌬〩猱㌬湶氨琮猱㐬〩猱㐊Ɱ癬⡴⹳ㄵⰰ⥳ㄵⱮ癬⡴⹳ㄶⰰ⥳ㄶⱮ癬⡴⹳ㄷⰰ⥳ㄷⱮ癬⡴⹳ㄸⰰ⥳ㄸⱮ癬⡴⹳ㄹⰰ⥳ㄹⱮ癬⡴⹳㈰ⰰ⥳㈰⁦牯洠睰江摴江湥眠琊睨敲攠琮瑩湟灬慮湯㴺偌䅎ੵ湩潮⁡汬ੳ敬散琠⵮癬⡴⹳ㄬ〩猱Ⱝ湶氨琮猲ⰰ⥳㈬⵮癬⡴⹳㌬〩猳Ⱝ湶氨琮猴ⰰ⥳㐬⵮癬⡴⹳㔬〩猵ਬ⵮癬⡴⹳㘬〩猶Ⱝ湶氨琮猷ⰰ⥳㜬⵮癬⡴⹳㠬〩猸Ⱝ湶氨琮猹ⰰ⥳㤬⵮癬⡴⹳㄰ⰰ⥳㄰ਬ⵮癬⡴⹳ㄱⰰ⥳ㄱⰭ湶氨琮猱㈬〩猱㈬⵮癬⡴⹳ㄳⰰ⥳ㄳⰭ湶氨琮猱㐬〩猱㐊Ⱝ湶氨琮猱㔬〩猱㔬⵮癬⡴⹳ㄶⰰ⥳ㄶⰭ湶氨琮猱㜬〩猱㜬⵮癬⡴⹳ㄸⰰ⥳ㄸⰭ湶氨琮猱㤬〩猱㤬⵮癬⡴⹳㈰ⰰ⥳㈰⁦牯洠睰江摴江湥眠琊睨敲攠琮瑯畴彰污湮漽㩐䱁上⤬⡓䕌䕃吠䱅噅䰠牮ਠ†††††⁆剏䴠†摵慬ਠ†††††䍏乎䕃吠䉙⁌䕖䕌‼㴠㈰⤊††††† †††⁧牯異⁢礠牮† ⁴牟睨‬ਠ†††ਠ†††ⴭ獴慲琠潦楳猠煴礊††† 獥汥捴⁴⹧彳楺攠獩Ᵽ潵湴⡴⹧彳楺攩⁍䥟兴礠晲潭楳獥摟杭瑟楤⁴ਊ睨敲攠琮灬慮彮漠㴠㩐䱁上੧牯異⁢礠琮束獩穥 ††† 浩猊੷桥牥⁡⹡捣彩搽洮慣损楤ਭⵡ湤⹰潮漽❎堭〱㈵✊慮搠種灯湯㵭⹰潮漊慮搠漮潲摥牟湯㵭⹰潮漊慮搠漮潲摥牟湯㵺⹰潮漊慮搠漮灬慮彮漽 㩐䱁上慮搠種捯氽愮捯氊慮搠愮捯氽捴⹣潬彳楺攨⬩੡湤⁡⹣潬㵩湤⹣潬彳楺攨⬩੡湤⁡⹣潬㵳琮捯江獩穥⠫⤊慮搠愮捯氽睨⹣潬⠫⤊慮搠愮捯氽獨⹣潬⠫⤊慮搠愮捯氽瑲彷栮捯氨⬩੡湤⁡⹣潬㵌佃匮捯氨⬩੡湤⁡⹓楺㵭楳⹳椨⬩੡湤⁳⹰污湟湯㵯⹰污湟湯ਊ慮搠愮獩稠楳潴畬氊杲潵瀠批⹰污湟湯ⱡ⹣潬ⱡ⹓楺ⱺ⹯牤Ᵽ琮捵瑟煴礬楮搮楮摟煴礬獴⹳瑟煴礬睨⹷桟煴礬獨⹳桟煴礬䱏䍓⹌佃当䅌Ⰺ瑲彷栮瑲影瑹Ɑ楳⹭楟煴礬献捵瑟獴慴畳ⱳ⹩湤彳瑡瑵猬献獴楴彳瑡瑵猬献灬慮彳瑡瑵猬漮潲摥牟湯Ɐ⹷慳瑥੨慶楮朠†⁳畭⡺⹓ㄩ‾《潲摥爠批⁺⹯牤਩焊杲潵瀠批ⁱ⹰污湟湯ⱱ⹣潬ⱱ⹳楺ⱱ⹯牤ⱱ⹣畴影瑹ⱱ⹩湤影瑹ⱱ⹲敪彡畤琬焮獴影瑹ⱱ⹭楳影瑹ⱱ⹢慬彵湩琬焮睨影瑹ⱱ⹴牟煴礬焮獨影瑹ⱱ⹢慬彷栬焮捵瑟獴慴畳ⱱ⹩湤彳瑡瑵猬焮獴楴彳瑡瑵猬焮灬慮彳瑡瑵猊潲摥爠批ⁱ⹯牤ਊ
620nmfq8upvsb	INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PROCESSING"."MV_GSTK" SELECT DISTINCT A.PLANNO , ENTRYTYPE, NARRATION, B.COLOR, CORPORATE_SUP_NO , A.REC_DATE FROM ( /* QUERY FOR RND*/ SELECT DISTINCT A.PLAN_NO PLANNO, DECODE(A.ENTRY_TYPE, 'DHR', 'GLOT', 'DIR', 'RLOT', 'DFR', 'FLOT') ENTRYTYPE, E.NARRATION, NULL PLAN_NO, CORPORATE_SUP_NO , A.REC_DATE FROM PROCESSING.DYE_SR_DTL B, PROCESSING.DYE_SR_MST A, ENTRYTYPE E WHERE A.ENTRY_NO = B.ENTRY_NO AND A.ENTRY_TYPE IN ('DHR', 'DIR', 'DFR') AND E.STOCKTYPE='DYE' AND A.DEPT_CODE=3502 AND E.ENTRYTYPE=DECODE(A.ENTRY_TYPE, 'DHR', 'GLOT', 'DIR', 'RLOT', 'DFR', 'FLOT') ) A , ( select distinct sup_rec_no, color from rnd_sr_dtl ) b, ( select plan_no from PROCESSING.GSTK WHERE SUBSTR(PLAN_NO, 1, 1)='S' ) S where A.CORPORATE_SUP_NO = b.sup_rec_no AND S.PLAN_NO=A.PLANNO
6nq3t1uk8bkry	SELECT IGPNO, CONTRACT_NO, VEND_CODE, DTL_DESC, PLANNO, IGP_REM, VEHNO, DRIVER FROM ( SELECT IGPNO, processing.get_lot_party(PLANNO, LOTNO, 'CONTRACT') CONTRACT_NO, processing.get_lot_party(PLANNO, LOTNO, 'VEND_CODE') VEND_CODE, processing.get_lot_party(PLANNO, LOTNO, 'PARTY') DTL_DESC, 3501 DEPT_CODE, PLANNO, IGP_REM, VEHNO, DRIVER FROM PROCESSING.PROD_MST D WHERE STATUS='A' AND IGPNO IS NOT NULL AND ENTRY_TYPE='DIS' AND NOT EXISTS (SELECT 1 FROM FAB_SR_MAST WHERE NVL(IGP_OGP_NO, 0)=D.IGPNO ) AND D.FIN_STORE=DECODE(:1, 'FAB_USMAN', 1, 'FAB_TARIQ', 2, 'FAB_ZAIN', 5, 'FAB_ALI', 15, 'FAB_MALI', 20, 'FAB_SAFDAL', 21, 'FAB_AHSAN', 14, '') union all SELECT D.DOC_NO, processing.get_lot_party(PLANNO, LOTNO, 'CONTRACT') CONTRACT_NO, processing.get_lot_party(PLANNO, LOTNO, 'VEND_CODE') VEND_CODE, processing.get_lot_party(PLANNO, LOTNO, 'PARTY') DTL_DESC, 3501 DEPT_CODE, PLANNO, '' IGP_REM, '' VEHNO, '' DRIVER FROM PROCESSING.PROD_MST D WHERE STATUS='A' AND ENTRY_TYPE='DI S' AND NOT EXISTS (SELECT 1 FROM FAB_SR_MAST WHERE NVL(IGP_OGP_NO, 0)=D.DOC_NO ) /*AND OGPNO IS NULL */ AND (PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:2, 'FAB_ALI5', 23, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:3, 'FAB_ALI5', 25, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:4, 'FAB_NADEEM5', 25, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:5, 'FAB_NADEEM5', 23, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:6, 'FAB_K5A', 25, '')) AND D.DOC_DATE>='22-APR-2013' UNION ALL SELECT D.DOC_NO, processing.get_lot_party(PLANNO, LOTNO, 'CONTRACT') CONTRACT_NO, processing.get_lot_party(PLANNO, LOTNO, 'VEND_CODE') VEND_CODE, processing.get_lot_party(PLANNO, LOTNO, 'PARTY') DTL_DESC, 3501 DEPT_CODE, PLANNO, '' IGP_REM, '' VEHNO, '' DRIVER FROM PROCESSING.PROD_MST D WHERE STATUS='A' AND ENTRY_TYPE='DIS' AND NOT EXISTS (SELECT 1 FROM FAB_SR_MAST WHERE NVL(IGP_OGP_NO, 0)=D.DOC_NO ) /*AND OGPNO IS NULL */ AND (PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:7, 'FAB_NAVEED', 10, '' ) or PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:8, 'FAB_NAVEED', 22, '') ) ) ORDER BY IGPNO DESC
6rf1xb3rsb3c9	SELECT CCODE_VALIDATION(:b1) FROM PRODUCTION.TBLPLANSHEET WHERE PLAN_NO = :b2
72851bbkzvsrx	begin update_apo_acc_user; end;
73mzjsxgt8kdb	SELECT NVL(SUM(H.QTY), 0) QTY FROM TBLPLANORDER O, KCL_PO_HITS H WHERE O.ORDER_NO=H.PONO AND O.PLAN_NO=:B2 AND H.GARID=:B1
742vw5aqd5947	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin PRODUCTION.POP_ACH_ALL; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7grsf923r1m4g	select distinct Z.ACT_SIZE S, Z.COL SIZ, ORD from planno_size_qty_view Z where plan_no = :1 and z.req_qty>0 ORDER BY ORD
87a8zgdsn7t2k	SELECT CCODE, UNITNO UNIT#, PLANNO, SUM(INDQTY)INDCUTQTY, SUM(SQTY)STITCHQTY, SUM(FIN_IN)FININ, SUM(FIN_OUT)FINOUT, SUM(WQTY)WHQTY, SUM(RQTY)RQTY, SUM(LSQTY)LSQTY, SUM(LRQTY)LRQTY, SUM(SAMQTY)SAMQTY, ((SUM(SQTY)+SUM(FIN_IN)+SUM(RQTY)+SUM(LRQTY))-(SUM(FIN_OUT)+SUM(WQTY)+SUM(SAMQTY)+SUM(LSQTY)))STOCK, (SUM(INDQTY)-SUM(SQTY))UNSTICH FROM PRODUCTION.UNSTITCH_STOCK_FINAL WHERE DATED <= : SDATE AND UNITNO = NVL ( : P_UNIT , UNITNO ) AND CCODE = : P_CCODE AND not exists ( select 1 from PLAN_STATUS tb where STIT_stock = 'Y' and tb.PLAN_NO = PLANNO ) AND not exists ( select 1 from TBLPLANSHEET tb where CLOSE = 1 and tb.PLAN_NO = PLANNO ) HAVING ( ( ( SUM ( SQTY ) + SUM ( FIN_IN ) + SUM ( RQTY ) + SUM ( LRQTY ) ) - ( SUM ( FIN_OUT ) + SUM ( WQTY ) + SUM ( SAMQTY ) + SUM ( LSQTY ) ) ) + ( SUM ( INDQTY ) - SUM ( SQTY ) ) ) > 0 GROUP BY CCODE , UNITNO , PLANNO ORDER BY 1 ASC, 2 ASC
8k4xz9kr1brkt	SELECT NVL(MAX(OPR_DTL_ID), 0) + 1 FROM OPR_WAGES_EMP_DTL
8r6x06b59nuyt	/* MV_REFRESH (INS) */INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."WAGES_SHEET_MV"("PLANNO", "OPRATION_ID", "DATED", "CCODE", "FLOW_ID", "UNIT_NUM", "EMPCODE", "EARN_AMT") SELECT "M"."PLANNO", "D"."OPRATION_ID", TRUNC("M"."DATED"), "M"."CCODE", "SMT"."FLOW_ID", "M"."UNIT_NUM", "D"."EMP_CODE", SUM(ROUND("M"."STITCHED_QTY"/12, 2)) FROM "OPR_WAGES_EMP_MASTER" "M", "OPR_WAGES_EMP_DTL" "D", "STIT_REC_ISSUE_M" "SMT", "STIT_REC_ISSUE_D" "SDT" WHERE "M"."OPR_MAIN_ID"="D"."OPR_MAIN_ID" AND "D"."EMP_CODE" IS NOT NULL AND "SMT"."DOC_ID"="SDT"."DOC_ID" AN D "SMT"."DOCUMENT_TYPE"='STR' AND "SDT"."SR#"="M"."CUT_BUNDLE_ID" AND TRUNC("M"."DATED")>'01-JUL-2013' GROUP BY "D"."EMP_CODE", "M"."UNIT_NUM", "SMT"."FLOW_ID", TRUNC("M"."DATED"), "M"."CCODE", "M"."PLANNO", "D"."OPRATION_ID"
95hp4vzj95d6b	/* MV_REFRESH (DEL) */ delete from "PRODUCTION"."WAGES_SHEET_MV"
9pc5hdmqdgx9j	UPDATE tblhrmemployee SET EMPCODE=:1, EMPNAME=:2, FNAME=:3, CCODE=:4, NIC=:5, OLDNIC=:6, EXM=:7, LATE_EXM=:8, GM_ATT=:9, DOB=:10, DEPTCODE=:11, DESIGCODE=:12, HOMEADDRESS=:13, CITY=:14, PERMANENTADDRESS=:15, REFRENCE=:16, CELLNO=:17, MOB_CARD_WEFDATE=:18, PERSONALEMAIL=:19, STATUS=:20, EMPTYPE=:21, PHONE=:22, NTNNO=:23, PROBOTIONPERIOD=:24, ENDPRODATE=:25, REASON=:26, LEAVINGDATE=:27, BGROUP=:28, RPLC_CODE=:29, RELIGION=:30, GENDER=:31, SSNO=:32, EOBINO=:33, OTALLOW=:34, RESTDAY=:35, SHIFT=:36, EMPCODE_OLD=:37, TEMPBLOCK=:38, NIGHTSHIFT=:39, HANDITYPE=:40, HANDICAP=:41, IM_BOSS=:42, INDEXDIS=:43, TOTALSALARY=:44, FORNIGHT=:45, SALMODE=:46, BANKID=:47, BRANCHID=:48, ACCOUNTNO=:49, MODIFYDATE=:50, MODIFYBY=:51, TEMPCODE=:52, MOB_CARD=:53, FUEL=:54, GUN_ALLOUNCE=:55, VEHICLE_MAIN=:56, CNIC_EXPIRY_DATE=:57, JOINIGDATE=:58, MOTHER_NAME=:59 WHERE ROWID=:60
9qhf8v4xaxdwq	SELECT SUM(FAB_DYE_VAL) FROM ( SELECT ROUND(SUM(DECODE(CD.FLAG, 'K', GW_IN, 'S', 1, GW_IN)*RATE)) FAB_DYE_VAL FROM RND_SR_MAST M, RND_SR_DTL D, TBLCONTRACTMAST CM, TBLDYECONTRACTDTL CD WHERE M.SUP_REC_NO = D.SUP_REC_NO AND CM.CONTRACT_NO = CD.CONTRACT_NO AND M.CONTRACT_ISUNO = CM.CONTRACT_NO AND D.PLANNO=CM.PLAN_NO AND D.FABRIC_CODE = CD.FABRIC_CODE AND CD.COLOR=D.COLOR AND M.ENTRYTYPE IN ('FFR', 'FRR') AND M.STOCK_TYPE IN ('FFB') AND PLANNO=:B1 UNION SELECT SUM(FAB_DYE_VAL) FAB_DYE_VAL FROM ( SELECT ROUND(SUM(DECODE(CD.FLAG, 'K', GW_IN, 'S', 1, GW_IN)*RATE)) FAB_DYE_VAL, GET_RND_DYE_PROCESS(M.IGP_OGP_NO) PROCESS FROM RND_SR_MAST M, RND_SR_DTL D, TBLCONTRACTMAST CM, TBLDYECONTRACTDTL CD WHERE M.SUP_REC_NO = D.SUP_REC_NO AND CM.CONTRACT_NO = CD.CONTRACT_NO AND M.CONTRACT_ISUNO = CM.CONTRACT_NO AND D.PLANNO LIKE DECODE(CM.PLAN_NO, 'GENERAL', '%', CM.PLAN_NO) AND D.FABRIC_CODE LIKE DECODE(CM.PLAN_NO, 'GENERAL', '%', CD.FABRIC_CODE) AND D.COLOR LIKE DECODE(CM.PLAN_NO, 'GENERAL', '%' , D.COLOR) AND M.ENTRYTYPE IN ('FFR', 'FRR') AND M.STOCK_TYPE IN ('FFB') AND PLANNO=:B1 AND CD.PROCESS_ID=DECODE(GET_RND_DYE_PROCESS(M.IGP_OGP_NO), 'DYE', 3, 'WASH', 2, 'BLEACH', 25) GROUP BY PLANNO, M.IGP_OGP_NO, D.FABRIC_CODE ) )
a63g1ffphjkdc	SELECT SUM(DECODE(NVL(DYS, 0), 1, 0, .75, .25, .50, .50, .25, .75, 0, 1, 0)) FROM ( SELECT NVL(A.EMPCODE, :B2 ) EMPCODE, P.DATED , NVL(STATUS, NVL( DECODE(RTRIM(TO_CHAR(P.DATED, 'DAY')), RTRIM(HRM.GET_EMP_REST(:B2 )), 'WR', NULL), 'A') ) STATUS, NVL(DYS, 0) DYS FROM PERIOD P, ( SELECT EMPCODE, DATED, STATUS, DYS FROM DAILY_ATTENDANCE WHERE EMPCODE=:B2 AND TO_CHAR(DATED, 'MMRRRR')=:B1 ) A WHERE TO_CHAR(P.DATED, 'mmrrrr')=:B1 AND P.DATED=A.DATED(+) ) WHERE STATUS NOT IN ('WR', 'GH') AND EMPCODE=:B2 AND TO_CHAR(DATED, 'MMRRRR')=:B1
ab21w6xh2m3r2	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PROCESSING.mv_gstk'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
axqbs2kdrnra7	INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."MV_STITCHING" select distinct trunc(t.dated) dated, TO_CHAR(t.DATED, 'MON-RRRR') MTH, TO_CHAR(t.DATED, 'RRRR') YR, to_number(TO_CHAR(t.DATED, 'MM'))mt, C.CUS_NAME, P.PHASE_DESC, V.c_Name, t.planno, dept_code_validation(t.unit_num) unit, g.GARMANT_DESCRIPTION PRODUCT, nvl(GET_SAM(t.planno, t.garment_id), 0) SAM, sum(t.stitched_qty) Sth_qty from opr_wages_emp_master t, tblplanorder o, kcl_po_main m, GARMENT_TYPE g, CUSTOMER C, PHASE P, cdtl v where o.plan_no=t.planno and m.pono=o.order_no and t.garment_id=g.garment_id and c.cus_id=m.cus_id and p.phase_id=m.phase_id and v.c_code=t.ccode group by TO_CHAR(t.DATED, 'MON-RRRR'), TO_CHAR(t.DATED, 'RRRR') , to_number(TO_CHAR(t.DATED, 'MM')), C.CUS_NAME, P.PHASE_DESC, v.c_name, g.GARMANT_DESCRIPTION , t.planno, t.unit_num, t.garment_id, trunc(t.dated)
c6rkc2anypq67	SELECT SUM(NVL(QTY_IN, 0)-NVL(QTY_OUT, 0)) FROM ST_MST A, ST_DTL B WHERE A.ENTRY_NO=B.ENTRY_NO AND TRUNC(A.DATED) BETWEEN '13-DEC-12' AND :B3 AND B.PO_NO=:B2 AND B.ITEM_CODE=:B1 AND A.ENTRY_TYPE IN ('RST', 'IFD')
cdy4c52fdcanv	SELECT DISTINCT D.PO_NO, D.ITEM_CODE, SUBSTR(PRODUCTION.GET_YARN(D.ITEM_CODE), 1, 100)ITEM_DESC , PROCESSING.ST_YARN_STK(:P_TO, D.PO_NO, D.ITEM_CODE, :P_STK)STK FROM PROCESSING.ST_MST M, PROCESSING.ST_DTL D WHERE M.ENTRY_NO=D.ENTRY_NO AND TRUNC(M.DATED)<=:P_TO AND TO_NUMBER(SUBSTR(D.ENTRY_NO, 4, 2))=:P_CCODE AND D.ITEM_CODE=NVL(:P_ITEM, D.ITEM_CODE) AND PROCESSING.ST_YARN_STK(:P_TO, D.PO_NO, D.ITEM_CODE, :P_STK)<>0
ch0thvp9q6y1w	SELECT DISTINCT T.PLAN_NO, T.PLAN_DATE, to_char(WM_CONCAT(DISTINCT ORDER_NO))PAKPO FROM TBLPLANSHEET T, tblplanorder o WHERE T.PLAN_DATE >='01-JAN-2011' and T.PLAN_NO=O.PLAN_NO GROUP BY T.PLAN_NO, T.PLAN_DATE /*AND UNIT=decode(:GLOBAL.COMPANY_CODE, 13, unit, :GLOBAL.COMPANY_CODE)*/ ORDER BY T.PLAN_DATE DESC
cjaa80k1hvpc1	select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128
cm5vu20fhtnq1	獥汥捴 ⨫⁣潮湥捴形祟晩汴敲楮朠⨯⁰物癩汥来⌬汥癥氠晲潭⁳祳慵瑨␠捯湮散琠批⁧牡湴敥⌽灲楯爠灲楶楬敧攣⁡湤⁰物癩汥来⌾〠獴慲琠睩瑨⁧牡湴敥⌽㨱⁡湤⁰物癩汥来⌾
czuy3y5uc92ab	SELECT distinct PLANNO, STYLENO, ORDERNO, CCODE, DEPT_NAME, DEPTCODE, GET_ADV_WAGE_PAY_JUL(CCODE, EMPCODE, :P_FROM, :P_TO, DEPTCODE) ADV_PAY, (26 - GET_EMP_ABS_datewise (empcode, :P_FROM , :P_TO)) DAYS_NEW, EMPCODE, OPRCODE, SUM(QTY) QTY, RATE, EMPNAME, FNAME, OPRNAME, SUM(ROUND(AMT, 2)) AMT, --EMPLOYEE_ATT_NEW_WAGES(CCODE, EMPCODE, :P_FROM , :P_TO) 0 DAYS FROM ( SELECT M.PLANNO, GET_PLAN_STYLE(M.PLANNO) STYLENO, GET_PLAN_PO(M.PLANNO) ORDERNO, M.CCODE, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM) DEPTCODE, DEPT_CODE_VALIDATION(DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)) DEPT_NAME, D.EMP_CODE EMPCODE, to_char(D.OPRATION_ID) OPRCODE, SUM(M.STITCHED_QTY) QTY , GET_PLANE_OPRATION_RATE(m.PLANNO, D.OPRATION_ID) RATE, emp_code_validation(D.EMP_CODE) EMPNAME, PRODUCTION.GET_EMP_FNAME(D.EMP_CODE) as FNAME , 0 as OPRCATNAME, OPERATION_ID_VALIDATION(D.OPRATION_ID) OPRNAME, SUM(ROUND((M.STITCHED_QTY)/12, 2 ) * GET_PLANE_OPRATION_RATE(m.PLANNO, D.OPRATION_ID)) as AMT, PRODUCTION.GET_EMP_SSALLOW( D.EMP_CODE) SS FROM OPR_WAGES_EMP_MASTER M, OPR_WAGES_EMP_DTL D WHERE M.OPR_MAIN_ID=D.OPR_MAIN_ID And D.EMP_CODE is not null AND PRODUCTION.GET_EMPTYPE(D.EMP_CODE)=:P_EMPTYPE AND trunc(M.dated) BETWEEN :P_FROM AND :P_TO AND M.CCODE=:P_CCODE AND D.EMP_CODE= NVL(:P_EMP, D.EMP_CODE) AND DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)=NVL(:P_DEPT, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)) group by M.CCODE, D.EMP_CODE , m.PLANNO , m.UNIT_NUM, D.OPRATION_ID UNION ALL SELECT M.PLANNO, GET_PLAN_STYLE(M.PLANNO) STYLENO, GET_PLAN_PO(M.PLANNO) ORDERNO, M.CCODE, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM) DEPTCODE, DEPT_CODE_VALIDATION(DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)) DEPT_NAME, EMPCODE, To_char(OPRATION) OPRCODE, SUM(M.STITCHED_QTY) QTY , GET_PLANE_OPRATION_RATE(M.PLANNO, OPRATION) RATE, emp_code_validation(EMPCODE) EMPNAME, PRODUCTION.GET_EMP_FNAME(EMPCODE) as FNAME , 0 as OPRCATNAME, OPERATION_ID_VALIDATION(OPRATION) OPRNAME, SUM(ROUND((M.STITCHED_QTY)/12, 2 ) * GET_PLANE_OPRATION_RATE(m.PLANNO, OP RATION)) as AMT, PRODUCTION.GET_EMP_SSALLOW(EMPCODE) SS FROM OPR_WAGES_EMP_MASTER M, OPR_WAGES_EMP_M MD WHERE M.OPR_MAIN_ID=MD.OPR_MAIN_ID AND PRODUCTION.GET_EMPTYPE(EMPCODE)=:P_EMPTYPE AND trunc(Ddate) BETWEEN :P_FROM AND :P_TO AND M.CCODE=:P_CCODE AND EMPCODE= NVL(:P_EMP, EMPCODE) AND DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)=NVL(:P_DEPT, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)) group by M.CCODE, EMPCODE , M.PLANNO , DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM), OPRATION UNION ALL SELECT Distinct a.planno, GET_PLAN_STYLE(a.PLANNO) STYLENO, GET_PLAN_PO(a.PLANNO) ORDERNO, A.ccode, a.unit_no DEPTCODE, DEPT_CODE_VALIDATION(A.UNIT_NO) DEPT_NAME, A.EMPCODE , To_char(a.operation) OPRCODE, 0 qty, 0 rate , E.empname, E.fname, 0 as OPRCATNAME, OPERATION_ID_VALIDATION(a.operation) OPRNAME, 0.01 amt, PRODUCTION.GET_EMP_SSALLOW(a.EMPCODE) SS FROM PRODUCTION.opr_wages_emp_add A, TBLHRMEMPLOYEE E WHERE A.EMPCODE=E.EMPCODE AND PRODUCTION.GET_EMPTYPE( A.EMPCODE)= :p_emptype AND TRUNC(A.DATED) B ETWEEN :p_from AND :p_to AND A.CCODE = :p_ccode AND A.EMPCODE= NVL(:P_EMP, A.EMPCODE) AND A.UNIT_NO=NVL(:P_DEPT, A.UNIT_NO) ) GROUP BY PLANNO , STYLENO , ORDERNO , CCODE , EMPCODE , OPRCODE , RATE , EMPNAME , FNAME , OPRNAME , DEPT_NAME , DEPTCODE HAVING SUM ( AMT ) > 0 ORDER BY 9 ASC, 14 ASC, 13 ASC, 17 ASC, 8 ASC, 7 ASC, 5 ASC, 6 ASC, 1 ASC, 2 ASC, 3 ASC, 15 ASC
f9utav8z8czs4	SELECT SUM(QTY) FROM (SELECT S1 QTY, 'S1' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S2 QTY, 'S2' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S3 QTY, 'S3' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S4 QTY, 'S4' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S5 QTY, 'S5' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S6 QTY, 'S6' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S7 QTY, 'S7' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S8 QTY, 'S8' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S9 QTY, 'S9' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S10 QTY, 'S10' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S11 QTY, 'S11' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S12 QTY, 'S12' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S13 QTY, 'S13' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S14 QTY, 'S14' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S15 QTY, 'S15' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S16 QTY, 'S16' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S17 QTY, 'S17' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S18 QTY, 'S18' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S19 QTY, 'S19' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL UNION ALL SELECT S20 QTY, 'S20' AS SIZ , PO, HITID, TYPE FROM PRODUCTION_ACHIEVEMENTS_DTL ) M WHERE TYPE=:B2 AND SIZ=:B1 AND EXISTS (SELECT DISTINCT HITID FROM STITCHING_PLAN_MAIN B WHERE PLAN_NO=:B4 AND B.HITID=M.HITID AND GET_HIT_GAR(B.HITID)=:B3 )
fabnkbu3vk8rp	卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺ㄠ䅎䐠❆䑉✽㨲⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⤽㨳⁁乄‧䑙䔧㴺㐠䅎䐠❍䄧㴺㔠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䴧Ⱗ䄧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐠䥎⠳ⰷ⤠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁇䕔彆䥎䥓䡟剏啔⡃⹃䑋彉䐩⁆䥎䥓䡟剏啔䔬⁖⹄䥁ⱖ⹇啁䝅ⱖ⹇卍ⱖ⹆䥎彇卍ⱖ⹆䥎彗䥄ⱖ⹄奅彁噇彗䅓呅Ⱐ䌮䍄䭟䥄⁆剏䴠呂䱄奅䍏乔剁䍔䑔䰠䌠ⱖ彃啔剅儠嘬䍄䭟䙉义午归何吠䘠坈䕒䔠䌮䍏乔剁䍔彎伽㨶⁁乄‧䙄䤧㴺㜠䅎䐠䌮䍄䭟䥄㵖⹓剎传䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩㴺㠠䅎䐠❄奅✽㨹⁁乄‧䴧㴺㄰⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䵁䥎彁䍃✩㴧䴧⁁乄⁃⹃䑋彉䐽䘮䍄䭟䥄⁁乄⁆⹏剄㴨卅䱅䍔⁍䥎⡏剄⤠䙒位⁐剏䑕䍔䥏丮䍄䭟䙉义午归何吠堠坈䕒䔠堮䍄䭟䥄㵃⹃䑋彉䐠⤠䅎䐠䘮偒佃䕓卟䥄⁉丨㌬㜩⁕义低⁁䱌⁓䕌䕃吠䑉協䥎䍔⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䙁䉒䥃彃佄䔧⤠䙁䉒䥃彃佄䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䙁䉒䥃✩⁆䅂剉䍟呙偅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⤠偌䅎彃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❄䕓䍒䥐呉低 ✩⁄䕓䍒䥐呉低Ⱐ䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺ㄱ⁁乄‧䙄䤧㴺ㄲ⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⤽㨱㌠䅎䐠❄奅✽㨱㐠䅎䐠❁✽㨱㔠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤽❁✠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐠䥎⠳ⰷ⤠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁇䕔彆䥎䥓䡟剏啔⡃⹃䑋彉䐩⁆䥎䥓䡟剏啔䔬⁖⹄䥁ⱖ⹇啁䝅ⱖ⹇卍ⱖ⹆䥎彇卍ⱖ⹆䥎彗䥄ⱖ⹄奅彁噇彗䅓呅Ⱐ䌮䍄䭟䥄⁆剏䴠呂䱄奅䍏乔剁䍔䑔䰠䌠ⱖ彃啔剅儠嘬䍄䭟䙉义午归何吠䘠坈䕒䔠䌮䍏乔剁䍔彎伽㨱㘠䅎䐠❆䑉✽㨱㜠䅎䐠䌮䍄䭟䥄㵖⹓剎传䅎䐠❗䅓䠧㴺ㄸ⁁乄‧䵁✽㨱㤠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䴧Ⱗ䄧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐽㈠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺㈰⁁乄‧䙄䤧㴺㈱⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄‧坁午✽㨲㈠䅎䐠❍✽㨲㌠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䴧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉 丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐽㈠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺㈴⁁乄‧䙄䤧㴺㈵⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄‧坁午✽㨲㘠䅎䐠❁✽㨲㜠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䄧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐽㈠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺㈸⁁乄‧䙄䤧㴺㈹⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄‧佔䡅刧㴺㌰⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䵁䥎彁䍃✩⁉丨❍✬❁✩⁁乄⁃⹃䑋彉䐽䘮䍄䭟䥄⁁乄⁆⹏剄㴨卅䱅䍔⁍䥎⡏剄⤠䙒位⁐剏䑕䍔䥏丮䍄䭟䙉义午归何吠堠坈䕒䔠堮䍄䭟䥄㵃⹃䑋彉䐠⤠䅎䐠䘮偒佃䕓卟䥄⁎佔⁉丨㌬㈩⁕义低⁁䱌⁓䕌䕃吠䑉協䥎䍔⁖⹆䅂剉䍟䍏䑅Ⱐ䝅呟䙁䉒䥃⡖⹆䅂剉䍟䍏䑅⤠䙁䉒䥃彔奐䔬 ⩄䕃佄䔨㩆䅂当剟䵁協⹅乔剙呙偅Ⱗ䙆䘧ⱃ⹓呋彃佌佒ⱖ⹃佌佒⤠䍏䱏刬⨯⁖⹃佌佒Ⱐ嘮䍏䱏删偌䅎彃佌佒Ⱐ嘮䑅千剉偔䥏丬⁇䕔彆䥎䥓䡟剏啔⡃⹃䑋彉䐩⁆䥎䥓䡟剏啔䔠ⱖ⹄䥁ⱖ⹇啁䝅ⱖ⹇卍ⱖ⹆䥎彇卍ⱖ⹆䥎彗䥄ⱖ⹄奅彁噇彗䅓呅ⱃ⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑 ⁖⁗䡅剅⁃⹃低呒䅃呟乏㴺㌱⁁乄‧䉆䘧㴺㌲⁁乄⁃⹃低呟呙偅㵄䕃佄䔨㨳㌬❆䥒✬❄奅✬❆䙆✬❆䥎✩⁁乄⁃⹃䑋彉䐽嘮卒乏

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Key Instance Activity Stats
• Other Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 2,560,069

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations