WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
EBSDB	716424792	ebsdb	1	18-Jul-18 14:07	11.2.0.4.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
bmora11t	Linux x86 64-bit	16	8	2	503.53

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	345	20-Jul-18 15:00:18	1491	16.8
End Snap:	348	20-Jul-18 17:07:56	946	17.5
Elapsed:		127.64 (mins)
DB Time:		616.22 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	4.8	0.1	0.00	0.00
DB CPU(s):	4.8	0.1	0.00	0.00
Redo size (bytes):	1,721,890.7	33,082.0
Logical read (blocks):	360,780.0	6,931.5
Block changes:	10,310.3	198.1
Physical read (blocks):	4.3	0.1
Physical write (blocks):	224.0	4.3
Read IO requests:	4.2	0.1
Write IO requests:	125.9	2.4
Read IO (MB):	0.0	0.0
Write IO (MB):	1.8	0.0
User calls:	2,733.6	52.5
Parses (SQL):	2,036.5	39.1
Hard parses (SQL):	0.7	0.0
SQL Work Area (MB):	57.6	1.1
Logons:	0.9	0.0
Executes (SQL):	9,642.2	185.3
Rollbacks:	3.0	0.1
Transactions:	52.1

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.00	Soft Parse %:	99.97
Execute to Parse %:	78.88	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	82.72	% Non-Parse CPU:	99.58

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

Host CPU

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
16	8	2	4.29	1.92	35.7	2.7	0.0	61.5

Instance CPU

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

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	205.2	6.6	198.6
Database Requests:	130.1	4.2	125.9
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	72.0	0.0	71.9
Total (MB):	3.6	0.1	3.5
Database (MB):	1.8	0.0	1.8
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	1.7	0.0	1.7
Database (blocks):	228.3	4.3	224.0
Via Buffer Cache (blocks):	224.0	0.8	223.2
Direct (blocks):	4.4	3.6	0.8

Memory Statistics

	Begin	End
Host Mem (MB):	515,617.1	515,617.1
SGA use (MB):	30,720.0	30,720.0
PGA use (MB):	9,276.5	4,187.1
% Host Mem used for SGA+PGA:	7.76	6.77

Cache Sizes

	Begin	End
Buffer Cache:	26,176M	25,984M	Std Block Size:	8K
Shared Pool Size:	3,110M	3,234M	Log Buffer:	53,948K

Shared Pool Statistics

	Begin	End
Memory Usage %:	63.18	44.06
% SQL with executions>1:	85.29	93.11
% Memory for SQL w/exec>1:	57.79	91.38

Main Report

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

Wait Events Statistics

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

Time Model Statistics

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 98.8% of Total DB time 36,973.08 (s)
• Total FG Wait Time: 150.07 (s) DB CPU time: 36,396.61 (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 59.2% of Total DB Time (s): 36,973
• Captured PL/SQL account for 2.8% of Total DB Time (s): 36,973

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 59.3% of Total CPU Time (s): 36,397
• Captured PL/SQL account for 2.8% of Total CPU Time (s): 36,397

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.2% of Total User I/O Wait Time (s): 3
• Captured PL/SQL account for 1.3% of Total User I/O Wait Time (s): 3

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 2,763,038,829
• Captured SQL account for 79.5% 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: 33,255
• Captured SQL account for 0.1% 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: 31,981
• Captured SQL account for 4.8% of Total
• Total UnOptimized Read Requests: 31,981
• Captured SQL account for 4.8% 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: 73,844,592
• Captured SQL account for 7.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 15,596,762
• Captured SQL account for 7.9% 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
0dfwu7658tj9k	BEGIN QP_Attr_Mapping_PUB.G_Temp_Value := QP_SOURCING_API_PUB.Get_Order_Amount(OE_ORDER_PUB.G_HDR.header_id); END;
0hfaqhz3gz1zw	SELECT DISTINCT PROFILE_CLASS_ID FROM HZ_CUSTOMER_PROFILES WHERE CUST_ACCOUNT_ID = :B1
12usbjyja22u1	select item, item_id, item_description, inventory_item_id, item_identifier_type, decode(item_identifier_type, 'INT', :1, 'CUST', :2, item_identifier_type) item_identifier_type_meaning, inventory_item, Address, cust_address, item_definition_level , RANK from oe_items_v where ( UPPER(ITEM) LIKE :3 AND (ITEM LIKE :4 OR ITEM LIKE :5 OR ITEM LIKE :6 OR ITEM LIKE :7)) AND ( (sold_to_org_id = :8 or sold_to_org_id is null) and (item_status ='ACTIVE' or item_status IS NULL) and (cross_ref_status = 'ACTIVE' or cross_ref_status IS NULL) ) order by item
132qdnqs38dx2	SELECT 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(:B8 -PS.DUE_DATE)), LEAST(:B27 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE )), LEAST(:B24 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B21 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B18 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B15 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B12 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B9 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B6 FROM RA_CUST_TRX_TYPES, AR_PAYMENT_SCHEDULES PS WHERE PS.CUST_TRX_TYPE_ID = RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID AND PS.CUSTOMER_ID = :B6 AND RA_CUST_TRX_TYPES.ORG_ID= PS.ORG_ID 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 AND PS.STATUS = 'OP' UNION ALL SELECT -SUM(DECODE(:B4 , NU LL, 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(:B8 -PS.DUE_DATE)), LEAST(:B27 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B24 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B21 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B18 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B15 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , ' 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(:B8 -PS.DUE_DATE)), LEAST(:B12 , CEIL(:B8 -PS.DUE_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , '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(:B8 -PS.DUE_DATE)), LEAST(:B9 , CEIL(:B8 -PS.DU E_DATE)), 1, 0) * DECODE(NVL(PS.AMOUNT_IN_DISPUTE, 0), 0, 1, DECODE(:B7 , 'DISPUTE_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1)) * DECODE(NVL(PS.AMOUNT_ADJUSTED_PENDING, 0), 0, 1, DECODE(:B7 , 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0, 1))) B6 FROM AR_PAYMENT_SCHEDULES PS, AR_RECEIVABLE_APPLICATIONS APP WHERE 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 (APP.REVERSAL_GL_DATE > :B8 OR APP.REVERSAL_GL_DATE IS NULL ) AND NVL( PS.RECEIPT_CONFIRMED_FLAG, 'Y' ) = 'Y' AND PS.CUSTOMER_ID = :B6 AND PS.ORG_ID=APP.ORG_ID 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 AND PS.STATUS = 'OP' 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')
162ttnv4ubqun	begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1t4ykj11rtya1	begin FND_MESSAGE.RETRIEVE(:result); end;
279sut03s49jd	SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID , NULL IS_RESERVABLE_LOT FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL, X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DETAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT ( :B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) ) ) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_I D LOCATOR_ID , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID), NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID))) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , DECODE (MP.PROCESS_ENABLED_FLAG, 'Y', DECODE ((SELECT MOVE_ORDER_TYPE FROM MTL_ TXN_REQUEST_HEADERS MTRH WHERE HEADER_ID = MMTT.MOVE_ORDER_HEADER_ID AND ROWNUM = 1), 5, 28, MMTT.TRANSACTION_ACTION_ID), MMTT.TRANSACTION_ACTION_ID), TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_PARAMETERS MP WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34)) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) AND MMTT.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID, 3, MMTT.TRANSFER_ORGANIZATION, MMTT.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUM BER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(NVL(MMTT.TRANSACTION_STATUS, 0), 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 6, 1 ), 1) QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND DECODE( NVL(MMTT.TRANSACTION_STATUS, 0), 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 2), 1 ) <> 2 AND (MMTT.TRANSACTION_ACTION_ID IN (2, 3) OR (MMTT.TRANSACTION_ACTION_ID = 28 AND :B4 = MMTT.TRANSACTION_SOURCE_ID AND NVL(:B3 , -9999) = NVL(MMTT.TRX_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MMTT.TRANSACTION_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MM TT.TRX_SOURCE_DELIVERY_ID, -9999) ) ) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ( (:B11 = 1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRA NSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
29291gnwbbcqs	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, DUNNING_LEVEL_OVERRIDE_DATE COL31, PURCHASE_ORDER COL32, NULL COL33, CONS_INV_ID COL34, CONS_BILLING_NUMBER COL35, NULL COL36, NULL COL37, GL_DATE COL38, TERM_NAME COL39, COMMENTS COL40, PRIMARY_SALESREP_NAME COL41, decode(DEFAULT_PRIN TING_OPTION, 'NOT', ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y'), '') COL42, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', PRINTING_PENDING) COL43, DELINQUENCY_STATUS COL44, UWQ_STATUS COL45, OPERATING_UNIT COL46, DEL_STATUS_DSP COL47, UNPAID_REASON_MEANING COL48, RECEIVABLES_COMMENTS COL49, RECEIVABLES_INTERNAL_NOTES COL50, RECEIVABLES_SPL_INSTRUCTIONS COL51, ATTRIBUTE_CATEGORY COL52, ATTRIBUTE1 COL53, ATTRIBUTE2 COL54, ATTRIBUTE3 COL55, ATTRIBUTE4 COL56, ATTRIBUTE5 COL57, ATTRIBUTE6 COL58, ATTRIBUTE7 COL59, ATTRIBUTE8 COL60, ATTRIBUTE9 COL61, ATTRIBUTE10 COL62, ATTRIBUTE11 COL63, ATTRIBUTE12 COL64, ATTRIBUTE13 COL65, ATTRIBUTE14 COL66, ATTRIBUTE15 COL67, INTERFACE_HEADER_CONTEXT COL68, INTERFACE_HEADER_ATTRIBUTE1 COL69, INTERFACE_HEADER_ATTRIBUTE2 COL70, INTERFACE_HEADER_ATTRIBUTE3 COL71, INTERFACE_HEADER_ATTRIBUTE4 COL72, INTERFACE_HEADER_ATTRIBUTE5 COL73, INTERFACE_HEADER_ATTRIBUTE6 COL74, INTERFACE_HEADER_ATTRIBUTE7 COL75, INTERFACE _HEADER_ATTRIBUTE8 COL76, INTERFACE_HEADER_ATTRIBUTE9 COL77, INTERFACE_HEADER_ATTRIBUTE10 COL78, INTERFACE_HEADER_ATTRIBUTE11 COL79, INTERFACE_HEADER_ATTRIBUTE12 COL80, INTERFACE_HEADER_ATTRIBUTE13 COL81, INTERFACE_HEADER_ATTRIBUTE14 COL82, INTERFACE_HEADER_ATTRIBUTE15 COL83, GLOBAL_ATTRIBUTE_CATEGORY COL84, GLOBAL_ATTRIBUTE1 COL85, GLOBAL_ATTRIBUTE2 COL86, GLOBAL_ATTRIBUTE3 COL87, GLOBAL_ATTRIBUTE4 COL88, GLOBAL_ATTRIBUTE5 COL89, GLOBAL_ATTRIBUTE6 COL90, GLOBAL_ATTRIBUTE7 COL91, GLOBAL_ATTRIBUTE8 COL92, GLOBAL_ATTRIBUTE9 COL93, GLOBAL_ATTRIBUTE10 COL94, GLOBAL_ATTRIBUTE11 COL95, GLOBAL_ATTRIBUTE12 COL96, GLOBAL_ATTRIBUTE13 COL97, GLOBAL_ATTRIBUTE14 COL98, GLOBAL_ATTRIBUTE15 COL99, ORG_ID COL100, LEGAL_ENTITY_ID COL101, LEGAL_ENTITY_NAME COL102, NULL COL103 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_statu s 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
2mj6c1fqvxmp9	SELECT 'EXISTS' FROM OE_ORDER_LINES_ALL WHERE HEADER_ID = :B1 AND ROWNUM = 1
2p5b3rpqfjdjk	BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := OZF_QP_QUAL_PVT.get_buying_groups(ASO_PRICING_INT.G_HEADER_REC.party_id, OE_ORDER_PUB.G_LINE.SOLD_TO_ORG_ID); END;
2qh8v5safwdg0	begin OE_2PC2_LINE_RETLIN.Is_Valid( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
38d6u7kwu013b	select hr.organization_id org_id, hr.name operating_unit from hr_operating_units hr where mo_global.check_access(hr.organization_id) = 'Y' UNION ALL select NULL org_id, meaning operating_unit from iex_lookups_v where lookup_type='IEX_HISTORY_TYPE' and lookup_code='ALL'
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#
3s58mgk0uy2ws	insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
3sqgkcng6vx8r	INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ', :13) RETURNING rowid INTO :14
3z7bqju2c7wpg	SELECT SUM(ACCTD_AMOUNT_DUE_REMAINING) AMOUNT FROM AR_PAYMENT_SCHEDULES PS, IEX_DELINQUENCIES DEL WHERE PS.CUSTOMER_ID = :B1 AND PS.STATUS = 'OP' AND DEL.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID AND DEL.STATUS IN ('DELINQUENT', 'PREDELINQUENT')
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
4uk039gb6g280	BEGIN QP_Attr_Mapping_PUB.G_Temp_Value := QP_SOURCING_API_PUB.GET_LINE_WEIGHT_OR_VOLUME('Weight', OE_ORDER_PUB.G_LINE.inventory_item_id, OE_ORDER_PUB.G_LINE.ordered_quantity, OE_ORDER_PUB.G_LINE.order_quantity_uom); END;
4ur521d1gnqjd	BEGIN QP_Attr_Mapping_PUB.G_Temp_Value := OE_ORDER_PUB.G_HDR.order_type_id; END;
4wgb411d8s7ss	INSERT INTO QP_NPREQ_LINE_ATTRS_TMP (LINE_INDEX, ATTRIBUTE_LEVEL, ATTRIBUTE_TYPE, CONTEXT, ATTRIBUTE, VALUE_FROM, VALIDATED_FLAG, APPLIED_FLAG, PRICING_STATUS_CODE, PRICING_ATTR_FLAG ) VALUES (:B1 , :B10 , :B2 , :B3 , :B4 , :B5 , :B6 , :B9 , :B8 , :B7 )
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
521y9hsruj6y2	SELECT I.TAX_CODE FROM ZX_OUTPUT_CLASSIFICATIONS_V L, MTL_SYSTEM_ITEMS I WHERE I.INVENTORY_ITEM_ID = :B4 AND I.ORGANIZATION_ID = :B3 AND L.LOOKUP_CODE = I.TAX_CODE AND L.ORG_ID IN (:B2 , -99) AND L.ENABLED_FLAG = 'Y' AND (L.START_DATE_ACTIVE <= :B1 OR L.START_DATE_ACTIVE IS NULL) AND (L.END_DATE_ACTIVE >= :B1 OR L.END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY L.ORG_ID DESC
5at5sq48ks98y	SELECT SUM(NVL(ACCTD_AMOUNT_DUE_REMAINING, 0)) FROM AR_PAYMENT_SCHEDULES PS, AR_SYSTEM_PARAMETERS PARM WHERE CUSTOMER_ID = :B1 AND PS.ORG_ID = PARM.ORG_ID AND PS.STATUS = 'OP'
5k283vd769gxk	INSERT INTO ZX_LINES (TAX_LINE_ID, INTERNAL_ORGANIZATION_ID, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TRX_LINE_NUMBER, DOC_EVENT_STATUS, TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE, TAX_LINE_NUMBER, CONTENT_OWNER_ID, TAX_REGIME_ID, TAX_REGIME_CODE, TAX_ID, TAX, TAX_STATUS_ID, TAX_STATUS_CODE, TAX_RATE_ID, TAX_RATE_CODE, TAX_RATE, TAX_RATE_TYPE, TAX_APPORTIONMENT_LINE_NUMBER, TRX_ID_LEVEL2, TRX_ID_LEVEL3, TRX_ID_LEVEL4, TRX_ID_LEVEL5, TRX_ID_LEVEL6, TRX_USER_KEY_LEVEL1, TRX_USER_KEY_LEVEL2, TRX_USER_KEY_LEVEL3, TRX_USER_KEY_LEVEL4, TRX_USER_KEY_LEVEL5, TRX_USER_KEY_LEVEL6, MRC_TAX_LINE_FLAG, LEDGER_ID, ESTABLISHMENT_ID, LEGAL_ENTITY_ID, LEGAL_ENTITY_TAX_REG_NUMBER, HQ_ESTB_REG_NUMBER, HQ_ESTB_PARTY_TAX_PROF_ID, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, TAX_CURRENCY_CONVERSION_DATE, TAX_CURRENCY_CONVERSION_TYPE, TAX_CURRENCY_CONVERSION_RATE, TRX_ CURRENCY_CODE, REPORTING_CURRENCY_CODE, MINIMUM_ACCOUNTABLE_UNIT, PRECISION, TRX_NUMBER, TRX_DATE, UNIT_PRICE, LINE_AMT, TRX_LINE_QUANTITY, TAX_BASE_MODIFIER_RATE, REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID, REF_DOC_TRX_LEVEL_TYPE, REF_DOC_LINE_ID, REF_DOC_LINE_QUANTITY, OTHER_DOC_LINE_AMT, OTHER_DOC_LINE_TAX_AMT, OTHER_DOC_LINE_TAXABLE_AMT, UNROUNDED_TAXABLE_AMT, UNROUNDED_TAX_AMT, RELATED_DOC_APPLICATION_ID, RELATED_DOC_ENTITY_CODE, RELATED_DOC_EVENT_CLASS_CODE, RELATED_DOC_TRX_ID, RELATED_DOC_TRX_LEVEL_TYPE, RELATED_DOC_NUMBER, RELATED_DOC_DATE, APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_TRX_ID, APPLIED_FROM_TRX_LEVEL_TYPE, APPLIED_FROM_LINE_ID, APPLIED_FROM_TRX_NUMBER, ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_TRX_LEVEL_TYPE, ADJUSTED_DOC_LINE_ID, ADJUSTED_DOC_NUMBER , ADJUSTED_DOC_DATE, APPLIED_TO_APPLICATION_ID, APPLIED_TO_EVENT_CLASS_CODE, APPLIED_TO_ENTITY_CODE, APPLIED_TO_TRX_ID, APPLIED_TO_TRX_LEVEL_TYPE, APPLIED_TO_LINE_ID, APPLIED_TO_TRX_NUMBER, SUMMARY_TAX_LINE_ID, OFFSET_LINK_TO_TAX_LINE_ID, OFFSET_FLAG, PROCESS_FOR_RECOVERY_FLAG, TAX_JURISDICTION_ID, TAX_JURISDICTION_CODE, PLACE_OF_SUPPLY, PLACE_OF_SUPPLY_TYPE_CODE, PLACE_OF_SUPPLY_RESULT_ID, TAX_DATE_RULE_ID, TAX_DATE, TAX_DETERMINE_DATE, TAX_POINT_DATE, TRX_LINE_DATE, TAX_TYPE_CODE, TAX_CODE, TAX_REGISTRATION_ID, TAX_REGISTRATION_NUMBER, REGISTRATION_PARTY_TYPE, ROUNDING_LEVEL_CODE, ROUNDING_RULE_CODE, ROUNDING_LVL_PARTY_TAX_PROF_ID, ROUNDING_LVL_PARTY_TYPE, COMPOUNDING_TAX_FLAG, ORIG_TAX_STATUS_ID, ORIG_TAX_STATUS_CODE, ORIG_TAX_RATE_ID, ORIG_TAX_RATE_CODE, ORIG_TAX_RATE, ORIG_TAX_JURISDICTION_ID, ORIG_TAX_JURISDICTION_CODE, ORIG_TAX_AMT_INCLUDED_FLAG, ORIG_SELF_ASSESSED_FLAG, TAX_CURRENCY_CODE, TAX_AMT, TAX_AMT_TAX_CURR, TAX_AMT_FUNCL_CURR , TAXABLE_AMT, TAXABLE_AMT_TAX_CURR, TAXABLE_AMT_FUNCL_CURR, ORIG_TAXABLE_AMT, ORIG_TAXABLE_AMT_TAX_CURR, CAL_TAX_AMT, CAL_TAX_AMT_TAX_CURR, CAL_TAX_AMT_FUNCL_CURR, ORIG_TAX_AMT, ORIG_TAX_AMT_TAX_CURR, REC_TAX_AMT, REC_TAX_AMT_TAX_CURR, REC_TAX_AMT_FUNCL_CURR, NREC_TAX_AMT, NREC_TAX_AMT_TAX_CURR, NREC_TAX_AMT_FUNCL_CURR, TAX_EXEMPTION_ID, TAX_RATE_BEFORE_EXEMPTION, TAX_RATE_NAME_BEFORE_EXEMPTION, EXEMPT_RATE_MODIFIER, EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON, EXEMPT_REASON_CODE, TAX_EXCEPTION_ID, TAX_RATE_BEFORE_EXCEPTION, TAX_RATE_NAME_BEFORE_EXCEPTION, EXCEPTION_RATE, TAX_APPORTIONMENT_FLAG, HISTORICAL_FLAG, TAXABLE_BASIS_FORMULA, TAX_CALCULATION_FORMULA, CANCEL_FLAG, PURGE_FLAG, DELETE_FLAG, TAX_AMT_INCLUDED_FLAG, SELF_ASSESSED_FLAG, OVERRIDDEN_FLAG, MANUALLY_ENTERED_FLAG, REPORTING_ONLY_FLAG, FREEZE_UNTIL_OVERRIDDEN_FLAG, COPIED_FROM_OTHER_DOC_FLAG, RECALC_REQUIRED_FLAG, SETTLEMENT_FLAG, ITEM_DIST_CHANGED_FLAG, ASSOCIATED_CHILD_FROZEN_FL AG, TAX_ONLY_LINE_FLAG, COMPOUNDING_TAX_MISS_FLAG, COMPOUNDING_DEP_TAX_FLAG, SYNC_WITH_PRVDR_FLAG, LAST_MANUAL_ENTRY, TAX_PROVIDER_ID, RECORD_TYPE_CODE, REPORTING_PERIOD_ID, LEGAL_JUSTIFICATION_TEXT1, LEGAL_JUSTIFICATION_TEXT2, LEGAL_JUSTIFICATION_TEXT3, LEGAL_MESSAGE_APPL_2, LEGAL_MESSAGE_STATUS, LEGAL_MESSAGE_RATE, LEGAL_MESSAGE_BASIS, LEGAL_MESSAGE_CALC, LEGAL_MESSAGE_THRESHOLD, LEGAL_MESSAGE_POS, LEGAL_MESSAGE_TRN, LEGAL_MESSAGE_EXMPT, LEGAL_MESSAGE_EXCPT, TAX_REGIME_TEMPLATE_ID, TAX_APPLICABILITY_RESULT_ID, DIRECT_RATE_RESULT_ID, STATUS_RESULT_ID, RATE_RESULT_ID, BASIS_RESULT_ID, THRESH_RESULT_ID, CALC_RESULT_ID, TAX_REG_NUM_DET_RESULT_ID, EVAL_EXMPT_RESULT_ID, EVAL_EXCPT_RESULT_ID, ENFORCE_FROM_NATURAL_ACCT_FLAG, TAX_HOLD_CODE, TAX_HOLD_RELEASED_CODE, PRD_TOTAL_TAX_AMT, PRD_TOTAL_TAX_AMT_TAX_CURR, PRD_TOTAL_TAX_AMT_FUNCL_CURR, TRX_LINE_INDEX, OFFSET_TAX_RATE_CODE, PRORATION_CODE, OTHER_DOC_SOURCE, INTERNAL_ORG_LOCATION_ID, LINE_ASSESSAB LE_VALUE, CTRL_TOTAL_LINE_TX_AMT, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, NUMERIC1, NUMERIC2, NUMERIC3, NUMERIC4, NUMERIC5, NUMERIC6, NUMERIC7, NUMERIC8, NUMERIC9, NUMERIC10, CHAR1, CHAR2, CHAR3, CHAR4, CHAR5, CHAR6, CHAR7, CHAR8, CHAR9, CHAR10, DATE1, DATE2, DATE3, DATE4, DATE5, DATE6, DATE7, DATE8, DATE9, DATE10, INTERFACE_ENTITY_CODE, INTERFACE_TAX_LINE_ID, TAXING_JURIS_GEOGRAPHY_ID, ADJUSTED_DOC_TAX_LINE_ID, OBJECT_VERSION_NUMBER, CREATED_ BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, MULTIPLE_JURISDICTIONS_FLAG, LEGAL_REPORTING_STATUS, ACCOUNT_SOURCE_TAX_RATE_ID) SELECT TAX_LINE_ID, INTERNAL_ORGANIZATION_ID, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TRX_LINE_NUMBER, DOC_EVENT_STATUS, TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE, TAX_LINE_NUMBER, CONTENT_OWNER_ID, TAX_REGIME_ID, TAX_REGIME_CODE, TAX_ID, TAX, TAX_STATUS_ID, TAX_STATUS_CODE, TAX_RATE_ID, TAX_RATE_CODE, TAX_RATE, TAX_RATE_TYPE, TAX_APPORTIONMENT_LINE_NUMBER, TRX_ID_LEVEL2, TRX_ID_LEVEL3, TRX_ID_LEVEL4, TRX_ID_LEVEL5, TRX_ID_LEVEL6, TRX_USER_KEY_LEVEL1, TRX_USER_KEY_LEVEL2, TRX_USER_KEY_LEVEL3, TRX_USER_KEY_LEVEL4, TRX_USER_KEY_LEVEL5, TRX_USER_KEY_LEVEL6, MRC_TAX_LINE_FLAG, LEDGER_ID, ESTABLISHMENT_ID, LEGAL_ENTITY_ID, LEGAL_ENTITY_TAX_REG_NUMBER, HQ_ESTB_REG_NUMBER, HQ_ESTB_PARTY_TAX_PROF_ID, CURRENCY_CONVERSION_DATE, CURRE NCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, TAX_CURRENCY_CONVERSION_DATE, TAX_CURRENCY_CONVERSION_TYPE, TAX_CURRENCY_CONVERSION_RATE, TRX_CURRENCY_CODE, REPORTING_CURRENCY_CODE, MINIMUM_ACCOUNTABLE_UNIT, PRECISION, TRX_NUMBER, TRX_DATE, UNIT_PRICE, LINE_AMT, TRX_LINE_QUANTITY, TAX_BASE_MODIFIER_RATE, REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID, REF_DOC_TRX_LEVEL_TYPE, REF_DOC_LINE_ID, REF_DOC_LINE_QUANTITY, OTHER_DOC_LINE_AMT, OTHER_DOC_LINE_TAX_AMT, OTHER_DOC_LINE_TAXABLE_AMT, UNROUNDED_TAXABLE_AMT, UNROUNDED_TAX_AMT, RELATED_DOC_APPLICATION_ID, RELATED_DOC_ENTITY_CODE, RELATED_DOC_EVENT_CLASS_CODE, RELATED_DOC_TRX_ID, RELATED_DOC_TRX_LEVEL_TYPE, RELATED_DOC_NUMBER, RELATED_DOC_DATE, APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_TRX_ID, APPLIED_FROM_TRX_LEVEL_TYPE, APPLIED_FROM_LINE_ID, APPLIED_FROM_TRX_NUMBER, ADJUSTED_DOC_APPLICATION_ID, ADJUSTE D_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_TRX_LEVEL_TYPE, ADJUSTED_DOC_LINE_ID, ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE, APPLIED_TO_APPLICATION_ID, APPLIED_TO_EVENT_CLASS_CODE, APPLIED_TO_ENTITY_CODE, APPLIED_TO_TRX_ID, APPLIED_TO_TRX_LEVEL_TYPE, APPLIED_TO_LINE_ID, APPLIED_TO_TRX_NUMBER, SUMMARY_TAX_LINE_ID, OFFSET_LINK_TO_TAX_LINE_ID, OFFSET_FLAG, PROCESS_FOR_RECOVERY_FLAG, TAX_JURISDICTION_ID, TAX_JURISDICTION_CODE, PLACE_OF_SUPPLY, PLACE_OF_SUPPLY_TYPE_CODE, PLACE_OF_SUPPLY_RESULT_ID, TAX_DATE_RULE_ID, TAX_DATE, TAX_DETERMINE_DATE, TAX_POINT_DATE, TRX_LINE_DATE, TAX_TYPE_CODE, TAX_CODE, TAX_REGISTRATION_ID, TAX_REGISTRATION_NUMBER, REGISTRATION_PARTY_TYPE, ROUNDING_LEVEL_CODE, ROUNDING_RULE_CODE, ROUNDING_LVL_PARTY_TAX_PROF_ID, ROUNDING_LVL_PARTY_TYPE, COMPOUNDING_TAX_FLAG, ORIG_TAX_STATUS_ID, ORIG_TAX_STATUS_CODE, ORIG_TAX_RATE_ID, ORIG_TAX_RATE_CODE, ORIG_TAX_RATE, ORIG_TAX_JURISDICTION_ID, ORIG_ TAX_JURISDICTION_CODE, ORIG_TAX_AMT_INCLUDED_FLAG, ORIG_SELF_ASSESSED_FLAG, TAX_CURRENCY_CODE, TAX_AMT, TAX_AMT_TAX_CURR, TAX_AMT_FUNCL_CURR, TAXABLE_AMT, TAXABLE_AMT_TAX_CURR, TAXABLE_AMT_FUNCL_CURR, ORIG_TAXABLE_AMT, ORIG_TAXABLE_AMT_TAX_CURR, CAL_TAX_AMT, CAL_TAX_AMT_TAX_CURR, CAL_TAX_AMT_FUNCL_CURR, ORIG_TAX_AMT, ORIG_TAX_AMT_TAX_CURR, REC_TAX_AMT, REC_TAX_AMT_TAX_CURR, REC_TAX_AMT_FUNCL_CURR, NREC_TAX_AMT, NREC_TAX_AMT_TAX_CURR, NREC_TAX_AMT_FUNCL_CURR, TAX_EXEMPTION_ID, TAX_RATE_BEFORE_EXEMPTION, TAX_RATE_NAME_BEFORE_EXEMPTION, EXEMPT_RATE_MODIFIER, EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON, EXEMPT_REASON_CODE, TAX_EXCEPTION_ID, TAX_RATE_BEFORE_EXCEPTION, TAX_RATE_NAME_BEFORE_EXCEPTION, EXCEPTION_RATE, TAX_APPORTIONMENT_FLAG, HISTORICAL_FLAG, TAXABLE_BASIS_FORMULA, TAX_CALCULATION_FORMULA, CANCEL_FLAG, PURGE_FLAG, DELETE_FLAG, TAX_AMT_INCLUDED_FLAG, SELF_ASSESSED_FLAG, OVERRIDDEN_FLAG, MANUALLY_ENTERED_FLAG, REPORTING_ONLY_FLAG, FREEZE _UNTIL_OVERRIDDEN_FLAG, COPIED_FROM_OTHER_DOC_FLAG, RECALC_REQUIRED_FLAG, SETTLEMENT_FLAG, ITEM_DIST_CHANGED_FLAG, ASSOCIATED_CHILD_FROZEN_FLAG, TAX_ONLY_LINE_FLAG, COMPOUNDING_TAX_MISS_FLAG, COMPOUNDING_DEP_TAX_FLAG, 'N', LAST_MANUAL_ENTRY, TAX_PROVIDER_ID, RECORD_TYPE_CODE, REPORTING_PERIOD_ID, LEGAL_JUSTIFICATION_TEXT1, LEGAL_JUSTIFICATION_TEXT2, LEGAL_JUSTIFICATION_TEXT3, LEGAL_MESSAGE_APPL_2, LEGAL_MESSAGE_STATUS, LEGAL_MESSAGE_RATE, LEGAL_MESSAGE_BASIS, LEGAL_MESSAGE_CALC, LEGAL_MESSAGE_THRESHOLD, LEGAL_MESSAGE_POS, LEGAL_MESSAGE_TRN, LEGAL_MESSAGE_EXMPT, LEGAL_MESSAGE_EXCPT, TAX_REGIME_TEMPLATE_ID, TAX_APPLICABILITY_RESULT_ID, DIRECT_RATE_RESULT_ID, STATUS_RESULT_ID, RATE_RESULT_ID, BASIS_RESULT_ID, THRESH_RESULT_ID, CALC_RESULT_ID, TAX_REG_NUM_DET_RESULT_ID, EVAL_EXMPT_RESULT_ID, EVAL_EXCPT_RESULT_ID, ENFORCE_FROM_NATURAL_ACCT_FLAG, TAX_HOLD_CODE, TAX_HOLD_RELEASED_CODE, PRD_TOTAL_TAX_AMT, PRD_TOTAL_TAX_AMT_TAX_CURR, PRD_TOTAL_TAX_AMT_ FUNCL_CURR, TRX_LINE_INDEX, OFFSET_TAX_RATE_CODE, PRORATION_CODE, OTHER_DOC_SOURCE, INTERNAL_ORG_LOCATION_ID, LINE_ASSESSABLE_VALUE, CTRL_TOTAL_LINE_TX_AMT, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, NUMERIC1, NUMERIC2, NUMERIC3, NUMERIC4, NUMERIC5, NUMERIC6, NUMERIC7, NUMERIC8, NUMERIC9, NUMERIC10, CHAR1, CHAR2, CHAR3, CHAR4, CHAR5, CHAR6, CHAR7, CHAR8, CHAR9, CHAR10, DATE1, DATE2, DATE3, DATE4, DATE5, DATE6, DATE7, DATE8, DATE9, DATE10, INTERF ACE_ENTITY_CODE, INTERFACE_TAX_LINE_ID, TAXING_JURIS_GEOGRAPHY_ID, ADJUSTED_DOC_TAX_LINE_ID, 1, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, MULTIPLE_JURISDICTIONS_FLAG, LEGAL_REPORTING_STATUS, ACCOUNT_SOURCE_TAX_RATE_ID FROM ZX_DETAIL_TAX_LINES_GT
5uc22nkkupb6x	SELECT INVENTORY_ITEM_ID , ORGANIZATION_ID , INVOICING_RULE_ID , ACCOUNTING_RULE_ID , DEFAULT_SHIPPING_ORG , SHIP_MODEL_COMPLETE_FLAG , BUILD_IN_WIP_FLAG , BOM_ITEM_TYPE , REPLENISH_TO_ORDER_FLAG , PRIMARY_UOM_CODE , PICK_COMPONENTS_FLAG , SHIPPABLE_ITEM_FLAG , SERVICE_ITEM_FLAG , ORGANIZATION_ID , CUSTOMER_ORDER_ENABLED_FLAG , INTERNAL_ORDER_ENABLED_FLAG , RETURNABLE_FLAG , RESTRICT_SUBINVENTORIES_CODE FROM MTL_SYSTEM_ITEMS WHERE INVENTORY_ITEM_ID = :B2 AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', :B1 )
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6dhn7dz44apb9	begin OE_SCHEDULE_UTIL.IS_ITEM_SUBSTITUTED( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
6dp3t6txwjvam	SELECT SU.TAX_CODE FROM HZ_CUST_SITE_USES_ALL SU, ZX_OUTPUT_CLASSIFICATIONS_V L WHERE SU.SITE_USE_ID = :B3 AND SU.ORG_ID = :B2 AND L.LOOKUP_CODE = SU.TAX_CODE AND L.ORG_ID IN (:B2 , -99) AND L.ENABLED_FLAG = 'Y' AND (L.START_DATE_ACTIVE <= :B1 OR L.START_DATE_ACTIVE IS NULL) AND (L.END_DATE_ACTIVE >= :B1 OR L.END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY L.ORG_ID DESC
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 )
7nfm92p6qts7a	UPDATE OE_ORDER_LINES SET ACCOUNTING_RULE_ID = :B351 , ACCOUNTING_RULE_DURATION = :B350 , CALCULATE_PRICE_FLAG = :B349 , ACTUAL_ARRIVAL_DATE = :B348 , ACTUAL_SHIPMENT_DATE = :B347 , AGREEMENT_ID = :B346 , ARRIVAL_SET_ID = :B345 , ATO_LINE_ID = :B344 , ATTRIBUTE1 = :B343 , ATTRIBUTE10 = :B342 , ATTRIBUTE11 = :B341 , ATTRIBUTE12 = :B340 , ATTRIBUTE13 = :B339 , ATTRIBUTE14 = :B338 , ATTRIBUTE15 = :B337 , ATTRIBUTE16 = :B336 , ATTRIBUTE17 = :B335 , ATTRIBUTE18 = :B334 , ATTRIBUTE19 = :B333 , ATTRIBUTE2 = :B332 , ATTRIBUTE20 = :B331 , ATTRIBUTE3 = :B330 , ATTRIBUTE4 = :B329 , ATTRIBUTE5 = :B328 , ATTRIBUTE6 = :B327 , ATTRIBUTE7 = :B326 , ATTRIBUTE8 = :B325 , ATTRIBUTE9 = :B324 , AUTO_SELECTED_QUANTITY = :B323 , AUTHORIZED_TO_SHIP_FLAG = :B322 , BOOKED_FLAG = :B321 , CANCELLED_FLAG = :B320 , CANCELLED_QUANTITY = :B319 , COMMITMENT_ID = :B318 , COMPONENT_CODE = :B317 , COMPONENT_SEQUENCE_ID = :B316 , CONFIG_HEADER_ID = :B315 , CONFIG_REV_NBR = :B314 , CON FIG_DISPLAY_SEQUENCE = :B313 , CONFIGURATION_ID = :B312 , CONTEXT = :B311 , CREATED_BY = :B310 , CREATION_DATE = :B309 , CREDIT_INVOICE_LINE_ID = :B308 , CUSTOMER_LINE_NUMBER = :B307 , CUSTOMER_SHIPMENT_NUMBER = :B306 , CUSTOMER_ITEM_NET_PRICE = :B305 , CUSTOMER_PAYMENT_TERM_ID = :B304 , CUSTOMER_DOCK_CODE = :B303 , CUSTOMER_JOB = :B302 , CUSTOMER_PRODUCTION_LINE = :B301 , CUST_PRODUCTION_SEQ_NUM = :B300 , CUSTOMER_TRX_LINE_ID = :B299 , CUST_MODEL_SERIAL_NUMBER = :B298 , CUST_PO_NUMBER = :B297 , DELIVERY_LEAD_TIME = :B296 , DELIVER_TO_CONTACT_ID = :B295 , DELIVER_TO_ORG_ID = :B294 , DEMAND_BUCKET_TYPE_CODE = :B293 , DEMAND_CLASS_CODE = :B292 , DEP_PLAN_REQUIRED_FLAG = :B291 , EARLIEST_ACCEPTABLE_DATE = :B290 , END_ITEM_UNIT_NUMBER = :B289 , EXPLOSION_DATE = :B288 , FIRST_ACK_CODE = :B287 , FIRST_ACK_DATE = :B286 , FOB_POINT_CODE = :B285 , FREIGHT_CARRIER_CODE = :B284 , FREIGHT_TERMS_CODE = :B283 , FULFILLED_QUANTITY = :B282 , FULFILLED_FLAG = :B281 , FU LFILLMENT_METHOD_CODE = :B280 , FULFILLMENT_DATE = :B279 , GLOBAL_ATTRIBUTE1 = :B278 , GLOBAL_ATTRIBUTE10 = :B277 , GLOBAL_ATTRIBUTE11 = :B276 , GLOBAL_ATTRIBUTE12 = :B275 , GLOBAL_ATTRIBUTE13 = :B274 , GLOBAL_ATTRIBUTE14 = :B273 , GLOBAL_ATTRIBUTE15 = :B272 , GLOBAL_ATTRIBUTE16 = :B271 , GLOBAL_ATTRIBUTE17 = :B270 , GLOBAL_ATTRIBUTE18 = :B269 , GLOBAL_ATTRIBUTE19 = :B268 , GLOBAL_ATTRIBUTE2 = :B267 , GLOBAL_ATTRIBUTE20 = :B266 , GLOBAL_ATTRIBUTE3 = :B265 , GLOBAL_ATTRIBUTE4 = :B264 , GLOBAL_ATTRIBUTE5 = :B263 , GLOBAL_ATTRIBUTE6 = :B262 , GLOBAL_ATTRIBUTE7 = :B261 , GLOBAL_ATTRIBUTE8 = :B260 , GLOBAL_ATTRIBUTE9 = :B259 , GLOBAL_ATTRIBUTE_CATEGORY = :B258 , HEADER_ID = :B1 , INDUSTRY_ATTRIBUTE1 = :B257 , INDUSTRY_ATTRIBUTE10 = :B256 , INDUSTRY_ATTRIBUTE11 = :B255 , INDUSTRY_ATTRIBUTE12 = :B254 , INDUSTRY_ATTRIBUTE13 = :B253 , INDUSTRY_ATTRIBUTE14 = :B252 , INDUSTRY_ATTRIBUTE15 = :B251 , INDUSTRY_ATTRIBUTE16 = :B250 , INDUSTRY_ATTRIBUTE17 = :B249 , INDUS TRY_ATTRIBUTE18 = :B248 , INDUSTRY_ATTRIBUTE19 = :B247 , INDUSTRY_ATTRIBUTE20 = :B246 , INDUSTRY_ATTRIBUTE21 = :B245 , INDUSTRY_ATTRIBUTE22 = :B244 , INDUSTRY_ATTRIBUTE23 = :B243 , INDUSTRY_ATTRIBUTE24 = :B242 , INDUSTRY_ATTRIBUTE25 = :B241 , INDUSTRY_ATTRIBUTE26 = :B240 , INDUSTRY_ATTRIBUTE27 = :B239 , INDUSTRY_ATTRIBUTE28 = :B238 , INDUSTRY_ATTRIBUTE29 = :B237 , INDUSTRY_ATTRIBUTE30 = :B236 , INDUSTRY_ATTRIBUTE2 = :B235 , INDUSTRY_ATTRIBUTE3 = :B234 , INDUSTRY_ATTRIBUTE4 = :B233 , INDUSTRY_ATTRIBUTE5 = :B232 , INDUSTRY_ATTRIBUTE6 = :B231 , INDUSTRY_ATTRIBUTE7 = :B230 , INDUSTRY_ATTRIBUTE8 = :B229 , INDUSTRY_ATTRIBUTE9 = :B228 , INDUSTRY_CONTEXT = :B227 , INTMED_SHIP_TO_CONTACT_ID = :B226 , INTMED_SHIP_TO_ORG_ID = :B225 , INVENTORY_ITEM_ID = :B224 , INVOICE_INTERFACE_STATUS_CODE = :B223 , INVOICE_TO_CONTACT_ID = :B222 , INVOICE_TO_ORG_ID = :B221 , INVOICED_QUANTITY = :B220 , INVOICING_RULE_ID = :B219 , ORDERED_ITEM_ID = :B218 , ITEM_IDENTIFIER_TYPE = :B2 17 , ORDERED_ITEM = :B216 , ITEM_REVISION = :B215 , ITEM_TYPE_CODE = :B214 , LAST_ACK_CODE = :B213 , LAST_ACK_DATE = :B212 , LAST_UPDATED_BY = :B211 , LATEST_ACCEPTABLE_DATE = :B210 , LAST_UPDATE_DATE = :B209 , LAST_UPDATE_LOGIN = :B208 , LINE_CATEGORY_CODE = :B207 , LINE_NUMBER = :B206 , LINE_TYPE_ID = :B205 , LINK_TO_LINE_ID = :B204 , MODEL_GROUP_NUMBER = :B203 , MFG_LEAD_TIME = :B202 , OPEN_FLAG = :B201 , OPTION_FLAG = :B200 , OPTION_NUMBER = :B199 , ORDERED_QUANTITY = :B198 , ORDERED_QUANTITY2 = :B197 , ORDER_QUANTITY_UOM = :B196 , ORDERED_QUANTITY_UOM2 = :B195 , ORDER_SOURCE_ID = :B194 , ORIG_SYS_DOCUMENT_REF = :B193 , ORIG_SYS_LINE_REF = :B192 , ORIG_SYS_SHIPMENT_REF = :B191 , CHANGE_SEQUENCE = :B190 , OVER_SHIP_REASON_CODE = :B189 , OVER_SHIP_RESOLVED_FLAG = :B188 , PAYMENT_TERM_ID = :B187 , PLANNING_PRIORITY = :B186 , PREFERRED_GRADE = :B185 , PRICE_LIST_ID = :B184 , PRICE_REQUEST_CODE = :B183 , PRICING_ATTRIBUTE1 = :B182 , PRICING_ATTRIBUTE1 0 = :B181 , PRICING_ATTRIBUTE2 = :B180 , PRICING_ATTRIBUTE3 = :B179 , PRICING_ATTRIBUTE4 = :B178 , PRICING_ATTRIBUTE5 = :B177 , PRICING_ATTRIBUTE6 = :B176 , PRICING_ATTRIBUTE7 = :B175 , PRICING_ATTRIBUTE8 = :B174 , PRICING_ATTRIBUTE9 = :B173 , PRICING_CONTEXT = :B172 , PRICING_DATE = :B171 , PRICING_QUANTITY = :B170 , PRICING_QUANTITY_UOM = :B169 , PROGRAM_APPLICATION_ID = :B168 , PROGRAM_ID = :B167 , PROGRAM_UPDATE_DATE = :B166 , PROJECT_ID = :B165 , PROMISE_DATE = :B164 , RE_SOURCE_FLAG = :B163 , REFERENCE_CUSTOMER_TRX_LINE_ID = :B162 , REFERENCE_HEADER_ID = :B161 , REFERENCE_LINE_ID = :B160 , REFERENCE_TYPE = :B159 , REQUEST_DATE = :B158 , REQUEST_ID = :B157 , RETURN_ATTRIBUTE1 = :B156 , RETURN_ATTRIBUTE10 = :B155 , RETURN_ATTRIBUTE11 = :B154 , RETURN_ATTRIBUTE12 = :B153 , RETURN_ATTRIBUTE13 = :B152 , RETURN_ATTRIBUTE14 = :B151 , RETURN_ATTRIBUTE15 = :B150 , RETURN_ATTRIBUTE2 = :B149 , RETURN_ATTRIBUTE3 = :B148 , RETURN_ATTRIBUTE4 = :B147 , RETURN_ ATTRIBUTE5 = :B146 , RETURN_ATTRIBUTE6 = :B145 , RETURN_ATTRIBUTE7 = :B144 , RETURN_ATTRIBUTE8 = :B143 , RETURN_ATTRIBUTE9 = :B142 , RETURN_CONTEXT = :B141 , RETURN_REASON_CODE = :B140 , RLA_SCHEDULE_TYPE_CODE = :B139 , SALESREP_ID = :B138 , SCHEDULE_ARRIVAL_DATE = :B137 , SCHEDULE_SHIP_DATE = :B136 , SCHEDULE_STATUS_CODE = :B135 , SHIPMENT_NUMBER = :B134 , SHIPMENT_PRIORITY_CODE = :B133 , SHIPPED_QUANTITY = :B132 , SHIPPED_QUANTITY2 = :B131 , SHIPPING_METHOD_CODE = :B130 , SHIPPING_QUANTITY = :B129 , SHIPPING_QUANTITY2 = :B128 , SHIPPING_QUANTITY_UOM = :B127 , SHIP_FROM_ORG_ID = :B126 , SUBINVENTORY = :B125 , SHIP_TOLERANCE_ABOVE = :B124 , SHIP_TOLERANCE_BELOW = :B123 , SHIPPABLE_FLAG = :B122 , SHIPPING_INTERFACED_FLAG = :B121 , SHIP_TO_CONTACT_ID = :B120 , SHIP_TO_ORG_ID = :B119 , SHIP_MODEL_COMPLETE_FLAG = :B118 , SHIP_SET_ID = :B117 , SOLD_TO_ORG_ID = :B116 , SOLD_FROM_ORG_ID = :B115 , SORT_ORDER = :B114 , SOURCE_DOCUMENT_ID = :B113 , SOURCE_DOCUME NT_LINE_ID = :B112 , SOURCE_DOCUMENT_TYPE_ID = :B111 , SOURCE_TYPE_CODE = :B110 , SPLIT_FROM_LINE_ID = :B109 , LINE_SET_ID = :B108 , SPLIT_BY = :B107 , MODEL_REMNANT_FLAG = :B106 , TASK_ID = :B105 , TAX_CODE = :B104 , TAX_DATE = :B103 , TAX_EXEMPT_FLAG = :B102 , TAX_EXEMPT_NUMBER = :B101 , TAX_EXEMPT_REASON_CODE = :B100 , TAX_POINT_CODE = :B99 , TAX_RATE = :B98 , TAX_VALUE = :B97 , TOP_MODEL_LINE_ID = :B96 , UNIT_LIST_PRICE = :B95 , UNIT_LIST_PRICE_PER_PQTY = :B94 , UNIT_SELLING_PRICE = :B93 , UNIT_SELLING_PRICE_PER_PQTY = :B92 , VISIBLE_DEMAND_FLAG = :B91 , VEH_CUS_ITEM_CUM_KEY_ID = :B90 , SHIPPING_INSTRUCTIONS = :B89 , PACKING_INSTRUCTIONS = :B88 , SERVICE_TXN_REASON_CODE = :B87 , SERVICE_TXN_COMMENTS = :B86 , SERVICE_DURATION = :B85 , SERVICE_PERIOD = :B84 , SERVICE_START_DATE = :B83 , SERVICE_END_DATE = :B82 , SERVICE_COTERMINATE_FLAG = :B81 , UNIT_LIST_PERCENT = :B80 , UNIT_SELLING_PERCENT = :B79 , UNIT_PERCENT_BASE_PRICE = :B78 , SERVICE_NUMBER = :B77 , SERVICE_REFERENCE_TYPE_CODE = :B76 , SERVICE_REFERENCE_LINE_ID = :B75 , SERVICE_REFERENCE_SYSTEM_ID = :B74 , TP_CONTEXT = :B73 , TP_ATTRIBUTE1 = :B72 , TP_ATTRIBUTE2 = :B71 , TP_ATTRIBUTE3 = :B70 , TP_ATTRIBUTE4 = :B69 , TP_ATTRIBUTE5 = :B68 , TP_ATTRIBUTE6 = :B67 , TP_ATTRIBUTE7 = :B66 , TP_ATTRIBUTE8 = :B65 , TP_ATTRIBUTE9 = :B64 , TP_ATTRIBUTE10 = :B63 , TP_ATTRIBUTE11 = :B62 , TP_ATTRIBUTE12 = :B61 , TP_ATTRIBUTE13 = :B60 , TP_ATTRIBUTE14 = :B59 , TP_ATTRIBUTE15 = :B58 , FLOW_STATUS_CODE = :B57 , MARKETING_SOURCE_CODE_ID = :B56 , ORIGINAL_INVENTORY_ITEM_ID = :B55 , ORIGINAL_ITEM_IDENTIFIER_TYPE = :B54 , ORIGINAL_ORDERED_ITEM_ID = :B53 , ORIGINAL_ORDERED_ITEM = :B52 , ITEM_RELATIONSHIP_TYPE = :B51 , ITEM_SUBSTITUTION_TYPE_CODE = :B50 , LATE_DEMAND_PENALTY_FACTOR = :B49 , OVERRIDE_ATP_DATE_CODE = :B48 , FIRM_DEMAND_FLAG = :B47 , EARLIEST_SHIP_DATE = :B46 , USER_ITEM_DESCRIPTION = :B45 , BLANKET_NUMBER = :B44 , BLANKET_LINE_NUMBER = :B43 , B LANKET_VERSION_NUMBER = :B42 , UNIT_COST = :B41 , LOCK_CONTROL = :B40 , TRANSACTION_PHASE_CODE = :B39 , SOURCE_DOCUMENT_VERSION_NUMBER = :B38 , MINISITE_ID = :B37 , IB_OWNER = :B36 , IB_INSTALLED_AT_LOCATION = :B35 , IB_CURRENT_LOCATION = :B34 , END_CUSTOMER_ID = :B33 , END_CUSTOMER_CONTACT_ID = :B32 , END_CUSTOMER_SITE_USE_ID = :B31 , RETROBILL_REQUEST_ID = :B30 , ORIGINAL_LIST_PRICE = :B29 , ORDER_FIRMED_DATE = :B28 , ACTUAL_FULFILLMENT_DATE = :B27 , CHARGE_PERIODICITY_CODE = :B26 , CANCELLED_QUANTITY2 = :B25 , SHIPPING_QUANTITY_UOM2 = :B24 , FULFILLED_QUANTITY2 = :B23 , CONTINGENCY_ID = :B22 , REVREC_EVENT_CODE = :B21 , REVREC_EXPIRATION_DAYS = :B20 , ACCEPTED_QUANTITY = :B19 , REVREC_COMMENTS = :B18 , REVREC_SIGNATURE = :B17 , REVREC_SIGNATURE_DATE = :B16 , ACCEPTED_BY = :B15 , REVREC_REFERENCE_DOCUMENT = :B14 , REVREC_IMPLICIT_FLAG = :B13 , SERVICE_BILL_PROFILE_ID = :B12 , SERVICE_COV_TEMPLATE_ID = :B11 , SERVICE_SUBS_TEMPLATE_ID = :B10 , SERVICE_B ILL_OPTION_CODE = :B9 , SUBSCRIPTION_ENABLE_FLAG = :B8 , SERVICE_FIRST_PERIOD_AMOUNT = :B7 , SERVICE_FIRST_PERIOD_ENDDATE = :B6 , FULFILLMENT_BASE = :B5 , CONTAINER_NUMBER = :B4 , EQUIPMENT_ID = :B3 WHERE LINE_ID = :B2 AND HEADER_ID = :B1
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
8camsgjsr9zya	begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8qkj6nq9kp5gq	SELECT rules.id RULE_ID, rules.trigger_event, rules.rule_key, rules.condition, rules.trigger_object, NVL(rules.fire_in_enter_query, 'N') FIRE_IN_QBE, actions.object_type, actions.target_object, actions.action_type, actions.argument_type, actions.property_name, actions.folder_prompt_block, decode(actions.action_type, 'M', actions.MESSAGE_TYPE, 'B', actions.BUILTIN_TYPE) MB_TYPE, decode(actions.action_type, 'M', actions.MESSAGE_TEXT, 'B', actions.BUILTIN_ARGUMENTS, 'P', actions.property_value) MB_TEXT, actions.menu_entry, actions.menu_label, actions.menu_seperator, actions.menu_enabled_in, actions.menu_action, actions.menu_argument_long, actions.menu_argument_short FROM fnd_form_custom_rules rules, fnd_form_custom_actions actions WHERE (decode(actions.LANGUAGE, '*', USERENV('LANG'), actions.language) = USERENV('LANG')) AND (((rules.rule_type = 'A') AND (rules.function_name = :1)) OR ((rules.rule_type = 'F') AND (rules.form_name = :2))) AND (actions.enabled = 'Y') AND (rules.enabled = 'Y') AND (actions.rule_id = rules.ID) AND exists (select 'x' from fnd_form_custom_scopes scopes WHERE scopes.rule_id = rules.id AND ((scopes.level_id = 10 and scopes.level_value = :3) or (scopes.level_id = 20) or (scopes.level_id = 30 and scopes.level_value = :4 AND scopes.level_value_application_id = :5) or (scopes.level_id = 40 and scopes.level_value = :6))) order by rules.trigger_event, rules.rule_key, rules.sequence, rules.id, actions.sequence
8zh8nt6uwvdr3	BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := OZF_QP_QUAL_PVT.get_lists(ASO_PRICING_INT.G_HEADER_REC.party_id, OE_ORDER_PUB.G_LINE.SOLD_TO_ORG_ID); END;
9q4g7968s2ymc	INSERT INTO OE_ORDER_LINES ( ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , CUSTOMER_PAYMENT_TERM_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_T RX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_ BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LATEST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORDER_SOURCE_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , CHANGE_SEQUENCE , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_ FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHEDULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SO LD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , SHIPPING_QUANTITY_UOM2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG , BYPASS_SCH_FLAG , PRE_EXPLODED_FLAG , SERVICE_BILL_PROFILE_ID , SERVICE_COV_TEMPLATE_ID , SERVICE_SUBS_TEMPLATE_ID , SERVICE_BILL_OPTION_CODE , SUBSCRIPTION_ENABLE_FLAG , SERVICE_FIRST_PERIOD_AMOUNT , SERVICE_FIRST_PERIOD_ENDDATE , FULFILLMENT_BASE , CONTAINER_NUMBER , EQUIPMENT_ID ) VALUES ( :B356 , :B355 , :B354 , :B353 , :B352 , :B351 , :B350 , :B349 , :B348 , :B347 , :B346 , :B345 , :B344 , :B343 , :B342 , :B341 , :B340 , :B339 , :B338 , :B337 , :B336 , :B335 , :B334 , :B333 , :B332 , :B331 , :B330 , :B329 , :B328 , :B327 , :B326 , :B325 , :B324 , :B323 , :B322 , :B321 , :B320 , :B319 , :B318 , :B317 , :B316 , :B315 , :B314 , :B313 , :B312 , :B311 , :B310 , :B309 , :B308 , :B307 , :B306 , :B305 , :B304 , :B303 , :B302 , :B301 , :B300 , :B299 , :B298 , :B297 , :B296 , :B295 , :B294 , :B293 , :B292 , :B291 , :B290 , :B289 , :B288 , :B287 , :B286 , :B285 , :B284 , :B283 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B154 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
a14wcsg9mk8j3	WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.PLSQL_OBJECT_ID, a$.PLSQL_SUBPROGRAM_ID, a$.TIME_MODEL FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.PLSQL_OBJECT_ID, a.PLSQL_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID = :plsqleid AND a.PLSQL_ENTRY_SUBPROGRAM_ID = :plsqlesid GROUP BY PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT ash.plsql_object_id, ash.plsql_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(dba.overload), ash.cnt FROM dba_procedures dba, ash WHERE ash.plsql_object_id = dba.object_id(+) AND ash.plsql_su bprogram_id = dba.subprogram_id(+) ORDER BY ash.cnt DESC, ash.plsql_object_id, ash.plsql_subprogram_id
akjhjsy8w1qz6	SELECT QPSEG.SEGMENT_MAPPING_COLUMN, QPSOUR.USER_SOURCING_TYPE SRC_TYPE, QPSOUR.USER_VALUE_STRING VALUE_STRING, QPCON.PRC_CONTEXT_CODE CONTEXT_CODE, QPCON.PRC_CONTEXT_TYPE CONTEXT_TYPE FROM QP_SEGMENTS_B QPSEG, QP_ATTRIBUTE_SOURCING QPSOUR, QP_PRC_CONTEXTS_B QPCON, QP_PTE_REQUEST_TYPES_B QPREQ, QP_PTE_SEGMENTS QPPSEG WHERE QPSOUR.SEGMENT_ID = QPSEG.SEGMENT_ID AND QPSOUR.ATTRIBUTE_SOURCING_LEVEL = :B2 AND QPSOUR.ENABLED_FLAG = 'Y' AND QPPSEG.SOURCING_STATUS = 'N' AND QPPSEG.USED_IN_SETUP = 'Y' AND QPPSEG.USER_SOURCING_METHOD = 'ATTRIBUTE MAPPING' AND QPSOUR.REQUEST_TYPE_CODE = :B1 AND QPSEG.PRC_CONTEXT_ID = QPCON.PRC_CONTEXT_ID AND QPREQ.REQUEST_TYPE_CODE = QPSOUR.REQUEST_TYPE_CODE AND QPPSEG.PTE_CODE = QPREQ.PTE_CODE AND QPPSEG.SEGMENT_ID = QPSOUR.SEGMENT_ID AND QPPSEG.SOURCING_ENABLED = 'Y' AND QPCON.PRC_CONTEXT_TYPE IN ('PRICING_ATTRIBUTE', 'PRODUCT', 'QUALIFIER')
b7nx8v38k5hv9	INSERT INTO ZX_LINES_DET_FACTORS( EVENT_ID, INTERNAL_ORGANIZATION_ID, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_CLASS_MAPPING_ID, EVENT_TYPE_CODE, DOC_EVENT_STATUS, LINE_LEVEL_ACTION, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TRX_DATE, TRX_DOC_REVISION, LEDGER_ID, TRX_CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, MINIMUM_ACCOUNTABLE_UNIT, PRECISION, TRX_LINE_CURRENCY_CODE, TRX_LINE_CURRENCY_CONV_DATE, TRX_LINE_CURRENCY_CONV_RATE, TRX_LINE_CURRENCY_CONV_TYPE, TRX_LINE_MAU, TRX_LINE_PRECISION, LEGAL_ENTITY_ID, ESTABLISHMENT_ID, RECEIVABLES_TRX_TYPE_ID, DEFAULT_TAXATION_COUNTRY, TRX_NUMBER, TRX_LINE_NUMBER, TRX_LINE_DESCRIPTION, TRX_DESCRIPTION, TRX_COMMUNICATED_DATE, BATCH_SOURCE_ID, BATCH_SOURCE_NAME, DOC_SEQ_ID, DOC_SEQ_NAME, DOC_SEQ_VALUE, TRX_DUE_DATE, TRX_TYPE_DESCRIPTION, DOCUMENT_SUB_TYPE, SUPPLIER_TAX_INVOICE_NUMBER, SUPPLIER_TAX_INVOICE_DATE, SUPPLIER_EXCHANGE_RATE, TAX_INVOICE_DA TE, TAX_INVOICE_NUMBER, FIRST_PTY_ORG_ID, TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE, RDNG_SHIP_TO_PTY_TX_PROF_ID, RDNG_SHIP_FROM_PTY_TX_PROF_ID, RDNG_BILL_TO_PTY_TX_PROF_ID, RDNG_BILL_FROM_PTY_TX_PROF_ID, RDNG_SHIP_TO_PTY_TX_P_ST_ID, RDNG_SHIP_FROM_PTY_TX_P_ST_ID, RDNG_BILL_TO_PTY_TX_P_ST_ID, RDNG_BILL_FROM_PTY_TX_P_ST_ID, LINE_INTENDED_USE , TRX_LINE_TYPE , TRX_SHIPPING_DATE, TRX_RECEIPT_DATE, TRX_SIC_CODE, FOB_POINT , TRX_WAYBILL_NUMBER, PRODUCT_ID, PRODUCT_FISC_CLASSIFICATION , PRODUCT_ORG_ID, UOM_CODE, PRODUCT_TYPE , PRODUCT_CODE, PRODUCT_CATEGORY , PRODUCT_DESCRIPTION, USER_DEFINED_FISC_CLASS, LINE_AMT, TRX_LINE_QUANTITY, UNIT_PRICE, CASH_DISCOUNT, VOLUME_DISCOUNT, TRADING_DISCOUNT, TRANSFER_CHARGE, TRANSPORTATION_CHARGE, INSURANCE_CHARGE, OTHER_CHARGE, ASSESSABLE_VALUE, ASSET_FLAG, ASSET_NUMBER, ASSET_ACCUM_DEPRECIATION, ASSET_TYPE, ASSET_COST, RELATED_DOC_APPLICATION_ID, RELATED_DOC_ENTITY_CODE, RELATED_DOC_EVENT_CLASS_CODE, RELATE D_DOC_TRX_ID, RELATED_DOC_NUMBER, RELATED_DOC_DATE, APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_TRX_ID, APPLIED_FROM_LINE_ID, APPLIED_FROM_TRX_NUMBER, ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_LINE_ID, ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE, APPLIED_TO_APPLICATION_ID, APPLIED_TO_ENTITY_CODE, APPLIED_TO_EVENT_CLASS_CODE, APPLIED_TO_TRX_ID , APPLIED_TO_TRX_LINE_ID, TRX_ID_LEVEL2, TRX_ID_LEVEL3, TRX_ID_LEVEL4, TRX_ID_LEVEL5, TRX_ID_LEVEL6, TRX_BUSINESS_CATEGORY, EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON, HISTORICAL_FLAG, TRX_LINE_GL_DATE, LINE_AMT_INCLUDES_TAX_FLAG, ACCOUNT_CCID, ACCOUNT_STRING, MERCHANT_PARTY_TAX_PROF_ID, HQ_ESTB_PARTY_TAX_PROF_ID, NUMERIC1, NUMERIC2, NUMERIC3, NUMERIC4, NUMERIC5, NUMERIC6, NUMERIC7, NUMERIC8, NUMERIC9, NUMERIC10, CHAR1, CHAR2, CHAR3, CHAR4, CHAR5, CHAR6, CHAR7, CHAR8, CH AR9, CHAR10, DATE1, DATE2, DATE3, DATE4, DATE5, DATE6, DATE7, DATE8, DATE9, DATE10, MERCHANT_PARTY_NAME, MERCHANT_PARTY_DOCUMENT_NUMBER, MERCHANT_PARTY_REFERENCE, MERCHANT_PARTY_TAXPAYER_ID, MERCHANT_PARTY_TAX_REG_NUMBER, MERCHANT_PARTY_ID, MERCHANT_PARTY_COUNTRY, SHIP_TO_LOCATION_ID, SHIP_FROM_LOCATION_ID, POA_LOCATION_ID, POO_LOCATION_ID, BILL_TO_LOCATION_ID, BILL_FROM_LOCATION_ID, PAYING_LOCATION_ID, OWN_HQ_LOCATION_ID, TRADING_HQ_LOCATION_ID, POC_LOCATION_ID, POI_LOCATION_ID, POD_LOCATION_ID, TITLE_TRANSFER_LOCATION_ID, SHIP_TO_PARTY_TAX_PROF_ID , SHIP_FROM_PARTY_TAX_PROF_ID, POA_PARTY_TAX_PROF_ID, POO_PARTY_TAX_PROF_ID, PAYING_PARTY_TAX_PROF_ID, OWN_HQ_PARTY_TAX_PROF_ID, TRADING_HQ_PARTY_TAX_PROF_ID, POI_PARTY_TAX_PROF_ID, POD_PARTY_TAX_PROF_ID, BILL_TO_PARTY_TAX_PROF_ID, BILL_FROM_PARTY_TAX_PROF_ID, TITLE_TRANS_PARTY_TAX_PROF_ID, SHIP_TO_SITE_TAX_PROF_ID, SHIP_FROM_SITE_TAX_PROF_ID, POA_SITE_TAX_PROF_ID, POO_SITE_TAX_PROF_ID, PAYING _SITE_TAX_PROF_ID, OWN_HQ_SITE_TAX_PROF_ID, TRADING_HQ_SITE_TAX_PROF_ID, POI_SITE_TAX_PROF_ID, POD_SITE_TAX_PROF_ID, BILL_TO_SITE_TAX_PROF_ID, BILL_FROM_SITE_TAX_PROF_ID, TITLE_TRANS_SITE_TAX_PROF_ID, CTRL_HDR_TX_APPL_FLAG, CTRL_TOTAL_LINE_TX_AMT, CTRL_TOTAL_HDR_TX_AMT, REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID, REF_DOC_LINE_ID, REF_DOC_LINE_QUANTITY, LINE_CLASS, TRX_LINE_DATE, INPUT_TAX_CLASSIFICATION_CODE, OUTPUT_TAX_CLASSIFICATION_CODE, INTERNAL_ORG_LOCATION_ID, PORT_OF_ENTRY_CODE, TAX_REPORTING_FLAG, TAX_AMT_INCLUDED_FLAG, COMPOUNDING_TAX_FLAG, SHIP_THIRD_PTY_ACCT_ID, BILL_THIRD_PTY_ACCT_ID, SHIP_THIRD_PTY_ACCT_SITE_ID, BILL_THIRD_PTY_ACCT_SITE_ID, SHIP_TO_CUST_ACCT_SITE_USE_ID, BILL_TO_CUST_ACCT_SITE_USE_ID, START_EXPENSE_DATE, TRX_BATCH_ID, APPLIED_TO_TRX_NUMBER, SOURCE_APPLICATION_ID, SOURCE_ENTITY_CODE, SOURCE_EVENT_CLASS_CODE, SOURCE_TRX_ID, SOURCE_LINE_ID, SOURCE_TRX_LEVEL_TYPE, SOURCE_TAX_LI NE_ID, REF_DOC_TRX_LEVEL_TYPE, ADJUSTED_DOC_TRX_LEVEL_TYPE, APPLIED_TO_TRX_LEVEL_TYPE, APPLIED_FROM_TRX_LEVEL_TYPE, APPLICATION_DOC_STATUS, OBJECT_VERSION_NUMBER, TAX_PROCESSING_COMPLETED_FLAG, USER_UPD_DET_FACTORS_FLAG, RECORD_TYPE_CODE, HDR_TRX_USER_KEY1, HDR_TRX_USER_KEY2, HDR_TRX_USER_KEY3, HDR_TRX_USER_KEY4, HDR_TRX_USER_KEY5, HDR_TRX_USER_KEY6, LINE_TRX_USER_KEY1, LINE_TRX_USER_KEY2, LINE_TRX_USER_KEY3, LINE_TRX_USER_KEY4, LINE_TRX_USER_KEY5, LINE_TRX_USER_KEY6, TAX_CALCULATION_DONE_FLAG, REVERSED_APPLN_ID, REVERSED_ENTITY_CODE, REVERSED_EVNT_CLS_CODE, REVERSED_TRX_ID, REVERSED_TRX_LEVEL_TYPE, REVERSED_TRX_LINE_ID, EXEMPTION_CONTROL_FLAG, EXEMPT_REASON_CODE, INTERFACE_ENTITY_CODE, INTERFACE_LINE_ID, DEFAULTING_ATTRIBUTE1, DEFAULTING_ATTRIBUTE2, DEFAULTING_ATTRIBUTE3, DEFAULTING_ATTRIBUTE4, DEFAULTING_ATTRIBUTE5, DEFAULTING_ATTRIBUTE6, DEFAULTING_ATTRIBUTE7, DEFAULTING_ATTRIBUTE8, DEFAULTING_ATTRIBUTE9, DEFAULTING_ATTRIBUTE10, PROVNL_TAX_ DETERMINATION_DATE, HISTORICAL_TAX_CODE_ID, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, TOTAL_INC_TAX_AMT, ICX_SESSION_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) SELECT :B296 , :B287 , :B286 , :B285 , :B284 , :B295 , :B283 , :B294 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , NVL(:B268 , :B269 ), NVL(:B266 , :B267 ), NVL(:B264 , :B265 ), NVL(:B262 , :B263 ), NVL(:B260 , :B261 ), NVL(:B258 , :B259 ), :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B154 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B 95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , NVL(:B70 , :B293 ), :B69 , :B68 , :B67 , :B66 , :B65 , DECODE(:B63 , 'RECORD_WITH_NO_TAX', 'N', DECODE(:B292 , 'N', 'N', NVL(:B64 , :B291 ))), :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , 1, :B39 , :B38 , 'ETAX_CREATED', :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B290 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , NVL(:B1 , 0), DECODE(:B289 , 'CALCULATE_TAX', :B288 , NULL), SYSDATE SYSTEM_DATE_1, FND_GLOBAL.USER_ID USER_ID_1, SYSDATE SYSTEM_DATE _2, FND_GLOBAL.USER_ID USER_ID_2, FND_GLOBAL.CONC_LOGIN_ID FROM DUAL
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a .flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
cf030hrp7d40k	SELECT PARTY_ID FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = :B1
cg4wq7jj6ymkz	UPDATE /*+ dynamic_sampling(1) */ QP_NPREQ_LINE_ATTRS_TMP LATTR SET VALUE_FROM = QP_NUMBER.NUMBER_TO_CANONICAL(QP_NUMBER.CANONICAL_TO_NUMBER(LATTR.VALUE_FROM)), VALUE_TO = QP_NUMBER.NUMBER_TO_CANONICAL(QP_NUMBER.CANONICAL_TO_NUMBER(LATTR.VALUE_TO)) WHERE ATTRIBUTE_TYPE = :B2 AND PRICING_STATUS_CODE = :B1 AND EXISTS ( SELECT FORMAT_TYPE FROM FND_FLEX_VALUE_SETS VSET, QP_SEGMENTS_B SEGMENTS, QP_PRC_CONTEXTS_B PCONTEXTS WHERE VSET.FLEX_VALUE_SET_ID = SEGMENTS.USER_VALUESET_ID AND SEGMENTS.APPLICATION_ID = 661 AND PCONTEXTS.PRC_CONTEXT_TYPE <> 'QUALIFIER' AND PCONTEXTS.PRC_CONTEXT_CODE = LATTR.CONTEXT AND SEGMENTS.SEGMENT_MAPPING_COLUMN = LATTR.ATTRIBUTE AND SEGMENTS.PRC_CONTEXT_ID = PCONTEXTS.PRC_CONTEXT_ID AND VSET.FORMAT_TYPE = 'N')
fbxfzbmhtvfgc	select count(descriptive_flex_context_code) l_context_count from fnd_descr_flex_contexts where application_id = 7003 and descriptive_flexfield_name = :1 and substr(descriptive_flex_context_code, 4, 2) = :2 and substr(descriptive_flex_context_code, 7, 8) = :3 and enabled_flag = 'Y'
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gmmq9hrnkkssh	Select distinct LOOKUP_CODE tax_code, description, tax_type From zx_output_classifications_v Where lookup_type = 'ZX_OUTPUT_CLASSIFICATIONS' and org_id in (:1, -99) and enabled_flag = 'Y' and :2 between nvl(start_date_active, :3) and nvl(end_date_active, :4)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File