Recently I had an interesting case when I’ve been asked how to change the execution plan of one complex query without changing the code.
I’ve already had a lecture with similar title at 2012 in Oracle User Group Conference – more details you can find at the following link:
How to change the execution plan without changing the code
(sorry, It’s on Croatian, but should be understandable for a wider audience)
Prerequisite for using that method is Oracle 11g database, as I’m using SQL Plan Baseline feature in that example.
In this case I have Oracle 10g database which was released long time ago (in 2003).
Naturally, someone may ask why you are running production database for which you have to pay extremely expensive Extended Premium Support, instead of just upgrading to the newest Oracle database 19c where you can use thousands of new features and significantly lower down Oracle Support costs (because of Standard Oracle Support), significantly increase database performance (that leads to further cutting down required number of Oracle licenses) and use many of the new HA (High Availability) features, but that is another story.
Another issue is in that it’s not possible to change the problematic SQL code either because your PL/SQL package in constant use (meaning if you try to change the package and compile it, you’ll get a lot of latches – and blocking session) or because code has been generated by the client application (e.g. Oracle Forms or Java or .NET).
Furthermore, there is a dependency change issue – even if I change the problematic package, several other dependent packages will get the invalid state status.
That leads to issue with developing store procedures, especially in cases where you have intensive ESB (e.g. Kafka, Tibco, RabbitMQ, OSB, MQ Series) and Microservice architecture in place, but you haven’t performed exception handling thoroughly to cover all cases.
In case you are running Oracle 11g, you have solution for the first – PL/SQL package compilation case by using Edition Based Redefinition feature of Oracle database.
To summarize:
– you are running Oracle 10g in production where the latest release is 19c
– it’s not possible to deploy tuned code in production as the problematic package is in constant use + dependency chain (there are several other packages that depends on problematic one)
Thankfully 10g database introduced SQL Profiler feature which should replace well known Outline which is first introduced with Oracle 8i back in 1998.
Here is how you can change the execution plan without touching the code that works even in Oracle 10g.
--assume this is a bad execution plan (index unique scan)
select /*+ test01 */ * from emp e where e.empno = :a;
SQL_ID 6t1432yzy00sv, child number 0
-------------------------------------
select /*+ test01 */ * from emp e where e.empno = :a
Plan hash value: 2949544139
--------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 1 (100)| |
| 1 | TABLE ACCESS BY INDEX ROWID| EMP | 1 | 38 | 1 (0)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | PK_EMP | 1 | | 0 (0)| |
--------------------------------------------------------------------------------------
--assume this is a good plan (Full Table Scan)
select /*+ test02 full(e) */ * from emp e where e.empno = :a;
SQL_ID 927gwyxf104xy, child number 0
-------------------------------------
select /*+ test02 full(e) */ * from emp e where e.empno = :a
Plan hash value: 3956160932
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 3 (100)| |
|* 1 | TABLE ACCESS FULL| EMP | 1 | 38 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('18.1.0')
DB_VERSION('18.1.0')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "E"@"SEL$1")
END_OUTLINE_DATA
*/
--fixing the plan
declare
sqltext varchar2(4000);
h SYS.SQLPROF_ATTR;
begin
sqltext := 'select /*+ test01 */ * from emp e where e.empno = :a';
h := SYS.SQLPROF_ATTR(
q'[BEGIN_OUTLINE_DATA]',
q'[IGNORE_OPTIM_EMBEDDED_HINTS]',
q'[OPTIMIZER_FEATURES_ENABLE('18.1.0')]',
q'[DB_VERSION('18.1.0')]',
q'[ALL_ROWS]',
q'[OUTLINE_LEAF(@"SEL$1")]',
q'[FULL(@"SEL$1" "E"@"SEL$1")]',
q'[END_OUTLINE_DATA]');
DBMS_SQLTUNE.IMPORT_SQL_PROFILE (
sql_text => sqltext,
profile => h,
name => 'custom_profile_test',
description => 'applying custom profile ',
category => 'DEFAULT',
validate => TRUE,
replace => TRUE,
force_match => FALSE );
end;
--fixed plan
SQL_ID 6t1432yzy00sv, child number 1
-------------------------------------
select /*+ test01 */ * from emp e where e.empno = :a
Plan hash value: 3956160932
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 3 (100)| |
|* 1 | TABLE ACCESS FULL| EMP | 1 | 38 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
Note
-----
- SQL profile custom_profile_test used for this statement
Note that the latest plan has the same sql_id as troublesome query, but the child number is 1 instead of 0.
Also note that SQL Profile has been used for this statement, which is what I wanted.
I had to tune the problematic plan, and by using the anonymous procedure, all I have to do is to import SQL Profile and to assocoate it with the problematic SQL.
In case you have a more complex SQL, this is the code you can use (example from one of my engagements with Oracle Retail):
DECLARE
sql_txt CLOB;
h SYS.SQLPROF_ATTR;
PROCEDURE wa (p_line IN VARCHAR2) IS
BEGIN
SYS.DBMS_LOB.WRITEAPPEND(sql_txt, LENGTH(p_line), p_line);
END wa;
BEGIN
SYS.DBMS_LOB.CREATETEMPORARY(sql_txt, TRUE);
SYS.DBMS_LOB.OPEN(sql_txt, SYS.DBMS_LOB.LOB_READWRITE);
-- SQL Text pieces below do not have to be of same length.
-- So if you edit SQL Text (i.e. removing temporary Hints),
-- there is no need to edit or re-align unmodified pieces.
wa(q'[MERGE INTO RPM_PROMO_ITEM_LOC_EXPL_GTT TARGET USING (SELECT PRIC]');
wa(q'[E_EVENT_ID, TO_ITEM ITEM, TO_DIFF_ID DIFF_ID, TO_ITEM_PARENT ITE]');
wa(q'[M_PARENT, DEPT, CLASS, SUBCLASS, TO_LOCATION LOCATION, TO_ZONE_N]');
wa(q'[ODE_TYPE ZONE_NODE_TYPE, TO_ZONE_ID ZONE_ID, PROMO_START_DATE, P]');
wa(q'[ROMO_END_DATE, PROMO_ID, PROMO_DISPLAY_ID, PROMO_SECONDARY_IND, ]');
wa(q'[PROMO_COMP_ID, COMP_DISPLAY_ID, PROMO_DTL_ID, TYPE, CUSTOMER_TYP]');
wa(q'[E, DETAIL_SECONDARY_IND, DETAIL_START_DATE, DETAIL_END_DATE, DET]');
wa(q'[AIL_APPLY_TO_CODE, DETAIL_CHANGE_TYPE, DETAIL_CHANGE_AMOUNT, DET]');
wa(q'[AIL_CHANGE_CURRENCY, DETAIL_CHANGE_PERCENT, DETAIL_CHANGE_SELLIN]');
wa(q'[G_UOM, DETAIL_PRICE_GUIDE_ID, EXCEPTION_PARENT_ID, PROMO_ITEM_LO]');
wa(q'[C_EXPL_ID, MAX_HIER_LEVEL, TO_CUR_HIER_LEVEL CUR_HIER_LEVEL, TIM]');
wa(q'[EBASED_DTL_IND FROM (SELECT /*+ ORDERED */ T.PRICE_EVENT_ID, T.T]');
wa(q'[O_ITEM, T.TO_DIFF_ID, T.TO_ITEM_PARENT, ILEX.DEPT, ILEX.CLASS, I]');
wa(q'[LEX.SUBCLASS, T.TO_LOCATION, T.TO_ZONE_NODE_TYPE, T.TO_ZONE_ID, ]');
wa(q'[ILEX.PROMO_START_DATE, ILEX.PROMO_END_DATE, ILEX.PROMO_ID, ILEX.]');
wa(q'[PROMO_DISPLAY_ID, ILEX.PROMO_SECONDARY_IND, ILEX.PROMO_COMP_ID, ]');
wa(q'[ILEX.COMP_DISPLAY_ID, ILEX.PROMO_DTL_ID, ILEX.TYPE, ILEX.CUSTOME]');
wa(q'[R_TYPE, ILEX.DETAIL_SECONDARY_IND, ILEX.DETAIL_START_DATE, ILEX.]');
wa(q'[DETAIL_END_DATE, ILEX.DETAIL_APPLY_TO_CODE, ILEX.DETAIL_CHANGE_T]');
wa(q'[YPE, ILEX.DETAIL_CHANGE_AMOUNT, ILEX.DETAIL_CHANGE_CURRENCY, ILE]');
wa(q'[X.DETAIL_CHANGE_PERCENT, ILEX.DETAIL_CHANGE_SELLING_UOM, ILEX.DE]');
wa(q'[TAIL_PRICE_GUIDE_ID, ILEX.EXCEPTION_PARENT_ID, ILEX.PROMO_ITEM_L]');
wa(q'[OC_EXPL_ID, ILEX.MAX_HIER_LEVEL, T.TO_CUR_HIER_LEVEL, ILEX.TIMEB]');
wa(q'[ASED_DTL_IND, T.RANK, MAX(RANK) OVER (PARTITION BY T.PRICE_EVENT]');
wa(q'[_ID, ILEX.PROMO_DTL_ID, T.TO_ITEM, T.TO_DIFF_ID, T.TO_LOCATION, ]');
wa(q'[T.TO_ZONE_NODE_TYPE) MAX_RANK FROM ( SELECT /*+ CARDINALITY(ids ]');
wa(q'[10) USE_NL(IDS) ORDERED */ DISTINCT 0 RANK, RPI.DEPT, RPI.PRICE_]');
wa(q'[EVENT_ID, RPI.ITEM FROM_ITEM, NULL FROM_DIFF_ID, RPL.LOCATION FR]');
wa(q'[OM_LOCATION, RPL.ZONE_NODE_TYPE FROM_ZONE_NODE_TYPE, RPI.ITEM TO]');
wa(q'[_ITEM, RPI.DIFF_ID TO_DIFF_ID, NULL TO_ITEM_PARENT, RPL.LOCATION]');
wa(q'[ TO_LOCATION, RPL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, NULL TO_ZONE]');
wa(q'[_ID, :B5 TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS OBJ_NUMERIC_ID]');
wa(q'[_TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCATION R]');
wa(q'[PL WHERE RPI.BULK_CC_PE_ID = :B4 AND RPI.PRICE_EVENT_ID = VALUE(]');
wa(q'[IDS) AND RPL.PRICE_EVENT_ID = VALUE(IDS) AND RPI.MERCH_LEVEL_TYP]');
wa(q'[E = :B3 AND RPI.PE_MERCH_LEVEL = :B3 AND RPL.BULK_CC_PE_ID = RPI]');
wa(q'[.BULK_CC_PE_ID AND RPL.PRICE_EVENT_ID = RPI.PRICE_EVENT_ID AND R]');
wa(q'[PL.ITEMLOC_ID = RPI.ITEMLOC_ID AND RPL.ZONE_NODE_TYPE = :B2 AND ]');
wa(q'[ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(ids 10) USE_NL(IDS)]');
wa(q'[ ORDERED */ DISTINCT 0 RANK, RPI.DEPT, RPI.PRICE_EVENT_ID, RPI.I]');
wa(q'[TEM FROM_ITEM, NULL FROM_DIFF_ID, RZ.ZONE_ID FROM_LOCATION, :B2 ]');
wa(q'[FROM_ZONE_NODE_TYPE, RPI.ITEM TO_ITEM, NULL TO_DIFF_ID, NULL TO_]');
wa(q'[ITEM_PARENT, RPL.LOCATION TO_LOCATION, RPL.ZONE_NODE_TYPE TO_ZON]');
wa(q'[E_NODE_TYPE, RZ.ZONE_ID TO_ZONE_ID, :B9 TO_CUR_HIER_LEVEL FROM T]');
wa(q'[ABLE(CAST(:B1 AS OBJ_NUMERIC_ID_TABLE)) IDS, RPM_BULK_CC_PE_ITEM]');
wa(q'[ RPI, RPM_BULK_CC_PE_LOCATION RPL, RPM_MERCH_RETAIL_DEF_EXPL RMR]');
wa(q'[DE, RPM_ZONE RZ, RPM_ZONE_LOCATION RZL WHERE RPI.BULK_CC_PE_ID =]');
wa(q'[ :B4 AND RPI.PRICE_EVENT_ID = VALUE(IDS) AND RPL.PRICE_EVENT_ID ]');
wa(q'[= VALUE(IDS) AND RPI.MERCH_LEVEL_TYPE = :B8 AND RPI.PE_MERCH_LEV]');
wa(q'[EL = :B8 AND RPL.BULK_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.PRICE]');
wa(q'[_EVENT_ID = RPI.PRICE_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITEMLOC_]');
wa(q'[ID AND RZL.LOCATION = RPL.LOCATION AND RPL.ZONE_NODE_TYPE IN (:B]');
wa(q'[7 , :B6 ) AND RPL.ZONE_ID IS NULL AND RMRDE.DEPT = RPI.DEPT AND ]');
wa(q'[RMRDE.CLASS = RPI.CLASS AND RMRDE.SUBCLASS = RPI.SUBCLASS AND RM]');
wa(q'[RDE.REGULAR_ZONE_GROUP = RZ.ZONE_GROUP_ID AND RZ.ZONE_ID = RZL.Z]');
wa(q'[ONE_ID AND ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(ids 10) ]');
wa(q'[USE_NL(IDS) ORDERED */ DISTINCT 0 RANK, RPI.DEPT, RPI.PRICE_EVEN]');
wa(q'[T_ID, IM.ITEM_PARENT FROM_ITEM, NULL FROM_DIFF_ID, RPL.LOCATION ]');
wa(q'[FROM_LOCATION, RPL.ZONE_NODE_TYPE FROM_ZONE_NODE_TYPE, RPI.ITEM ]');
wa(q'[TO_ITEM, RPI.DIFF_ID TO_DIFF_ID, IM.ITEM_PARENT TO_ITEM_PARENT, ]');
wa(q'[RPL.LOCATION TO_LOCATION, RPL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, ]');
wa(q'[NULL TO_ZONE_ID, :B11 TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS O]');
wa(q'[BJ_NUMERIC_ID_TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_]');
wa(q'[PE_LOCATION RPL, ITEM_MASTER IM WHERE RPI.BULK_CC_PE_ID = :B4 AN]');
wa(q'[D RPI.PRICE_EVENT_ID = VALUE(IDS) AND RPL.PRICE_EVENT_ID = VALUE]');
wa(q'[(IDS) AND RPI.MERCH_LEVEL_TYPE = :B10 AND RPI.PE_MERCH_LEVEL = :]');
wa(q'[B10 AND RPL.BULK_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.PRICE_EVEN]');
wa(q'[T_ID = RPI.PRICE_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AN]');
wa(q'[D RPL.ZONE_NODE_TYPE = :B2 AND RPL.ZONE_ID IS NULL AND IM.ITEM =]');
wa(q'[ RPI.ITEM AND ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(ids 1]');
wa(q'[0) USE_NL(IDS) ORDERED */ DISTINCT 1 RANK, RPI.DEPT, RPI.PRICE_E]');
wa(q'[VENT_ID, IM.ITEM_PARENT FROM_ITEM, RPI.DIFF_ID FROM_DIFF_ID, RPL]');
wa(q'[.LOCATION FROM_LOCATION, RPL.ZONE_NODE_TYPE FROM_ZONE_NODE_TYPE,]');
wa(q'[ RPI.ITEM TO_ITEM, RPI.DIFF_ID TO_DIFF_ID, IM.ITEM_PARENT TO_ITE]');
wa(q'[M_PARENT, RPL.LOCATION TO_LOCATION, RPL.ZONE_NODE_TYPE TO_ZONE_N]');
wa(q'[ODE_TYPE, NULL TO_ZONE_ID, :B11 TO_CUR_HIER_LEVEL FROM TABLE(CAS]');
wa(q'[T(:B1 AS OBJ_NUMERIC_ID_TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RP]');
wa(q'[M_BULK_CC_PE_LOCATION RPL, ITEM_MASTER IM WHERE RPI.BULK_CC_PE_I]');
wa(q'[D = :B4 AND RPI.PRICE_EVENT_ID = VALUE(IDS) AND RPL.PRICE_EVENT_]');
wa(q'[ID = VALUE(IDS) AND RPI.MERCH_LEVEL_TYPE = :B10 AND RPI.PE_MERCH]');
wa(q'[_LEVEL = :B10 AND RPL.BULK_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.]');
wa(q'[PRICE_EVENT_ID = RPI.PRICE_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITE]');
wa(q'[MLOC_ID AND RPL.ZONE_NODE_TYPE = :B2 AND RPL.ZONE_ID IS NULL AND]');
wa(q'[ IM.ITEM = RPI.ITEM AND ROWNUM >= 1 UNION ALL SELECT /*+ CARDINA]');
wa(q'[LITY(ids 10) USE_NL(IDS) ORDERED */ DISTINCT 0 RANK, RPI.DEPT, R]');
wa(q'[PI.PRICE_EVENT_ID, RPI.ITEM FROM_ITEM, NULL FROM_DIFF_ID, RZ.ZON]');
wa(q'[E_ID FROM_LOCATION, :B2 FROM_ZONE_NODE_TYPE, RPI.ITEM TO_ITEM, R]');
wa(q'[PI.DIFF_ID TO_DIFF_ID, NULL TO_ITEM_PARENT, RPL.LOCATION TO_LOCA]');
wa(q'[TION, RPL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, RZ.ZONE_ID TO_ZONE_I]');
wa(q'[D, :B12 TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS OBJ_NUMERIC_ID_]');
wa(q'[TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCATION RP]');
wa(q'[L, RPM_MERCH_RETAIL_DEF_EXPL RMRDE, RPM_ZONE RZ, RPM_ZONE_LOCATI]');
wa(q'[ON RZL WHERE RPI.BULK_CC_PE_ID = :B4 AND RPI.PRICE_EVENT_ID = VA]');
wa(q'[LUE(IDS) AND RPL.PRICE_EVENT_ID = VALUE(IDS) AND RPI.MERCH_LEVEL]');
wa(q'[_TYPE = :B3 AND RPI.PE_MERCH_LEVEL = :B3 AND RPL.BULK_CC_PE_ID =]');
wa(q'[ RPI.BULK_CC_PE_ID AND RPL.PRICE_EVENT_ID = RPI.PRICE_EVENT_ID A]');
wa(q'[ND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AND RPL.ZONE_NODE_TYPE IN (:B]');
wa(q'[7 , :B6 ) AND RPL.ZONE_ID IS NULL AND RMRDE.DEPT = RPI.DEPT AND ]');
wa(q'[RMRDE.CLASS = RPI.CLASS AND RMRDE.SUBCLASS = RPI.SUBCLASS AND RM]');
wa(q'[RDE.REGULAR_ZONE_GROUP = RZ.ZONE_GROUP_ID AND RZ.ZONE_ID = RZL.Z]');
wa(q'[ONE_ID AND RZL.LOCATION = RPL.LOCATION AND RZL.LOC_TYPE = RPL.ZO]');
wa(q'[NE_NODE_TYPE AND ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(id]');
wa(q'[s 10) USE_NL(IDS) ORDERED */ DISTINCT 1 RANK, RPI.DEPT, RPI.PRIC]');
wa(q'[E_EVENT_ID, RPI.ITEM FROM_ITEM, RPI.DIFF_ID FROM_DIFF_ID, RZ.ZON]');
wa(q'[E_ID FROM_LOCATION, :B2 FROM_ZONE_NODE_TYPE, RPI.ITEM TO_ITEM, R]');
wa(q'[PI.DIFF_ID TO_DIFF_ID, NULL TO_ITEM_PARENT, RPL.LOCATION TO_LOCA]');
wa(q'[TION, RPL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, RZ.ZONE_ID TO_ZONE_I]');
wa(q'[D, :B12 TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS OBJ_NUMERIC_ID_]');
wa(q'[TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCATION RP]');
wa(q'[L, RPM_MERCH_RETAIL_DEF_EXPL RMRDE, RPM_ZONE RZ, RPM_ZONE_LOCATI]');
wa(q'[ON RZL WHERE RPI.BULK_CC_PE_ID = :B4 AND RPI.PRICE_EVENT_ID = VA]');
wa(q'[LUE(IDS) AND RPL.PRICE_EVENT_ID = VALUE(IDS) AND RPI.MERCH_LEVEL]');
wa(q'[_TYPE = :B3 AND RPI.PE_MERCH_LEVEL = :B3 AND RPL.BULK_CC_PE_ID =]');
wa(q'[ RPI.BULK_CC_PE_ID AND RPL.PRICE_EVENT_ID = RPI.PRICE_EVENT_ID A]');
wa(q'[ND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AND RPL.ZONE_NODE_TYPE IN (:B]');
wa(q'[7 , :B6 ) AND RPL.ZONE_ID IS NULL AND RMRDE.DEPT = RPI.DEPT AND ]');
wa(q'[RMRDE.CLASS = RPI.CLASS AND RMRDE.SUBCLASS = RPI.SUBCLASS AND RM]');
wa(q'[RDE.REGULAR_ZONE_GROUP = RZ.ZONE_GROUP_ID AND RZ.ZONE_ID = RZL.Z]');
wa(q'[ONE_ID AND RZL.LOCATION = RPL.LOCATION AND RZL.LOC_TYPE = RPL.ZO]');
wa(q'[NE_NODE_TYPE AND ROWNUM >= 1 UNION ALL SELECT DISTINCT 1 RANK, I]');
wa(q'[L.DEPT, IL.PRICE_EVENT_ID, IL.ITEM FROM_ITEM, NULL FROM_DIFF_ID,]');
wa(q'[ IL.LOCATION FROM_LOCATION, IL.ZONE_NODE_TYPE FROM_ZONE_NODE_TYP]');
wa(q'[E, IL.ITEM TO_ITEM, IL.DIFF_ID TO_DIFF_ID, NULL TO_ITEM_PARENT, ]');
wa(q'[IL.LOCATION TO_LOCATION, IL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, ZL]');
wa(q'[.ZONE_ID TO_ZONE_ID, :B12 TO_CUR_HIER_LEVEL FROM (SELECT /*+ CAR]');
wa(q'[DINALITY(ids 10) USE_NL(IDS) ORDERED */ RPI.PRICE_EVENT_ID, RPI.]');
wa(q'[DEPT, RPI.ITEM, RPL.LOCATION, RPL.ZONE_NODE_TYPE, RPI.DIFF_ID, R]');
wa(q'[MRDE.REGULAR_ZONE_GROUP FROM TABLE(CAST(:B1 AS OBJ_NUMERIC_ID_TA]');
wa(q'[BLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCATION RPL,]');
wa(q'[ RPM_MERCH_RETAIL_DEF_EXPL RMRDE WHERE RPI.BULK_CC_PE_ID = :B4 A]');
wa(q'[ND RPI.PRICE_EVENT_ID = VALUE(IDS) AND RPL.PRICE_EVENT_ID = VALU]');
wa(q'[E(IDS) AND RPI.MERCH_LEVEL_TYPE = :B3 AND RPI.PE_MERCH_LEVEL = :]');
wa(q'[B3 AND RPL.BULK_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.PRICE_EVENT]');
wa(q'[_ID = RPI.PRICE_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AND]');
wa(q'[ RPL.ZONE_NODE_TYPE IN (:B7 , :B6 ) AND RPL.ZONE_ID IS NULL AND ]');
wa(q'[RMRDE.DEPT = RPI.DEPT AND RMRDE.CLASS = RPI.CLASS AND RMRDE.SUBC]');
wa(q'[LASS = RPI.SUBCLASS AND ROWNUM > 0) IL, (SELECT RZ.ZONE_GROUP_ID]');
wa(q'[, RZ.ZONE_ID, RZL.LOCATION FROM RPM_ZONE RZ, RPM_ZONE_LOCATION R]');
wa(q'[ZL WHERE RZL.ZONE_ID = RZ.ZONE_ID AND ROWNUM > 0) ZL WHERE IL.RE]');
wa(q'[GULAR_ZONE_GROUP = ZL.ZONE_GROUP_ID (+) AND IL.LOCATION = ZL.LOC]');
wa(q'[ATION (+) AND ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(ids 1]');
wa(q'[0) USE_NL(IDS) ORDERED */ DISTINCT 0 RANK, RPI.DEPT, RPI.PRICE_E]');
wa(q'[VENT_ID, IM.ITEM_PARENT FROM_ITEM, NULL FROM_DIFF_ID, RZ.ZONE_ID]');
wa(q'[ FROM_LOCATION, :B2 FROM_ZONE_NODE_TYPE, RPI.ITEM TO_ITEM, RPI.D]');
wa(q'[IFF_ID TO_DIFF_ID, IM.ITEM_PARENT TO_ITEM_PARENT, RPL.LOCATION T]');
wa(q'[O_LOCATION, RPL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, RZ.ZONE_ID TO_]');
wa(q'[ZONE_ID, :B13 TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS OBJ_NUMER]');
wa(q'[IC_ID_TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCAT]');
wa(q'[ION RPL, ITEM_MASTER IM, RPM_MERCH_RETAIL_DEF_EXPL RMRDE, RPM_ZO]');
wa(q'[NE RZ, RPM_ZONE_LOCATION RZL WHERE RPI.BULK_CC_PE_ID = :B4 AND R]');
wa(q'[PI.PRICE_EVENT_ID = VALUE(IDS) AND RPL.PRICE_EVENT_ID = VALUE(ID]');
wa(q'[S) AND RPI.MERCH_LEVEL_TYPE = :B10 AND RPI.PE_MERCH_LEVEL = :B10]');
wa(q'[ AND IM.ITEM = RPI.ITEM AND RPL.BULK_CC_PE_ID = RPI.BULK_CC_PE_I]');
wa(q'[D AND RPL.PRICE_EVENT_ID = RPI.PRICE_EVENT_ID AND RPL.ITEMLOC_ID]');
wa(q'[ = RPI.ITEMLOC_ID AND RMRDE.DEPT = RPI.DEPT AND RMRDE.CLASS = RP]');
wa(q'[I.CLASS AND RMRDE.SUBCLASS = RPI.SUBCLASS AND RMRDE.REGULAR_ZONE]');
wa(q'[_GROUP = RZ.ZONE_GROUP_ID AND RZ.ZONE_ID = RZL.ZONE_ID AND RZL.L]');
wa(q'[OCATION = RPL.LOCATION AND RZL.LOC_TYPE = RPL.ZONE_NODE_TYPE AND]');
wa(q'[ RPL.ZONE_NODE_TYPE IN (:B7 , :B6 ) AND RPL.ZONE_ID IS NULL AND ]');
wa(q'[ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(ids 10) USE_NL(IDS)]');
wa(q'[ ORDERED */ DISTINCT 1 RANK, RPI.DEPT, RPI.PRICE_EVENT_ID, IM.IT]');
wa(q'[EM_PARENT FROM_ITEM, RPI.DIFF_ID FROM_DIFF_ID, RZ.ZONE_ID FROM_L]');
wa(q'[OCATION, :B2 FROM_ZONE_NODE_TYPE, RPI.ITEM TO_ITEM, RPI.DIFF_ID ]');
wa(q'[TO_DIFF_ID, IM.ITEM_PARENT TO_ITEM_PARENT, RPL.LOCATION TO_LOCAT]');
wa(q'[ION, RPL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, RZ.ZONE_ID TO_ZONE_ID]');
wa(q'[, :B13 TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS OBJ_NUMERIC_ID_T]');
wa(q'[ABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCATION RPL]');
wa(q'[, ITEM_MASTER IM, RPM_MERCH_RETAIL_DEF_EXPL RMRDE, RPM_ZONE RZ, ]');
wa(q'[RPM_ZONE_LOCATION RZL WHERE RPI.BULK_CC_PE_ID = :B4 AND RPI.PRIC]');
wa(q'[E_EVENT_ID = VALUE(IDS) AND RPL.PRICE_EVENT_ID = VALUE(IDS) AND ]');
wa(q'[RPI.MERCH_LEVEL_TYPE = :B10 AND RPI.PE_MERCH_LEVEL = :B10 AND IM]');
wa(q'[.ITEM = RPI.ITEM AND RPL.BULK_CC_PE_ID = RPI.BULK_CC_PE_ID AND R]');
wa(q'[PL.PRICE_EVENT_ID = RPI.PRICE_EVENT_ID AND RPL.ITEMLOC_ID = RPI.]');
wa(q'[ITEMLOC_ID AND RMRDE.DEPT = RPI.DEPT AND RMRDE.CLASS = RPI.CLASS]');
wa(q'[ AND RMRDE.SUBCLASS = RPI.SUBCLASS AND RMRDE.REGULAR_ZONE_GROUP ]');
wa(q'[= RZ.ZONE_GROUP_ID AND RZ.ZONE_ID = RZL.ZONE_ID AND RZL.LOCATION]');
wa(q'[ = RPL.LOCATION AND RZL.LOC_TYPE = RPL.ZONE_NODE_TYPE AND RPL.ZO]');
wa(q'[NE_NODE_TYPE IN (:B7 , :B6 ) AND RPL.ZONE_ID IS NULL AND ROWNUM ]');
wa(q'[>= 1 UNION ALL SELECT DISTINCT 1 RANK, IL.DEPT, IL.PRICE_EVENT_I]');
wa(q'[D, IL.ITEM_PARENT FROM_ITEM, NULL FROM_DIFF_ID, IL.LOCATION FROM]');
wa(q'[_LOCATION, IL.ZONE_NODE_TYPE FROM_ZONE_NODE_TYPE, IL.ITEM TO_ITE]');
wa(q'[M, IL.DIFF_ID TO_DIFF_ID, IL.ITEM_PARENT TO_ITEM_PARENT, IL.LOCA]');
wa(q'[TION TO_LOCATION, IL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, ZL.ZONE_I]');
wa(q'[D TO_ZONE_ID, :B13 TO_CUR_HIER_LEVEL FROM (SELECT /*+ CARDINALIT]');
wa(q'[Y(ids 10) USE_NL(IDS) ORDERED */ RPI.PRICE_EVENT_ID, RPI.DEPT, R]');
wa(q'[PI.DIFF_ID, IM.ITEM_PARENT, RPL.LOCATION, RPL.ZONE_NODE_TYPE, RP]');
wa(q'[I.ITEM, RMRDE.REGULAR_ZONE_GROUP FROM TABLE(CAST(:B1 AS OBJ_NUME]');
wa(q'[RIC_ID_TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCA]');
wa(q'[TION RPL, ITEM_MASTER IM, RPM_MERCH_RETAIL_DEF_EXPL RMRDE WHERE ]');
wa(q'[RPI.BULK_CC_PE_ID = :B4 AND RPI.PRICE_EVENT_ID = VALUE(IDS) AND ]');
wa(q'[RPL.PRICE_EVENT_ID = VALUE(IDS) AND RPI.MERCH_LEVEL_TYPE = :B10 ]');
wa(q'[AND RPI.PE_MERCH_LEVEL = :B10 AND IM.ITEM = RPI.ITEM AND RPL.BUL]');
wa(q'[K_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.PRICE_EVENT_ID = RPI.PRIC]');
wa(q'[E_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AND RPL.ZONE_NODE]');
wa(q'[_TYPE IN (:B7 , :B6 ) AND RPL.ZONE_ID IS NULL AND RMRDE.DEPT = R]');
wa(q'[PI.DEPT AND RMRDE.CLASS = RPI.CLASS AND RMRDE.SUBCLASS = RPI.SUB]');
wa(q'[CLASS AND ROWNUM > 0) IL, (SELECT RZ.ZONE_GROUP_ID, RZ.ZONE_ID, ]');
wa(q'[RZL.LOCATION FROM RPM_ZONE RZ, RPM_ZONE_LOCATION RZL WHERE RZL.Z]');
wa(q'[ONE_ID = RZ.ZONE_ID AND ROWNUM > 0) ZL WHERE IL.REGULAR_ZONE_GRO]');
wa(q'[UP = ZL.ZONE_GROUP_ID (+) AND IL.LOCATION = ZL.LOCATION (+) AND ]');
wa(q'[ROWNUM >= 1 UNION ALL SELECT /*+ CARDINALITY(ids 10) USE_NL(IDS)]');
wa(q'[ ORDERED */ DISTINCT 2 RANK, RPI.DEPT, RPI.PRICE_EVENT_ID, RPI.I]');
wa(q'[TEM FROM_ITEM, RPI.DIFF_ID FROM_DIFF_ID, RZ.ZONE_ID FROM_LOCATIO]');
wa(q'[N, :B2 FROM_ZONE_NODE_TYPE, RPI.ITEM TO_ITEM, RPI.DIFF_ID TO_DIF]');
wa(q'[F_ID, IM.ITEM_PARENT TO_ITEM_PARENT, RPL.LOCATION TO_LOCATION, R]');
wa(q'[PL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, RZ.ZONE_ID TO_ZONE_ID, :B13]');
wa(q'[ TO_CUR_HIER_LEVEL FROM TABLE(CAST(:B1 AS OBJ_NUMERIC_ID_TABLE))]');
wa(q'[ IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCATION RPL, ITEM]');
wa(q'[_MASTER IM, RPM_MERCH_RETAIL_DEF_EXPL RMRDE, RPM_ZONE RZ, RPM_ZO]');
wa(q'[NE_LOCATION RZL WHERE RPI.BULK_CC_PE_ID = :B4 AND RPI.PRICE_EVEN]');
wa(q'[T_ID = VALUE(IDS) AND RPL.PRICE_EVENT_ID = VALUE(IDS) AND RPI.ME]');
wa(q'[RCH_LEVEL_TYPE = :B10 AND RPI.PE_MERCH_LEVEL = :B10 AND RPL.BULK]');
wa(q'[_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.PRICE_EVENT_ID = RPI.PRICE]');
wa(q'[_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AND RPL.ZONE_NODE_]');
wa(q'[TYPE IN (:B7 , :B6 ) AND RMRDE.DEPT = RPI.DEPT AND RMRDE.CLASS =]');
wa(q'[ RPI.CLASS AND RMRDE.SUBCLASS = RPI.SUBCLASS AND RMRDE.REGULAR_Z]');
wa(q'[ONE_GROUP = RZ.ZONE_GROUP_ID AND RZ.ZONE_ID = RZL.ZONE_ID AND RZ]');
wa(q'[L.LOCATION = RPL.LOCATION AND RZL.LOC_TYPE = RPL.ZONE_NODE_TYPE ]');
wa(q'[AND RPL.ZONE_ID IS NULL AND RPI.ITEM = IM.ITEM AND ROWNUM >= 1 U]');
wa(q'[NION ALL SELECT DISTINCT 2 RANK, IL.DEPT, IL.PRICE_EVENT_ID, IL.]');
wa(q'[ITEM_PARENT FROM_ITEM, IL.DIFF_ID FROM_DIFF_ID, IL.LOCATION FROM]');
wa(q'[_LOCATION, IL.ZONE_NODE_TYPE FROM_ZONE_NODE_TYPE, IL.ITEM TO_ITE]');
wa(q'[M, IL.DIFF_ID TO_DIFF_ID, IL.ITEM_PARENT TO_ITEM_PARENT, IL.LOCA]');
wa(q'[TION TO_LOCATION, IL.ZONE_NODE_TYPE TO_ZONE_NODE_TYPE, ZL.ZONE_I]');
wa(q'[D TO_ZONE_ID, :B13 TO_CUR_HIER_LEVEL FROM (SELECT /*+ CARDINALIT]');
wa(q'[Y(ids 10) USE_NL(IDS) ORDERED */ RPI.PRICE_EVENT_ID, RPI.DEPT, I]');
wa(q'[M.ITEM_PARENT, RPI.DIFF_ID, RPL.LOCATION, RPL.ZONE_NODE_TYPE, RP]');
wa(q'[I.ITEM, RMRDE.REGULAR_ZONE_GROUP FROM TABLE(CAST(:B1 AS OBJ_NUME]');
wa(q'[RIC_ID_TABLE)) IDS, RPM_BULK_CC_PE_ITEM RPI, RPM_BULK_CC_PE_LOCA]');
wa(q'[TION RPL, ITEM_MASTER IM, RPM_MERCH_RETAIL_DEF_EXPL RMRDE WHERE ]');
wa(q'[RPI.BULK_CC_PE_ID = :B4 AND RPI.PRICE_EVENT_ID = VALUE(IDS) AND ]');
wa(q'[RPL.PRICE_EVENT_ID = VALUE(IDS) AND RPI.MERCH_LEVEL_TYPE = :B10 ]');
wa(q'[AND RPI.PE_MERCH_LEVEL = :B10 AND IM.ITEM = RPI.ITEM AND RPL.BUL]');
wa(q'[K_CC_PE_ID = RPI.BULK_CC_PE_ID AND RPL.PRICE_EVENT_ID = RPI.PRIC]');
wa(q'[E_EVENT_ID AND RPL.ITEMLOC_ID = RPI.ITEMLOC_ID AND RPL.ZONE_NODE]');
wa(q'[_TYPE IN (:B7 , :B6 ) AND RPL.ZONE_ID IS NULL AND RMRDE.DEPT = R]');
wa(q'[PI.DEPT AND RMRDE.CLASS = RPI.CLASS AND RMRDE.SUBCLASS = RPI.SUB]');
wa(q'[CLASS AND ROWNUM > 0) IL, (SELECT RZ.ZONE_GROUP_ID, RZ.ZONE_ID, ]');
wa(q'[RZL.LOCATION FROM RPM_ZONE RZ, RPM_ZONE_LOCATION RZL WHERE RZL.Z]');
wa(q'[ONE_ID = RZ.ZONE_ID AND ROWNUM > 0) ZL WHERE IL.REGULAR_ZONE_GRO]');
wa(q'[UP = ZL.ZONE_GROUP_ID (+) AND IL.LOCATION = ZL.LOCATION (+) AND ]');
wa(q'[ROWNUM >= 1) T, RPM_PROMO_ITEM_LOC_EXPL ILEX, RPM_PROMO_COMP RPC]');
wa(q'[, RPM_PROMO_DTL RPD WHERE ILEX.DEPT = T.DEPT AND ILEX.ITEM = T.F]');
wa(q'[ROM_ITEM AND NVL(ILEX.DIFF_ID, -999) = NVL(T.FROM_DIFF_ID, -999)]');
wa(q'[ AND ILEX.LOCATION = T.FROM_LOCATION AND ILEX.ZONE_NODE_TYPE = T]');
wa(q'[.FROM_ZONE_NODE_TYPE AND RPD.PROMO_DTL_ID = ILEX.PROMO_DTL_ID AN]');
wa(q'[D RPC.PROMO_COMP_ID = RPD.PROMO_COMP_ID AND ( :B20 IN (:B31 , :B]');
wa(q'[30 , :B29 , :B28 , :B27 ) OR ( :B20 IN (:B26 , :B25 , :B24 , :B2]');
wa(q'[3 , :B22 , :B21 ) AND RPC.CUSTOMER_TYPE IS NULL AND ILEX.CUSTOME]');
wa(q'[R_TYPE IS NULL) OR ( :B20 IN (:B19 , :B18 , :B17 , :B16 , :B15 ,]');
wa(q'[ :B14 ) AND RPC.CUSTOMER_TYPE = ILEX.CUSTOMER_TYPE))) WHERE RANK]');
wa(q'[ = MAX_RANK) SOURCE ON ( TARGET.PRICE_EVENT_ID = SOURCE.PRICE_EV]');
wa(q'[ENT_ID AND TARGET.ITEM = SOURCE.ITEM AND NVL(TARGET.DIFF_ID, -99]');
wa(q'[999) = NVL(SOURCE.DIFF_ID, -99999) AND TARGET.LOCATION = SOURCE.]');
wa(q'[LOCATION AND TARGET.ZONE_NODE_TYPE = SOURCE.ZONE_NODE_TYPE AND T]');
wa(q'[ARGET.PROMO_DTL_ID = SOURCE.PROMO_DTL_ID) WHEN NOT MATCHED THEN ]');
wa(q'[INSERT (PRICE_EVENT_ID, PROMO_ITEM_LOC_EXPL_ID, ITEM, DIFF_ID, I]');
wa(q'[TEM_PARENT, DEPT, CLASS, SUBCLASS, LOCATION, ZONE_NODE_TYPE, ZON]');
wa(q'[E_ID, PROMO_START_DATE, PROMO_END_DATE, PROMO_ID, PROMO_DISPLAY_]');
wa(q'[ID, PROMO_SECONDARY_IND, PROMO_COMP_ID, COMP_DISPLAY_ID, PROMO_D]');
wa(q'[TL_ID, TYPE, CUSTOMER_TYPE, DETAIL_SECONDARY_IND, DETAIL_START_D]');
wa(q'[ATE, DETAIL_END_DATE, DETAIL_APPLY_TO_CODE, DETAIL_CHANGE_TYPE, ]');
wa(q'[DETAIL_CHANGE_AMOUNT, DETAIL_CHANGE_CURRENCY, DETAIL_CHANGE_PERC]');
wa(q'[ENT, DETAIL_CHANGE_SELLING_UOM, DETAIL_PRICE_GUIDE_ID, EXCEPTION]');
wa(q'[_PARENT_ID, PROMO_COMP_MSG_TYPE, RPILE_ROWID, TIMEBASED_DTL_IND,]');
wa(q'[ ORIGINAL_PILE_ID, MAX_HIER_LEVEL, CUR_HIER_LEVEL) VALUES (SOURC]');
wa(q'[E.PRICE_EVENT_ID, RPM_PROM_IL_EXPL_SEQ.NEXTVAL, SOURCE.ITEM, SOU]');
wa(q'[RCE.DIFF_ID, SOURCE.ITEM_PARENT, SOURCE.DEPT, SOURCE.CLASS, SOUR]');
wa(q'[CE.SUBCLASS, SOURCE.LOCATION, SOURCE.ZONE_NODE_TYPE, SOURCE.ZONE]');
wa(q'[_ID, SOURCE.PROMO_START_DATE, SOURCE.PROMO_END_DATE, SOURCE.PROM]');
wa(q'[O_ID, SOURCE.PROMO_DISPLAY_ID, SOURCE.PROMO_SECONDARY_IND, SOURC]');
wa(q'[E.PROMO_COMP_ID, SOURCE.COMP_DISPLAY_ID, SOURCE.PROMO_DTL_ID, SO]');
wa(q'[URCE.TYPE, SOURCE.CUSTOMER_TYPE, SOURCE.DETAIL_SECONDARY_IND, SO]');
wa(q'[URCE.DETAIL_START_DATE, SOURCE.DETAIL_END_DATE, SOURCE.DETAIL_AP]');
wa(q'[PLY_TO_CODE, SOURCE.DETAIL_CHANGE_TYPE, SOURCE.DETAIL_CHANGE_AMO]');
wa(q'[UNT, SOURCE.DETAIL_CHANGE_CURRENCY, SOURCE.DETAIL_CHANGE_PERCENT]');
wa(q'[, SOURCE.DETAIL_CHANGE_SELLING_UOM, SOURCE.DETAIL_PRICE_GUIDE_ID]');
wa(q'[, SOURCE.EXCEPTION_PARENT_ID, NULL, NULL, SOURCE.TIMEBASED_DTL_I]');
wa(q'[ND, SOURCE.PROMO_ITEM_LOC_EXPL_ID, SOURCE.MAX_HIER_LEVEL, SOURCE]');
wa(q'[.CUR_HIER_LEVEL)]');
SYS.DBMS_LOB.CLOSE(sql_txt);
h := SYS.SQLPROF_ATTR(
q'[BEGIN_OUTLINE_DATA]',
q'[IGNORE_OPTIM_EMBEDDED_HINTS]',
q'[OPTIMIZER_FEATURES_ENABLE('11.2.0.3.1')]',
q'[DB_VERSION('11.2.0.3')]',
q'[FORCE_XML_QUERY_REWRITE]',
q'[XML_DML_RWT_STMT]',
q'[XMLINDEX_REWRITE]',
q'[XMLINDEX_REWRITE_IN_SELECT]',
q'[NO_COST_XML_QUERY_REWRITE]',
q'[OUTLINE_LEAF(@"SEL$ABDE6DFF")]',
q'[MERGE(@"SEL$6")]',
q'[OUTLINE_LEAF(@"SEL$193D1E52")]',
q'[OUTLINE_LEAF(@"SEL$11")]',
q'[OUTLINE_LEAF(@"SEL$A66D0F29")]',
q'[OUTLINE_LEAF(@"SEL$13")]',
q'[OUTLINE_LEAF(@"SEL$14")]',
q'[OUTLINE_LEAF(@"SEL$3461DC8E")]',
q'[OUTLINE_LEAF(@"SET$7BE537C4")]',
q'[OLD_PUSH_PRED(@"SEL$8A3193DA" "RMRDE"@"SEL$7" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$8A3193DA")]',
q'[MERGE(@"SEL$8")]',
q'[OUTLINE_LEAF(@"SEL$29F99543")]',
q'[MERGE(@"SEL$16")]',
q'[OUTLINE_LEAF(@"SEL$DC4B4145")]',
q'[MERGE(@"SEL$18")]',
q'[OUTLINE_LEAF(@"SEL$AA219DAE")]',
q'[OUTLINE_LEAF(@"SEL$23")]',
q'[OUTLINE_LEAF(@"SEL$56798371")]',
q'[OUTLINE_LEAF(@"SEL$25")]',
q'[OUTLINE_LEAF(@"SEL$26")]',
q'[OUTLINE_LEAF(@"SEL$EBE615B3")]',
q'[OUTLINE_LEAF(@"SET$61667F90")]',
q'[OLD_PUSH_PRED(@"SEL$3B673E5C" "RMRDE"@"SEL$19" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$3B673E5C")]',
q'[MERGE(@"SEL$20")]',
q'[OUTLINE_LEAF(@"SEL$E666FA22")]',
q'[OUTLINE_LEAF(@"SEL$31")]',
q'[OUTLINE_LEAF(@"SEL$835086F2")]',
q'[OUTLINE_LEAF(@"SEL$33")]',
q'[OUTLINE_LEAF(@"SEL$34")]',
q'[OUTLINE_LEAF(@"SEL$77BA0B0E")]',
q'[OUTLINE_LEAF(@"SET$6071500D")]',
q'[OLD_PUSH_PRED(@"SEL$A065B7E5" "RMRDE"@"SEL$27" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$A065B7E5")]',
q'[MERGE(@"SEL$28")]',
q'[OUTLINE_LEAF(@"SEL$739233A5")]',
q'[OUTLINE_LEAF(@"SEL$40")]',
q'[OUTLINE_LEAF(@"SEL$6CC0B070")]',
q'[OUTLINE_LEAF(@"SEL$42")]',
q'[OUTLINE_LEAF(@"SEL$43")]',
q'[OUTLINE_LEAF(@"SEL$1269F772")]',
q'[OUTLINE_LEAF(@"SET$013C4B19")]',
q'[OLD_PUSH_PRED(@"SEL$FF4A7D68" "RMRDE"@"SEL$36" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$FF4A7D68")]',
q'[MERGE(@"SEL$37")]',
q'[OUTLINE_LEAF(@"SEL$6B6449AE")]',
q'[OUTLINE_LEAF(@"SEL$44")]',
q'[OUTLINE_LEAF(@"SEL$35")]',
q'[OUTLINE_LEAF(@"SEL$DA9BBF6F")]',
q'[OUTLINE_LEAF(@"SEL$49")]',
q'[OUTLINE_LEAF(@"SEL$544607EE")]',
q'[OUTLINE_LEAF(@"SEL$51")]',
q'[OUTLINE_LEAF(@"SEL$52")]',
q'[OUTLINE_LEAF(@"SEL$210D83C0")]',
q'[OUTLINE_LEAF(@"SET$CA1A952B")]',
q'[OLD_PUSH_PRED(@"SEL$B3FB865B" "RMRDE"@"SEL$45" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$B3FB865B")]',
q'[MERGE(@"SEL$46")]',
q'[OUTLINE_LEAF(@"SEL$EF45A52A")]',
q'[OUTLINE_LEAF(@"SEL$57")]',
q'[OUTLINE_LEAF(@"SEL$09A927DA")]',
q'[OUTLINE_LEAF(@"SEL$59")]',
q'[OUTLINE_LEAF(@"SEL$60")]',
q'[OUTLINE_LEAF(@"SEL$35A3D408")]',
q'[OUTLINE_LEAF(@"SET$0EE36CEF")]',
q'[OLD_PUSH_PRED(@"SEL$D312661C" "RMRDE"@"SEL$53" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$D312661C")]',
q'[MERGE(@"SEL$54")]',
q'[OUTLINE_LEAF(@"SEL$93BB4834")]',
q'[OUTLINE_LEAF(@"SEL$66")]',
q'[OUTLINE_LEAF(@"SEL$2769D7CD")]',
q'[OUTLINE_LEAF(@"SEL$68")]',
q'[OUTLINE_LEAF(@"SEL$69")]',
q'[OUTLINE_LEAF(@"SEL$0687E345")]',
q'[OUTLINE_LEAF(@"SET$8C914BCC")]',
q'[OLD_PUSH_PRED(@"SEL$3B6E7E85" "RMRDE"@"SEL$62" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$3B6E7E85")]',
q'[MERGE(@"SEL$63")]',
q'[OUTLINE_LEAF(@"SEL$34C2C325")]',
q'[OUTLINE_LEAF(@"SEL$70")]',
q'[OUTLINE_LEAF(@"SEL$61")]',
q'[OUTLINE_LEAF(@"SEL$2562DEB9")]',
q'[OUTLINE_LEAF(@"SEL$75")]',
q'[OUTLINE_LEAF(@"SEL$39B419B5")]',
q'[OUTLINE_LEAF(@"SEL$77")]',
q'[OUTLINE_LEAF(@"SEL$78")]',
q'[OUTLINE_LEAF(@"SEL$16729207")]',
q'[OUTLINE_LEAF(@"SET$81DCDBDA")]',
q'[OLD_PUSH_PRED(@"SEL$BDF6F82C" "RMRDE"@"SEL$71" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$BDF6F82C")]',
q'[MERGE(@"SEL$72")]',
q'[OUTLINE_LEAF(@"SEL$B387F92E")]',
q'[OUTLINE_LEAF(@"SEL$84")]',
q'[OUTLINE_LEAF(@"SEL$F8DF03ED")]',
q'[OUTLINE_LEAF(@"SEL$86")]',
q'[OUTLINE_LEAF(@"SEL$87")]',
q'[OUTLINE_LEAF(@"SEL$907BFD88")]',
q'[OUTLINE_LEAF(@"SET$34AE3B66")]',
q'[OLD_PUSH_PRED(@"SEL$0E835E3A" "RMRDE"@"SEL$80" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$0E835E3A")]',
q'[MERGE(@"SEL$81")]',
q'[OUTLINE_LEAF(@"SEL$839AE4A5")]',
q'[OUTLINE_LEAF(@"SEL$88")]',
q'[OUTLINE_LEAF(@"SEL$79")]',
q'[OUTLINE_LEAF(@"SET$1")]',
q'[OUTLINE_LEAF(@"SEL$4")]',
q'[OUTLINE_LEAF(@"SEL$5428C7F1")]',
q'[MERGE(@"SEL$2")]',
q'[MERGE(@"SEL$3")]',
q'[OUTLINE_LEAF(@"SEL$362A9158")]',
q'[MERGE(@"SEL$92")]',
q'[OUTLINE_LEAF(@"SEL$58EF4AB8")]',
q'[OUTLINE_LEAF(@"SEL$97")]',
q'[OUTLINE_LEAF(@"SEL$0EF0B205")]',
q'[OUTLINE_LEAF(@"SEL$99")]',
q'[OUTLINE_LEAF(@"SEL$100")]',
q'[OUTLINE_LEAF(@"SEL$FCD49EB1")]',
q'[OUTLINE_LEAF(@"SET$A928D9C2")]',
q'[OLD_PUSH_PRED(@"SEL$A6513D81" "RMRDE"@"SEL$93" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$A6513D81")]',
q'[MERGE(@"SEL$94")]',
q'[OUTLINE_LEAF(@"SEL$D329535F")]',
q'[MERGE(@"SEL$102")]',
q'[OUTLINE_LEAF(@"SEL$7C853860")]',
q'[MERGE(@"SEL$104")]',
q'[OUTLINE_LEAF(@"SEL$C7DD480F")]',
q'[OUTLINE_LEAF(@"SEL$109")]',
q'[OUTLINE_LEAF(@"SEL$2AA80680")]',
q'[OUTLINE_LEAF(@"SEL$111")]',
q'[OUTLINE_LEAF(@"SEL$112")]',
q'[OUTLINE_LEAF(@"SEL$886431FB")]',
q'[OUTLINE_LEAF(@"SET$FEADF573")]',
q'[OLD_PUSH_PRED(@"SEL$609B08DB" "RMRDE"@"SEL$105" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$609B08DB")]',
q'[MERGE(@"SEL$106")]',
q'[OUTLINE_LEAF(@"SEL$759B359D")]',
q'[OUTLINE_LEAF(@"SEL$117")]',
q'[OUTLINE_LEAF(@"SEL$5989E56E")]',
q'[OUTLINE_LEAF(@"SEL$119")]',
q'[OUTLINE_LEAF(@"SEL$120")]',
q'[OUTLINE_LEAF(@"SEL$19E0C56C")]',
q'[OUTLINE_LEAF(@"SET$D63FDE2A")]',
q'[OLD_PUSH_PRED(@"SEL$92E3B30F" "RMRDE"@"SEL$113" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$92E3B30F")]',
q'[MERGE(@"SEL$114")]',
q'[OUTLINE_LEAF(@"SEL$A98FE7C3")]',
q'[OUTLINE_LEAF(@"SEL$126")]',
q'[OUTLINE_LEAF(@"SEL$E68CF370")]',
q'[OUTLINE_LEAF(@"SEL$128")]',
q'[OUTLINE_LEAF(@"SEL$129")]',
q'[OUTLINE_LEAF(@"SEL$ACA617ED")]',
q'[OUTLINE_LEAF(@"SET$9E98C185")]',
q'[OLD_PUSH_PRED(@"SEL$ECFFA1E1" "RMRDE"@"SEL$122" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$ECFFA1E1")]',
q'[MERGE(@"SEL$123")]',
q'[OUTLINE_LEAF(@"SEL$5F49C9CA")]',
q'[OUTLINE_LEAF(@"SEL$130")]',
q'[OUTLINE_LEAF(@"SEL$121")]',
q'[OUTLINE_LEAF(@"SEL$7D2E1154")]',
q'[OUTLINE_LEAF(@"SEL$135")]',
q'[OUTLINE_LEAF(@"SEL$EC6B20CD")]',
q'[OUTLINE_LEAF(@"SEL$137")]',
q'[OUTLINE_LEAF(@"SEL$138")]',
q'[OUTLINE_LEAF(@"SEL$5A876370")]',
q'[OUTLINE_LEAF(@"SET$D7816B12")]',
q'[OLD_PUSH_PRED(@"SEL$08BE9987" "RMRDE"@"SEL$131" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$08BE9987")]',
q'[MERGE(@"SEL$132")]',
q'[OUTLINE_LEAF(@"SEL$9B0E7215")]',
q'[OUTLINE_LEAF(@"SEL$143")]',
q'[OUTLINE_LEAF(@"SEL$0C0B3338")]',
q'[OUTLINE_LEAF(@"SEL$145")]',
q'[OUTLINE_LEAF(@"SEL$146")]',
q'[OUTLINE_LEAF(@"SEL$BEC9EB05")]',
q'[OUTLINE_LEAF(@"SET$27639C96")]',
q'[OLD_PUSH_PRED(@"SEL$3C5FD19C" "RMRDE"@"SEL$139" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$3C5FD19C")]',
q'[MERGE(@"SEL$140")]',
q'[OUTLINE_LEAF(@"SEL$2333EF74")]',
q'[OUTLINE_LEAF(@"SEL$152")]',
q'[OUTLINE_LEAF(@"SEL$6A616D60")]',
q'[OUTLINE_LEAF(@"SEL$154")]',
q'[OUTLINE_LEAF(@"SEL$155")]',
q'[OUTLINE_LEAF(@"SEL$D87DD315")]',
q'[OUTLINE_LEAF(@"SET$8C806512")]',
q'[OLD_PUSH_PRED(@"SEL$211F7714" "RMRDE"@"SEL$148" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$211F7714")]',
q'[MERGE(@"SEL$149")]',
q'[OUTLINE_LEAF(@"SEL$3E114BED")]',
q'[OUTLINE_LEAF(@"SEL$156")]',
q'[OUTLINE_LEAF(@"SEL$147")]',
q'[OUTLINE_LEAF(@"SEL$F0D18AAF")]',
q'[OUTLINE_LEAF(@"SEL$161")]',
q'[OUTLINE_LEAF(@"SEL$8DAFD586")]',
q'[OUTLINE_LEAF(@"SEL$163")]',
q'[OUTLINE_LEAF(@"SEL$164")]',
q'[OUTLINE_LEAF(@"SEL$74E2D305")]',
q'[OUTLINE_LEAF(@"SET$4482F871")]',
q'[OLD_PUSH_PRED(@"SEL$4FA37A56" "RMRDE"@"SEL$157" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$4FA37A56")]',
q'[MERGE(@"SEL$158")]',
q'[OUTLINE_LEAF(@"SEL$DA07537C")]',
q'[OUTLINE_LEAF(@"SEL$170")]',
q'[OUTLINE_LEAF(@"SEL$158256AE")]',
q'[OUTLINE_LEAF(@"SEL$172")]',
q'[OUTLINE_LEAF(@"SEL$173")]',
q'[OUTLINE_LEAF(@"SEL$9D92F63C")]',
q'[OUTLINE_LEAF(@"SET$1891BEE8")]',
q'[OLD_PUSH_PRED(@"SEL$68D11BD3" "RMRDE"@"SEL$166" ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT") ("SUBCLASS"."SUBCLASS" "SUBCLASS"."CLASS" "SUBCLASS"."DEPT"))]',
q'[OUTLINE_LEAF(@"SEL$68D11BD3")]',
q'[MERGE(@"SEL$167")]',
q'[OUTLINE_LEAF(@"SEL$03F8EF75")]',
q'[OUTLINE_LEAF(@"SEL$174")]',
q'[OUTLINE_LEAF(@"SEL$165")]',
q'[OUTLINE_LEAF(@"SET$11")]',
q'[OUTLINE_LEAF(@"SEL$90")]',
q'[OUTLINE_LEAF(@"SEL$89")]',
q'[OUTLINE_LEAF(@"MRG$1")]',
q'[OUTLINE(@"SEL$5")]',
q'[OUTLINE(@"SEL$6")]',
q'[OUTLINE(@"SEL$9")]',
q'[OUTLINE(@"SEL$10")]',
q'[OUTLINE(@"SEL$12")]',
q'[OUTLINE(@"SET$2")]',
q'[OUTLINE(@"SEL$8A3193DA")]',
q'[MERGE(@"SEL$8")]',
q'[OUTLINE(@"SEL$7")]',
q'[OUTLINE(@"SEL$8")]',
q'[OUTLINE(@"SEL$15")]',
q'[OUTLINE(@"SEL$16")]',
q'[OUTLINE(@"SEL$17")]',
q'[OUTLINE(@"SEL$18")]',
q'[OUTLINE(@"SEL$21")]',
q'[OUTLINE(@"SEL$22")]',
q'[OUTLINE(@"SEL$24")]',
q'[OUTLINE(@"SET$3")]',
q'[OUTLINE(@"SEL$3B673E5C")]',
q'[MERGE(@"SEL$20")]',
q'[OUTLINE(@"SEL$19")]',
q'[OUTLINE(@"SEL$20")]',
q'[OUTLINE(@"SEL$29")]',
q'[OUTLINE(@"SEL$30")]',
q'[OUTLINE(@"SEL$32")]',
q'[OUTLINE(@"SET$4")]',
q'[OUTLINE(@"SEL$A065B7E5")]',
q'[MERGE(@"SEL$28")]',
q'[OUTLINE(@"SEL$27")]',
q'[OUTLINE(@"SEL$28")]',
q'[OUTLINE(@"SEL$38")]',
q'[OUTLINE(@"SEL$39")]',
q'[OUTLINE(@"SEL$41")]',
q'[OUTLINE(@"SET$5")]',
q'[OUTLINE(@"SEL$FF4A7D68")]',
q'[MERGE(@"SEL$37")]',
q'[OUTLINE(@"SEL$36")]',
q'[OUTLINE(@"SEL$37")]',
q'[OUTLINE(@"SEL$47")]',
q'[OUTLINE(@"SEL$48")]',
q'[OUTLINE(@"SEL$50")]',
q'[OUTLINE(@"SET$6")]',
q'[OUTLINE(@"SEL$B3FB865B")]',
q'[MERGE(@"SEL$46")]',
q'[OUTLINE(@"SEL$45")]',
q'[OUTLINE(@"SEL$46")]',
q'[OUTLINE(@"SEL$55")]',
q'[OUTLINE(@"SEL$56")]',
q'[OUTLINE(@"SEL$58")]',
q'[OUTLINE(@"SET$7")]',
q'[OUTLINE(@"SEL$D312661C")]',
q'[MERGE(@"SEL$54")]',
q'[OUTLINE(@"SEL$53")]',
q'[OUTLINE(@"SEL$54")]',
q'[OUTLINE(@"SEL$64")]',
q'[OUTLINE(@"SEL$65")]',
q'[OUTLINE(@"SEL$67")]',
q'[OUTLINE(@"SET$8")]',
q'[OUTLINE(@"SEL$3B6E7E85")]',
q'[MERGE(@"SEL$63")]',
q'[OUTLINE(@"SEL$62")]',
q'[OUTLINE(@"SEL$63")]',
q'[OUTLINE(@"SEL$73")]',
q'[OUTLINE(@"SEL$74")]',
q'[OUTLINE(@"SEL$76")]',
q'[OUTLINE(@"SET$9")]',
q'[OUTLINE(@"SEL$BDF6F82C")]',
q'[MERGE(@"SEL$72")]',
q'[OUTLINE(@"SEL$71")]',
q'[OUTLINE(@"SEL$72")]',
q'[OUTLINE(@"SEL$82")]',
q'[OUTLINE(@"SEL$83")]',
q'[OUTLINE(@"SEL$85")]',
q'[OUTLINE(@"SET$10")]',
q'[OUTLINE(@"SEL$0E835E3A")]',
q'[MERGE(@"SEL$81")]',
q'[OUTLINE(@"SEL$80")]',
q'[OUTLINE(@"SEL$81")]',
q'[OUTLINE(@"SEL$1")]',
q'[OUTLINE(@"SEL$2")]',
q'[OUTLINE(@"SEL$3")]',
q'[OUTLINE(@"SEL$91")]',
q'[OUTLINE(@"SEL$92")]',
q'[OUTLINE(@"SEL$95")]',
q'[OUTLINE(@"SEL$96")]',
q'[OUTLINE(@"SEL$98")]',
q'[OUTLINE(@"SET$12")]',
q'[OUTLINE(@"SEL$A6513D81")]',
q'[MERGE(@"SEL$94")]',
q'[OUTLINE(@"SEL$93")]',
q'[OUTLINE(@"SEL$94")]',
q'[OUTLINE(@"SEL$101")]',
q'[OUTLINE(@"SEL$102")]',
q'[OUTLINE(@"SEL$103")]',
q'[OUTLINE(@"SEL$104")]',
q'[OUTLINE(@"SEL$107")]',
q'[OUTLINE(@"SEL$108")]',
q'[OUTLINE(@"SEL$110")]',
q'[OUTLINE(@"SET$13")]',
q'[OUTLINE(@"SEL$609B08DB")]',
q'[MERGE(@"SEL$106")]',
q'[OUTLINE(@"SEL$105")]',
q'[OUTLINE(@"SEL$106")]',
q'[OUTLINE(@"SEL$115")]',
q'[OUTLINE(@"SEL$116")]',
q'[OUTLINE(@"SEL$118")]',
q'[OUTLINE(@"SET$14")]',
q'[OUTLINE(@"SEL$92E3B30F")]',
q'[MERGE(@"SEL$114")]',
q'[OUTLINE(@"SEL$113")]',
q'[OUTLINE(@"SEL$114")]',
q'[OUTLINE(@"SEL$124")]',
q'[OUTLINE(@"SEL$125")]',
q'[OUTLINE(@"SEL$127")]',
q'[OUTLINE(@"SET$15")]',
q'[OUTLINE(@"SEL$ECFFA1E1")]',
q'[MERGE(@"SEL$123")]',
q'[OUTLINE(@"SEL$122")]',
q'[OUTLINE(@"SEL$123")]',
q'[OUTLINE(@"SEL$133")]',
q'[OUTLINE(@"SEL$134")]',
q'[OUTLINE(@"SEL$136")]',
q'[OUTLINE(@"SET$16")]',
q'[OUTLINE(@"SEL$08BE9987")]',
q'[MERGE(@"SEL$132")]',
q'[OUTLINE(@"SEL$131")]',
q'[OUTLINE(@"SEL$132")]',
q'[OUTLINE(@"SEL$141")]',
q'[OUTLINE(@"SEL$142")]',
q'[OUTLINE(@"SEL$144")]',
q'[OUTLINE(@"SET$17")]',
q'[OUTLINE(@"SEL$3C5FD19C")]',
q'[MERGE(@"SEL$140")]',
q'[OUTLINE(@"SEL$139")]',
q'[OUTLINE(@"SEL$140")]',
q'[OUTLINE(@"SEL$150")]',
q'[OUTLINE(@"SEL$151")]',
q'[OUTLINE(@"SEL$153")]',
q'[OUTLINE(@"SET$18")]',
q'[OUTLINE(@"SEL$211F7714")]',
q'[MERGE(@"SEL$149")]',
q'[OUTLINE(@"SEL$148")]',
q'[OUTLINE(@"SEL$149")]',
q'[OUTLINE(@"SEL$159")]',
q'[OUTLINE(@"SEL$160")]',
q'[OUTLINE(@"SEL$162")]',
q'[OUTLINE(@"SET$19")]',
q'[OUTLINE(@"SEL$4FA37A56")]',
q'[MERGE(@"SEL$158")]',
q'[OUTLINE(@"SEL$157")]',
q'[OUTLINE(@"SEL$158")]',
q'[OUTLINE(@"SEL$168")]',
q'[OUTLINE(@"SEL$169")]',
q'[OUTLINE(@"SEL$171")]',
q'[OUTLINE(@"SET$20")]',
q'[OUTLINE(@"SEL$68D11BD3")]',
q'[MERGE(@"SEL$167")]',
q'[OUTLINE(@"SEL$166")]',
q'[OUTLINE(@"SEL$167")]',
q'[NO_ACCESS(@"MRG$1" "from$_subquery$_168"@"MRG$1")]',
q'[NO_ACCESS(@"MRG$1" "SOURCE"@"MRG$1")]',
q'[FULL(@"MRG$1" "TARGET"@"MRG$1")]',
q'[LEADING(@"MRG$1" "from$_subquery$_168"@"MRG$1" "SOURCE"@"MRG$1" "TARGET"@"MRG$1")]',
q'[USE_MERGE_CARTESIAN(@"MRG$1" "SOURCE"@"MRG$1")]',
q'[USE_MERGE_CARTESIAN(@"MRG$1" "TARGET"@"MRG$1")]',
q'[NO_ACCESS(@"SEL$5428C7F1" "from$_subquery$_086"@"SEL$3")]',
q'[FULL(@"SEL$5428C7F1" "TARGET"@"SEL$2")]',
q'[LEADING(@"SEL$5428C7F1" "from$_subquery$_086"@"SEL$3" "TARGET"@"SEL$2")]',
q'[USE_HASH(@"SEL$5428C7F1" "TARGET"@"SEL$2")]',
q'[NO_ACCESS(@"SEL$89" "from$_subquery$_004"@"SEL$89")]',
q'[NO_ACCESS(@"SEL$90" "T"@"SEL$90")]',
q'[INDEX_RS_ASC(@"SEL$90" "ILEX"@"SEL$90" ("RPM_PROMO_ITEM_LOC_EXPL"."ITEM" "RPM_PROMO_ITEM_LOC_EXPL"."LOCATION"))]',
q'[FULL(@"SEL$90" "RPC"@"SEL$90")]',
q'[INDEX(@"SEL$90" "RPD"@"SEL$90" ("RPM_PROMO_DTL"."PROMO_DTL_ID"))]',
q'[LEADING(@"SEL$90" "T"@"SEL$90" "ILEX"@"SEL$90" "RPC"@"SEL$90" "RPD"@"SEL$90")]',
q'[USE_NL(@"SEL$90" "ILEX"@"SEL$90")]',
q'[USE_NL(@"SEL$90" "RPC"@"SEL$90")]',
q'[USE_NL(@"SEL$90" "RPD"@"SEL$90")]',
q'[NLJ_BATCHING(@"SEL$90" "RPD"@"SEL$90")]',
q'[NO_ACCESS(@"SEL$165" "IL"@"SEL$165")]',
q'[NO_ACCESS(@"SEL$165" "ZL"@"SEL$165")]',
q'[LEADING(@"SEL$165" "IL"@"SEL$165" "ZL"@"SEL$165")]',
q'[USE_HASH(@"SEL$165" "ZL"@"SEL$165")]',
q'[USE_HASH_AGGREGATION(@"SEL$165")]',
q'[FULL(@"SEL$4FA37A56" "KOKBF$10"@"SEL$158")]',
q'[INDEX_RS_ASC(@"SEL$4FA37A56" "RPI"@"SEL$157" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$4FA37A56" "RPL"@"SEL$157" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$4FA37A56" "IM"@"SEL$157" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$4FA37A56" "RMRDE"@"SEL$157")]',
q'[INDEX_RS_ASC(@"SEL$4FA37A56" "RZ"@"SEL$157" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$4FA37A56" "RZL"@"SEL$157" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$4FA37A56" "KOKBF$10"@"SEL$158" "RPI"@"SEL$157" "RPL"@"SEL$157" "IM"@"SEL$157" "RMRDE"@"SEL$157" "RZ"@"SEL$157" "RZL"@"SEL$157")]',
q'[USE_NL(@"SEL$4FA37A56" "RPI"@"SEL$157")]',
q'[USE_NL(@"SEL$4FA37A56" "RPL"@"SEL$157")]',
q'[USE_NL(@"SEL$4FA37A56" "IM"@"SEL$157")]',
q'[USE_NL(@"SEL$4FA37A56" "RMRDE"@"SEL$157")]',
q'[USE_NL(@"SEL$4FA37A56" "RZ"@"SEL$157")]',
q'[USE_NL(@"SEL$4FA37A56" "RZL"@"SEL$157")]',
q'[NLJ_BATCHING(@"SEL$4FA37A56" "RZL"@"SEL$157")]',
q'[USE_HASH_AGGREGATION(@"SEL$4FA37A56")]',
q'[NO_ACCESS(@"SEL$147" "IL"@"SEL$147")]',
q'[NO_ACCESS(@"SEL$147" "ZL"@"SEL$147")]',
q'[LEADING(@"SEL$147" "IL"@"SEL$147" "ZL"@"SEL$147")]',
q'[USE_HASH(@"SEL$147" "ZL"@"SEL$147")]',
q'[USE_HASH_AGGREGATION(@"SEL$147")]',
q'[FULL(@"SEL$3C5FD19C" "KOKBF$8"@"SEL$140")]',
q'[INDEX_RS_ASC(@"SEL$3C5FD19C" "RPI"@"SEL$139" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$3C5FD19C" "RPL"@"SEL$139" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$3C5FD19C" "IM"@"SEL$139" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$3C5FD19C" "RMRDE"@"SEL$139")]',
q'[INDEX_RS_ASC(@"SEL$3C5FD19C" "RZ"@"SEL$139" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$3C5FD19C" "RZL"@"SEL$139" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$3C5FD19C" "KOKBF$8"@"SEL$140" "RPI"@"SEL$139" "RPL"@"SEL$139" "IM"@"SEL$139" "RMRDE"@"SEL$139" "RZ"@"SEL$139" "RZL"@"SEL$139")]',
q'[USE_NL(@"SEL$3C5FD19C" "RPI"@"SEL$139")]',
q'[USE_NL(@"SEL$3C5FD19C" "RPL"@"SEL$139")]',
q'[USE_NL(@"SEL$3C5FD19C" "IM"@"SEL$139")]',
q'[USE_NL(@"SEL$3C5FD19C" "RMRDE"@"SEL$139")]',
q'[USE_NL(@"SEL$3C5FD19C" "RZ"@"SEL$139")]',
q'[USE_NL(@"SEL$3C5FD19C" "RZL"@"SEL$139")]',
q'[NLJ_BATCHING(@"SEL$3C5FD19C" "RZL"@"SEL$139")]',
q'[USE_HASH_AGGREGATION(@"SEL$3C5FD19C")]',
q'[FULL(@"SEL$08BE9987" "KOKBF$7"@"SEL$132")]',
q'[INDEX_RS_ASC(@"SEL$08BE9987" "RPI"@"SEL$131" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$08BE9987" "RPL"@"SEL$131" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$08BE9987" "IM"@"SEL$131" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$08BE9987" "RMRDE"@"SEL$131")]',
q'[INDEX_RS_ASC(@"SEL$08BE9987" "RZ"@"SEL$131" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$08BE9987" "RZL"@"SEL$131" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$08BE9987" "KOKBF$7"@"SEL$132" "RPI"@"SEL$131" "RPL"@"SEL$131" "IM"@"SEL$131" "RMRDE"@"SEL$131" "RZ"@"SEL$131" "RZL"@"SEL$131")]',
q'[USE_NL(@"SEL$08BE9987" "RPI"@"SEL$131")]',
q'[USE_NL(@"SEL$08BE9987" "RPL"@"SEL$131")]',
q'[USE_NL(@"SEL$08BE9987" "IM"@"SEL$131")]',
q'[USE_NL(@"SEL$08BE9987" "RMRDE"@"SEL$131")]',
q'[USE_NL(@"SEL$08BE9987" "RZ"@"SEL$131")]',
q'[USE_NL(@"SEL$08BE9987" "RZL"@"SEL$131")]',
q'[NLJ_BATCHING(@"SEL$08BE9987" "RZL"@"SEL$131")]',
q'[USE_HASH_AGGREGATION(@"SEL$08BE9987")]',
q'[NO_ACCESS(@"SEL$121" "IL"@"SEL$121")]',
q'[NO_ACCESS(@"SEL$121" "ZL"@"SEL$121")]',
q'[LEADING(@"SEL$121" "IL"@"SEL$121" "ZL"@"SEL$121")]',
q'[USE_HASH(@"SEL$121" "ZL"@"SEL$121")]',
q'[USE_HASH_AGGREGATION(@"SEL$121")]',
q'[FULL(@"SEL$92E3B30F" "KOKBF$5"@"SEL$114")]',
q'[INDEX_RS_ASC(@"SEL$92E3B30F" "RPI"@"SEL$113" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$92E3B30F" "RPL"@"SEL$113" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$92E3B30F" "RMRDE"@"SEL$113")]',
q'[INDEX_RS_ASC(@"SEL$92E3B30F" "RZ"@"SEL$113" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$92E3B30F" "RZL"@"SEL$113" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$92E3B30F" "KOKBF$5"@"SEL$114" "RPI"@"SEL$113" "RPL"@"SEL$113" "RMRDE"@"SEL$113" "RZ"@"SEL$113" "RZL"@"SEL$113")]',
q'[USE_NL(@"SEL$92E3B30F" "RPI"@"SEL$113")]',
q'[USE_NL(@"SEL$92E3B30F" "RPL"@"SEL$113")]',
q'[USE_NL(@"SEL$92E3B30F" "RMRDE"@"SEL$113")]',
q'[USE_NL(@"SEL$92E3B30F" "RZ"@"SEL$113")]',
q'[USE_NL(@"SEL$92E3B30F" "RZL"@"SEL$113")]',
q'[NLJ_BATCHING(@"SEL$92E3B30F" "RZL"@"SEL$113")]',
q'[USE_HASH_AGGREGATION(@"SEL$92E3B30F")]',
q'[FULL(@"SEL$609B08DB" "KOKBF$4"@"SEL$106")]',
q'[INDEX_RS_ASC(@"SEL$609B08DB" "RPI"@"SEL$105" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$609B08DB" "RPL"@"SEL$105" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$609B08DB" "RMRDE"@"SEL$105")]',
q'[INDEX_RS_ASC(@"SEL$609B08DB" "RZ"@"SEL$105" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$609B08DB" "RZL"@"SEL$105" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$609B08DB" "KOKBF$4"@"SEL$106" "RPI"@"SEL$105" "RPL"@"SEL$105" "RMRDE"@"SEL$105" "RZ"@"SEL$105" "RZL"@"SEL$105")]',
q'[USE_NL(@"SEL$609B08DB" "RPI"@"SEL$105")]',
q'[USE_NL(@"SEL$609B08DB" "RPL"@"SEL$105")]',
q'[USE_NL(@"SEL$609B08DB" "RMRDE"@"SEL$105")]',
q'[USE_NL(@"SEL$609B08DB" "RZ"@"SEL$105")]',
q'[USE_NL(@"SEL$609B08DB" "RZL"@"SEL$105")]',
q'[NLJ_BATCHING(@"SEL$609B08DB" "RZL"@"SEL$105")]',
q'[USE_HASH_AGGREGATION(@"SEL$609B08DB")]',
q'[FULL(@"SEL$7C853860" "KOKBF$3"@"SEL$104")]',
q'[INDEX_RS_ASC(@"SEL$7C853860" "RPI"@"SEL$103" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$7C853860" "RPL"@"SEL$103" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX(@"SEL$7C853860" "IM"@"SEL$103" ("ITEM_MASTER"."ITEM"))]',
q'[LEADING(@"SEL$7C853860" "KOKBF$3"@"SEL$104" "RPI"@"SEL$103" "RPL"@"SEL$103" "IM"@"SEL$103")]',
q'[USE_NL(@"SEL$7C853860" "RPI"@"SEL$103")]',
q'[USE_NL(@"SEL$7C853860" "RPL"@"SEL$103")]',
q'[USE_NL(@"SEL$7C853860" "IM"@"SEL$103")]',
q'[NLJ_BATCHING(@"SEL$7C853860" "IM"@"SEL$103")]',
q'[USE_HASH_AGGREGATION(@"SEL$7C853860")]',
q'[FULL(@"SEL$D329535F" "KOKBF$2"@"SEL$102")]',
q'[INDEX_RS_ASC(@"SEL$D329535F" "RPI"@"SEL$101" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$D329535F" "RPL"@"SEL$101" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX(@"SEL$D329535F" "IM"@"SEL$101" ("ITEM_MASTER"."ITEM"))]',
q'[LEADING(@"SEL$D329535F" "KOKBF$2"@"SEL$102" "RPI"@"SEL$101" "RPL"@"SEL$101" "IM"@"SEL$101")]',
q'[USE_NL(@"SEL$D329535F" "RPI"@"SEL$101")]',
q'[USE_NL(@"SEL$D329535F" "RPL"@"SEL$101")]',
q'[USE_NL(@"SEL$D329535F" "IM"@"SEL$101")]',
q'[NLJ_BATCHING(@"SEL$D329535F" "IM"@"SEL$101")]',
q'[USE_HASH_AGGREGATION(@"SEL$D329535F")]',
q'[FULL(@"SEL$A6513D81" "KOKBF$1"@"SEL$94")]',
q'[INDEX_RS_ASC(@"SEL$A6513D81" "RPI"@"SEL$93" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$A6513D81" "RPL"@"SEL$93" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$A6513D81" "RMRDE"@"SEL$93")]',
q'[INDEX_RS_ASC(@"SEL$A6513D81" "RZ"@"SEL$93" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$A6513D81" "RZL"@"SEL$93" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$A6513D81" "KOKBF$1"@"SEL$94" "RPI"@"SEL$93" "RPL"@"SEL$93" "RMRDE"@"SEL$93" "RZ"@"SEL$93" "RZL"@"SEL$93")]',
q'[USE_NL(@"SEL$A6513D81" "RPI"@"SEL$93")]',
q'[USE_NL(@"SEL$A6513D81" "RPL"@"SEL$93")]',
q'[USE_NL(@"SEL$A6513D81" "RMRDE"@"SEL$93")]',
q'[USE_NL(@"SEL$A6513D81" "RZ"@"SEL$93")]',
q'[USE_NL(@"SEL$A6513D81" "RZL"@"SEL$93")]',
q'[NLJ_BATCHING(@"SEL$A6513D81" "RZL"@"SEL$93")]',
q'[USE_HASH_AGGREGATION(@"SEL$A6513D81")]',
q'[FULL(@"SEL$362A9158" "KOKBF$0"@"SEL$92")]',
q'[INDEX_RS_ASC(@"SEL$362A9158" "RPI"@"SEL$91" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX(@"SEL$362A9158" "RPL"@"SEL$91" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[LEADING(@"SEL$362A9158" "KOKBF$0"@"SEL$92" "RPI"@"SEL$91" "RPL"@"SEL$91")]',
q'[USE_NL(@"SEL$362A9158" "RPI"@"SEL$91")]',
q'[USE_NL(@"SEL$362A9158" "RPL"@"SEL$91")]',
q'[NLJ_BATCHING(@"SEL$362A9158" "RPL"@"SEL$91")]',
q'[USE_HASH_AGGREGATION(@"SEL$362A9158")]',
q'[INDEX(@"SEL$FCD49EB1" "SBC"@"SEL$98" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$FCD49EB1" "MRD"@"SEL$98" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$FCD49EB1" "SBC"@"SEL$98" "MRD"@"SEL$98")]',
q'[USE_NL(@"SEL$FCD49EB1" "MRD"@"SEL$98")]',
q'[PUSH_SUBQ(@"SEL$100")]',
q'[PUSH_SUBQ(@"SEL$99")]',
q'[INDEX(@"SEL$0EF0B205" "SBC"@"SEL$96" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$0EF0B205" "MRD"@"SEL$96" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$0EF0B205" "SBC"@"SEL$96" "MRD"@"SEL$96")]',
q'[USE_NL(@"SEL$0EF0B205" "MRD"@"SEL$96")]',
q'[PUSH_SUBQ(@"SEL$97")]',
q'[INDEX(@"SEL$58EF4AB8" "SBC"@"SEL$95" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$58EF4AB8" "MRD"@"SEL$95" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$58EF4AB8" "SBC"@"SEL$95" "MRD"@"SEL$95")]',
q'[USE_NL(@"SEL$58EF4AB8" "MRD"@"SEL$95")]',
q'[INDEX_RS_ASC(@"SEL$97" "MRD2"@"SEL$97" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$100" "MRD2"@"SEL$100" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$99" "MRD2"@"SEL$99" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$886431FB" "SBC"@"SEL$110" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$886431FB" "MRD"@"SEL$110" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$886431FB" "SBC"@"SEL$110" "MRD"@"SEL$110")]',
q'[USE_NL(@"SEL$886431FB" "MRD"@"SEL$110")]',
q'[PUSH_SUBQ(@"SEL$112")]',
q'[PUSH_SUBQ(@"SEL$111")]',
q'[INDEX(@"SEL$2AA80680" "SBC"@"SEL$108" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$2AA80680" "MRD"@"SEL$108" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$2AA80680" "SBC"@"SEL$108" "MRD"@"SEL$108")]',
q'[USE_NL(@"SEL$2AA80680" "MRD"@"SEL$108")]',
q'[PUSH_SUBQ(@"SEL$109")]',
q'[INDEX(@"SEL$C7DD480F" "SBC"@"SEL$107" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$C7DD480F" "MRD"@"SEL$107" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$C7DD480F" "SBC"@"SEL$107" "MRD"@"SEL$107")]',
q'[USE_NL(@"SEL$C7DD480F" "MRD"@"SEL$107")]',
q'[INDEX_RS_ASC(@"SEL$109" "MRD2"@"SEL$109" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$112" "MRD2"@"SEL$112" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$111" "MRD2"@"SEL$111" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$19E0C56C" "SBC"@"SEL$118" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$19E0C56C" "MRD"@"SEL$118" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$19E0C56C" "SBC"@"SEL$118" "MRD"@"SEL$118")]',
q'[USE_NL(@"SEL$19E0C56C" "MRD"@"SEL$118")]',
q'[PUSH_SUBQ(@"SEL$120")]',
q'[PUSH_SUBQ(@"SEL$119")]',
q'[INDEX(@"SEL$5989E56E" "SBC"@"SEL$116" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$5989E56E" "MRD"@"SEL$116" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$5989E56E" "SBC"@"SEL$116" "MRD"@"SEL$116")]',
q'[USE_NL(@"SEL$5989E56E" "MRD"@"SEL$116")]',
q'[PUSH_SUBQ(@"SEL$117")]',
q'[INDEX(@"SEL$759B359D" "SBC"@"SEL$115" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$759B359D" "MRD"@"SEL$115" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$759B359D" "SBC"@"SEL$115" "MRD"@"SEL$115")]',
q'[USE_NL(@"SEL$759B359D" "MRD"@"SEL$115")]',
q'[INDEX_RS_ASC(@"SEL$117" "MRD2"@"SEL$117" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$120" "MRD2"@"SEL$120" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$119" "MRD2"@"SEL$119" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[FULL(@"SEL$ECFFA1E1" "KOKBF$6"@"SEL$123")]',
q'[INDEX_RS_ASC(@"SEL$ECFFA1E1" "RPI"@"SEL$122" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$ECFFA1E1" "RPL"@"SEL$122" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$ECFFA1E1" "RMRDE"@"SEL$122")]',
q'[LEADING(@"SEL$ECFFA1E1" "KOKBF$6"@"SEL$123" "RPI"@"SEL$122" "RPL"@"SEL$122" "RMRDE"@"SEL$122")]',
q'[USE_NL(@"SEL$ECFFA1E1" "RPI"@"SEL$122")]',
q'[USE_NL(@"SEL$ECFFA1E1" "RPL"@"SEL$122")]',
q'[USE_NL(@"SEL$ECFFA1E1" "RMRDE"@"SEL$122")]',
q'[INDEX_JOIN(@"SEL$130" "RZ"@"SEL$130" ("RPM_ZONE"."ZONE_ID") ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[FULL(@"SEL$130" "RZL"@"SEL$130")]',
q'[LEADING(@"SEL$130" "RZ"@"SEL$130" "RZL"@"SEL$130")]',
q'[USE_HASH(@"SEL$130" "RZL"@"SEL$130")]',
q'[INDEX(@"SEL$ACA617ED" "SBC"@"SEL$127" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$ACA617ED" "MRD"@"SEL$127" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$ACA617ED" "SBC"@"SEL$127" "MRD"@"SEL$127")]',
q'[USE_NL(@"SEL$ACA617ED" "MRD"@"SEL$127")]',
q'[PUSH_SUBQ(@"SEL$129")]',
q'[PUSH_SUBQ(@"SEL$128")]',
q'[INDEX(@"SEL$E68CF370" "SBC"@"SEL$125" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$E68CF370" "MRD"@"SEL$125" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$E68CF370" "SBC"@"SEL$125" "MRD"@"SEL$125")]',
q'[USE_NL(@"SEL$E68CF370" "MRD"@"SEL$125")]',
q'[PUSH_SUBQ(@"SEL$126")]',
q'[INDEX(@"SEL$A98FE7C3" "SBC"@"SEL$124" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$A98FE7C3" "MRD"@"SEL$124" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$A98FE7C3" "SBC"@"SEL$124" "MRD"@"SEL$124")]',
q'[USE_NL(@"SEL$A98FE7C3" "MRD"@"SEL$124")]',
q'[INDEX_RS_ASC(@"SEL$126" "MRD2"@"SEL$126" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$129" "MRD2"@"SEL$129" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$128" "MRD2"@"SEL$128" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$5A876370" "SBC"@"SEL$136" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$5A876370" "MRD"@"SEL$136" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$5A876370" "SBC"@"SEL$136" "MRD"@"SEL$136")]',
q'[USE_NL(@"SEL$5A876370" "MRD"@"SEL$136")]',
q'[PUSH_SUBQ(@"SEL$138")]',
q'[PUSH_SUBQ(@"SEL$137")]',
q'[INDEX(@"SEL$EC6B20CD" "SBC"@"SEL$134" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$EC6B20CD" "MRD"@"SEL$134" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$EC6B20CD" "SBC"@"SEL$134" "MRD"@"SEL$134")]',
q'[USE_NL(@"SEL$EC6B20CD" "MRD"@"SEL$134")]',
q'[PUSH_SUBQ(@"SEL$135")]',
q'[INDEX(@"SEL$7D2E1154" "SBC"@"SEL$133" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$7D2E1154" "MRD"@"SEL$133" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$7D2E1154" "SBC"@"SEL$133" "MRD"@"SEL$133")]',
q'[USE_NL(@"SEL$7D2E1154" "MRD"@"SEL$133")]',
q'[INDEX_RS_ASC(@"SEL$135" "MRD2"@"SEL$135" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$138" "MRD2"@"SEL$138" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$137" "MRD2"@"SEL$137" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$BEC9EB05" "SBC"@"SEL$144" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$BEC9EB05" "MRD"@"SEL$144" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$BEC9EB05" "SBC"@"SEL$144" "MRD"@"SEL$144")]',
q'[USE_NL(@"SEL$BEC9EB05" "MRD"@"SEL$144")]',
q'[PUSH_SUBQ(@"SEL$146")]',
q'[PUSH_SUBQ(@"SEL$145")]',
q'[INDEX(@"SEL$0C0B3338" "SBC"@"SEL$142" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$0C0B3338" "MRD"@"SEL$142" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$0C0B3338" "SBC"@"SEL$142" "MRD"@"SEL$142")]',
q'[USE_NL(@"SEL$0C0B3338" "MRD"@"SEL$142")]',
q'[PUSH_SUBQ(@"SEL$143")]',
q'[INDEX(@"SEL$9B0E7215" "SBC"@"SEL$141" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$9B0E7215" "MRD"@"SEL$141" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$9B0E7215" "SBC"@"SEL$141" "MRD"@"SEL$141")]',
q'[USE_NL(@"SEL$9B0E7215" "MRD"@"SEL$141")]',
q'[INDEX_RS_ASC(@"SEL$143" "MRD2"@"SEL$143" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$146" "MRD2"@"SEL$146" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$145" "MRD2"@"SEL$145" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[FULL(@"SEL$211F7714" "KOKBF$9"@"SEL$149")]',
q'[INDEX_RS_ASC(@"SEL$211F7714" "RPI"@"SEL$148" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$211F7714" "RPL"@"SEL$148" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$211F7714" "IM"@"SEL$148" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$211F7714" "RMRDE"@"SEL$148")]',
q'[LEADING(@"SEL$211F7714" "KOKBF$9"@"SEL$149" "RPI"@"SEL$148" "RPL"@"SEL$148" "IM"@"SEL$148" "RMRDE"@"SEL$148")]',
q'[USE_NL(@"SEL$211F7714" "RPI"@"SEL$148")]',
q'[USE_NL(@"SEL$211F7714" "RPL"@"SEL$148")]',
q'[USE_NL(@"SEL$211F7714" "IM"@"SEL$148")]',
q'[USE_NL(@"SEL$211F7714" "RMRDE"@"SEL$148")]',
q'[INDEX_JOIN(@"SEL$156" "RZ"@"SEL$156" ("RPM_ZONE"."ZONE_ID") ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[FULL(@"SEL$156" "RZL"@"SEL$156")]',
q'[LEADING(@"SEL$156" "RZ"@"SEL$156" "RZL"@"SEL$156")]',
q'[USE_HASH(@"SEL$156" "RZL"@"SEL$156")]',
q'[INDEX(@"SEL$D87DD315" "SBC"@"SEL$153" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$D87DD315" "MRD"@"SEL$153" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$D87DD315" "SBC"@"SEL$153" "MRD"@"SEL$153")]',
q'[USE_NL(@"SEL$D87DD315" "MRD"@"SEL$153")]',
q'[PUSH_SUBQ(@"SEL$155")]',
q'[PUSH_SUBQ(@"SEL$154")]',
q'[INDEX(@"SEL$6A616D60" "SBC"@"SEL$151" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$6A616D60" "MRD"@"SEL$151" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$6A616D60" "SBC"@"SEL$151" "MRD"@"SEL$151")]',
q'[USE_NL(@"SEL$6A616D60" "MRD"@"SEL$151")]',
q'[PUSH_SUBQ(@"SEL$152")]',
q'[INDEX(@"SEL$2333EF74" "SBC"@"SEL$150" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$2333EF74" "MRD"@"SEL$150" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$2333EF74" "SBC"@"SEL$150" "MRD"@"SEL$150")]',
q'[USE_NL(@"SEL$2333EF74" "MRD"@"SEL$150")]',
q'[INDEX_RS_ASC(@"SEL$152" "MRD2"@"SEL$152" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$155" "MRD2"@"SEL$155" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$154" "MRD2"@"SEL$154" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$74E2D305" "SBC"@"SEL$162" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$74E2D305" "MRD"@"SEL$162" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$74E2D305" "SBC"@"SEL$162" "MRD"@"SEL$162")]',
q'[USE_NL(@"SEL$74E2D305" "MRD"@"SEL$162")]',
q'[PUSH_SUBQ(@"SEL$164")]',
q'[PUSH_SUBQ(@"SEL$163")]',
q'[INDEX(@"SEL$8DAFD586" "SBC"@"SEL$160" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$8DAFD586" "MRD"@"SEL$160" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$8DAFD586" "SBC"@"SEL$160" "MRD"@"SEL$160")]',
q'[USE_NL(@"SEL$8DAFD586" "MRD"@"SEL$160")]',
q'[PUSH_SUBQ(@"SEL$161")]',
q'[INDEX(@"SEL$F0D18AAF" "SBC"@"SEL$159" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$F0D18AAF" "MRD"@"SEL$159" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$F0D18AAF" "SBC"@"SEL$159" "MRD"@"SEL$159")]',
q'[USE_NL(@"SEL$F0D18AAF" "MRD"@"SEL$159")]',
q'[INDEX_RS_ASC(@"SEL$161" "MRD2"@"SEL$161" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$164" "MRD2"@"SEL$164" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$163" "MRD2"@"SEL$163" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[FULL(@"SEL$68D11BD3" "KOKBF$11"@"SEL$167")]',
q'[INDEX_RS_ASC(@"SEL$68D11BD3" "RPI"@"SEL$166" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$68D11BD3" "RPL"@"SEL$166" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$68D11BD3" "IM"@"SEL$166" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$68D11BD3" "RMRDE"@"SEL$166")]',
q'[LEADING(@"SEL$68D11BD3" "KOKBF$11"@"SEL$167" "RPI"@"SEL$166" "RPL"@"SEL$166" "IM"@"SEL$166" "RMRDE"@"SEL$166")]',
q'[USE_NL(@"SEL$68D11BD3" "RPI"@"SEL$166")]',
q'[USE_NL(@"SEL$68D11BD3" "RPL"@"SEL$166")]',
q'[USE_NL(@"SEL$68D11BD3" "IM"@"SEL$166")]',
q'[USE_NL(@"SEL$68D11BD3" "RMRDE"@"SEL$166")]',
q'[INDEX_JOIN(@"SEL$174" "RZ"@"SEL$174" ("RPM_ZONE"."ZONE_ID") ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[FULL(@"SEL$174" "RZL"@"SEL$174")]',
q'[LEADING(@"SEL$174" "RZ"@"SEL$174" "RZL"@"SEL$174")]',
q'[USE_HASH(@"SEL$174" "RZL"@"SEL$174")]',
q'[INDEX(@"SEL$9D92F63C" "SBC"@"SEL$171" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$9D92F63C" "MRD"@"SEL$171" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$9D92F63C" "SBC"@"SEL$171" "MRD"@"SEL$171")]',
q'[USE_NL(@"SEL$9D92F63C" "MRD"@"SEL$171")]',
q'[PUSH_SUBQ(@"SEL$173")]',
q'[PUSH_SUBQ(@"SEL$172")]',
q'[INDEX(@"SEL$158256AE" "SBC"@"SEL$169" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$158256AE" "MRD"@"SEL$169" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$158256AE" "SBC"@"SEL$169" "MRD"@"SEL$169")]',
q'[USE_NL(@"SEL$158256AE" "MRD"@"SEL$169")]',
q'[PUSH_SUBQ(@"SEL$170")]',
q'[INDEX(@"SEL$DA07537C" "SBC"@"SEL$168" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$DA07537C" "MRD"@"SEL$168" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$DA07537C" "SBC"@"SEL$168" "MRD"@"SEL$168")]',
q'[USE_NL(@"SEL$DA07537C" "MRD"@"SEL$168")]',
q'[INDEX_RS_ASC(@"SEL$170" "MRD2"@"SEL$170" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$173" "MRD2"@"SEL$173" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$172" "MRD2"@"SEL$172" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[NO_ACCESS(@"SEL$4" "T"@"SEL$4")]',
q'[INDEX_RS_ASC(@"SEL$4" "ILEX"@"SEL$4" ("RPM_PROMO_ITEM_LOC_EXPL"."ITEM" "RPM_PROMO_ITEM_LOC_EXPL"."LOCATION"))]',
q'[FULL(@"SEL$4" "RPC"@"SEL$4")]',
q'[INDEX(@"SEL$4" "RPD"@"SEL$4" ("RPM_PROMO_DTL"."PROMO_DTL_ID"))]',
q'[LEADING(@"SEL$4" "T"@"SEL$4" "ILEX"@"SEL$4" "RPC"@"SEL$4" "RPD"@"SEL$4")]',
q'[USE_NL(@"SEL$4" "ILEX"@"SEL$4")]',
q'[USE_NL(@"SEL$4" "RPC"@"SEL$4")]',
q'[USE_NL(@"SEL$4" "RPD"@"SEL$4")]',
q'[NLJ_BATCHING(@"SEL$4" "RPD"@"SEL$4")]',
q'[NO_ACCESS(@"SEL$79" "IL"@"SEL$79")]',
q'[NO_ACCESS(@"SEL$79" "ZL"@"SEL$79")]',
q'[LEADING(@"SEL$79" "IL"@"SEL$79" "ZL"@"SEL$79")]',
q'[USE_HASH(@"SEL$79" "ZL"@"SEL$79")]',
q'[USE_HASH_AGGREGATION(@"SEL$79")]',
q'[FULL(@"SEL$BDF6F82C" "KOKBF$22"@"SEL$72")]',
q'[INDEX_RS_ASC(@"SEL$BDF6F82C" "RPI"@"SEL$71" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$BDF6F82C" "RPL"@"SEL$71" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$BDF6F82C" "IM"@"SEL$71" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$BDF6F82C" "RMRDE"@"SEL$71")]',
q'[INDEX_RS_ASC(@"SEL$BDF6F82C" "RZ"@"SEL$71" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$BDF6F82C" "RZL"@"SEL$71" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$BDF6F82C" "KOKBF$22"@"SEL$72" "RPI"@"SEL$71" "RPL"@"SEL$71" "IM"@"SEL$71" "RMRDE"@"SEL$71" "RZ"@"SEL$71" "RZL"@"SEL$71")]',
q'[USE_NL(@"SEL$BDF6F82C" "RPI"@"SEL$71")]',
q'[USE_NL(@"SEL$BDF6F82C" "RPL"@"SEL$71")]',
q'[USE_NL(@"SEL$BDF6F82C" "IM"@"SEL$71")]',
q'[USE_NL(@"SEL$BDF6F82C" "RMRDE"@"SEL$71")]',
q'[USE_NL(@"SEL$BDF6F82C" "RZ"@"SEL$71")]',
q'[USE_NL(@"SEL$BDF6F82C" "RZL"@"SEL$71")]',
q'[NLJ_BATCHING(@"SEL$BDF6F82C" "RZL"@"SEL$71")]',
q'[USE_HASH_AGGREGATION(@"SEL$BDF6F82C")]',
q'[NO_ACCESS(@"SEL$61" "IL"@"SEL$61")]',
q'[NO_ACCESS(@"SEL$61" "ZL"@"SEL$61")]',
q'[LEADING(@"SEL$61" "IL"@"SEL$61" "ZL"@"SEL$61")]',
q'[USE_HASH(@"SEL$61" "ZL"@"SEL$61")]',
q'[USE_HASH_AGGREGATION(@"SEL$61")]',
q'[FULL(@"SEL$D312661C" "KOKBF$20"@"SEL$54")]',
q'[INDEX_RS_ASC(@"SEL$D312661C" "RPI"@"SEL$53" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$D312661C" "RPL"@"SEL$53" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$D312661C" "IM"@"SEL$53" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$D312661C" "RMRDE"@"SEL$53")]',
q'[INDEX_RS_ASC(@"SEL$D312661C" "RZ"@"SEL$53" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$D312661C" "RZL"@"SEL$53" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$D312661C" "KOKBF$20"@"SEL$54" "RPI"@"SEL$53" "RPL"@"SEL$53" "IM"@"SEL$53" "RMRDE"@"SEL$53" "RZ"@"SEL$53" "RZL"@"SEL$53")]',
q'[USE_NL(@"SEL$D312661C" "RPI"@"SEL$53")]',
q'[USE_NL(@"SEL$D312661C" "RPL"@"SEL$53")]',
q'[USE_NL(@"SEL$D312661C" "IM"@"SEL$53")]',
q'[USE_NL(@"SEL$D312661C" "RMRDE"@"SEL$53")]',
q'[USE_NL(@"SEL$D312661C" "RZ"@"SEL$53")]',
q'[USE_NL(@"SEL$D312661C" "RZL"@"SEL$53")]',
q'[NLJ_BATCHING(@"SEL$D312661C" "RZL"@"SEL$53")]',
q'[USE_HASH_AGGREGATION(@"SEL$D312661C")]',
q'[FULL(@"SEL$B3FB865B" "KOKBF$19"@"SEL$46")]',
q'[INDEX_RS_ASC(@"SEL$B3FB865B" "RPI"@"SEL$45" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$B3FB865B" "RPL"@"SEL$45" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$B3FB865B" "IM"@"SEL$45" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$B3FB865B" "RMRDE"@"SEL$45")]',
q'[INDEX_RS_ASC(@"SEL$B3FB865B" "RZ"@"SEL$45" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$B3FB865B" "RZL"@"SEL$45" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$B3FB865B" "KOKBF$19"@"SEL$46" "RPI"@"SEL$45" "RPL"@"SEL$45" "IM"@"SEL$45" "RMRDE"@"SEL$45" "RZ"@"SEL$45" "RZL"@"SEL$45")]',
q'[USE_NL(@"SEL$B3FB865B" "RPI"@"SEL$45")]',
q'[USE_NL(@"SEL$B3FB865B" "RPL"@"SEL$45")]',
q'[USE_NL(@"SEL$B3FB865B" "IM"@"SEL$45")]',
q'[USE_NL(@"SEL$B3FB865B" "RMRDE"@"SEL$45")]',
q'[USE_NL(@"SEL$B3FB865B" "RZ"@"SEL$45")]',
q'[USE_NL(@"SEL$B3FB865B" "RZL"@"SEL$45")]',
q'[NLJ_BATCHING(@"SEL$B3FB865B" "RZL"@"SEL$45")]',
q'[USE_HASH_AGGREGATION(@"SEL$B3FB865B")]',
q'[NO_ACCESS(@"SEL$35" "IL"@"SEL$35")]',
q'[NO_ACCESS(@"SEL$35" "ZL"@"SEL$35")]',
q'[LEADING(@"SEL$35" "IL"@"SEL$35" "ZL"@"SEL$35")]',
q'[USE_HASH(@"SEL$35" "ZL"@"SEL$35")]',
q'[USE_HASH_AGGREGATION(@"SEL$35")]',
q'[FULL(@"SEL$A065B7E5" "KOKBF$17"@"SEL$28")]',
q'[INDEX_RS_ASC(@"SEL$A065B7E5" "RPI"@"SEL$27" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$A065B7E5" "RPL"@"SEL$27" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$A065B7E5" "RMRDE"@"SEL$27")]',
q'[INDEX_RS_ASC(@"SEL$A065B7E5" "RZ"@"SEL$27" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$A065B7E5" "RZL"@"SEL$27" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$A065B7E5" "KOKBF$17"@"SEL$28" "RPI"@"SEL$27" "RPL"@"SEL$27" "RMRDE"@"SEL$27" "RZ"@"SEL$27" "RZL"@"SEL$27")]',
q'[USE_NL(@"SEL$A065B7E5" "RPI"@"SEL$27")]',
q'[USE_NL(@"SEL$A065B7E5" "RPL"@"SEL$27")]',
q'[USE_NL(@"SEL$A065B7E5" "RMRDE"@"SEL$27")]',
q'[USE_NL(@"SEL$A065B7E5" "RZ"@"SEL$27")]',
q'[USE_NL(@"SEL$A065B7E5" "RZL"@"SEL$27")]',
q'[NLJ_BATCHING(@"SEL$A065B7E5" "RZL"@"SEL$27")]',
q'[USE_HASH_AGGREGATION(@"SEL$A065B7E5")]',
q'[FULL(@"SEL$3B673E5C" "KOKBF$16"@"SEL$20")]',
q'[INDEX_RS_ASC(@"SEL$3B673E5C" "RPI"@"SEL$19" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$3B673E5C" "RPL"@"SEL$19" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$3B673E5C" "RMRDE"@"SEL$19")]',
q'[INDEX_RS_ASC(@"SEL$3B673E5C" "RZ"@"SEL$19" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$3B673E5C" "RZL"@"SEL$19" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$3B673E5C" "KOKBF$16"@"SEL$20" "RPI"@"SEL$19" "RPL"@"SEL$19" "RMRDE"@"SEL$19" "RZ"@"SEL$19" "RZL"@"SEL$19")]',
q'[USE_NL(@"SEL$3B673E5C" "RPI"@"SEL$19")]',
q'[USE_NL(@"SEL$3B673E5C" "RPL"@"SEL$19")]',
q'[USE_NL(@"SEL$3B673E5C" "RMRDE"@"SEL$19")]',
q'[USE_NL(@"SEL$3B673E5C" "RZ"@"SEL$19")]',
q'[USE_NL(@"SEL$3B673E5C" "RZL"@"SEL$19")]',
q'[NLJ_BATCHING(@"SEL$3B673E5C" "RZL"@"SEL$19")]',
q'[USE_HASH_AGGREGATION(@"SEL$3B673E5C")]',
q'[FULL(@"SEL$DC4B4145" "KOKBF$15"@"SEL$18")]',
q'[INDEX_RS_ASC(@"SEL$DC4B4145" "RPI"@"SEL$17" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$DC4B4145" "RPL"@"SEL$17" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX(@"SEL$DC4B4145" "IM"@"SEL$17" ("ITEM_MASTER"."ITEM"))]',
q'[LEADING(@"SEL$DC4B4145" "KOKBF$15"@"SEL$18" "RPI"@"SEL$17" "RPL"@"SEL$17" "IM"@"SEL$17")]',
q'[USE_NL(@"SEL$DC4B4145" "RPI"@"SEL$17")]',
q'[USE_NL(@"SEL$DC4B4145" "RPL"@"SEL$17")]',
q'[USE_NL(@"SEL$DC4B4145" "IM"@"SEL$17")]',
q'[NLJ_BATCHING(@"SEL$DC4B4145" "IM"@"SEL$17")]',
q'[USE_HASH_AGGREGATION(@"SEL$DC4B4145")]',
q'[FULL(@"SEL$29F99543" "KOKBF$14"@"SEL$16")]',
q'[INDEX_RS_ASC(@"SEL$29F99543" "RPI"@"SEL$15" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$29F99543" "RPL"@"SEL$15" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX(@"SEL$29F99543" "IM"@"SEL$15" ("ITEM_MASTER"."ITEM"))]',
q'[LEADING(@"SEL$29F99543" "KOKBF$14"@"SEL$16" "RPI"@"SEL$15" "RPL"@"SEL$15" "IM"@"SEL$15")]',
q'[USE_NL(@"SEL$29F99543" "RPI"@"SEL$15")]',
q'[USE_NL(@"SEL$29F99543" "RPL"@"SEL$15")]',
q'[USE_NL(@"SEL$29F99543" "IM"@"SEL$15")]',
q'[NLJ_BATCHING(@"SEL$29F99543" "IM"@"SEL$15")]',
q'[USE_HASH_AGGREGATION(@"SEL$29F99543")]',
q'[FULL(@"SEL$8A3193DA" "KOKBF$13"@"SEL$8")]',
q'[INDEX_RS_ASC(@"SEL$8A3193DA" "RPI"@"SEL$7" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$8A3193DA" "RPL"@"SEL$7" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$8A3193DA" "RMRDE"@"SEL$7")]',
q'[INDEX_RS_ASC(@"SEL$8A3193DA" "RZ"@"SEL$7" ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[INDEX(@"SEL$8A3193DA" "RZL"@"SEL$7" ("RPM_ZONE_LOCATION"."LOCATION" "RPM_ZONE_LOCATION"."LOC_TYPE"))]',
q'[LEADING(@"SEL$8A3193DA" "KOKBF$13"@"SEL$8" "RPI"@"SEL$7" "RPL"@"SEL$7" "RMRDE"@"SEL$7" "RZ"@"SEL$7" "RZL"@"SEL$7")]',
q'[USE_NL(@"SEL$8A3193DA" "RPI"@"SEL$7")]',
q'[USE_NL(@"SEL$8A3193DA" "RPL"@"SEL$7")]',
q'[USE_NL(@"SEL$8A3193DA" "RMRDE"@"SEL$7")]',
q'[USE_NL(@"SEL$8A3193DA" "RZ"@"SEL$7")]',
q'[USE_NL(@"SEL$8A3193DA" "RZL"@"SEL$7")]',
q'[NLJ_BATCHING(@"SEL$8A3193DA" "RZL"@"SEL$7")]',
q'[USE_HASH_AGGREGATION(@"SEL$8A3193DA")]',
q'[FULL(@"SEL$ABDE6DFF" "KOKBF$12"@"SEL$6")]',
q'[INDEX_RS_ASC(@"SEL$ABDE6DFF" "RPI"@"SEL$5" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX(@"SEL$ABDE6DFF" "RPL"@"SEL$5" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[LEADING(@"SEL$ABDE6DFF" "KOKBF$12"@"SEL$6" "RPI"@"SEL$5" "RPL"@"SEL$5")]',
q'[USE_NL(@"SEL$ABDE6DFF" "RPI"@"SEL$5")]',
q'[USE_NL(@"SEL$ABDE6DFF" "RPL"@"SEL$5")]',
q'[NLJ_BATCHING(@"SEL$ABDE6DFF" "RPL"@"SEL$5")]',
q'[USE_HASH_AGGREGATION(@"SEL$ABDE6DFF")]',
q'[INDEX(@"SEL$3461DC8E" "SBC"@"SEL$12" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$3461DC8E" "MRD"@"SEL$12" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$3461DC8E" "SBC"@"SEL$12" "MRD"@"SEL$12")]',
q'[USE_NL(@"SEL$3461DC8E" "MRD"@"SEL$12")]',
q'[PUSH_SUBQ(@"SEL$14")]',
q'[PUSH_SUBQ(@"SEL$13")]',
q'[INDEX(@"SEL$A66D0F29" "SBC"@"SEL$10" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$A66D0F29" "MRD"@"SEL$10" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$A66D0F29" "SBC"@"SEL$10" "MRD"@"SEL$10")]',
q'[USE_NL(@"SEL$A66D0F29" "MRD"@"SEL$10")]',
q'[PUSH_SUBQ(@"SEL$11")]',
q'[INDEX(@"SEL$193D1E52" "SBC"@"SEL$9" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$193D1E52" "MRD"@"SEL$9" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$193D1E52" "SBC"@"SEL$9" "MRD"@"SEL$9")]',
q'[USE_NL(@"SEL$193D1E52" "MRD"@"SEL$9")]',
q'[INDEX_RS_ASC(@"SEL$11" "MRD2"@"SEL$11" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$14" "MRD2"@"SEL$14" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$13" "MRD2"@"SEL$13" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$EBE615B3" "SBC"@"SEL$24" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$EBE615B3" "MRD"@"SEL$24" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$EBE615B3" "SBC"@"SEL$24" "MRD"@"SEL$24")]',
q'[USE_NL(@"SEL$EBE615B3" "MRD"@"SEL$24")]',
q'[PUSH_SUBQ(@"SEL$26")]',
q'[PUSH_SUBQ(@"SEL$25")]',
q'[INDEX(@"SEL$56798371" "SBC"@"SEL$22" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$56798371" "MRD"@"SEL$22" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$56798371" "SBC"@"SEL$22" "MRD"@"SEL$22")]',
q'[USE_NL(@"SEL$56798371" "MRD"@"SEL$22")]',
q'[PUSH_SUBQ(@"SEL$23")]',
q'[INDEX(@"SEL$AA219DAE" "SBC"@"SEL$21" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$AA219DAE" "MRD"@"SEL$21" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$AA219DAE" "SBC"@"SEL$21" "MRD"@"SEL$21")]',
q'[USE_NL(@"SEL$AA219DAE" "MRD"@"SEL$21")]',
q'[INDEX_RS_ASC(@"SEL$23" "MRD2"@"SEL$23" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$26" "MRD2"@"SEL$26" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$25" "MRD2"@"SEL$25" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$77BA0B0E" "SBC"@"SEL$32" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$77BA0B0E" "MRD"@"SEL$32" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$77BA0B0E" "SBC"@"SEL$32" "MRD"@"SEL$32")]',
q'[USE_NL(@"SEL$77BA0B0E" "MRD"@"SEL$32")]',
q'[PUSH_SUBQ(@"SEL$34")]',
q'[PUSH_SUBQ(@"SEL$33")]',
q'[INDEX(@"SEL$835086F2" "SBC"@"SEL$30" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$835086F2" "MRD"@"SEL$30" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$835086F2" "SBC"@"SEL$30" "MRD"@"SEL$30")]',
q'[USE_NL(@"SEL$835086F2" "MRD"@"SEL$30")]',
q'[PUSH_SUBQ(@"SEL$31")]',
q'[INDEX(@"SEL$E666FA22" "SBC"@"SEL$29" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$E666FA22" "MRD"@"SEL$29" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$E666FA22" "SBC"@"SEL$29" "MRD"@"SEL$29")]',
q'[USE_NL(@"SEL$E666FA22" "MRD"@"SEL$29")]',
q'[INDEX_RS_ASC(@"SEL$31" "MRD2"@"SEL$31" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$34" "MRD2"@"SEL$34" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$33" "MRD2"@"SEL$33" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[FULL(@"SEL$FF4A7D68" "KOKBF$18"@"SEL$37")]',
q'[INDEX_RS_ASC(@"SEL$FF4A7D68" "RPI"@"SEL$36" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$FF4A7D68" "RPL"@"SEL$36" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[NO_ACCESS(@"SEL$FF4A7D68" "RMRDE"@"SEL$36")]',
q'[LEADING(@"SEL$FF4A7D68" "KOKBF$18"@"SEL$37" "RPI"@"SEL$36" "RPL"@"SEL$36" "RMRDE"@"SEL$36")]',
q'[USE_NL(@"SEL$FF4A7D68" "RPI"@"SEL$36")]',
q'[USE_NL(@"SEL$FF4A7D68" "RPL"@"SEL$36")]',
q'[USE_NL(@"SEL$FF4A7D68" "RMRDE"@"SEL$36")]',
q'[INDEX_JOIN(@"SEL$44" "RZ"@"SEL$44" ("RPM_ZONE"."ZONE_ID") ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[FULL(@"SEL$44" "RZL"@"SEL$44")]',
q'[LEADING(@"SEL$44" "RZ"@"SEL$44" "RZL"@"SEL$44")]',
q'[USE_HASH(@"SEL$44" "RZL"@"SEL$44")]',
q'[INDEX(@"SEL$1269F772" "SBC"@"SEL$41" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$1269F772" "MRD"@"SEL$41" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$1269F772" "SBC"@"SEL$41" "MRD"@"SEL$41")]',
q'[USE_NL(@"SEL$1269F772" "MRD"@"SEL$41")]',
q'[PUSH_SUBQ(@"SEL$43")]',
q'[PUSH_SUBQ(@"SEL$42")]',
q'[INDEX(@"SEL$6CC0B070" "SBC"@"SEL$39" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$6CC0B070" "MRD"@"SEL$39" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$6CC0B070" "SBC"@"SEL$39" "MRD"@"SEL$39")]',
q'[USE_NL(@"SEL$6CC0B070" "MRD"@"SEL$39")]',
q'[PUSH_SUBQ(@"SEL$40")]',
q'[INDEX(@"SEL$739233A5" "SBC"@"SEL$38" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$739233A5" "MRD"@"SEL$38" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$739233A5" "SBC"@"SEL$38" "MRD"@"SEL$38")]',
q'[USE_NL(@"SEL$739233A5" "MRD"@"SEL$38")]',
q'[INDEX_RS_ASC(@"SEL$40" "MRD2"@"SEL$40" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$43" "MRD2"@"SEL$43" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$42" "MRD2"@"SEL$42" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$210D83C0" "SBC"@"SEL$50" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$210D83C0" "MRD"@"SEL$50" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$210D83C0" "SBC"@"SEL$50" "MRD"@"SEL$50")]',
q'[USE_NL(@"SEL$210D83C0" "MRD"@"SEL$50")]',
q'[PUSH_SUBQ(@"SEL$52")]',
q'[PUSH_SUBQ(@"SEL$51")]',
q'[INDEX(@"SEL$544607EE" "SBC"@"SEL$48" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$544607EE" "MRD"@"SEL$48" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$544607EE" "SBC"@"SEL$48" "MRD"@"SEL$48")]',
q'[USE_NL(@"SEL$544607EE" "MRD"@"SEL$48")]',
q'[PUSH_SUBQ(@"SEL$49")]',
q'[INDEX(@"SEL$DA9BBF6F" "SBC"@"SEL$47" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$DA9BBF6F" "MRD"@"SEL$47" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$DA9BBF6F" "SBC"@"SEL$47" "MRD"@"SEL$47")]',
q'[USE_NL(@"SEL$DA9BBF6F" "MRD"@"SEL$47")]',
q'[INDEX_RS_ASC(@"SEL$49" "MRD2"@"SEL$49" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$52" "MRD2"@"SEL$52" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$51" "MRD2"@"SEL$51" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$35A3D408" "SBC"@"SEL$58" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$35A3D408" "MRD"@"SEL$58" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$35A3D408" "SBC"@"SEL$58" "MRD"@"SEL$58")]',
q'[USE_NL(@"SEL$35A3D408" "MRD"@"SEL$58")]',
q'[PUSH_SUBQ(@"SEL$60")]',
q'[PUSH_SUBQ(@"SEL$59")]',
q'[INDEX(@"SEL$09A927DA" "SBC"@"SEL$56" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$09A927DA" "MRD"@"SEL$56" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$09A927DA" "SBC"@"SEL$56" "MRD"@"SEL$56")]',
q'[USE_NL(@"SEL$09A927DA" "MRD"@"SEL$56")]',
q'[PUSH_SUBQ(@"SEL$57")]',
q'[INDEX(@"SEL$EF45A52A" "SBC"@"SEL$55" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$EF45A52A" "MRD"@"SEL$55" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$EF45A52A" "SBC"@"SEL$55" "MRD"@"SEL$55")]',
q'[USE_NL(@"SEL$EF45A52A" "MRD"@"SEL$55")]',
q'[INDEX_RS_ASC(@"SEL$57" "MRD2"@"SEL$57" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$60" "MRD2"@"SEL$60" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$59" "MRD2"@"SEL$59" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[FULL(@"SEL$3B6E7E85" "KOKBF$21"@"SEL$63")]',
q'[INDEX_RS_ASC(@"SEL$3B6E7E85" "RPI"@"SEL$62" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$3B6E7E85" "RPL"@"SEL$62" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$3B6E7E85" "IM"@"SEL$62" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$3B6E7E85" "RMRDE"@"SEL$62")]',
q'[LEADING(@"SEL$3B6E7E85" "KOKBF$21"@"SEL$63" "RPI"@"SEL$62" "RPL"@"SEL$62" "IM"@"SEL$62" "RMRDE"@"SEL$62")]',
q'[USE_NL(@"SEL$3B6E7E85" "RPI"@"SEL$62")]',
q'[USE_NL(@"SEL$3B6E7E85" "RPL"@"SEL$62")]',
q'[USE_NL(@"SEL$3B6E7E85" "IM"@"SEL$62")]',
q'[USE_NL(@"SEL$3B6E7E85" "RMRDE"@"SEL$62")]',
q'[INDEX_JOIN(@"SEL$70" "RZ"@"SEL$70" ("RPM_ZONE"."ZONE_ID") ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[FULL(@"SEL$70" "RZL"@"SEL$70")]',
q'[LEADING(@"SEL$70" "RZ"@"SEL$70" "RZL"@"SEL$70")]',
q'[USE_HASH(@"SEL$70" "RZL"@"SEL$70")]',
q'[INDEX(@"SEL$0687E345" "SBC"@"SEL$67" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$0687E345" "MRD"@"SEL$67" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$0687E345" "SBC"@"SEL$67" "MRD"@"SEL$67")]',
q'[USE_NL(@"SEL$0687E345" "MRD"@"SEL$67")]',
q'[PUSH_SUBQ(@"SEL$69")]',
q'[PUSH_SUBQ(@"SEL$68")]',
q'[INDEX(@"SEL$2769D7CD" "SBC"@"SEL$65" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$2769D7CD" "MRD"@"SEL$65" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$2769D7CD" "SBC"@"SEL$65" "MRD"@"SEL$65")]',
q'[USE_NL(@"SEL$2769D7CD" "MRD"@"SEL$65")]',
q'[PUSH_SUBQ(@"SEL$66")]',
q'[INDEX(@"SEL$93BB4834" "SBC"@"SEL$64" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$93BB4834" "MRD"@"SEL$64" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$93BB4834" "SBC"@"SEL$64" "MRD"@"SEL$64")]',
q'[USE_NL(@"SEL$93BB4834" "MRD"@"SEL$64")]',
q'[INDEX_RS_ASC(@"SEL$66" "MRD2"@"SEL$66" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$69" "MRD2"@"SEL$69" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$68" "MRD2"@"SEL$68" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX(@"SEL$16729207" "SBC"@"SEL$76" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$16729207" "MRD"@"SEL$76" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$16729207" "SBC"@"SEL$76" "MRD"@"SEL$76")]',
q'[USE_NL(@"SEL$16729207" "MRD"@"SEL$76")]',
q'[PUSH_SUBQ(@"SEL$78")]',
q'[PUSH_SUBQ(@"SEL$77")]',
q'[INDEX(@"SEL$39B419B5" "SBC"@"SEL$74" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$39B419B5" "MRD"@"SEL$74" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$39B419B5" "SBC"@"SEL$74" "MRD"@"SEL$74")]',
q'[USE_NL(@"SEL$39B419B5" "MRD"@"SEL$74")]',
q'[PUSH_SUBQ(@"SEL$75")]',
q'[INDEX(@"SEL$2562DEB9" "SBC"@"SEL$73" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$2562DEB9" "MRD"@"SEL$73" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$2562DEB9" "SBC"@"SEL$73" "MRD"@"SEL$73")]',
q'[USE_NL(@"SEL$2562DEB9" "MRD"@"SEL$73")]',
q'[INDEX_RS_ASC(@"SEL$75" "MRD2"@"SEL$75" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$78" "MRD2"@"SEL$78" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$77" "MRD2"@"SEL$77" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[FULL(@"SEL$0E835E3A" "KOKBF$23"@"SEL$81")]',
q'[INDEX_RS_ASC(@"SEL$0E835E3A" "RPI"@"SEL$80" ("RPM_BULK_CC_PE_ITEM"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_ITEM"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_ITEM"."ITEM" "RPM_BULK_CC_PE_ITEM"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$0E835E3A" "RPL"@"SEL$80" ("RPM_BULK_CC_PE_LOCATION"."BULK_CC_PE_ID" "RPM_BULK_CC_PE_LOCATION"."PRICE_EVENT_ID" "RPM_BULK_CC_PE_LOCATION"."LOCATION" "RPM_BULK_CC_PE_LOCATION"."ITEMLOC_ID"))]',
q'[INDEX_RS_ASC(@"SEL$0E835E3A" "IM"@"SEL$80" ("ITEM_MASTER"."ITEM"))]',
q'[NO_ACCESS(@"SEL$0E835E3A" "RMRDE"@"SEL$80")]',
q'[LEADING(@"SEL$0E835E3A" "KOKBF$23"@"SEL$81" "RPI"@"SEL$80" "RPL"@"SEL$80" "IM"@"SEL$80" "RMRDE"@"SEL$80")]',
q'[USE_NL(@"SEL$0E835E3A" "RPI"@"SEL$80")]',
q'[USE_NL(@"SEL$0E835E3A" "RPL"@"SEL$80")]',
q'[USE_NL(@"SEL$0E835E3A" "IM"@"SEL$80")]',
q'[USE_NL(@"SEL$0E835E3A" "RMRDE"@"SEL$80")]',
q'[INDEX_JOIN(@"SEL$88" "RZ"@"SEL$88" ("RPM_ZONE"."ZONE_ID") ("RPM_ZONE"."ZONE_GROUP_ID"))]',
q'[FULL(@"SEL$88" "RZL"@"SEL$88")]',
q'[LEADING(@"SEL$88" "RZ"@"SEL$88" "RZL"@"SEL$88")]',
q'[USE_HASH(@"SEL$88" "RZL"@"SEL$88")]',
q'[INDEX(@"SEL$907BFD88" "SBC"@"SEL$85" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$907BFD88" "MRD"@"SEL$85" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$907BFD88" "SBC"@"SEL$85" "MRD"@"SEL$85")]',
q'[USE_NL(@"SEL$907BFD88" "MRD"@"SEL$85")]',
q'[PUSH_SUBQ(@"SEL$87")]',
q'[PUSH_SUBQ(@"SEL$86")]',
q'[INDEX(@"SEL$F8DF03ED" "SBC"@"SEL$83" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$F8DF03ED" "MRD"@"SEL$83" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$F8DF03ED" "SBC"@"SEL$83" "MRD"@"SEL$83")]',
q'[USE_NL(@"SEL$F8DF03ED" "MRD"@"SEL$83")]',
q'[PUSH_SUBQ(@"SEL$84")]',
q'[INDEX(@"SEL$B387F92E" "SBC"@"SEL$82" ("SUBCLASS"."DEPT" "SUBCLASS"."CLASS" "SUBCLASS"."SUBCLASS"))]',
q'[INDEX_RS_ASC(@"SEL$B387F92E" "MRD"@"SEL$82" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[LEADING(@"SEL$B387F92E" "SBC"@"SEL$82" "MRD"@"SEL$82")]',
q'[USE_NL(@"SEL$B387F92E" "MRD"@"SEL$82")]',
q'[INDEX_RS_ASC(@"SEL$84" "MRD2"@"SEL$84" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$87" "MRD2"@"SEL$87" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[INDEX_RS_ASC(@"SEL$86" "MRD2"@"SEL$86" ("RPM_MERCH_RETAIL_DEF"."CLASS" "RPM_MERCH_RETAIL_DEF"."DEPT"))]',
q'[END_OUTLINE_DATA]');
:signature := SYS.DBMS_SQLTUNE.SQLTEXT_TO_SIGNATURE(sql_txt);
SYS.DBMS_SQLTUNE.IMPORT_SQL_PROFILE (
sql_text => sql_txt,
profile => h,
name => 'sqlt_s84500_p3693803053',
description => 's84500_mom1p_rtlmomdb2p 1nqj54uumu3yn 3693803053 '||:signature,
category => 'DEFAULT',
validate => TRUE,
replace => TRUE,
force_match => TRUE /* TRUE:FORCE (match even when different literals in SQL). FALSE:EXACT (similar to CURSOR_SHARING) */ );
SYS.DBMS_LOB.FREETEMPORARY(sql_txt);
END;
Summary:
Even with Oracle 10g database it is possible to do miracles if you deeply understand how it is working under the hood.
In 11g and later releases, you can accomplish the same by using Sql Plan Baselines that you can find on the link I’ve provided.
You should also be aware of limitations of the SQL Profile technology, as even with 19c, there is no replacement for your SQL/ PL/SQL & Java expertise.
Comments