WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	289083851	VIS	1	12-Apr-12 10:04	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
db1.oasb.cisco	Linux x86 64-bit	32	16	2	125.91

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	11	12-Apr-12 10:40:42	235	10.4
End Snap:	19	12-Apr-12 12:12:03	230	9.5
Elapsed:		91.35 (mins)
DB Time:		623.62 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	13,056M	13,056M	Std Block Size:	8K
Shared Pool Size:	9,728M	9,728M	Log Buffer:	142,940K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.8	0.0	0.00	0.05
DB CPU(s):	5.0	0.0	0.00	0.04
Redo size:	8,140,757.4	21,930.9
Logical reads:	823,019.1	2,217.2
Block changes:	50,679.2	136.5
Physical reads:	87.2	0.2
Physical writes:	637.4	1.7
User calls:	137.6	0.4
Parses:	1,371.5	3.7
Hard parses:	1.0	0.0
W/A MB processed:	31.2	0.1
Logons:	0.4	0.0
Executes:	21,110.9	56.9
Rollbacks:	1.0	0.0
Transactions:	371.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.91	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	100.23	Soft Parse %:	99.93
Execute to Parse %:	93.50	Latch Hit %:	97.12
Parse CPU to Parse Elapsd %:	15.40	% Non-Parse CPU:	99.71

Shared Pool Statistics

	Begin	End
Memory Usage %:	37.72	41.44
% SQL with executions>1:	54.63	91.01
% Memory for SQL w/exec>1:	60.74	90.66

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 16 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.18	0.10	15.7	0.5	0.4	83.8

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	128,930.7	128,930.7
SGA use (MB):	25,600.0	25,600.0
PGA use (MB):	1,049.3	993.0
% Host Mem used for SGA+PGA:	20.67	20.63

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): 37417.4s
• 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 94.3% of Total DB time 37,417.37 (s)
• Total FG Wait Time: 7,716.79 (s) DB CPU time: 27,584.87 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 54.5% of Total DB Time (s): 37,417
• Captured PL/SQL account for 101.5% of Total DB Time (s): 37,417

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 48.9% of Total CPU Time (s): 27,585
• Captured PL/SQL account for 102.9% of Total CPU Time (s): 27,585

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

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,511,038,382
• Captured SQL account for 71.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: 477,652
• Captured SQL account for 69.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: 282,906
• Captured SQL account for 70.1% of Total
• Total UnOptimized Read Requests: 282,906
• Captured SQL account for 70.1% 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: 115,710,387
• Captured SQL account for 28.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 7,517,319
• Captured SQL account for 44.0% 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
0074pdmwb7fmv	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
00b9c91r6ysp9	UPDATE WSH_TRIP_STOPS SET PENDING_INTERFACE_FLAG = 'P', REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID, LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_DATE = SYSDATE, BATCH_ID = :B2 WHERE STOP_ID = :B1
03r0vwczazc4d	declare l_return_status VARCHAR2 ( 2000 ) ; l_msg_count NUMBER ; l_msg_data VARCHAR2 ( 2000 ) ; l_instrument_assignment_id NUMBER ; l_response_rec IBY_FNDCPT_COMMON_PUB . RESULT_REC_TYPE ; l_payment_trxn_extension_id NUMBER ; l_payer_rec IBY_FNDCPT_COMMON_PUB . PAYERCONTEXT_REC_TYPE ; l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB . TRXNEXTENSION_REC_TYPE ; l_cust_account_id NUMBER ; l_cust_site_use_id NUMBER ; l_party_id NUMBER ; l_org_id NUMBER ; l_org_type VARCHAR2 ( 30 ) ; l_payment_function VARCHAR2 ( 30 ) ; l_payment_channel VARCHAR2 ( 30 ) ; l_instrument_type VARCHAR2 ( 30 ) ; cursor lines_rec_cur is select distinct l . customer_trx_id , l . trx_number , l . paying_customer_id , l . paying_site_use_id , l . orig_system_bill_customer_id , l . orig_system_bill_address_id , l . org_id , l . receipt_method_id , l . currency_code , l . trx_date , rm . payment_channel_code , pc . instrument_type , su . site_use_id bill_to_site_use_id from ra_interface_lines_gt l , ar_receipt_methods rm , ar_receipt_classes rc , iby_fndcpt_pmt_chnnls_b pc , hz_cust_site_uses su where l . request_id = fnd_global . conc_request_id and l . receipt_method_id is not null and l . customer_trx_id is not null and l . payment_trxn_extension_id is null and nvl ( l . interface_status , '~' ) != 'P' and rm . receipt_method_id = l . receipt_method_id and rm . receipt_class_id = rc . receipt_class_id and rc . creation_method_code in ( 'AUTOMATIC' , 'BR' ) and rm . payment_channel_code = pc . paym ent_channel_code and su . site_use_code = 'BILL_TO' and su . cust_acct_site_id = l . orig_system_bill_address_id ; BEGIN arp_standard . debug ( 'Default Payment Transaction Extension ID()+' ) ; FOR line_rec IN lines_rec_cur LOOP l_payment_channel := line_rec . payment_channel_code ; l_instrument_type := line_rec . instrument_type ; l_instrument_assignment_id := NULL ; l_payment_trxn_extension_id := NULL ; IF l_instrument_type = 'CREDITCARD' THEN Select substrb ( max ( decode ( acct_site_use_id , NULL , '1' || to_char ( instr_assignment_id ) , '2' || to_char ( instr_assignment_id ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'CREDITCARD' and order_of_preference = 1 and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; IF l_instrument_assignment_id IS NULL THEN Select substrb ( max ( decode ( acct_site_use_id , NULL , '1' || to_char ( instr_assignment_id ) , '2' || to_char ( instr_assignment_id ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'CREDITCARD' and order_of_preference = 1 and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , line_rec . bill_to_site_ use_id ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; END IF ; ELSIF l_instrument_type = 'BANKACCOUNT' THEN Select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( instr_assignment_id ) , '3' || to_char ( instr_assignment_id ) ) , decode ( currency_code , NULL , '2' || to_char ( instr_assignment_id ) , '1' || to_char ( instr_assignment_id ) ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and order_of_preference = ( select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( order_of_preference ) , '3' || to_char ( order_of_preference ) ) , decode ( currency_code , NULL , '2' || to_char ( order_of_preference ) , '1' || to_char ( order_of_preference ) ) ) ) , 2 ) from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and line_rec . tr x_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; IF l_instrument_assignment_id IS NULL THEN Select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( instr_assignment_id ) , '3' || to_char ( instr_assignment_id ) ) , decode ( currency_code , NULL , '2' || to_char ( instr_assignment_id ) , '1' || to_char ( instr_assignment_id ) ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , line_rec . bill_to_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and order_of_preference = ( select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( order_of_preference ) , '3' || to_char ( order_of_preference ) ) , decode ( currency_code , NULL , '2' || to_char ( order_of_preference ) , '1' || to_char ( order_of_preference ) ) ) ) , 2 ) from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , li ne_rec . bill_to_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; END IF ; END IF ; arp_standard . debug ( 'l_instrument_assignment_id :- ' || l_instrument_assignment_id ) ; IF l_instrument_assignment_id IS NOT NULL THEN select party_id , cust_account_id , acct_site_use_id , org_id , org_type , payment_function into l_party_id , l_cust_account_id , l_cust_site_use_id , l_org_id , l_org_type , l_payment_function from IBY_FNDCPT_payer_assgn_instr_v where instr_assignment_id = l_instrument_assignment_id and rownum < 2 ; l_payer_rec . payment_function := l_payment_function ; l_payer_rec . party_id := l_party_id ; l_payer_rec . cust_account_id := l_cust_account_id ; l_payer_rec . account_site_id := l_cust_site_use_id ; l_payer_rec . org_id := l_org_id ; l_payer_rec . org_type := l_org_type ; l_trxn_attribs_rec . originating_application_id := arp_standard . application_id ; l_trxn_attribs_rec . order_id := line_rec . customer_trx_id ; l_trxn_attribs_rec . trxn_ref_number1 := 'TRANSACTION' ; l_trxn_attribs_rec . trxn_ref_number2 := line_rec . customer_trx_id ; IBY_FNDCPT_TRXN_PUB . CREATE_TRANSACTION_EXTENSION ( p_api_version => 1.0 , p_init_ msg_list => FND_API . G_TRUE , p_commit => FND_API . G_FALSE , x_return_status => l_return_status , x_msg_count => l_msg_count , x_msg_data => l_msg_data , p_payer => l_payer_rec , p_payer_equivalency => IBY_FNDCPT_COMMON_PUB . G_PAYER_EQUIV_UPWARD , p_pmt_channel => l_payment_channel , p_instr_assignment => l_instrument_assignment_id , p_trxn_attribs => l_trxn_attribs_rec , x_entity_id => l_payment_trxn_extension_id , x_response => l_response_rec ) ; IF l_return_status = FND_API . G_RET_STS_SUCCESS THEN arp_standard . debug ( 'l_payment_trxn_extension_id :- ' || l_payment_trxn_extension_id ) ; update ra_interface_lines_gt set payment_trxn_extension_id = l_payment_trxn_extension_id where customer_trx_id = line_rec . customer_trx_id and request_id = fnd_global . conc_request_id and receipt_method_id is not null ; ELSE arp_standard . debug ( 'Processing customer_trx_id :- ' || line_rec . customer_trx_id ) ; arp_standard . debug ( 'result_code :- ' || l_response_rec . result_code ) ; arp_standard . debug ( 'result_category :- ' || l_response_rec . result_category ) ; arp_standard . debug ( 'result_message :- ' || l_response_rec . result_message ) ; arp_standard . debug ( 'l_return_status :- ' || l_return_status ) ; arp_standard . debug ( 'l_msg_count :- ' || l_msg_count ) ; arp_standard . debug ( 'l_msg_data :- ' || l_msg_data ) ; END IF ; END IF ; END LOOP ; arp_standard . debug ( 'Default Payment Transaction Extension ID()-' ) ; E XCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in Default Payment Transaction Extension ID' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ;
05b1a8ykag57t	insert into ra_customer_trx ( customer_trx_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login, trx_number, cust_trx_type_id, trx_date, set_of_books_id, ct_reference, interface_header_context, interface_header_attribute1, interface_header_attribute2, interface_header_attribute3, interface_header_attribute4, interface_header_attribute5, interface_header_attribute6, interface_header_attribute7, interface_header_attribute8, interface_header_attribute9, interface_header_attribute10, interface_header_attribute11, interface_header_attribute12, interface_header_attribute13, interface_header_attribute14, interface_header_attribute15, bill_to_contact_id, batch_id, batch_source_id, sold_to_customer_id, bill_to_customer_id, bill_to_address_id, ship_to_customer_id, ship_to_contact_id, ship_to_address_id, ship_to_site_use_id, term_id, previous_customer_trx_id, primary_salesrep_id, purchase_order, purchase_order_revision, purchase_order_date, comments, internal_notes, exchange_rate_type, exchange_date, exchange_rate, invoice_currency_code, initial_customer_trx_id, agreement_id, request_id, program_application_id, program_id, program_update_date, complete_flag, doc_sequence_value, credit_method_for_rules, credit_method_for_installments, receipt_method_id, doc_sequence_id, related_customer_trx_id, invoicing_rule_id, ship_via, ship_date_actual, waybill_number, fob_point, territory_id, 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, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20, global_attribute21, global_attribute22, global_attribute23, global_attribute24, global_attribute25, global_attribute26, global_attribute27, global_attribute28, global_attribute29, global_attribute30, status_trx, posting_control_id, created_from, paying_customer_id, paying_site_use_id, reason_code, printing_option, orig_system_batch_name, payment_server_order_num, approval_code, contract_id, org_id, legal_entity_id, application_id, payment_attributes, billing_date) select l.customer_trx_id, sysdate, :b_last_updated_by, sysdate, :b_created_by, :b_last_update_login, '~$~$$$', l.cust_trx_type_id, l.trx_date, l.set_of_books_id, DECODE(b.DEFAULT_REFERENCE, '1', l.interface_line_attribute1, '2', l.interface_line_attribute2, '3', l.interface_line_attribute3, '4', l.interface _line_attribute4, '5', l.interface_line_attribute5, '6', l.interface_line_attribute6, '7', l.interface_line_attribute7, '8', l.interface_line_attribute8, '9', l.interface_line_attribute9, '10', l.interface_line_attribute10, '11', l.interface_line_attribute11, '12', l.interface_line_attribute12, '13', l.interface_line_attribute13, '14', l.interface_line_attribute14, '15', l.interface_line_attribute15, NULL ), substr(decode(l.interface_line_context, 'Global Data Elements', decode(1, 0, null, 'ORDER ENTRY'), decode(1, 1, l.interface_line_context, 'ORDER ENTRY')), 1, 30), l.interface_line_attribute1, l.interface_line_attribute2, l.interface_line_attribute3, l.interface_line_attribute4, l.interface_line_attribute5, l.interface_line_attribute6, l.interface_line_attribute7, l.interface_line_attribute8, l.interface_line_attribute9, l.interface_line_attribute10, l.interface_line_attribute11, l.interface_line_attribute12, l.interface_line_attribute13, l.interface_line_attribute14, l.interface_line_attribute15, l.orig_system_bill_contact_id, :b_batch_id, :b_batch_source_id, l.orig_system_sold_customer_id, l.orig_system_bill_customer_id, l.orig_system_bill_address_id, l.orig_system_ship_customer_id, l.orig_system_ship_contact_id, l.orig_system_ship_address_id, null, l.term_id, l.previous_customer_trx_id, l.primary_salesrep_id, l.purchase_order, l.purchase_order_revision, l.purchase_order_date, l.comments, l.internal_notes, decode(l.currency_code, g.currency_code, null, l.conversion_type), decode(l.currency_code, g.currency_code, null, nvl(l.conversion_date, l.trx_date)), decode(l.currency_code, g.currency_code, null, l.conversion_rate), l.currency_code, l.initial_customer_trx_id, l.agreement_id, :b1, :b_program_application_id, :b_program_id, sysdate, 'N', l.document_number, l.credit_method_for_acct_rule, l.credit_method_for_installments, l.receipt_method_id, l.document_number_sequence_id, l.related_customer_trx_id, l.invoicing_rule_id, l.ship_via, l.ship_date_actual, l.waybill_number, l.fob_point, l.territory_id, l.header_attribute_category, rtrim(l.header_attribute1), rtrim(l.header_attribute2), rtrim(l.header_attribute3), rtrim(l.header_attribute4), rtrim(l.header_attribute5), rtrim(l.header_attribute6), rtrim(l.header_attribute7), rtrim(l.header_attribute8), rtrim(l.header_attribute9), rtrim(l.header_attribute10), rtrim(l.header_attribute11), rtrim(l.header_attribute12), rtrim(l.header_attribute13), rtrim(l.header_attribute14), rtrim(l.header_attribute15), l.header_gdf_attr_category, l.header_gdf_attribute1, l.header_gdf_attribute2, l.header_gdf_attribute3, l.header_gdf_attribute4, l.header_gdf_attribute5, l.header_gdf_attribute6, l.header_gdf_attribute7, l.header_gdf_attribute8, l.header_gdf_attribute9, l.header_gdf_attribu te10, l.header_gdf_attribute11, l.header_gdf_attribute12, l.header_gdf_attribute13, l.header_gdf_attribute14, l.header_gdf_attribute15, l.header_gdf_attribute16, l.header_gdf_attribute17, l.header_gdf_attribute18, l.header_gdf_attribute19, l.header_gdf_attribute20, l.header_gdf_attribute21, l.header_gdf_attribute22, l.header_gdf_attribute23, l.header_gdf_attribute24, l.header_gdf_attribute25, l.header_gdf_attribute26, l.header_gdf_attribute27, l.header_gdf_attribute28, l.header_gdf_attribute29, l.header_gdf_attribute30, 'OP', -3, 'RAXTRX', decode(l.receipt_method_id, null, null, l.paying_customer_id), decode(l.receipt_method_id, null, null, l.paying_site_use_id), l.reason_code, l.printing_option, l.orig_system_batch_name, l.payment_server_order_num, l.approval_code, l.contract_id, l.org_id, l.legal_entity_id, l.application_id, l.payment_attributes, l.billing_date from ra_interface_lines_gt l, ra_batch_sources b, gl_sets_of_books g where l.set_of_books_id = g.set_of_books_id and b.name = l.batch_source_name and l.interface_line_id in ( select /*+ INDEX (l1, RA_INTERFACE_LINES_N2) */ min(l1.interface_line_id) from ra_interface_lines_gt l1 where l1.request_id = :b2 and l1.customer_trx_id is not null and nvl(l1.interface_status, '~') != 'P' and l1.link_to_line_id is null and not ((l1.reference_line_id is not null or l1.reference_line_attribute1 || l1.reference_line_attribute2 || l1.reference_line _attribute3 || l1.reference_line_attribute4 || l1.reference_line_attribute5 || l1.reference_line_attribute6 || l1.reference_line_attribute7 || l1.reference_line_attribute8 || l1.reference_line_attribute9 || l1.reference_line_attribute10 || l1.reference_line_attribute11 || l1.reference_line_attribute12 || l1.reference_line_attribute13 || l1.reference_line_attribute14 || l1.reference_line_attribute15 is not null) and exists (select 'x' from ra_cust_trx_types t where t.cust_trx_type_id = l1.cust_trx_type_id and t.type = 'CM'))and ( l1.customer_trx_id, NVL(l1.ship_date_actual, to_date('01/01/0001', 'dd-mm-yyyy')) ) IN ( select /*+ no_merge */ l2.customer_trx_id, NVL(MIN(l2.ship_date_actual), to_date('01/01/0001', 'dd-mm-yyyy')) from ra_interface_lines_gt l2 where request_id = :b3 group by l2.customer_trx_id )group by l1.customer_trx_id )
05s9358mm6vrr	begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
06cpusv7u92nh	SELECT a.INSTANCE_ID from csi_item_instances a where a.inventory_item_id = :INVENTORY_ITEM_ID AND a.inventory_revision IS NULL AND a.serial_number IS NULL AND a.lot_number IS NULL AND a.inv_organization_id = :inv_organization_id AND a.inv_subinventory_name = :inv_subinventory_name AND a.inv_locator_id IS NULL AND a.instance_usage_code = :instance_usage_code
0758ng3cbw07m	SELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE NOWAIT
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;
0tsz27uj32p77	UPDATE GL_BC_PACKETS SET GROUP_ID = :B2 , JE_BATCH_NAME = :B1 WHERE AE_HEADER_ID IN (SELECT AE_HEADER_ID FROM XLA_AE_HEADERS WHERE GROUP_ID = :B2 AND APPLICATION_ID = :B3 )
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
0wrz2kbatczjk	SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
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
1c8gw5pykyvbq	SELECT WPA.PROCESS_NAME, WPA.INSTANCE_LABEL FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA WHERE WIAS.ITEM_TYPE = :B5 AND WIAS.ITEM_KEY = :B4 AND WIAS.ACTIVITY_STATUS = :B3 AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID AND WPA.ACTIVITY_NAME = :B2 AND WPA.PROCESS_NAME = NVL(:B1 , WPA.PROCESS_NAME)
1g62m2w49xngu	BEGIN XNP_EVENT.PROCESS_IN_EVT(:1, :2, :3, :4) ; END;
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;
1zj0h70du2jyx	INSERT INTO WSH_DELIVERY_DETAILS( SOURCE_CODE, SOURCE_HEADER_ID, SOURCE_LINE_ID, CUSTOMER_ID, SOLD_TO_CONTACT_ID, INVENTORY_ITEM_ID, ITEM_DESCRIPTION, HAZARD_CLASS_ID, COUNTRY_OF_ORIGIN, SHIP_FROM_LOCATION_ID, SHIP_TO_LOCATION_ID, SHIP_TO_CONTACT_ID, SHIP_TO_SITE_USE_ID, DELIVER_TO_LOCATION_ID, DELIVER_TO_CONTACT_ID, DELIVER_TO_SITE_USE_ID, INTMED_SHIP_TO_LOCATION_ID, INTMED_SHIP_TO_CONTACT_ID, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, REQUESTED_QUANTITY, REQUESTED_QUANTITY_UOM, SUBINVENTORY, REVISION, DATE_REQUESTED, DATE_SCHEDULED, MASTER_CONTAINER_ITEM_ID, DETAIL_CONTAINER_ITEM_ID, SHIP_METHOD_CODE, CARRIER_ID, FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE, FOB_CODE, CUSTOMER_ITEM_ID, DEP_PLAN_REQUIRED_FLAG, CUSTOMER_PROD_SEQ, CUSTOMER_DOCK_CODE, CUST_MODEL_SERIAL_NUMBER, CUSTOMER_JOB, CUSTOMER_PRODUCTION_LINE, NET_WEIGHT, WEIGHT_UOM_CODE, VOLUME, VOLUME_UOM_CODE, TP_ATTRIBUTE_CATEGORY, 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, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, MVT_STAT_STATUS, ORGANIZATION_ID, SHIP_SET_ID, ARRIVAL_SET_ID, SHIP_MODEL_COMPLETE_FLAG, TOP_MODEL_LINE_ID, SOURCE_HEADER_NUMBER, SOURCE_HEADER_TYPE_ID, SOURCE_HEADER_TYPE_NAME, CUST_PO_NUMBER, ATO_LINE_ID, SRC_REQUESTED_QUANTITY, SRC_REQUESTED_QUANTITY_UOM, CANCELLED_QUANTITY, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, PROJECT_ID, TASK_ID, ORG_ID, OE_INTERFACED_FLAG, INV_INTERFACED_FLAG, SOURCE_LINE_NUMBER, INSPECTION_FLAG, RELEASED_STATUS, DELIVERY_DETAIL_ID, CONTAINER_FLAG, GROSS_WEIGHT, SEAL_CODE, UNIT_NUMBER, UNIT_PRICE, CURRENCY_CODE, PREFERRED_GRADE, SRC_REQUESTED_QUANTITY2, SRC_REQUESTED_QUANTITY_UOM2, REQUESTED_QUANTITY2, CANCELLED_QUANTITY2, REQUESTED_QUANTITY_UOM2, PICKABLE_FLAG, ORIGINAL_SUBINVENTORY, RECEIVED_QUANTITY, RECEIVED_QUANTITY2, SOURCE_LINE_SET_ID, LINE_DIRECTION, IGNORE_FOR_PLANNING, EARLIEST_PICKUP_DATE, LATEST_PICKUP_DATE, EARLIEST_DROPOFF_DATE, LATEST_DROPOFF_DATE, SOURCE_DOCUMENT_TYPE_ID, SERVICE_LEVEL, MODE_OF_TRANSPORT, SOURCE_BLANKET_REFERENCE_ID, SOURCE_BLANKET_REFERENCE_NUM, VENDOR_ID, PARTY_ID, SHIP_FROM_SITE_ID, HOLD_CODE, SUPPLIER_ITEM_NUMBER, PO_SHIPMENT_LINE_ID, PO_SHIPMENT_LINE_NUMBER, SHIPPING_CONTROL, SOURCE_LINE_TYPE_CODE, PO_REVISION_NUMBER, RELEASE_REVISION_NUMBER, WV_FROZEN_FLAG, UNIT_WEIGHT, UNIT_VOLUME ) VALUES ( :B140 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , NVL(:B9 , -1), :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , NVL(:B20 , -1), NVL ( :B21 , 'XX'), :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 , :B31 , :B32 , :B33 , :B34 , :B35 , :B36 , :B37 , :B38 , :B39 , :B40 , :B41 , :B42 , :B43 , :B44 , :B45 , :B46 , :B47 , :B48 , :B49 , :B50 , :B51 , :B52 , :B53 , :B54 , :B55 , :B56 , :B57 , :B58 , :B59 , :B60 , :B61 , :B62 , :B63 , :B64 , :B65 , :B66 , :B67 , :B68 , :B69 , :B70 , :B71 , :B72 , :B73 , :B74 , :B75 , :B142 , :B143 , :B143 , :B142 , :B142 , NULL, NULL, NULL, :B76 , :B77 , :B78 , :B79 , :B80 , :B81 , :B82 , :B83 , :B84 , :B85 , :B86 , :B87 , :B88 , :B89 , :B90 , :B91 , :B92 , :B93 , :B94 , :B141 , DECODE(:B140 , 'OE', 'N', 'X'), NVL(:B95 , DECODE(:B96 , 'Y', 'N', 'X')), :B97 , DECODE (:B140 , 'OKE' , NVL (:B98 , 'N') , 'N' ), :B99 , WSH_DELIVERY_DETAILS_S.NEXTVAL, 'N', :B100 , :B101 , :B102 , :B103 , :B104 , :B105 , :B106 , :B107 , :B108 , :B109 , :B110 , :B111 , :B112 , :B113 , :B114 , :B115 , DECODE(:B140 , 'OE', 'O', 'OKE', 'O', 'PO', DECODE(:B116 , 'Y', 'D', 'I'), 'O'), NVL(:B117 , 'N'), :B118 , :B119 , :B120 , :B121 , :B122 , :B123 , :B124 , :B125 , :B126 , :B127 , :B128 , :B129 , :B130 , :B131 , :B132 , :B133 , :B134 , :B135 , :B136 , :B137 , 'N' , :B138 , :B139 ) RETURNING DELIVERY_DETAIL_ID INTO :O0
252pmsa01tgbj	SELECT APPLICATION_ID FROM FND_APPLICATION WHERE APPLICATION_SHORT_NAME = :B1
2pd6nc2mwjfk0	SELECT /*+ 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(1, 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)) / 1) * 1 ), 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( 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( 1, 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)) / 1 ) * 1 ), to_number('')), /* 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 */ 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
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
33838u0xy9fk9	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 , INVOICED_FLAG , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_AMOUNT , COST_U PDATE_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, SOUR CE_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 ) 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, 'N', :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))
34bx0h6k0q8a1	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 = :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 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 = :B3 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, -1 COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_RATE_CODE = :B4 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFE CTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL) AND EXISTS (SELECT 1 FROM ZX_SCO_TAXES_B_V TAX WHERE 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') ) ORDER BY COMPOUNDING_PRECEDENCE
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;
3c2x9nz802wy0	begin JTM_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST(:1, :2, :3, :4, :5, :6, :7, :8); exception when others then begin JTM_MESSAGE_LOG_PKG.log_msg( 'UPDATE_ITEM_INSTANCE_POST', 'CSI_ITEM_INSTANCE_VUHK', 'Error:' || SQLERRM , 1, 'JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST'); exception when others then null; end; end;
3h1rjtcff3wy1	BEGIN ordsys.CARTRIDGE.dbms_feature_multimedia(:feature_boolean, :aux_cnt, :feature_info); END;
3wtnuzdm579hg	UPDATE RA_INTERFACE_LINES_GT SET PAYMENT_TRXN_EXTENSION_ID = :B2 WHERE CUSTOMER_TRX_ID = :B1 AND REQUEST_ID = FND_GLOBAL . CONC_REQUEST_ID AND RECEIPT_METHOD_ID IS NOT NULL
4157ujygrhkyt	INSERT /*+ NO_DST_UPGRADE_INSERT_CONV IDX(0) */ INTO "WSH"."MLOG$_WSH_DELIVERY_DETAILS" (dmltype$$, old_new$$, snaptime$$, change_vector$$, m_row$$, "DELIVERY_DETAIL_ID", "SOURCE_CODE", "CUST_PO_NUMBER", "CUSTOMER_ID", "INVENTORY_ITEM_ID", "ITEM_DESCRIPTION", "SHIP_SET_ID", "ARRIVAL_SET_ID", "TOP_MODEL_LINE_ID", "SHIP_MODEL_COMPLETE_FLAG", "SHIP_FROM_LOCATION_ID", "ORGANIZATION_ID", "SHIP_TO_LOCATION_ID", "SRC_REQUESTED_QUANTITY", "SRC_REQUESTED_QUANTITY_UOM", "REQUESTED_QUANTITY", "SHIPPED_QUANTITY", "RELEASED_STATUS", "FREIGHT_TERMS_CODE", "NET_WEIGHT", "WEIGHT_UOM_CODE", "VOLUME", "VOLUME_UOM_CODE", "ORG_ID", "CREATED_BY", "SPLIT_FROM_DELIVERY_DETAIL_ID", "GROSS_WEIGHT", "CONTAINER_TYPE_CODE", "CONTAINER_FLAG", "UNIT_PRICE", "CURRENCY_CODE", "FREIGHT_CLASS_CAT_ID", "COMMODITY_CODE_CAT_ID", "SOURCE_HEADER_NUMBER", "SOURCE_LINE_NUMBER", "PICKED_QUANTITY", "EARLIEST_PICKUP_DATE", "LATEST_PICKUP_DATE", "EARLIEST_DROPOFF_DATE", "LATEST_DROPOFF_DATE", "TP_DELIVERY_DETAIL_ID", "SOURCE_DOCUMENT_TYPE_ID", "VENDOR_ID", "IGNORE_FOR_PLANN ING", "LINE_DIRECTION", "PO_SHIPMENT_LINE_NUMBER", "SOURCE_LINE_TYPE_CODE") VALUES (:d, :o, to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'), :c, :m, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :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)
43w0r9122v7jm	select max(bytes) from dba_segments
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
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;
502wjpr8z94b4	SELECT MSG_STATUS FROM XNP_MSGS WHERE MSG_ID = :B1
54wkgprhc32fh	SELECT COUNT(*), DATA_TYPE FROM SYS.DBA_TAB_COLS WHERE DATA_TYPE IN ('ORDIMAGE', 'ORDAUDIO', 'ORDDOC', 'ORDVIDEO', 'SI_COLOR', 'SI_STILLIMAGE', 'SI_AVERAGECOLOR', 'SI_COLORHISTOGRAM', 'SI_POSITIONALCOLOR', 'SI_TEXTURE', 'SI_FEATURELIST') AND OWNER != 'PM' GROUP BY DATA_TYPE
55dc767ajydh3	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
5dyqsrkd6232u	select 1 l_value from csi_t_transaction_lines where transaction_line_id in (select transaction_line_id from csi_t_transaction_lines where source_transaction_id = :source_transaction_id and source_transaction_table = :source_transaction_table)
5jvn1sqv3zrgh	select /*+ FIRST_ROWS(1) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, 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 "XNP"."XNP_IN_EVT_QTAB" tab where q_name = :1 and (state = :2 ) order by q_name, state, priority, enq_time, step_no, chain_no, local_order_no for update skip locked
5k6qbnudqmsvm	SELECT NEGATIVE_INV_RECEIPT_CODE FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B1
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;
5tfvz9jwzghhh	BEGIN DECLARE l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ; BEGIN l_msg_header.message_id := :message_id ; l_msg_header.message_code := :message_code ; l_msg_header.reference_id := :reference_id ; l_msg_header.opp_reference_id := :opp_ref_id ; l_msg_header.creation_date := :creation_date; l_msg_header.sender_name := :sender_name ; l_msg_header.recipient_name := :recipient_name ; l_msg_header.version := :version; l_msg_header.direction_indr := :direction_indr ; l_msg_header.order_id := :order_id ; l_msg_header.wi_instance_id := :wi_instance_id ; l_msg_header.fa_instance_id := :fa_instance_id ; XNP_CSISOSHP_U.DEFAULT_PROCESS( l_msg_header, :l_msg_body, :error_code, :error_message ) ; END ; END ;
608c0n36kaw62	begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); 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
685jucmq3q7nd	BEGIN DBMS_FEATURE_XDB(:feature_boolean, :aux_cnt, :feature_info); END;
6abn0zw8kkvtk	begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; END ;
6hq9tpnvfqvuw	INSERT INTO MTL_DEMAND( DEMAND_ID , ORGANIZATION_ID , INVENTORY_ITEM_ID , DEMAND_SOURCE_TYPE , DEMAND_SOURCE_HEADER_ID , DEMAND_SOURCE_LINE , DEMAND_SOURCE_DELIVERY , DEMAND_SOURCE_NAME , UOM_CODE , LINE_ITEM_QUANTITY , PRIMARY_UOM_QUANTITY , LINE_ITEM_RESERVATION_QTY , RESERVATION_QUANTITY , COMPLETED_QUANTITY , REQUIREMENT_DATE , RESERVATION_TYPE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PARENT_DEMAND_ID , EXTERNAL_SOURCE_CODE , EXTERNAL_SOURCE_LINE_ID , USER_LINE_NUM , USER_DELIVERY , SCHEDULE_ID , AUTODETAIL_GROUP_ID , SUPPLY_SOURCE_TYPE , SUPPLY_SOURCE_HEADER_ID , SUPPLY_GROUP_ID , UPDATED_FLAG , REVISION , LOT_NUMBER , SERIAL_NUMBER , SUBINVENTORY , LOCATOR_ID , COMPONENT_SEQUENCE_ID , PARENT_COMPONENT_SEQ_ID , RTO_MODEL_SOURCE_LINE , RTO_PREVIOUS_QTY , CONFIG_STATUS , AVAILABLE_TO_MRP , AVAILABLE_TO_ATP , ESTIMATED_RELEASE_DATE , DEMAND_CLASS , ROW_STATUS_FLAG , ORDER_CHANGE_REPORT_FLAG , ATP_LEAD_TIME , EXPLOSION_EFFECTIVITY_DATE , BOM_LEVEL , MRP_DATE , MRP_QUANTITY , CUSTOMER_ID , TERRITORY_ID , BILL_TO_SITE_USE_ID , SHIP_TO_SITE_USE_ID , MASTER_RESERVATION_QTY , DESCRIPTION , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , DEMAND_TYPE , DUPLICATED_CONFIG_ITEM_ID , DUPLICATED_CO NFIG_DEMAND_ID , EXPLOSION_GROUP_ID , ORDERED_ITEM_ID , CONFIG_GROUP_ID , OPERATION_SEQ_NUM , N_COLUMN1) SELECT :B3 , A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.DEMAND_SOURCE_TYPE_ID , NVL(A.DEMAND_SOURCE_HEADER_ID, 0) , A.DEMAND_SOURCE_LINE_ID , A.DEMAND_SOURCE_DELIVERY , A.DEMAND_SOURCE_NAME , A.RESERVATION_UOM_CODE , A.RESERVATION_QUANTITY , A.PRIMARY_RESERVATION_QUANTITY , NULL , NULL , 0 , A.REQUIREMENT_DATE , DECODE(A.SUPPLY_SOURCE_TYPE_ID, 13, 2, 3) , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_LOGIN , A.REQUEST_ID , A.PROGRAM_APPLICATION_ID , A.PROGRAM_ID , A.PROGRAM_UPDATE_DATE , :B2 , A.EXTERNAL_SOURCE_CODE , A.EXTERNAL_SOURCE_LINE_ID , NULL , NULL , NULL , A.AUTODETAIL_GROUP_ID , DECODE(A.SUPPLY_SOURCE_TYPE_ID, 13, NULL, A.SUPPLY_SOURCE_TYPE_ID) , A.SUPPLY_SOURCE_HEADER_ID , NULL , NULL , A.REVISION , A.LOT_NUMBER , A.SERIAL_NUMBER , A.SUBINVENTORY_CODE , A.LOCATOR_ID , NULL , NULL , NULL , NULL , NULL , 1 , 1 , NULL , NULL , 1 , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , A.ATTRIBUTE_CATEGORY , A.ATTRIBUTE1 , A.ATTRIBUTE2 , A.ATTRIBUTE3 , A.ATTRIBUTE4 , A.ATTRIBUTE5 , A.ATTRIBUTE6 , A.ATTRIBUTE7 , A.ATTRIBUTE8 , A.ATTRIBUTE9 , A.ATTRIBUTE10 , A.ATTRIBUTE11 , A.ATTRIBUTE12 , A.ATTRIBUTE13 , A.ATTRIBUTE14 , A.ATTRIBUTE15 , NULL , NULL , NULL , NULL , NULL , NULL , NULL , :B1 FROM MTL_RESERVATIONS A WHERE A.RESERVATION_ID = :B1
6mu4cfrayu648	SELECT 'x' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT
6ujg2sv6yp0w9	SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , BASE.DATE_RECEIVED ORDER_BY_STRING FROM WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , X.STATUS_ID STATUS_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCRESERVABLE LOCRESERVABLE , X.LOTRESERVABLE LOTRESERVABLE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , NVL(X.RESERVABLE_TYPE, 1) LOCRESERVABLE , NVL(LOT.RESERV ABLE_TYPE, 1) LOTRESERVABLE , X.LOCATOR_ID , X.COST_GROUP_ID , X.STATUS_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MOQ.STATUS_ID , MILS.RESERVABLE_TYPE , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.STATUS_ID, MILS.RESERVABLE_TYPE, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.OR GANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_ID (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND ((EXISTS (SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B2 AND DEFAULT_STATUS_ID IS NOT NULL ) AND EXISTS(SELECT 1 FROM MTL_MATERIAL_STATUSES WHERE STATUS_ID = BASE.STATUS_ID AND RESERVABLE_TYPE = 1)) OR ((NOT EXISTS(SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B2 AND DEFAULT_STATUS_ID IS NOT NULL) OR BASE.STATUS_ID IS NULL) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1)) AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , BASE.DATE_RECEIVED, BASE.SERIAL_NUMBER, BASE.CONVERSION_RATE , BASE.DATE_RECEIVED ORDER BY BASE.DATE_RECEIVED DESC , BASE.SERIAL_NUMBER ASC, BASE.CONVERSION_RATE DESC
6uwctg1cdb25v	SELECT DG.DELIVERY_LEG_ID LEG_ID, ST1.STOP_LOCATION_ID PICKUP, ST2.STOP_LOCATION_ID DROPOFF FROM WSH_DELIVERY_LEGS DG, WSH_TRIP_STOPS ST1, WSH_TRIP_STOPS ST2 WHERE DG.DELIVERY_ID = :B2 AND ST1.STOP_ID = DG.PICK_UP_STOP_ID AND ST2.STOP_ID = DG.DROP_OFF_STOP_ID AND ST1.STOP_LOCATION_ID = :B1
6y2m7nrx0s6tn	BEGIN DECLARE l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ; BEGIN l_msg_header.message_id := :message_id ; l_msg_header.message_code := :message_code ; l_msg_header.reference_id := :reference_id ; l_msg_header.opp_reference_id := :opp_ref_id ; l_msg_header.creation_date := :creation_date; l_msg_header.sender_name := :sender_name ; l_msg_header.recipient_name := :recipient_name ; l_msg_header.version := :version; l_msg_header.direction_indr := :direction_indr ; l_msg_header.order_id := :order_id ; l_msg_header.wi_instance_id := :wi_instance_id ; l_msg_header.fa_instance_id := :fa_instance_id ; XNP_CSISUBTR_U.DEFAULT_PROCESS( l_msg_header, :l_msg_body, :error_code, :error_message ) ; END ; END ;
76fxg7ksm1rzw	SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_KEY = TO_CHAR(:B1 ) AND ITEM_TYPE = 'OEOL' AND NAME = 'APPLICATION_ID'
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
79yusvgdbx8tv	SELECT ACTIVE_START_DATE, ACTIVE_END_DATE FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID = :B1 AND ((ACTIVE_END_DATE IS NULL) OR (TO_DATE(ACTIVE_END_DATE, 'DD-MM-YY HH24:MI') >= TO_DATE(SYSDATE, 'DD-MM-YY HH24:MI')))
7bdg2fscmus2h	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 , GLOB AL_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 , LAT EST_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 , SCHED ULE_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_ATTRI BUTE8 , 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 FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7nmx77x4y3b0v	SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_KEY = TO_CHAR(:B1 ) AND ITEM_TYPE = 'OEOL' AND NAME = 'USER_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
7qs7fx89194u1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
82vq9qjhzt908	begin JTM_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE(:1, :2, :3, :4, :5, :6, :7, :8); exception when others then begin JTM_MESSAGE_LOG_PKG.log_msg( 'UPDATE_ITEM_INSTANCE_PRE', 'CSI_ITEM_INSTANCE_VUHK', 'Error:' || SQLERRM , 1, 'JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE'); exception when others then null; end; end;
8zfgv4ck11dw9	BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9d8w3myb2h8bs	SELECT TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_RATE_CODE, TAX_RATE_ID, EFFECTIVE_FROM, EFFECTIVE_TO, RATE_TYPE_CODE, PERCENTAGE_RATE, QUANTITY_RATE, ALLOW_ADHOC_TAX_RATE_FLAG, UOM_CODE, TAX_JURISDICTION_CODE, OFFSET_TAX, OFFSET_STATUS_CODE, OFFSET_TAX_RATE_CODE, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG, NULL TAX_JURISDICTION_ID, DEF_REC_SETTLEMENT_OPTION_CODE, TAXABLE_BASIS_FORMULA_CODE, ADJ_FOR_ADHOC_AMT_CODE, INCLUSIVE_TAX_FLAG, TAX_CLASS FROM ZX_SCO_RATES_B_V WHERE TAX_REGIME_CODE = :B7 AND TAX = :B6 AND TAX_STATUS_CODE = :B5 AND ACTIVE_FLAG = 'Y' AND (TAX_JURISDICTION_CODE = :B4 ) AND TAX_RATE_CODE = :B3 AND (TAX_CLASS = :B2 OR TAX_CLASS IS NULL) AND ( :B1 >= EFFECTIVE_FROM AND (:B1 <= EFFECTIVE_TO OR EFFECTIVE_TO IS NULL)) ORDER BY TAX_CLASS NULLS LAST, SUBSCRIPTION_LEVEL_CODE
a40f9h91scg23	select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
amu2ypf9rvs3s	begin CSM_WF_PKG.CSI_Item_Instance_Pre_Upd(:1, :2, :3, :4, :5, :6, :7, :8); exception when others then null; end;
aryj7kcf4zqnk	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_1 2 , 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 , MERGE_INDEX) AE_LINE_NUM FROM XLA_AE_LINES_GT WHERE TEMP_LINE_NUM <> 0
assndb4wqnd6r	BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
aw21gc59tbcnr	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_QUANT ITY - 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 , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , 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 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) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID, 3, MMTT.TRAN SFER_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) , 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, 28, 3) 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.INVENT ORY_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
bf7uwg5pa3pj6	begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bsuw7pmwrufpy	SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
by0sg8ccaazuk	UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B44 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B42 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B40 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B41 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B38 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B39 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B37 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B36 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B34 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B35 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B33 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B31 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B30 , NULL)), AVAILABLE_QUANTITY = DECO DE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B27 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B25 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B26 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B23 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B24 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , DECODE(ERROR_CODE, NULL, DECODE(:B22 , 150, 0, 61, 0, 0, 0, :B51 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B20 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B18 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B19 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B17 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_A VAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B8 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B50 , 4, :B7 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :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 = :B49 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B48 AND NVL(:B47 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B45 , -1)) = NVL(:B46 , -1)
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
cmkq326a9wqb7	select count(*), o.type#, bitand(p.flags, 2) from sys.opqtype$ p, sys.obj$ o, sys.user$ u where o.obj# = p.obj# and p.type = 1 and (o.type# = 2 or o.type# = 4) and o.owner# = u.user# and u.name not in ('XDB', 'SYS', 'MDSYS', 'EXFSYS', 'ORDSYS', 'ORDDATA', 'OE', 'SH', 'HR', 'SCOTT' ) and u.name not like 'APEX_%' group by (bitand(p.flags, 2), o.type#)
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cw171rvngr1w9	begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
dcvv68fju01g4	begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
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
f0nmqbt7w3ta1	select instance_id, instance_number, external_reference, inventory_item_id , inventory_revision , inv_master_organization_id, serial_number , mfg_serial_number_flag, lot_number, quantity, unit_of_measure , accounting_class_code, instance_condition_id, instance_status_id, customer_view_flag, merchant_view_flag, sellable_flag, system_id, instance_type_code , active_start_date, active_end_date, location_type_code , location_id, inv_organization_id, inv_subinventory_name, inv_locator_id, pa_project_id, pa_project_task_id, in_transit_order_line_id, wip_job_id, po_order_line_id , last_oe_order_line_id, last_oe_rma_line_id , last_po_po_line_id, last_oe_po_number, last_wip_job_id, last_pa_project_id, last_pa_task_id, last_oe_agreement_id, install_date, manually_created_flag, return_by_date, actual_return_date, creation_complete_flag, completeness_flag, context, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, object_version_number, last_txn_line_detail_id, install_location_type_code, install_location_id, instance_usage_code, last_vld_organization_id, config_inst_hdr_id, config_inst_rev_num, config_inst_item_id, config_valid_status, instance_description, network_asset_flag, maintainable_flag, pn_location_id, asset_criticality_code, category_id, equipment_gen_object _id, instantiation_flag, linear_location_id, operational_log_flag, checkin_status, supplier_warranty_exp_date, attribute16, attribute17, attribute18, attribute19, attribute20, attribute21, attribute22, attribute23, attribute24, attribute25, attribute26, attribute27, attribute28, attribute29, attribute30, purchase_unit_price, purchase_currency_code, payables_unit_price, payables_currency_code, sales_unit_price, sales_currency_code, operational_status_code from csi_item_instances where instance_id = :l_inst_id
fgygwdc00v0wz	SELECT WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN, WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS, WA.FUNCTION, WA.FUNCTION_TYPE, WA.MESSAGE, WA.BEGIN_DATE, WA.END_DATE, WA.DIRECTION, WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION, WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID, WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT FROM WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA WHERE WPA.INSTANCE_ID = :B2 AND WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE AND WA.NAME = WPA.ACTIVITY_NAME AND :B1 >= WA.BEGIN_DATE AND :B1 < NVL(WA.END_DATE, :B1 +1)
fh2txhqv5a2bv	INSERT INTO MTL_TRANSACTIONS_INTERFACE ( SOURCE_CODE, SOURCE_HEADER_ID, SOURCE_LINE_ID, INVENTORY_ITEM_ID, SUBINVENTORY_CODE, TRANSACTION_QUANTITY, TRANSACTION_DATE, ORGANIZATION_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_TYPE_ID, DISTRIBUTION_ACCOUNT_ID, TRANSACTION_REFERENCE, TRANSACTION_HEADER_ID, TRX_SOURCE_LINE_ID, TRX_SOURCE_DELIVERY_ID, REVISION, LOCATOR_ID, PICKING_LINE_ID, TRANSFER_SUBINVENTORY, TRANSFER_ORGANIZATION, SHIP_TO_LOCATION_ID, REQUISITION_LINE_ID, REQUISITION_DISTRIBUTION_ID, TRANSACTION_UOM, TRANSACTION_INTERFACE_ID, SHIPMENT_NUMBER, EXPECTED_ARRIVAL_DATE, ENCUMBRANCE_ACCOUNT, ENCUMBRANCE_AMOUNT, MOVEMENT_ID, FREIGHT_CODE, WAYBILL_AIRBILL, CONTENT_LPN_ID, PROCESS_FLAG, TRANSACTION_MODE, SECONDARY_TRANSACTION_QUANTITY, SECONDARY_UOM_CODE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY ) VALUES ( :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 , :B31 , :B32 , :B33 , :B34 , :B35 , '1', '3', :B36 , :B37 , SYSDATE, :B38 , SYSDATE, :B38 )
g2qs4xk48vcwy	select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
g7gy8auwm38xy	SELECT a.INSTANCE_ID from csi_item_instances a where a.inventory_item_id = :INVENTORY_ITEM_ID AND a.inventory_revision IS NULL AND a.serial_number IS NULL AND a.location_type_code = :location_type_code AND a.inv_organization_id = :inv_organization_id AND a.inv_subinventory_name = :inv_subinventory_name AND a.inv_locator_id IS NULL AND a.instance_usage_code = :instance_usage_code AND ( a.active_end_date IS NULL OR a.active_end_date > SYSDATE)
gash0u2q9atsp	INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUST_TRX_LINE_GL_DIST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, SET_OF_BOOKS_ID, REQUEST_ID, CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, CUST_TRX_LINE_SALESREP_ID, PERCENT, AMOUNT, ACCTD_AMOUNT, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, CONCATENATED_SEGMENTS, CODE_COMBINATION_ID, GL_DATE, ORIGINAL_GL_DATE, USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE_CONTEXT, POSTING_CONTROL_ID, LATEST_REC_FLAG, COLLECTED_TAX_CONCAT_SEG, COLLECTED_TAX_CCID, REC_OFFSET_FLAG , ORG_ID ) VALUES ( RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, :B33 , SYSDATE, :B33 , SYSDATE, :B32 , :B31 , :B1 , :B2 , :B3 , ROUND(NVL(:B4 , 0), 4), DECODE(:B5 , 'Y', NULL, :B6 ), DECODE(:B7 , 'Y', NULL, :B8 ), :B9 , :B10 , DECODE(:B11 , '', DECODE(:B12 , -1, :B13 , NULL ), -1, :B14 , NULL), DECODE(:B15 , '', :B16 , :B17 ), TO_DATE(:B18 , 'J'), TO_DATE(:B19 , 'J'), :B20 , :B21 , -3, DECODE( :B22 , 'REC', 'Y', NULL), DECODE(:B23 , '', NULL, DECODE(:B24 , -1, :B25 , NULL)), DECODE(:B26 , '', NULL, :B27 ), DECODE(:B28 , 'Y', NULL, DECODE(:B29 , 'UNEARN', 'Y', NULL)) , :B30 ) RETURNING CUST_TRX_LINE_GL_DIST_ID INTO :O0
gk8x2shgj6xwp	SELECT WDD.DELIVERY_DETAIL_ID FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_ASSIGNMENTS_V WDA, WSH_DELIVERY_DETAILS WDD WHERE WDD.INV_INTERFACED_FLAG IN ('N', 'P') AND WTS.BATCH_ID = :B1 AND WTS.STOP_LOCATION_ID = WDD.SHIP_FROM_LOCATION_ID AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND WDL.DELIVERY_ID = WDA.DELIVERY_ID AND WDA.DELIVERY_ID IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.SOURCE_CODE IN ('OE', 'OKE', 'WSH') AND WDD.RELEASED_STATUS <> 'D' AND NVL(WDD.LINE_DIRECTION , 'O') IN ('O', 'IO') AND ROWNUM = 1
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 )
gxx5fj67t61nb	SELECT CSI_II_FORWARD_SYNC_TEMP_S.CURRVAL FROM DUAL
gzz7aqa9bvu9g	INSERT INTO OE_PROCESSING_MSGS ( REQUEST_ID , ENTITY_CODE , ENTITY_REF , ENTITY_ID , HEADER_ID , LINE_ID , ORDER_SOURCE_ID , ORIGINAL_SYS_DOCUMENT_REF , ORIGINAL_SYS_DOCUMENT_LINE_REF , ORIG_SYS_SHIPMENT_REF , CHANGE_SEQUENCE , SOURCE_DOCUMENT_TYPE_ID , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , ATTRIBUTE_CODE , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROCESS_ACTIVITY , NOTIFICATION_FLAG , TYPE , MESSAGE_SOURCE_CODE , LANGUAGE , MESSAGE_TEXT, TRANSACTION_ID ) SELECT REQUEST_ID , 'LINE', NULL, NULL, NULL, NULL , ORDER_SOURCE_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , CHANGE_SEQUENCE, NULL, NULL, NULL, 'ORDERED_QUANTITY_UOM2' , SYSDATE , FND_GLOBAL.USER_ID , SYSDATE , FND_GLOBAL.USER_ID , FND_GLOBAL.CONC_LOGIN_ID , 660, NULL, NULL, NULL, NULL, NULL , 'C' , USERENV('LANG') , :B1 , OE_MSG_ID_S.NEXTVAL FROM OE_LINES_IFACE_ALL B WHERE (ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF) IN ( SELECT ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF FROM OE_HEADERS_IFACE_ALL WHERE BATCH_ID = :B2 ) AND ( B.ORDERED_QUANTITY_UOM2 IS NULL) AND EXISTS ( SELECT TRACKING_QUANTITY_IND FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = B.SHIP_FROM_ORG_ID AND INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ( TRACKING_QUANTITY_IND = 'PS' OR ONT_PRICING_QTY_SOURCE = 'S') )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc