WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
EBS1225	2783254286	ebs1225	1	13-Sep-16 15:09	11.2.0.4.0	NO

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

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	163	13-Sep-16 20:00:20	699	4.2
End Snap:	165	13-Sep-16 21:59:48	700	3.9
Elapsed:		119.48 (mins)
DB Time:		2,086.69 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	17.5	0.1	0.00	0.12
DB CPU(s):	5.6	0.0	0.00	0.04
Redo size (bytes):	8,430,157.3	36,401.9
Logical read (blocks):	863,537.9	3,728.8
Block changes:	57,560.1	248.6
Physical read (blocks):	316.6	1.4
Physical write (blocks):	1,405.6	6.1
Read IO requests:	137.0	0.6
Write IO requests:	773.0	3.3
Read IO (MB):	2.5	0.0
Write IO (MB):	11.0	0.1
User calls:	142.4	0.6
Parses (SQL):	1,337.7	5.8
Hard parses (SQL):	0.2	0.0
SQL Work Area (MB):	55.7	0.2
Logons:	0.9	0.0
Executes (SQL):	129,611.7	559.7
Rollbacks:	1.7	0.0
Transactions:	231.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.95	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.82	Soft Parse %:	99.99
Execute to Parse %:	98.97	Latch Hit %:	99.76
Parse CPU to Parse Elapsd %:	29.99	% Non-Parse CPU:	99.74

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

Host CPU

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
8	8	1	30.46	0.28	61.9	9.8	1.3	28.2

Instance CPU

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

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,107.4	139.5	967.9
Database Requests:	910.0	137.0	773.0
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	192.6	0.0	192.6
Total (MB):	21.9	2.5	19.4
Database (MB):	13.5	2.5	11.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	8.4	0.0	8.4
Database (blocks):	1,722.2	316.6	1,405.6
Via Buffer Cache (blocks):	1,401.2	142.1	1,259.1
Direct (blocks):	321.0	174.5	146.5

Memory Statistics

	Begin	End
Host Mem (MB):	29,902.6	29,902.6
SGA use (MB):	10,240.0	10,240.0
PGA use (MB):	2,512.2	2,047.5
% Host Mem used for SGA+PGA:	42.65	41.09

Cache Sizes

	Begin	End
Buffer Cache:	8,160M	8,160M	Std Block Size:	8K
Shared Pool Size:	1,513M	1,508M	Log Buffer:	16,504K

Shared Pool Statistics

	Begin	End
Memory Usage %:	65.31	66.66
% SQL with executions>1:	93.37	92.69
% Memory for SQL w/exec>1:	91.46	91.60

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): 125201.1s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 52.3% of Total DB time 125,201.13 (s)
• Total FG Wait Time: 25,505.24 (s) DB CPU time: 39,954.45 (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 32.9% of Total DB Time (s): 125,201
• Captured PL/SQL account for 118.1% of Total DB Time (s): 125,201

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

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 59.8% of Total User I/O Wait Time (s): 4,101
• Captured PL/SQL account for 87.9% of Total User I/O Wait Time (s): 4,101

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: 6,190,313,784
• Captured SQL account for 48.1% 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: 2,269,779
• Captured SQL account for 13.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 982,161
• Captured SQL account for 26.2% of Total
• Total UnOptimized Read Requests: 982,161
• Captured SQL account for 26.2% 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: 929,127,548
• Captured SQL account for 82.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 9,589,399
• Captured SQL account for 55.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0074pdmwb7fmv	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0423ayw04f496	SELECT FND_PROFILE.VALUE('XLA_MERGE_MATCHING_LINES') FROM DUAL
0758ng3cbw07m	SELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE NOWAIT
0bj4c9wdx63t2	SELECT HSECS FROM V$TIMER
0cnpxtkxfcv9j	SELECT DEFAULT_COST_GROUP_ID FROM MTL_SECONDARY_INVENTORIES WHERE SECONDARY_INVENTORY_NAME = :B2 AND ORGANIZATION_ID = :B1 AND DEFAULT_COST_GROUP_ID IS NOT NULL
0gw430hg7pn9p	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 , L . MANDATE_LAST_TRX_FLAG , 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 . PAYMENT_CHANNEL_CODE AND SU . SITE_USE_CODE = 'BILL_TO' AND SU . CUST_ACCT_SITE_ID = L . ORIG_SYSTEM_BILL_ADDRESS_ID
0mcwzxa8uk2n4	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_VALUES_APPL_V WHERE PROFILE_OPTION_ID = :B3 AND APPLICATION_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
0mdnts20d60yr	declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0puu35brrk8z4	SELECT * FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = :B2 AND INVENTORY_ITEM_ID = :B1
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 ;
10m257vjxv4w3	INSERT /*+ NO_DST_UPGRADE_INSERT_CONV IDX(0) */ INTO "INV"."MLOG$_MTL_RESERVATIONS" (dmltype$$, old_new$$, snaptime$$, change_vector$$, m_row$$) VALUES (:d, :o, to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'), :c, :m)
126qbd5cn7adz	SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B8 , -9999, NULL, :B8 ) 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 MTL_LOT_NUMBERS MLNA , 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.RESERVABLE_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(NV L(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 , NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED) , 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) HAVING SUM(MOQ.PRIMARY_T RANSACTION_QUANTITY) > 0 ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.ORGANIZATION_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(:B12 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B12 , '-9999', 'a', :B12 ) AND DECODE(:B12 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B11 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B11 , -9999, 1, :B11 ) AND DECODE(:B10 , '-99', 'a', BASE.REVISION) = DECODE(:B10 , '-99', 'a', :B10 ) AND DECODE(:B9 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B9 , '-9999', 'a', :B9 ) AND DECODE(:B8 , -9999, 1, BASE.LPN_ID) = DECODE(:B8 , -9999, 1, :B8 ) AND DECODE(:B7 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B6 AND WMS_RULE_PVT.MATCH_PLANNING_GROUP(BASE.ORGANIZATION_ID, BASE.LOCATOR_ID, :B3 , MPTDTV.PROJECT_ID, MPTDTV.TASK_ID, :B5 , :B1 , BASE.PROJECT_ID, BASE.TASK_ID) = 1 AND MLNA.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLNA.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLNA.LOT_NUMBER (+) = BASE.LOT_NUMBER AND ( MLNA.EXPIRATION_DATE IS NULL OR MLNA.EXPIRATION_DATE > SYSDATE OR :B4 = 'Y' ) 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 DECODE(BASE.PROJECT_ID, :B3 , 1, NULL, 2, 3) ASC, BASE.DATE_RECEIVED DESC , BASE.SERIAL_NUMBER ASC, BASE.CONVERSION_RATE DESC
1c0b7sas42w2z	SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1gpdqku7dc104	SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL FROM DUAL
1h2p0m6c0h40f	SELECT TYPE FROM RA_RULES WHERE RULE_ID = :B1
1v818hwxjxy58	select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
2amkqgr5gg7zs	SELECT 'Y' FROM ZX_JURISDICTIONS_GT WHERE TAX_REGIME_CODE = :B2 AND TAX = :B1 AND ROWNUM = 1
2t8587ka68jt8	INSERT ALL WHEN (ZX_LOCATION_MISSING = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LOCATION_MISSING', :B30 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_CLASS_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_CLASS_INVALID', :B29 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_TRX_LINE_TYPE_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID , ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_LINE_TYPE_INVALID', :B28 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_AMT_INCL_TAX_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_AMT_INCTAX_INVALID', :B27 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_ NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_NOT_EXIST', :B26 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_NOT_EFFECTIVE', :B25 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE _LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_COUNTRY_INCON', :B24 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_FC_CODE_NOT_EXIST', :B23 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID , ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_FC_CODE_NOT_EFFECT', :B22 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_COUNTRY_INCONSIS', :B21 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (DOC_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_ DOC_FC_CODE_NOT_EFFECTIVE', :B20 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_CODE_NOT_EXIST', :B19 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_CODE_NOT_EFFECT', :B18 , TRX_LEVEL_TYPE, INTERFACE_LI NE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_COUNTRY_INCONSIS', :B17 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_CODE_NOT_EXIST', :B16 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_NOT_EFF ECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_NOT_EFFECTIVE', :B15 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_CONTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_COUNTRY_INCON', :B14 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_TYPE_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_CODE_NOT_EXIST', :B13 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_TYPE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_NOT_EFFECTIVE', :B12 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_T AX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_FC_CODE_NOT_EXIST', :B11 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_CTRL_AMT_NOT_NULL = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_CTRL_AMT_NOT_NULL', :B10 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_EXEMPTION_CTRL_FLAG_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERF ACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_EXEMPTION_CTRL_FLAG_INVALID', :B9 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_PRODUCT_TYPE_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_INVALID', :B8 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_LINES = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EV ENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_LINES', :B7 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_LINE_TAX_AMT = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_LINE_TAX_AMT', :B6 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_FOR_ALLOC_FLG = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_FOR_ALLOC_FLG', :B5 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_ONLY_TAX_LINES = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_ONLY_TAX_LINES', :B4 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_EXIST', :B3 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (NVL(TAX_R ATE_NOT_EXISTS, 'N') <> 'Y' AND TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_EFFECTIVE', :B2 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (NVL(TAX_RATE_NOT_EXISTS, 'N') <> 'Y' AND TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_ACTIVE', :B1 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) SEL ECT HEADER.APPLICATION_ID, HEADER.ENTITY_CODE, HEADER.EVENT_CLASS_CODE, HEADER.TRX_ID, LINES_GT.TRX_LINE_ID, LINES_GT.TRX_LINE_ID INTERFACE_LINE_ID , LINES_GT.ENTITY_CODE INTERFACE_LINE_ENTITY_CODE, LINES_GT.TRX_LEVEL_TYPE, CASE WHEN (LINES_GT.SHIP_FROM_LOCATION_ID IS NOT NULL OR LINES_GT.SHIP_TO_LOCATION_ID IS NOT NULL OR LINES_GT.POA_LOCATION_ID IS NOT NULL OR LINES_GT.POO_LOCATION_ID IS NOT NULL OR LINES_GT.PAYING_LOCATION_ID IS NOT NULL OR LINES_GT.OWN_HQ_LOCATION_ID IS NOT NULL OR LINES_GT.TRADING_HQ_LOCATION_ID IS NOT NULL OR LINES_GT.POC_LOCATION_ID IS NOT NULL OR LINES_GT.POI_LOCATION_ID IS NOT NULL OR LINES_GT.POD_LOCATION_ID IS NOT NULL OR LINES_GT.BILL_TO_LOCATION_ID IS NOT NULL OR LINES_GT.BILL_FROM_LOCATION_ID IS NOT NULL OR LINES_GT.TITLE_TRANSFER_LOCATION_ID IS NOT NULL) THEN NULL ELSE 'Y' END ZX_LOCATION_MISSING, NVL2(LINES_GT.LINE_CLASS, CASE WHEN (NOT EXISTS (SELECT 1 FROM FND_LOOKUPS LKP WHERE LINES_GT.LINE_CLASS = LKP.LOOKUP_CODE AND LKP.LOOKUP_TYPE = 'ZX_ LINE_CLASS')) THEN 'Y' ELSE NULL END, NULL ) ZX_LINE_CLASS_INVALID, CASE WHEN (LINES_GT.TRX_LINE_TYPE NOT IN('ITEM', 'FREIGHT', 'MISC', 'MISCELLANEOUS')) THEN 'Y' ELSE NULL END ZX_TRX_LINE_TYPE_INVALID, CASE WHEN (LINES_GT.LINE_AMT_INCLUDES_TAX_FLAG IS NULL OR LINES_GT.LINE_AMT_INCLUDES_TAX_FLAG NOT IN ('A', 'N', 'S')) THEN 'Y' ELSE NULL END ZX_LINE_AMT_INCL_TAX_INVALID, NVL2(LINES_GT.PRODUCT_CATEGORY, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) ) ) THEN 'Y' ELSE NULL END, NULL ) PRODUCT_CATEG_NOT_EXISTS, CASE WHEN LINES_GT.PRODUCT_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)) ) ) THEN 'Y' ELSE NULL END ELSE NULL END PRODUCT_CATEG_NOT_EFFECTIVE, CASE WHEN LINES_GT.PRODUCT_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END PRODUCT_CATEG_COUNTRY_INCONSIS, NVL2(LINES_GT.USER_DEFINED_FISC_CLASS, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_T AXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) USER_DEF_FC_CODE_NOT_EXISTS, CASE WHEN LINES_GT.USER_DEFINED_FISC_CLASS IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)) ) ) THEN 'Y' ELSE NULL END ELSE NULL END USER_DEF_FC_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.USER_DEFINED_FISC_CLASS IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V W HERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END USER_DEF_COUNTRY_INCONSIS, CASE WHEN HEADER.DOCUMENT_SUB_TYPE IS NOT NULL AND FC_DOC.CLASSIFICATION_CODE IS NOT NULL THEN CASE WHEN (FC_DOC.COUNTRY_CODE IS NULL OR FC_DOC.COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) THEN CASE WHEN ( LINES_GT.TAX_DATE NOT BETWEEN FC_DOC.EFFECTIVE_FROM AND NVL(FC_DOC.EFFECTIVE_TO, LINES_GT.TAX_DATE) AND (NOT EXISTS (SELECT 1 FROM ZX_TRANSACTION_LINES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID < LINES_GT.TRX_LINE_ID AND TRX_LEVEL_TYPE = LINES_GT.TRX_LEVEL_TYPE ) ) ) THEN 'Y' ELSE NULL END ELSE NULL END ELSE NULL END DOC_FC_CODE_NOT_EFFECTIVE, NVL2(LINES_GT.TRX_BUSINESS_CATEGORY, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CA TEGORIES_V WHERE CLASSIFICATION_CODE = DECODE(LINES_GT.SOURCE_APPLICATION_ID, NULL, LINES_GT.TRX_BUSINESS_CATEGORY, DECODE(LINES_GT.SOURCE_EVENT_CLASS_CODE, 'INTERCOMPANY_TRX', REPLACE(LINES_GT.TRX_BUSINESS_CATEGORY, 'SALES_TRANSACTION', 'PURCHASE_TRANSACTION'), LINES_GT.TRX_BUSINESS_CATEGORY)) AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE) ) ) ) ) AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL ) TRX_BIZ_FC_CODE_NOT_EXISTS, CASE WHEN LINES_GT.TRX_BUSINESS_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = DECODE(LINES_GT.SOURCE_APPLICATION_ID, NULL, LINES_GT.TRX_BUSINESS_CATEGORY, DECODE(LINES_GT.SOURCE_EVENT_CLASS_CODE, 'INTERCOMPANY_TRX', REPLACE(LINES_GT.TRX_BUSINESS_CATEGORY, 'SALES_TRANS ACTION', 'PURCHASE_TRANSACTION'), LINES_GT.TRX_BUSINESS_CATEGORY) ) AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE)))) ) AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) ) ) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = DECODE(LINES_GT.SOURCE_APPLICATION_ID, NULL, LINES_GT.TRX_BUSINESS_CATEGORY, DECODE(LINES_GT.SOURCE_EVENT_CLASS_CODE, 'INTERCOMPANY_TRX', REPLACE(LINES_GT.TRX_BUSINESS_CATEGORY, 'SALES_TRANSACTION', 'PURCHASE_TRANSACTION'), LINES_GT.TRX_BUSINESS_CATEGORY)) AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE)))) ) AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)) ) ) THEN 'Y' ELSE NULL END ELSE NULL END TRX_BIZ_FC_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.TRX_BUSINESS_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = DECODE(LINES_GT.SOURCE_APPLICATION_ID, NULL, LINES_GT.TRX_BUSINESS_CATEGORY, DECODE(LINES_GT.SOURCE_EVENT_CLASS_CODE, 'INTERCOMPANY_TRX', REPLACE(LINES_GT.TRX_BUSINESS_CATEGORY, 'SALES_TRANSACTION', 'PURCHASE_TRANSACTION'), LINES_GT.TRX_BUSINESS_CATEGORY)) AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE)))) ) AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = DECODE(LINES_GT.SOURCE_APPLICATION_ID, NULL, LINES_GT.TRX_BUSINESS_CATEGORY, DECODE(LINES_GT.SOURCE_EVENT_CLASS_CODE, 'INTERCOMPANY_TRX', REPLACE(LINES_GT.TRX_BUSINESS_CATEGORY, 'SALES_TRANSACTION', 'PURCHASE_TRANSACTION'), LINES_GT.TRX_BUSINESS_CATEGORY)) AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE)))) ) AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) ) THEN 'Y' ELSE NULL END ELSE NULL END TRX_BIZ_FC_COUNTRY_INCONSIS, NVL2(LINES_GT.LINE_INTENDED_USE, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) ) THEN 'Y' ELSE NULL END, NULL) INTENDED_USE_CODE_NOT_EXISTS, CASE WHEN LINES_GT.LINE_INTENDED_USE IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END INTENDED_USE_NOT_EFFECTIVE, CASE WHEN LINES_GT.LINE_INTENDED_USE IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END INTENDED_USE_CONTR Y_INCONSIS, NVL2(LINES_GT.PRODUCT_TYPE, NVL(FND.LOOKUP_CODE, 'Y'), NULL ) PRODUCT_TYPE_CODE_NOT_EXISTS, CASE WHEN (FND.LOOKUP_CODE IS NOT NULL) THEN CASE WHEN ( LINES_GT.TAX_DATE BETWEEN FND.START_DATE_ACTIVE AND NVL(FND.END_DATE_ACTIVE, LINES_GT.TAX_DATE) ) THEN NULL ELSE 'Y' END ELSE NULL END PRODUCT_TYPE_NOT_EFFECTIVE, NVL2(LINES_GT.PRODUCT_FISC_CLASSIFICATION, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_FISCAL_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_FISC_CLASSIFICATION AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) PRODUCT_FC_CODE_NOT_EXISTS, CASE WHEN (LINES_GT.LINE_LEVEL_ACTION <> 'CREATE' AND LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL ) THEN 'Y' ELSE NULL END ZX_LINE_CTRL_AMT_NOT_NULL, CASE WHEN (LINES_GT.EXEMPTION_CONTROL_FLAG IS NOT NULL AND LINES_GT.EXEMPTION_CONTROL_FLAG NOT IN ('R', 'S', 'E')) THEN 'Y' ELSE NULL END ZX_EXEMPTION_CTRL_FLAG_INVALID, CASE WHEN (LINES_GT.PRODUCT_TYPE IS NOT NULL AND LINES_GT.PRODUCT_TYPE NOT IN ('GOODS', 'SERVICES')) THEN 'Y' ELSE NULL END ZX_PRODUCT_TYPE_INVALID, CASE WHEN (LINES_GT.CTRL_HDR_TX_APPL_FLAG = 'Y' AND LINES_GT.LINE_LEVEL_ACTION <> 'LINE_INFO_TAX_ONLY' AND EXISTS (SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID) ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_LINES, CASE WHEN (LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND EXISTS (SELECT 1 FROM ZX_TRX_TAX_LINK_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID AND TRX_LEVEL_TYPE = LINES_GT.TRX_LEVEL_TYPE) ) THEN 'Y' ELSE NULL END ZX_INVALID_LINE_TAX_AMT, CASE WHEN (LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND EXIS TS(SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID IS NULL AND IMPTAXES_GT.TAX_LINE_ALLOCATION_FLAG = 'N') ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_FOR_ALLOC_FLG, CASE WHEN (LINES_GT.LINE_LEVEL_ACTION = 'LINE_INFO_TAX_ONLY' AND EXISTS (SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID AND IMPTAXES_GT.TAX_LINE_ALLOCATION_FLAG <> 'Y') ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_ONLY_TAX_LINES, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZA TION_ID, -99)) THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99)) THEN CASE WHEN (LINES_GT.SOURCE_APPLICATION_ID IS NOT NULL AND LINES_GT.SOURCE_EVENT_CLASS_CODE = 'INTERCOMPANY_TRX') THEN CASE WHEN NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE UPPER(LOOKUP_CODE) = UPPER(LINES_GT.INPUT_TAX_CLASSIFICATION_CODE) AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) ) THEN 'Y' ELSE NULL END ELSE 'Y' END ELSE NULL END END TAX_RATE_NOT_EXISTS, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE) ) THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE) ) THEN CASE WHEN (LINES_GT.SOURCE_APPLICATION_ID IS NOT NULL AND LINES_GT.SOURCE_EVENT_CLASS_CODE = 'INTERCOMPANY_TRX') THEN CASE WHEN NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE UPPER(LOOKUP_CODE) = UPPER(LINES_GT.INPUT_TAX_CLASSIFICATION_CODE) AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE) ) THEN 'Y' ELSE NULL END ELSE 'Y' END ELSE NULL END END TAX_RATE_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_I D IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y') THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y') THEN CASE WHEN (LINES_GT.SOURCE_APPLICATION_ID IS NOT NULL AND LINES_GT.SOURCE_EVENT_CLASS_CODE = 'INTERCOMPANY_TRX') THEN CASE WHEN NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE UPPER(LOOKUP_CODE) = UPPER(LINES_GT.INPUT_TAX_CLASSIFICATION_CODE) AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y' ) THEN 'Y' ELSE NULL END ELSE 'Y' END ELSE NULL END END TAX_RATE_CODE_NOT_ACTIVE FROM ZX_TRX_HEADERS_GT HEADER, ZX_EVNT_CLS_MAPPINGS EVNTMAP, ZX_TRANSACTION_LINES_GT LINES_GT, ZX_FC_DOCUMENT_FISCAL_V FC_DOC, FND_LOOKUPS FND WHERE LINES_GT.TRX_ID = HEADER.TRX_ID AND LINES_GT.APPLICATION_ID = HEADER.APPLICATION_ID AND LINE S_GT.ENTITY_CODE = HEADER.ENTITY_CODE AND LINES_GT.EVENT_CLASS_CODE = HEADER.EVENT_CLASS_CODE AND FC_DOC.CLASSIFICATION_CODE(+) = HEADER.DOCUMENT_SUB_TYPE AND HEADER.APPLICATION_ID = EVNTMAP.APPLICATION_ID (+) AND HEADER.ENTITY_CODE = EVNTMAP.ENTITY_CODE (+) AND HEADER.EVENT_CLASS_CODE = EVNTMAP.EVENT_CLASS_CODE(+) AND FND.LOOKUP_TYPE(+) = 'ZX_PRODUCT_TYPE' AND FND.LOOKUP_CODE(+) = LINES_GT.PRODUCT_TYPE
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, SOURCE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, LOGICAL_TRX_TYPE_C ODE, 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))
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_retv al: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;
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_PLANNING", "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)
4u81ft6vn8k4j	SELECT ACCT_PERIOD_ID FROM ORG_ACCT_PERIODS WHERE PERIOD_CLOSE_DATE IS NULL AND ORGANIZATION_ID = :B1 AND TRUNC(SCHEDULE_CLOSE_DATE) >= INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(NVL(:B2 , SYSDATE), :B1 ) AND TRUNC(PERIOD_START_DATE) <= INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(NVL(:B2 , SYSDATE), :B1 )
4y08a52989vfk	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5087kdcmjuqjs	SELECT ITEM_TYPE_CODE, ATO_LINE_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
521y9hsruj6y2	SELECT I.TAX_CODE FROM ZX_OUTPUT_CLASSIFICATIONS_V L, MTL_SYSTEM_ITEMS I WHERE I.INVENTORY_ITEM_ID = :B4 AND I.ORGANIZATION_ID = :B3 AND L.LOOKUP_CODE = I.TAX_CODE AND L.ORG_ID IN (:B2 , -99) AND L.ENABLED_FLAG = 'Y' AND (L.START_DATE_ACTIVE <= :B1 OR L.START_DATE_ACTIVE IS NULL) AND (L.END_DATE_ACTIVE >= :B1 OR L.END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY L.ORG_ID DESC
5b6q12n5gr1d3	SELECT USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE ROWID = :B1
5dsv99085tx1k	SELECT /*+ leading(ct) index(ct, RA_CUSTOMER_TRX_N15) index(ctl, RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ct.customer_trx_id, /* customer_trx_id */ ctl.customer_trx_line_id, /* customer_trx_line_id */ to_number(''), /* cust_trx_line_salesrep_id */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, nvl(ctl.revenue_amount, ctl.extended_amount), to_number('')), /* line_amount */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NUL L, decode(to_number(''), NULL, round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)), 2), round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)) / to_number('')) * to_number('') ), to_number('')), /* accounted_line_amount */ round( 100, 4), /* percent */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, nvl(ctl.revenue_amount, ctl.extended_amount), to_number('') ), /* amount */ decode( DECODE(1, 1, NULL) , NULL, decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.aut orule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode( to_number(''), NULL, round ((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)), 2), round((nvl(ctl.revenue_amount, ctl.extended_amount) * nvl(ct.exchange_rate, 1)) / to_number('') ) * to_number('') ), to_number('')), DECODE(1, 1, NULL)), /* acctd_amt */ 'TAX', /* account class */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('TAX', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, 'N', 'Y' ), /* account_set_flag */ ct.cust_trx_type_id, /* cust_trx_type_id */ decode(ct.invoicing_rule_id, -3, 'Y', 'N'), /* allow_not_open_flag */ to_char(''), /* concatenated segments */ :code_combination_id , /* code_combinatio n_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_d uration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(nvl(rgd.original_gl_date, :original_gl_date), 'J'), '' ) ), /* orig_gl_date */ nvl(ctl.default_ussgl_transaction_code, ct.default_ussgl_transaction_code), /* ussgl_trx_code */ nvl(ctl.default_ussgl_trx_code_context, ct.default_ussgl_trx_code_context), /* ussgl_trx_code_cntxt*/ ct.primary_salesrep_id, /* salesrep_id */ ctl_line.inventory_item_id, /* inventory_item_id */ ctl_line.memo_line_id, /* memo_line_id */ arp_etax_util.get_tax_account(ctl.customer_trx_line_id, rgd.gl_date, 'TAX'), arp_etax_util.get_tax_account(ctl.customer_trx_line_id, rgd.gl_date, 'INTERIM'), ct.bill_to_site_use_id, /* Billing site id */ ctl_line.warehouse_id /* Warehouse id */ , ctl.link_to_cust_trx_line_id /* 1651593 - tax errors */, ct.rev_rec_application /* Bug 16240687 changes for EBS-VRM Integration */, -999 FROM ra_customer_trx_lines ctl_lin e, 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.reques t_id is not null ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
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;
608c0n36kaw62	begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
6abn0zw8kkvtk	begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; END ;
6f8nnh3kc2syp	SELECT PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID = :B1
6gqwu2btky0za	SELECT DECODE(:B2 , 'USER', USER_ENABLED_FLAG, 'RESP', RESP_ENABLED_FLAG, 'APPL', APP_ENABLED_FLAG, 'SERVER', SERVER_ENABLED_FLAG, 'ORG', ORG_ENABLED_FLAG, 'SERVRESP', SERVERRESP_ENABLED_FLAG, 'SITE', SITE_ENABLED_FLAG) FROM FND_PROFILE_OPTIONS WHERE ROWID = :B1
6ptvgszqrzy4s	begin :1 := inv_material_status_grp.is_status_applicable(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); end;
6xzrrmb9f81x7	SELECT HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE ROWID = :B1
6zjvd8d8r4fyf	INSERT /*+ NO_DST_UPGRADE_INSERT_CONV IDX(0) */ INTO "INV"."MLOG$_MTL_MATERIAL_TRANSAC" (dmltype$$, old_new$$, snaptime$$, change_vector$$, m_row$$) VALUES (:d, :o, to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'), :c, :m)
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
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;
7qwsx7rw0s3a5	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_VALUES_USER_V WHERE PROFILE_OPTION_ID = :B3 AND APPLICATION_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
7rphn7dmkxya2	INSERT /*+ NO_DST_UPGRADE_INSERT_CONV IDX(0) */ INTO "ONT"."MLOG$_OE_ORDER_LINES_ALL" (dmltype$$, old_new$$, snaptime$$, change_vector$$, m_row$$) VALUES (:d, :o, to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'), :c, :m)
8xst6001v8drw	SELECT 'Y' FROM ONT_DBI_CHANGE_LOG WHERE HEADER_ID=:B2 AND LINE_ID = :B1 AND SET_OF_BOOKS_ID = :B4 AND CURRENCY_CODE = :B3 FOR UPDATE
8zfgv4ck11dw9	BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
90znmngwuvu4w	SELECT PROFILE_OPTION_ID FROM FND_PROFILE_OPTIONS WHERE ROWID = :B1
9173mvrnzb898	SELECT DEFAULT_COST_GROUP_ID, PRIMARY_COST_METHOD FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B1
96cgwbvtkygk5	BEGIN :1 := XLA_00222_AAD_S_000009_PKG.CreateJournalEntries(:2, :3, :4, :5, :6 ); 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
9k7gd9pn661pj	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_VALUES_RESP_V WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
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
ampd28zxzzun6	declare l_retstat number ; l_msg_data varchar2 ( 244 ) ; BEGIN INV_ENHANCED_TM_PERF . launch_worker ( :maxrows , :applid , :progid , :userid , :reqstid , :loginid , 'SO' , l_retstat , l_msg_data ) ; IF ( l_retstat = 0 ) then :l_result := 0 ; ELSE :l_result := 1 ; END IF ; END ;
assndb4wqnd6r	BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b5ycnkqg2b0wk	SELECT MTL_DEMAND_S.NEXTVAL FROM DUAL
b9tuqaas6xbh8	SELECT ROWID FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
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
c7f2ankv7htm4	SELECT PRIMARY_RESERVATION_QUANTITY FROM MTL_RESERVATIONS WHERE RESERVATION_ID = :B1
c9n1fq4s5mpj8	select to_char(INVENTORY_ITEM_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 from MTL_SYSTEM_ITEMS_B where ORGANIZATION_ID = :FND_BIND1 and INVENTORY_ITEM_ID = :FND_BIND2
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
csrayyhmtf1jk	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 , l . mandate_last_trx_flag , 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 . payment_channel_code and su . site_use_code = 'BILL_TO' and su . cust_acct_site_id = l . orig_system_bill_address_id ; l_mandate_error VARCHAR2 ( 30 ) ; l_last_customer_trx_id NUMBER ; l_last_mandate_flag VARCHAR2 ( 1 ) ; l_mandate_error_raised BOOLEAN ; l_error_message_text VARCHAR2 ( 512 ) ; BEGIN arp_standard . debug ( 'Default Payment Transaction Extension ID()+' ) ; FOR line_rec IN lines_rec_cur LOOP IF NVL ( l_last_customer_trx_id , -99 ) <> line_rec . custo mer_trx_id THEN l_last_customer_trx_id := line_rec . customer_trx_id ; l_last_mandate_flag := line_rec . mandate_last_trx_flag ; l_mandate_error := NULL ; l_mandate_error_raised := FALSE ; END IF ; IF l_mandate_error IS NULL THEN IF NVL ( line_rec . mandate_last_trx_flag , 'N' ) = 'Y' OR NVL ( line_rec . mandate_last_trx_flag , 'N' ) = 'N' THEN IF l_last_mandate_flag <> line_rec . mandate_last_trx_flag THEN l_mandate_error := 'AR_AI_INVALID_MANDATE_FLAG' ; END IF ; ELSE l_mandate_error := 'AR_INVALID_MANDATE_FLAG' ; END IF ; END IF ; IF l_mandate_error IS NOT NULL THEN IF NOT l_mandate_error_raised THEN arp_standard . debug ( 'Raising ' || l_mandate_error || ' for trx_id ' || l_last_customer_trx_id ) ; FND_MESSAGE . SET_NAME ( 'AR' , l_mandate_error ) ; l_error_message_text := FND_MESSAGE . GET ; INSERT INTO RA_INTERFACE_ERRORS ( INTERFACE_LINE_ID , MESSAGE_TEXT , INVALID_VALUE , ORG_ID ) SELECT L . INTERFACE_LINE_ID , l_error_message_text , L . MANDATE_LAST_TRX_FLAG , L . ORG_ID FROM RA_INTERFACE_LINES_GT L WHERE L . CUSTOMER_TRX_ID = l_last_customer_trx_id AND NVL ( L . INTERFACE_STATUS , '~' ) != 'P' AND L . LINE_TYPE IN ( 'LINE' , 'CHARGES' ) ; l_mandate_error_raised := TRUE ; END IF ; goto continue_loop ; END IF ; 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 IF :h_pmt_det_def_hierarchy = 'PARENT' 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 ) ; END IF ; 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 ; IF :h_pmt_det_def_hierarchy = 'BILL_TO' AND 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_assign ment_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 ) ; END IF ; ELSIF l_instrument_type = 'BANKACCOUNT' THEN IF :h_pmt_det_def_hierarchy = 'PARENT' 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 . 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 ; 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 , line_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 ; IF :h_pmt_det_def_hierarchy = 'BILL_TO' AND 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 . 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 . 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 OR l_payment_channel = 'BILLS_RECEIVABLE' THEN 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 ; ELSE l_payment_function := 'CUSTOMER_PAYMENT' ; l_org_type := 'OPERATING_UNIT' ; l_org_id : = line_rec . org_id ; l_cust_site_use_id := line_rec . bill_to_site_use_id ; l_cust_account_id := line_rec . orig_system_bill_customer_id ; SELECT party_id INTO l_party_id FROM HZ_CUST_ACCOUNTS WHERE cust_account_id = line_rec . orig_system_bill_customer_id ; END IF ; 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 ; l_trxn_attribs_rec . seq_type_last := line_rec . mandate_last_trx_flag ; 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 ; << continue_loop >> arp_standard . debug ( 'End of loop' ) ; END LOOP ; arp_standard . debug ( 'Default Payment Transaction Extension ID()-' ) ; EXCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in Default Payment Transaction Extension ID' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ;
ctdcj8mghk5c9	SELECT APPLICATION_ID FROM FND_PROFILE_OPTIONS WHERE ROWID = :B1
cw171rvngr1w9	begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
d0asq32jsy1qa	SELECT L.CUSTOMER_TRX_LINE_ID, G.ACCOUNT_CLASS, (DECODE(G.REC_OFFSET_FLAG, 'Y', L.REVENUE_AMOUNT, DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(T.INVOICING_RULE_ID, -2, 0, L.REVENUE_AMOUNT), L.REVENUE_AMOUNT)) - (SUM(G.AMOUNT) * DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1)))) * DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1)) ROUND_AMT, (DECODE(G.REC_OFFSET_FLAG, 'Y', 100, DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(T.INVOICING_RULE_ID, -2, 0, 100), 100)) - (SUM(G.PERCENT) * DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1)))) * DECODE(G.ACCOUNT _CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1)) ROUND_PCT, (DECODE(:B1 , NULL, ROUND(DECODE(G.REC_OFFSET_FLAG, 'Y', L.REVENUE_AMOUNT, DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(T.INVOICING_RULE_ID, -2, 0, L.REVENUE_AMOUNT), L.REVENUE_AMOUNT)) * NVL(T.EXCHANGE_RATE, 1), :B2 ), ROUND((DECODE(G.REC_OFFSET_FLAG, 'Y', L.REVENUE_AMOUNT, DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(T.INVOICING_RULE_ID, -2, 0, L.REVENUE_AMOUNT), L.REVENUE_AMOUNT)) * NVL(T.EXCHANGE_RATE, 1)) / :B1 ) * :B1 ) - (SUM(G.ACCTD_AMOUNT) * DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1)))) * DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV '), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1)) ROUND_ACCT_AMT, G.REC_OFFSET_FLAG, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV') FROM RA_CUSTOMER_TRX_LINES L, RA_CUST_TRX_LINE_GL_DIST G, RA_CUSTOMER_TRX T, RA_RULES R WHERE T.CUSTOMER_TRX_ID = :B3 AND L.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND L.CUSTOMER_TRX_ID = G.CUSTOMER_TRX_ID AND L.CUSTOMER_TRX_LINE_ID = G.CUSTOMER_TRX_LINE_ID AND L.ACCOUNTING_RULE_ID = R.RULE_ID AND G.REVENUE_ADJUSTMENT_ID IS NULL AND L.ACCOUNTING_RULE_ID IS NOT NULL AND L.AUTORULE_COMPLETE_FLAG IS NULL AND G.ACCOUNT_CLASS IN ('REV', 'UNEARN', 'UNBILL') AND G.ACCOUNT_SET_FLAG = 'N' AND EXISTS ( SELECT 'has rof row' FROM RA_CUST_TRX_LINE_GL_DIST ROF WHERE ROF.CUSTOMER_TRX_LINE_ID = G.CUSTOMER_TRX_LINE_ID AND ROF.ACCOUNT_SET_FLAG = 'N' AND ROF.ACCOUNT_CLASS IN ('UNEARN', 'UNBILL') AND ROF.REC_OFFSET_FLAG = 'Y') HAVING (SUM(G.AMOUNT) <> DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MA NAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), L.REVENUE_AMOUNT, DECODE(G.REC_OFFSET_FLAG, 'Y', L.REVENUE_AMOUNT, L.REVENUE_AMOUNT * -1)) * DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(G.REC_OFFSET_FLAG, 'Y', 1, DECODE(T.INVOICING_RULE_ID, -2, 0, 1)), 1) OR SUM(G.PERCENT) <> DECODE(G.ACCOUNT_CLASS, DECODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 100, DECODE(G.REC_OFFSET_FLAG, 'Y', 100, -100)) * DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(G.REC_OFFSET_FLAG, 'Y', 1, DECODE(T.INVOICING_RULE_ID, -2, 0, 1)), 1) OR SUM(G.ACCTD_AMOUNT) <> DECODE(:B1 , NULL, ROUND(L.REVENUE_AMOUNT * NVL(T.EXCHANGE_RATE, 1), :B2 ), ROUND((L.REVENUE_AMOUNT * NVL(T.EXCHANGE_RATE, 1)) / :B1 ) * :B1 ) * DECODE(R.DEFERRED_REVENUE_FLAG, 'Y', DECODE(G.REC_OFFSET_FLAG, 'Y', 1, DECODE(T.INVOICING_RULE_ID, -2, 0, 1)), 1) * DECODE(G.ACCOUNT_CLASS, DE CODE (AR_REVENUE_MANAGEMENT_PVT.IS_INARREAR_TRX_CONT_LINE(L.CUSTOMER_TRX_LINE_ID, 'ROUNDING'), 'Y', 'UNEARN', 'REV'), 1, DECODE(G.REC_OFFSET_FLAG, 'Y', 1, -1))) AND MIN(G.POSTING_CONTROL_ID) = -3 GROUP BY L.CUSTOMER_TRX_LINE_ID, G.ACCOUNT_CLASS, G.REC_OFFSET_FLAG, L.REVENUE_AMOUNT, T.EXCHANGE_RATE, R.DEFERRED_REVENUE_FLAG, T.INVOICING_RULE_ID
d9ybtwvn89wct	SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
dcvv68fju01g4	begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dkgvan3nyuhhb	begin INV_SERIAL_NUMBER_PUB.is_serial_controlled ( p_inventory_item_id => :1 , p_organization_id => :2 , p_transfer_org_id => :3 , p_txn_type_id => :4 , p_txn_src_type_id => :5 , p_txn_action_id => :6 , p_serial_control => :7 , p_xfer_serial_control => :8 , x_serial_control => :9 , x_return_status => :10); end;
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)
g7duqx1duk4bd	SELECT /*+ leading(xet) cardinality(xet, 1) */ XET.ENTITY_ID , XET.LEGAL_ENTITY_ID , XET.ENTITY_CODE , XET.TRANSACTION_NUMBER , XET.EVENT_ID , XET.EVENT_CLASS_CODE , XET.EVENT_TYPE_CODE , XET.EVENT_NUMBER , XET.EVENT_DATE , XET.TRANSACTION_DATE , XET.REFERENCE_NUM_1 , XET.REFERENCE_NUM_2 , XET.REFERENCE_NUM_3 , XET.REFERENCE_NUM_4 , XET.REFERENCE_CHAR_1 , XET.REFERENCE_CHAR_2 , XET.REFERENCE_CHAR_3 , XET.REFERENCE_CHAR_4 , XET.REFERENCE_DATE_1 , XET.REFERENCE_DATE_2 , XET.REFERENCE_DATE_3 , XET.REFERENCE_DATE_4 , XET.EVENT_CREATED_BY , XET.BUDGETARY_CONTROL_FLAG , H6.JLBR_BANK_OCC_DESC SOURCE_13 , H6.JLBR_DOCUMENT_NUMBER SOURCE_14 , H6.JLBR_TRADE_NOTE_NUMBER SOURCE_15 , H1.BILL_CUST_PARTY_NAME SOURCE_17 , H1.BILL_CUST_PARTY_NUMBER SOURCE_18 , H3.RMT_BNK_ACCOUNT_NAME SOURCE_19 , H3.RMT_BNK_ACCOUNT_NUM SOURCE_20 , H3.RMT_BANK_NAME SOURCE_21 , H3.RMT_BANK_NUM SOURCE_22 , H1.BILL_CUST_ACCOUNT_ID SOURCE_62 , H2.BILL_USES_SITE_USE_ID SOURCE_63 , H4.XLA_PARTY_TYPE SOURCE_64 , H6. JLBR_OCCURRENCE_ID SOURCE_107 , H6.JLBR_EXCHG_GAIN_CCID SOURCE_134 , H6.JLBR_EXCHG_LOSS_CCID SOURCE_135 , H6.JLBR_GL_DATE SOURCE_136 , H6.JLBR_TRANSFER_TO_GL_FLAG SOURCE_137 , FVL137.MEANING SOURCE_137_MEANING FROM XLA_EVENTS_GT XET , AR_BILL_TO_CUSTOMERS_S_V H1 , AR_BILL_TO_SITE_USES_S_V H2 , AR_REMIT_BANK_ACCT_H_V H3 , AR_TRANSACTIONS_S_V H4 , JL_BR_AR_COLL_OCC_DOCS_H_V H6 , FND_LOOKUP_VALUES FVL137 WHERE XET.EVENT_DATE BETWEEN :B3 AND :B2 AND XET.EVENT_CLASS_CODE = :B1 AND XET.EVENT_STATUS_CODE <> 'N' AND H3.EVENT_ID = XET.EVENT_ID AND H1.EVENT_ID (+) = H3.EVENT_ID AND H2.EVENT_ID (+) = H3.EVENT_ID AND H4.EVENT_ID (+) = H3.EVENT_ID AND H6.EVENT_ID = H3.EVENT_ID AND FVL137.LOOKUP_TYPE(+) = 'YES_NO' AND FVL137.LOOKUP_CODE(+) = H6.JLBR_TRANSFER_TO_GL_FLAG AND FVL137.VIEW_APPLICATION_ID(+) = 0 AND FVL137.LANGUAGE(+) = USERENV('LANG') ORDER BY EVENT_ID
gb694cbt9qks7	DELETE FROM WMS_TRANSACTIONS_TEMP WHERE PP_TRANSACTION_TEMP_ID = :B1
gj84g2yx56u2q	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_VALUES_SITE_V WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc