WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
PROD	293518444	PROD	1	06-Jul-16 17:07	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
erpprodlivedb.sunresort.local	Linux x86 64-bit	8	8	1	31.35

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9523	12-Jul-16 10:00:33	531	10.9
End Snap:	9524	12-Jul-16 10:38:21	533	10.8
Elapsed:		37.81 (mins)
DB Time:		48.28 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	7,872M	7,872M	Std Block Size:	8K
Shared Pool Size:	4,352M	4,352M	Log Buffer:	39,932K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.3	0.1	0.01	0.00
DB CPU(s):	0.3	0.0	0.00	0.00
Redo size:	12,232.2	641.6
Logical reads:	13,390.0	702.3
Block changes:	91.5	4.8
Physical reads:	5.4	0.3
Physical writes:	5.7	0.3
User calls:	258.0	13.5
Parses:	21.5	1.1
Hard parses:	1.1	0.1
W/A MB processed:	-11.4	-0.6
Logons:	0.3	0.0
Executes:	244.1	12.8
Rollbacks:	1.5	0.1
Transactions:	19.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.94	Redo NoWait %:	100.00
Buffer Hit %:	99.96	In-memory Sort %:	100.00
Library Hit %:	99.31	Soft Parse %:	94.80
Execute to Parse %:	91.19	Latch Hit %:	98.99
Parse CPU to Parse Elapsd %:	61.75	% Non-Parse CPU:	98.02

Shared Pool Statistics

	Begin	End
Memory Usage %:	71.16	71.11
% SQL with executions>1:	85.88	97.45
% Memory for SQL w/exec>1:	87.41	92.51

Top 5 Timed Foreground Events

Host CPU (CPUs: 8 Cores: 8 Sockets: 1)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.59	0.99	4.1	1.7	1.0	94.1

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
4.1	69.7	1.4

Memory Statistics

	Begin	End
Host Mem (MB):	32,102.0	32,102.0
SGA use (MB):	12,672.0	9,216.0
PGA use (MB):	1,491.0	1,505.5
% Host Mem used for SGA+PGA:	44.12	33.40

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): 2897.1s
• 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 100.2% of Total DB time 2,897.10 (s)
• Total FG Wait Time: 2,273.80 (s) DB CPU time: 629.56 (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 76.3% of Total DB Time (s): 2,897
• Captured PL/SQL account for 0.5% of Total DB Time (s): 2,897

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 53.2% of Total CPU Time (s): 630
• Captured PL/SQL account for 1.4% of Total CPU Time (s): 630

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 19.7% of Total User I/O Wait Time (s): 106
• Captured PL/SQL account for 5.0% of Total User I/O Wait Time (s): 106

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: 30,373,392
• Captured SQL account for 95.3% 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: 12,203
• Captured SQL account for 28.5% 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: 10,595
• Captured SQL account for 1.9% of Total
• Total UnOptimized Read Requests: 10,595
• Captured SQL account for 1.9% 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: 553,779
• Captured SQL account for 83.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 48,797
• Captured SQL account for 29.9% 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

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
02y1xzs7zv4rq	SELECT A.VALUE, B.VALUE FROM V$NLS_PARAMETERS A, V$NLS_PARAMETERS B WHERE A.PARAMETER = 'NLS_CHARACTERSET' AND B.PARAMETER = 'NLS_SORT'
03s61gtq86zy3	update MTL_MATERIAL_TRANSACTIONS_TEMP MMTT set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG='Y', ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG='Y' and NVL(TRANSACTION_STATUS, 1) in (1, 3)) and NVL(LOCK_FLAG, 'N')='N') and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MMTT.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
05uqdabhzncdc	select role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0b6y4c54mqnzx	select /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) +*/ NVL(min(transaction_id), 0) into :b0 from mtl_material_transactions MMT where (((transaction_date=TO_DATE(:b1, 'YYYY/MM/DD HH24:MI:SS') and ((nvl(parent_transaction_id, transaction_id)=transaction_id or (nvl(parent_transaction_id, transaction_id)<>transaction_id and transaction_action_id in (15, 22))) or ((((parent_transaction_id is not null and parent_transaction_id<>transaction_id) and transaction_action_id=17) and transaction_source_type_id=7) and 1=(select MOD(sum(DECODE(MP.process_enabled_flag, 'Y', 1, 2)), 2) from mtl_parameters mp where (mp.organization_id=mmt.organization_id or mp.organization_id=mmt.transfer_organization_id))))) and costed_flag in ('N', 'E')) and (((organization_id=:b2 and ((costed_flag='E' or (nvl(logical_transactions_created, 1)=2 or exists (select null from mtl_material_transactions_temp MMTP where ((MMT.transaction_action_id in (30, 31) and MMT.organization_id=MMTP.organization_id) and (MMT.COMPLETION_TRANSACTION_ID=MMTP.COMPLETION_TRANSACTION_ID or MMT.MOVE_TRANSACTION_ID=MMTP.move_transaction_id)) union all select null from wip_move_txn_interface WMTI where (MMT.transaction_action_id in (30, 31) and WMTI.TRANSACTION_ID=MMT.MOVE_TRANSACTION_ID)))) or (costed_flag='N' and (exists (select null from mtl_parameters where ((organization_id=MMT.transfer_organization_id and primary_cost_method in (2, 5, 6)) and process_enabled_flag='N')) and (((transaction_action_id=3 and primary_quantity>0) and transaction_cost is null ) or exists (select null from mtl_interorg_parameters MIP where ((((transaction_action_id=12 and MIP.to_organization_id=MMT.organization_id) and MIP.from_organization_id=MMT.transfer_organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2) and shipment_costed is null ))))))) or ((transfer_organization_id=:b2 and costed_flag='N') and (exists (select null from mtl_interorg_parameters MIP where (((((transaction_action_id=21 and MIP.to_organization_id=MMT.transfer_organization_id) and MIP.from_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=1) and shipment_costed is null ) and exists (select null from mtl_parameters where (organization_id=MMT.organization_id and primary_cost_method in (2, 5, 6))))) or (exists (select null from mtl_parameters where (((organization_id=MMT.organization_id and primary_cost_method=1) and cost_cutoff_date is not null ) and MMT.transaction_date>=cost_cutoff_date)) and (transaction_action_id=3 and primary_quantity<0))))) or ((costed_flag='N' and exists (select null from mtl_interorg_parameters MIP where ((((transaction_action_id in (21, 15) and MIP.to_organization_id=MMT.transfer_organization_id) and MIP.from_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=1) or (((transaction_action_id in (12, 22) and MIP.to_organization_id=MMT.organization_id) and MIP.from_organization_id=MMT.transfer_organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2)))) and exists (select null from mtl_parameters where (((primary_cost_method=1 and cost_cutoff_date is not null ) and MMT.transaction_date>=cost_cutoff_date) and (((MMT.organization_id=:b2 and organization_id=MMT.transfer_organization_id) and process_enabled_flag='N') or (MMT.transfer_organization_id=:b2 and organization_id=MMT.organization_id)))))))
0q8w0cndsp865	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID
19w2h52d7ggr7	SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LANGUAGE', 'NLS_DATE_LANGUAGE', 'NLS_SORT', 'NLS_TERRITORY', 'NLS_DATE_FORMAT', 'NLS_NUMERIC_CHARACTERS', 'NLS_CHARACTERSET' )
19x1189chq3xd	SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE
1ad1ww0b5p4ky	SELECT DECODE(:B1 , 'P', 'REPORTS', 'I', 'PLSQL_CP', 'J', 'JAVA_STORED_CP', 'K', 'JAVA_CP', 'Q', 'SQLPLUS_CP', 'E', 'PERL_CP', 'S', 'SUBROUTINE_CP', 'A', 'SPAWNED_CP', 'H', 'HOST_CP', 'L', 'LOADER_CP', 'NOT_SUPPORTED') FROM DUAL
1c1u6gc725u2a	SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NVL(U.CUSTOMER_ID, :B2 ) CUSTOMER_ID, NVL(U.SUPPLIER_ID, :B2 ) SUPPLIER_ID, NVL(U.PERSON_PARTY_ID, :B2 ) PERSON_PARTY_ID FROM FND_USER U WHERE U.USER_ID = :B1
1d3vut2wf2mhv	SELECT ENABLE_ROUTINE, DISABLE_ROUTINE, DRO.DEBUG_OPTION_NAME, DRO.DEBUG_OPTION_VALUE, DR.DEBUG_RULE_ID, REPEATION_COUNTER, START_TIME, END_TIME, USER_ID, RESPONSIBILITY_ID, RESP_APPL_ID, COMPONENT_TYPE, COMPONENT_NAME, COMPONENT_ID, COMPONENT_APPL_ID, TRACE_FILE_ROUTINE, TRACE_FILE_NODE, COMMENTS, NVL(REQUEST_ID, 0) REQID FROM FND_DEBUG_OPTIONS DO, FND_DEBUG_RULES DR, FND_DEBUG_OPTION_VALUES DOV, FND_DEBUG_RULE_OPTIONS DRO WHERE ( DR.USER_ID = :B8 OR (DR.RESPONSIBILITY_ID = :B7 AND DR.RESP_APPL_ID = :B6 ) OR (DR.USER_ID IS NULL AND DR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= DR.START_TIME AND SYSDATE <= DR.END_TIME) OR DR.REPEATION_COUNTER > 0 ) AND ( DR.COMPONENT_NAME = :B5 OR (DR.COMPONENT_ID = :B4 AND DR.COMPONENT_APPL_ID = :B3 ) ) AND DR.COMPONENT_TYPE = :B2 AND DRO.DEBUG_OPTION_NAME = DOV.DEBUG_OPTION_NAME AND DRO.DEBUG_OPTION_VALUE = DOV.DEBUG_OPTION_VALUE AND DRO.DEBUG_OPTION_NAME = DO.DEBUG_OPTION_NAME AND DO.TYPE = 'D' AND DO.ENABLED_FLAG = 'Y' AND ((DR.REQUEST_ID IS NOT NULL AND :B1 = DR.REQUEST_ID) OR (DR.REQUEST_ID IS NULL) ) AND DR.DEBUG_RULE_ID = DRO.DEBUG_RULE_ID AND DR.DEBUG_RULE_ID=(SELECT MIN(DEBUG_RULE_ID) FROM FND_DEBUG_RULES IDR WHERE (IDR.USER_ID = :B8 OR (IDR.RESPONSIBILITY_ID = :B7 AND IDR.RESP_APPL_ID = :B6 ) OR (IDR.USER_ID IS NULL AND IDR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= IDR.START_TIME AND SYSDATE <= IDR.END_TIME) OR IDR.REPEATION_COUNTER > 0 ) AND ( IDR.COMPONENT_NAME = :B5 OR (IDR.COMPONENT_ID = :B4 AND IDR.COMPONENT_APPL_ID = :B3 ) ) AND IDR.COMPONENT_TYPE = :B2 AND ((IDR.REQUEST_ID IS NOT NULL AND :B1 = IDR.REQUEST_ID) OR (IDR.REQUEST_ID IS NULL) ) ) ORDER BY REQID DESC, DR.CREATION_DATE, DR.DEBUG_RULE_ID
1ftd4vvnwzyqq	SELECT DISTINCT R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.SECURITY_GROUP_ID, R.RESPONSIBILITY_NAME, S.SECURITY_GROUP_NAME FROM FND_RESPONSIBILITY_VL R, FND_USER_RESP_GROUPS U, FND_SECURITY_GROUPS_VL S WHERE U.USER_ID = :A00 AND SYSDATE BETWEEN U.START_DATE AND NVL(U.END_DATE, SYSDATE) AND R.VERSION IN ('4', 'W') AND R.APPLICATION_ID = U.RESPONSIBILITY_APPLICATION_ID AND R.RESPONSIBILITY_ID = U.RESPONSIBILITY_ID AND SYSDATE BETWEEN R.START_DATE AND NVL(R.END_DATE, SYSDATE) AND U.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID AND S.SECURITY_GROUP_ID >= 0 AND S.SECURITY_GROUP_KEY = NVL(:A01, S.SECURITY_GROUP_KEY) AND R.RESPONSIBILITY_KEY = NVL(:A02, R.RESPONSIBILITY_KEY) AND R.APPLICATION_ID = NVL(:A03, R.APPLICATION_ID) AND NVL(:A04, 1) <= NVL(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL', U.USER_ID, R.RESPONSIBILITY_ID, R.APPLICATION_ID), 1) ORDER BY RESPONSIBILITY_NAME, SECURITY_GROUP_NAME
1nrhwbfbmgpmw	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_PROFILE_OPTION' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID
1wmz1trqkzhzq	SELECT /*+ ORDERED USE_NL (WIASP WI WPAP WAP) INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */ WIASP.ROWID ROW_ID FROM WF_ITEM_ACTIVITY_STATUSES WIASP, WF_ITEMS WI, WF_PROCESS_ACTIVITIES WPAP, WF_ACTIVITIES WAP WHERE WIASP.ITEM_TYPE = :B2 AND WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID AND WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE AND WPAP.ACTIVITY_NAME = WAP.NAME AND WIASP.ITEM_TYPE = WI.ITEM_TYPE AND WIASP.ITEM_KEY = WI.ITEM_KEY AND WI.BEGIN_DATE >= WAP.BEGIN_DATE AND WI.BEGIN_DATE < NVL(WAP.END_DATE, WI.BEGIN_DATE+1) AND WAP.TYPE = :B1 AND WIASP.ACTIVITY_STATUS = 'ACTIVE' AND NOT EXISTS (SELECT NULL FROM WF_ITEM_ACTIVITY_STATUSES WIASC, WF_PROCESS_ACTIVITIES WPAC WHERE WAP.ITEM_TYPE = WPAC.PROCESS_ITEM_TYPE AND WAP.NAME = WPAC.PROCESS_NAME AND WAP.VERSION = WPAC.PROCESS_VERSION AND WPAC.INSTANCE_ID = WIASC.PROCESS_ACTIVITY AND WIASC.ITEM_TYPE = WI.ITEM_TYPE AND WIASC.ITEM_KEY = WI.ITEM_KEY AND WIASC.ACTIVITY_STATUS IN ('ACTIVE', 'NOTIFIED', 'SUSPEND', 'DEFERRED', 'ERROR'))
1ytruncyx2kdb	BEGIN MGMT_HTTP_SESSION.session_expired(:1); END;
1zr2ujm5sa5gc	begin fnd_oam_collection.refresh_app_sys_status; end;
20xbbyqvh05c7	update /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) +*/ mtl_material_transactions MMT set transaction_group_id=:b0, last_update_date=SYSDATE, last_updated_by=:b1, last_update_login=:b2, program_application_id=:b3, program_id=:b4, program_update_date=SYSDATE where ((((((costed_flag='N' and ((nvl(parent_transaction_id, transaction_id)=transaction_id or (nvl(parent_transaction_id, transaction_id)<>transaction_id and transaction_action_id in (15, 22))) or ((((parent_transaction_id is not null and parent_transaction_id<>transaction_id) and transaction_action_id=17) and transaction_source_type_id=7) and 1=(select MOD(sum(DECODE(MP.process_enabled_flag, 'Y', 1, 2)), 2) from mtl_parameters mp where (mp.organization_id=mmt.organization_id or mp.organization_id=mmt.transfer_organization_id))))) and (transaction_date<TO_DATE(:b5, 'YYYY/MM/DD HH24:MI:SS') or (((:b6=0 and transaction_date=TO_DATE(:b5, 'YYYY/MM/DD HH24:MI:SS')) and transaction_date<TO_DATE(:b8, 'YYYY/MM/DD HH24:MI:SS')) and transaction_id<:b9))) and DECODE(transaction_action_id, 12, DECODE(transfer_organization_id, :b10, NVL(shipment_costed, 'N'), 'N'), DECODE(organization_id, :b10, NVL(shipment_costed, 'N'), 'N'))<>'Y') and not ((MMT.transaction_source_type_id=5 and NVL(MMT.flow_schedule, 'N')='Y') and MMT.transaction_action_id in (1, 27, 33, 34))) and (((organization_id=:b10 and not exists (select null from mtl_material_transactions_temp MMTP where ((MMT.transaction_action_id in (30, 31) and MMT.organization_id=MMTP.organization_id) and (MMT.COMPLETION_TRANSACTION_ID=MMTP.COMPLETION_TRANSACTION_ID or MMT.MOVE_TRANSACTION_ID=MMTP.move_transaction_id)) union all select null from wip_move_txn_interface WMTI where (MMT.transaction_action_id in (30, 31) and WMTI.TRANSACTION_ID=MMT.MOVE_TRANSACTION_ID))) and not (MMT.transaction_action_id in (3, 12) and (exists (select null from mtl_parameters where ((organization_id=MMT.transfer_organization_id and primary_cost_method in (2, 5, 6)) and process_enabled_flag='N')) and (((transaction_action_id=3 and primary_quantity>0) and transaction_cost is null ) or ((MMT.transaction_action_id=12 and MMT.shipment_costed is null ) and exists (select null from mtl_interorg_parameters MIP where ((MIP.to_organization_id=MMT.organization_id and MIP.from_organization_id=MMT.transfer_organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2))))))) or (MMT.transfer_organization_id=:b10 and ((exists (select null from mtl_parameters where (organization_id=MMT.organization_id and primary_cost_method in (2, 5, 6))) and exists (select null from mtl_interorg_parameters MIP where (((((MMT.transaction_action_id=21 and MIP.to_organization_id=MMT.transfer_organization_id) and MIP.from_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=1) and MMT.shipment_costed='Y') or ((((MMT.transaction_action_id=12 and MIP.from_organization_id=MMT.transfer_organization_id) and MIP.to_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2) and MMT.shipment_costed is null )))) or (exists (select null from mtl_parameters where ((organization_id=MMT.organization_id and primary_cost_method=1) and MMT.transaction_date<NVL(cost_cutoff_date, (SYSDATE+1)))) and (exists (select null from mtl_interorg_parameters MIP where ((((MMT.transaction_action_id=12 and MIP.from_organization_id=MMT.transfer_organization_id) and MIP.to_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2) or (((MMT.transaction_action_id=21 and MIP.to_organization_id=MMT.transfer_organization_id) and MIP.from_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=1))) or (MMT.transaction_action_id=3 and MMT.primary_quantity>0))))))) and not (transaction_action_id=36 and (exists (select null from cst_revenue_cogs_match_lines where ((cogs_om_line_id=trx_source_line_id and pac_cost_type_id is null ) and original_shipped_qty is null )) or :b14=1)))
24pvc5bn4w9th	SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, 0) FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((401, 32320), (401, 32321), (702, 31888), (702, 32763), (706, 31915)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((401, 57333)) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((401, 32237), (401, 32319), (401, 32320), (401, 32321), (401, 57336), (702, 31888), (702, 31889), (702, 32763), (706, 31892), (706, 31915)))) FOR UPDATE OF R.status_code NoWait
28snkd14qy95b	SELECT * FROM RCV_TRANSACTIONS_INTERFACE RTI WHERE RTI.PROCESSING_STATUS_CODE = 'PENDING' AND RTI.PROCESSING_MODE_CODE = :B1 AND ( MO_GLOBAL.CHECK_ACCESS(RTI.ORG_ID) = 'Y' OR RTI.ORG_ID IS NULL) CONNECT BY PRIOR RTI.INTERFACE_TRANSACTION_ID = PARENT_INTERFACE_TXN_ID START WITH RTI.INTERFACE_TRANSACTION_ID IN (SELECT RTI1.INTERFACE_TRANSACTION_ID FROM RCV_TRANSACTIONS_INTERFACE RTI1 WHERE RTI1.PARENT_INTERFACE_TXN_ID IS NOT NULL AND RTI1.PROCESSING_MODE_CODE = :B1 AND RTI1. PARENT_INTERFACE_TXN_ID NOT IN(SELECT RTI2.INTERFACE_TRANSACTION_ID FROM RCV_TRANSACTIONS_INTERFACE RTI2)) ORDER BY RTI.GROUP_ID, RTI.INTERFACE_TRANSACTION_ID
2awqj4xu2qhyx	SELECT * FROM ( SELECT * FROM RCV_TRANSACTIONS_INTERFACE WHERE PROCESSING_STATUS_CODE = 'PENDING' AND PROCESSING_MODE_CODE = :B1 AND ( MO_GLOBAL.CHECK_ACCESS(ORG_ID) = 'Y' OR ORG_ID IS NULL) ) RCV CONNECT BY PRIOR RCV.INTERFACE_TRANSACTION_ID = RCV.PARENT_INTERFACE_TXN_ID START WITH RCV.PARENT_INTERFACE_TXN_ID IS NULL ORDER BY GROUP_ID, INTERFACE_TRANSACTION_ID
2mwvn9xwq1tz3	select (RUNNING_PROCESSES-MAX_PROCESSES) , MAX_PROCESSES , NVL(SLEEP_SECONDS, 0) , DIAGNOSTIC_LEVEL into :b0, :b1, :b2, :b3:b4 from FND_CONCURRENT_QUEUES where ((APPLICATION_ID=:b5 and CONCURRENT_QUEUE_ID=:b6) and (TARGET_NODE=:b7 or (TARGET_NODE is null and :b7 is null )))
2sjraytcfcv2n	SELECT /*+ USE_NL (A B I) */ DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.APPLICATION_SHORT_NAME, B.BASEPATH, I.PRODUCT_VERSION FROM FND_APPLICATION_TL A, FND_APPLICATION B, FND_PRODUCT_INSTALLATIONS I WHERE A.APPLICATION_ID = I.APPLICATION_ID (+) AND A.APPLICATION_ID = B.APPLICATION_ID AND A.LANGUAGE = USERENV ('LANG')
320p3t19tmxs1	select ATTRIBUTE15, CURRENCY_CODE, PARTY_ID, SHIPPING_LOC, VENDOR_ID, AUTO_TAX_CALC_FLAG, TODAY_DATE, NEED_BY_DATE, ORG_ID, NOTE_TO_VENDOR, LONG_DESCRIPTION, ITEM_TYPE, DELIVER_TO_LOCATION_ID, PO_NUM, PO_NUM_2, PHONE, FAX, DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, VENDOR_NUM, VENDOR_NAME, VAT_REGISTRATION_NUM, BILL_TO_LOCATION_ID, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, CITY, BUSINESS_COUNTRY, PRIMARY_PHONE_EXTENSION, PRIMARY_PHONE_NUMBER, DUNS_NUMBER_C, TAX_REFERENCE, PO_DATE, STOCK_CODE, DESCRIPTION, UOM, sum(QUANTITY) QUANTITY , TAXABLE_FLAG, PERCENTAGE_RATE, UPRICE, --AMT, PO_HEADER_ID, --LINE_NUM, LOCATION_ID, LOCATION_CODE, DESCRIPTION1, ADDRESS_LINE_1, ADDRESS_LINE_11, ADDRESS_LINE_2, ADDRESS_LINE_3, TOWN_OR_CITY, BILL, BILL_CODE, BILL_DESCRIPTION, BILLADD1, BILLADD2, BILLADD3, BILLTOWN, TEL, LOCATIONFAX, TAX_REFERENCE1, DUNS_NUMBER_C1, COUNTRY, ORGNAME, ORG_ORG_ID, ORG_LOCATION_CODE, ORG_DESCRIPTION, ORG_ADDRESS1, ORG_ADDRESS2, ORG_CITY, ORG_TEL_NO, ORG_FAX, sum(NET_AMOUNT) NET_AMOUNT, sum(UNIT_PRICE) UNIT_PRICE, ROUND(sum(TAX_GROSS), 2) TAX_GROSS, :P_CONC_REQUEST_ID, DECODE (MAX(BUYER_MAIL), NULL, EMAIL_ADDRESS, EMAIL_ADDRESS || ', ' || MAX(BUYER_MAIL)) EMAIL_ADDRESS, COPYEMAIL from( SELECT "A".*, :P_CONC_REQUEST_ID, LISTAGG(replace(hcpe.email_address, ';', ', ') , ', ') WITHIN GROUP (ORDER BY "A".party_id) email_address, 'kima.achadoo@agileum.com, Pravin.Hauzaree@bdo.mu, Pradha.Luchun@agileum.com' copyemail from( select a.*, b.*, c.*, --d.*, e.*, --replace(hcpe.email_address, ';', ', ') email_address, --f.email_address, a.Uprice*a.quantity net_amount, /*CASE WHEN a.vendor_name = d.name THEN a.DUNS_NUMBER_C ELSE d.DUNS_NUMBER_C1 END as BILL_DUNS, case WHEN d.NAME = a.VENDOR_NAME THEN a.TAX_REFERENCE else d.TAX_REFERENCE1 END BILL_TAX, */ case when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'N' and a.taxable_flag = 'N' then a.Uprice when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'Y' and a.taxable_flag = 'Y' then a.Uprice + (a.Uprice*(a.PERCENTAGE_RATE/100)) when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'N' and a.taxable_flag = 'Y' then a.Uprice when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'Y' and a.taxable_flag = 'N' then a.Uprice else a.Uprice + (a.Uprice*(a.PERCENTAGE_RATE/100)) end as Unit_Price, case when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'N' and a.taxable_flag = 'N' then (a.quantity*a.Uprice) when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'Y' and a.taxable_flag = 'Y' then a.quantity*( a.Uprice + (a.Uprice*(a.PERCENTAGE_RATE/100))) when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'N' and a.taxable_flag = 'Y' then a.quantity*a.Uprice when nvl(a.AUTO_TAX_CALC_FLAG, 'N') = 'Y' and a.taxable_flag = 'N' then a.quantity*a.Uprice else a.quantity*( a.Uprice + (a.Uprice*(a.PERCENTAGE_RATE/100))) end as TAX_GROSS from ( Select --replace(assa.email_address, ';', ', ') as EMAIL_ADDRESS, poa.attribute15, poa.currency_code, aps.party_id, plla.ship_to_location_id shipping_loc, aps.vendor_id, assa.auto_tax_calc_flag, to_date(sysdate, 'dd/mm/yy') today_date, trunc(plla.NEED_BY_DATE) NEED_BY_DATE , pla.org_id, PLA.NOTE_TO_VENDOR, MSIF.LONG_DESCRIPTION, msi.ITEM_TYPE, pda.deliver_to_location_id, Poa.Segment1 Po_Num, Poa.Segment1 Po_Num_2, assa.phone, assa.fax, pda.DESTINATION_SUBINVENTORY, pda.DESTINATION_TYPE_CODE, pda.DESTINATION_ORGANIZATION_ID , Aps.Segment1 Vendor_Num , Aps.Vendor_Name, aps.vat_registration_num, assa.bill_to_location_id , Assa.Address_Line1 , Assa.Address_Line2 , Assa.Address_Line3 , Assa.City, case when ASSA.COUNTRY = 'MU' or ASSA.COUNTRY = 'Mauritius' then 'Mauritius' else (select distinct initcap(t.NLS_TERRITORY) from fnd_territories t where t.TERRITORY_CODE=ASSA.COUNTRY) end Business_country, hzp.PRIMARY_PHONE_EXTENSION, hzp.PRIMARY_PHONE_NUMBER, hzp.duns_number_c, hzp.TAX_REFERENCE, To_Char(Poa.Creation_Date, 'Dd/Mm/YYYY') Po_Date, Msi.Segment1 Stock_Code, Pla.ITEM_Description Description, Pla.Unit_Meas_Lo okup_Code Uom, SUM(Pda.QUANTITY_ORDERED) Quantity , msi.taxable_flag, nvl(zrb.PERCENTAGE_RATE, 0) PERCENTAGE_RATE, max(per_people.office_number) buyer_mail, Pla.Unit_Price Uprice, Trim(To_Char(Round(decode(msi.taxable_flag, 'N', (Pda.QUANTITY_ORDERED*Pla.Unit_Price), Pda.QUANTITY_ORDERED*(Pla.Unit_Price + (Pla.Unit_Price*(zrb.PERCENTAGE_RATE/100)))), 2), '99999999999999.99')) Amt, Poa.Po_header_id Po_header_id, Pla.line_num line_num --null PO_RELEASE_ID From Po_Headers_All Poa, po_distributions_all pda, Po_Lines_All Pla, Ap_Suppliers Aps, Ap_Supplier_Sites_All Assa, Mtl_System_Items Msi , PO_LINE_LOCATIONS_ALL plla, MTL_SYSTEM_ITEMS_FVL MSIF, hz_parties hzp, ZX_RATES_B zrb, (select per.office_number, per.person_id from per_people_f per where trunc(sysdate) between trunc(per.EFFECTIVE_START_DATE) and trunc(per.EFFECTIVE_END_DATE)) per_people Where Poa.Po_Header_Id=Pla.Po_Header_Id And Poa.Vendor_Id=Aps.Vendor_Id And Aps.Vendor_Id=Assa.Vendor_Id and msi.INVENTORY_ITEM_ID = pla.item_id and pla.po_line_id = pda.po_line_id and poa.vendor_site_id = assa.vendor_site_id and pda.LINE_LOCATION_ID = plla.LINE_LOCATION_ID and pda.po_line_id = pla.po_line_id and aps.PARTY_ID = hzp.PARTY_ID and pda.DESTINATION_ORGANIZATION_ID = msi.organization_id and pda.DESTINATION_ORGANIZATION_ID = msif.organization_id AND MSIF.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID and zrb.TAX_RATE_CODE (+)= msi.purchasing_tax_code And (PLA.CANCEL_FLAG is null or PLA.CANCEL_FLAG ='N') and poa.agent_id=per_people.person_id(+) --And Poa.Segment1 between decode(instr(:Po_Num, '-'), 0, TO_NUMBER(:Po_Num), null) and decode(instr(:Po_Num_to, '-'), 0, TO_NUMBER(:Po_Num_to), null) And Poa.Approved_Flag='Y' And Poa.TYPE_LOOKUP_CODE like '%STANDARD%' --and aps.party_id=17120 group by aps.vat_registration_num, poa.currency_code, poa.attribute15, plla.NEED_BY_DATE, pla.org_id, PLA.NOTE_TO_VENDOR, MSIF.LONG_DESCRIPTION, msi.ITEM_TYPE, pda.deliver_to_location_id, Poa.Segment1, assa.phone, assa.fax, pda.DESTINATION_SUBINVENTORY, pda.DESTINATION_TYPE_CODE, pda.DESTINATION_ORGANIZATION_ID , Aps.Segment1 , Aps.Vendor_Name, assa.bill_to_location_id , Assa.Address_Line1 , Assa.Address_Line2 , Assa.Address_Line3 , Assa.City, ASSA.COUNTRY, --t.TERRITORY_CODE, hzp.PRIMARY_PHONE_EXTENSION, hzp.PRIMARY_PHONE_NUMBER, hzp.duns_number_c, hzp.TAX_REFERENCE, Poa.Creation_Date, Msi.Segment1, Pla.ITEM_Description , Pla.Unit_Meas_Lookup_Code , msi.taxable_flag, zrb.PERCENTAGE_RATE, Pla.Unit_Price , Pla.Unit_Price, Pda.QUANTITY_ORDERED, Pla.Unit_Price, zrb.PERCENTAGE_RATE, Pda.QUANTITY_ORDERED, msi.taxable_flag, Poa.Po_header_id , Pla.line_num, aps.vendor_id, assa.email_address, plla.ship_to_location_id, assa.auto_tax_calc_flag, aps.party_id) a, (select hrl.LOCATION_ID, hrl.LOCATION_CODE, hrl.DESCRIPTION DESCRIPTION1, hrl.ADDRESS_LINE_1, hrl.ADDRESS_LINE_1 ADDRESS_LINE_11, hrl.ADDRESS_LINE_2, hrl.ADDRESS_LINE_3, hrl.TOWN_OR_CITY from hr_locations hrl)b, (select hrz.LOCATION_ID bill, hrz.LOCATION_CODE bill_code, hrz.DESCRIPTION bill_description, hrz.ADDRESS_LINE_1 billadd1, hrz.ADDRESS_LINE_2 billadd2, hrz.ADDRESS_LINE_3 billadd3, hrz.TOWN_OR_CITY billtown, TELEPHONE_NUMBER_1 Tel, TELEPHONE_NUMBER_2 LocationFax, case when hrz.COUNTRY = 'MU' or hrz.COUNTRY = 'Mauritius' then 'Mauritius' else initcap(t.NLS_TERRITORY) end country from hr_locations hrz, fnd_territories t where t.TERRITORY_CODE(+)=hrz.COUNTRY) c , (select hou1.NAME orgname, hou1.ORGANIZATION_ID org_org_id, hrl.LOCATION_CODE org_location_code, hrl.DESCRIPTION org_description, hrl.ADDRESS_LINE_1 org_address1, hrl.ADDRESS_LINE_2 org_address2, hrl.TOWN_OR_CITY org_city, hrl.TELEPHONE_NUMBER_1 org_tel_no, hrl.TELEPHONE_NUMBER_2 org_fax , hrl.region_2 Tax_reference1, hrl.region_3 DUNS_NUMBER_C1 from hr_locations_V hrl, hr_organization_units hou1 where hou1.LOCATION_ID = hrl.location_id --and ORGANIZATION_ID = 125 )e where --a.party_id=aps.party_id a.shipping_loc = b.location_ id(+) --and a.party_id=f.party_id and a.BILL_TO_LOCATION_ID = c.bill --and a.org_id = d.organization_id and a.org_id = e.org_org_id--organization_id --order by (a.PO_NUM) asc ) "A", hz_relationships hr, hz_contact_points hcpe, hz_parties hp where hr.object_id = hp.party_id(+) AND hcpe.owner_table_id(+) = hr.party_id and "A".party_id=hr.subject_id(+) and hcpe.OWNER_TABLE_NAME ='HZ_PARTIES' and hcpe.status='A' --and hr.party_id=17111 and "A".attribute15 ='S' -- and po_num='15008531' -- and hcpe.email_address like 'niraj%'-- --, 'kima%' group by "A".attribute15, "A".PARTY_ID, VENDOR_ID, AUTO_TAX_CALC_FLAG, TODAY_DATE, NEED_BY_DATE, ORG_ID, NOTE_TO_VENDOR, LONG_DESCRIPTION, ITEM_TYPE, DELIVER_TO_LOCATION_ID, PO_NUM, PHONE, FAX, DESTINATION_SUBINVENTORY, DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, VENDOR_NUM, VENDOR_NAME, BILL_TO_LOCATION_ID, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, "A".CITY, BUSINESS_COUNTRY, "A".PRIMARY_PHONE_EXTENSION, "A".PRIMARY_PHONE_NUMBER, "A".DUNS_NUMBER_C, "A".TAX_REFERENCE, PO_DATE, STOCK_CODE, DESCRIPTION, UOM, QUANTITY, TAXABLE_FLAG, PERCENTAGE_RATE, UPRICE, AMT, PO_HEADER_ID, LINE_NUM, LOCATION_ID, LOCATION_CODE, DESCRIPTION1, ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, TOWN_OR_CITY, BILL, BILL_CODE, BILL_DESCRIPTION, BILLADD1, BILLADD2, BILLADD3, BILLTOWN, locationFax, Tel, --TELEPHONE_NUMBER_1, --TELEPHONE_NUMBER_2, --ORGANIZATION_ID, "A".COUNTRY, "A".shipping_loc, --NAME, --PRIMARY_PHONE_NUMBER1, --PRIMARY_PHONE_EXTENSION1, DUNS_NUMBER_C1, TAX_REFERENCE1, ORGNAME, ORG_ORG_ID, ORG_LOCATION_CODE, ORG_DESCRIPTION, ORG_ADDRESS1, ORG_ADDRESS2, ORG_CITY, ORG_TEL_NO, ORG_FAX, --EMAIL_ADDRESS, NET_AMOUNT, --BILL_DUNS, --BILL_TAX, UNIT_PRICE, TAX_GROSS, currency_code, vat_registration_num, "A".buyer_mail) group by ATTRIBUTE15, CURRENCY_CODE, PARTY_ID, SHIPPING_LOC, VENDOR_ID, AUTO_TAX_CALC_FLAG, TODAY_DATE, NEED_BY_DATE, ORG_ID, NOTE_TO_VENDOR, LONG_DESCRIPTION, ITEM_TYPE, DELIVER_TO_LOCATION_ID, PO_NUM, PO_NUM_2, PHONE, FAX, DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, VENDOR_NUM, VENDOR_NAME, VAT_REGISTRATION_NUM, BILL_TO_LOCATION_ID, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, CITY, BUSINESS_COUNTRY, PRIMARY_PHONE_EXTENSION, PRIMARY_PHONE_NUMBER, DUNS_NUMBER_C, TAX_REFERENCE, PO_DATE, STOCK_CODE, DESCRIPTION, UOM, --QUANTITY, TAXABLE_FLAG, PERCENTAGE_RATE, UPRICE, --AMT, PO_HEADER_ID, --LINE_NUM, LOCATION_ID, LOCATION_CODE, DESCRIPTION1, ADDRESS_LINE_1, ADDRESS_LINE_11, ADDRESS_LINE_2, ADDRESS_LINE_3, TOWN_OR_CITY, BILL, BILL_CODE, BILL_DESCRIPTION, BILLADD1, BILLADD2, BILLADD3, BILLTOWN, TEL, LOCATIONFAX, TAX_REFERENCE1, DUNS_NUMBER_C1, COUNTRY, ORGNAME, ORG_ORG_ID, ORG_LOCATION_CODE, ORG_DESCRIPTION, ORG_ADDRESS1, ORG_ADDRESS2, ORG_CITY, ORG_TEL_NO, ORG_FAX, EMAIL_ADDRESS, COPYEMAIL
3350m9wncvqvn	select HIERARCHY_TYPE, SITE_ENABLED_FLAG, APP_ENABLED_FLAG, RESP_ENABLED_FLAG, USER_ENABLED_FLAG, SERVER_ENABLED_FLAG, ORG_ENABLED_FLAG, SQL_VALIDATION, SERVERRESP_ENABLED_FLAG from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME = :1
3ff5c8bwgf31t	select node_id from fnd_nodes where server_id = :1
3pbabadc6g0xp	Select Oracle_Process_Id, Queue_Application_Id, Concurrent_Queue_Id, Os_Process_Id, Lk_Handle, Node_Name, Db_Instance, Process_Context, Gsm_Internal_Status From Fnd_Concurrent_Processes Where Concurrent_Process_ID = :cpid And Process_Status_Code in ('A', 'T', 'C', 'P') Order by Node_Name, Db_Instance For Update Of Concurrent_Process_Id
43c5ykm1mcp2a	begin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client_info(:3); dbms_session.set_identifier(:4); end;
4d8w3n5u1mgp3	LOCK TABLE FND_CONCURRENT_PROCESSES IN SHARE UPDATE MODE NOWAIT
4djnjz7ggr3as	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 /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("QT") FULL("QT") NO_PARALLEL_INDEX("QT") */ 1 AS C1, CASE WHEN "QT"."Q_NAME"=:B1 AND "QT"."STATE"=:B2 THEN 1 ELSE 0 END AS C2 FROM "SYSMAN"."MGMT_TASK_QTABLE" "QT") SAMPLESUB
4twxwvtqj9188	SELECT DATA_LENGTH FROM ALL_TAB_COLUMNS WHERE OWNER = 'SYS' AND TABLE_NAME = 'V_$SESSION' AND COLUMN_NAME = :B1
50f8udzy8kzkg	select R.Priority_Request_ID , Decode(R.Parent_Request_ID, null , 0, R.Parent_Request_ID) , R.Priority , R.Has_Sub_Request , R.Is_Sub_Request , R.Resubmit_Time , R.Resubmit_Interval_Type_Code , R.Resubmit_Interval_Unit_Code , R.Resubmit_Interval , TO_CHAR(R.Resubmit_End_Date, 'DD-MON-YYYY HH24:MI:SS') , R.Increment_Dates , R.Nls_Language , R.Nls_Territory , R.Description , R.Req_Information , R.Conc_Login_Id , R.Responsibility_ID , R.Responsibility_Application_ID , R.Program_Application_ID , R.Concurrent_Program_ID , R.Requested_BY , DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N') , NVL(R.SECURITY_GROUP_ID, 0) , R.Number_Of_Copies , R.Save_Output_Flag , R.Printer , R.Print_Style , P.Print_Flag , R.Phase_Code , R.Status_Code , R.Enable_Trace , P.Execution_Method_Code , P.Argument_Method_Code , R.Argument_Input_Method_Code , A.Application_Short_Name , A.Basepath , P.Concurrent_Program_Name , E.Executable_Name , E.Execution_File_Name , A2.Basepath , U.User_Name , O.Oracle_Username , O.Encrypted_Oracle_Password , TO_CHAR(R.Requested_Start_Date, 'DD-MON-RR HH24:MI:SS') , R.Number_Of_Arguments , Decode(E.Execution_File_Name, null , 'N', Decode(E.Subroutine_Name, null , 'N', 'Y')) , R.Print_Group , R.Logfile_Name , R.Outfile_Name , R.Outfile_Node_Name , R.NOTIFY_ON_PP_ERROR , R.Argument1 , R.Argument2 , R.Argument3 , R.Argument4 , R.Argument5 , R.Argument6 , R.Argument7 , R.Argument8 , R.Argument9 , R.Argument10 , R.Argument11 , R.Argument12 , R.Argument13 , R.Argument14 , R.Argument15 , R.Argument16 , R.Argument17 , R.Argument18 , R.Argument19 , R.Argument20 , R.Argument21 , R.Argument22 , R.Argument23 , R.Argument24 , R.Argument25 , X.Argument26 , X.Argument27 , X.Argument28 , X.Argument29 , X.Argument30 , X.Argument31 , X.Argument32 , X.Argument33 , X.Argument34 , X.Argument35 , X.Argument36 , X.Argument37 , X.Argument38 , X.Argument39 , X.Argument40 , X.Argument41 , X.Argument42 , X.Argument43 , X.Argument44 , X.Argument45 , X.Argument46 , X.Argument47 , X.Argument48 , X.Argument49 , X.Argument50 , X.Argument51 , X.Argument52 , X.Argument53 , X.Argument54 , X.Argument55 , X.Argument56 , X.Argument57 , X.Argument58 , X.Argument59 , X.Argument60 , X.Argument61 , X.Argument62 , X.Argument63 , X.Argument64 , X.Argument65 , X.Argument66 , X.Argument67 , X.Argument68 , X.Argument69 , X.Argument70 , X.Argument71 , X.Argument72 , X.Argument73 , X.Argument74 , X.Argument75 , X.Argument76 , X.Argument77 , X.Argument78 , X.Argument79 , X.Argument80 , X.Argument81 , X.Argument82 , X.Argument83 , X.Argument84 , X.Argument85 , X.Argument86 , X.Argument87 , X.Argument88 , X.Argument89 , X.Argument90 , X.Argument91 , X.Argument92 , X.Argument93 , X.Argument94 , X.Argument95 , X.Argument96 , X.Argument97 , X.Argument98 , X.Argument99 , X.Argument100 , NVL(R.org_id, 0) from Fnd_Concurrent_Requests R , Fnd_Concurrent_Programs P , Fnd_Application A , Fnd_User U , Fnd_Oracle_Userid O , Fnd_Application A2 , Fnd_Executables E , Fnd_Conc_Request_Arguments X where (((((((R.Request_ID=:afpreqid and R.Request_ID=X.Request_ID(+)) and (R.Concurrent_Program_ID=P.Concurrent_Program_Id and R.Program_Application_ID=P.application_ID)) and R.Program_Application_ID=A.Application_ID) and (P.Executable_ID=E.Executable_Id and P.Executable_Application_ID=E.Application_ID)) and P.Executable_Application_ID=A2.Application_ID) and R.Oracle_ID=O.Oracle_ID) and R.Requested_BY=U.User_ID)
52051drvkvhwd	select ba.baseline_name, b.timegrouping from dbsnmp.bsln_baselines b, dba_hist_baseline ba where b.baseline_id = ba.baseline_id and b.instance_name = :1 and b.dbid = :2
595qpkr7b4a4t	SELECT NLS_CHARSET_NAME(:B1 ) FROM SYS.DUAL
5as61q63aqmts	SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1
5fk0v8km2f811	select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5qp95achdvbcp	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((201, 45109))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
5xcqgzcxb958t	SELECT S.ROWID ROW_ID FROM WF_ITEM_ACTIVITY_STATUSES S WHERE S.DUE_DATE < SYSDATE AND S.ACTIVITY_STATUS IN ('ACTIVE', 'WAITING', 'NOTIFIED', 'SUSPEND', 'DEFERRED')
6129566gyvx21	SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
694w9s58u0bkp	Select R.Priority_Request_ID, Decode(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority, R.Has_Sub_Request, R.Is_Sub_Request, R.Nls_Language, R.Nls_Territory, R.Conc_Login_Id, R.Responsibility_ID, R.Responsibility_Application_ID, R.Program_Application_ID, R.Concurrent_Program_ID, R.Requested_BY, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), NVL(R.SECURITY_GROUP_ID, 0), R.Save_Output_Flag, R.Phase_Code, R.Status_Code, R.Enable_Trace, A.Application_Short_Name, P.Concurrent_Program_Name, U.User_Name, R.Number_Of_Arguments, R.Logfile_Name, R.Outfile_Name, R.REQ_INFORMATION, R.Logfile_Node_Name, R.Outfile_Node_Name, R.Nls_numeric_characters, R.Nls_codeset, R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100 FROM Fnd_Concurrent_Requests R, Fnd_Concurrent_Programs P, Fnd_Application A, Fnd_User U, Fnd_Conc_Request_Arguments X WHERE R.Request_ID = X.Request_ID(+) And ( R.Concurrent_Program_ID = P.Concurrent_Program_Id and R.Program_Application_ID = P.application_ID ) And R.Program_Application_ID = A.Application_ID And R.Requested_BY = U.User_ID And R.Request_ID = :1
6b9frvkw310fp	declare l_return_status VARCHAR2 ( 1 ) ; BEGIN CST_CostProcValidation_PVT . Validate_Transactions ( l_return_status ) ; IF l_return_status <> FND_API . G_RET_STS_SUCCESS THEN :l_validation_error := 1 ; END IF ; END ;
6k5agh28pr3wp	select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6ztvrmu012ypd	update FND_CONCURRENT_REQUESTS set PHASE_CODE='R', STATUS_CODE='R', ACTUAL_START_DATE=nvl(actual_start_date, SYSDATE), CONTROLLING_MANAGER=:b0, LOGFILE_NAME=:b1, OUTFILE_NAME=:b2, LOGFILE_NODE_NAME=:b3, OUTFILE_NODE_NAME=:b3, NLS_CodeSet=substr(userenv('LANGUAGE'), (instr(userenv('LANGUAGE'), '.')+1)), LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b5 where ROWID=:b6
76c447p662hur	INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ORG_ID, NODE_NAME1, CONNSTR1, RECALC_PARAMETERS, EDITION_NAME, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B78 , :B77 , :B76 , DECODE (:B75 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B57 , 'Y', 'Q', DECODE(:B38 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B74 , NULL, 50, :B74 )), DECODE (:B66 , 0, NULL, :B66 ), :B73 , :B72 , NULL, :B71 , 'N', :B70 , :B69 , 'Y', :B57 , 'S', :B68 , SYSDATE, DECODE (:B67 , '', (SYSDATE - :B65 ), GREATEST (:B67 , DECODE (:B66 , 0, (SYSDATE - :B65 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B64 , SYSDATE, :B64 , :B63 , ORACLE_ID, :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B38 , 'Y', 'B', DECODE(:B57 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , DECODE (:B50 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B50 ), 'HH24:MI:SS')), DECODE (:B49 , '', NULL, :B49 ), :B48 , :B47 , :B46 , 'N', :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B39 , :B38 , :B37 , DECODE(:B36 , 'Y', 'Y', FCP.ENABLE_TRACE), :B35 , :B34 , :B33 , :B32 , :B31 , SYS_CONTEXT('userenv', 'current_edition_name'), :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
77zr3gn0qv5nt	/* OracleOEM */ select apply_name, s.num_msgs num_msgs, q.spill_msgs spill_msgs, s.cnum_msgs cnum_msgs, q.cspill_msgs cspill_msgs from dba_apply a, gv$buffered_queues q, gv$buffered_subscribers s, dba_queues d, dba_queue_tables t where a.queue_name = s.queue_name and a.queue_owner = s.queue_schema and a.queue_name = q.queue_name and a.queue_owner = q.queue_schema and a.apply_name = s.subscriber_name and s.subscriber_address is null and a.queue_owner = d.owner and a.queue_name = d.name and d.queue_table = t.queue_table and q.inst_id = s.inst_id and q.inst_id = t.owner_instance
7rcjfc2rg1sw4	update fnd_concurrent_queues set work_end = sysdate, LAST_UPDATE_DATE = sysdate, Last_Updated_By = :mgrusrid where Application_ID = 0 AND CONCURRENT_QUEUE_ID=5
7s6zxa6zc6c1x	SELECT /*+ leading (S.S S.W S.E P) use_nl(S.S. S.W S.E P) opt_param('_optimizer_sortmerge_join_enabled', 'FALSE') */ P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.SID = :B2 AND P.PID = :B1
7wt7phk4xns75	select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
8g44f2hva5hhb	SELECT HR.ORGANIZATION_ID ORGANIZATION_ID , HR.NAME NAME FROM HR_OPERATING_UNITS HR WHERE HR.BUSINESS_GROUP_ID = :B1 AND HR.USABLE_FLAG IS NULL
8m2tu4r76nchq	SELECT value FROM v$parameter WHERE lower(name) = 'resource_limit'
8u809k64x3nzd	begin DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
8yujfb6samwvg	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((201, 45109)) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((200, 57329), (200, 57332), (200, 57338), (200, 57339), (200, 57343), (200, 57345), (201, 57335), (201, 57340), (201, 57346), (201, 57347), (201, 60330), (201, 60331), (201, 64367), (222, 57330), (603, 48616)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
95w5r9gccgbpd	SELECT FND_CONCURRENT_REQUESTS_S.NEXTVAL FROM SYS.DUAL
98j69vs3ymzjv	SELECT DECODE(:B2 , 'UTF8', FL.UTF8_DATE_LANGUAGE, 'AL32UTF8', FL.UTF8_DATE_LANGUAGE, FL.LOCAL_DATE_LANGUAGE ) DATA_RTN FROM FND_LANGUAGES FL WHERE FL.NLS_LANGUAGE = :B1 AND FL.INSTALLED_FLAG <>'D'
9juw6s4yy5pzp	/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
9kh7pgzdns9ts	SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, 0) FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((101, 56329), (101, 58330), (200, 57329), (200, 57332), (200, 57338), (200, 57339), (200, 57343), (200, 57345), (201, 45109), (201, 57335), (201, 57340), (201, 57346), (201, 57347), (201, 60330), (201, 60331), (201, 64367), (222, 57330), (510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494), (603, 48616))) FOR UPDATE OF R.status_code NoWait
9mbft6x06na4x	select /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) +*/ TO_CHAR(min(transaction_date), 'YYYY/MM/DD HH24:MI:SS') into :b0 from mtl_material_transactions MMT where ((((nvl(parent_transaction_id, transaction_id)=transaction_id or (nvl(parent_transaction_id, transaction_id)<>transaction_id and transaction_action_id in (15, 22))) or ((((parent_transaction_id is not null and parent_transaction_id<>transaction_id) and transaction_action_id=17) and transaction_source_type_id=7) and 1=(select MOD(sum(DECODE(MP.process_enabled_flag, 'Y', 1, 2)), 2) from mtl_parameters mp where (mp.organization_id=mmt.organization_id or mp.organization_id=mmt.transfer_organization_id)))) and costed_flag in ('N', 'E')) and (((organization_id=:b1 and ((costed_flag='E' or (nvl(logical_transactions_created, 1)=2 or exists (select null from mtl_material_transactions_temp MMTP where ((MMT.transaction_action_id in (30, 31) and MMT.organization_id=MMTP.organization_id) and (MMT.COMPLETION_TRANSACTION_ID=MMTP.COMPLETION_TRANSACTION_ID or MMT.MOVE_TRANSACTION_ID=MMTP.move_transaction_id)) union all select null from wip_move_txn_interface WMTI where (MMT.transaction_action_id in (30, 31) and WMTI.TRANSACTION_ID=MMT.MOVE_TRANSACTION_ID)))) or (costed_flag='N' and (exists (select null from mtl_parameters where ((organization_id=MMT.transfer_organization_id and primary_cost_method in (2, 5, 6)) and process_enabled_flag='N')) and (((transaction_action_id=3 and primary_quantity>0) and transaction_cost is null ) or exists (select null from mtl_interorg_parameters MIP where ((((transaction_action_id=12 and MIP.to_organization_id=MMT.organization_id) and MIP.from_organization_id=MMT.transfer_organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2) and shipment_costed is null ))))))) or ((transfer_organization_id=:b1 and costed_flag='N') and (exists (select null from mtl_interorg_parameters MIP where (((((transaction_action_id=21 and MIP.to_organization_id=MMT.transfer_organization_id) and MIP.from_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=1) and shipment_costed is null ) and exists (select null from mtl_parameters where (organization_id=MMT.organization_id and primary_cost_method in (2, 5, 6))))) or (exists (select null from mtl_parameters where (((organization_id=MMT.organization_id and primary_cost_method=1) and cost_cutoff_date is not null ) and MMT.transaction_date>=cost_cutoff_date)) and (transaction_action_id=3 and primary_quantity<0))))) or ((costed_flag='N' and exists (select null from mtl_interorg_parameters MIP where ((((transaction_action_id in (21, 15) and MIP.to_organization_id=MMT.transfer_organization_id) and MIP.from_organization_id=MMT.organization_id) and NVL(MMT.fob_point, MIP.fob_point)=1) or (((transaction_action_id in (12, 22) and MIP.to_organization_id=MMT.organization_id) and MIP.from_organization_id=MMT.transfer_organization_id) and NVL(MMT.fob_point, MIP.fob_point)=2)))) and exists (select null from mtl_parameters where (((primary_cost_method=1 and cost_cutoff_date is not null ) and MMT.transaction_date>=cost_cutoff_date) and (((MMT.organization_id=:b1 and organization_id=MMT.transfer_organization_id) and process_enabled_flag='N') or (MMT.transfer_organization_id=:b1 and organization_id=MMT.organization_id)))))))
9pvbjqqt222b4	select o.owner#, o.obj#, decode(o.linkname, null, decode(u.name, null, 'SYS', u.name), o.remoteowner), o.name, o.linkname, o.namespace, o.subname, o.type# from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#)
9t6cn12dxp62s	SELECT PATH_DOCID FROM JDR_PATHS paths, JDR_ATTRIBUTES WHERE ROWNUM=1 AND PATH_NAME=:1 AND PATH_DOCID=ATT_COMP_DOCID AND ATT_COMP_SEQ=0 AND ATT_NAME='customizes' AND ATT_VALUE= :2 AND EXISTS (SELECT PATH_NAME FROM JDR_PATHS WHERE PATH_DOCID in (SELECT PATH_OWNER_DOCID FROM JDR_PATHS WHERE PATH_NAME=:3 START WITH PATH_DOCID =paths.PATH_DOCID CONNECT BY PRIOR PATH_OWNER_DOCID=PATH_DOCID) AND PATH_NAME='customizations')
9vkcgv9hzhw85	SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.ENABLE_TRACE), UPPER(R.ENABLE_TRACE), DECODE(UPPER(P.ENABLE_TIME_STATISTICS), 'Y', 'TRUE', NULL), EXECUTION_METHOD_CODE, MULTI_ORG_CATEGORY, ORG_ID, P.APPLICATION_ID FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID AND P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
9xpj978rhdprv	select count(*) from all_objects " sys$alias1" where " sys$alias1".owner = :1 and " sys$alias1".object_name = :2
a4ct9tx8f9d4a	begin execute immediate 'alter session set NLS_NUMERIC_CHARACTERS = ''., '''; end;
a4gss3ajbyfzr	SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1
a5pyncg7v0bw3	/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
a8j39qb13tqkr	SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_FINDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
ak5crjygnpk60	UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION = SYSDATE + (:B1 /86400) WHERE ROWID = :B2
amjk7qdaq37s0	SELECT R.RESPONSIBILITY_KEY FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1
at2h5x34yj2c4	SELECT NLS_CHARSET_ID(:B1 ) FROM SYS.DUAL
au7f6hpnhxpkx	select ts# from ts$ where dflmaxext =:1 and bitand(flags, 1024) =1024 and online$=1
b1cp8pancvaaf	SELECT NVL(MPI.STATUS, 'N') FROM FND_MO_PRODUCT_INIT MPI WHERE MPI.APPLICATION_SHORT_NAME = :B1
b6mcn03jvfq41	SELECT /*+ ORDERED USE_NL (WIASP WI WPAP WAP) INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */ WIASP.ROWID ROW_ID FROM WF_ITEM_ACTIVITY_STATUSES WIASP, WF_ITEMS WI, WF_PROCESS_ACTIVITIES WPAP, WF_ACTIVITIES WAP WHERE WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID AND WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE AND WPAP.ACTIVITY_NAME = WAP.NAME AND WIASP.ITEM_TYPE = WI.ITEM_TYPE AND WIASP.ITEM_KEY = WI.ITEM_KEY AND WI.BEGIN_DATE >= WAP.BEGIN_DATE AND WI.BEGIN_DATE < NVL(WAP.END_DATE, WI.BEGIN_DATE+1) AND WAP.TYPE = 'PROCESS' AND WIASP.ACTIVITY_STATUS = 'ACTIVE' AND NOT EXISTS (SELECT NULL FROM WF_ITEM_ACTIVITY_STATUSES WIASC, WF_PROCESS_ACTIVITIES WPAC WHERE WAP.ITEM_TYPE = WPAC.PROCESS_ITEM_TYPE AND WAP.NAME = WPAC.PROCESS_NAME AND WAP.VERSION = WPAC.PROCESS_VERSION AND WPAC.INSTANCE_ID = WIASC.PROCESS_ACTIVITY AND WIASC.ITEM_TYPE = DECODE(WAP.DIRECTION, WAP.DIRECTION, WI.ITEM_TYPE, WI.ITEM_TYPE) AND WIASC.ITEM_KEY = WI.ITEM_KEY AND WIASC.ACTIVITY_STATUS IN ('ACTIVE', 'NOTIFIED', 'SUSPEND', 'DEFERRED', 'ERROR'))
bazquck2vuvm1	SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID
bt4ks8gt2rwf8	SELECT NVL(RESOURCE_CONSUMER_GROUP, 'DEFAULT_CONSUMER_GROUP') FROM FND_CONCURRENT_QUEUES WHERE CONCURRENT_QUEUE_ID = :B2 AND APPLICATION_ID = :B1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c1yjc80hbku2c	BEGIN :v_status := FND_CONCURRENT_BUSINESS_EVENT.RAISE_CP_BI_EVENT(:v_reqid, fnd_concurrent_business_event.REQUEST_RUNNING); END;
cb21bacyh3c7d	select metadata from kopm$ where name='DB_FDO'
cbbug6a8grfnf	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((101, 56329), (101, 58330))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cwtbbnt1g8h51	update MTL_TRANSACTIONS_INTERFACE MTI set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG=1, ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG=1 and NVL(LOCK_FLAG, 2)=2) and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 'X' from MTL_TRANSACTION_TYPES MTT where (MTT.TRANSACTION_TYPE_ID=MTI.TRANSACTION_TYPE_ID and MTT.TRANSACTION_SOURCE_TYPE_ID=5))) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MTI.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
d17m78gkh6p93	SELECT Q.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_QUEUES Q WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND R.CONTROLLING_MANAGER = P.CONCURRENT_PROCESS_ID AND Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID AND Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID
d8mayxqw0wnpv	SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
dawf7hvg1ym94	select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
f0jxh8d6b5af2	/* OracleOEM */ select a.capture_name capture_name, total_messages_captured, total_messages_enqueued from gv$streams_capture a, dba_capture b, dba_queues c, dba_queue_tables d where a.capture_name = b.capture_name and b.queue_name=c.name and b.queue_owner=c.owner and c.queue_table=d.queue_table and c.owner=d.owner and d.owner_instance=a.inst_id
f1z9p2hbvv32j	SELECT RCV_TRANSACTIONS_INTERFACE.*, ROWID ROW_ID, :B11 UNIT_OF_MEASURE_CLASS, :B10 SHIP_TO_ORGANIZATION_ID, :B9 RECEIPT_DAYS_EXCEPTION_CODE, :B8 , :B7 , :B6 ERROR_STATUS, :B5 ERROR_MESSAGE, :B4 DERIVE, :B3 DERIVE_INDEX FROM RCV_TRANSACTIONS_INTERFACE WHERE (PROCESSING_REQUEST_ID = :B2 ) AND (GROUP_ID = :B1 OR :B1 = 0) AND PROCESSING_STATUS_CODE IN ('RUNNING') AND NVL(VALIDATION_FLAG, 'N') = 'Y' ORDER BY ORDER_TRANSACTION_ID, INTERFACE_TRANSACTION_ID ASC
f288ub87mchyj	SELECT STAT_COLLECT FROM FND_CONCURRENT_PROGRAMS WHERE CONCURRENT_PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID AND APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
f4a41m16pm7zg	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((101, 56329), (101, 58330), (200, 57329), (200, 57332), (200, 57338), (200, 57339), (200, 57343), (200, 57345), (201, 45109), (201, 57335), (201, 57340), (201, 57346), (201, 57347), (201, 60330), (201, 60331), (201, 64367), (222, 57330), (510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494), (603, 48616))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
fdusc2rgnuhuj	UPDATE FND_CONCURRENT_PROCESSES SET PROCESS_STATUS_CODE = 'A', OS_PROCESS_ID = :ospid, ORACLE_PROCESS_ID = :opid, SESSION_ID = :osid, LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :mgrusrid, LAST_TXN_END = SYSDATE, DB_INSTANCE = (Select instance_name from v$instance), INSTANCE_NUMBER = (Select instance_number from v$instance) WHERE PROCESS_STATUS_CODE IN ('A', 'C') AND CONCURRENT_PROCESS_ID = :cpid
ffuf485g4tj0s	select count(*) from resource_consumer_group$ where name = :1 and internal_use = 1 and status = 'ACTIVE'
fjvwzpxbpch0h	/* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
fmfdkztk8vx23	SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
gdhprruufmc50	SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = FND_GLOBAL.SERVER_ID
gfj6wznuj14u1	insert into Fnd_Concurrent_Requests (Request_Id, Priority_Request_ID, Last_Update_Date, Last_Updated_By, Last_Update_Login, ops_instance, Hold_Flag, Requested_Start_Date, Enforce_Seriality_Flag, Single_Thread_Flag, Request_Date, Requested_By, Number_Of_Copies, Save_Output_Flag, Argument_Input_Method_Code, Priority, Printer, Program_Application_Id, Concurrent_Program_Id, Queue_Method_Code, Request_Class_Application_Id, Concurrent_Request_Class_Id, Oracle_Id, Number_Of_Arguments, Phase_Code, Status_Code, Conc_Login_Id, Responsibility_Id, Responsibility_Application_Id, Nls_Language, Nls_Territory, Nls_numeric_characters, CRM_THRSHLD, Resubmit_Time, Resubmit_Interval, Resubmit_Interval_Unit_Code, Resubmit_Interval_Type_Code, Resubmit_End_Date, Increment_Dates, Resubmitted, Parent_Request_ID, Description, Req_Information, Is_Sub_Request, Has_Sub_Request, Update_Protected, Implicit_Code, Print_Group, Argument_Text, Print_Style, output_file_type, Nls_Compliant, Request_Type, CD_ID, Request_Limit, Enable_Trace, Security_Group_ID, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, ROOT_REQUEST_ID, Argument1, Argument2, Argument3, Argument4, Argument5, Argument6, Argument7, Argument8, Argument9, Argument10, Argument11, Argument12, Argument13, Argument14, Argument15, Argument16, Argument17, Argument18, Argument19, Argument20, Argument21, Argument22, Argument23, Argument24, Argument25, org_id, node_name1, connstr1, edition_name, recalc_parameters)select :b0 , :b1 , SYSDATE , :b2 , :b3 , :b4 , :b5 , Decode(:b6, '', (SYSDATE-:b7), Greatest(To_Date(:b6, 'YYYY/MM/DD HH24:MI:SS'), Decode(:b9, 0, (SYSDATE-:b7), To_Date('01-01-0001', 'DD-MM-YYYY')))) , 'Y' , :b11 , SYSDATE , :b2 , :b13 , Decode(Fcp.Save_Output_Flag, 'N', 'N', :b14) , :b15 , Decode(Fcp.Queue_Control_Flag, 'Y', NVL(Fcp.request_priority, 0), NVL(Fcp.request_priority, :b16)) , :b17 , Fa.APPLICATION_ID , CONCURRENT_PROGRAM_ID , Decode(:b18, 'Y', 'B', Decode(:b11, 'Y', 'B', QUEUE_METHOD_CODE)) , CLASS_APPLICATION_ID , CONCURRENT_CLASS_ID , ORACLE_ID , :b20 , :b21 , Decode(:b22, 'A', 'A', 'Z', 'Z', Decode(:b23, 'X', 'P', Decode(Queue_Method_Code, 'B', 'Q', Decode(:b11, 'Y', 'Q', Decode(:b18, 'Y', 'Q', 'I'))))) , :b26 , :b27 , :b28 , :b29 , :b30 , Decode(:b31, '', null , :b31) , :b33 , Decode(:b34, '', null , To_Char(To_Date(:b34, Decode(Instr(:b34, ':', 1, 2), 0, 'HH24:MI', 'HH24:MI:SS')), 'HH24:MI:SS')) , Decode(:b37, '', Decode(:b38, (-1), null , :b38), To_Number(:b37)) , :b41 , :b42 , To_Date(Decode(:b43, '', null , :b43), 'YYYY/MM/DD HH24:MI:SS') , :b45 , 'N' , Decode(:b9, 0, null , :b9) , :b48 , null , :b49 , 'N' , :b50 , :b51 , :b52 , :b53 , :b54 , Fcp.Output_File_Type , FCP.Nls_Compliant , Decode(:b55, '0', null , :b55) , :b57 , :b18 , Fcp.Enable_Trace , :b59 , :b60 , Decode(:b61, 0, Decode(:b23, 'P', :b63, null ), :b61) , Decode(:b65, 0, null , :b65) , :b67 , :b68 , :b69 , :b70 , :b71 , :b72 , :b73 , :b74 , :b75 , :b76 , :b77 , :b78 , :b79 , :b80 , :b81 , :b82 , :b83 , :b84 , :b85 , :b86 , :b87 , :b88 , :b89 , :b90 , :b91 , :b92 , decode(:b93, 'NULL', null , :b93) , decode(:b95, 'NULL', null , :b95) , sys_context('userenv', 'current_edition_name') , :b97 from FND_CONCURRENT_PROGRAMS Fcp , FND_ORACLE_USERID , FND_APPLICATION Fa where (((ORACLE_USERNAME=:b98 and Fcp.Enabled_Flag='Y') and (Fcp.APPLICATION_ID=Fa.Application_ID and CONCURRENT_PROGRAM_NAME=:b99)) and Fa.APPLICATION_SHORT_NAME=:b100)
grwydz59pu6mc	select text from view$ where rowid=:1
gwv7ftmfctxf2	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), COUNT(DISTINCT C3), NVL(SUM(CASE WHEN C3 IS NULL THEN 1 ELSE 0 END), 0) FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("QT") FULL("QT") NO_PARALLEL_INDEX("QT") */ 1 AS C1, CASE WHEN "QT"."Q_NAME"=:B1 AND "QT"."STATE"=:B2 THEN 1 ELSE 0 END AS C2, "QT"."Q_NAME" AS C3 FROM "SYSMAN"."MGMT_TASK_QTABLE" "QT") SAMPLESUB
gx9v00vz8mb1g	insert into FND_CONC_PP_ACTIONS (CONCURRENT_REQUEST_ID, ACTION_TYPE, STATUS_S_FLAG, STATUS_W_FLAG, STATUS_F_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, CREATED_BY, PROGRAM_APPLICATION_ID, PROGRAM_ID, ARGUMENTS, COMPLETED, NUMBER_OF_COPIES, SEQUENCE, ORIG_SYSTEM, ORIG_SYSTEM_ID, OPS_INSTANCE, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10)select :b0 , ACTION_TYPE , STATUS_S_FLAG , STATUS_W_FLAG , STATUS_F_FLAG , sysdate , 4 , sysdate , 0 , 4 , PROGRAM_APPLICATION_ID , PROGRAM_ID , ARGUMENTS , 'N' , NUMBER_OF_COPIES , SEQUENCE , ORIG_SYSTEM , ORIG_SYSTEM_ID , OPS_INSTANCE , ARGUMENT1 , ARGUMENT2 , ARGUMENT3 , ARGUMENT4 , ARGUMENT5 , ARGUMENT6 , ARGUMENT7 , ARGUMENT8 , ARGUMENT9 , ARGUMENT10 from fnd_conc_pp_actions fcpa where ((action_type=2 and (fcpa.arguments=(select name from wf_roles wf where (((((wf.EXPIRATION_DATE is null or wf.expiration_date>=sysdate) and wf.partition_id<>1) and fcpa.arguments=wf.name) and fcpa.orig_system=wf.orig_system) and fcpa.orig_system_id=wf.orig_system_id)) or fcpa.arguments=(select name from wf_roles wf , fnd_user fu where ((((((fu.END_DATE is null or fu.end_date>=sysdate) and wf.partition_id=1) and fcpa.arguments=wf.name) and fcpa.arguments=fu.user_name) and fcpa.orig_system=wf.orig_system) and fcpa.orig_system_id=wf.orig_system_id)))) and concurrent_request_id=:b1) union select :b0 , ACTION_TYPE , STATUS_S_FLAG , STATUS_W_FLAG , STATUS_F_FLAG , sysdate , 4 , sysdate , 0 , 4 , PROGRAM_APPLICATION_ID , PROGRAM_ID , ARGUMENTS , 'N' , NUMBER_OF_COPIES , SEQUENCE , ORIG_SYSTEM , ORIG_SYSTEM_ID , OPS_INSTANCE , ARGUMENT1 , ARGUMENT2 , ARGUMENT3 , ARGUMENT4 , ARGUMENT5 , ARGUMENT6 , ARGUMENT7 , ARGUMENT8 , ARGUMENT9 , ARGUMENT10 from fnd_conc_pp_actions fcpa where (action_type<>2 and concurrent_request_id=:b1)
gyp9pgmvwu659	select severity_code, message, b.collection_timestamp, d.value, d.collection_timestamp, c.metric_name, metric_column, b.key_value, c.metric_label, c.column_label, a.target_name, b.message_nlsid, b.message_params, case when c.metric_name != 'adrAlertLogIncidentError' then NULL else (select p.string_value from mgmt_current_metrics p, mgmt_metrics q where p.metric_guid = q.metric_guid and q.metric_name = 'adrAlertLogIncidentError' and q.metric_column = 'impact' and p.key_value = b.key_value and p.target_guid = b.target_guid and q.type_meta_ver = a.type_meta_ver and (q.category_prop_1 = a.category_prop_1 or q.category_prop_1 = ' ') and (q.category_prop_2 = a.category_prop_2 or q.category_prop_2 = ' ') and (q.category_prop_3 = a.category_prop_3 or q.category_prop_3 = ' ') and (q.category_prop_4 = a.category_prop_4 or q.category_prop_4 = ' ') and (q.category_prop_5 = a.category_prop_5 or q.category_prop_5 = ' ')) end as impact, e.metric_label_nlsid, c.column_label_nlsid from mgmt_targets a, mgmt_current_severity b, mgmt_metrics c, mgmt_current_metrics d, (select category_prop_1, category_prop_2, category_prop_3, category_prop_4, category_prop_5, metric_name, target_type, type_meta_ver, metric_label_nlsid from mgmt_metrics where metric_column = ' ') e where a.target_guid = b.target_guid and b.metric_guid = c.metric_guid and b.metric_guid = d.metric_guid(+) and b.target_guid = d.target_guid(+) and e.target_type = a.target_type and e.metric_name = c.metric_name and b.key_value = d.key_value(+) and a.target_name = :1 and a.target_type = :2 and c.type_meta_ver = e.type_meta_ver AND c.type_meta_ver = a.type_meta_ver AND (c.category_prop_1 = a.category_prop_1 OR c.category_prop_1 = ' ') AND (c.category_prop_2 = a.category_prop_2 OR c.category_prop_2 = ' ') AND (c.category_prop_3 = a.category_prop_3 OR c.category_prop_3 = ' ') AND (c.category_prop_4 = a.category_prop_4 OR c.category_prop_4 = ' ') AND (c.category_prop_5 = a.category_prop_5 OR c.category_prop_5 = ' ') AND (e.category_prop_1 = a.category_prop_1 OR e.category_prop_1 = ' ') AND (e.category_prop_2 = a.category_prop_2 OR e.category_prop_2 = ' ') AND (e.category_prop_3 = a.category_prop_3 OR e.category_prop_3 = ' ') AND (e.category_prop_4 = a.category_prop_4 OR e.category_prop_4 = ' ') AND (e.category_prop_5 = a.category_prop_5 OR e.category_prop_5 = ' ') ORDER BY 1 desc

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

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: 12,827

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

• B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.