WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	429244995	VIS	1	14-Sep-15 13:09	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbzone1.priv.com	Solaris[tm] OE (64-bit)				.00

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	195	15-Sep-15 18:15:58	7097	34.9
End Snap:	199	15-Sep-15 19:15:06	3450	45.8
Elapsed:		59.14 (mins)
DB Time:		1,168.59 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	62,464M	62,464M	Std Block Size:	8K
Shared Pool Size:	16,384M	16,384M	Log Buffer:	172,632K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	19.8	0.0	0.00	0.00
DB CPU(s):	19.3	0.0	0.00	0.00
Redo size:	4,508,438.9	3,401.5
Logical reads:	525,414.5	396.4
Block changes:	29,290.1	22.1
Physical reads:	1.5	0.0
Physical writes:	431.5	0.3
User calls:	17,722.5	13.4
Parses:	2,510.3	1.9
Hard parses:	2.9	0.0
W/A MB processed:	54.0	0.0
Logons:	9.4	0.0
Executes:	47,062.1	35.5
Rollbacks:	122.3	0.1
Transactions:	1,325.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	100.17	Soft Parse %:	99.88
Execute to Parse %:	94.67	Latch Hit %:	98.14
Parse CPU to Parse Elapsd %:	96.13	% Non-Parse CPU:	97.82

Shared Pool Statistics

	Begin	End
Memory Usage %:	27.53	23.71
% SQL with executions>1:	93.85	93.34
% Memory for SQL w/exec>1:	92.17	90.73

Top 5 Timed Foreground Events

Host CPU (CPUs: Cores: Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):
SGA use (MB):	81,920.0	81,920.0
PGA use (MB):	47,172.5	26,302.8
% Host Mem used for SGA+PGA:

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): 70115.3s
• 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 103.4% of Total DB time 70,115.27 (s)
• Total FG Wait Time: 4,114.46 (s) DB CPU time: 68,406.62 (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 27.0% of Total DB Time (s): 70,115
• Captured PL/SQL account for 43.5% of Total DB Time (s): 70,115

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 27.6% of Total CPU Time (s): 68,407
• Captured PL/SQL account for 41.8% of Total CPU Time (s): 68,407

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

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: 1,864,303,692
• Captured SQL account for 60.7% 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: 5,244
• Captured SQL account for 29.3% 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: 4,102
• Captured SQL account for 26.0% of Total
• Total UnOptimized Read Requests: 4,102
• Captured SQL account for 26.0% 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: 166,988,153
• Captured SQL account for 27.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 8,907,011
• Captured SQL account for 35.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

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
091k6w295fwz7	select ps . org_id invoice_org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_000" , NULL , types . cust_trx_type_id ) dummy_id_inv , decode ( UPPER ( : p_order_by ) , :"SYS_B_001" , NULL , types . name ) dummy_type_inv , decode ( party . party_name , null , :"SYS_B_002" , rtrim ( rpad ( substrb ( :"SYS_B_003" || party . party_name , :"SYS_B_004" , :"SYS_B_005" ) , :"SYS_B_006" ) ) ) customer_name_inv , cust_acct . cust_account_id customer_id_inv , cust_acct . account_number customer_number_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_007" , :"SYS_B_008" , site . site_use_id ) contact_site_id_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_009" , NULL , rtrim ( rpad ( loc . state , :"SYS_B_010" ) ) ) cust_state_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_011" , NULL , rtrim ( rpad ( loc . city , :"SYS_B_012" ) ) ) cust_city_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_013" , :"SYS_B_014" , addr . cust_acct_site_id ) addr_id_inv , rtrim ( rpad ( trx . purchase_order , :"SYS_B_015" ) ) reference_number , ps . payment_schedule_id payment_sched_id_inv , ps . class class_inv , ps . due_date due_date_inv , decode ( : rp_convert_flag , :"SYS_B_016" , ps . acctd_amount_due_remaining , ps . amount_due_remaining ) amt_due_remaining_inv , decode ( : rp_convert_flag , :"SYS_B_017" , round ( ( ps . amount_due_original * nvl ( ps . exchange_rate , :"SYS_B_018" ) ) , : func_curr_precision ) , ps . amount_due_original ) amt_due_original_inv , ps . trx_number invnum , types . name invoice_type_inv , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due_inv , ps . amount_adjusted amount_adjusted_inv , ps . amount_applied amount_applied_inv , ps . amount_credited amount_credited_inv , ps . gl_date gl_date_inv , decode ( ps . invoice_currency_code , : functional_currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_019" , NULL ) ) data_converted_inv , nvl ( ps . exchange_rate , :"SYS_B_020" ) ps_exchange_rate_inv , decode ( : rp_bucket_line_type_0 , :"SYS_B_021" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_022" ) , :"SYS_B_023" , :"SYS_B_024" , :"SYS_B_025" ) , :"SYS_B_026" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_027" ) , :"SYS_B_028" , :"SYS_B_029" , :"SYS_B_030" ) , :"SYS_B_031" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_032" ) , :"SYS_B_033" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_034" ) , :"SYS_B_035" , :"SYS_B_036" , :"SYS_B_037" ) , :"SYS_B_038" ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_039" , :"SYS_B_040" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_041" ) , :"SYS_B_042" , :"SYS_B_043" , decode ( : rp_bucket_category , :"SYS_B_044" , :"SYS_B_045" , :"SYS_B_046" , :"SYS_B_047" , :"SYS_B_048" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_049" ) , :"SYS_B_050" , :"SYS_B_051" , decode ( : rp_bucket_category , :"SYS_B_052" , :"SYS_B_053" , :"SYS_B_054" , :"SYS_B_055" , :"SYS_B_056" ) ) ) b0_inv , decode ( : rp_bucket_line_type_1 , :"SYS_B_057" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_058" ) , :"SYS_B_059" , :"SYS_B_060" , :"SYS_B_061" ) , :"SYS_B_062 " , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_063" ) , :"SYS_B_064" , :"SYS_B_065" , :"SYS_B_066" ) , :"SYS_B_067" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_068" ) , :"SYS_B_069" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_070" ) , :"SYS_B_071" , :"SYS_B_072" , :"SYS_B_073" ) , :"SYS_B_074" ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_075" , :"SYS_B_076" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_077" ) , :"SYS_B_078" , :"SYS_B_079" , decode ( : rp_bucket_category , :"SYS_B_080" , :"SYS_B_081" , :"SYS_B_082" , :"SYS_B_083" , :"SYS_B_084" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_085" ) , :"SYS_B_086" , :"SYS_B_087" , decode ( : rp_bucket_category , :"SYS_B_088" , :"SYS_B_089" , :"SYS_B_090" , :"SYS_B_091" , :"SYS_B_092" ) ) ) b1_inv , decode ( : rp_bucket_line_type_2 , :"SYS_B_093" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_094" ) , :"SYS_B_095" , :"SYS_B_096" , :"SYS_B_097" ) , :"SYS_B_098" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_099" ) , :"SYS_B_100" , :"SYS_B_101" , :"SYS_B_102" ) , :"SYS_B_103" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_104" ) , :"SYS_B_105" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_106" ) , :"SYS_B_107" , :"SYS_B_108" , :"SYS_B_109" ) , :"SYS_B_110" ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_111" , :"SYS_B_112" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_113" ) , :"SYS_B_114" , :"SYS_B_115" , decode ( : rp_bucket_category , :"SYS_B_116" , :"SYS_B_117" , :"SYS_B_118" , :"SYS_B_119" , :"SYS_B_120" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_121" ) , :"SYS_B_122" , :"SYS_B_123" , decode ( : rp_bucket_category , :"SYS_B_124" , :"SYS_B_125" , :"SYS_B_126" , :"SYS_B_127" , :"SYS_B_128" ) ) ) b2_inv , decode ( : rp_bucket_line_type_3 , :"SYS_B_129" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_130" ) , :"SYS_B_131" , :"SYS_B_132" , :"SYS_B_133" ) , :"SYS_B_134" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_135" ) , :"SYS_B_136" , :"SYS_B_137" , :"SYS_B_138" ) , :"SYS_B_139" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_140" ) , :"SYS_B_141" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_142" ) , :"SYS_B_143" , :"SYS_B_144" , :"SYS_B_145" ) , :"SYS_B_146" ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_147" , :"SYS_B_148" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_149" ) , :"SYS_B_150" , :"SYS_B_151" , decode ( : rp_bucket_category , :"SYS_B_152" , :"SYS_B_153" , :"SYS_B_154" , :"SYS_B_155" , :"SYS_B_156" ) ) * dec ode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_157" ) , :"SYS_B_158" , :"SYS_B_159" , decode ( : rp_bucket_category , :"SYS_B_160" , :"SYS_B_161" , :"SYS_B_162" , :"SYS_B_163" , :"SYS_B_164" ) ) ) b3_inv , cc.segment1 bal_segment_value_inv , ps.trx_number cons_billing_number , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_165" , :"SYS_B_166" ) , : rp_short_unid_phrase ) , :"SYS_B_167" ) ) customer_name_inv_dsp from ra_cust_trx_types_all types , hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , RA_CUSTOMER_TRX_ALL trx , hz_cust_site_uses_all site , hz_cust_acct_sites_all addr , hz_party_sites party_site , hz_locations loc , ra_cust_trx_line_gl_dist_all gld , gl_code_combinations cc WHERE ( TRUNC ( ps.gl_date ) <= : p_as_of_date and ps.customer_trx_id + :"SYS_B_168" = trx.customer_trx_id and ps.customer_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cust_trx_type_id = types.cust_trx_type_id and nvl ( ps.org_id , - :"SYS_B_169" ) = nvl ( types.org_id , - :"SYS_B_170" ) and ps.customer_site_use_id + :"SYS_B_171" = site.site_use_id (+) and site.cust_acct_site_id = addr.cust_acct_site_id (+) and addr.party_site_id = party_site.party_site_id (+) and loc.location_id (+) = party_site.location_id and ps.gl_date_closed > : P_AS_OF_DATE and ps.customer_trx_id + :"SYS_B_172" = gld.customer_trx_id and gld.account_class = :"SYS_B_173" and gld.latest_rec_flag = :"SYS_B_174" and gld.code_combination_id = cc.code_combination_id AND ( TYPES.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_175" FROM hr_organization_information org_info WHERE TYPES.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_176" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_177" ) ) ) AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_178" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_179" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_180" ) ) ) AND ( ADDR.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_181" FROM hr_organization_information org_info WHERE ADDR.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_182" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_183" ) ) ) AND ( GLD.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_184" FROM hr_organization_information org_info WHERE GLD.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_185" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_186" ) ) ) ) AND ( :qi_org_id = ps.org_id) UNION ALL select ps . org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_187" , NULL , - :"SYS_B_188" ) , decode ( UPPER ( : p_order_by ) , :"SYS_B_189" , NULL , decode ( app . applied_payment_schedule_id , - :"SYS_B_190" , : c_claim_meaning , : c_payment_meaning ) ) , decode ( party . party_name , null , :"SYS_B_191" , rtrim ( rpad ( substrb ( :"SYS_B_192" || party . party_name , :"SYS_B_193" , :"SYS_B_194" ) , :"SYS_B_195" ) ) ) , nvl ( cust_acct . cust_account_id , - :"SYS_B_196" ) , cust_acct . account_number , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_197" , :"SYS_B_198" , site . site_use_id ) , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_199" , NULL , substr ( loc . state , :"SYS_B_200" , :"SYS_B_201" ) ) , DECODE ( UPPER ( : p_format _option_low ) , :"SYS_B_202" , NULL , substr ( loc . city , :"SYS_B_203" , :"SYS_B_204" ) ) , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_205" , :"SYS_B_206" , addr . cust_acct_site_id ) , NULL , ps . payment_schedule_id , ps . class , ps . due_date , - sum ( decode ( : rp_convert_flag , :"SYS_B_207" , app . acctd_amount_applied_from , app . amount_applied ) ) , ps . amount_due_original , ps . trx_number invnum , decode ( UPPER ( : p_order_by ) , :"SYS_B_208" , NULL , decode ( app . applied_payment_schedule_id , - :"SYS_B_209" , : c_claim_meaning , : c_payment_meaning ) ) , ceil ( : P_AS_OF_DATE - ps . due_date ) , ps . amount_adjusted , ps . amount_applied , ps . amount_credited , ps . gl_date , decode ( ps . invoice_currency_code , : functional_currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_210" , NULL ) ) , nvl ( ps . exchange_rate , :"SYS_B_211" ) , Decode ( : rp_bucket_line_type_0 , :"SYS_B_212" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_213" ) , :"SYS_B_214" , :"SYS_B_215" , :"SYS_B_216" ) , :"SYS_B_217" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_218" ) , :"SYS_B_219" , :"SYS_B_220" , :"SYS_B_221" ) , :"SYS_B_222" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_223" ) , :"SYS_B_224" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_225" ) , :"SYS_B_226" , :"SYS_B_227" , :"SYS_B_228" ) , :"SYS_B_229" ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_230" , :"SYS_B_231" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_232" ) , :"SYS_B_233" , :"SYS_B_234" , decode ( : rp_bucket_category , :"SYS_B_235" , :"SYS_B_236" , :"SYS_B_237" , :"SYS_B_238" , :"SYS_B_239" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_240" ) , :"SYS_B_241" , :"SYS_B_242" , decode ( : rp_bucket_category , :"SYS_B_243" , :"SYS_B_244" , :"SYS_B_245" , :"SYS_B_246" , :"SYS_B_247" ) ) ) b0_inv , decode ( : rp_bucket_line_type_1 , :"SYS_B_248" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_249" ) , :"SYS_B_250" , :"SYS_B_251" , :"SYS_B_252" ) , :"SYS_B_253" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_254" ) , :"SYS_B_255" , :"SYS_B_256" , :"SYS_B_257" ) , :"SYS_B_258" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_259" ) , :"SYS_B_260" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_261" ) , :"SYS_B_262" , :"SYS_B_263" , :"SYS_B_264" ) , :"SYS_B_265" ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_266" , :"SYS_B_267" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_268" ) , :"SYS_B_269" , :"SYS_B_270" , decode ( : rp_bucket_category , :"SYS_B_271" , :"SYS_B_272" , :"SYS_B_273" , :"SYS_B_274" , :"SYS_B_275" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_276" ) , :"SYS_B_277" , :"SYS_B_278" , decode ( : rp_bucket_category , :"SYS_B_279" , :"SYS_B_280" , :"SYS_B_281" , :"SYS_B_282 " , :"SYS_B_283" ) ) ) b1_inv , decode ( : rp_bucket_line_type_2 , :"SYS_B_284" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_285" ) , :"SYS_B_286" , :"SYS_B_287" , :"SYS_B_288" ) , :"SYS_B_289" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_290" ) , :"SYS_B_291" , :"SYS_B_292" , :"SYS_B_293" ) , :"SYS_B_294" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_295" ) , :"SYS_B_296" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_297" ) , :"SYS_B_298" , :"SYS_B_299" , :"SYS_B_300" ) , :"SYS_B_301" ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_302" , :"SYS_B_303" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_304" ) , :"SYS_B_305" , :"SYS_B_306" , decode ( : rp_bucket_category , :"SYS_B_307" , :"SYS_B_308" , :"SYS_B_309" , :"SYS_B_310" , :"SYS_B_311" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_312" ) , :"SYS_B_313" , :"SYS_B_314" , decode ( : rp_bucket_category , :"SYS_B_315" , :"SYS_B_316" , :"SYS_B_317" , :"SYS_B_318" , :"SYS_B_319" ) ) ) b2_inv , decode ( : rp_bucket_line_type_3 , :"SYS_B_320" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_321" ) , :"SYS_B_322" , :"SYS_B_323" , :"SYS_B_324" ) , :"SYS_B_325" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_326" ) , :"SYS_B_327" , :"SYS_B_328" , :"SYS_B_329" ) , :"SYS_B_330" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_331" ) , :"SYS_B_332" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_333" ) , :"SYS_B_334" , :"SYS_B_335" , :"SYS_B_336" ) , :"SYS_B_337" ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_338" , :"SYS_B_339" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_340" ) , :"SYS_B_341" , :"SYS_B_342" , decode ( : rp_bucket_category , :"SYS_B_343" , :"SYS_B_344" , :"SYS_B_345" , :"SYS_B_346" , :"SYS_B_347" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_348" ) , :"SYS_B_349" , :"SYS_B_350" , decode ( : rp_bucket_category , :"SYS_B_351" , :"SYS_B_352" , :"SYS_B_353" , :"SYS_B_354" , :"SYS_B_355" ) ) ) b3_inv , cc.segment1 bal_segment_value_inv , ps.trx_number cons_billing_number , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_356" , :"SYS_B_357" ) , : rp_short_unid_phrase ) , :"SYS_B_358" ) ) from AR_PAYMENT_SCHEDULES_ALL ps , AR_RECEIVABLE_APPLICATIONS_ALL app , gl_code_combinations cc , hz_cust_accounts cust_acct , hz_parties party , hz_cust_site_uses_all site , hz_cust_acct_sites_all addr , hz_party_sites party_site , hz_locations loc WHERE ( app.gl_date + :"SYS_B_359" <= : P_AS_OF_DATE and ps.customer_id = cust_acct.cust_account_id (+) and cust_acct.party_id = party.party_id (+) and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cash_receipt_id + :"SYS_B_360" = app.cash_receipt_id and ps.customer_site_use_id + :"SYS_B_361" = site.site_use_id (+) and site.cust _acct_site_id = addr.cust_acct_site_id (+) and addr.party_site_id = party_site.party_site_id (+) and loc.location_id (+) = party_site.location_id and app.code_combination_id = cc.code_combination_id and app.status in ( :"SYS_B_362" , :"SYS_B_363" , :"SYS_B_364" , :"SYS_B_365" ) and nvl ( app.confirmed_flag , :"SYS_B_366" ) = :"SYS_B_367" and ps.gl_date_closed > : P_AS_OF_DATE and ( ( app.reversal_gl_date is not null AND ps.gl_date <= : P_AS_OF_DATE ) OR app.reversal_gl_date is null ) and nvl ( ps.receipt_confirmed_flag , :"SYS_B_368" ) = :"SYS_B_369" AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_370" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_371" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_372" ) ) ) AND ( APP.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_373" FROM hr_organization_information org_info WHERE APP.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_374" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_375" ) ) ) AND ( ADDR.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_376" FROM hr_organization_information org_info WHERE ADDR.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_377" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_378" ) ) ) ) AND ( :qi_org_id = ps.org_id) group by ps.org_id , party.party_name , site.site_use_id , loc.state , loc.city , addr.cust_acct_site_id , cust_acct.cust_account_id , cust_acct.account_number , ps.payment_schedule_id , ps.class , ps.due_date , ps.amount_due_original , ps.trx_number , ps.amount_adjusted , ps.amount_applied , ps.amount_credited , ps.gl_date , ps.amount_in_dispute , ps.amount_adjusted_pending , ps.invoice_currency_code , ps.exchange_rate , cc.segment1 , decode ( app.status , :"SYS_B_379" , :"SYS_B_380" , :"SYS_B_381" ) , ps.trx_number , app.applied_payment_schedule_id UNION ALL select ps . org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_382" , NULL , - :"SYS_B_383" ) , decode ( UPPER ( : p_order_by ) , :"SYS_B_384" , NULL , : c_risk_meaning ) , decode ( party . party_name , null , :"SYS_B_385" , rtrim ( rpad ( substrb ( :"SYS_B_386" || party . party_name , :"SYS_B_387" , :"SYS_B_388" ) , :"SYS_B_389" ) ) ) , cust_acct . cust_account_id , cust_acct . account_number , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_390" , :"SYS_B_391" , site . site_use_id ) , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_392" , NULL , rtrim ( rpad ( loc . state , :"SYS_B_393" ) ) ) , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_394" , NULL , rtrim ( rpad ( loc . city , :"SYS_B_395" ) ) ) , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_396" , :"SYS_B_397" , addr . cust_acct_site_id ) , null , ps . payment_schedule_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_398" , NULL , : c_risk_meaning ) , ps . due_date , decode ( : rp_convert_flag , :"SYS_B_399" , crh . acctd_amount , crh . amount ) , decode ( : rp_convert_flag , :"SYS_B_400" , round ( ( ps . amount_due_original * nvl ( ps . exchange_rate , :"SYS_B_401" ) ) , : func_curr_precision ) , ps . amount_due_original ) , ps . trx_number , decode ( UPPER ( : p_order_by ) , :"SYS_B_402" , NULL , : c_risk_meaning ) , ceil ( : P_AS_OF_DATE - ps . due_date ) , ps . amount_adjusted , ps . amount_applied , ps . amount_credited , crh . gl_date , decode ( ps . invoice_currency_code , : functional_currency , NULL , decode ( ps . exchange_rate , NUL L , :"SYS_B_403" , NULL ) ) , nvl ( ps . exchange_rate , :"SYS_B_404" ) , decode ( : rp_bucket_line_type_0 , :"SYS_B_405" , :"SYS_B_406" , :"SYS_B_407" , :"SYS_B_408" , :"SYS_B_409" , :"SYS_B_410" , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_411" , :"SYS_B_412" ) ) b0_inv , decode ( : rp_bucket_line_type_1 , :"SYS_B_413" , :"SYS_B_414" , :"SYS_B_415" , :"SYS_B_416" , :"SYS_B_417" , :"SYS_B_418" , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_419" , :"SYS_B_420" ) ) b1_inv , decode ( : rp_bucket_line_type_2 , :"SYS_B_421" , :"SYS_B_422" , :"SYS_B_423" , :"SYS_B_424" , :"SYS_B_425" , :"SYS_B_426" , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_427" , :"SYS_B_428" ) ) b2_inv , decode ( : rp_bucket_line_type_3 , :"SYS_B_429" , :"SYS_B_430" , :"SYS_B_431" , :"SYS_B_432" , :"SYS_B_433" , :"SYS_B_434" , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_435" , :"SYS_B_436" ) ) b3_inv , cc.segment1 , ps.trx_number cons_billing_number , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_437" , :"SYS_B_438" ) , : rp_short_unid_phrase ) , :"SYS_B_439" ) ) from hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , hz_cust_site_uses_all site , hz_cust_acct_sites_all addr , hz_party_sites party_site , hz_locations loc , AR_CASH_RECEIPTS_ALL cr , AR_CASH_RECEIPT_HISTORY_ALL crh , gl_code_combinations cc WHERE ( TRUNC ( crh.gl_date ) <= : p_as_of_date and ps.trx_number is not null and upper ( : p_risk_option ) != :"SYS_B_440" and ps.customer_id = cust_acct.cust_account_id (+) and cust_acct.party_id = party.party_id (+) and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cash_receipt_id = cr.cash_receipt_id and cr.cash_receipt_id = crh.cash_receipt_id and crh.account_code_combination_id = cc.code_combination_id and ps.customer_site_use_id = site.site_use_id (+) and site.cust_acct_site_id = addr.cust_acct_site_id (+) and addr.party_site_id = party_site.party_site_id (+) and loc.location_id (+) = party_site.location_id and ( crh.current_record_flag = :"SYS_B_441" or crh.reversal_gl_date > : p_as_of_date ) and crh.status not in ( decode ( crh.factor_flag , :"SYS_B_442" , :"SYS_B_443" , :"SYS_B_444" , :"SYS_B_445" ) , :"SYS_B_446" ) and not exists ( select :"SYS_B_447" from AR_RECEIVABLE_APPLICATIONS_ALL ra where ra.cash_receipt_id = cr.cash_receipt_id and ra.status = :"SYS_B_448" and applied_payment_schedule_id = - :"SYS_B_449" ) AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_450" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_451" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_452" ) ) ) AND ( ADDR.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_453" FROM hr_organization_information org_info WHERE ADDR.org_id = org_info.organization_id AND org_info.org_informat ion_context = :"SYS_B_454" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_455" ) ) ) AND ( CR.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_456" FROM hr_organization_information org_info WHERE CR.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_457" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_458" ) ) ) AND ( CRH.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_459" FROM hr_organization_information org_info WHERE CRH.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_460" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_461" ) ) ) ) AND ( :qi_org_id = ps.org_id) UNION ALL select ps . org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_462" , NULL , types . cust_trx_type_id ) dummy_id_inv , decode ( UPPER ( : p_order_by ) , :"SYS_B_463" , NULL , types . name ) dummy_type_inv , decode ( party . party_name , null , :"SYS_B_464" , rtrim ( rpad ( substrb ( :"SYS_B_465" || party . party_name , :"SYS_B_466" , :"SYS_B_467" ) , :"SYS_B_468" ) ) ) customer_name_inv , cust_acct . cust_account_id customer_id_inv , cust_acct . account_number customer_number_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_469" , :"SYS_B_470" , site . site_use_id ) contact_site_id_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_471" , NULL , rtrim ( rpad ( loc . state , :"SYS_B_472" ) ) ) cust_state_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_473" , NULL , rtrim ( rpad ( loc . city , :"SYS_B_474" ) ) ) cust_city_inv , DECODE ( UPPER ( : p_format_option_low ) , :"SYS_B_475" , :"SYS_B_476" , addr . cust_acct_site_id ) addr_id_inv , null , ps . payment_schedule_id payment_sched_id_inv , ps . class class_inv , ps . due_date due_date_inv , decode ( : rp_convert_flag , :"SYS_B_477" , ps . acctd_amount_due_remaining , ps . amount_due_remaining ) amt_due_remaining_inv , decode ( : rp_convert_flag , :"SYS_B_478" , round ( ( ps . amount_due_original * nvl ( ps . exchange_rate , :"SYS_B_479" ) ) , : func_curr_precision ) , ps . amount_due_original ) amt_due_original_inv , ps . trx_number invnum , types . name invoice_type_inv , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due_inv , ps . amount_adjusted amount_adjusted_inv , ps . amount_applied amount_applied_inv , ps . amount_credited amount_credited_inv , ps . gl_date gl_date_inv , decode ( ps . invoice_currency_code , : functional_currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_480" , NULL ) ) data_converted_inv , nvl ( ps . exchange_rate , :"SYS_B_481" ) ps_exchange_rate_inv , decode ( : rp_bucket_line_type_0 , :"SYS_B_482" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_483" ) , :"SYS_B_484" , :"SYS_B_485" , :"SYS_B_486" ) , :"SYS_B_487" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_488" ) , :"SYS_B_489" , :"SYS_B_490" , :"SYS_B_491" ) , :"SYS_B_492" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_493" ) , :"SYS_B_494" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_495" ) , :"SYS_B_496" , :"SYS_B_497" , :"SYS_B_498" ) , :"SYS_B_499" ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_500" , :"SYS_B_501" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_502" ) , :"SYS_B_503" , :"SYS_B_504" , decode ( : rp_bucket_category , :"SYS_B_505" , :"SYS_B_506" , :"SYS_B_507" , :"SYS_B_508" , :"SYS_B_509" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_510" ) , :"SYS_B_511" , :"SYS_B_512" , decode ( : rp_bucket_category , :"SYS_B_513" , :"SYS_B_514" , :"SYS_B_515" , :"SYS_B_516" , :"SYS_B_517" ) ) ) b0_inv , decode ( : rp_bucket_line_type_1 , :"SYS_B_518" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_519" ) , :"SYS_B_520" , :"SYS_B_521" , :"SYS_B_522" ) , :"SYS_B_523" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_524" ) , :"SYS_B_525" , :"SYS_B_526" , :"SYS_B_527" ) , :"SYS_B_528" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_529" ) , :"SYS_B_530" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_531" ) , :"SYS_B_532" , :"SYS_B_533" , :"SYS_B_534" ) , :"SYS_B_535" ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_536" , :"SYS_B_537" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_538" ) , :"SYS_B_539" , :"SYS_B_540" , decode ( : rp_bucket_category , :"SYS_B_541" , :"SYS_B_542" , :"SYS_B_543" , :"SYS_B_544" , :"SYS_B_545" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_546" ) , :"SYS_B_547" , :"SYS_B_548" , decode ( : rp_bucket_category , :"SYS_B_549" , :"SYS_B_550" , :"SYS_B_551" , :"SYS_B_552" , :"SYS_B_553" ) ) ) b1_inv , decode ( : rp_bucket_line_type_2 , :"SYS_B_554" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_555" ) , :"SYS_B_556" , :"SYS_B_557" , :"SYS_B_558" ) , :"SYS_B_559" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_560" ) , :"SYS_B_561" , :"SYS_B_562" , :"SYS_B_563" ) , :"SYS_B_564" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_565" ) , :"SYS_B_566" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_567" ) , :"SYS_B_568" , :"SYS_B_569" , :"SYS_B_570" ) , :"SYS_B_571" ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_572" , :"SYS_B_573" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_574" ) , :"SYS_B_575" , :"SYS_B_576" , decode ( : rp_bucket_category , :"SYS_B_577" , :"SYS_B_578" , :"SYS_B_579" , :"SYS_B_580" , :"SYS_B_581" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_582" ) , :"SYS_B_583" , :"SYS_B_584" , decode ( : rp_bucket_category , :"SYS_B_585" , :"SYS_B_586" , :"SYS_B_587" , :"SYS_B_588" , :"SYS_B_589" ) ) ) b2_inv , decode ( : rp_bucket_line_type_3 , :"SYS_B_590" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_591" ) , :"SYS_B_592" , :"SYS_B_593" , :"SYS_B_594" ) , :"SYS_B_595" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_596" ) , :"SYS_B_597" , :"SYS_B_598" , :"SYS_B_599" ) , :"SYS_B_600" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_601" ) , :"SYS_B_602" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_ B_603" ) , :"SYS_B_604" , :"SYS_B_605" , :"SYS_B_606" ) , :"SYS_B_607" ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_608" , :"SYS_B_609" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_610" ) , :"SYS_B_611" , :"SYS_B_612" , decode ( : rp_bucket_category , :"SYS_B_613" , :"SYS_B_614" , :"SYS_B_615" , :"SYS_B_616" , :"SYS_B_617" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_618" ) , :"SYS_B_619" , :"SYS_B_620" , decode ( : rp_bucket_category , :"SYS_B_621" , :"SYS_B_622" , :"SYS_B_623" , :"SYS_B_624" , :"SYS_B_625" ) ) ) b3_inv , cc.segment1 bal_segment_value_inv , ps.trx_number cons_billing_number , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_626" , :"SYS_B_627" ) , : rp_short_unid_phrase ) , :"SYS_B_628" ) ) from ra_cust_trx_types_all types , hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , RA_CUSTOMER_TRX_ALL trx , hz_cust_site_uses_all site , hz_cust_acct_sites_all addr , hz_party_sites party_site , hz_locations loc , ar_transaction_history_all th , AR_DISTRIBUTIONS_ALL dist , gl_code_combinations cc WHERE ( TRUNC ( ps.gl_date ) <= : p_as_of_date and ps.class = :"SYS_B_629" and ps.customer_trx_id + :"SYS_B_630" = trx.customer_trx_id and ps.customer_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cust_trx_type_id = types.cust_trx_type_id and nvl ( ps.org_id , - :"SYS_B_631" ) = nvl ( types.org_id , - :"SYS_B_632" ) and ps.customer_site_use_id + :"SYS_B_633" = site.site_use_id (+) and site.cust_acct_site_id = addr.cust_acct_site_id (+) and addr.party_site_id = party_site.party_site_id (+) and loc.location_id (+) = party_site.location_id and ps.gl_date_closed > : P_AS_OF_DATE and ps.customer_trx_id + :"SYS_B_634" = th.customer_trx_id and th.transaction_history_id = dist.source_id and dist.source_table = :"SYS_B_635" and th.transaction_history_id = ( select max ( transaction_history_id ) from ar_transaction_history_all th2 , AR_DISTRIBUTIONS_ALL dist2 where th2.transaction_history_id = dist2.source_id and dist2.source_table = :"SYS_B_636" and th2.gl_date <= : p_as_of_date and dist2.amount_dr is not null and th2.customer_trx_id = ps.customer_trx_id ) and dist.amount_dr is not null and dist.source_table_secondary is NULL and dist.code_combination_id = cc.code_combination_id AND ( TYPES.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_637" FROM hr_organization_information org_info WHERE TYPES.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_638" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_639" ) ) ) AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_640" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_641" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_642" ) ) ) AND ( ADDR.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_643" FROM hr_organization_information org_info WHERE ADDR.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_644" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_645" ) ) ) ) AND ( :qi_org_id = ps.org_id) ORDER BY :"SYS_B_646" ASC, :"SYS_B_647" ASC, :"SYS_B_648" ASC, :"SYS_B_649" ASC, :"SYS_B_650 " ASC, :"SYS_B_651" ASC
095wdjqzchazh	/* $Header: ValueSet.java 120.7.12010000.7 2009/09/01 20:55:44 hgeorgi ship $ */ select :"SYS_B_00" FLEX_ENABLED_FLAG , trunc(to_date(null)) FLEX_START_DATE , trunc(to_date(null)) FLEX_END_DATE , trunc(SysDate) FLEX_SYSDATE , :"SYS_B_01" FLEX_SUMMARY_FLAG , NULL FLEX_COMPILED_VALUE_ATTRIBUTES , WEB_PROMPT FLEX_VALUE , PARAMETER_ID FLEX_DESCRIPTION from AP_EXPENSE_TYPES_V erp, AP_EXPENSE_REPORTS er where ( ((nvl(:1, :"SYS_B_02") != :"SYS_B_03" AND erp.PA_EXPENDITURE_TYPE in (select ga.EXPENDITURE_TYPE from GMS_SSA_AWARD_EXPTYPE_V ga where ga.AWARD_NUMBER = nvl(:2, -:"SYS_B_04") )) OR nvl(:3, :"SYS_B_05") = :"SYS_B_06") AND ((erp.EXPENSE_REPORT_ID = nvl(:4, -:"SYS_B_07")) OR (erp.WEB_ENABLED_FLAG = :"SYS_B_08" AND er.WEB_ENABLED_FLAG = :"SYS_B_09")) AND ( (nvl(:5, :"SYS_B_10") <> :"SYS_B_11" AND nvl(:6, :"SYS_B_12") <> :"SYS_B_13" AND erp.CATEGORY_CODE <> :"SYS_B_14" AND erp.CATEGORY_CODE <> :"SYS_B_15") OR (nvl(:7, :"SYS_B_16") = erp.CATEGORY_CODE) ) AND trunc(sysdate) <= trunc(nvl(er.INACTIVE_DATE, sysdate)) + nvl(:8, :"SYS_B_17") AND trunc(sysdate) <= trunc(nvl(erp.END_DATE, sysdate)) + nvl(:9, :"SYS_B_18") AND (nvl(:10, :"SYS_B_19") = :"SYS_B_20" OR PA_EXPENDITURE_TYPE is not NULL) AND erp.EXPENSE_REPORT_ID = er.EXPENSE_REPORT_ID) and PROMPT = :11
09k3ak8yazq84	SELECT S.BASE_CURRENCY_CODE, :B1 , C.NAME, NVL(S.MULTI_CURRENCY_FLAG, 'N') FROM AP_SYSTEM_PARAMETERS S, FND_CURRENCIES_VL C WHERE C.CURRENCY_CODE = S.BASE_CURRENCY_CODE
0a0c83zxhhh8t	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, :"SYS_B_0") AS ITEM_DESCRIPTION, nvl(erp.line_type_lookup_code, :"SYS_B_1") AS LINE_TYPE_LOOKUP_CODE, erp.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(erp.JUSTIFICATION_REQUIRED_FLAG, :"SYS_B_2") 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, tax.name as tax_code, tax.tax_id, erp.CARD_REQUIRE_RECEIPT_AMOUNT, erp.NEG_RECEIPT_REQUIRED_FLAG FROM AP_EXPENSE_REPORT_PARAMS erp, AP_TAX_CODES tax where erp.vat_code = tax.name(+) and :"SYS_B_3" = tax.WEB_ENABLED_FLAG(+)) QRSLT WHERE PARAMETER_ID = :1
0ns9vs1ctqdsc	SELECT CUSTOMER_TRX_ID COL1, PAYMENT_SCHEDULE_ID COL2, DELINQUENCY_ID COL3, TRX_NUMBER COL4, ACCOUNT_NUMBER COL5, AMOUNT_DUE_ORIGINAL COL6, INVOICE_CURRENCY_CODE COL7, AMOUNT_DUE_REMAINING COL8, INVOICE_CURRENCY_CODE COL9, ACCTD_AMOUNT_DUE_REMAINING COL10, INVOICE_CURRENCY_CODE COL11, INVOICE_CURRENCY_CODE COL12, DAYS_PAST_DUE COL13, CUST_TRX_CLASS_NAME COL14, CUST_TRX_CLASS_CODE COL15, DUE_DATE COL16, TERMS_SEQUENCE_NUMBER COL17, TRX_DATE COL18, TRX_CREATION_DATE COL19, PARTY_SITE_NUMBER COL20, BILL_TO_LOCATION COL21, BILL_TO_ADDRESS COL22, CUST_TRX_TYPE_NAME COL23, CUST_TRX_STATUS_NAME COL24, AMOUNT_IN_DISPUTE COL25, INVOICE_CURRENCY_CODE COL26, DISPUTE_DATE COL27, NULL COL28, NULL COL29, STAGED_DUNNING_LEVEL COL30, PURCHASE_ORDER COL31, NULL COL32, CONS_INV_ID COL33, CONS_BILLING_NUMBER COL34, NULL COL35, NULL COL36, GL_DATE COL37, TERM_NAME COL38, COMMENTS COL39, PRIMARY_SALESREP_NAME COL40, decode(DEFAULT_PRINTING_OPTION, 'NOT', ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y'), '') COL41, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', PRINTING_PENDING) COL42, DELINQUENCY_STATUS COL43, UWQ_STATUS COL44, OPERATING_UNIT COL45, DEL_STATUS_DSP COL46, UNPAID_REASON_MEANING COL47, RECEIVABLES_COMMENTS COL48, RECEIVABLES_INTERNAL_NOTES COL49, RECEIVABLES_SPL_INSTRUCTIONS COL50, ATTRIBUTE_CATEGORY COL51, ATTRIBUTE1 COL52, ATTRIBUTE2 COL53, ATTRIBUTE3 COL54, ATTRIBUTE4 COL55, ATTRIBUTE5 COL56, ATTRIBUTE6 COL57, ATTRIBUTE7 COL58, ATTRIBUTE8 COL59, ATTRIBUTE9 COL60, ATTRIBUTE10 COL61, ATTRIBUTE11 COL62, ATTRIBUTE12 COL63, ATTRIBUTE13 COL64, ATTRIBUTE14 COL65, ATTRIBUTE15 COL66, INTERFACE_HEADER_CONTEXT COL67, INTERFACE_HEADER_ATTRIBUTE1 COL68, INTERFACE_HEADER_ATTRIBUTE2 COL69, INTERFACE_HEADER_ATTRIBUTE3 COL70, INTERFACE_HEADER_ATTRIBUTE4 COL71, INTERFACE_HEADER_ATTRIBUTE5 COL72, INTERFACE_HEADER_ATTRIBUTE6 COL73, INTERFACE_HEADER_ATTRIBUTE7 COL74, INTERFACE_HEADER_ATTRIBUTE8 COL75, INTERFACE_HEADER_ATTRIBUTE9 COL76, INTERFACE_HEADER_ATTRIBUTE10 COL77, INTERFACE_HEADER_ATTRIBUTE11 COL78, INTERFACE_HEADER_ATTRIBUTE12 COL79, INTERFACE_HEADER_ATTRIBUTE13 COL80, INTERFACE_HEADER_ATTRIBUTE14 COL81, INTERFACE_HEADER_ATTRIBUTE15 COL82, GLOBAL_ATTRIBUTE_CATEGORY COL83, GLOBAL_ATTRIBUTE1 COL84, GLOBAL_ATTRIBUTE2 COL85, GLOBAL_ATTRIBUTE3 COL86, GLOBAL_ATTRIBUTE4 COL87, GLOBAL_ATTRIBUTE5 COL88, GLOBAL_ATTRIBUTE6 COL89, GLOBAL_ATTRIBUTE7 COL90, GLOBAL_ATTRIBUTE8 COL91, GLOBAL_ATTRIBUTE9 COL92, GLOBAL_ATTRIBUTE10 COL93, GLOBAL_ATTRIBUTE11 COL94, GLOBAL_ATTRIBUTE12 COL95, GLOBAL_ATTRIBUTE13 COL96, GLOBAL_ATTRIBUTE14 COL97, GLOBAL_ATTRIBUTE15 COL98, ORG_ID COL99, LEGAL_ENTITY_ID COL100, LEGAL_ENTITY_NAME COL101, NULL COL102 FROM IEX_TRANSACTIONS_V WHERE trunc(due_date) >= :B_DUE_DATE_LOW AND trunc(due_date) <= :B_DUE_DATE_HIGH AND customer_id = :B_CUSTOMER_ID AND cust_trx_class_code = :B_TRX_CLASS AND (delinquency_status in ('DELINQUENT', 'PREDELINQUENT') OR (delinquency_status IS NULL AND amount_due_remaining <> 0) OR (delinquency_status = 'CURRENT' AND amount_due_remaining <> 0)) AND (cust_trx_status_code = 'OP') ORDER BY COL16 DESC
0qzp60c3d1prh	SELECT PROMPT FROM AP_EXPENSE_REPORT_PARAMS WHERE PARAMETER_ID = :B1
0wmwsjy9kd92f	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
16614jtsr33r0	begin fnd_date.initialize_with_calendar(:1, null, :2); end;
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;
1wr32ytknh1u9	SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND S.PADDR = P.ADDR
2ksmubnmd5hmh	SELECT ROUND( ( (SUM( DECODE(PS.CLASS, 'INV', 1, 'DM', 1, 'CB', 1, 'DEP', 1, 'BR', 1, 0) * PS.ACCTD_AMOUNT_DUE_REMAINING ) * MAX(SP.CER_DSO_DAYS) ) / DECODE( SUM( DECODE(PS.CLASS, 'INV', 1, 'DM', 1, 'DEP', 1, 0) * DECODE(SIGN (TRUNC(SYSDATE) - PS.TRX_DATE - SP.CER_DSO_DAYS), -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED, 0)) * NVL(PS.EXCHANGE_RATE, 1 ), 0)) , 0, 1, SUM( DECODE(PS.CLASS, 'INV', 1, 'DM', 1, 'DEP', 1, 0) * DECODE(SIGN (TRUNC(SYSDATE) - PS.TRX_DATE - SP.CER_DSO_DAYS), -1, (PS.AMOUNT_DUE_ORIGINAL + NVL(PS.AMOUNT_ADJUSTED, 0)) * NVL(PS.EXCHANGE_RATE, 1 ), 0) ) ) ), 0) FROM AR_SYSTEM_PARAMETERS SP, AR_PAYMENT_SCHEDULES PS WHERE PS.CUSTOMER_ID = :B1 AND NVL(PS.RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y' AND PS.ORG_ID=SP.ORG_ID
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4mjmz2t60yfh4	INSERT INTO GL_POSTING_INTERIM( code_combination_id, period_name, ledger_id, currency_code, period_year, period_num, period_type, account_type, bal_seg_value, actual_flag, encumbrance_type_id, budget_version_id, period_net_dr, period_net_cr, begin_balance_dr, begin_balance_cr, quarter_to_date_dr, quarter_to_date_cr, project_to_date_dr, project_to_date_cr, template_id, translated_flag ) SELECT /*+ ORDERED INDEX (JEB, GL_JE_BATCHES_N1) USE_NL (JEB JEH LED PSTAT1 PSTAT2 BPR JEL CC) */ JEL.code_combination_id, PSTAT2.period_name, JEH.ledger_id, decode(JEH.currency_code, :"SYS_B_000", JEH.currency_code, LED.currency_code), PSTAT2.period_year, PSTAT2.period_num, PSTAT2.period_type, CC.account_type, CC.SEGMENT1, JEH.actual_flag, JEH.encumbrance_type_id, JEH.budget_version_id, nvl(sum(decode(JEL.period_name, PSTAT2.period_name, JEL.accounted_dr, :"SYS_B_001")), :"SYS_B_002"), nvl(sum(decode(JEL.period_name, PSTAT2.period_name, JEL.accounted_cr, :"SYS_B_003")), :"SYS_B_004"), nvl(sum(decode(CC.account_type, :"SYS_B_005", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_006", JEL.accounted_dr), :"SYS_B_007"), :"SYS_B_008", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_009", JEL.accounted_dr), :"SYS_B_010"), :"SYS_B_011", decode(PSTAT2.track_bc_ytd_flag, :"SYS_B_012", decode(JEH.actual_flag, :"SYS_B_013", decode(PSTAT1.period_year * :"SYS_B_014" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_015" + PSTAT2.period_num, :"SYS_B_016", JEL.accounted_dr), :"SYS_B_017", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_018", JEL.accounted_dr), :"SYS_B_019"), :"SYS_B_020", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_021", JEL.accounted_dr), :"SYS_B_022")), decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_023", JEL.accounted_dr), :"SYS_B_024")), :"SYS_B_025", decode(PSTAT2.track_bc_ytd_flag, :"SYS_B_026", decode(JEH.actual_flag, :"SYS_B_027", decode(PSTAT1.period_year * :"SYS_B_028" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_029" + PSTAT2.period_num, :"SYS_B_030", JEL.accounted_dr), :"SYS_B_031", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_032", JEL.accounted_dr), :"SYS_B_033"), :"SYS_B_034", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_035", JEL.accounted_dr), :"SYS_B_036")), decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_037", JEL.accounted_dr), :"SYS_B_038")), decode(JEH.actual_flag, :"SYS_B_039", decode(PSTAT1.period_year * :"SYS_B_040" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_041" + PSTAT2.period_num, :"SYS_B_042", JEL.accounted_dr), :"SYS_B_043", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_044", JEL.accounted_dr), :"SYS_B_045"), :"SYS_B_046", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_047", JEL.accounted_dr), :"SYS_B_048"), :"SYS_B_049"))), :"SYS_B_050"), nvl(sum(decode(CC.account_type, :"SYS_B_051", decode(PSTAT1.period_year, PSTAT2.pe riod_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_052", JEL.accounted_cr), :"SYS_B_053"), :"SYS_B_054", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_055", JEL.accounted_cr), :"SYS_B_056"), :"SYS_B_057", decode(PSTAT2.track_bc_ytd_flag, :"SYS_B_058", decode(JEH.actual_flag, :"SYS_B_059", decode(PSTAT1.period_year * :"SYS_B_060" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_061" + PSTAT2.period_num, :"SYS_B_062", JEL.accounted_cr), :"SYS_B_063", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_064", JEL.accounted_cr), :"SYS_B_065"), :"SYS_B_066", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_067", JEL.accounted_cr), :"SYS_B_068")), decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_069", JEL.accounted_cr), :"SYS_B_070")), :"SYS_B_071", decode(PSTAT2.track_bc_ytd_flag, :"SYS_B_072", decode(JEH.actual_flag, :"SYS_B_073", decode(PSTAT1.period_year * :"SYS_B_074" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_075" + PSTAT2.period_num, :"SYS_B_076", JEL.accounted_cr), :"SYS_B_077", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_078", JEL.accounted_cr), :"SYS_B_079"), :"SYS_B_080", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_081", JEL.accounted_cr), :"SYS_B_082")), decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_083", JEL.accounted_cr), :"SYS_B_084")), decode(JEH.actual_flag, :"SYS_B_085", decode(PSTAT1.period_year * :"SYS_B_086" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_087" + PSTAT2.period_num, :"SYS_B_088", JEL.accounted_cr), :"SYS_B_089", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_090", JEL.accounted_cr), :"SYS_B_091"), :"SYS_B_092", decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_093", JEL.accounted_cr), :"SYS_B_094"), :"SYS_B_095"))), :"SYS_B_096"), nvl(sum(decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.quarter_num, PSTAT2.quarter_num, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_097", JEL.accounted_dr), :"SYS_B_098"), :"SYS_B_099")), :"SYS_B_100"), nvl(sum(decode(PSTAT1.period_year, PSTAT2.period_year, decode(PSTAT1.quarter_num, PSTAT2.quarter_num, decode(PSTAT1.period_num, PSTAT2.period_num, :"SYS_B_101", JEL.accounted_cr), :"SYS_B_102"), :"SYS_B_103")), :"SYS_B_104"), nvl(sum(decode( PSTAT1.period_year * :"SYS_B_105" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_106" + PSTAT2.period_num, :"SYS_B_107", JEL.accounted_dr)), :"SYS_B_108"), nvl(sum(decode( PSTAT1.period_year * :"SYS_B_109" + PSTAT1.period_num, PSTAT2.period_year * :"SYS_B_110" + PSTAT2.period_num, :"SYS_B_111", JEL.accounted_cr)), :"SYS_B_112"), max(CC.template_id), NULL FROM GL_JE_BATCHES JEB, GL_JE_HEADERS JEH, GL_LEDGERS LED, GL_BUDGET_PERIOD_RANGES BPR, GL_PERIOD_STATUSES PSTAT1, GL_PERIOD_STATUSES PSTAT2, GL_JE_LINES JEL, GL_CODE_COMBINATIONS CC WHERE JEB.status = :"SYS_B_113" AND JEB.chart _of_accounts_id = :coa_id AND JEB.posting_run_id = :prun_id AND JEB.average_journal_flag = :"SYS_B_114" AND JEH.je_batch_id = JEB.je_batch_id AND JEH.status != :"SYS_B_115" AND LED.ledger_id = JEH.ledger_id AND JEL.je_header_id = JEH.je_header_id AND nvl(JEL.status, :"SYS_B_116") = :"SYS_B_117" AND CC.code_combination_id = JEL.code_combination_id AND CC.template_id is NULL AND JEH.actual_flag = decode(JEH.actual_flag, :"SYS_B_118", :"SYS_B_119", :"SYS_B_120", :"SYS_B_121", :"SYS_B_122", decode(JEH.currency_code, LED.currency_code, :"SYS_B_123", :"SYS_B_124", :"SYS_B_125", :"SYS_B_126")) AND decode(JEH.actual_flag, :"SYS_B_127", PSTAT2.period_num, :"SYS_B_128") BETWEEN decode(JEH.actual_flag, :"SYS_B_129", bpr.start_period_num, :"SYS_B_130") AND decode(JEH.actual_flag, :"SYS_B_131", bpr.end_period_num, :"SYS_B_132") AND decode(JEH.actual_flag, :"SYS_B_133", bpr.open_flag, :"SYS_B_134") = decode(JEH.actual_flag, :"SYS_B_135", :"SYS_B_136", :"SYS_B_137") AND decode(JEH.actual_flag, :"SYS_B_138", PSTAT2.period_year, :"SYS_B_139") = decode(JEH.actual_flag, :"SYS_B_140", bpr.period_year, :"SYS_B_141") AND JEH.budget_version_id = bpr.budget_version_id(+) AND PSTAT1.application_id = :"SYS_B_142" AND PSTAT1.ledger_id = JEH.ledger_id AND PSTAT1.period_name = JEH.period_name AND PSTAT2.application_id = :"SYS_B_143" AND PSTAT2.ledger_id = JEH.ledger_id AND decode(JEH.actual_flag, :"SYS_B_144", PSTAT2.period_year, :"SYS_B_145") <= decode(JEH.actual_flag, :"SYS_B_146", LED.latest_encumbrance_year, :"SYS_B_147") AND decode(JEH.actual_flag, :"SYS_B_148", :"SYS_B_149", :"SYS_B_150", :"SYS_B_151", nvl(PSTAT2.closing_status, :"SYS_B_152")) IN (:"SYS_B_153", :"SYS_B_154", :"SYS_B_155") AND PSTAT2.effective_period_num >= PSTAT1.effective_period_num GROUP BY JEH.ledger_id, JEH.actual_flag, JEH.encumbrance_type_id, JEH.budget_version_id, JEL.code_combination_id, PSTAT2.period_name, decode(JEH.currency_code, :"SYS_B_156", JEH.currency_code, LED.currency_code), PSTAT2.period_year, PSTAT2.period_num, PSTAT2.period_type, CC.account_type, CC.SEGMENT1
4ygjza9x62zmh	SELECT L.POLICY_LINE_ID FROM AP_POL_HEADERS H, AP_POL_LINES L, AP_POL_SCHEDULE_PERIODS SP, AP_SYSTEM_PARAMETERS SYS, AP_POL_EXRATE_OPTIONS RATE_OPTS, AP_EXPENSE_REPORT_PARAMS_ALL P WHERE P.PARAMETER_ID = :B4 AND H.POLICY_ID = P.COMPANY_POLICY_ID AND H.CATEGORY_CODE <> 'MILEAGE' AND H.CATEGORY_CODE <> 'PER_DIEM' AND :B1 BETWEEN H.START_DATE AND NVL(H.END_DATE, TO_DATE('31-12-4712', 'DD-MM-YYYY')) AND L.POLICY_ID = H.POLICY_ID AND L.STATUS = 'ACTIVE' AND L.SCHEDULE_PERIOD_ID = SP.SCHEDULE_PERIOD_ID AND :B1 BETWEEN SP.START_DATE AND NVL(SP.END_DATE, TO_DATE('31-12-4712', 'DD-MM-YYYY')) AND SYS.ORG_ID = RATE_OPTS.ORG_ID(+) AND (NVL(H.EMPLOYEE_ROLE_FLAG, 'N') = 'N' OR L.ROLE_ID = NVL((SELECT ROLE_ID FROM AP_POL_SCHEDULE_OPTIONS WHERE POLICY_ID = H.POLICY_ID AND OPTION_TYPE = 'EMPLOYEE_ROLE' AND STATUS = 'ACTIVE' AND (END_DATE IS NULL OR END_DATE >= :B1 ) AND ROLE_ID = DECODE(H.ROLE_CODE, 'JOB_GROUP', :B7 , 'POSITION', :B6 , 'GRADE', :B5 , -1)), -1)) AND (NVL(H.LOCATION_FLAG, 'N') = 'N' OR L.LOCATION_ID = :B3 ) AND ( (H.CATEGORY_CODE = 'AIRFARE') OR (L.CURRENCY_CODE = :B2 ) OR (NVL(H.ALLOW_RATE_CONVERSION_CODE, 'NO_CONVERSION') = 'NO_CONVERSION' AND H.CURRENCY_CODE = :B2 ) OR (H.CURRENCY_PREFERENCE = 'SRC' AND H.ALLOW_RATE_CONVERSION_CODE = 'ALLOW_CONVERSION' AND ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) OR ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , SYS.BASE_CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) AND 'Y' = GL_CURRENCY_API.RATE_EXISTS(SYS.BASE_CURRENCY_CODE, L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE))) ) OR (NVL(H.CURRENCY_PREFERENCE, 'LCR') = 'LCR' AND ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) OR ('Y' = GL_CURRENCY_API.RATE_EXISTS(:B2 , SYS.BASE_CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE) AND 'Y' = GL_CURRENCY_API.RATE_EXISTS(SYS.BASE_CURRENCY_CODE, L.CURRENCY_CODE, :B1 , RATE_OPTS.EXCHANGE_RATE_TYPE))) ) ) AND (H.CATEGORY_CODE <> 'ACCOMMODATIONS' OR L.START_OF_SEASON IS NULL OR L.END_OF_SEASON IS NULL OR 'Y' = AP_WEB_POLICY_UTILS.ISDATEINSEASON(:B1 , L.START_OF_SEASON, L.END_OF_SEASON)) AND L.PARENT_LINE_ID IS NULL AND :B1 BETWEEN NVL(L.EFFECTIVE_START_DATE, :B1 ) AND NVL(L.EFFECTIVE_END_DATE, :B1 +1)
5c8xj742thhyr	SELECT BUSINESS_GROUP_ID FROM PA_IMPLEMENTATIONS
5y4fg1527trdk	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_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
61ra3j3bhj409	SELECT /*+ index(ps AR_PAYMENT_SCHEDULES_ALL_CUS2) */ DECODE(:B4 , NULL, PS.ACCTD_AMOUNT_DUE_REMAINING, PS.AMOUNT_DUE_REMAINING), DECODE(:B29 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B28 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B27 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B0, DECODE(:B26 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B25 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B24 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B1, DECODE(:B23 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B22 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B21 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B2, DECODE(:B20 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B19 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B18 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B3, DECODE(:B17 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B16 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B15 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B4, DECODE(:B14 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B13 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B12 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B5, DECODE(:B11 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECO DE( GREATEST(:B10 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B9 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B6 FROM RA_CUST_TRX_TYPES, AR_PAYMENT_SCHEDULES PS WHERE PS.GL_DATE <= :B7 AND PS.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID AND PS.GL_DATE_CLOSED > :B7 AND PS.CUSTOMER_ID = :B6 AND DECODE(:B5 , NULL, PS.CUSTOMER_SITE_USE_ID, :B5 ) = PS.CUSTOMER_SITE_USE_ID AND DECODE(UPPER(:B4 ), NULL, PS.INVOICE_CURRENCY_CODE, UPPER(:B4 )) = PS.INVOICE_CURRENCY_CODE AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'CM') <> PS.CLASS AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'PMT') <> PS.CLASS AND DECODE(:B2 , NULL, RA_CUST_TRX_TYPES.NAME, :B2 ) <= RA_CUST_TRX_TYPES.NAME AND DECODE(:B1 , NULL, RA_CUST_TRX_TYPES.NAME, :B1 ) >= RA_CUST_TRX_TYPES.NAME UNION ALL SELECT /*+ index(ps AR_PAYMENT_SCHEDULES_ALL_CUS2) */ -SUM(DECODE(:B4 , NULL, APP.ACCTD_AMOUNT_APPLIED_FROM, APP.AMOUNT_APPLIED)), DECODE(:B29 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B28 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B27 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B0, DECODE(:B26 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B25 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B24 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)))B1, DECODE(:B23 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B22 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B21 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B2, DECODE(:B20 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B19 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B18 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B3, DECODE(:B17 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B16 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B15 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE _PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B4, DECODE(:B14 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B13 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B12 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B5, DECODE(:B11 , 'DISPUTE_ONLY', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 0, 1), 'PENDADJ_ONLY', DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 'DISPUTE_PENDADJ', DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 0, 1), 1), DECODE( GREATEST(:B10 , CEIL(:B7 -PS.DUE_DATE)), LEAST(:B9 , CEIL(:B7 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B8 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B8 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B6 FROM AR_PAYMENT_SCHEDULES PS, AR_RECEIVABLE_APPLICATIONS APP WHERE APP.GL_DATE+0 <= :B7 AND PS.CASH_RECEIPT_ID+0 = APP.CASH_RECEIPT_ID AND APP.STATUS IN ( 'ACC', 'UNAPP', 'UNID', 'OTHER ACC') AND NVL(APP.CONFIRMED_FLAG, 'Y') = 'Y' AND PS.GL_DATE_CLOSED > :B7 AND (APP.REVERSAL_GL_DATE > :B7 OR APP.REVERSAL_GL_DATE IS NULL ) AND NVL( PS.RECEIPT_CONFIRMED_FLAG, 'Y' ) = 'Y' AND PS.CUSTOMER_ID = :B6 AND DECODE(:B5 , NULL, NVL(PS.CUSTOMER_SITE_USE_ID, -10), :B5 ) = NVL(PS.CUSTOMER_SITE_USE_ID, -10) AND DECODE(UPPER(:B4 ), NULL, PS.INVOICE_CURRENCY_CODE, UPPER(:B4 )) = PS.INVOICE_CURRENCY_CODE AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'CM') <> PS.CLASS AND DECODE(UPPER(:B3 ), 'AGE', 'dummy', 'PMT') <> PS.CLASS GROUP BY PS.DUE_DATE, PS.AMOUNT_DUE_ORIGINAL, PS.AMOUNT_ADJUSTED, PS.AMOUNT_APPLIED, PS.AMOUNT_CREDITED, PS.GL_DATE, PS.AMOUNT_IN_DISPUTE, PS.AMOUNT_ADJUSTED_PENDING, PS.INVOICE_CURRENCY_CODE, PS.EXCHANGE_RATE, PS.CLASS, DECODE( APP.STATUS, 'UNID', 'UNID', 'UNAPP')
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;
6hr29bwvugchr	SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM GMS_IMPLEMENTATIONS WHERE ORG_ID = :B1 AND ENABLED = 'Y')
707cda24y439k	SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0) FROM ar_payment_schedules arp WHERE (arp.customer_id = :cust_account_id and arp.status = 'OP') and ( trunc(sysdate)-trunc(arp.due_date) >= :days_start and trunc(sysdate)-trunc(arp.due_date) <= :days_to and arp.class = :class )
72tm9vzuscjyf	declare sess_id number; tranx_id number; new_tranx_id number; cursor c1 is select transaction_id from icx_transactions where session_id = sess_id and transaction_id = tranx_id;begin sess_id := fnd_session_utilities.XSID_to_SessionID(:1); tranx_id := :2; open c1; fetch c1 into new_tranx_id; if c1%notfound then new_tranx_id := fnd_session_management.CREATETRANSACTION(sess_id); end if; :3 := new_tranx_id;end;
7hs96a541jgxn	begin fnd_session_management.updateSessionContext(p_function_id=>:1, p_application_id=>:2, p_responsibility_id=>:3, p_security_group_id=>:4, p_session_id=>:5, p_transaction_id=>:6); end;
7qs7fx89194u1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
7ujfmgb1j83a3	BEGIN FND_AOLJ_UTIL.SET_NLS_CONTEXT( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13);END;
7z0tsy9zxk6p0	SELECT count(distinct ocahb.id) FROM ar_payment_schedules arp, ar_aging_bucket_lines aabl, ra_customer_trx rct, okl_cnsld_ar_strms_b ocasb, OKL_CNSLD_AR_LINES_B ocalb, OKL_CNSLD_AR_HDRS_B ocahb WHERE (:l_date - arp.due_date) >= aabl.days_start and (:l_date - arp.due_date) <= aabl.days_to and arp.class = :l_class and rct.customer_trx_id = arp.customer_trx_id and ocasb.receivables_invoice_id = rct.customer_trx_id and ocalb.id = ocasb.lln_id and ocahb.id = ocalb.cnr_id and rct.interface_header_attribute9 <> :l_interface_attr and rct.interface_header_context = :l_interface_context and arp.status = :l_status and aabl.aging_bucket_line_id = :bucket_line_id AND arp.customer_id = :cust_account_id
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
91hakq9n36htp	SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
9dq8x6239bhmt	UPDATE AP_EXP_REPORT_DISTS SET (CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, COST_CENTER) = (SELECT NVL(CODE_COMBINATION_ID, :B3 ), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, AP_WEB_DB_EXPDIST_PKG.GETCCSEGMENTVALUE(:B3 ) FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID = :B3 ) WHERE REPORT_DISTRIBUTION_ID = :B2 AND REPORT_HEADER_ID = :B1
9pammshaxxyx0	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, attribute3 => :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_nFreeLunches2 => :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_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);END;
a0b9t5ctnc47j	SELECT REPORT_DISTRIBUTION_ID FROM AP_EXP_REPORT_DISTS WHERE REPORT_HEADER_ID = :B2 AND REPORT_LINE_ID = :B1 AND ROWNUM = 1
aaw4na3kmdfkq	DECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :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 := l_result;END;
ar6ybm8ksq5pf	BEGIN mo_global.init(:1); END;
aw7fu9a9bdyus	SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1
b1rpgkmtm60d1	SELECT EXP_CYCLE_START_DAY_CODE FROM PA_IMPLEMENTATIONS
bkaaqaa5aj3gf	SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID
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;
chkkj84y3mv9s	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, attribute3 => :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_nFreeLunches2 => :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);END;
d8yjzxj75t1cs	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, :"SYS_B_00") AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, :"SYS_B_01") AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, :"SYS_B_02") 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 FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type, AP_POL_ITEMIZATIONS api WHERE parent_type.itemization_all_flag = :"SYS_B_03" AND api.parameter_id = parent_type.parameter_id AND child_type.parameter_id = api.itemization_parameter_id AND child_type.CATEGORY_CODE != :"SYS_B_04" AND child_type.CATEGORY_CODE != :"SYS_B_05" AND (:"SYS_B_06" = :1 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value(:"SYS_B_07"), :"SYS_B_08")) 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, :"SYS_B_09") AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, :"SYS_B_10") AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, :"SYS_B_11") 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 FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type WHERE parent_type.itemization_all_flag = :"SYS_B_12" -- 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 = :"SYS_B_13") AND child_type.CATEGORY_CODE != :"SYS_B_14" AND child_type.CATEGORY_CODE != :"SYS_B_15" AND (:"SYS_B_16" = :2 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value(:"SYS_B_17"), :"SYS_B_18"))) QRSLT WHERE PARENT_EXPENSE_TYPE_ID = :3 ORDER BY WEB_PROMPT
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
dcrschgcxcbkn	begin AP_WEB_EXPENSE_WF.APVALIDATEEXPENSEREPORT (:v1, :v2, :v3, :v4, :v5); end;
dt2vdh82d4hrb	BEGIN :1 := FND_WEB_SEC.validate_login(:2, :3); END;
f1v2hmt6qbkyc	begin fnd_session_management.PUTSESSIONATTRIBUTEVALUE(:1, :2, :3);end;
f2m7b1g3jk389	INSERT INTO AP_EXP_REPORT_DISTS ( REPORT_HEADER_ID, REPORT_LINE_ID, REPORT_DISTRIBUTION_ID, SEQUENCE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, ORG_ID, AMOUNT, PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_ORGANIZATION_ID, COST_CENTER ) SELECT XL.REPORT_HEADER_ID, XL.REPORT_LINE_ID, AP_EXP_REPORT_DISTS_S.NEXTVAL, :B2 , SYSDATE, XL.LAST_UPDATED_BY, SYSDATE, XL.CREATED_BY, XL.CODE_COMBINATION_ID, GL.SEGMENT1, GL.SEGMENT2, GL.SEGMENT3, GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6, GL.SEGMENT7, GL.SEGMENT8, GL.SEGMENT9, GL.SEGMENT10, GL.SEGMENT11, GL.SEGMENT12, GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18, GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24, GL.SEGMENT25, GL.SEGMENT26, GL.SEGMENT27, GL.SEGMENT28, GL.SEGMENT29, GL.SEGMENT30, XL.ORG_ID, XL.AMOUNT, XL.PROJECT_ID, XL.TASK_ID, XL.AWARD_ID, XL.EXPENDITURE_ORGANIZATION_ID, XH.FLEX_CONCATENATED FROM AP_EXPENSE_REPORT_LINES XL, AP_EXPENSE_REPORT_HEADERS XH, GL_CODE_COMBINATIONS GL WHERE XL.REPORT_LINE_ID = :B1 AND XL.REPORT_HEADER_ID = XH.REPORT_HEADER_ID AND GL.CODE_COMBINATION_ID(+) = XL.CODE_COMBINATION_ID
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;
fx3r7cdax24h8	select ps . org_id customer_org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_000" , NULL , types . cust_trx_type_id ) dummy_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_001" , NULL , types . name ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , :"SYS_B_002" , :"SYS_B_003" ) , :"SYS_B_004" ) ) customer_name , cust_acct . cust_account_id customer_id , cust_acct . account_number customer_number , types . name type , ps . payment_schedule_id payment_sched_id , ps . class class , ps . due_date due_date , decode ( : rp_convert_flag , :"SYS_B_005" , ps . acctd_amount_due_remaining , ps . amount_due_remaining ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , ps . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_006" , NULL ) ) data_converted , nvl ( ps . exchange_rate , :"SYS_B_007" ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , :"SYS_B_008" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_009" ) , :"SYS_B_010" , :"SYS_B_011" , :"SYS_B_012" ) , :"SYS_B_013" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_014" ) , :"SYS_B_015" , :"SYS_B_016" , :"SYS_B_017" ) , :"SYS_B_018" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_019" ) , :"SYS_B_020" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_021" ) , :"SYS_B_022" , :"SYS_B_023" , :"SYS_B_024" ) , :"SYS_B_025" ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_026" , :"SYS_B_027" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_028" ) , :"SYS_B_029" , :"SYS_B_030" , decode ( : rp_bucket_category , :"SYS_B_031" , :"SYS_B_032" , :"SYS_B_033" , :"SYS_B_034" , :"SYS_B_035" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_036" ) , :"SYS_B_037" , :"SYS_B_038" , decode ( : rp_bucket_category , :"SYS_B_039" , :"SYS_B_040" , :"SYS_B_041" , :"SYS_B_042" , :"SYS_B_043" ) ) ) b0 , decode ( : rp_bucket_line_type_1 , :"SYS_B_044" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_045" ) , :"SYS_B_046" , :"SYS_B_047" , :"SYS_B_048" ) , :"SYS_B_049" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_050" ) , :"SYS_B_051" , :"SYS_B_052" , :"SYS_B_053" ) , :"SYS_B_054" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_055" ) , :"SYS_B_056" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_057" ) , :"SYS_B_058" , :"SYS_B_059" , :"SYS_B_060" ) , :"SYS_B_061" ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_062" , :"SYS_B_063" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_064" ) , :"SYS_B_065" , :"SYS_B_066" , decode ( : rp_bucket_category , :"SYS_B_067" , :"SYS_B_068" , :"SYS_B_069" , :"SYS_B_070" , :"SYS_B_071" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_072" ) , : "SYS_B_073" , :"SYS_B_074" , decode ( : rp_bucket_category , :"SYS_B_075" , :"SYS_B_076" , :"SYS_B_077" , :"SYS_B_078" , :"SYS_B_079" ) ) ) b1 , decode ( : rp_bucket_line_type_2 , :"SYS_B_080" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_081" ) , :"SYS_B_082" , :"SYS_B_083" , :"SYS_B_084" ) , :"SYS_B_085" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_086" ) , :"SYS_B_087" , :"SYS_B_088" , :"SYS_B_089" ) , :"SYS_B_090" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_091" ) , :"SYS_B_092" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_093" ) , :"SYS_B_094" , :"SYS_B_095" , :"SYS_B_096" ) , :"SYS_B_097" ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_098" , :"SYS_B_099" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_100" ) , :"SYS_B_101" , :"SYS_B_102" , decode ( : rp_bucket_category , :"SYS_B_103" , :"SYS_B_104" , :"SYS_B_105" , :"SYS_B_106" , :"SYS_B_107" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_108" ) , :"SYS_B_109" , :"SYS_B_110" , decode ( : rp_bucket_category , :"SYS_B_111" , :"SYS_B_112" , :"SYS_B_113" , :"SYS_B_114" , :"SYS_B_115" ) ) ) b2 , decode ( : rp_bucket_line_type_3 , :"SYS_B_116" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_117" ) , :"SYS_B_118" , :"SYS_B_119" , :"SYS_B_120" ) , :"SYS_B_121" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_122" ) , :"SYS_B_123" , :"SYS_B_124" , :"SYS_B_125" ) , :"SYS_B_126" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_127" ) , :"SYS_B_128" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_129" ) , :"SYS_B_130" , :"SYS_B_131" , :"SYS_B_132" ) , :"SYS_B_133" ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_134" , :"SYS_B_135" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_136" ) , :"SYS_B_137" , :"SYS_B_138" , decode ( : rp_bucket_category , :"SYS_B_139" , :"SYS_B_140" , :"SYS_B_141" , :"SYS_B_142" , :"SYS_B_143" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_144" ) , :"SYS_B_145" , :"SYS_B_146" , decode ( : rp_bucket_category , :"SYS_B_147" , :"SYS_B_148" , :"SYS_B_149" , :"SYS_B_150" , :"SYS_B_151" ) ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_152" , :"SYS_B_153" ) , : rp_unid_phrase ) , :"SYS_B_154" ) ) customer_name_dsp from ra_cust_trx_types_all types , hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , ra_cust_trx_line_gl_dist_all gld , gl_code_combinations cc WHERE ( TRUNC ( ps.gl_date ) <= : p_as_of_date and ps.customer_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cust_trx_type_id = types.cust_trx_type_id and nvl ( ps.org_id , - :"SYS_B_155" ) = nvl ( types.org_id , - : "SYS_B_156" ) and ps.gl_date_closed > : P_AS_OF_DATE and ps.customer_trx_id + :"SYS_B_157" = gld.customer_trx_id and gld.account_class = :"SYS_B_158" and gld.latest_rec_flag = :"SYS_B_159" and gld.code_combination_id = cc.code_combination_id AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_160" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_161" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_162" ) ) ) AND ( TYPES.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_163" FROM hr_organization_information org_info WHERE TYPES.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_164" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_165" ) ) ) AND ( GLD.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_166" FROM hr_organization_information org_info WHERE GLD.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_167" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_168" ) ) ) ) AND ( :qc_org_id = ps.org_id) UNION ALL select ps . org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_169" , NULL , - :"SYS_B_170" ) dummy_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_171" , NULL , decode ( app . applied_payment_schedule_id , - :"SYS_B_172" , : c_claim_meaning , : c_payment_meaning ) ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , :"SYS_B_173" , :"SYS_B_174" ) , :"SYS_B_175" ) ) customer_name , nvl ( cust_acct . cust_account_id , - :"SYS_B_176" ) customer_id , cust_acct . account_number customer_number , decode ( : p_order_by , :"SYS_B_177" , NULL , decode ( app . applied_payment_schedule_id , - :"SYS_B_178" , : c_claim_meaning , : c_payment_meaning ) ) type , ps . payment_schedule_id payment_sched_id , ps . class class , ps . due_date due_date , - sum ( decode ( : rp_convert_flag , :"SYS_B_179" , app . acctd_amount_applied_from , app . amount_applied ) ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , ps . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_180" , NULL ) ) data_converted , nvl ( ps . exchange_rate , :"SYS_B_181" ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , :"SYS_B_182" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_183" ) , :"SYS_B_184" , :"SYS_B_185" , :"SYS_B_186" ) , :"SYS_B_187" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_188" ) , :"SYS_B_189" , :"SYS_B_190" , :"SYS_B_191" ) , :"SYS_B_192" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_193" ) , :"SYS_B_194" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_195" ) , :"SYS_B_196" , :"SYS_B_197" , :"SYS_B_198" ) , :"SYS_B_199" ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_200" , :"SYS_B_201" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_202" ) , :"SYS_B_203" , :"SYS_B_204" , decode ( : rp_bucket_category , :"SYS_B_205" , :"SYS_B_206" , :"SYS_B_207" , :"SYS_B_208" , :"SYS_B_209" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_210" ) , : "SYS_B_211" , :"SYS_B_212" , decode ( : rp_bucket_category , :"SYS_B_213" , :"SYS_B_214" , :"SYS_B_215" , :"SYS_B_216" , :"SYS_B_217" ) ) ) b0 , decode ( : rp_bucket_line_type_1 , :"SYS_B_218" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_219" ) , :"SYS_B_220" , :"SYS_B_221" , :"SYS_B_222" ) , :"SYS_B_223" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_224" ) , :"SYS_B_225" , :"SYS_B_226" , :"SYS_B_227" ) , :"SYS_B_228" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_229" ) , :"SYS_B_230" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_231" ) , :"SYS_B_232" , :"SYS_B_233" , :"SYS_B_234" ) , :"SYS_B_235" ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_236" , :"SYS_B_237" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_238" ) , :"SYS_B_239" , :"SYS_B_240" , decode ( : rp_bucket_category , :"SYS_B_241" , :"SYS_B_242" , :"SYS_B_243" , :"SYS_B_244" , :"SYS_B_245" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_246" ) , :"SYS_B_247" , :"SYS_B_248" , decode ( : rp_bucket_category , :"SYS_B_249" , :"SYS_B_250" , :"SYS_B_251" , :"SYS_B_252" , :"SYS_B_253" ) ) ) b1 , decode ( : rp_bucket_line_type_2 , :"SYS_B_254" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_255" ) , :"SYS_B_256" , :"SYS_B_257" , :"SYS_B_258" ) , :"SYS_B_259" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_260" ) , :"SYS_B_261" , :"SYS_B_262" , :"SYS_B_263" ) , :"SYS_B_264" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_265" ) , :"SYS_B_266" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_267" ) , :"SYS_B_268" , :"SYS_B_269" , :"SYS_B_270" ) , :"SYS_B_271" ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_272" , :"SYS_B_273" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_274" ) , :"SYS_B_275" , :"SYS_B_276" , decode ( : rp_bucket_category , :"SYS_B_277" , :"SYS_B_278" , :"SYS_B_279" , :"SYS_B_280" , :"SYS_B_281" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_282" ) , :"SYS_B_283" , :"SYS_B_284" , decode ( : rp_bucket_category , :"SYS_B_285" , :"SYS_B_286" , :"SYS_B_287" , :"SYS_B_288" , :"SYS_B_289" ) ) ) b2 , decode ( : rp_bucket_line_type_3 , :"SYS_B_290" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_291" ) , :"SYS_B_292" , :"SYS_B_293" , :"SYS_B_294" ) , :"SYS_B_295" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_296" ) , :"SYS_B_297" , :"SYS_B_298" , :"SYS_B_299" ) , :"SYS_B_300" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_301" ) , :"SYS_B_302" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_303" ) , :"SYS_B_304" , :"SYS_B_305" , :"SYS_B_306" ) , :"SYS_B_307" ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_308" , :"SYS_B_309" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_310" ) , :"SYS_B_311" , :"SYS_B_312" , decode ( : rp_bucket_category , :"SYS_B_313" , :"SYS_B_314" , :"SYS_B_315" , :"SYS_B_316" , :"SYS_B_317" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_318" ) , :"SYS_B_319" , :"SYS_B_320" , decode ( : rp_bucket_category , :"SYS_B_321" , :"SYS_B_322" , :"SYS_B_323" , :"SYS_B_324" , :"SYS_B_325" ) ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_326" , :"SYS_B_327" ) , : rp_unid_phrase ) , :"SYS_B_328" ) ) customer_name_dsp from AR_PAYMENT_SCHEDULES_ALL ps , AR_RECEIVABLE_APPLICATIONS_ALL app , gl_code_combinations cc , hz_cust_accounts cust_acct , hz_parties party WHERE ( app.gl_date + :"SYS_B_329" <= : P_AS_OF_DATE and ps.customer_id = cust_acct.cust_account_id (+) and cust_acct.party_id = party.party_id (+) and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cash_receipt_id + :"SYS_B_330" = app.cash_receipt_id and app.code_combination_id = cc.code_combination_id and app.status in ( :"SYS_B_331" , :"SYS_B_332" , :"SYS_B_333" , :"SYS_B_334" ) and nvl ( app.confirmed_flag , :"SYS_B_335" ) = :"SYS_B_336" and ps.gl_date_closed > : P_AS_OF_DATE and ( ( app.reversal_gl_date is not null AND ps.gl_date <= : P_AS_OF_DATE ) OR app.reversal_gl_date is null ) and nvl ( ps.receipt_confirmed_flag , :"SYS_B_337" ) = :"SYS_B_338" AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_339" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_340" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_341" ) ) ) AND ( APP.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_342" FROM hr_organization_information org_info WHERE APP.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_343" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_344" ) ) ) ) AND ( :qc_org_id = ps.org_id) group by ps.org_id , party.party_name , cust_acct.account_number , cust_acct.cust_account_id , ps.payment_schedule_id , app.applied_payment_schedule_id , ps.due_date , ps.amount_due_original , ps.amount_adjusted , ps.amount_applied , ps.amount_credited , ps.gl_date , ps.amount_in_dispute , ps.amount_adjusted_pending , ps.invoice_currency_code , ps.exchange_rate , ps.class , cc.SEGMENT1 , decode ( app.status , :"SYS_B_345" , :"SYS_B_346" , :"SYS_B_347" ) UNION ALL select ps . org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_348" , NULL , - :"SYS_B_349" ) , decode ( UPPER ( : p_order_by ) , :"SYS_B_350" , NULL , : c_risk_meaning ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , :"SYS_B_351" , :"SYS_B_352" ) , :"SYS_B_353" ) ) customer_name , nvl ( cust_acct . cust_account_id , - :"SYS_B_354" ) customer_id , cust_acct . account_number customer_number , : c_risk_meaning type , ps . payment_schedule_id payment_sched_id , : c_risk_meaning class , ps . due_date due_date , decode ( : rp_convert_flag , :"SYS_B_355" , crh . acctd_amount , crh . amount ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount _credited amount_credited , crh . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_356" , NULL ) ) data_converted , nvl ( ps . exchange_rate , :"SYS_B_357" ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , :"SYS_B_358" , :"SYS_B_359" , :"SYS_B_360" , :"SYS_B_361" , :"SYS_B_362" , :"SYS_B_363" , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_364" , :"SYS_B_365" ) ) b0 , decode ( : rp_bucket_line_type_1 , :"SYS_B_366" , :"SYS_B_367" , :"SYS_B_368" , :"SYS_B_369" , :"SYS_B_370" , :"SYS_B_371" , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_372" , :"SYS_B_373" ) ) b1 , decode ( : rp_bucket_line_type_2 , :"SYS_B_374" , :"SYS_B_375" , :"SYS_B_376" , :"SYS_B_377" , :"SYS_B_378" , :"SYS_B_379" , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_380" , :"SYS_B_381" ) ) b2 , decode ( : rp_bucket_line_type_3 , :"SYS_B_382" , :"SYS_B_383" , :"SYS_B_384" , :"SYS_B_385" , :"SYS_B_386" , :"SYS_B_387" , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_388" , :"SYS_B_389" ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_390" , :"SYS_B_391" ) , : rp_unid_phrase ) , :"SYS_B_392" ) ) customer_name_dsp from hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , AR_CASH_RECEIPTS_ALL cr , AR_CASH_RECEIPT_HISTORY_ALL crh , gl_code_combinations cc WHERE ( crh.gl_date + :"SYS_B_393" <= : P_AS_OF_DATE and upper ( : p_risk_option ) != :"SYS_B_394" and ps.customer_id = cust_acct.cust_account_id (+) and cust_acct.party_id = party.party_id (+) and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cash_receipt_id = cr.cash_receipt_id and cr.cash_receipt_id = crh.cash_receipt_id and crh.account_code_combination_id = cc.code_combination_id and ( crh.current_record_flag = :"SYS_B_395" or crh.reversal_gl_date > : p_as_of_date ) and crh.status not in ( decode ( crh.factor_flag , :"SYS_B_396" , :"SYS_B_397" , :"SYS_B_398" , :"SYS_B_399" ) , :"SYS_B_400" ) and not exists ( select :"SYS_B_401" from AR_RECEIVABLE_APPLICATIONS_ALL ra where ra.cash_receipt_id = cr.cash_receipt_id and ra.status = :"SYS_B_402" and applied_payment_schedule_id = - :"SYS_B_403" ) AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_404" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_405" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_406" ) ) ) AND ( CR.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_407" FROM hr_organization_information org_info WHERE CR.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_408" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_409" ) ) ) AND ( CRH.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_ B_410" FROM hr_organization_information org_info WHERE CRH.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_411" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_412" ) ) ) ) AND ( :qc_org_id = ps.org_id) UNION ALL select ps . org_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_413" , NULL , types . cust_trx_type_id ) dummy_id , decode ( UPPER ( : p_order_by ) , :"SYS_B_414" , NULL , types . name ) dummy_type , rtrim ( rpad ( substrb ( party . party_name , :"SYS_B_415" , :"SYS_B_416" ) , :"SYS_B_417" ) ) customer_name , cust_acct . cust_account_id customer_id , cust_acct . account_number customer_number , types . name type , ps . payment_schedule_id payment_sched_id , ps . class class , ps . due_date due_date , decode ( : rp_convert_flag , :"SYS_B_418" , ps . acctd_amount_due_remaining , ps . amount_due_remaining ) amt_due_remaining , ps . amount_due_original amt_due_original , ceil ( : P_AS_OF_DATE - ps . due_date ) days_past_due , ps . amount_adjusted amount_adjusted , ps . amount_applied amount_applied , ps . amount_credited amount_credited , ps . gl_date gl_date , decode ( ps . invoice_currency_code , : Functional_Currency , NULL , decode ( ps . exchange_rate , NULL , :"SYS_B_419" , NULL ) ) data_converted , nvl ( ps . exchange_rate , :"SYS_B_420" ) ps_exchange_rate , decode ( : rp_bucket_line_type_0 , :"SYS_B_421" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_422" ) , :"SYS_B_423" , :"SYS_B_424" , :"SYS_B_425" ) , :"SYS_B_426" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_427" ) , :"SYS_B_428" , :"SYS_B_429" , :"SYS_B_430" ) , :"SYS_B_431" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_432" ) , :"SYS_B_433" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_434" ) , :"SYS_B_435" , :"SYS_B_436" , :"SYS_B_437" ) , :"SYS_B_438" ) , decode ( greatest ( : rp_bucket_days_from_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_0 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_439" , :"SYS_B_440" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_441" ) , :"SYS_B_442" , :"SYS_B_443" , decode ( : rp_bucket_category , :"SYS_B_444" , :"SYS_B_445" , :"SYS_B_446" , :"SYS_B_447" , :"SYS_B_448" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_449" ) , :"SYS_B_450" , :"SYS_B_451" , decode ( : rp_bucket_category , :"SYS_B_452" , :"SYS_B_453" , :"SYS_B_454" , :"SYS_B_455" , :"SYS_B_456" ) ) ) b0 , decode ( : rp_bucket_line_type_1 , :"SYS_B_457" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_458" ) , :"SYS_B_459" , :"SYS_B_460" , :"SYS_B_461" ) , :"SYS_B_462" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_463" ) , :"SYS_B_464" , :"SYS_B_465" , :"SYS_B_466" ) , :"SYS_B_467" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_468" ) , :"SYS_B_469" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_470" ) , :"SYS_B_471" , :"SYS_B_472" , :"SYS_B_473" ) , :"SYS_B_474" ) , decode ( greatest ( : rp_bucket_days_from_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_1 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_475" , :"SYS_B_476" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_477" ) , :"SYS_B_478" , :"SYS_B_ 479" , decode ( : rp_bucket_category , :"SYS_B_480" , :"SYS_B_481" , :"SYS_B_482" , :"SYS_B_483" , :"SYS_B_484" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_485" ) , :"SYS_B_486" , :"SYS_B_487" , decode ( : rp_bucket_category , :"SYS_B_488" , :"SYS_B_489" , :"SYS_B_490" , :"SYS_B_491" , :"SYS_B_492" ) ) ) b1 , decode ( : rp_bucket_line_type_2 , :"SYS_B_493" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_494" ) , :"SYS_B_495" , :"SYS_B_496" , :"SYS_B_497" ) , :"SYS_B_498" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_499" ) , :"SYS_B_500" , :"SYS_B_501" , :"SYS_B_502" ) , :"SYS_B_503" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_504" ) , :"SYS_B_505" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_506" ) , :"SYS_B_507" , :"SYS_B_508" , :"SYS_B_509" ) , :"SYS_B_510" ) , decode ( greatest ( : rp_bucket_days_from_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_2 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_511" , :"SYS_B_512" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_513" ) , :"SYS_B_514" , :"SYS_B_515" , decode ( : rp_bucket_category , :"SYS_B_516" , :"SYS_B_517" , :"SYS_B_518" , :"SYS_B_519" , :"SYS_B_520" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_521" ) , :"SYS_B_522" , :"SYS_B_523" , decode ( : rp_bucket_category , :"SYS_B_524" , :"SYS_B_525" , :"SYS_B_526" , :"SYS_B_527" , :"SYS_B_528" ) ) ) b2 , decode ( : rp_bucket_line_type_3 , :"SYS_B_529" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_530" ) , :"SYS_B_531" , :"SYS_B_532" , :"SYS_B_533" ) , :"SYS_B_534" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_535" ) , :"SYS_B_536" , :"SYS_B_537" , :"SYS_B_538" ) , :"SYS_B_539" , decode ( nvl ( ps . amount_in_dispute , :"SYS_B_540" ) , :"SYS_B_541" , decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_542" ) , :"SYS_B_543" , :"SYS_B_544" , :"SYS_B_545" ) , :"SYS_B_546" ) , decode ( greatest ( : rp_bucket_days_from_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , least ( : rp_bucket_days_to_3 , ceil ( : P_AS_OF_DATE - ps . due_date ) ) , :"SYS_B_547" , :"SYS_B_548" ) * decode ( nvl ( ps . amount_in_dispute , :"SYS_B_549" ) , :"SYS_B_550" , :"SYS_B_551" , decode ( : rp_bucket_category , :"SYS_B_552" , :"SYS_B_553" , :"SYS_B_554" , :"SYS_B_555" , :"SYS_B_556" ) ) * decode ( nvl ( ps . amount_adjusted_pending , :"SYS_B_557" ) , :"SYS_B_558" , :"SYS_B_559" , decode ( : rp_bucket_category , :"SYS_B_560" , :"SYS_B_561" , :"SYS_B_562" , :"SYS_B_563" , :"SYS_B_564" ) ) ) b3 , cc.SEGMENT1 bal_segment_value , rtrim ( rpad ( nvl ( substrb ( party . party_name , :"SYS_B_565" , :"SYS_B_566" ) , : rp_unid_phrase ) , :"SYS_B_567" ) ) customer_name_dsp from ra_cust_trx_types_all types , hz_cust_accounts cust_acct , hz_parties party , AR_PAYMENT_SCHEDULES_ALL ps , ar_transaction_history_all th , AR_DISTRIBUTIONS_ALL dist , gl_code_combinations cc WHERE ( TRUNC ( ps.gl_date ) <= : p_as_of_date and ps.class = :"SYS_B_568" and ps.custome r_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cust_acct.account_number >= : p_customer_number_low and cust_acct.account_number <= : p_customer_number_high and ps.cust_trx_type_id = types.cust_trx_type_id and nvl ( ps.org_id , - :"SYS_B_569" ) = nvl ( types.org_id , - :"SYS_B_570" ) and ps.gl_date_closed > : P_AS_OF_DATE and ps.customer_trx_id + :"SYS_B_571" = th.customer_trx_id and th.transaction_history_id = dist.source_id and dist.source_table = :"SYS_B_572" and th.transaction_history_id = ( select max ( transaction_history_id ) from ar_transaction_history_all th2 , AR_DISTRIBUTIONS_ALL dist2 where th2.transaction_history_id = dist2.source_id and dist2.source_table = :"SYS_B_573" and th2.gl_date <= : p_as_of_date and dist2.amount_dr is not null and th2.customer_trx_id = ps.customer_trx_id ) and dist.amount_dr is not null and dist.source_table_secondary is NULL and dist.code_combination_id = cc.code_combination_id AND ( PS.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_574" FROM hr_organization_information org_info WHERE PS.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_575" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_576" ) ) ) AND ( TYPES.org_id IS NULL OR EXISTS ( SELECT /*+ */ :"SYS_B_577" FROM hr_organization_information org_info WHERE TYPES.org_id = org_info.organization_id AND org_info.org_information_context = :"SYS_B_578" AND org_info.org_information3 = TO_CHAR ( :"SYS_B_579" ) ) ) ) AND ( :qc_org_id = ps.org_id) ORDER BY :"SYS_B_580" ASC, :"SYS_B_581" ASC, :"SYS_B_582" ASC, :"SYS_B_583" ASC, :"SYS_B_584" ASC , :"SYS_B_585" , :"SYS_B_586" , :"SYS_B_587"

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: 1,531,119

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

No data exists for this section of the report.

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.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Mutex Sleep Summary
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
• "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
• "Pct Misses" for both should be very close to 0.0