WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	379317749	VIS	1	24-Mar-14 08:03	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbzone3	Solaris[tm] OE (64-bit)	168	21	2	1006.00

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9	24-Mar-14 15:30:19	4417	31.9
End Snap:	10	24-Mar-14 15:45:20	4412	32.0
Elapsed:		15.01 (mins)
DB Time:		329.83 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	75,520M	74,752M	Std Block Size:	8K
Shared Pool Size:	16,384M	16,384M	Log Buffer:	225,048K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	22.0	0.1	0.00	0.00
DB CPU(s):	21.5	0.1	0.00	0.00
Redo size:	7,642,556.3	40,521.6
Logical reads:	659,533.4	3,496.9
Block changes:	49,470.1	262.3
Physical reads:	4.4	0.0
Physical writes:	845.8	4.5
User calls:	8,452.2	44.8
Parses:	4,007.4	21.3
Hard parses:	0.0	0.0
W/A MB processed:	60.8	0.3
Logons:	0.1	0.0
Executes:	33,653.4	178.4
Rollbacks:	2.6	0.0
Transactions:	188.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	100.15	Soft Parse %:	100.00
Execute to Parse %:	88.09	Latch Hit %:	94.01
Parse CPU to Parse Elapsd %:	70.12	% Non-Parse CPU:	95.31

Shared Pool Statistics

	Begin	End
Memory Usage %:	36.68	36.73
% SQL with executions>1:	96.70	96.72
% Memory for SQL w/exec>1:	95.46	95.60

Top 5 Timed Foreground Events

Host CPU (CPUs: 168 Cores: 21 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
56.17	54.07	26.9	3.0	0.0	70.2

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	1,030,144.0	1,030,144.0
SGA use (MB):	131,072.0	131,072.0
PGA use (MB):	5,027.3	5,164.7
% Host Mem used for SGA+PGA:	13.21	13.23

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): 19789.8s
• 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 102.2% of Total DB time 19,789.84 (s)
• Total FG Wait Time: 846.09 (s) DB CPU time: 19,375.47 (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 24.2% of Total DB Time (s): 19,790
• Captured PL/SQL account for 2.7% of Total DB Time (s): 19,790

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 23.3% of Total CPU Time (s): 19,375
• Captured PL/SQL account for 2.7% of Total CPU Time (s): 19,375

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 7.6% of Total User I/O Wait Time (s): 2
• Captured PL/SQL account for 4.2% of Total User I/O Wait Time (s): 2

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: 594,170,345
• Captured SQL account for 51.8% 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: 3,943
• Captured SQL account for 6.5% 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: 3,943
• Captured SQL account for 4.3% of Total
• Total UnOptimized Read Requests: 3,943
• Captured SQL account for 4.3% 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: 30,318,140
• Captured SQL account for 12.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 3,610,200
• Captured SQL account for 57.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
02zf27p5upk26	SELECT /*+ NO_EXPAND ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) INDEX(QPLINES) INDEX(QPLATPR) index(QPPROD QP_PRICING_ATTRIBUTES_N5 ) index(qph QP_LIST_HEADERS_B_N7) */ QPL.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPL.LIST_LINE_TYPE_CODE, QPLATPR.LINE_INDEX, QPLATPR.VALIDATED_FLAG, QPLATPR.APPLIED_FLAG, QPLATPR.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLATPR.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLATPR.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLATPR.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLATPR.VALUE_FROM PRODUCT_ATTR_VALUE, QPPROD.PRODUCT_ATTR_VALUE PRODUCT_SETUP_VALUE, QPLATPR.PRICING_ATTR_FLAG PRODUCT_PRICING_ATTR_FLAG, QPPROD.PRODUCT_UOM_CODE PRODUCT_UOM_CODE, QPPROD.EXCLUDER_FLAG, NULL QUALIFIER_GROUPING_NO, NULL QUALIFIER_PRECEDENCE, QPL.AUTOMATIC_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.PRIMARY_UOM_FLAG, QPL.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE, QPL.OPERAND OPERAND_VALUE, QPL.NET_AMOUNT_FLAG, QPL.PRICING_GROUP_SEQUENCE, QPH.ASK_FOR_FLAG, QPH.LIST_TYPE_CODE CREATED_FROM_LIST_TYPE, QPL.PRICING_PHASE_ID, QPL.PRICE_BREAK_TYPE_CODE, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.OVERRIDE_FLAG, QPL.BENEFIT_QTY, QPL.BENEFIT_UOM_CODE, QPL.LIST_LINE_NO, QPL.ACCRUAL_FLAG, QPL.ACCRUAL_CONVERSION_RATE, QPL.ESTIM_ACCRUAL_RATE, QPH.LIMIT_EXISTS_FLAG HEADER_LIMIT_EXISTS, QPL.LIMIT_EXISTS_FLAG LINE_LIMIT_EXISTS, 'NQ' QUALIFIER_TYPE, QPL.CHARGE_TYPE_CODE, QPL.CHARGE_SUBTYPE_CODE, QPL.ACCUM_CONTEXT, QPL.ACCUM_ATTRIBUTE, QPL.ACCUM_ATTR_RUN_SRC_FLAG FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLATPR, QP_PRICING_ATTRIBUTES QPPROD , QP_LIST_HEADERS_B QPH , QP_LIST_LINES QPL , QP_PRICE_REQ_SOURCES_V QPRS WHERE (QPLINES.PRICE_FLAG = :B1 OR (QPLINES.PRICE_FLAG = :B16 AND :B15 = :B1 )) AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE) OR QPH.CURRENCY_CODE IS NULL) AND (QPLINES.UNIT_PRICE IS NOT NULL OR QPLINES.USAGE_PRICING_TYPE = :B14 OR QPLINES.LINE_TYPE_CODE = :B13 ) AND (QPL.MODIFIER_LEVEL_CODE = QPLINES.LINE_TYPE_CODE OR (QPL.MODIFIER_LEVEL_CODE = :B12 AND NVL(:B3 , :B2 ) <> :B1 )) AND QPH.ACTIVE_FLAG = :B1 AND ((QPH.ASK_FOR_FLAG = :B1 AND EXISTS (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' FROM QP_NPREQ_LINE_ATTRS_TMP LA WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B9 AND VALIDATED_FLAG = :B2 AND LIST_HEADER_ID = QPH.LIST_HEADER_ID AND LINE_INDEX = QPLINES.LINE_INDEX)) OR QPH.ASK_FOR_FLAG = :B2 ) AND QPL.LIST_LINE_ID = QPPROD.LIST_LINE_ID AND NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_FIRST_TYPE, NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X')) AND NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_SECOND_TYPE, NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X')) AND NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE)) BETWEEN NVL(QPL.START_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPL.END_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND QPLINES.PRICED_UOM_CODE = NVL(QPPROD.PRODUCT_UOM_CODE, QPLINES.PRICED_UOM_CODE) AND QPPROD.PRICING_PHASE_ID = :B11 AND QPPROD.QUALIFICATION_IND = :B10 AND QPPROD.PRODUCT_ATTRIBUTE_CONTEXT = QPLATPR.CONTEXT AND QPPROD.PRODUCT_ATTRIBUTE = QPLATP R.ATTRIBUTE AND QPPROD.PRODUCT_ATTR_VALUE = QPLATPR.VALUE_FROM AND QPPROD.EXCLUDER_FLAG = :B2 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPLATPR.LINE_INDEX = QPLINES.LINE_INDEX AND QPLATPR.ATTRIBUTE_TYPE='PRODUCT' AND QPLATPR.PRICING_STATUS_CODE=:B9 AND (NVL(:B3 , :B2 ) = :B1 AND QPL.LIST_LINE_TYPE_CODE NOT IN (:B8 , :B7 , :B6 , :B5 , :B4 ) OR NVL(:B3 , :B2 ) <> :B1 ) ORDER BY 4, 2
0d3t5pd9c06kx	SELECT NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0), NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0) FROM RA_CUSTOMER_TRX_LINES WHERE CUSTOMER_TRX_ID = :B2 AND LINE_TYPE = :B1
0f5b5fy8drf38	SELECT ORDERED_QUANTITY, UNIT_SELLING_PRICE, UNIT_COST FROM OE_ORDER_LINES_ALL WHERE HEADER_ID = :B1 AND UNIT_COST IS NOT NULL AND LINE_CATEGORY_CODE = 'ORDER'
0hfaqhz3gz1zw	SELECT DISTINCT PROFILE_CLASS_ID FROM HZ_CUSTOMER_PROFILES WHERE CUST_ACCOUNT_ID = :B1
0rxhfv39us09g	SELECT 'Y' FROM RA_CUSTOMER_TRX_LINES CTL WHERE CTL.CUSTOMER_TRX_ID = :B1 AND CTL.LINE_TYPE = 'LINE' AND NVL(CTL.AUTORULE_COMPLETE_FLAG, 'Y') <> 'N'
1pyvdv4zz5s05	SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.QUALIFIER_ATTR_VALUE = QPLATQ.VALUE_FROM AND QPQ.COMPARISON_OPERATOR_CODE = '=' AND QPQ.LIST_LINE_ID = -1 AND QPQ.SEARCH_IND = 1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE _FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B12 AND QPQ.QUALIFIER_DATATYPE = :B11 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND QP_NUMBER.CANONICAL_TO_NUMBER(DECODE(QPQ.QUALIFIER_DATATYPE, :B11 , QPLATQ.VALUE_FROM, NULL)) BETWEEN QPQ.QUAL_ATTR_VALUE_FROM_NUMBER AND QPQ.QUAL_ATTR_VALUE_TO_NUMBER AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QU ALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B12 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND QPQ.QUALIFIER_DATATYPE IN (:B15 , :B14 , :B13 ) AND QPLATQ.VALUE_FROM BETWEEN QPQ.QUALIFIER_ATTR_VALUE AND QPQ.QUALIFIER_ATTR_VALUE_TO AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =' AND QPQ.QUALIFIER_ATTR_VALUE <> QPLATQ.VALUE_FROM AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND Q PLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y'))
2714fpj38u2c0	SELECT HS.HOLD_SOURCE_ID, HS.HOLD_ID, HS.HOLD_ENTITY_CODE, HS.HOLD_ENTITY_ID, HS.HOLD_ENTITY_CODE2, HS.HOLD_ENTITY_ID2 FROM OE_HOLD_SOURCES HS, OE_HOLD_DEFINITIONS HLD WHERE HLD.HOLD_ID = HS.HOLD_ID AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >= ROUND( SYSDATE ) AND HS.RELEASED_FLAG = 'N' AND SYSDATE BETWEEN NVL( HLD.START_DATE_ACTIVE, SYSDATE ) AND NVL( HLD.END_DATE_ACTIVE, SYSDATE ) AND HS.HOLD_ENTITY_CODE = :B2 AND HS.HOLD_ENTITY_ID = :B1
2gr8c5nzs91d3	SELECT SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', -1*NVL(UNIT_SELLING_PRICE, 0), NVL(UNIT_SELLING_PRICE, 0))) FROM OE_ORDER_LINES WHERE ORDER_SOURCE_ID=27 AND ORIG_SYS_DOCUMENT_REF=TO_CHAR(:B2 ) AND ORIG_SYS_LINE_REF = TO_CHAR(:B1 ) AND RETROBILL_REQUEST_ID IS NOT NULL
2mj6c1fqvxmp9	SELECT 'EXISTS' FROM OE_ORDER_LINES_ALL WHERE HEADER_ID = :B1 AND ROWNUM = 1
2r68fjxqkmpt8	UPDATE OE_ORDER_LINES SET ACCOUNTING_RULE_ID = :B341 , ACCOUNTING_RULE_DURATION = :B340 , CALCULATE_PRICE_FLAG = :B339 , ACTUAL_ARRIVAL_DATE = :B338 , ACTUAL_SHIPMENT_DATE = :B337 , AGREEMENT_ID = :B336 , ARRIVAL_SET_ID = :B335 , ATO_LINE_ID = :B334 , ATTRIBUTE1 = :B333 , ATTRIBUTE10 = :B332 , ATTRIBUTE11 = :B331 , ATTRIBUTE12 = :B330 , ATTRIBUTE13 = :B329 , ATTRIBUTE14 = :B328 , ATTRIBUTE15 = :B327 , ATTRIBUTE16 = :B326 , ATTRIBUTE17 = :B325 , ATTRIBUTE18 = :B324 , ATTRIBUTE19 = :B323 , ATTRIBUTE2 = :B322 , ATTRIBUTE20 = :B321 , ATTRIBUTE3 = :B320 , ATTRIBUTE4 = :B319 , ATTRIBUTE5 = :B318 , ATTRIBUTE6 = :B317 , ATTRIBUTE7 = :B316 , ATTRIBUTE8 = :B315 , ATTRIBUTE9 = :B314 , AUTO_SELECTED_QUANTITY = :B313 , AUTHORIZED_TO_SHIP_FLAG = :B312 , BOOKED_FLAG = :B311 , CANCELLED_FLAG = :B310 , CANCELLED_QUANTITY = :B309 , COMMITMENT_ID = :B308 , COMPONENT_CODE = :B307 , COMPONENT_SEQUENCE_ID = :B306 , CONFIG_HEADER_ID = :B305 , CONFIG_REV_NBR = :B304 , CONFIG_DISPLAY_SEQUENCE = :B303 , CONFIGURATION_ID = :B302 , CONTEXT = :B301 , CREATED_BY = :B300 , CREATION_DATE = :B299 , CREDIT_INVOICE_LINE_ID = :B298 , CUSTOMER_LINE_NUMBER = :B297 , CUSTOMER_SHIPMENT_NUMBER = :B296 , CUSTOMER_ITEM_NET_PRICE = :B295 , CUSTOMER_PAYMENT_TERM_ID = :B294 , CUSTOMER_DOCK_CODE = :B293 , CUSTOMER_JOB = :B292 , CUSTOMER_PRODUCTION_LINE = :B291 , CUST_PRODUCTION_SEQ_NUM = :B290 , CUSTOMER_TRX_LINE_ID = :B289 , CUST_MODEL_SERIAL_NUMBER = :B288 , CUST_PO_NUMBER = :B287 , DELIVERY_LEAD_TIME = :B286 , DELIVER_TO_CONTACT_ID = :B285 , DELIVER_TO_ORG_ID = :B284 , DEMAND_BUCKET_TYPE_CODE = :B283 , DEMAND_CLASS_CODE = :B282 , DEP_PLAN_REQUIRED_FLAG = :B281 , EARLIEST_ACCEPTABLE_DATE = :B280 , END_ITEM_UNIT_NUMBER = :B279 , EXPLOSION_DATE = :B278 , FIRST_ACK_CODE = :B277 , FIRST_ACK_DATE = :B276 , FOB_POINT_CODE = :B275 , FREIGHT_CARRIER_CODE = :B274 , FREIGHT_TERMS_CODE = :B273 , FULFILLED_QUANTITY = :B272 , FULFILLED_FLAG = :B271 , FULFILLMENT_METHOD_CODE = :B270 , FULFILLMENT_DATE = :B269 , GLOBAL_ATTRIBUTE1 = :B268 , GLOBAL_ATTRIBUTE10 = :B267 , GLOBAL_ATTRIBUTE11 = :B266 , GLOBAL_ATTRIBUTE12 = :B265 , GLOBAL_ATTRIBUTE13 = :B264 , GLOBAL_ATTRIBUTE14 = :B263 , GLOBAL_ATTRIBUTE15 = :B262 , GLOBAL_ATTRIBUTE16 = :B261 , GLOBAL_ATTRIBUTE17 = :B260 , GLOBAL_ATTRIBUTE18 = :B259 , GLOBAL_ATTRIBUTE19 = :B258 , GLOBAL_ATTRIBUTE2 = :B257 , GLOBAL_ATTRIBUTE20 = :B256 , GLOBAL_ATTRIBUTE3 = :B255 , GLOBAL_ATTRIBUTE4 = :B254 , GLOBAL_ATTRIBUTE5 = :B253 , GLOBAL_ATTRIBUTE6 = :B252 , GLOBAL_ATTRIBUTE7 = :B251 , GLOBAL_ATTRIBUTE8 = :B250 , GLOBAL_ATTRIBUTE9 = :B249 , GLOBAL_ATTRIBUTE_CATEGORY = :B248 , HEADER_ID = :B1 , INDUSTRY_ATTRIBUTE1 = :B247 , INDUSTRY_ATTRIBUTE10 = :B246 , INDUSTRY_ATTRIBUTE11 = :B245 , INDUSTRY_ATTRIBUTE12 = :B244 , INDUSTRY_ATTRIBUTE13 = :B243 , INDUSTRY_ATTRIBUTE14 = :B242 , INDUSTRY_ATTRIBUTE15 = :B241 , INDUSTRY_ATTRIBUTE16 = :B240 , INDUSTRY_ATTRIBUTE17 = :B239 , INDUSTRY_ATTRIBUTE18 = :B238 , INDUSTRY_ATTRIBUTE19 = :B237 , INDUSTRY_ATTRIBUTE20 = :B236 , INDUSTRY_ATTRIBUTE21 = :B235 , INDUSTRY_ATTRIBUTE22 = :B234 , INDUSTRY_ATTRIBUTE23 = :B233 , INDUSTRY_ATTRIBUTE24 = :B232 , INDUSTRY_ATTRIBUTE25 = :B231 , INDUSTRY_ATTRIBUTE26 = :B230 , INDUSTRY_ATTRIBUTE27 = :B229 , INDUSTRY_ATTRIBUTE28 = :B228 , INDUSTRY_ATTRIBUTE29 = :B227 , INDUSTRY_ATTRIBUTE30 = :B226 , INDUSTRY_ATTRIBUTE2 = :B225 , INDUSTRY_ATTRIBUTE3 = :B224 , INDUSTRY_ATTRIBUTE4 = :B223 , INDUSTRY_ATTRIBUTE5 = :B222 , INDUSTRY_ATTRIBUTE6 = :B221 , INDUSTRY_ATTRIBUTE7 = :B220 , INDUSTRY_ATTRIBUTE8 = :B219 , INDUSTRY_ATTRIBUTE9 = :B218 , INDUSTRY_CONTEXT = :B217 , INTMED_SHIP_TO_CONTACT_ID = :B216 , INTMED_SHIP_TO_ORG_ID = :B215 , INVENTORY_ITEM_ID = :B214 , INVOICE_INTERFACE_STATUS_CODE = :B213 , INVOICE_TO_CONTACT_ID = :B212 , INVOICE_TO_ORG_ID = :B211 , INVOICED_QUANTITY = :B210 , INVOICING_RULE_ID = :B209 , ORDERED_ITEM_ID = :B208 , ITEM_IDENTIFIER_TYPE = :B2 07 , ORDERED_ITEM = :B206 , ITEM_REVISION = :B205 , ITEM_TYPE_CODE = :B204 , LAST_ACK_CODE = :B203 , LAST_ACK_DATE = :B202 , LAST_UPDATED_BY = :B201 , LATEST_ACCEPTABLE_DATE = :B200 , LAST_UPDATE_DATE = :B199 , LAST_UPDATE_LOGIN = :B198 , LINE_CATEGORY_CODE = :B197 , LINE_NUMBER = :B196 , LINE_TYPE_ID = :B195 , LINK_TO_LINE_ID = :B194 , MODEL_GROUP_NUMBER = :B193 , MFG_LEAD_TIME = :B192 , OPEN_FLAG = :B191 , OPTION_FLAG = :B190 , OPTION_NUMBER = :B189 , ORDERED_QUANTITY = :B188 , ORDERED_QUANTITY2 = :B187 , ORDER_QUANTITY_UOM = :B186 , ORDERED_QUANTITY_UOM2 = :B185 , ORDER_SOURCE_ID = :B184 , ORIG_SYS_DOCUMENT_REF = :B183 , ORIG_SYS_LINE_REF = :B182 , ORIG_SYS_SHIPMENT_REF = :B181 , CHANGE_SEQUENCE = :B180 , OVER_SHIP_REASON_CODE = :B179 , OVER_SHIP_RESOLVED_FLAG = :B178 , PAYMENT_TERM_ID = :B177 , PLANNING_PRIORITY = :B176 , PREFERRED_GRADE = :B175 , PRICE_LIST_ID = :B174 , PRICE_REQUEST_CODE = :B173 , PRICING_ATTRIBUTE1 = :B172 , PRICING_ATTRIBUTE10 = :B171 , PRICING_ATTRIBUTE2 = :B170 , PRICING_ATTRIBUTE3 = :B169 , PRICING_ATTRIBUTE4 = :B168 , PRICING_ATTRIBUTE5 = :B167 , PRICING_ATTRIBUTE6 = :B166 , PRICING_ATTRIBUTE7 = :B165 , PRICING_ATTRIBUTE8 = :B164 , PRICING_ATTRIBUTE9 = :B163 , PRICING_CONTEXT = :B162 , PRICING_DATE = :B161 , PRICING_QUANTITY = :B160 , PRICING_QUANTITY_UOM = :B159 , PROGRAM_APPLICATION_ID = :B158 , PROGRAM_ID = :B157 , PROGRAM_UPDATE_DATE = :B156 , PROJECT_ID = :B155 , PROMISE_DATE = :B154 , RE_SOURCE_FLAG = :B153 , REFERENCE_CUSTOMER_TRX_LINE_ID = :B152 , REFERENCE_HEADER_ID = :B151 , REFERENCE_LINE_ID = :B150 , REFERENCE_TYPE = :B149 , REQUEST_DATE = :B148 , REQUEST_ID = :B147 , RETURN_ATTRIBUTE1 = :B146 , RETURN_ATTRIBUTE10 = :B145 , RETURN_ATTRIBUTE11 = :B144 , RETURN_ATTRIBUTE12 = :B143 , RETURN_ATTRIBUTE13 = :B142 , RETURN_ATTRIBUTE14 = :B141 , RETURN_ATTRIBUTE15 = :B140 , RETURN_ATTRIBUTE2 = :B139 , RETURN_ATTRIBUTE3 = :B138 , RETURN_ATTRIBUTE4 = :B137 , RETURN_ATTRIBUTE5 = :B136 , RETURN_ATTRIBUTE6 = :B135 , RETURN_ATTRIBUTE7 = :B134 , RETURN_ATTRIBUTE8 = :B133 , RETURN_ATTRIBUTE9 = :B132 , RETURN_CONTEXT = :B131 , RETURN_REASON_CODE = :B130 , RLA_SCHEDULE_TYPE_CODE = :B129 , SALESREP_ID = :B128 , SCHEDULE_ARRIVAL_DATE = :B127 , SCHEDULE_SHIP_DATE = :B126 , SCHEDULE_STATUS_CODE = :B125 , SHIPMENT_NUMBER = :B124 , SHIPMENT_PRIORITY_CODE = :B123 , SHIPPED_QUANTITY = :B122 , SHIPPED_QUANTITY2 = :B121 , SHIPPING_METHOD_CODE = :B120 , SHIPPING_QUANTITY = :B119 , SHIPPING_QUANTITY2 = :B118 , SHIPPING_QUANTITY_UOM = :B117 , SHIP_FROM_ORG_ID = :B116 , SUBINVENTORY = :B115 , SHIP_TOLERANCE_ABOVE = :B114 , SHIP_TOLERANCE_BELOW = :B113 , SHIPPABLE_FLAG = :B112 , SHIPPING_INTERFACED_FLAG = :B111 , SHIP_TO_CONTACT_ID = :B110 , SHIP_TO_ORG_ID = :B109 , SHIP_MODEL_COMPLETE_FLAG = :B108 , SHIP_SET_ID = :B107 , SOLD_TO_ORG_ID = :B106 , SOLD_FROM_ORG_ID = :B105 , SORT_ORDER = :B104 , SOURCE_DOCUMENT_ID = :B103 , SOURCE_DOCUMENT_LINE_ID = :B102 , SOURCE_DOCUMENT_TYPE_ID = :B101 , SOURCE_TYPE_CODE = :B100 , SPLIT_FROM_LINE_ID = :B99 , LINE_SET_ID = :B98 , SPLIT_BY = :B97 , MODEL_REMNANT_FLAG = :B96 , TASK_ID = :B95 , TAX_CODE = :B94 , TAX_DATE = :B93 , TAX_EXEMPT_FLAG = :B92 , TAX_EXEMPT_NUMBER = :B91 , TAX_EXEMPT_REASON_CODE = :B90 , TAX_POINT_CODE = :B89 , TAX_RATE = :B88 , TAX_VALUE = :B87 , TOP_MODEL_LINE_ID = :B86 , UNIT_LIST_PRICE = :B85 , UNIT_LIST_PRICE_PER_PQTY = :B84 , UNIT_SELLING_PRICE = :B83 , UNIT_SELLING_PRICE_PER_PQTY = :B82 , VISIBLE_DEMAND_FLAG = :B81 , VEH_CUS_ITEM_CUM_KEY_ID = :B80 , SHIPPING_INSTRUCTIONS = :B79 , PACKING_INSTRUCTIONS = :B78 , SERVICE_TXN_REASON_CODE = :B77 , SERVICE_TXN_COMMENTS = :B76 , SERVICE_DURATION = :B75 , SERVICE_PERIOD = :B74 , SERVICE_START_DATE = :B73 , SERVICE_END_DATE = :B72 , SERVICE_COTERMINATE_FLAG = :B71 , UNIT_LIST_PERCENT = :B70 , UNIT_SELLING_PERCENT = :B69 , UNIT_PERCENT_BASE_PRICE = :B68 , SERVICE_NUMBER = :B67 , SERVICE_REFERENCE_TYPE_CODE = :B66 , SERVICE_REFERENCE_LINE_ID = :B65 , SERVICE_REFERENCE_SYSTEM_ID = :B64 , TP_CONTEXT = :B63 , TP_ATTRIBUTE1 = :B62 , TP_ATTRIBUTE2 = :B61 , TP_ATTRIBUTE3 = :B60 , TP_ATTRIBUTE4 = :B59 , TP_ATTRIBUTE5 = :B58 , TP_ATTRIBUTE6 = :B57 , TP_ATTRIBUTE7 = :B56 , TP_ATTRIBUTE8 = :B55 , TP_ATTRIBUTE9 = :B54 , TP_ATTRIBUTE10 = :B53 , TP_ATTRIBUTE11 = :B52 , TP_ATTRIBUTE12 = :B51 , TP_ATTRIBUTE13 = :B50 , TP_ATTRIBUTE14 = :B49 , TP_ATTRIBUTE15 = :B48 , FLOW_STATUS_CODE = :B47 , MARKETING_SOURCE_CODE_ID = :B46 , ORIGINAL_INVENTORY_ITEM_ID = :B45 , ORIGINAL_ITEM_IDENTIFIER_TYPE = :B44 , ORIGINAL_ORDERED_ITEM_ID = :B43 , ORIGINAL_ORDERED_ITEM = :B42 , ITEM_RELATIONSHIP_TYPE = :B41 , ITEM_SUBSTITUTION_TYPE_CODE = :B40 , LATE_DEMAND_PENALTY_FACTOR = :B39 , OVERRIDE_ATP_DATE_CODE = :B38 , FIRM_DEMAND_FLAG = :B37 , EARLIEST_SHIP_DATE = :B36 , USER_ITEM_DESCRIPTION = :B35 , BLANKET_NUMBER = :B34 , BLANKET_LINE_NUMBER = :B33 , BLANKET_VERSION_NUMBER = :B32 , UNIT_COST = :B31 , LOCK_CONTROL = :B30 , TRANSACTION_PHASE_CODE = :B29 , SOURCE_DOCUMENT_VERSION_NUMBER = :B28 , MINISITE_ID = :B27 , IB_OWNER = :B26 , IB_INSTALLED_AT_LOCATION = :B25 , IB_CURRENT_LOCATION = :B24 , END_CUSTOMER_ID = :B23 , END_CUSTOMER_CONTACT_ID = :B22 , END_CUSTOMER_SITE_USE_ID = :B21 , RETROBILL_REQUEST_ID = :B20 , ORIGINAL_LIST_PRICE = :B19 , ORDER_FIRMED_DATE = :B18 , ACTUAL_FULFILLMENT_DATE = :B17 , CHARGE_PERIODICITY_CODE = :B16 , CANCELLED_QUANTITY2 = :B15 , SHIPPING_QUANTITY_UOM2 = :B14 , FULFILLED_QUANTITY2 = :B13 , CONTINGENCY_ID = :B12 , REVREC_EVENT_CODE = :B11 , REVREC_EXPIRATION_DAYS = :B10 , ACCEPTED_QUANTITY = :B9 , REVREC_COMMENTS = :B8 , REVREC_SIGNATURE = :B7 , REVREC_SIGNATURE_DATE = :B6 , ACCEPTED_BY = :B5 , REVREC_REFERENCE_DOCUMENT = :B4 , REVREC_IMPLICIT_FLAG = :B3 WHERE LINE_ID = :B2 AND HEADER_ID = :B1
2rpmdkbqgdzau	SELECT DISTINCT WDA.DELIVERY_ID FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS_V WDA, WSH_NEW_DELIVERIES WND, WSH_SHIPPING_PARAMETERS WSP WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID AND WDD.BATCH_ID = :B1 AND WDD.RELEASED_STATUS = 'Y' AND WDA.DELIVERY_ID = WND.DELIVERY_ID AND WDA.DELIVERY_ID IS NOT NULL AND WND.PLANNED_FLAG = 'N' AND WND.ORGANIZATION_ID = WSP.ORGANIZATION_ID AND NVL(WSP.APPENDING_LIMIT, 'N') <> 'N'
2v1vanmps8nck	SELECT NVL(OT.CUST_TRX_TYPE_ID, 0) FROM OE_ORDER_TYPES_V OT, OE_ORDER_HEADERS_ALL OH WHERE OT.ORDER_TYPE_ID = OH.ORDER_TYPE_ID AND OH.HEADER_ID = :B1
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3cv034rb4c2z4	SELECT RELATED_CUST_ACCOUNT_ID FROM HZ_CUST_ACCT_RELATE WHERE CUST_ACCOUNT_ID = :B1
3jznhhwdk3hj4	SELECT NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', NVL(ORDERED_QUANTITY, 0)*(UNIT_LIST_PRICE), 0)), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', 0, NVL(ORDERED_QUANTITY, 0)*(UNIT_LIST_PRICE))), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', NVL(ORDERED_QUANTITY, 0), 0)), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', 0, NVL(ORDERED_QUANTITY, 0))), 0) FROM OE_ORDER_LINES WHERE HEADER_ID=:B1 AND (CANCELLED_FLAG='N' OR CANCELLED_FLAG IS NULL) AND CHARGE_PERIODICITY_CODE IS NULL
45a1r2zswduwz	SELECT /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpc qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_prod_pric_cur_mod */ QPL.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPL.LIST_LINE_TYPE_CODE, QPLATPR.LINE_INDEX, QPLATPR.VALIDATED_FLAG, QPLATPR.APPLIED_FLAG, QPLATPR.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLATPR.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLATPR.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLATPR.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLATPR.VALUE_FROM PRODUCT_ATTR_VALUE, QPPROD.PRODUCT_ATTR_VALUE PRODUCT_SETUP_VALUE, QPLATPR.PRICING_ATTR_FLAG PRODUCT_PRICING_ATTR_FLAG, QPPROD.PRODUCT_UOM_CODE PRODUCT_UOM_CODE, QPPROD.EXCLUDER_FLAG, QPLATPC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLATPC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPLATPC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLATPC.ATTRIBUTE PRICING_ATTRIBUTE, QPLATPC.VALUE_FROM PRICING_ATTR_VALUE, QPPROD.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPPROD.PRICING_ATTR_VALUE_TO PRICING_SETUP_VALUE_TO, QPPROD.COMPARISON_OPERATOR_CODE PRICING_COMPARISON_OPERATOR, QPPROD.PRICING_ATTRIBUTE_DATATYPE PRICING_DATATYPE, NULL QUALIFIER_GROUPING_NO, NULL QUALIFIER_PRECEDENCE, QPL.AUTOMATIC_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.PRIMARY_UOM_FLAG, QPL.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE, QPL.OPERAND OPERAND_VALUE, QPL.NET_AMOUNT_FLAG, QPL.PRICING_GROUP_SEQUENCE, QPH.ASK_FOR_FLAG, QPH.LIST_TYPE_CODE CREATED_FROM_LIST_TYPE, QPL.PRICING_PHASE_ID, QPL.PRICE_BREAK_TYPE_CODE, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.OVERRIDE_FLAG, QPL.BENEFIT_QTY, QPL.BENEFIT_UOM_CODE, QPL.LIST_LINE_NO, QPL.ACCRUAL_FLAG, QPL.ACCRUAL_CONVERSION_RATE, QPL.ESTIM_ACCRUAL_RATE, QPH.LIMIT_EXISTS_FLAG HEADER_LIMIT_EXISTS, QPL.LIMIT_EXISTS_FLAG LINE_LIMIT_EXISTS, 'NQ' QUALIFIER_TYPE, QPL.CHARGE_TYPE_CODE, QPL.CHARGE_SUBTYPE_CODE, QPL.ACCUM_CONTEXT, QPL.ACCUM_ATTRIBUTE, QPL.ACCUM_ATTR_RUN_SRC_FLAG FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLATPR, QP_PRICING_ATTRIBUTES QPPROD , QP_NPREQ_LINE_ATTRS_TMP QPLATPC, QP_LIST_HEADERS_B QPH , QP_LIST_LINES QPL , QP_PRICE_REQ_SOURCES_V QPRS WHERE (QPLINES.PRICE_FLAG = :B1 OR (QPLINES.PRICE_FLAG = :B17 AND :B16 = :B1 )) AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE) OR QPH.CURRENCY_CODE IS NULL) AND (QPLINES.UNIT_PRICE IS NOT NULL OR QPLINES.USAGE_PRICING_TYPE = :B15 OR QPLINES.LINE_TYPE_CODE = :B14 ) AND (QPL.MODIFIER_LEVEL_CODE = QPLINES.LINE_TYPE_CODE OR (QPL.MODIFIER_LEVEL_CODE = :B13 AND NVL(:B3 , :B2 ) <> :B1 )) AND QPH.ACTIVE_FLAG = :B1 AND ((QPH.ASK_FOR_FLAG = :B1 AND EXISTS (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' FROM QP_NPREQ_LINE_ATTRS_TMP LA WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B9 AND VALIDATED_FLAG = :B2 AND LIST_HEADER_ID = QPH.LIST_HEADER_ID AND LINE_INDEX = QPLINES.LINE_INDEX)) OR QPH.ASK_FOR_FLAG = :B2 ) AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID AND QPL.LIST_LINE_ID = QPPROD.LIST_LINE_ID AND QPPROD.PRICING_PHASE_ID = :B12 AND NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_FIRST_TYPE, NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X')) AND NVL(QPLI NES.ACTIVE_DATE_SECOND_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_SECOND_TYPE, NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X')) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICED_UOM_CODE = NVL(QPPROD.PRODUCT_UOM_CODE, QPLINES.PRICED_UOM_CODE) AND QPPROD.PRICING_PHASE_ID = :B12 AND QPPROD.QUALIFICATION_IND = :B11 AND QPPROD.PRODUCT_ATTRIBUTE_CONTEXT = QPLATPR.CONTEXT AND QPPROD.PRODUCT_ATTRIBUTE = QPLATPR.ATTRIBUTE AND QPPROD.PRODUCT_ATTR_VALUE = QPLATPR.VALUE_FROM AND QPPROD.PRICING_ATTRIBUTE_CONTEXT = QPLATPC.CONTEXT AND QPPROD.PRICING_ATTRIBUTE = QPLATPC.ATTRIBUTE AND (QPPROD.PRICING_ATTR_VALUE_FROM = QPLATPC.VALUE_FROM OR QPPROD.COMPARISON_OPERATOR_CODE IN ('NOT =', :B10 )) AND QPPROD.EXCLUDER_FLAG = :B2 AND QPLATPC.LINE_INDEX = QPLATPR.LINE_INDEX AND QPLATPR.LINE_INDEX = QPLINES.LINE_INDEX AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPLATPC.PRICING_ATTR_FLAG = :B1 AND QPLATPR.ATTRIBUTE_TYPE='PRODUCT' AND QPLATPR.PRICING_STATUS_CODE=:B9 AND QPLATPC.ATTRIBUTE_TYPE = 'PRICING' AND QPLATPC.PRICING_STATUS_CODE = :B9 AND (NVL(:B3 , :B2 ) = :B1 AND QPL.LIST_LINE_TYPE_CODE NOT IN (:B8 , :B7 , :B6 , :B5 , :B4 ) OR NVL(:B3 , :B2 ) <> :B1 ) ORDER BY 4, 2
48ft2dtrjr8k3	INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ORG_ID, NODE_NAME1, CONNSTR1, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25) SELECT :B77 , :B76 , :B75 , DECODE (:B74 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B56 , 'Y', 'Q', DECODE(:B37 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B73 , NULL, 50, :B73 )), DECODE (:B65 , 0, NULL, :B65 ), :B72 , :B71 , NULL, :B70 , 'N', :B69 , :B68 , 'Y', :B56 , 'S', :B67 , SYSDATE, DECODE (:B66 , '', (SYSDATE - :B64 ), GREATEST (:B66 , DECODE (:B65 , 0, (SYSDATE - :B64 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B63 , SYSDATE, :B63 , :B62 , ORACLE_ID, :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B37 , 'Y', 'B', DECODE(:B56 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , DECODE (:B49 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B49 ), 'HH24:MI:SS')), DECODE (:B48 , '', NULL, :B48 ), :B47 , :B46 , :B45 , 'N', :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B38 , :B37 , :B36 , DECODE(:B35 , 'Y', 'Y', FCP.ENABLE_TRACE), :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
4t6x5a9b46cyx	SELECT * FROM (select p.party_id, p.party_name, p.person_first_name, p.person_last_name, p.party_type, partytype.meaning type_lookup, p.party_number, p.tax_reference, p.jgzz_fiscal_code taxpayer_id, p.duns_number_c duns_number, p.known_as, p.known_as2, p.known_as3, p.known_as4, p.known_as5, p.organization_name_phonetic, p.person_first_name_phonetic, p.person_last_name_phonetic, ps.location_id, terr.territory_short_name country, p.primary_phone_contact_pt_id, p.primary_phone_country_code, p.primary_phone_area_code, p.primary_phone_number, p.primary_phone_line_type, p.primary_phone_extension, p.email_address email, p.url primary_url, certification.meaning certification_level_meaning , registrystatus.meaning registry_meaning , p.status party_status from hz_parties p, hz_party_sites ps, fnd_territories_vl terr, fnd_lookup_values partytype, fnd_lookup_values certification , fnd_lookup_values registrystatus where p.party_type in (:"SYS_B_00", :"SYS_B_01") and registrystatus.lookup_code = p.status and ps.party_id(+) = p.party_id and ps.identifying_address_flag(+) = :"SYS_B_02" and terr.territory_code(+) = p.country and partytype.view_application_id = :"SYS_B_03" and partytype.lookup_type = :"SYS_B_04" and partytype.language = userenv(:"SYS_B_05") and partytype.lookup_code = p.party_type and certification.view_application_id(+) = :"SYS_B_06" and certification.lookup_type(+) = :"SYS_B_07" and certification.language(+) = userenv(:"SYS_B_08") and certification.lookup_code(+) = p.certification_level and registrystatus.lookup_type = :"SYS_B_09" and registrystatus.language = userenv(:"SYS_B_10")) QRSLT WHERE (party_type = :1 and party_status=:"SYS_B_11" and exists ( select null from HZ_CUSTOMER_PARTY_FIND_V hpfv where hpfv.org_per_number = qrslt.party_number and hpfv.CUSTOMER_NUMBER = :2 ) and exists ( SELECT null FROM hz_party_usg_assignments WHERE party_id = qrslt.party_id AND party_usage_code = :"SYS_B_12"AND status_flag = :"SYS_B_13" AND trunc(SYSDATE) BETWEEN effective_start_date AND effective_end_date))
4wgb411d8s7ss	INSERT INTO QP_NPREQ_LINE_ATTRS_TMP (LINE_INDEX, ATTRIBUTE_LEVEL, ATTRIBUTE_TYPE, CONTEXT, ATTRIBUTE, VALUE_FROM, VALIDATED_FLAG, APPLIED_FLAG, PRICING_STATUS_CODE, PRICING_ATTR_FLAG ) VALUES (:B1 , :B10 , :B2 , :B3 , :B4 , :B5 , :B6 , :B9 , :B8 , :B7 )
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
52uy1628x95hv	SELECT AD.TYPE TYPE, ADS.SEGMENT SEGMENT, UPPER(ADS.TABLE_NAME) TABLE_NAME, ADS.CONSTANT CONSTANT FROM RA_ACCOUNT_DEFAULT_SEGMENTS ADS, RA_ACCOUNT_DEFAULTS AD WHERE AD.GL_DEFAULT_ID = ADS.GL_DEFAULT_ID AND AD.ORG_ID = NVL(:B1 , AD.ORG_ID) AND AD.TYPE IN ( 'REV', 'REC', 'FREIGHT', 'TAX', 'UNBILL', 'UNEARN', 'SUSPENSE' ) ORDER BY TYPE, SEGMENT_NUM
5j000r4cc1kaz	SELECT PERIOD3_ORDERED_QUANTITY, PRIMARY_UOM_CODE FROM OE_ITEM_CUST_VOLS WHERE SOLD_TO_ORG_ID = :B2 AND INVENTORY_ITEM_ID = :B1
5uc22nkkupb6x	SELECT INVENTORY_ITEM_ID , ORGANIZATION_ID , INVOICING_RULE_ID , ACCOUNTING_RULE_ID , DEFAULT_SHIPPING_ORG , SHIP_MODEL_COMPLETE_FLAG , BUILD_IN_WIP_FLAG , BOM_ITEM_TYPE , REPLENISH_TO_ORDER_FLAG , PRIMARY_UOM_CODE , PICK_COMPONENTS_FLAG , SHIPPABLE_ITEM_FLAG , SERVICE_ITEM_FLAG , ORGANIZATION_ID , CUSTOMER_ORDER_ENABLED_FLAG , INTERNAL_ORDER_ENABLED_FLAG , RETURNABLE_FLAG , RESTRICT_SUBINVENTORIES_CODE FROM MTL_SYSTEM_ITEMS WHERE INVENTORY_ITEM_ID = :B2 AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', :B1 )
5yvh6u6k34zjn	select cust_acct.account_number account_number, party.party_name party_name, party.jgzz_fiscal_code jgzz_fiscal_code, party.tax_reference tax_reference, cust_acct.cust_account_id customer_id , decode(al_fob.meaning, null, null, cust_acct.fob_point) fob_point, al_fob.meaning fob_point_meaning, decode(oft.description, null, null, cust_acct.ship_via) ship_via, oft.description ship_via_meaning, to_number( decode(ras.name, null, null, cust_acct.primary_salesrep_id) ) primary_salesrep_id, ras.name primary_salesrep_name, ras.salesrep_number primary_salesrep_num , cust_acct.account_name account_description from hz_cust_accounts cust_acct, hz_parties party, ra_salesreps ras, org_freight oft, ar_lookups al_fob where (ACCOUNT_NUMBER LIKE :1) AND ( cust_acct.party_id = party.party_id and cust_acct.ship_via = oft.freight_code(+) and :2 = organization_id(+) and cust_acct.fob_point = al_fob.lookup_code(+) and :"SYS_B_00" = al_fob.lookup_type(+) and :"SYS_B_01" = al_fob.enabled_flag(+) and cust_acct.primary_salesrep_id = ras.salesrep_id(+) and :3 <= nvl(trunc(oft.disable_date(+)), :4) and :5 between al_fob.start_date_active (+) and nvl(al_fob.end_date_active(+), :6) and :7 between nvl(ras.start_date_active(+), :8) and nvl(ras.end_date_active, :9) and ( /* credit memos against specific transactions must have the same ship to customer as the transaction they are crediting. */ (cust_acct.cust_account_id = decode(:10, :"SYS_B_02", :11, :"SYS_B_03", :12, :13)) or ( ( :14 is null or :15 != :"SYS_B_04" ) and nvl(cust_acct.status, :"SYS_B_05") = :"SYS_B_06" and nvl(party.category_code, :"SYS_B_07") != :"SYS_B_08" and exists ( select :"SYS_B_09" from hz_cust_Acct_sites acct_site where acct_site.cust_account_id = cust_acct.cust_account_id and acct_site.status = :"SYS_B_10" and ( ( :16 = :"SYS_B_11" and acct_site.ship_to_flag in ( :"SYS_B_12", :"SYS_B_13") ) or (:17 = :"SYS_B_14" and acct_site.bill_to_flag in ( :"SYS_B_15", :"SYS_B_16") ) or (:18 = :"SYS_B_17"))))) ) order by decode(:19, :"SYS_B_18", party.party_name, cust_acct.account_number ), decode(:20, :"SYS_B_19", cust_acct.account_number, party.party_name )
6xusmw3vc1xny	SELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES CAL, MTL_PARAMETERS ORG WHERE CAL.CALENDAR_CODE = ORG.CALENDAR_CODE AND CAL.EXCEPTION_SET_ID = ORG.CALENDAR_EXCEPTION_SET_ID AND ORG.ORGANIZATION_ID = :B1 AND CAL.SEQ_NUM IS NOT NULL
78jsmr7hwsnsc	SELECT * FROM (select p.party_id, p.party_name, p.person_first_name, p.person_last_name, p.party_type, partytype.meaning type_lookup, p.party_number, p.tax_reference, p.jgzz_fiscal_code taxpayer_id, p.duns_number_c duns_number, p.known_as, p.known_as2, p.known_as3, p.known_as4, p.known_as5, p.organization_name_phonetic, p.person_first_name_phonetic, p.person_last_name_phonetic, ps.location_id, terr.territory_short_name country, p.primary_phone_contact_pt_id, p.primary_phone_country_code, p.primary_phone_area_code, p.primary_phone_number, p.primary_phone_line_type, p.primary_phone_extension, p.email_address email, p.url primary_url, certification.meaning certification_level_meaning , registrystatus.meaning registry_meaning , p.status party_status from hz_parties p, hz_party_sites ps, fnd_territories_vl terr, fnd_lookup_values partytype, fnd_lookup_values certification , fnd_lookup_values registrystatus where p.party_type in (:"SYS_B_00", :"SYS_B_01") and registrystatus.lookup_code = p.status and ps.party_id(+) = p.party_id and ps.identifying_address_flag(+) = :"SYS_B_02" and terr.territory_code(+) = p.country and partytype.view_application_id = :"SYS_B_03" and partytype.lookup_type = :"SYS_B_04" and partytype.language = userenv(:"SYS_B_05") and partytype.lookup_code = p.party_type and certification.view_application_id(+) = :"SYS_B_06" and certification.lookup_type(+) = :"SYS_B_07" and certification.language(+) = userenv(:"SYS_B_08") and certification.lookup_code(+) = p.certification_level and registrystatus.lookup_type = :"SYS_B_09" and registrystatus.language = userenv(:"SYS_B_10")) QRSLT WHERE (party_type = :1 and party_status=:"SYS_B_11" and exists ( select null from HZ_CUSTOMER_PARTY_FIND_V hpfv where hpfv.org_per_number = qrslt.party_number and hpfv.CUSTOMER_NUMBER = :2 ))
88nycj781my88	INSERT INTO OE_ORDER_LINES ( ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , CUSTOMER_PAYMENT_TERM_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LATEST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORDER_SOURCE_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , CHANGE_SEQUENCE , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_ FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHEDULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , SHIPPING_QUANTITY_UOM2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG ) VALUES ( :B344 , :B343 , :B342 , :B341 , :B340 , :B339 , :B338 , :B337 , :B336 , :B335 , :B334 , :B333 , :B332 , :B331 , :B330 , :B329 , :B328 , :B327 , :B326 , :B325 , :B324 , :B323 , :B322 , :B321 , :B320 , :B319 , :B318 , :B317 , :B316 , :B315 , :B314 , :B313 , :B312 , :B311 , :B310 , :B309 , :B308 , :B307 , :B306 , :B305 , :B304 , :B303 , :B302 , :B301 , :B300 , :B299 , :B298 , :B297 , :B296 , :B295 , :B294 , :B293 , :B292 , :B291 , :B290 , :B289 , :B288 , :B287 , :B286 , :B285 , :B284 , :B283 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B154 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
8aphk8myt3n7q	select acct.account_number account_number, acct.account_name account_description, party.party_number registry_id, party.party_name party_name, party.party_type, acct.cust_account_id cust_account_id, party.email_address email_address, nvl(party.gsa_indicator_flag, :"SYS_B_0") gsa_indicator FROM HZ_PARTIES PARTY, hz_cust_accounts acct WHERE (ACCOUNT_NUMBER LIKE :1) AND ( acct.party_id=party.party_id AND acct.status=:"SYS_B_1" ) order by party_name
8camsgjsr9zya	begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8p204vk5avzuq	SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT, CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX, PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID, PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR, ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE (PR.CONDITION_GROUP_CODE = :B2 OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND EXISTS (SELECT /*+ no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE = RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE = PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a) use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX, RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM, -1 COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_RATE_CODE = :B4 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL) AND EXISTS (SELECT 1 FROM ZX_SCO_TAXES_B_V TAX WHERE TAX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y') ) ORDER BY COMPOUNDING_PRECEDENCE NULLS FIRST
8r13yd5kb4z0t	SELECT T.BILL_TO_SITE_USE_ID FROM RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B1
9cz4wbnyvaz6j	INSERT INTO MSC_REGIONS_TEMP (SESSION_ID, PARTNER_SITE_ID, REGION_ID, REGION_TYPE, ZONE_FLAG, PARTNER_TYPE) SELECT DISTINCT :B5 , :B3 , A.REGION_ID, A.ZONE_LEVEL, :B6 , :B4 FROM WSH_REGIONS A, WSH_ZONE_REGIONS B, MSC_REGIONS_TEMP C WHERE A.REGION_ID = B.PARENT_REGION_ID AND A.REGION_TYPE = 10 AND A.ZONE_LEVEL IS NOT NULL AND B.REGION_ID = C.REGION_ID AND C.SESSION_ID = :B5 AND C.PARTNER_SITE_ID = DECODE(:B1 , :B4 , :B3 , :B2 ) AND C.PARTNER_TYPE = :B1
9ndqc5wmt19s4	SELECT VALUE FROM V$PARAMETER WHERE NAME = 'optimizer_dynamic_sampling'
9zuxp618k86n4	SELECT MTL_MSI.BOM_ITEM_TYPE , MTL_MSI.REPLENISH_TO_ORDER_FLAG , MTL_MSI.CONFIG_MODEL_TYPE FROM MTL_SYSTEM_ITEMS MTL_MSI WHERE MTL_MSI.INVENTORY_ITEM_ID = :B2 AND MTL_MSI.ORGANIZATION_ID=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', :B1 )
aa6zd9qzswmpt	SELECT NVL(GSA_INDICATOR, 'N') FROM HZ_CUST_SITE_USES HSU WHERE SITE_USE_ID = :B2 AND HSU.ORG_ID = :B1
akdc5ap5258pd	SELECT LOOKUP_CODE FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = :B3 AND ORG_ID IN (:B2 , -99) AND ENABLED_FLAG = 'Y' AND (START_DATE_ACTIVE <= :B1 OR START_DATE_ACTIVE IS NULL) AND (END_DATE_ACTIVE >= :B1 OR END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY ORG_ID DESC
aw21gc59tbcnr	SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID , NULL IS_RESERVABLE_LOT FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL, X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DETAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT ( :B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) ) ) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBIN VENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34)) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID, 3, MMTT.TRANSFER_ORGANIZATION, MMTT.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND DECODE( NVL(MMTT.TRANSACTION_STATUS, 0), 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 2), 1 ) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ( (:B11 = 1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
bmvr0154yzvmv	SELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES WHERE CALENDAR_CODE = :B1 AND SEQ_NUM IS NOT NULL
cd4dpzrvancs3	SELECT TAX_CALCULATION_FLAG FROM RA_CUST_TRX_TYPES WHERE CUST_TRX_TYPE_ID = :B1
cdhfj5xxygura	SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B8 VALIDATED_FLAG, :B8 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B8 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.QUALIFIER_ATTR_VALUE = QPLATQ.VALUE_FROM AND QPQ.COMPARISON_OPERATOR_CODE = '=' AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID <> -1 AND ( QPQ.LIST_HEADER_ID IN (SELECT DISTINCT LIST_HEADER_ID FROM QP_PREQ_QUAL_TMP WHERE PRICING_PHASE_ID = :B9 AND PRICING_STATUS_CODE = :B3 ) OR QPQ.HEADER_QUALS_EXIST_FLAG = :B8 ) AND (NOT EXISTS (SELECT /*+ INDEX (qp_pa, QP_PRICING_ATTRIBUTES_N2) */'x' FROM QP_PRICING_ATTRIBUTES QP_PA WHERE QP_PA.LIST_LINE_ID = QPQ.LIST_LINE_ID AND ROWNUM = 1) OR EXISTS (SELECT /*+ ORDERED USE_NL(qpprod) INDEX (c, QP_PRICING_ATTRIBUTES_N2) */ 'x' FROM QP_PRICING_ATTRIBUTES C, QP_NPREQ_LINE_ATTRS_TMP QPPROD WHERE C.LIST_HEADER_ID = QPQ.LIST_HEADER_ID AND C.LIST_LINE_ID = QPQ.LIST_LINE_ID AND C.PRICING_PHASE_ID = :B9 AND QPPROD.CONTEXT = C.PRODUCT_ATTRIBUTE_CONTEXT AND QPPROD.ATTRIBUTE = C.PRODUCT_ATTRIBUTE AND QPPROD.VALUE_FROM = C.PRODUCT_ATTR_VALUE AND QPPROD.PRICING_STATUS_CODE = :B3 AND C.QUALIFICATION_IND IN (:B15 , :B14 , :B13 , :B12 ) AND QPPROD.ATTRIBUTE_TYPE = :B11 AND C.EXCLUDER_FLAG = :B8 AND ROWNUM = 1) ) AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B7 ) OR QPH.CURRENCY_CODE IS NULL) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B8 VALIDATED_ FLAG, :B8 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B8 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B17 AND QPQ.QUALIFIER_DATATYPE = :B16 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID <> -1 AND ( QPQ.LIST_HEADER_ID IN (SELECT DISTINCT LIST_HEADER_ID FROM QP_PREQ_QUAL_TMP WHERE PRICING_PHASE_ID = :B9 AND PRICING_STATUS_CODE = :B3 ) OR QPQ.HEADER_QUALS_EXIST_FLAG = :B8 ) AND (NOT EXISTS (SELECT /*+ INDEX (qp_pa, QP_PRICING_ATTRIBUTES_N2) */'x' FROM QP_PRICING_ATTRIBUTES QP_PA WHERE QP_PA.LIST_LINE_ID = QPQ.LIST_LINE_ID AND ROWNUM = 1) OR EXISTS (SELECT /*+ ORDERED USE_NL(qpprod) INDEX (c, QP_PRICING_ATTRIBUTES_N2) */ 'x' FROM QP_PRICING_ATTRIBUTES C, QP_NPREQ_LINE_ATTRS_TMP QPPROD WHERE C.LIST_HEADER_ID = QPQ.LIST_HEADER_ID AND C.LIST_LINE_ID = QPQ.LIST_LINE_ID AND C.PRICING_PHASE_ID = :B9 AND QPPROD.CONTEXT = C.PRODUCT_ATTRIBUTE_CONTEXT AND QPPROD.ATTRIBUTE = C.PRODUCT_ATTRIBUTE AND QPPROD.VALUE_FROM = C.PRODUCT_ATTR_VALUE AND QPPROD.PRICING_STATUS_CODE = :B3 AND C.QUALIFICATION_IND IN (:B15 , :B14 , :B13 , :B12 ) AND QPPROD.ATTRIBUTE_TYPE = :B11 AND C.EXCLUDER_FLAG = :B8 AND ROWNUM = 1) ) AND QP_NUMBER.CANONICAL_TO_NUMBER(DECODE(QPQ.QUALIFIER_DATATYPE, :B16 , QPLATQ.VALUE_FROM, NULL)) BETWEEN QPQ.QUAL_ATTR_VALUE_FROM_NUMBER AND QPQ.QUAL_ATTR_VALUE_TO_NUMBER AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B7 ) OR QPH.CURRENCY_CODE IS NULL) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B8 VALIDATED_FLAG, :B8 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROU PING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B8 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B17 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID <> -1 AND ( QPQ.LIST_HEADER_ID IN (SELECT DISTINCT LIST_HEADER_ID FROM QP_PREQ_QUAL_TMP WHERE PRICING_PHASE_ID = :B9 AND PRICING_STATUS_CODE = :B3 ) OR QPQ.HEADER_QUALS_EXIST_FLAG = :B8 ) AND (NOT EXISTS (SELECT /*+ INDEX (qp_pa, QP_PRICING_ATTRIBUTES_N2) */ 'x' FROM QP_PRICING_ATTRIBUTES QP_PA WHERE QP_PA.LIST_LINE_ID = QPQ.LIST_LINE_ID AND ROWNUM = 1) OR EXISTS (SELECT /*+ ORDERED USE_NL(qpprod) INDEX (c, QP_PRICING_ATTRIBUTES_N2) */ 'x' FROM QP_PRICING_ATTRIBUTES C, QP_NPREQ_LINE_ATTRS_TMP QPPROD WHERE C.LIST_HEADER_ID = QPQ.LIST_HEADER_ID AND C.LIST_LINE_ID = QPQ.LIST_LINE_ID AND C.PRICING_PHASE_ID = :B9 AND QPPROD.CONTEXT = C.PRODUCT_ATTRIBUTE_CONTEXT AND QPPROD.ATTRIBUTE = C.PRODUCT_ATTRIBUTE AND QPPROD.VALUE_FROM = C.PRODUCT_ATTR_VALUE AND QPPROD.PRICING_STATUS_CODE = :B3 AND C.QUALIFICATION_IND IN (:B15 , :B14 , :B13 , :B12 ) AND QPPROD.ATTRIBUTE_TYPE = :B11 AND C.EXCLUDER_FLAG = :B8 AND ROWNUM = 1) ) AND QPQ.QUALIFIER_DATATYPE IN (:B20 , :B19 , :B18 ) AND QPLATQ.VALUE_FROM BETWEEN QPQ.QUALIFIER_ATTR_VALUE AND QPQ.QUALIFIER_ATTR_VALUE_TO AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B7 ) OR QPH.CURRENCY_CODE IS NULL) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B8 VALIDATED_FLAG, :B8 APPLIED_FLAG, :B10 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B8 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_T YPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG, QPLATQ.DERIVED_QUALIFIER_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLH.PRICING_PHASE_ID = :B9 AND QPLH.PRIC_PROD_ATTR_ONLY_FLAG = 'N' AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =' AND QPQ.QUALIFIER_ATTR_VALUE <> QPLATQ.VALUE_FROM AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID <> -1 AND ( QPQ.LIST_HEADER_ID IN (SELECT DISTINCT LIST_HEADER_ID FROM QP_PREQ_QUAL_TMP WHERE PRICING_PHASE_ID = :B9 AND PRICING_STATUS_CODE = :B3 ) OR QPQ.HEADER_QUALS_EXIST_FLAG = :B8 ) AND (NOT EXISTS (SELECT /*+ INDEX (qp_pa, QP_PRICING_ATTRIBUTES_N2) */ 'x' FROM QP_PRICING_ATTRIBUTES QP_PA WHERE QP_PA.LIST_LINE_ID = QPQ.LIST_LINE_ID AND ROWNUM = 1) OR EXISTS (SELECT /*+ ORDERED USE_NL(qpprod) INDEX (c, QP_PRICING_ATTRIBUTES_N2) */ 'x' FROM QP_PRICING_ATTRIBUTES C, QP_NPREQ_LINE_ATTRS_TMP QPPROD WHERE C.LIST_HEADER_ID = QPQ.LIST_HEADER_ID AND C.LIST_LINE_ID = QPQ.LIST_LINE_ID AND C.PRICING_PHASE_ID = :B9 AND QPPROD.CONTEXT = C.PRODUCT_ATTRIBUTE_CONTEXT AND QPPROD.ATTRIBUTE = C.PRODUCT_ATTRIBUTE AND QPPROD.VALUE_FROM = C.PRODUCT_ATTR_VALUE AND QPPROD.PRICING_STATUS_CODE = :B3 AND C.QUALIFICATION_IND IN (:B15 , :B14 , :B13 , :B12 ) AND QPPROD.ATTRIBUTE_TYPE = :B11 AND C.EXCLUDER_FLAG = :B8 AND ROWNUM = 1) ) AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B7 ) OR QPH.CURRENCY_CODE IS NULL) AND (NVL(QPH.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPH.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND (NVL(QPQ.END_DATE_ACTIVE, :B6 ) >= :B6 AND NVL(QPQ.START_DATE_ACTIVE, :B5 ) <= :B5 ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND ((NVL(QPLATQ.DERIVED_QUALIFIER_FLAG, 'N') = 'N') OR (QPLATQ.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y'))
dks0bsk9wzmxg	SELECT /*+ NO_EXPAND ORDERED USE_NL(QPL QPH QPRS) index(QPL QP_LIST_LINES_N5) index(qph qp_list_headers_b_n7) l_cur_mod */ QPL.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPL.LIST_LINE_TYPE_CODE, QPLINES.LINE_INDEX, QPL.AUTOMATIC_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.PRIMARY_UOM_FLAG, QPL.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE, QPL.OPERAND OPERAND_VALUE, QPL.NET_AMOUNT_FLAG, QPL.PRICING_GROUP_SEQUENCE, QPH.ASK_FOR_FLAG, QPH.LIST_TYPE_CODE CREATED_FROM_LIST_TYPE, QPL.PRICING_PHASE_ID, QPL.PRICE_BREAK_TYPE_CODE, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.OVERRIDE_FLAG, QPL.BENEFIT_QTY, QPL.BENEFIT_UOM_CODE, QPL.LIST_LINE_NO, QPL.ACCRUAL_FLAG, QPL.ACCRUAL_CONVERSION_RATE, QPL.ESTIM_ACCRUAL_RATE, QPH.LIMIT_EXISTS_FLAG HEADER_LIMIT_EXISTS, QPL.LIMIT_EXISTS_FLAG LINE_LIMIT_EXISTS, QPL.CHARGE_TYPE_CODE, QPL.CHARGE_SUBTYPE_CODE, QPL.ACCUM_CONTEXT, QPL.ACCUM_ATTRIBUTE, QPL.ACCUM_ATTR_RUN_SRC_FLAG FROM QP_NPREQ_LINES_TMP QPLINES, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID AND QPH.ACTIVE_FLAG=:B1 AND ((QPH.ASK_FOR_FLAG = :B1 AND EXISTS (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' FROM QP_NPREQ_LINE_ATTRS_TMP LA WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B16 AND VALIDATED_FLAG = :B2 AND LIST_HEADER_ID = QPH.LIST_HEADER_ID AND LINE_INDEX = QPLINES.LINE_INDEX)) OR QPH.ASK_FOR_FLAG = :B2 ) AND QPL.PRICING_PHASE_ID=:B15 AND QPL.QUALIFICATION_IND = :B14 AND (QPLINES.PRICE_FLAG = :B1 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B1 )) AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE) OR QPH.CURRENCY_CODE IS NULL) AND (QPLINES.UNIT_PRICE IS NOT NULL OR QPLINES.USAGE_PRICING_TYPE = :B11 OR QPLINES.LINE_TYPE_CODE = :B10 ) AND (QPL.MODIFIER_LEVEL_CODE = QPLINES.LINE_TYPE_CODE OR (QPL.MODIFIER_LEVEL_CODE = :B9 AND NVL(:B3 , :B2 ) <> :B1 )) AND NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_FIRST_TYPE, NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X')) AND NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_SECOND_TYPE, NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X')) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND (NVL(:B3 , :B2 ) = :B1 AND QPL.LIST_LINE_TYPE_CODE NOT IN (:B8 , :B7 , :B6 , :B5 , :B4 ) OR NVL(:B3 , :B2 ) <> :B1 ) ORDER BY 4, 2
dm6ad863v40sc	SELECT /*+ leading(ctlgd, evn, ev1) use_nl(evn, ev1) */ ctlgd.rowid, ev1.event_id FROM xla_events ev1, xla_transaction_entities_upg evn, ra_cust_trx_line_gl_dist ctlgd WHERE ctlgd.account_set_flag = 'N' AND ctlgd.event_id IS NULL AND evn.entity_code = 'TRANSACTIONS' AND evn.application_id = 222 AND ev1.entity_id = evn.entity_id AND evn.application_id = 222 AND nvl(evn.source_id_int_1, -99) = ctlgd.customer_trx_id AND evn.ledger_id = ctlgd.set_of_books_id AND ev1.application_id = 222 AND ctlgd.posting_control_id = nvl(ev1.reference_num_1, -3) AND nvl(ev1.event_date, to_date('01-01-1900', 'DD-MM-YYYY')) = nvl(ctlgd.gl_date, to_date('01-01-1900', 'DD-MM-YYYY')) AND (((ctlgd.posting_control_id = -3) AND (ev1.event_status_code <> 'P')) OR ((ctlgd.posting_control_id <> -3) AND (ev1.event_status_code = 'P' ))) AND ctlgd.customer_trx_id = :b_xla_from_doc_id AND ctlgd.customer_trx_id = :b_xla_to_doc_id
drt9k4tpvph64	SELECT AR_TAX.LOCATION_SEGMENT_ID, AR_TAX.ORG_ID, AR_TAX.TAX_LINE_ID, AR_TAX.VAT_TAX_ID, AR_TAX.SET_OF_BOOKS_ID, NVL(AR_REC.GL_DATE, TRUNC(SYSDATE)) FROM RA_CUSTOMER_TRX_LINES AR_TAX, RA_CUST_TRX_LINE_GL_DIST AR_REC WHERE AR_TAX.CUSTOMER_TRX_LINE_ID = :B1 AND AR_TAX.CUSTOMER_TRX_ID = AR_REC.CUSTOMER_TRX_ID AND AR_REC.ACCOUNT_CLASS = 'REC' AND AR_REC.LATEST_REC_FLAG = 'Y'
ds9gjnp0un99w	UPDATE ZX_LINES_DET_FACTORS SET EVENT_ID = :B288 , INTERNAL_ORGANIZATION_ID = :B274 , EVENT_TYPE_CODE = :B273 , DOC_EVENT_STATUS = :B287 , LINE_LEVEL_ACTION = :B272 , LINE_CLASS = NVL(:B271 , :B278 ), TRX_DATE = :B270 , TRX_DOC_REVISION = :B269 , LEDGER_ID = :B268 , TRX_CURRENCY_CODE = :B267 , CURRENCY_CONVERSION_DATE = :B266 , CURRENCY_CONVERSION_RATE = :B265 , CURRENCY_CONVERSION_TYPE = :B264 , MINIMUM_ACCOUNTABLE_UNIT = :B263 , PRECISION = :B262 , TRX_LINE_CURRENCY_CODE = NVL(:B260 , :B261 ), TRX_LINE_CURRENCY_CONV_DATE = NVL(:B258 , :B259 ), TRX_LINE_CURRENCY_CONV_RATE = NVL(:B256 , :B257 ), TRX_LINE_CURRENCY_CONV_TYPE = NVL(:B254 , :B255 ), TRX_LINE_MAU = NVL(:B252 , :B253 ), TRX_LINE_PRECISION = NVL(:B250 , :B251 ), LEGAL_ENTITY_ID = :B249 , ESTABLISHMENT_ID = :B248 , RECEIVABLES_TRX_TYPE_ID = :B247 , DEFAULT_TAXATION_COUNTRY = NVL(:B246 , DEFAULT_TAXATION_COUNTRY), TRX_NUMBER = :B245 , TRX_LINE_NUMBER = :B244 , TRX_LINE_DESCRIPTION = :B243 , TRX_DESCRIPTION = :B242 , TRX_COMMUNICATED_DATE = :B241 , BATCH_SOURCE_ID = :B240 , BATCH_SOURCE_NAME = :B239 , DOC_SEQ_ID = :B238 , DOC_SEQ_NAME = :B237 , DOC_SEQ_VALUE = :B236 , TRX_DUE_DATE = :B235 , TRX_TYPE_DESCRIPTION = :B234 , DOCUMENT_SUB_TYPE = NVL(:B233 , DOCUMENT_SUB_TYPE), SUPPLIER_TAX_INVOICE_NUMBER = :B232 , SUPPLIER_TAX_INVOICE_DATE = :B231 , SUPPLIER_EXCHANGE_RATE = :B230 , TAX_INVOICE_DATE = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', TAX_INVOICE_DATE, NVL(:B229 , TAX_INVOICE_DATE)), TAX_INVOICE_NUMBER = :B228 , FIRST_PTY_ORG_ID = :B227 , TAX_EVENT_CLASS_CODE = :B286 , TAX_EVENT_TYPE_CODE = :B285 , RDNG_SHIP_TO_PTY_TX_PROF_ID = :B226 , RDNG_SHIP_FROM_PTY_TX_PROF_ID = :B225 , RDNG_BILL_TO_PTY_TX_PROF_ID = :B224 , RDNG_BILL_FROM_PTY_TX_PROF_ID = :B223 , RDNG_SHIP_TO_PTY_TX_P_ST_ID = :B222 , RDNG_SHIP_FROM_PTY_TX_P_ST_ID = :B221 , RDNG_BILL_TO_PTY_TX_P_ST_ID = :B220 , RDNG_BILL_FROM_PTY_TX_P_ST_ID = :B219 , LINE_INTENDED_USE = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', LINE_INTENDED_USE, NVL(:B218 , LINE_INTENDED_USE)), TRX_LINE_TYPE = :B217 , TRX_SHIPPING_DATE = :B216 , TRX_RECEIPT_DATE = :B215 , TRX_SIC_CODE = :B214 , FOB_POINT = :B213 , TRX_WAYBILL_NUMBER = :B212 , PRODUCT_ID = :B211 , PRODUCT_FISC_CLASSIFICATION = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', NVL(:B210 , PRODUCT_FISC_CLASSIFICATION)), PRODUCT_ORG_ID = :B209 , UOM_CODE = :B208 , PRODUCT_TYPE = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', PRODUCT_TYPE, NVL(:B207 , PRODUCT_TYPE)), PRODUCT_CODE = :B206 , PRODUCT_CATEGORY = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', PRODUCT_CATEGORY, NVL(:B205 , PRODUCT_CATEGORY)), PRODUCT_DESCRIPTION = :B204 , USER_DEFINED_FISC_CLASS = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', USER_DEFINED_FISC_CLASS, NVL(:B203 , USER_DEFINED_FISC_CLASS)), LINE_AMT = :B202 , TRX_LINE_QUANTITY = :B201 , UNIT_PRICE = :B200 , CASH_DISCOUNT = :B199 , VOLUME_DISCOUNT = :B198 , TRADING_DISCOUNT = :B197 , TRANSFER_CHARGE = :B196 , TRANSPORTATION_CHARGE = :B195 , INSURANCE_CHARGE = :B194 , OTHER_CHARGE = :B193 , ASSESSABLE_VALUE = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', ASSESSABLE_VALUE, NVL(:B192 , ASSESSABLE_VALUE)), ASSET_FLAG = :B191 , ASSET_NUMBER = :B190 , ASSET_ACCUM_DEPRECIATION = :B189 , ASSET_TYPE = :B188 , ASSET_COST = :B187 , RELATED_DOC_APPLICATION_ID = :B186 , RELATED_DOC_ENTITY_CODE = :B185 , RELATED_DOC_EVENT_CLASS_CODE = :B184 , RELATED_DOC_TRX_ID = :B183 , RELATED_DOC_NUMBER = :B182 , RELATED_DOC_DATE = :B181 , APPLIED_FROM_APPLICATION_ID = :B180 , APPLIED_FROM_ENTITY_CODE = :B179 , APPLIED_FROM_EVENT_CLASS_CODE = :B178 , APPLIED_FROM_TRX_ID = :B177 , APPLIED_FROM_LINE_ID = :B176 , APPLIED_FROM_TRX_NUMBER = :B175 , ADJUSTED_DOC_APPLICATION_ID = :B174 , ADJUSTED_DOC_ENTITY_CODE = :B173 , ADJUSTED_DOC_EVENT_CLASS_CODE = :B172 , ADJUSTED_DOC_TRX_ID = :B171 , ADJUSTED_DOC_LINE_ID = :B170 , ADJUSTED_DOC_NUMBER = :B169 , ADJUSTED_DOC_DATE = :B168 , APPLIED_TO_APPLICATION_ID = :B167 , APPLIED_ TO_ENTITY_CODE = :B166 , APPLIED_TO_EVENT_CLASS_CODE = :B165 , APPLIED_TO_TRX_ID = :B164 , APPLIED_TO_TRX_LINE_ID = :B163 , TRX_ID_LEVEL2 = :B162 , TRX_ID_LEVEL3 = :B161 , TRX_ID_LEVEL4 = :B160 , TRX_ID_LEVEL5 = :B159 , TRX_ID_LEVEL6 = :B158 , TRX_BUSINESS_CATEGORY = DECODE(USER_UPD_DET_FACTORS_FLAG, 'Y', TRX_BUSINESS_CATEGORY, NVL(:B157 , TRX_BUSINESS_CATEGORY)), EXEMPT_CERTIFICATE_NUMBER = :B156 , EXEMPT_REASON = :B155 , HISTORICAL_FLAG = NVL(HISTORICAL_FLAG, :B154 ), TRX_LINE_GL_DATE = :B153 , LINE_AMT_INCLUDES_TAX_FLAG = :B152 , ACCOUNT_CCID = :B151 , ACCOUNT_STRING = :B150 , MERCHANT_PARTY_TAX_PROF_ID = :B149 , HQ_ESTB_PARTY_TAX_PROF_ID = :B148 , NUMERIC1 = :B147 , NUMERIC2 = :B146 , NUMERIC3 = :B145 , NUMERIC4 = :B144 , NUMERIC5 = :B143 , NUMERIC6 = :B142 , NUMERIC7 = :B141 , NUMERIC8 = :B140 , NUMERIC9 = :B139 , NUMERIC10 = :B138 , CHAR1 = :B137 , CHAR2 = :B136 , CHAR3 = :B135 , CHAR4 = :B134 , CHAR5 = :B133 , CHAR6 = :B132 , CHAR7 = :B131 , CHAR8 = :B130 , CHAR9 = :B129 , CHAR10 = :B128 , DATE1 = :B127 , DATE2 = :B126 , DATE3 = :B125 , DATE4 = :B124 , DATE5 = :B123 , DATE6 = :B122 , DATE7 = :B121 , DATE8 = :B120 , DATE9 = :B119 , DATE10 = :B118 , MERCHANT_PARTY_NAME = :B117 , MERCHANT_PARTY_DOCUMENT_NUMBER = :B116 , MERCHANT_PARTY_REFERENCE = :B115 , MERCHANT_PARTY_TAXPAYER_ID = :B114 , MERCHANT_PARTY_TAX_REG_NUMBER = :B113 , MERCHANT_PARTY_ID = :B112 , MERCHANT_PARTY_COUNTRY = :B111 , SHIP_TO_LOCATION_ID = :B110 , SHIP_FROM_LOCATION_ID = :B109 , POA_LOCATION_ID = :B108 , POO_LOCATION_ID = :B107 , BILL_TO_LOCATION_ID = :B106 , BILL_FROM_LOCATION_ID = :B105 , PAYING_LOCATION_ID = :B104 , OWN_HQ_LOCATION_ID = :B103 , TRADING_HQ_LOCATION_ID = :B102 , POC_LOCATION_ID = :B101 , POI_LOCATION_ID = :B100 , POD_LOCATION_ID = :B99 , TITLE_TRANSFER_LOCATION_ID = :B98 , SHIP_TO_PARTY_TAX_PROF_ID = :B97 , SHIP_FROM_PARTY_TAX_PROF_ID = :B96 , POA_PARTY_TAX_PROF_ID = :B95 , POO_PARTY_TAX_PROF_ID = :B94 , PAYING_PARTY_TAX_PROF_ID = :B93 , OWN_HQ_PARTY_TAX_PROF_ID = :B92 , TRADING_HQ_PARTY_TAX_PROF_ID = :B91 , POI_PARTY_TAX_PROF_ID = :B90 , POD_PARTY_TAX_PROF_ID = :B89 , BILL_TO_PARTY_TAX_PROF_ID = :B88 , BILL_FROM_PARTY_TAX_PROF_ID = :B87 , TITLE_TRANS_PARTY_TAX_PROF_ID = :B86 , SHIP_TO_SITE_TAX_PROF_ID = :B85 , SHIP_FROM_SITE_TAX_PROF_ID = :B84 , POA_SITE_TAX_PROF_ID = :B83 , POO_SITE_TAX_PROF_ID = :B82 , PAYING_SITE_TAX_PROF_ID = :B81 , OWN_HQ_SITE_TAX_PROF_ID = :B80 , TRADING_HQ_SITE_TAX_PROF_ID = :B79 , POI_SITE_TAX_PROF_ID = :B78 , POD_SITE_TAX_PROF_ID = :B77 , BILL_TO_SITE_TAX_PROF_ID = :B76 , BILL_FROM_SITE_TAX_PROF_ID = :B75 , TITLE_TRANS_SITE_TAX_PROF_ID = :B74 , CTRL_HDR_TX_APPL_FLAG = :B73 , CTRL_TOTAL_LINE_TX_AMT = :B72 , CTRL_TOTAL_HDR_TX_AMT = :B71 , REF_DOC_APPLICATION_ID = :B70 , REF_DOC_ENTITY_CODE = :B69 , REF_DOC_EVENT_CLASS_CODE = :B68 , REF_DOC_TRX_ID = :B67 , REF_DOC_LINE_ID = :B66 , REF_DOC_LINE_QUANTITY = :B65 , TRX_LINE_DATE = :B64 , INPUT_TAX_CLASSIFICATION_CODE = :B63 , OUTPUT_TAX_CLASSIFICATION_CODE = :B62 , INTERNAL_ORG_LOCATION_ID = :B61 , PORT_OF_ENTRY_CODE = :B60 , TAX_REPORTING_FLAG = DECODE(:B58 , 'RECORD_WITH_NO_TAX' , 'N' , NVL(:B59 , :B284 )), TAX_AMT_INCLUDED_FLAG = :B57 , COMPOUNDING_TAX_FLAG = :B56 , SHIP_THIRD_PTY_ACCT_ID = :B55 , BILL_THIRD_PTY_ACCT_ID = :B54 , SHIP_THIRD_PTY_ACCT_SITE_ID = :B53 , BILL_THIRD_PTY_ACCT_SITE_ID = :B52 , SHIP_TO_CUST_ACCT_SITE_USE_ID = :B51 , BILL_TO_CUST_ACCT_SITE_USE_ID = :B50 , START_EXPENSE_DATE = :B49 , TRX_BATCH_ID = :B48 , APPLIED_TO_TRX_NUMBER = :B47 , SOURCE_APPLICATION_ID = :B46 , SOURCE_ENTITY_CODE = :B45 , SOURCE_EVENT_CLASS_CODE = :B44 , SOURCE_TRX_ID = :B43 , SOURCE_LINE_ID = :B42 , SOURCE_TRX_LEVEL_TYPE = :B41 , SOURCE_TAX_LINE_ID = :B40 , REF_DOC_TRX_LEVEL_TYPE = :B39 , APPLIED_TO_TRX_LEVEL_TYPE = :B38 , APPLIED_FROM_TRX_LEVEL_TYPE = :B37 , ADJUSTED_DOC_TRX_LEVEL_TYPE = :B36 , APPLICATION_DOC_STATUS = :B35 , TAX_PROC ESSING_COMPLETED_FLAG = :B34 , TAX_CALCULATION_DONE_FLAG = :B283 , OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1, HDR_TRX_USER_KEY1 = :B33 , HDR_TRX_USER_KEY2 = :B32 , HDR_TRX_USER_KEY3 = :B31 , HDR_TRX_USER_KEY4 = :B30 , HDR_TRX_USER_KEY5 = :B29 , HDR_TRX_USER_KEY6 = :B28 , LINE_TRX_USER_KEY1 = :B27 , LINE_TRX_USER_KEY2 = :B26 , LINE_TRX_USER_KEY3 = :B25 , LINE_TRX_USER_KEY4 = :B24 , LINE_TRX_USER_KEY5 = :B23 , LINE_TRX_USER_KEY6 = :B22 , EXEMPTION_CONTROL_FLAG = :B21 , EXEMPT_REASON_CODE = :B20 , INTERFACE_ENTITY_CODE = :B19 , INTERFACE_LINE_ID = :B18 , DEFAULTING_ATTRIBUTE1 = :B17 , DEFAULTING_ATTRIBUTE2 = :B16 , DEFAULTING_ATTRIBUTE3 = :B15 , DEFAULTING_ATTRIBUTE4 = :B14 , DEFAULTING_ATTRIBUTE5 = :B13 , DEFAULTING_ATTRIBUTE6 = :B12 , DEFAULTING_ATTRIBUTE7 = :B11 , DEFAULTING_ATTRIBUTE8 = :B10 , DEFAULTING_ATTRIBUTE9 = :B9 , DEFAULTING_ATTRIBUTE10 = :B8 , PROVNL_TAX_DETERMINATION_DATE = :B7 , HISTORICAL_TAX_CODE_ID = :B6 , GLOBAL_ATTRIBUTE_CATEGORY = :B5 , GLOBAL_ATTRIBUTE1 = :B4 , USER_UPD_DET_FACTORS_FLAG = NVL(:B3 , USER_UPD_DET_FACTORS_FLAG), TOTAL_INC_TAX_AMT = DECODE(:B1 , 'NO_CHANGE', TOTAL_INC_TAX_AMT, NVL(:B2 , 0)), ICX_SESSION_ID = DECODE (:B282 , 'CALCULATE_TAX', :B281 , NULL), LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID WHERE APPLICATION_ID = :B280 AND ENTITY_CODE = :B279 AND EVENT_CLASS_CODE = :B278 AND TRX_ID = :B277 AND TRX_LINE_ID = :B276 AND TRX_LEVEL_TYPE = :B275 AND NOT EXISTS (SELECT 'Y' FROM ZX_ERRORS_GT ERR_GT WHERE ERR_GT.APPLICATION_ID = :B292 AND ERR_GT.ENTITY_CODE = :B291 AND ERR_GT.EVENT_CLASS_CODE = :B290 AND ERR_GT.TRX_ID = :B289 )
fmvtkwzyaz67m	SELECT C.CONSTRAINT_ID, C.ENTITY_ID , C.ON_OPERATION_ACTION, C.COLUMN_NAME FROM OE_PC_CONSTRAINTS C WHERE C.ENTITY_ID = :B3 AND C.CONSTRAINED_OPERATION = :B2 AND EXISTS ( SELECT 'EXISTS' FROM OE_PC_ASSIGNMENTS A WHERE A.CONSTRAINT_ID = C.CONSTRAINT_ID AND ( A.RESPONSIBILITY_ID = :B5 OR A.RESPONSIBILITY_ID IS NULL) AND ( A.APPLICATION_ID = :B4 OR A.APPLICATION_ID IS NULL) AND NOT EXISTS ( SELECT 'EXISTS' FROM OE_PC_EXCLUSIONS E WHERE E.RESPONSIBILITY_ID = :B5 AND E.ASSIGNMENT_ID = A.ASSIGNMENT_ID AND E.APPLICATION_ID = :B4 ) ) AND NVL(C.ENABLED_FLAG, 'Y') = 'Y' AND ((:B1 IS NULL) OR NVL(C.QUALIFIER_ATTRIBUTE, :B1 ) = :B1 ) ORDER BY C.ON_OPERATION_ACTION
fqa353m4t2gvs	SELECT 'x' FROM DUAL WHERE EXISTS ( SELECT /*+ ORDERED */ 'x' FROM QP_LIST_HEADER_PHASES LHP, QP_LIST_HEADERS_B QPLH WHERE LHP.PRICING_PHASE_ID = :B1 AND QPLH.LIST_HEADER_ID = LHP.LIST_HEADER_ID AND QPLH.ACTIVE_FLAG = 'Y') OR EXISTS ( SELECT /*+ ORDERED */ 'x' FROM QP_LIST_LINES QPLL, QP_LIST_HEADERS_B QPLH WHERE QPLL.PRICING_PHASE_ID = :B1 AND QPLL.QUALIFICATION_IND IN (0, 4, 20) AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.ACTIVE_FLAG = 'Y')
gpcbywvqvk1n8	SELECT 'Y' FROM OE_ORDER_HOLDS WHERE HEADER_ID = :B1 AND RELEASED_FLAG = 'N'

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 761,947

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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