WORKLOAD REPOSITORY PDB report (PDB snapshots)

DB Name	DB Id	Unique Name	Role	Edition	Release	RAC	CDB
EBSCDB	684292237	EBSCDB	PRIMARY	EE	19.0.0.0.0	NO	YES

Instance	Inst Num	Startup Time
EBSCDB	1	09-Apr-20 23:51

Container DB Id	Container Name	Open Time
684292237	VOL1229	09-Apr-20 23:51

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ebs1229db	Linux x86 64-bit	32	16	1	235.88

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	307	23-Apr-20 18:30:49	738	7.6
End Snap:	314	23-Apr-20 19:19:03	739	7.4
Elapsed:		48.23 (mins)
DB Time:		1,143.80 (mins)

Report Summary

Top ADDM Findings by Average Active Sessions

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	23.7	0.0	0.00	0.15
DB CPU(s):	12.3	0.0	0.00	0.08
Background CPU(s):	0.0	0.0	0.00	0.00
Redo size (bytes):	15,245,406.6	23,717.9
Logical read (blocks):	1,386,269.1	2,156.7
Block changes:	101,351.0	157.7
Physical read (blocks):	3,125.4	4.9
Physical write (blocks):	13.7	0.0
Read IO requests:	2,816.7	4.4
Write IO requests:	0.6	0.0
Read IO (MB):	24.4	0.0
Write IO (MB):	0.1	0.0
IM scan rows:	0.0	0.0
Session Logical Read IM:	0.0	0.0
User calls:	155.3	0.2
Parses (SQL):	5,895.5	9.2
Hard parses (SQL):	0.6	0.0
SQL Work Area (MB):	91.3	0.1
Logons:	1.7	0.0
User logons:	0.3	0.0
Executes (SQL):	41,992.0	65.3
Rollbacks:	1.0	0.0
Transactions:	642.8

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	2,828.5	2,827.9	0.6
Database Requests:	2,817.3	2,816.7	0.6
Optimized Requests:	0.0	0.0	0.0
Redo Requests:
Total (MB):	24.7	24.6	0.1
Database (MB):	24.5	24.4	0.1
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):
Database (blocks):	3,139.1	3,125.4	13.7
Via Buffer Cache (blocks):	3,096.4	3,096.4	0.0
Direct (blocks):	42.6	29.0	13.7

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Wait Statistics
• Undo Statistics
• Segment Statistics
• Initialization Parameters
• Active Session History (ASH) Report
• ADDM Reports

Wait Events Statistics

• Time Model Statistics
• Foreground Wait Class
• Foreground Wait Events
• Service Statistics
• Service Wait Class Stats
• Top Process Types by Wait Class
• Top Process Types by CPU Used

Time Model Statistics

• DB Time represents total time in user calls
• DB CPU represents CPU time of foreground processes
• Total CPU Time represents foreground and background processes
• Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic
• Ordered by % of DB time in descending order, followed by Statistic Name

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond, us - microsecond, ns - nanosecond
• 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 92.6% of Total DB time 68,627.80 (s)
• Total FG Wait Time: 27,981.43 (s) DB CPU time: 35,597.62 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond, us - microsecond, ns - nanosecond
• 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

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

Top Process Types by Wait Class

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Top Process Types by CPU Used

No data exists for this section of the report.

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 57.8% of Total DB Time (s): 68,628
• Captured PL/SQL account for 102.0% of Total DB Time (s): 68,628

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 41.5% of Total CPU Time (s): 35,598
• Captured PL/SQL account for 102.4% of Total CPU Time (s): 35,598

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

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: 4,011,794,727
• Captured SQL account for 76.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 9,044,677
• Captured SQL account for 80.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqs - (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile)
• %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: 8,151,505
• Captured SQL account for 70.4% of Total
• Total UnOptimized Read Requests: 8,151,505
• Captured SQL account for 70.4% 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: 121,522,755
• Captured SQL account for 36.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 17,061,160
• Captured SQL account for 80.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0074pdmwb7fmv	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0423ayw04f496	SELECT FND_PROFILE.VALUE('XLA_MERGE_MATCHING_LINES') FROM DUAL
0758ng3cbw07m	SELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE NOWAIT
0bj4c9wdx63t2	SELECT HSECS FROM V$TIMER
0cnpxtkxfcv9j	SELECT DEFAULT_COST_GROUP_ID FROM MTL_SECONDARY_INVENTORIES WHERE SECONDARY_INVENTORY_NAME = :B2 AND ORGANIZATION_ID = :B1 AND DEFAULT_COST_GROUP_ID IS NOT NULL
0mdnts20d60yr	declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0puu35brrk8z4	SELECT * FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = :B2 AND INVENTORY_ITEM_ID = :B1
0snr5d5m3uxh7	DELETE FROM RA_INTERFACE_SALESCREDITS S WHERE EXISTS (SELECT 'X' FROM RA_INTERFACE_LINES_ALL L WHERE L.INTERFACE_LINE_CONTEXT ='Contra' AND L.INTERFACE_STATUS = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND S.INTERFACE_LINE_ATTRIBUTE1= L.INTERFACE_LINE_ATTRIBUTE1 AND S.INTERFACE_LINE_ATTRIBUTE2= L.INTERFACE_LINE_ATTRIBUTE2 AND S.INTERFACE_LINE_ATTRIBUTE3= L.INTERFACE_LINE_ATTRIBUTE3)
0wabkkyua3y3v	SELECT ITEM_KEY FROM WF_ITEMS WHERE ITEM_TYPE = :B2 AND ITEM_KEY = :B1 FOR UPDATE
0wfry4rz1ygfk	SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ OH.ORDER_TYPE_ID FROM OE_ORDER_HEADERS_ALL OH, WSH_DELIVERY_DETAILS WDD WHERE OH.HEADER_ID = WDD.SOURCE_HEADER_ID AND WDD.RELEASED_STATUS = 'S' AND WDD.SOURCE_CODE = 'OE' AND WDD.MOVE_ORDER_LINE_ID = :B1
0x2a5zafnpz2y	select distinct s.sowner, s.vname from sys.snap$ s, sys.snap_reftime$ r where r.masobj# in (68511, 68722) and s.sowner = r.sowner and s.vname = r.vname and bitand(s.flag3, 67108864) = 67108864
0z318y6g3uagc	declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1c0b7sas42w2z	SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1gpdqku7dc104	SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL FROM DUAL
1h2p0m6c0h40f	SELECT TYPE FROM RA_RULES WHERE RULE_ID = :B1
1v818hwxjxy58	select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wnq9qthbb54q	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); 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_ID 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_NUMBER , 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(MMTT.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.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
2amkqgr5gg7zs	SELECT 'Y' FROM ZX_JURISDICTIONS_GT WHERE TAX_REGIME_CODE = :B2 AND TAX = :B1 AND ROWNUM = 1
2mfx52cpfr0yp	SELECT LOCATION_SEGMENT_ID FROM RA_CUSTOMER_TRX_LINES_ALL INV, ZX_LINES CM, ZX_LINES ZXINV WHERE CM.TAX_LINE_ID = :B1 AND CM.ADJUSTED_DOC_TRX_ID = INV.CUSTOMER_TRX_ID AND CM.ADJUSTED_DOC_TAX_LINE_ID = INV.TAX_LINE_ID AND INV.LINE_TYPE = 'TAX' AND CM.ADJUSTED_DOC_TAX_LINE_ID = ZXINV.TAX_LINE_ID AND CM.TAX_PROVIDER_ID IS NOT NULL AND ZXINV.RECORD_TYPE_CODE = 'MIGRATED'
37f1qguwxw0sk	begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesrep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retval:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3c32a4bk574vp	select d.sumobj# from sys.sumdetail$ d, sys.sum$ s where d.sumobj# = s.obj# and bitand(d.flags, 2) = 2 and bitand(s.xpflags, 34359738368) = 34359738368 and d.detailobj# = :1
3hc5p1pfvaq7m	BEGIN INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper(:1, :2, :3, :4, :5, :6, :7); END;
3s3xp6fupjh7d	UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B45 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B44 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B41 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B42 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B39 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B40 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B38 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B37 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B35 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B36 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B33 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B34 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B30 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B31 , NULL)), AVAILABLE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B26 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B27 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B24 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B25 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B22 , DECODE(ERROR_CODE, NULL, DECODE(:B23 , 150, 0, 61, 0, 0, 0, :B52 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B19 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B20 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B17 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B18 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_AVAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B51 , 4, :B8 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B7 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), ATTRIBUTE_21 = NVL( :B4 , NULL ), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B50 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B49 AND NVL(:B48 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B46 , -1)) = NVL(:B47 , -1)
3xsxzzr557p9y	select S.QUEUE_APPLICATION_ID , S.CONCURRENT_QUEUE_ID , DECODE(Q.TARGET_NODE, null , S.MIN_PROCESSES, NVL(Q.NODE_NAME, Q.TARGET_NODE), S.MIN_PROCESSES, NVL(S.FAILOVER_MIN, S.MIN_PROCESSES)) , DECODE(Q.TARGET_NODE, null , NVL(S.MAX_PROCESSES, S.MIN_PROCESSES), NVL(Q.NODE_NAME, Q.TARGET_NODE), NVL(S.MAX_PROCESSES, S.MIN_PROCESSES), NVL(NVL(S.FAILOVER_MAX, S.FAILOVER_MIN), NVL(S.MAX_PROCESSES, S.MIN_PROCESSES))) , Q.MAX_PROCESSES , NVL(S.MAX_PROCESSES, (-1)) , NVL(Q.TARGET_PROCESSES, (-1)) , NVL(Q.MIN_PROCESSES, (-1)) , NVL(Q.SLEEP_SECONDS, (-1)) , Q.CONTROL_CODE , ((DECODE(SPECIFIC_DATE, null , DECODE(FROM_WEEK_DAY, null , 6, 4), 2)-DECODE(START_TIME, null , 0, 1))+DECODE(P.APPLICATION_ID, 0, DECODE(P.CONCURRENT_TIME_PERIOD_ID, 0, 3, 0), 0)) , NVL(S.SLEEP_SECONDS, 0) , Q.Manager_type , P.APPLICATION_ID , P.CONCURRENT_TIME_PERIOD_ID , NVL(Q.CONCURRENT_TIME_PERIOD_ID, (-1)) , NVL(Q.PERIOD_APPLICATION_ID, (-1)) , S.SERVICE_PARAMETERS , Target_Node from FND_CONCURRENT_QUEUE_SIZE S , FND_CONCURRENT_TIME_PERIODS P , FND_CONCURRENT_QUEUES Q where ((((((P.APPLICATION_ID=S.PERIOD_APPLICATION_ID and Q.APPLICATION_ID=S.QUEUE_APPLICATION_ID) and Q.CONCURRENT_QUEUE_ID=S.CONCURRENT_QUEUE_ID) and P.CONCURRENT_TIME_PERIOD_ID=S.CONCURRENT_TIME_PERIOD_ID) and ((((SPECIFIC_DATE is not null and TRUNC(SYSDATE)=SPECIFIC_DATE) or (FROM_WEEK_DAY is not null and SYSDATE<=NEXT_DAY(((NEXT_DAY(SYSDATE, (mod(((FROM_WEEK_DAY+6)-:b0), 7)+1))-7)-1), (mod(((TO_WEEK_DAY+6)-:b0), 7)+1)))) and (START_TIME is null or TO_NUMBER(TO_CHAR(SYSDATE, 'HH24MI')) between START_TIME and END_TIME)) or (SPECIFIC_DATE is null and FROM_WEEK_DAY is null ))) and (Q.CONTROL_CODE is null or Q.CONTROL_CODE not in ('H'))) and Q.ENABLED_FLAG='Y') union select Application_ID , Concurrent_Queue_ID , 0 , 0 , 0 , 0 , NVL(TARGET_PROCESSES, (-1)) , NVL(MIN_PROCESSES, (-1)) , NVL(Sleep_Seconds, 0) , Control_Code , 10 , NVL(Sleep_Seconds, 0) , Manager_type , (-1) , (-1) , NVL(Concurrent_Time_Period_ID, 0) , NVL(Period_Application_ID, 0) , '' , Target_Node from Fnd_Concurrent_Queues where ((Manager_Type<>6 and (Control_Code is null or Control_Code not in ('H'))) and Enabled_Flag='Y') order by 1, 2, 11, 4 desc
40tb15g61shu2	INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE ) VALUES ( :B4 , :B1 , :B3 , :B2 )
49suaruf5dtth	select distinct s.sowner, s.vname from sys.snap$ s, sys.snap_reftime$ r where r.masobj# in (68722) and s.sowner = r.sowner and s.vname = r.vname and bitand(s.flag3, 67108864) = 67108864
4u81ft6vn8k4j	SELECT ACCT_PERIOD_ID FROM ORG_ACCT_PERIODS WHERE PERIOD_CLOSE_DATE IS NULL AND ORGANIZATION_ID = :B1 AND TRUNC(SCHEDULE_CLOSE_DATE) >= INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(NVL(:B2 , SYSDATE), :B1 ) AND TRUNC(PERIOD_START_DATE) <= INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(NVL(:B2 , SYSDATE), :B1 )
4y08a52989vfk	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5087kdcmjuqjs	SELECT ITEM_TYPE_CODE, ATO_LINE_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
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
53j6qu1wu4673	INSERT INTO MRP_RELIEF_INTERFACE (TRANSACTION_ID , INVENTORY_ITEM_ID , ORGANIZATION_ID , RELIEF_TYPE , DISPOSITION_TYPE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , NEW_ORDER_QUANTITY , NEW_ORDER_DATE , OLD_ORDER_QUANTITY , OLD_ORDER_DATE , DISPOSITION_ID , DEMAND_CLASS , PROCESS_STATUS , LINE_NUM ) VALUES (MRP_RELIEF_INTERFACE_S.NEXTVAL , :B13 , :B12 , :B11 , :B10 , SYSDATE , :B9 , SYSDATE , :B9 , -1 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
58aj2xxbjf844	SELECT STATUS FROM ALL_OBJECTS WHERE OBJECT_NAME = :B1 AND OWNER = USER ORDER BY STATUS ASC
5dsv99085tx1k	SELECT /*+ leading(ct) index(ct, RA_CUSTOMER_TRX_N15) index(ctl, RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ct.customer_trx_id, /* customer_trx_id */ ctl.customer_trx_line_id, /* customer_trx_line_id */ to_number(''), /* cust_trx_line_salesrep_id */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, nvl(ctl.revenue_amount, ctl.extended_amount), to_number('')), /* line_amount */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode(to_number(''), NULL, round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)), 2), round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)) / to_number('')) * to_number('') ), to_number('')), /* accounted_line_amount */ round( 100, 4), /* percent */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, nvl(ctl.revenue_amount, ctl.extended_amount), to_number('') ), /* amount */ decode( DECODE(1, 1, NULL) , NULL, decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode( to_number(''), NULL, round ((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)), 2), round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)) / to_number('') ) * to_number('') ), to_number('')), DECODE(1, 1, NULL)), /* acctd_amt */ 'TAX', /* account class */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, 'N', 'Y' ), /* account_set_flag */ ct.cust_trx_type_id, /* cust_trx_type_id */ decode(ct.invoicing_rule_id, -3, 'Y', 'N'), /* allow_not_open_flag */ to_char(''), /* concatenated segments */ :code_combination_id , /* code_combination_id */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(rgd.gl_date, 'J'), '' ), /* gl_date */ decode( :original_gl_date, NULL, decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(rgd.original_gl_date, 'J'), '' ), decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(nvl(rgd.original_gl_date, :original_gl_date), 'J'), '' ) ), /* orig_gl_date */ nvl(ctl.default_ussgl_transaction_code, ct.default_ussgl_transaction_code), /* ussgl_trx_code */ nvl(ctl.default_ussgl_trx_code_context, ct.default_ussgl_trx_code_context), /* ussgl_trx_code_cntxt*/ ct.primary_salesrep_id, /* salesrep_id */ ctl_line.inventory_item_id, /* inventory_item_id */ ctl_line.memo_line_id, /* memo_line_id */ arp_etax_util.get_tax_account(ctl.customer_trx_line_id, rgd.gl_date, 'TAX'), arp_etax_util.get_tax_account(ctl.customer_trx_line_id, rgd.gl_date, 'INTERIM'), ct.bill_to_site_use_id, /* Billing site id */ ctl_line.warehouse_id /* Warehouse id */ , ctl.link_to_cust_trx_line_id /* 1651593 - tax errors */, ct.rev_rec_application /* Bug 16240687 changes for EBS-VRM Integration */, -999 FROM ra_customer_trx_lines ctl_line, fnd_currencies fc_foreign, ra_cust_trx_line_gl_dist rgd, ra_customer_trx_lines ctl, ra_customer_trx ct WHERE ct.customer_trx_id = ctl.customer_trx_id(+) AND ct.invoice_currency_code = fc_foreign.currency_code /* prevent duplicate records from being created */ AND not exists (SELECT /*+ INDEX (lgd RA_CUST_TRX_LINE_GL_DIST_N10)*/ 'distribution exists' FROM ra_cust_trx_line_gl_dist lgd WHERE ctl.customer_trx_id = lgd.customer_trx_id AND ctl.customer_trx_line_id = lgd.customer_trx_line_id and lgd.request_id = :request_id1 and 'TAX' = lgd.account_class and decode(ct.invoicing_rule_id, NULL, 'N', 'Y' ) = lgd.account_set_flag ) AND ct.customer_trx_id = rgd.customer_trx_id(+) AND 'REC' = rgd.account_class(+) AND 'N' = rgd.account_set_flag(+) AND ctl.line_type = 'TAX' AND ctl.link_to_cust_trx_line_id = ctl_line.customer_trx_line_id(+) and nvl(ct.invoicing_rule_id, -10) = nvl(ct.invoicing_rule_id, -10) AND ct.request_id = :request_id AND ctl.request_id (+) = :request_id AND ct.request_id is not null ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
5f9spvysgkr1c	INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, NLS_SORT, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ORG_ID, NODE_NAME1, CONNSTR1, RECALC_PARAMETERS, EDITION_NAME, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B79 , :B78 , :B77 , DECODE (:B76 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B57 , 'Y', 'Q', DECODE(:B38 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B75 , NULL, 50, :B75 )), DECODE (:B67 , 0, NULL, :B67 ), :B74 , :B73 , NULL, :B72 , 'N', :B71 , :B70 , 'Y', :B57 , 'S', :B69 , SYSDATE, DECODE (:B68 , '', (SYSDATE - :B66 ), GREATEST (:B68 , DECODE (:B67 , 0, (SYSDATE - :B66 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B65 , SYSDATE, :B65 , :B64 , ORACLE_ID, :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B38 , 'Y', 'B', DECODE(:B57 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , DECODE (:B50 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B50 ), 'HH24:MI:SS')), DECODE (:B49 , '', NULL, :B49 ), :B48 , :B47 , :B46 , 'N', :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B39 , :B38 , :B37 , DECODE(:B36 , 'Y', 'Y', FCP.ENABLE_TRACE), :B35 , :B34 , :B33 , :B32 , :B31 , SYS_CONTEXT('userenv', 'current_edition_name'), :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
5fky033hvxn3s	SELECT 'X' FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_ASSIGNMENTS WDA , WSH_DELIVERY_DETAILS WDD WHERE WTS.BATCH_ID = :B1 AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID AND WDD.CONTAINER_FLAG = 'N' AND WDD.SOURCE_CODE = 'OE' AND (EXISTS (SELECT 'any non-cancelled line outside batch' FROM WSH_DELIVERY_DETAILS WDD2 WHERE WDD2.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD2.SOURCE_CODE = 'OE' AND WDD2.CONTAINER_FLAG = 'N' AND WDD2.RELEASED_STATUS <> 'D' AND WDD2.DELIVERY_DETAIL_ID NOT IN (SELECT WDA3.DELIVERY_DETAIL_ID FROM WSH_DELIVERY_ASSIGNMENTS WDA3 , WSH_DELIVERY_LEGS WDL3, WSH_TRIP_STOPS WTS3, WSH_DELIVERY_DETAILS WDD3 WHERE WTS3.BATCH_ID = :B1 AND WDL3.PICK_UP_STOP_ID = WTS3.STOP_ID AND WDA3.DELIVERY_ID = WDL3.DELIVERY_ID AND WDD3.DELIVERY_DETAIL_ID = WDA3.DELIVERY_DETAIL_ID AND WDD3.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD3.SOURCE_CODE = 'OE' AND WDD3.CONTAINER_FLAG = 'N')) OR WDD.TOP_MODEL_LINE_ID IS NOT NULL OR WDD.SHIP_SET_ID IS NOT NULL OR NVL(WDD.SHIP_MODEL_COMPLETE_FLAG, 'N') = 'Y' OR WDD.REQUESTED_QUANTITY <> NVL(WDD.SHIPPED_QUANTITY, -99) OR NVL(REQUESTED_QUANTITY2, -99) <> NVL(SHIPPED_QUANTITY2, -99) OR WDD.SOURCE_LINE_SET_ID IS NOT NULL ) AND ROWNUM = 1
5t39uchjqpyfm	BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
5t6wystf9zvbb	BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15); END;
66tmsr3446uqn	SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6abn0zw8kkvtk	begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; 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
6mu4cfrayu648	SELECT 'x' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT
6vubppkb5tps5	SELECT HEADER.PREVIOUS_CUSTOMER_TRX_ID , NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), HEADER.INVOICING_RULE_ID FROM RA_CUSTOMER_TRX HEADER, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE WHERE LINES.CUSTOMER_TRX_LINE_ID = :B1 AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID
7ptvbaycjtbg4	BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
7qh9zcbrq9ky7	SELECT 'Y' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT
7t8v1mvj7vk71	SELECT 'N' DUMMY_FLAG, REG.REGISTRATION_ID, REG.REGISTRATION_TYPE_CODE, REG.REGISTRATION_NUMBER, REG.VALIDATION_RULE, REG.TAX_AUTHORITY_ID, REG.REP_TAX_AUTHORITY_ID, REG.COLL_TAX_AUTHORITY_ID, REG.ROUNDING_RULE_CODE, REG.TAX_JURISDICTION_CODE, REG.SELF_ASSESS_FLAG, REG.REGISTRATION_STATUS_CODE, REG.REGISTRATION_SOURCE_CODE, REG.REGISTRATION_REASON_CODE, REG.PARTY_TAX_PROFILE_ID, REG.TAX, REG.TAX_REGIME_CODE, REG.INCLUSIVE_TAX_FLAG, REG.EFFECTIVE_FROM, REG.EFFECTIVE_TO, REG.REP_PARTY_TAX_NAME, REG.LEGAL_REGISTRATION_ID, REG.DEFAULT_REGISTRATION_FLAG, REG.BANK_ID, REG.BANK_BRANCH_ID, REG.BANK_ACCOUNT_NUM, REG.LEGAL_LOCATION_ID, REG.RECORD_TYPE_CODE, REG.REQUEST_ID, REG.PROGRAM_APPLICATION_ID, REG.PROGRAM_ID, REG.PROGRAM_LOGIN_ID, REG.ACCOUNT_SITE_ID, NULL, REG.ACCOUNT_ID, REG.TAX_CLASSIFICATION_CODE, REG.ATTRIBUTE1, REG.ATTRIBUTE2, REG.ATTRIBUTE3, REG.ATTRIBUTE4, REG.ATTRIBUTE5, REG.ATTRIBUTE6, REG.ATTRIBUTE7, REG.ATTRIBUTE8, REG.ATTRIBUTE9, REG.ATTRIBUTE10, REG.ATTRIBUTE11, REG.ATTRIBUTE12, REG.ATTRIBUTE13, REG.ATTRIBUTE14, REG.ATTRIBUTE15, REG.ATTRIBUTE_CATEGORY, PTP.PARTY_TYPE_CODE, PTP.SUPPLIER_FLAG, PTP.CUSTOMER_FLAG, PTP.SITE_FLAG, PTP.PROCESS_FOR_APPLICABILITY_FLAG, PTP.ROUNDING_LEVEL_CODE, PTP.WITHHOLDING_START_DATE, PTP.ALLOW_AWT_FLAG, PTP.USE_LE_AS_SUBSCRIBER_FLAG, PTP.LEGAL_ESTABLISHMENT_FLAG, PTP.FIRST_PARTY_LE_FLAG, PTP.REPORTING_AUTHORITY_FLAG, PTP.COLLECTING_AUTHORITY_FLAG, PTP.PROVIDER_TYPE_CODE, PTP.CREATE_AWT_DISTS_TYPE_CODE, PTP.CREATE_AWT_INVOICES_TYPE_CODE, PTP.ALLOW_OFFSET_TAX_FLAG, PTP.EFFECTIVE_FROM_USE_LE, PTP.PARTY_ID, PTP.REP_REGISTRATION_NUMBER FROM ZX_REGISTRATIONS REG, ZX_PARTY_TAX_PROFILE PTP WHERE REG.PARTY_TAX_PROFILE_ID = :B5 AND REG.PARTY_TAX_PROFILE_ID = PTP.PARTY_TAX_PROFILE_ID AND NVL(REG.TAX_REGIME_CODE, 1) = NVL(:B4 , 1) AND NVL(REG.TAX, NVL(:B3 , 1)) = NVL(:B3 , 1) AND NVL(REG.TAX_JURISDICTION_CODE, NVL(:B2 , 1)) = NVL(:B2 , 1) AND :B1 >= REG.EFFECTIVE_FROM AND (:B1 <= REG.EFFECTIVE_TO OR REG.EFFECTIVE_TO IS NULL)
82y1b79wj51rx	SELECT P.CONCURRENT_PROCESS_ID FROM FND_CONCURRENT_PROCESSES P, fnd_concurrent_queues q WHERE (P.QUEUE_APPLICATION_ID != :qapplid OR P.CONCURRENT_QUEUE_ID != :queueid) AND P.PROCESS_STATUS_CODE IN ('A', 'C', 'T', 'P') and (P.QUEUE_APPLICATION_ID = Q.APPLICATION_ID AND P.CONCURRENT_QUEUE_ID = Q.CONCURRENT_QUEUE_ID) AND Q.MANAGER_TYPE <> '6'
8an3ja4qk82vm	SELECT /*+ index (tl RA_CUSTOMER_TRX_LINES_N4) */ TL.CUSTOMER_TRX_LINE_ID, NVL(TL.TAX_CLASSIFICATION_CODE, ZX.OUTPUT_TAX_CLASSIFICATION_CODE) FROM RA_CUSTOMER_TRX T, RA_CUSTOMER_TRX_LINES TL, ZX_LINES_DET_FACTORS ZX WHERE T.REQUEST_ID = :B2 AND T.CUSTOMER_TRX_ID = TL.CUSTOMER_TRX_ID AND TL.LINE_TYPE = 'LINE' AND TL.REQUEST_ID = :B2 AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B1 , 'INV', -99, 'DM', -99, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -99)) AND ZX.APPLICATION_ID = 222 AND ZX.ENTITY_CODE = 'TRANSACTIONS' AND ZX.EVENT_CLASS_CODE IN ('INVOICE', 'DEBIT_MEMO', 'CREDIT_MEMO') AND ZX.TRX_ID = TL.CUSTOMER_TRX_ID AND ZX.TRX_LEVEL_TYPE = 'LINE' AND ZX.TRX_LINE_ID = TL.CUSTOMER_TRX_LINE_ID
8gmgrb5mwa9f9	SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT, CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX, PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID, PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR, ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE (PR.CONDITION_GROUP_CODE IN (:B2 , DECODE(:B4 , 'OUTPUT', SUBSTRB(:B3 , 1, 45)||'-'||'XOP' , 'INPUT' , SUBSTRB(:B3 , 1, 45)||'-'||'XIP' , :B2 ) ) OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND TAX.EFFECTIVE_FROM <= :B1 AND (TAX.EFFECTIVE_TO >= :B1 OR TAX.EFFECTIVE_TO IS NULL ) AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y' AND EXISTS (SELECT /*+ no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE = RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE = PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B4 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a) use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX, RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT, ZX_SCO_TAXES_B_V TAX WHERE RT.TAX_RATE_CODE = :B3 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B4 OR RT.TAX_CLASS IS NULL) AND TAX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y' AND TAX.EFFECTIVE_FROM <= :B1 AND (TAX.EFFECTIVE_TO >= :B1 OR TAX.EFFECTIVE_TO IS NULL ) ) ORDER BY COMPOUNDING_PRECEDENCE NULLS FIRST
8zfgv4ck11dw9	BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9173mvrnzb898	SELECT DEFAULT_COST_GROUP_ID, PRIMARY_COST_METHOD FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B1
a1wk2hsdfm7pu	select /*+ FIRST_ROWS(1) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "APPLSYS"."WF_DEFERRED_TABLE_M" tab, "APPLSYS"."AQ$_WF_DEFERRED_TABLE_M_I" iot where (iot.subscriber# = :1 and iot.name = :2 and iot.queue# = :3) and iot.msg_priority = tab.priority and iot.msg_enq_time = tab.enq_time and iot.msg_step_no = tab.step_no and iot.msg_chain_no = tab.chain_no and iot.msg_local_order_no = tab.local_order_no and tab.corrid = :4 and tab.msgid = iot.msgid
a72z5jmc038tt	SELECT /*+ index (line RA_CUSTOMER_TRX_LINES_N4) */ LINE.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, SUM(DECODE(LINE.EXTENDED_AMOUNT, 0, 0, TAX.EXTENDED_AMOUNT)) INCLUSIVE_AMOUNT, HEADER.INVOICE_CURRENCY_CODE CURRENCY_CODE, HEADER.EXCHANGE_RATE EXCHANGE_RATE, CURRENCY.PRECISION PRECISION, CURRENCY.MINIMUM_ACCOUNTABLE_UNIT MAU FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES CURRENCY, RA_CUSTOMER_TRX_LINES LINE, RA_CUSTOMER_TRX_LINES TAX WHERE HEADER.REQUEST_ID = :B1 AND NVL(HEADER.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B2 , 'CM', NVL(HEADER.PREVIOUS_CUSTOMER_TRX_ID, -99), -99) AND LINE.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINE.LINE_TYPE = 'LINE' AND LINE.REQUEST_ID = :B1 AND TAX.LINK_TO_CUST_TRX_LINE_ID = LINE.CUSTOMER_TRX_LINE_ID AND TAX.LINE_TYPE = 'TAX' AND TAX.AMOUNT_INCLUDES_TAX_FLAG = 'Y' AND TAX.CUSTOMER_TRX_ID = LINE.CUSTOMER_TRX_ID AND HEADER.INVOICE_CURRENCY_CODE = CURRENCY.CURRENCY_CODE GROUP BY LINE.CUSTOMER_TRX_LINE_ID, HEADER.INVOICE_CURRENCY_CODE, HEADER.EXCHANGE_RATE, CURRENCY.PRECISION, CURRENCY.MINIMUM_ACCOUNTABLE_UNIT
aptgswyxvu4ws	SELECT COUNT ( * ) FROM RA_INTERFACE_ERRORS ERR , RA_INTERFACE_LINES LINES WHERE LINES . REQUEST_ID = :B1 AND LINES . INTERFACE_LINE_ID = ERR . INTERFACE_LINE_ID
assndb4wqnd6r	BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
axhwy13vcu03g	SELECT ROWID , DENSE_RANK() OVER (PARTITION BY AE_HEADER_ID ORDER BY AE_HEADER_ID , GL_TRANSFER_MODE_CODE , ACCOUNTING_CLASS_CODE , EVENT_TYPE_CODE , ROUNDING_CLASS_CODE , DOCUMENT_ROUNDING_LEVEL , CURRENCY_CODE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , CODE_COMBINATION_ID , CODE_COMBINATION_STATUS_CODE , 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 , ALT_CODE_COMBINATION_ID , ALT_CCID_STATUS_CODE , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , JGZZ_RECON_REF , USSGL_TRANSACTION_CODE , MERGE_DUPLICATE_CODE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , BUSINESS_CLASS_CODE , MPA_ACCRUAL_ENTRY_FLAG , ENCUMBRANCE_TYPE_ID , DECODE(MERGE_DUPLICATE_CODE, 'N', ROWNUM, 'D', ROWNUM, MERGE_INDEX) , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , ENTERED_CURRENCY_MAU) AE_LINE_NUM , ROWNUM FROM XLA_AE_LINES_GT WHERE TEMP_LINE_NUM <> 0
b5mv0n1ss384u	INSERT INTO MTL_MATERIAL_TRANSACTIONS ( TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, REVISION, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, TRANSACTION_COST, ACTUAL_COST, PRIOR_COST, NEW_COST, QUANTITY_ADJUSTED, VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, TRANSFER_TRANSACTION_ID, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID , ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, REPETITIVE_LINE_ID, DEPARTMENT_ID, OPERATION_SEQ_NUM, SHIPMENT_NUMBER, FREIGHT_CODE, WAYBILL_AIRBILL, TRX_SOURCE_LINE_ID, MOVE_ORDER_LINE_ID , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_AMOUNT , COST_UPDATE_ID , PROJECT_ID , TASK_ID , TO_PROJECT_ID , TO_TASK_ID , LPN_ID , TRANSFER_LPN_ID, CONTENT_LPN_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , CREATED_BY , COST_GROUP_ID , TRANSFER_COST_GROUP_ID , TRANSACTION_SET_ID , PM_COST_COLLECTED , COST_CATEGORY_ID , ORGANIZATION_TYPE , TRANSFER_ORGANIZATION_TYPE , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , PLANNING_ORGANIZATION_ID , PLANNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , XFR_PLANNING_ORGANIZATION_ID , TRANSFER_PLANNING_TP_TYPE , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE, PICK_SLIP_NUMBER, PICKING_LINE_ID, VENDOR_LOT_NUMBER, SOURCE_CODE, SOURCE_LINE_ID, MOVE_TRANSACTION_ID, RCV_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, MOVEMENT_ID, SOURCE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, LOGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID, SHORTAGE_PROCESS_CODE, TRANSFER_PRICE, COSTED_FLAG, OPM_COSTED_FLAG, MCC_CODE, INVOICED_FLAG) VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, ROUND(:75, 5), :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, Decode(:149, 'D', 'N', NULL), DECODE(:150, 'O', 'N', NULL), :151, :152)
b5ycnkqg2b0wk	SELECT MTL_DEMAND_S.NEXTVAL FROM DUAL
bc9gpshz90yw0	INSERT INTO AR_XLA_LINES_EXTRACT ( EVENT_ID , LINE_NUMBER , LANGUAGE , LEDGER_ID , SOURCE_ID , SOURCE_TABLE , LINE_ID , TAX_CODE_ID , LOCATION_SEGMENT_ID , BASE_CURRENCY_CODE , EXCHANGE_RATE_TYPE , EXCHANGE_RATE , EXCHANGE_DATE , ACCTD_AMOUNT , TAXABLE_ACCTD_AMOUNT , ORG_ID , HEADER_TABLE_ID , POSTING_ENTITY , CASH_RECEIPT_ID , CUSTOMER_TRX_ID , CUSTOMER_TRX_LINE_ID , CUST_TRX_LINE_GL_DIST_ID , CUST_TRX_LINE_SALESREP_ID , INVENTORY_ITEM_ID , SALES_TAX_ID , SO_ORGANIZATION_ID , TAX_EXEMPTION_ID , UOM_CODE , WAREHOUSE_ID , AGREEMENT_ID , CUSTOMER_BANK_ACCT_ID , DRAWEE_BANK_ACCOUNT_ID , REMITTANCE_BANK_ACCT_ID , DISTRIBUTION_SET_ID , PAYMENT_SCHEDULE_ID , RECEIPT_METHOD_ID , RECEIVABLES_TRX_ID , ED_ADJ_RECEIVABLES_TRX_ID , UNED_RECEIVABLES_TRX_ID , SET_OF_BOOKS_ID , SALESREP_ID , BILL_SITE_USE_ID , DRAWEE_SITE_USE_ID , PAYING_SITE_USE_ID , SOLD_SITE_USE_ID , SHIP_SITE_USE_ID , RECEIPT_CUSTOMER_SITE_USE_ID , BILL_CUST_ROLE_ID , DRAWEE_CUST_ROLE_ID , SHIP_CUST_ROLE_ID , SOLD_CUST_ROLE_ID , BILL_CUSTOMER_ID , DRAWEE_CUSTOMER_ID , PAYING_CUSTOMER_ID , SOLD_CUSTOMER_ID , SHIP_CUSTOMER_ID , REMIT_ADDRESS_ID , RECEIPT_BATCH_ID , RECEIVABLE_APPLICATION_ID , CUSTOMER_BANK_BRANCH_ID , ISSUER_BANK_BRANCH_ID , BATCH_SOURCE_ID , BATCH_ID , TERM_ID , SELECT_FLAG , LEVEL_FLAG , FROM_TO_FLAG , FROM_AMOUNT , AMOUNT , FROM_ACCTD_AMOUNT , EVENT_TYPE_CODE , EVENT_CLASS_CODE , ENTITY_CODE , TAX_LINE_ID , ADDITIONAL_CHAR1 , MFAR_ADDITIONAL_ENTRY , SOURCE_TYPE , CM_APP_TO_TRX_LINE_ID , BAL_SEG_VALUE , ADDITIONAL_CHAR2 ) SELECT /*+LEADING(gt) cardinality(gt, 1) USE_NL(gt, app)*/ GT.EVENT_ID, DIST.LINE_ID, '', SOB.SET_OF_BOOKS_ID, DIST.SOURCE_ID, DIST.SOURCE_TABLE, DIST.LINE_ID, DIST.TAX_CODE_ID, DIST.LOCATION_SEGMENT_ID, SOB.CURRENCY_CODE, TRXT.EXCHANGE_RATE_TYPE, TRXT.EXCHANGE_RATE, DECODE(TRXT.INVOICE_CURRENCY_CODE, SOB.CURRENCY_CODE, TRXT.TRX_DATE, TRXT.EXCHANGE_DATE), NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), NVL(DIST.TAXABLE_ACCOUNTED_CR, 0) - NVL(DIST.TAXABLE_ACCOUNTED_DR, 0), APP.ORG_ID, APP.RECEIVABLE_APPLICATION_ID, 'APP', NULL, TRXT.CUSTOMER_TRX_ID, TLT.CUSTOMER_TRX_LINE_ID, GLDT.CUST_TRX_LINE_GL_DIST_ID, GLDT.CUST_TRX_LINE_SALESREP_ID, TLT.INVENTORY_ITEM_ID, TLT.SALES_TAX_ID, OSP.MASTER_ORGANIZATION_ID, TLT.TAX_EXEMPTION_ID, TLT.UOM_CODE, TLT.WAREHOUSE_ID, TRXT.AGREEMENT_ID, TRXT.CUSTOMER_BANK_ACCOUNT_ID, TRXT.DRAWEE_BANK_ACCOUNT_ID, TRXT.REMIT_BANK_ACCT_USE_ID, NULL, PSCH.PAYMENT_SCHEDULE_ID, TRXT.RECEIPT_METHOD_ID, NULL, ARP_XLA_EXTRACT_MAIN_PKG.ED_UNED_TRX('EDISC', APP.ORG_ID), ARP_XLA_EXTRACT_MAIN_PKG.ED_UNED_TRX('UNEDISC', APP.ORG_ID), TRXT.SET_OF_BOOKS_ID, TRXT.PRIMARY_SALESREP_ID, TRXT.BILL_TO_SITE_USE_ID, TRXT.DRAWEE_SITE_USE_ID, TRXT.PAYING_SITE_USE_ID, TRXT.SOLD_TO_SITE_USE_ID, TRXT.SHIP_TO_SITE_USE_ID, NULL, TRXT.BILL_TO_CONTACT_ID, TRXT.DRAWEE_CONTACT_ID, TRXT.SHIP_TO_CONTACT_ID, TRXT.SOLD_TO_CONTACT_ID, TRXT.BILL_TO_CUSTOMER_ID, TRXT.DRAWEE_ID, TRXT.PAYING_CUSTOMER_ID, TRXT.SOLD_TO_CUSTOMER_ID, TRXT.SHIP_TO_CUSTOMER_ID, TRXT.REMIT_TO_ADDRESS_ID, NULL, NULL, NULL, NULL, TRXT.BATCH_SOURCE_ID, TRXT.BATCH_ID, TRXT.TERM_ID, 'Y', 'L', 'T', CASE WHEN (APP.UPGRADE_METHOD IS NULL AND APP.STATUS ='APP') THEN CASE WHEN (DIST.FROM_AMOUNT_DR IS NOT NULL OR DIST.FROM_AMOUNT_CR IS NOT NULL) THEN NVL(DIST.FROM_AMOUNT_CR, 0)-NVL(DIST.FROM_AMOUNT_DR, 0) ELSE CASE WHEN (DIST.SOURCE_TYPE NOT IN ('REC', 'EDISC', 'UNEDISC')) THEN NULL ELSE CASE WHEN (APP.EARNED_DISCOUNT_TAKEN IS NOT NULL AND APP.EARNED_DISCOUNT_TAKEN = NVL(DIST.AMOUNT_DR, 0)-NVL(DIST.AMOUNT_CR, 0) AND APP.ACCTD_EARNED_DISCOUNT_TAKEN = NVL(DIST.ACCTD_AMOUNT_DR, 0)-NVL(DIST.ACCTD_AMOUNT_CR, 0) AND DIST.SOURCE_TYPE = 'REC') THEN NULL ELSE CASE WHEN (TRXT.INVOICE_CURRENCY_CODE = CR.CURRENCY_CODE) THEN NVL(DIST.AMOUNT_CR, 0)-NVL(DIST.AMOUNT_DR, 0) ELSE CASE WHEN (APP.AMOUNT_APPLIED <> 0 AND APP.AMOUNT_APPLIED_FROM <> 0) THEN NVL(APP.AMOUNT_APPLIED_FROM / APP.AMOUNT_APPLIED * DIST.AMOUNT_CR, 0)- NVL(APP.AMOUNT_APPLIED_FROM / APP.AMOUNT_APPLIED * DIST.AMOUNT_DR, 0) ELSE NULL END END END END END ELSE NVL(DIST.FROM_AMOUNT_CR, 0) -NVL(DIST.FROM_AMOUNT_DR, 0) END, NVL(DIST.AMOUNT_CR, 0) - NVL(DIST.AMOUNT_DR, 0), CASE WHEN (APP.UPGRADE_METHOD IS NULL AND APP.STATUS ='APP') THEN CASE WHEN (DIST.FROM_ACCTD_AMOUNT_DR IS NOT NULL OR DIST.FROM_ACCTD_AMOUNT_CR IS NOT NULL) THEN NVL(DIST.FROM_ACCTD_AMOUNT_CR, 0)-NVL(DIST.FROM_ACCTD_AMOUNT_DR, 0) ELSE CASE WHEN (DIST.SOURCE_TYPE NOT IN ('REC', 'EDISC', 'UNEDISC')) THEN NULL ELSE CASE WHEN (APP.EARNED_DISCOUNT_TAKEN IS NOT NULL AND APP.EARNED_DISCOUNT_TAKEN = NVL(DIST.AMOUNT_DR, 0)-NVL(DIST.AMOUNT_CR, 0) AND APP.ACCTD_EARNED_DISCOUNT_TAKEN = NVL(DIST.ACCTD_AMOUNT_DR, 0)-NVL(DIST.ACCTD_AMOUNT_CR, 0) AND DIST.SOURCE_TYPE = 'REC') THEN NULL ELSE CASE WHEN (TRXT.INVOICE_CURRENCY_CODE = SOB.CURRENCY_CODE AND CR.CURRENCY_CODE = SOB.CURRENCY_CODE ) THEN NVL(DIST.ACCTD_AMOUNT_CR, 0)-NVL(DIST.ACCTD_AMOUNT_DR, 0) ELSE CASE WHEN (APP.ACCTD_AMOUNT_APPLIED_TO <> 0 AND APP.ACCTD_AMOUNT_APPLIED_FROM <> 0) THEN NVL(APP.ACCTD_AMOUNT_APPLIED_FROM / APP.ACCTD_AMOUNT_APPLIED_TO * DIST.ACCTD_AMOUNT_CR, 0)- NVL(APP.ACCTD_AMOUNT_APPLIED_FROM / APP.ACCTD_AMOUNT_APPLIED_TO * DIST.ACCTD_AMOUNT_DR, 0) ELSE NULL END END END END END ELSE NVL(DIST.FROM_ACCTD_AMOUNT_CR, 0) -NVL(DIST.FROM_ACCTD_AMOUNT_DR, 0) END, GT.EVENT_TYPE_CODE , GT.EVENT_CLASS_CODE , GT.ENTITY_CODE , TLT.TAX_LINE_ID , APP.UPGRADE_METHOD , 'N' , NULL , TO_NUMBER(NULL) , NULL , DECODE(TRXT.UPGRADE_METHOD, 'R12_11ICASH', 'N', '') FROM XLA_EVENTS_GT GT, AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_DISTRIBUTIONS_ALL DIST, GL_SETS_OF_BOOKS SOB, OE_SYSTEM_PARAMETERS_ALL OSP, RA_CUSTOMER_TRX_ALL TRXT, RA_CUSTOMER_TRX_LINES_ALL TLT, RA_CUST_TRX_LINE_GL_DIST_ALL GLDT, AR_PAYMENT_SCHEDULES_ALL PSCH, AR_CASH_RECEIPTS_ALL CR WHERE GT.EVENT_TYPE_CODE IN ( 'RECP_CREATE' , 'RECP_UPDATE' , 'RECP_RATE_ADJUST' ) AND GT.APPLICATION_ID = :B1 AND GT.EVENT_ID = APP.EVENT_ID AND (APP.UPGRADE_METHOD IN ('R12_NLB', 'R12', 'R12_11IMFAR', 'R12_11ICASH', '11I_R12_POST', 'R12_MERGE') OR (APP.UPGRADE_METHOD IS NULL AND APP.STATUS = 'APP') OR (DECODE(APP.UPGRADE_METHOD, '11I_MFAR_UPG' , DECODE(DIST.SOURCE_TABLE_SECONDARY, 'UPMFRAMIAR', 'Y', 'N'), 'N') = 'Y')) AND APP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND APP.ORG_ID = OSP.ORG_ID(+) AND APP.APPLIED_CUSTOMER_TRX_ID = TRXT.CUSTOMER_TRX_ID AND APP.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID AND DIST.SOURCE_ID = APP.RECEIVABLE_APPLICATION_ID AND DIST.SOURCE_TABLE = 'RA' AND DIST.REF_CUSTOMER_TRX_LINE_ID = TLT.CUSTOMER_TRX_LINE_ID(+) AND DIST.REF_CUST_TRX_LINE_GL_DIST_ID = GLDT.CUST_TRX_LINE_GL_DIST_ID(+) AND TRXT.CUSTOMER_TRX_ID = PSCH.CUSTOMER_TRX_ID AND NVL(PSCH.TERMS_SEQUENCE_NUMBER, 1) = 1 UNION ALL SELECT /*+LEADING(gt) cardinality(gt, 1) USE_NL(gt, app)*/ GT.EVENT_ID, DIST.LINE_ID, '', SOB.SET_OF_BOOKS_ID, DIST.SOURCE_ID, DIST.SOURCE_TABLE, DIST.LINE_ID, DIST.TAX_CODE_ID, DIST.LOCATION_SEGMENT_ID, SOB.CURRENCY_CODE, TRXT.EXCHANGE_RATE_TYPE, TRXT.EXCHANGE_RATE, DECODE(TRXT.INVOICE_CURRENCY_CODE, SOB.CURRENCY_CODE, TRXT.TRX_DATE, TRXT.EXCHANGE_DATE), NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), NVL(DIST.TAXABLE_ACCOUNTED_CR, 0) - NVL(DIST.TAXABLE_ACCOUNTED_DR, 0), APP.ORG_ID, APP.RECEIVABLE_APPLICATION_ID, 'APP', NULL, TRXT.CUSTOMER_TRX_ID, TLT.CUSTOMER_TRX_LINE_ID, GLDT.CUST_TRX_LINE_GL_DIST_ID, GLDT.CUST_TRX_LINE_SALESREP_ID, TLT.INVENTORY_ITEM_ID, TLT.SALES_TAX_ID, OSP.MASTER_ORGANIZATION_ID, TLT.TAX_EXEMPTION_ID, TLT.UOM_CODE, TLT.WAREHOUSE_ID, TRXT.AGREEMENT_ID, TRXT.CUSTOMER_BANK_ACCOUNT_ID, TRXT.DRAWEE_BANK_ACCOUNT_ID, TRXT.REMIT_BANK_ACCT_USE_ID, NULL, PSCH.PAYMENT_SCHEDULE_ID, TRXT.RECEIPT_METHOD_ID, NULL, NULL, NULL, TRXT.SET_OF_BOOKS_ID, TRXT.PRIMARY_SALESREP_ID, TRXT.BILL_TO_SITE_USE_ID, TRXT.DRA WEE_SITE_USE_ID, TRXT.PAYING_SITE_USE_ID, TRXT.SOLD_TO_SITE_USE_ID, TRXT.SHIP_TO_SITE_USE_ID, NULL, TRXT.BILL_TO_CONTACT_ID, TRXT.DRAWEE_CONTACT_ID, TRXT.SHIP_TO_CONTACT_ID, TRXT.SOLD_TO_CONTACT_ID, TRXT.BILL_TO_CUSTOMER_ID, TRXT.DRAWEE_ID, TRXT.PAYING_CUSTOMER_ID, TRXT.SOLD_TO_CUSTOMER_ID, TRXT.SHIP_TO_CUSTOMER_ID, TRXT.REMIT_TO_ADDRESS_ID, NULL, NULL, NULL, NULL, TRXT.BATCH_SOURCE_ID, TRXT.BATCH_ID, TRXT.TERM_ID, 'Y', 'L', 'T', CASE WHEN (DIST.FROM_AMOUNT_CR IS NULL AND DIST.FROM_AMOUNT_DR IS NULL) THEN NVL(DIST.AMOUNT_CR, 0) - NVL(DIST.AMOUNT_DR, 0) ELSE NVL(DIST.FROM_AMOUNT_CR, 0) - NVL(DIST.FROM_AMOUNT_DR, 0) END, NVL(DIST.AMOUNT_CR, 0) -NVL(DIST.AMOUNT_DR, 0), CASE WHEN (DIST.FROM_ACCTD_AMOUNT_CR IS NULL AND DIST.FROM_ACCTD_AMOUNT_DR IS NULL) THEN NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0) ELSE NVL(DIST.FROM_ACCTD_AMOUNT_CR, 0) - NVL(DIST.FROM_ACCTD_AMOUNT_DR, 0) END, GT.EVENT_TYPE_CODE , GT.EVENT_CLASS_CODE , GT.ENTITY_CODE , TLT.TAX_LINE_ID , APP.UPGRADE_METHOD , 'N' , DIST.SOURCE_TYPE , DECODE(DIST.REF_PREV_CUST_TRX_LINE_ID, NULL, TO_NUMBER(NULL), DIST.REF_CUSTOMER_TRX_LINE_ID) , ARP_XLA_EXTRACT_MAIN_PKG.THE_SEGMENT_VALUE(SOB.CHART_OF_ACCOUNTS_ID, 'GL_BALANCING', DIST.REF_DIST_CCID) , DECODE(TRXT.UPGRADE_METHOD, 'R12_11ICASH', 'N', '') FROM XLA_EVENTS_GT GT, AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_DISTRIBUTIONS_ALL DIST, GL_SETS_OF_BOOKS SOB, OE_SYSTEM_PARAMETERS_ALL OSP, RA_CUSTOMER_TRX_ALL TRXT, RA_CUSTOMER_TRX_LINES_ALL TLT, RA_CUST_TRX_LINE_GL_DIST_ALL GLDT, AR_PAYMENT_SCHEDULES_ALL PSCH WHERE GT.EVENT_TYPE_CODE IN ( 'CM_CREATE', 'CM_UPDATE' ) AND GT.APPLICATION_ID = :B1 AND GT.EVENT_ID = APP.EVENT_ID AND (APP.UPGRADE_METHOD IN ('R12_NLB', 'R12', 'R12_11IMFAR', 'R12_11ICASH', '11I_R12_POST', 'R12_MERGE') OR (APP.UPGRADE_METHOD IS NULL AND APP.STATUS = 'APP') OR (DECODE(APP.UPGRADE_METHOD, '11I_MFAR_UPG' , DECODE(DIST.SOURCE_TABLE_SECONDARY, 'UPMFRAMIAR', 'Y', 'N'), 'N') = 'Y')) AND DIST.SOURCE_TABLE = 'RA' AND DIST.SOURCE_ID = APP.RECEIVABLE_APPLICATION_ID AND APP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND APP.ORG_ID = OSP.ORG_ID(+) AND APP.APPLIED_CUSTOMER_TRX_ID = TRXT.CUSTOMER_TRX_ID AND DIST.REF_CUSTOMER_TRX_LINE_ID = TLT.CUSTOMER_TRX_LINE_ID(+) AND DIST.REF_CUST_TRX_LINE_GL_DIST_ID = GLDT.CUST_TRX_LINE_GL_DIST_ID(+) AND TRXT.CUSTOMER_TRX_ID = PSCH.CUSTOMER_TRX_ID AND NVL(PSCH.TERMS_SEQUENCE_NUMBER, 1) = 1 AND ((( DIST.REF_CUST_TRX_LINE_GL_DIST_ID IS NOT NULL AND SIGN(DIST.REF_CUST_TRX_LINE_GL_DIST_ID) = 1) AND DIST.REF_CUST_TRX_LINE_GL_DIST_ID IN (SELECT CUST_TRX_LINE_GL_DIST_ID FROM RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD WHERE CTLGD.CUSTOMER_TRX_ID = APP.APPLIED_CUSTOMER_TRX_ID)) OR (((DIST.REF_CUST_TRX_LINE_GL_DIST_ID IS NULL OR SIGN(DIST.REF_CUST_TRX_LINE_GL_DIST_ID) = -1) AND ((SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0))) = SIGN(NVL(DIST.AMOUNT_CR, 0) * -1+NVL(DIST.AMOUNT_DR, 0)) AND DIST.SOURCE_TYPE = 'DEFERRED_TAX' ) OR (SIGN((APP.ACCTD_AMOUNT_APPLIED_TO+NVL(APP.ACCTD_EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.ACCTD_UNEARNED_DISCOUNT_TAKEN, 0))) = SIGN(NVL(DIST.ACCTD_AMOUNT_DR, 0) * -1+NVL(DIST.ACCTD_AMOUNT_CR, 0)) AND DIST.SOURCE_TYPE = 'CURR_ROUND') OR ( (SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0))) = SIGN(NVL(DIST.AMOUNT_DR, 0) * -1+NVL(DIST.AMOUNT_CR, 0)) AND DIST.SOURCE_TYPE NOT IN ('DEFERRED_TAX', 'CURR_ROUND')) AND (((SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0)))*-1) <> 0) OR ((SIGN((APP.AMOUNT_APPLIED+NVL(APP.EARNED_DISCOUNT_TAKEN, 0)+NVL(APP.UNEARNED_DISCOUNT_TAKEN, 0)))*-1 = 0) AND DIST.AMOUNT_DR IS NOT NULL))))))) UNION SELECT /*+LEADING(gt) cardinality(gt, 1) USE_NL(gt, app)*/ GT.EVENT_ID, DIST.LINE_ID, '', SOB.SET_OF_BOOKS_ID, DIST.SOURCE_ID, DIST.SOURCE_TABLE, DIST.LINE_ID, DIST.TAX_CODE_ID, DIST.LOCATION_SEGMENT_ID, SOB.CURRENCY_CODE, TRX.EXCHANGE_RATE_TYPE, TRX.EXCHANGE_RATE, TRX.EXCHANGE_DATE, NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), NVL(DIST.TAXABLE_ACCOUNTED_CR, 0) - NVL(DIST.TAXABLE_ACCOUNTED_DR, 0), APP.ORG_ID, APP.RECEIVABLE_APPLICATION_ID, 'APP', NULL, APP.CUSTOMER_TRX_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, APP.RECEIVABLES_TRX_ID, NULL, NULL, APP.SET_OF_BOOKS_ID, NULL, TRX.BILL_TO_SITE_USE_ID, NULL, NULL, TRX.SOLD_TO_SITE_USE_ID, TRX.SHIP_TO_SITE_USE_ID, NULL, NULL, NULL, NULL, NULL, TRX.BILL_TO_CUSTOMER_ID, NULL, NULL, TRX.SOLD_TO_CUSTOMER_ID, TRX.SHIP_TO_CUSTOMER_ID, NULL, NULL, APP.RECEIVABLE_APPLICATION_ID, NULL, NULL, NULL, NULL, NULL, 'Y', 'L', 'T', NVL(DIST.AMOUNT_CR, 0) - NVL(DIST.AMOUNT_DR, 0), NVL(DIST.AMOUNT_CR, 0) -NVL(DIST.AMOUNT_DR, 0), NVL(DIST.ACCTD_AMOUNT_CR, 0) - NVL(DIST.ACCTD_AMOUNT_DR, 0), GT.EVENT_TYPE_CODE , GT.EVENT_CLASS_CODE , GT.ENTITY_CODE , NULL , APP.UPGRADE_METHOD , 'N' , DIST.SOURCE_TYPE , TO_NUMBER(NULL) , NULL , NULL FROM XLA_EVENTS_GT GT, AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_DISTRIBUTIONS_ALL DIST, GL_SETS_OF_BOOKS SOB, RA_CUSTOMER_TRX_ALL TRX WHERE GT.EVENT_TYPE_CODE IN ( 'CM_CREATE', 'CM_UPDATE' ) AND GT.APPLICATION_ID = :B1 AND GT.EVENT_ID = APP.EVENT_ID AND DIST.SOURCE_TABLE = 'RA' AND DIST.SOURCE_ID = APP.RECEIVABLE_APPLICATION_ID AND APP.STATUS = 'ACTIVITY' AND APP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND TRX.CUSTOMER_TRX_ID = APP.CUSTOMER_TRX_ID AND DIST.SOURCE_TYPE = 'ACTIVITY'
bkwbfrp993czv	UPDATE RA_CUSTOMER_TRX_LINES MTL SET LINE_RECOVERABLE = EXTENDED_AMOUNT, TAX_RECOVERABLE = (SELECT SUM(EXTENDED_AMOUNT) FROM RA_CUSTOMER_TRX_LINES SQTL WHERE SQTL.LINK_TO_CUST_TRX_LINE_ID = MTL.CUSTOMER_TRX_LINE_ID AND SQTL.CUSTOMER_TRX_ID = MTL.CUSTOMER_TRX_ID AND SQTL.LINE_TYPE = 'TAX') WHERE MTL.REQUEST_ID = :B2 AND NVL(MTL.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B1 , 'CM', MTL.PREVIOUS_CUSTOMER_TRX_ID, -99) AND MTL.LINE_TYPE = 'LINE'
bmvr0154yzvmv	SELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES WHERE CALENDAR_CODE = :B1 AND SEQ_NUM IS NOT NULL
bt475t962hbbr	select 1 from sys.sum$, sys.sumdep$ where obj# = sumobj# and bitand(xpflags, 1099511627776) = 1099511627776 and p_obj# = :1 and rownum < 2
byaf6gyh7qg9v	declare ok_flag BOOLEAN ; BEGIN ok_flag := AR_InterfaceSalesCredits_GRP . delete_salescredit ( ) ; END ;
c7f2ankv7htm4	SELECT PRIMARY_RESERVATION_QUANTITY FROM MTL_RESERVATIONS WHERE RESERVATION_ID = :B1
cd9mbmqyf4qhp	UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
d9ybtwvn89wct	SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
drt9k4tpvph64	SELECT AR_TAX.LOCATION_SEGMENT_ID, AR_TAX.ORG_ID, AR_TAX.TAX_LINE_ID, AR_TAX.VAT_TAX_ID, AR_TAX.SET_OF_BOOKS_ID, NVL(AR_REC.GL_DATE, TRUNC(SYSDATE)) FROM RA_CUSTOMER_TRX_LINES AR_TAX, RA_CUST_TRX_LINE_GL_DIST AR_REC WHERE AR_TAX.CUSTOMER_TRX_LINE_ID = :B1 AND AR_TAX.CUSTOMER_TRX_ID = AR_REC.CUSTOMER_TRX_ID AND AR_REC.ACCOUNT_CLASS = 'REC' AND AR_REC.LATEST_REC_FLAG = 'Y'
f07y7y34utqz1	SELECT SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WHERE ENTITY_NAME = :B3 AND ENTITY_ID = :B2 AND STATUS <> 'CANCELLED' AND DOCUMENT_TYPE = :B1
f4p5c1tvqfnfr	SELECT 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_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , 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 , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , 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 , SHIPPING_QUANTITY_UOM2 , 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 , SOLD_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 , ORDER_SOURCE_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 , CHANGE_SEQUENCE , 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 , 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 , REQUIRE_BILLING_VALIDATION , BILLING_PLAN_HEADER_ID , SOURCE_ORDER_LINE_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
g31wtj4vanqku	DELETE FROM RA_INTERFACE_SALESCREDITS S WHERE EXISTS (SELECT 'X' FROM RA_INTERFACE_LINES_ALL L WHERE L.INTERFACE_LINE_CONTEXT ='ORDER ENTRY' AND L.INTERFACE_STATUS = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND S.INTERFACE_LINE_ATTRIBUTE1= L.INTERFACE_LINE_ATTRIBUTE1 AND S.INTERFACE_LINE_ATTRIBUTE2= L.INTERFACE_LINE_ATTRIBUTE2 AND S.INTERFACE_LINE_ATTRIBUTE3= L.INTERFACE_LINE_ATTRIBUTE3 AND S.INTERFACE_LINE_ATTRIBUTE4= L.INTERFACE_LINE_ATTRIBUTE4 AND S.INTERFACE_LINE_ATTRIBUTE5= L.INTERFACE_LINE_ATTRIBUTE5 AND S.INTERFACE_LINE_ATTRIBUTE6= L.INTERFACE_LINE_ATTRIBUTE6 AND S.INTERFACE_LINE_ATTRIBUTE7= L.INTERFACE_LINE_ATTRIBUTE7 AND S.INTERFACE_LINE_ATTRIBUTE8= L.INTERFACE_LINE_ATTRIBUTE8 AND S.INTERFACE_LINE_ATTRIBUTE9= L.INTERFACE_LINE_ATTRIBUTE9 AND S.INTERFACE_LINE_ATTRIBUTE10= L.INTERFACE_LINE_ATTRIBUTE10 AND S.INTERFACE_LINE_ATTRIBUTE11= L.INTERFACE_LINE_ATTRIBUTE11 AND S.INTERFACE_LINE_ATTRIBUTE12= L.INTERFACE_LINE_ATTRIBUTE12 AND S.INTERFACE_LINE_ATTRIBUTE13= L.INTERFACE_LINE_ATTRIBUTE13 AND S.INTERFACE_LINE_ATTRIBUTE14= L.INTERFACE_LINE_ATTRIBUTE14)
gb694cbt9qks7	DELETE FROM WMS_TRANSACTIONS_TEMP WHERE PP_TRANSACTION_TEMP_ID = :B1
gc3yz4rdhyqt5	begin arp_process_payinfo . copy_payment_ext_id ( :num_copy_ext_failures ) ; EXCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in arp_process_payinfo.' || 'copy_payment_ext_id()' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ;
gccbpwamzp78q	declare l_header_rounding_flag VARCHAR2 ( 1 ) ; BEGIN select trx_header_level_rounding into l_header_rounding_flag from ar_system_parameters ; :return_value:i_return_value := arp_rounding . correct_dist_rounding_errors ( :request_id , NULL , NULL , :rows_processed:i_rows_processed , :error_msg:i_error_msg , NULL , NULL , :trx_class , 'N' , :debug_mode , l_header_rounding_flag , 'N' ) ; END ;
gnhmcahkmrnzs	INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gxyzmvghm41nt	DELETE FROM RA_INTERFACE_SALESCREDITS S WHERE EXISTS (SELECT 'X' FROM RA_INTERFACE_LINES_ALL L WHERE L.INTERFACE_LINE_CONTEXT ='OKL_CONTRACTS' AND L.INTERFACE_STATUS = 'P' AND S.INTERFACE_LINE_CONTEXT = L.INTERFACE_LINE_CONTEXT AND S.INTERFACE_LINE_ATTRIBUTE10= L.INTERFACE_LINE_ATTRIBUTE10 AND S.INTERFACE_LINE_ATTRIBUTE14= L.INTERFACE_LINE_ATTRIBUTE14 AND S.INTERFACE_LINE_ATTRIBUTE11= L.INTERFACE_LINE_ATTRIBUTE11)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

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

IO Stats

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

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
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

Tablespace IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

File IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

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

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by Physical Read Requests
• Segments by UnOptimized Reads
• Segments by Optimized Reads
• Segments by Direct Physical Reads
• Segments by Physical Writes
• Segments by Physical Write Requests
• Segments by Direct Physical Writes
• Segments by Table Scans
• Segments by DB Blocks Changes
• Segments by Row Lock Waits
• Segments by ITL Waits
• Segments by Buffer Busy Waits

Segments by Logical Reads

• Total Logical Reads: 4,011,794,727
• Captured Segments account for 45.4% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 9,044,677
• Captured Segments account for 36.0% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

• Total Physical Read Requests: 8,151,505
• Captured Segments account for 31.9% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

• Total UnOptimized Read Requests: 8,151,505
• Captured Segments account for 31.9% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

• Total Direct Physical Reads: 83,768
• Captured Segments account for 51.5% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Writes

• Total Physical Writes: 39,612
• Captured Segments account for 5.7E+03% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

• Total Physical Write Requests: 1,600
• Captured Segments account for 1.0E+05% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

• Total Table Scans: 99
• Captured Segments account for 98.0% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

• % of Capture shows % of DB Block Changes for each top segment compared
• with total DB Block Changes for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

• % of Capture shows % of row lock waits for each top segment compared
• with total row lock waits for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by ITL Waits

• % of Capture shows % of ITL waits for each top segment compared
• with total ITL waits for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

• % of Capture shows % of Buffer Busy Waits for each top segment compared
• with total Buffer Busy Waits for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Initialization Parameters

• Parameters modified by this container
• Parameters modified by other containers
• Multi-Valued Parameters modified by this container
• Multi-Valued Parameters modified by other containers

Parameters modified by this container

• This section shows all the modified initialization parameters that were in effect during the entire snapshot interval
• End Value is displayed only if the parameter value was modified within the snapshot interval

Back to Initialization Parameters
Back to Top

Parameters modified by other containers

• This section shows all the modified initialization parameters that were in effect during the snapshot interval
• End Value is displayed only if the parameter value was changed within the snapshot interval

Back to Initialization Parameters
Back to Top

Multi-Valued Parameters modified by this container

No data exists for this section of the report.

Back to Initialization Parameters
Back to Top

Multi-Valued Parameters modified by other containers

• This section only displays parameters that have more than one value
• '(NULL)' indicates a missing parameter value
• A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot'

Back to Initialization Parameters
Back to Top

Active Session History (ASH) Report

• Top SQL with Top Events
• Top SQL with Top Row Sources
• Top Sessions
• Top Blocking Sessions
• Top PL/SQL Procedures
• Top Events
• Top Event P1/P2/P3 Values
• Top DB Objects
• Activity Over Time

Top SQL with Top Events

• Top SQL statements by DB Time along with the top events by DB Time for those SQLs.
• % Activity is the percentage of DB Time due to the SQL.
• % Event is the percentage of DB Time due to the event that the SQL is waiting on.
• % Row Source is the percentage of DB Time due to the row source for the SQL waiting on the event.
• Executions is the number of executions of the SQL that were sampled in ASH.

Back to Active Session History (ASH) Report
Back to Top

Top SQL with Top Row Sources

• Top SQL statements by DB Time along with the top row sources by DB Time for those SQLs.
• % Activity is the percentage of DB Time due to the SQL.
• % Row Source is the percentage of DB Time spent on the row source by that SQL.
• % Event is the percentage of DB Time spent on the event by the SQL executing the row source.
• Executions is the number of executions of the SQL that were sampled in ASH.

Back to Active Session History (ASH) Report
Back to Top

Top Sessions

No data exists for this section of the report.

Back to Active Session History (ASH) Report
Back to Top

Top Blocking Sessions

• Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only
• '% Activity' represents the load on the database caused by a particular blocking session
• '# Samples Active' shows the number of ASH samples in which the blocking session was found active.
• 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the blocking session was found active.

Back to Active Session History (ASH) Report
Back to Top

Top PL/SQL Procedures

• 'PL/SQL entry subprogram' represents the application's top-level entry-point (procedure, function, trigger, package initialization or RPC call) into PL/SQL.
• 'PL/SQL current subprogram' is the PL/SQL subprogram being executed at the point of sampling . If the value is 'SQL', it represents the percentage of time spent executing SQL for the particular PL/SQL entry subprogram

Back to Active Session History (ASH) Report
Back to Top

Top Events

• Top Events by DB Time
• % Activity is the percentage of DB Time due to the event

Back to Active Session History (ASH) Report
Back to Top

Top Event P1/P2/P3 Values

• Top Events by DB Time and the top P1/P2/P3 values for those events.
• % Event is the percentage of DB Time due to the event
• % Activity is the percentage of DB Time due to the event with the given P1,P2,P3 Values.

Back to Active Session History (ASH) Report
Back to Top

Top DB Objects

• Top DB Objects by DB Time with respect to Application, Cluster, User I/O, buffer busy waits and In-Memory DB events only.
• Tablespace name is not available for reports generated from the root PDB of a consolidated database.
• When ** MISSING ** occurs, some of the object attributes may not be available.