WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
EBS1225	2783254286	ebs1225	1	01-May-17 15:05	11.2.0.4.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ebs1225	Linux x86 64-bit	16	16	1	117.78

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	937	01-May-17 17:00:09	1526	36.6
End Snap:	939	01-May-17 19:00:24	1833	58.0
Elapsed:		120.25 (mins)
DB Time:		768.78 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.4	0.0	0.00	0.00
DB CPU(s):	5.5	0.0	0.00	0.00
Redo size (bytes):	2,438,057.2	4,827.4
Logical read (blocks):	335,464.7	664.2
Block changes:	15,334.7	30.4
Physical read (blocks):	920.3	1.8
Physical write (blocks):	1,289.4	2.6
Read IO requests:	68.4	0.1
Write IO requests:	252.3	0.5
Read IO (MB):	7.2	0.0
Write IO (MB):	10.1	0.0
User calls:	10,800.0	21.4
Parses (SQL):	5,548.4	11.0
Hard parses (SQL):	0.9	0.0
SQL Work Area (MB):	55.1	0.1
Logons:	0.2	0.0
Executes (SQL):	22,639.6	44.8
Rollbacks:	20.4	0.0
Transactions:	505.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.99	Soft Parse %:	99.98
Execute to Parse %:	75.49	Latch Hit %:	99.81
Parse CPU to Parse Elapsd %:	81.67	% Non-Parse CPU:	99.01

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
16	16	1	3.46	8.50	30.3	3.6	2.6	65.4

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
36.9	106.6	0.0

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	653.7	72.7	581.0
Database Requests:	320.8	68.4	252.3
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	326.5	0.0	326.5
Total (MB):	19.9	7.3	12.6
Database (MB):	17.3	7.2	10.1
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	2.5	0.0	2.5
Database (blocks):	2,209.7	920.3	1,289.4
Via Buffer Cache (blocks):	415.7	32.9	382.8
Direct (blocks):	1,794.0	887.4	906.6

Memory Statistics

	Begin	End
Host Mem (MB):	120,604.3	120,604.3
SGA use (MB):	30,720.0	30,720.0
PGA use (MB):	9,859.3	17,803.5
% Host Mem used for SGA+PGA:	33.65	40.23

Cache Sizes

	Begin	End
Buffer Cache:	25,024M	25,024M	Std Block Size:	8K
Shared Pool Size:	4,471M	4,454M	Log Buffer:	53,948K

Shared Pool Statistics

	Begin	End
Memory Usage %:	35.99	47.17
% SQL with executions>1:	94.49	93.47
% Memory for SQL w/exec>1:	92.68	90.11

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): 46126.7s
• 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 98.1% of Total DB time 46,126.70 (s)
• Total FG Wait Time: 5,255.74 (s) DB CPU time: 39,983.77 (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)

No data exists for this section of the report.

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 26.9% of Total DB Time (s): 46,127
• Captured PL/SQL account for 56.7% of Total DB Time (s): 46,127

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 25.1% of Total CPU Time (s): 39,984
• Captured PL/SQL account for 54.7% of Total CPU Time (s): 39,984

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 80.2% of Total User I/O Wait Time (s): 1,694
• Captured PL/SQL account for 81.2% of Total User I/O Wait Time (s): 1,694

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,420,414,647
• Captured SQL account for 74.2% 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: 6,640,349
• Captured SQL account for 80.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: 493,791
• Captured SQL account for 45.3% of Total
• Total UnOptimized Read Requests: 493,791
• Captured SQL account for 45.3% 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: 163,347,325
• Captured SQL account for 26.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 40,032,368
• Captured SQL account for 10.8% 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
05s9358mm6vrr	begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
0wnbj3tpd8g58	SELECT FRO.RESULT_TYPE, FRD.RULE_DETAIL_ID, FRD.OPERATOR , FRD.RULE_OBJECT_ID, FRO.FLEXFIELD_NAME , FRO.FLEXFIELD_APP_SHORT_NAME, UPPER(NVL(FRO.MULTI_RULE_RESULT_FLAG, 'N')), UPPER(USE_DEFAULT_VALUE_FLAG) FROM FUN_RULE_DETAILS FRD , FUN_RULE_OBJECTS_VL FRO WHERE FRO.RULE_OBJECT_ID = FRD.RULE_OBJECT_ID AND FRO.RULE_OBJECT_NAME=:1 AND FRO.APPLICATION_ID = :2 AND NVL(FRD.ENABLED_FLAG, 'N') = 'Y' AND ( (INSTANCE_LABEL IS NULL AND :3 IS NULL) OR (INSTANCE_LABEL IS NOT NULL AND :4 IS NOT NULL AND INSTANCE_LABEL = :5)) AND ( (ORG_ID IS NULL AND :6 IS NULL) OR (ORG_ID IS NOT NULL AND :7 IS NOT NULL AND ORG_ID = :8)) ORDER BY FRD.SEQ
1kjhvys1sd1sg	BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.OASubmitWorkflow(p_report_header_id => :1, p_preparer_id => :2, p_employee_id => :3, p_invoice_number => :4, p_reimb_curr => :5, p_cost_center => :6, p_purpose => :7, p_approver_id => :8, p_week_end_date => :9, p_workflow_appr_flag => :10, p_msg_count => :11);END;
1rd31t40r4fu5	BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
1xxc9mch43qdh	SELECT * FROM (SELECT PolicyViolationEO.REPORT_HEADER_ID, PolicyViolationEO.DISTRIBUTION_LINE_NUMBER, PolicyViolationEO.VIOLATION_NUMBER, PolicyViolationEO.VIOLATION_TYPE, PolicyViolationEO.VIOLATION_DATE, PolicyViolationEO.ALLOWABLE_AMOUNT, PolicyViolationEO.ORG_ID, PolicyViolationEO.CREATION_DATE, PolicyViolationEO.CREATED_BY, PolicyViolationEO.LAST_UPDATE_DATE, PolicyViolationEO.LAST_UPDATED_BY, PolicyViolationEO.LAST_UPDATE_LOGIN, PolicyViolationEO.FUNC_CURRENCY_ALLOWABLE_AMT, PolicyViolationEO.EXCEEDED_AMOUNT FROM AP_POL_VIOLATIONS_ALL PolicyViolationEO WHERE PolicyViolationEO.VIOLATION_TYPE <> 'DUPLICATE_DETECTION' UNION SELECT DISTINCT PolicyViolationEO.REPORT_HEADER_ID, PolicyViolationEO.DISTRIBUTION_LINE_NUMBER, AP_WEB_POLICY_UTILS.getMaxDistLineNumber(PolicyViolationEO.REPORT_HEADER_ID, PolicyViolationEO.DISTRIBUTION_LINE_NUMBER) VIOLATION_NUMBER, PolicyViolationEO.VIOLATION_TYPE, PolicyViolationEO.VIOLATION_DATE, PolicyViolationEO.ALLOWABLE_AMOUNT, PolicyViolationEO.ORG_ID, PolicyViolationEO.CREATION_DATE, PolicyViolationEO.CREATED_BY, PolicyViolationEO.LAST_UPDATE_DATE, PolicyViolationEO.LAST_UPDATED_BY, PolicyViolationEO.LAST_UPDATE_LOGIN, PolicyViolationEO.FUNC_CURRENCY_ALLOWABLE_AMT, PolicyViolationEO.EXCEEDED_AMOUNT FROM AP_POL_VIOLATIONS_ALL PolicyViolationEO WHERE PolicyViolationEO.VIOLATION_TYPE = 'DUPLICATE_DETECTION') QRSLT WHERE REPORT_HEADER_ID = :1 AND DISTRIBUTION_LINE_NUMBER = :2
20wnd5y5xjzpk	SELECT ExpAttendeeEO.REPORT_LINE_ID, ExpAttendeeEO.EMPLOYEE_FLAG, ExpAttendeeEO.EMPLOYEE_ID, ExpAttendeeEO.ATTENDEE_TYPE, ExpAttendeeEO.NAME, ExpAttendeeEO.TITLE, ExpAttendeeEO.EMPLOYER, ExpAttendeeEO.EMPLOYER_ADDRESS, ExpAttendeeEO.ORG_ID, ExpAttendeeEO.LAST_UPDATE_DATE, ExpAttendeeEO.LAST_UPDATED_BY, ExpAttendeeEO.CREATION_DATE, ExpAttendeeEO.CREATED_BY, ExpAttendeeEO.LAST_UPDATE_LOGIN, ExpAttendeeEO.ATTENDEE_LINE_ID, ExpAttendeeEO.TAX_ID FROM OIE_ATTENDEES_ALL ExpAttendeeEO WHERE :1 = ExpAttendeeEO.REPORT_LINE_ID AND EMPLOYEE_FLAG = 'N'
2d1p0p5k3f8fu	select p, NULL, NULL from (select count(*) p from v$rman_status where operation = 'BLOCK MEDIA RECOVERY')
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
3mhs9q5cs93qt	SELECT * FROM (SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, A ERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND AI.SOURCE in ('XpenseXpress', 'SelfService', 'CREDIT CARD', 'Both Pay') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND PV.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :1 AND P.PERSON_ID = PV.EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAM E , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' in ('STANDARD', 'MIXED', 'PAYMENT REQUEST ') AND AI.SOURCE IN ('SelfService', 'Both Pay', 'CREDIT CARD') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :2 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION ALL SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AERH.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXI MUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, /*NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, */ DECODE (NVL (AERH.approval_type, 'PER'), 'PER', NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)), AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0 =0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :3 AND PER_EMPLOYEE.PERSON_ID = AERH.EMPLOYEE_ID AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_curren t_approver_id = PER_APPROVER.person_id (+) AND DECODE(AERH.expense_status_code, 'PAID', ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)), 30) <= 30 AND AERH.SOURCE <> 'Both Pay' UNION SELECT /*+ leading(a aerh) push_pred(per_employee) push_pred(per_approver) */ AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AERH.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEAD ER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, /*NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, */ DECODE (NVL (AERH.approval_type, 'PER'), 'PER', NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)), AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_ CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0=0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :4 AND PER_EMPLOYEE.PERSON_ID = PAID_ON_BEHALF_EMPLOYEE_ID AND AERH.EMPLOYEE_ID IS NULL AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND DECODE(AERH.expense_status_code, 'PAID', ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sy sdate - AERH.LAST_UPDATE_DATE)), 30) <= 30 AND AERH.SOURCE <> 'Both Pay' UNION ALL /* This select is for invoice imported reports by contingent workers */ SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_S WITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID, AERH.IMAGE_RECEIPTS_STATUS IMAGE_RECEIPTS_STATUS_CODE FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND AI.SOURCE in ('XpenseXpress', 'SelfService', 'CREDIT CARD', 'Both Pay') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :5 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND AP_WEB_DB_HR_INT_PKG.IsPersonCwk(AI.PAID_ON_BEHALF_EMPLOYEE_ID)='Y' AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL)) QRSLT ORDER BY REPORT_SUBMITTED_DATE DESC
3uuh9br2vgsc3	select 'Y' from ap_card_programs cp, ap_cards card, ap_credit_card_trxns trxns where card.employee_id = :1 and card.card_program_id = cp.card_program_id and card.card_reference_id is not null and cp.card_type_lookup_code = 'TRAVEL' and trxns.card_program_id = card.card_program_id and trxns.card_id = card.card_id and trxns.validate_code = 'Y' and trxns.payment_flag <> 'Y' and trxns.billed_amount is not null and trxns.report_header_id is null and nvl(trxns.CATEGORY, 'BUSINESS') not in ('DISPUTED', 'CREDIT', 'MATCHED', 'DEACTIVATED') and TRUNC(sysdate - trxns.posted_date) > :2 and rownum = 1 union select 'Y' from ( SELECT P.FULL_NAME, P.PERSON_ID, AERH.DESCRIPTION, AERH.TOTAL TOTAL, TO_CHAR((AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '||AERH.DEFAULT_CURRENCY_CODE FORMATTED_TOTAL, AERH.DEFAULT_CURRENCY_CODE, AERH.WEEK_END_DATE, AERH.INVOICE_NUM, AERH.REPORT_HEADER_ID, ALC.displayed_field AS STATUS, DECODE (AERH.WORKFLOW_APPRO VED_FLAG, 'R', 'DuplicateImageDisabled', 'T', 'DuplicateImageDisabled', 'DuplicateImageEnabled'), AERH.LAST_UPDATE_DATE FROM PER_PEOPLE_X P, AP_EXPENSE_REPORT_HEADERS AERH, AP_LOOKUP_CODES ALC WHERE P.PERSON_ID = AERH.EMPLOYEE_ID AND AERH.VOUCHNO+0 =0 AND AERH.SOURCE = 'NonValidatedWebExpense' AND AERH.WORKFLOW_APPROVED_FLAG IN ('S', 'R', 'T', 'W') AND ALC.LOOKUP_TYPE = 'EXPENSE REPORT STATUS' AND ALC.LOOKUP_CODE =Decode(AERH.Workflow_approved_flag, 'S', 'SAVED', 'R', 'REJECTED', 'T', 'RETURNED', 'W', 'WITHDRAWN') ) aerv, ap_credit_card_trxns trxns where aerv.report_header_id = trxns.report_header_id and aerv.person_id = :3 and TRUNC(sysdate - trxns.posted_date) > :4 and rownum = 1
4nu9bf8k5v303	BEGIN FUN_RULE_PUB.INIT_PARAMETER_LIST; FUN_RULE_PUB.ADD_PARAMETER(:1, :2); FUN_RULE_PUB.ADD_PARAMETER(:3, :4); FUN_RULE_PUB.ADD_PARAMETER(:5, :6); FUN_RULE_PUB.ADD_PARAMETER(:7, :8); :9 := FUN_RULE_PUB.APPLY_RULE_WRAPPER(:10, :11); end;
4xpxwj3mmpbj8	SELECT COUNT(*) FROM PA_TASKS WHERE PROJECT_ID = :B2 AND TASK_ID = :B1
6129566gyvx21	SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
67mmmbx5hb3p0	BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;
7qg24jchwmfjp	BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, a ttribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => :55, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63 , receipt_cost_center => :64 , p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeL unches2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_head er_attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_addon_rates => :113, p_report_line_id => :114, p_itemization_parent_id => :115, p_daily_breakup_id => :116, p_start_date => :117, p_end_date => :118, p_amount => :119, p_number_of_meals => :120, p_meals_amount => :121, p_breakfast_flag => :122, p_lunch_flag => :123, p_dinner_flag => :124, p_accommodation_amount => :125, p_accommodation_flag => :126, p_hotel_name => :127, p_night_rate_type => :128, p_night_rate_amount => :129, p_pdm_rate => :130, p_rate_type_code => :131, p_pdm_breakup_dest_id => :132, p_pdm_destination_id => :133, p_dest_start_date => :134, p_dest_end_date => :135, p_location_id => :136, p_cust_meals_amount => :137, p_cust_accommodation_amount => :138, p_cust_night_rate_amount => :139, p_cust_pdm_rate => :140, p_vat_code => :141, p_emp_attendee_count => :142, p_nonemp_attendee_count => :143, p_receipt_location_id => :144);END;
7ujfmgb1j83a3	BEGIN FND_AOLJ_UTIL.SET_NLS_CONTEXT( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13);END;
8m2sw3z7kt6ph	select p, NULL, NULL from (select count(*) p from v$rman_status where operation = 'BACKUP COPYROLLFORWARD')
8zwp9b5wbdvqu	/* $Header: ValueSet.java 120.13.12020000.10 2015/03/04 07:47:59 svedi ship $ */ select enabled_flag FLEX_ENABLED_FLAG , trunc(start_date_active) FLEX_START_DATE , trunc(end_date_active) FLEX_END_DATE , trunc(SysDate) FLEX_SYSDATE , summary_flag FLEX_SUMMARY_FLAG , compiled_value_attributes FLEX_COMPILED_VALUE_ATTRIBUTES , description FLEX_DESCRIPTION from fnd_flex_values_vl where (fnd_flex_values_vl.flex_value_set_id = :1) and flex_value = :2
91hakq9n36htp	SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
99p2syxffrkt0	BEGIN hxc_timecard_utilities.get_time_periods (p_resource_id => :1 , p_resource_type => :2 , p_rec_period_start_date => :3 , p_period_type => :4 , p_duration_in_days => :5 , p_current_date => :6 , p_num_past_entries => :7 , p_num_future_entries => :8 , p_num_past_days => :9 , p_num_future_days => :10 , p_hire_date => :11 , p_show_existing_timecard => :12 , p_first_empty_period => :13 , p_periods => :14 ); END;
9phk60b4zpy16	SELECT * FROM (SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_t ype.data_capture_rule_id, nvl((select reimbursement_percentage_flag from ap_pol_headers where policy_id = child_type.COMPANY_POLICY_ID), 'N') as RP_ENABLED FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type, AP_POL_ITEMIZATIONS api WHERE parent_type.itemization_all_flag = 'N' AND api.parameter_id = parent_type.parameter_id AND child_type.parameter_id = api.itemization_parameter_id AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :1 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0)) UNION ALL SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type .prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id, nvl((select reimbursement_percentage_flag from ap_pol_headers where policy_id = child_type.COMPANY_POLICY_ID), 'N') as RP_ENABLED FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type WHERE parent_type.itemization_all_flag = 'Y' -- Include Expense Type if it either belongs to the requested Template -- or if it is marked as "Viewable From All Tempaltes AND (child_type.expense_report_id = parent_type.expense_report_id OR child_type.web_enabled_flag = 'Y') AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :2 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0))) QRSLT WHERE PARENT_EXPENSE_TYPE_ID = :3 ORDER BY WEB_PROMPT
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')
atx2mcqhyq0bg	SELECT DFF.RULE_DETAIL_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 FROM FUN_CONTACTUS_SETUP DFF WHERE DFF.RULE_DETAIL_ID = -99 AND RULE_OBJECT_ID = :1
av3725tvr1a31	SELECT RESULT_TYPE, RULE_OBJECT_ID, FLEXFIELD_NAME , FLEXFIELD_APP_SHORT_NAME FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_NAME = :1 AND ( (INSTANCE_LABEL IS NULL AND :2 IS NULL) OR (INSTANCE_LABEL IS NOT NULL AND :3 IS NOT NULL AND INSTANCE_LABEL = :4)) AND ( (ORG_ID IS NULL AND :5 IS NULL) OR (ORG_ID IS NOT NULL AND :6 IS NOT NULL AND ORG_ID = :7))
awxz0wckf2x9z	SELECT * FROM (SELECT rsa.RULE_ASSIGNMENT_ID, rsa.RULE_SET_ID, rsa.ORG_ID, rsa.CREATION_DATE, rsa.CREATED_BY, rsa.LAST_UPDATE_LOGIN, rsa.LAST_UPDATE_DATE, rsa.LAST_UPDATED_BY, rsa.START_DATE, rsa.END_DATE, rs.rule_set_type, ou.name ORG_NAME, rs.rule_set_name, rsa.END_DATE orig_end_date FROM AP_AUD_RULE_ASSIGNMENTS_ALL rsa, AP_AUD_RULE_SETS rs, HR_ALL_ORGANIZATION_UNITS ou WHERE ou.organization_id = rsa.org_id AND rs.rule_set_id = rsa.rule_set_id AND rsa.org_id = :1 AND rs.rule_set_type = :2) QRSLT ORDER BY start_date desc
b52t4h7waqbzu	SELECT * FROM (SELECT AP_WEB_DB_CCARD_PKG.GetLocation(merchant_city , merchant_province_state) AS LOCATION, ApCreditCardTrxnsAll.TRX_ID, ApCreditCardTrxnsAll.CARD_PROGRAM_ID, ApCreditCardTrxnsAll.TRANSACTION_DATE, ApCreditCardTrxnsAll.TRANSACTION_AMOUNT, ApCreditCardTrxnsAll.BILLED_AMOUNT, ApCreditCardTrxnsAll.POSTED_CURRENCY_CODE, ApCreditCardTrxnsAll.BILLED_CURRENCY_CODE, ApCreditCardTrxnsAll.MERCHANT_NAME1, ApCreditCardTrxnsAll.MERCHANT_CITY, ApCreditCardTrxnsAll.MERCHANT_PROVINCE_STATE, ApCreditCardTrxnsAll.MERCHANT_COUNTRY, ApCreditCardTrxnsAll.FOLIO_TYPE, ApCreditCardTrxnsAll.CATEGORY, ApCreditCardTrxnsAll.REPORT_HEADER_ID, ApCreditCardTrxnsAll.COMPANY_PREPAID_INVOICE_ID, ApCreditCardTrxnsAll.EXPENSED_AMOUNT, CreditCardEO.CARD_ID, nvl(ApCreditCardTrxnsAll.BILLED_DATE, ApCreditCardTrxnsAll.POSTED_DATE) BILLED_DATE, ApCreditCardTrxnsAll.HOTEL_ROOM_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TELEPHONE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_TAX, ApCreditCardTrxnsAll.H OTEL_BAR_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MOVIE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_GIFT_SHOP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_LAUNDRY_AMOUNT, ApCreditCardTrxnsAll.HOTEL_HEALTH_AMOUNT, ApCreditCardTrxnsAll.HOTEL_RESTAURANT_AMOUNT, ApCreditCardTrxnsAll.HOTEL_BUSINESS_AMOUNT, ApCreditCardTrxnsAll.HOTEL_PARKING_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_SERVICE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TIP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MISC_AMOUNT, ApCreditCardTrxnsAll.PAYMENT_DUE_FROM_CODE, ApCreditCardTrxnsAll.POSTED_DATE, ApCreditCardTrxnsAll.AIR_TICKET_NUMBER, ApCreditCardTrxnsAll.DESCRIPTION, ApCreditCardTrxnsAll.AIR_DEPARTURE_CITY, ApCreditCardTrxnsAll.AIR_ARRIVAL_CITY, ApCreditCardTrxnsAll.AIR_SERVICE_CLASS, TRUNC(sysdate - NVL(POSTED_DATE, BILLED_DATE)) as Age, decode(REPORT_HEADER_ID, null, 'N', 'Y') as selected, decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG), 'N') as TRXN_DETAIL_FLAG, d ecode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', decode(ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG, 'Y', 'Y', AP_WEB_CREDIT_CARD_PKG.HAS_DETAILED_TRXN(ApCreditCardTrxnsAll.trx_id) ) ), 'N') as level2or3_detail_flag, ApCreditCardTrxnsAll.ATM_CASH_ADVANCE, ApCreditCardTrxnsAll.ATM_FEE_AMOUNT, ApCreditCardTrxnsAll.RESTAURANT_FOOD_AMOUNT, ApCreditCardTrxnsAll.RESTAURANT_BEVERAGE_AMOUNT, ApCreditCardTrxnsAll.RESTAURANT_TIP_AMOUNT, ApCreditCardTrxnsAll.CAR_MILEAGE_AMOUNT, ApCreditCardTrxnsAll.CAR_GAS_AMOUNT, ApCreditCardTrxnsAll.CAR_INSURANCE_AMOUNT, ApCreditCardTrxnsAll.AIR_BASE_FARE_AMOUNT, ApCreditCardTrxnsAll.FUEL_SALE_AMOUNT, ApCreditCardTrxnsAll.NON_FUEL_SALE_AMOUNT FROM AP_CREDIT_CARD_TRXNS ApCreditCardTrxnsAll, AP_CARDS CreditCardEO, AP_CARD_PROGRAMS apcp WHERE ApCreditCardTrxnsAll.validate_code = 'Y' AND CreditCardEO.CARD_PROGRAM_ID = apcp.card_program_id AND ApCreditCardTrxnsAll.payment_flag <> 'Y' AND ApCreditCardTrxnsAll.billed_amoun t is not null AND ApCreditCardTrxnsAll.billed_currency_code = :1 AND CreditCardEO.card_id = :2 AND ApCreditCardTrxnsAll.payment_due_from_code = :3 AND ApCreditCardTrxnsAll.CARD_PROGRAM_ID = CreditCardEO.CARD_PROGRAM_ID AND ApCreditCardTrxnsAll.CARD_ID = CreditCardEO.CARD_ID AND (nvl(ApCreditCardTrxnsAll.CATEGORY, 'BUSINESS') not in ('DISPUTED', 'CREDIT', 'MATCHED', 'DEACTIVATED')) AND trunc(nvl(ApCreditCardTrxnsAll.trx_available_date, TO_DATE('01-01-1952 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))) <= trunc(sysdate)) QRSLT WHERE (report_header_id is null OR report_header_id = :4) ORDER BY age desc
ba54gdcfdgutp	SELECT LAST_UPDATE_DATE FROM HXC_PREF_HIERARCHIES WHERE PREF_HIERARCHY_ID = :B1
bnk32fdswwqrz	begin HXC_APPROVAL_WF_PKG.create_appl_period_info (:v1, :v2, :v3, :v4, :v5); end;
bqf04xkudk4zt	BEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END;
btamp5s88hqqb	SELECT PATH_DOCID, PATH_TYPE FROM JDR_PATHS WHERE PATH_NAME = :B1 AND PATH_OWNER_DOCID = :B2
c9vu0rgm0nqj2	BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, a ttribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => :55, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63, receipt_cost_center => :64, p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeLunc hes2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_header_ attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_report_line_id => :113, p_itemization_parent_id => :114, p_cust_meals_amount => :115, p_cust_accommodation_amount => :116, p_cust_night_rate_amount => :117, p_cust_pdm_rate => :118, p_emp_attendee_count => :119, p_nonemp_attendee_count => :120 , p_vat_code => :121 , p_receipt_location_id => :122);END;
cmxq1hvy8crz7	SELECT ExpAttendeeEO.REPORT_LINE_ID, ExpAttendeeEO.EMPLOYEE_FLAG, ExpAttendeeEO.EMPLOYEE_ID, ExpAttendeeEO.ATTENDEE_TYPE, ExpAttendeeEO.NAME, ExpAttendeeEO.TITLE, ExpAttendeeEO.EMPLOYER, ExpAttendeeEO.EMPLOYER_ADDRESS, ExpAttendeeEO.ORG_ID, ExpAttendeeEO.LAST_UPDATE_DATE, ExpAttendeeEO.LAST_UPDATED_BY, ExpAttendeeEO.CREATION_DATE, ExpAttendeeEO.CREATED_BY, ExpAttendeeEO.LAST_UPDATE_LOGIN, ExpAttendeeEO.ATTENDEE_LINE_ID, ExpAttendeeEO.TAX_ID FROM OIE_ATTENDEES_ALL ExpAttendeeEO WHERE :1 = ExpAttendeeEO.REPORT_LINE_ID AND EMPLOYEE_FLAG = 'Y'
cyxbnpx56hm9h	BEGIN :1:=jdr_mds_internal.getDocumentID(:2, :3); END;
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
dcqsadu746twn	SELECT count(1) FROM HR_OPERATING_UNITS WHERE NVL(ORGANIZATION_ID, -1) = NVL(:1, -1)
dcrschgcxcbkn	begin AP_WEB_EXPENSE_WF.APVALIDATEEXPENSEREPORT (:v1, :v2, :v3, :v4, :v5); end;
f7g96xjhudpzt	BEGIN HXC_TIMECARD.CREATE_TIMECARD (P_VALIDATE => :1 , P_BLOCKS => :2 , P_ATTRIBUTES => :3 , P_DEPOSIT_MODE => :4 , P_TEMPLATE => :5 , P_ITEM_TYPE => :6 , P_APPROVAL_PRC => :7 , P_LOCK_ROWID => :8 , P_TIMECARD_ID => :9 , P_TIMECARD_OVN => :10 , P_MESSAGES => :11 , P_CLA_SAVE => :12 ); END;
g22cn4nvvn83b	begin HXC_APPROVAL_WF_PKG.process_appl_periods (:v1, :v2, :v3, :v4, :v5); end;
gf87bnxzf9raf	select db.version_time, db.controlfile_change#, db.controlfile_sequence#, dbinc.resetlogs_time, df.last_recid, tf.last_recid, ts.last_recid, rl.last_recid, rm.last_recid, dc.last_recid, al.last_recid, bp.last_recid, do.last_recid, offr.last_recid, pc.last_recid, bs.last_recid, ldbinc.resetlogs_change#, ldbinc.resetlogs_time, ic.last_recid, rt.last_recid, grsp.last_recid, nrsp.last_recid, bcr.last_recid, decode(dc.records_used, 0, 0, dc.last_recid - dc.records_used + 1), decode(al.records_used, 0, 0, al.last_recid - al.records_used + 1), decode(bp.records_used, 0, 0, bp.last_recid - bp.records_used + 1), decode(bs.records_used, 0, 0, bs.last_recid - bs.records_used + 1), decode(do.records_used, 0, 0, do.last_recid - do.records_used + 1), decode(offr.records_used, 0, 0, offr.last_recid - offr.records_used + 1), decode(pc.records_used, 0, 0, pc.last_recid - pc.records_used + 1)into :vertime, :cfscn, :cfseq, :rltime, :dfhwm, :tfhwm, : tshwm, :rlhwm, :rmhwm, :dchwm, :alhwm, :bphwm, :dohwm, :offrhwm, :pchwm, :bshwm, :lrstscn, :lrsttime, :ichwm, :rthwm, :grsphwm, :nrsphwm, :bcrhwm, :dclwm, :allwm, :bplwm, :bslwm, :dolwm, :offrlwm, :pclwm from v$database db, v$controlfile_record_section df, v$controlfile_record_section tf, v$controlfile_record_section ts, v$controlfile_record_section rt, v$controlfile_record_section rl, v$controlfile_record_section rm, v$controlfile_record_section dc, v$controlfile_record_section al, v$controlfile_record_section bp, v$controlfile_record_section do, v$controlfile_record_section offr, v$controlfile_record_section pc, v$controlfile_record_section bs, v$controlfile_record_section ic, v$controlfile_record_section grsp, v$controlfile_record_section nrsp, v$controlfile_record_section bcr, v$database_incarnation dbinc, v$database_incarnation ldbinc where df.type = 'DATAFILE' and tf.type = 'TEMPORARY FILENAME' and ts.type = 'TABLESPACE' and rt.type = 'RE DO THREAD' and rl.type = 'REDO LOG' and rm.type = 'RMAN CONFIGURATION' and dc.type = 'DATAFILE COPY' and al.type = 'ARCHIVED LOG' and bp.type = 'BACKUP PIECE' and do.type = 'DELETED OBJECT' and offr.type = 'OFFLINE RANGE' and pc.type = 'PROXY COPY' and bs.type = 'BACKUP SET' and ic.type = 'DATABASE INCARNATION' and grsp.type = 'GUARANTEED RESTORE POINT' and nrsp.type = 'RESTORE POINT' and bcr.type = 'DATABASE BLOCK CORRUPTION' and dbinc.incarnation#=db.recovery_target_incarnation# and ldbinc.incarnation#=db.last_open_incarnation#
gj1mbaw0hyzru	BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1, :2, :3, :4, :5, :6, :7, :8); END;
gtrwx3zy64zm0	SELECT * FROM (SELECT erp.PARAMETER_ID AS PARAMETER_ID, nvl(erp.WEB_FRIENDLY_PROMPT, erp.PROMPT) AS WEB_PROMPT, erp.PROMPT AS PROMPT, erp.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(erp.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(erp.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, erp.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(erp.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, erp.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, erp.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, erp.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, erp.COMPANY_POLICY_ID, erp.CATEGORY_CODE, erp.END_DATE, erp.ITEMIZATION_REQUIRED_FLAG, erp.ITEMIZATION_ALL_FLAG, erp.RECEIPT_REQUIRED_FLAG, erp.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS erp, AP_EXPENSE_REPORTS er WHERE erp.EXPENSE_REPORT_ID = er.EXPENSE_REPORT_ID -- Include Expense Type if it either belongs to the requested Template -- or if it is marked as "Viewable From All T empaltes AND (erp.EXPENSE_REPORT_ID = :1 OR erp.WEB_ENABLED_FLAG = 'Y') AND erp.CATEGORY_CODE IS NOT NULL AND (('PER_DIEM' = :2 AND erp.CATEGORY_CODE = 'PER_DIEM') OR ('MILEAGE' = :3 AND erp.CATEGORY_CODE = 'MILEAGE') OR (erp.CATEGORY_CODE <> 'PER_DIEM' AND erp.CATEGORY_CODE <> 'MILEAGE')) AND er.WEB_ENABLED_FLAG = 'Y' AND ('RO' = :4 OR (trunc(sysdate) <= trunc(nvl(er.INACTIVE_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0) AND trunc(sysdate) <= trunc(nvl(erp.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0)))) QRSLT ORDER BY WEB_PROMPT

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