GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name : SQL_TUNING_1702587181270
Tuning Task Owner : SYSTEM
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 1800
Completion Status : COMPLETED
Started at : 12/14/2023 22:53:04
Completed at : 12/14/2023 22:56:51
-------------------------------------------------------------------------------
Schema Name: APPS
SQL ID : crfq1hbng6wag
SQL Text : INSERT INTO "APPS"."RV$7B2BCC" (SELECT "A41"."LIST_HEADER_ID"
"LIST_HEADER_ID","A41"."NAME" "NAME","A41"."DESCRIPTION"
"DESCRIPTION","A41"."CURRENCY_CODE" "CURRENCY_CODE",(-1)
"PRICE_LIST_ID","A40"."CUST_ACCOUNT_ID" "CUST_ACCOUNT_ID",(-1)
"ORDER_TYPE_ID",NULL "QUALIFIER_CONTEXT1",999
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A84"."CURRENCY_CODE"
"CURRENCY_CODE","A84"."LIST_HEADER_ID"
"LIST_HEADER_ID","A84"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A83"."NAME" "NAME","A83"."DESCRIPTION"
"DESCRIPTION","A84"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A84","QP"."QP_LIST_HEADERS_TL" "A83"
WHERE "A84"."LIST_HEADER_ID"="A83"."LIST_HEADER_ID" AND
"A83"."LANGUAGE"=USERENV('LANG')) "A41","AR"."HZ_CUST_ACCOUNTS"
"A40" WHERE "A41"."ACTIVE_FLAG"='Y' AND
"A41"."LIST_TYPE_CODE"='DLT' AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A42" WHERE
"A42"."LIST_HEADER_ID"="A41"."LIST_HEADER_ID" AND
"A42"."LIST_LINE_ID"=(-1))) UNION ALL (SELECT
"A39"."LIST_HEADER_ID" "LIST_HEADER_ID","A39"."NAME"
"NAME","A39"."DESCRIPTION" "DESCRIPTION","A39"."CURRENCY_CODE"
"CURRENCY_CODE",(-1) "PRICE_LIST_ID","A37"."CUST_ACCOUNT_ID"
"CUST_ACCOUNT_ID",(-1) "ORDER_TYPE_ID","A38"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A38"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A82"."CURRENCY_CODE"
"CURRENCY_CODE","A82"."LIST_HEADER_ID"
"LIST_HEADER_ID","A82"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A81"."NAME" "NAME","A81"."DESCRIPTION"
"DESCRIPTION","A82"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A82","QP"."QP_LIST_HEADERS_TL" "A81"
WHERE "A82"."LIST_HEADER_ID"="A81"."LIST_HEADER_ID" AND
"A81"."LANGUAGE"=USERENV('LANG')) "A39","QP"."QP_QUALIFIERS"
"A38","AR"."HZ_CUST_ACCOUNTS" "A37" WHERE
"A39"."ACTIVE_FLAG"='Y' AND "A39"."LIST_TYPE_CODE"='DLT' AND
"A38"."LIST_HEADER_ID"="A39"."LIST_HEADER_ID" AND
"A38"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A38"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A37"."CUST_ACCOUNT_ID") OR
"A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A38"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A37"."SALES_CHANNEL_CODE"))
AND "A38"."ACTIVE_FLAG"='Y' AND
"A38"."COMPARISON_OPERATOR_CODE"='=' AND
"A38"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A38"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A38"."END_DA
TE_ACTIVE",SYSDATE@!+1) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A44" WHERE
"A44"."LIST_HEADER_ID"="A39"."LIST_HEADER_ID" AND
"A44"."QUALIFIER_CONTEXT"='ORDER' AND "A44"."ACTIVE_FLAG"='Y'
AND "A44"."COMPARISON_OPERATOR_CODE"='=' AND
"A44"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A44"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A44"."END_DA
TE_ACTIVE",SYSDATE@!+1)) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A43" WHERE
"A43"."LIST_HEADER_ID"="A39"."LIST_HEADER_ID" AND
"A43"."QUALIFIER_CONTEXT"='MODLIST' AND
"A43"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A43"."ACTIVE_FLAG"='Y' AND "A43"."COMPARISON_OPERATOR_CODE"='='
AND "A43"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A43"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A43"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A36"."LIST_HEADER_ID"
"LIST_HEADER_ID","A36"."NAME" "NAME","A36"."DESCRIPTION"
"DESCRIPTION","A36"."CURRENCY_CODE" "CURRENCY_CODE",(-1)
"PRICE_LIST_ID",(-1) "CUST_ACCOUNT_ID",(-1)
"ORDER_TYPE_ID","A35"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A35"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3","A35"."QUALIFIER_ATTR_VALUE"
"SITE_USE_ID",NULL "CDB_BRANCH" FROM (SELECT
"A80"."CURRENCY_CODE" "CURRENCY_CODE","A80"."LIST_HEADER_ID"
"LIST_HEADER_ID","A80"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A79"."NAME" "NAME","A79"."DESCRIPTION"
"DESCRIPTION","A80"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A80","QP"."QP_LIST_HEADERS_TL" "A79"
WHERE "A80"."LIST_HEADER_ID"="A79"."LIST_HEADER_ID" AND
"A79"."LANGUAGE"=USERENV('LANG')) "A36","QP"."QP_QUALIFIERS"
"A35" WHERE "A36"."ACTIVE_FLAG"='Y' AND
"A36"."LIST_TYPE_CODE"='DLT' AND
"A35"."LIST_HEADER_ID"="A36"."LIST_HEADER_ID" AND
"A35"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A35"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14' OR
"A35"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11') AND
"A35"."ACTIVE_FLAG"='Y' AND "A35"."COMPARISON_OPERATOR_CODE"='='
AND "A35"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A35"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A35"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A46" WHERE
"A46"."LIST_HEADER_ID"="A36"."LIST_HEADER_ID" AND
"A46"."QUALIFIER_CONTEXT"='ORDER' AND "A46"."ACTIVE_FLAG"='Y'
AND "A46"."COMPARISON_OPERATOR_CODE"='=' AND
"A46"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A46"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A46"."END_DA
TE_ACTIVE",SYSDATE@!+1)) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A45" WHERE
"A45"."LIST_HEADER_ID"="A36"."LIST_HEADER_ID" AND
"A45"."QUALIFIER_CONTEXT"='MODLIST' AND
"A45"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A45"."ACTIVE_FLAG"='Y' AND "A45"."COMPARISON_OPERATOR_CODE"='='
AND "A45"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A45"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A45"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A34"."LIST_HEADER_ID"
"LIST_HEADER_ID","A34"."NAME" "NAME","A34"."DESCRIPTION"
"DESCRIPTION","A34"."CURRENCY_CODE"
"CURRENCY_CODE",TO_NUMBER("A33"."QUALIFIER_ATTR_VALUE")
"PRICE_LIST_ID",(-1) "CUST_ACCOUNT_ID",(-1) "ORDER_TYPE_ID",NULL
"QUALIFIER_CONTEXT1",999 "QUALIFIER_PRECEDENCE1","A33"."QUALIFIER
_CONTEXT" "QUALIFIER_CONTEXT2","A33"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A78"."CURRENCY_CODE"
"CURRENCY_CODE","A78"."LIST_HEADER_ID"
"LIST_HEADER_ID","A78"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A77"."NAME" "NAME","A77"."DESCRIPTION"
"DESCRIPTION","A78"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A78","QP"."QP_LIST_HEADERS_TL" "A77"
WHERE "A78"."LIST_HEADER_ID"="A77"."LIST_HEADER_ID" AND
"A77"."LANGUAGE"=USERENV('LANG')) "A34","QP"."QP_QUALIFIERS"
"A33" WHERE "A34"."ACTIVE_FLAG"='Y' AND
"A34"."LIST_TYPE_CODE"='DLT' AND
"A33"."LIST_HEADER_ID"="A34"."LIST_HEADER_ID" AND
"A33"."QUALIFIER_CONTEXT"='MODLIST' AND
"A33"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A33"."ACTIVE_FLAG"='Y' AND "A33"."COMPARISON_OPERATOR_CODE"='='
AND "A33"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A33"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A33"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A48" WHERE
"A48"."LIST_HEADER_ID"="A34"."LIST_HEADER_ID" AND
"A48"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A48"."ACTIVE_FLAG"='Y'
AND "A48"."COMPARISON_OPERATOR_CODE"='=' AND
"A48"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A48"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A48"."END_DA
TE_ACTIVE",SYSDATE@!+1)) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A47" WHERE
"A47"."LIST_HEADER_ID"="A34"."LIST_HEADER_ID" AND
"A47"."QUALIFIER_CONTEXT"='ORDER' AND "A47"."ACTIVE_FLAG"='Y'
AND "A47"."COMPARISON_OPERATOR_CODE"='=' AND
"A47"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A47"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A47"."END_DA
TE_ACTIVE",SYSDATE@!+1))) UNION ALL (SELECT
"A32"."LIST_HEADER_ID" "LIST_HEADER_ID","A32"."NAME"
"NAME","A32"."DESCRIPTION" "DESCRIPTION","A32"."CURRENCY_CODE"
"CURRENCY_CODE",(-1) "PRICE_LIST_ID",(-1)
"CUST_ACCOUNT_ID",TO_NUMBER("A31"."QUALIFIER_ATTR_VALUE")
"ORDER_TYPE_ID",NULL "QUALIFIER_CONTEXT1",999
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2","A31"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT3","A31"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A76"."CURRENCY_CODE"
"CURRENCY_CODE","A76"."LIST_HEADER_ID"
"LIST_HEADER_ID","A76"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A75"."NAME" "NAME","A75"."DESCRIPTION"
"DESCRIPTION","A76"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A76","QP"."QP_LIST_HEADERS_TL" "A75"
WHERE "A76"."LIST_HEADER_ID"="A75"."LIST_HEADER_ID" AND
"A75"."LANGUAGE"=USERENV('LANG')) "A32","QP"."QP_QUALIFIERS"
"A31" WHERE "A32"."ACTIVE_FLAG"='Y' AND
"A32"."LIST_TYPE_CODE"='DLT' AND
"A31"."LIST_HEADER_ID"="A32"."LIST_HEADER_ID" AND
"A31"."QUALIFIER_CONTEXT"='ORDER' AND
"A31"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A31"."ACTIVE_FLAG"='Y' AND "A31"."COMPARISON_OPERATOR_CODE"='='
AND "A31"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A31"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A31"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A50" WHERE
"A50"."LIST_HEADER_ID"="A32"."LIST_HEADER_ID" AND
"A50"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A50"."ACTIVE_FLAG"='Y'
AND "A50"."COMPARISON_OPERATOR_CODE"='=' AND
"A50"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A50"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A50"."END_DA
TE_ACTIVE",SYSDATE@!+1)) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A49" WHERE
"A49"."LIST_HEADER_ID"="A32"."LIST_HEADER_ID" AND
"A49"."QUALIFIER_CONTEXT"='MODLIST' AND
"A49"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A49"."ACTIVE_FLAG"='Y' AND "A49"."COMPARISON_OPERATOR_CODE"='='
AND "A49"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A49"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A49"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A30"."LIST_HEADER_ID"
"LIST_HEADER_ID","A30"."NAME" "NAME","A30"."DESCRIPTION"
"DESCRIPTION","A30"."CURRENCY_CODE"
"CURRENCY_CODE",TO_NUMBER("A29"."QUALIFIER_ATTR_VALUE")
"PRICE_LIST_ID","A27"."CUST_ACCOUNT_ID" "CUST_ACCOUNT_ID",(-1)
"ORDER_TYPE_ID","A28"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A28"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1","A29"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A29"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A74"."CURRENCY_CODE"
"CURRENCY_CODE","A74"."LIST_HEADER_ID"
"LIST_HEADER_ID","A74"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A73"."NAME" "NAME","A73"."DESCRIPTION"
"DESCRIPTION","A74"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A74","QP"."QP_LIST_HEADERS_TL" "A73"
WHERE "A74"."LIST_HEADER_ID"="A73"."LIST_HEADER_ID" AND
"A73"."LANGUAGE"=USERENV('LANG')) "A30","QP"."QP_QUALIFIERS"
"A29","QP"."QP_QUALIFIERS" "A28","AR"."HZ_CUST_ACCOUNTS" "A27"
WHERE "A30"."ACTIVE_FLAG"='Y' AND "A30"."LIST_TYPE_CODE"='DLT'
AND "A29"."LIST_HEADER_ID"="A30"."LIST_HEADER_ID" AND
"A29"."QUALIFIER_CONTEXT"='MODLIST' AND
"A29"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A29"."ACTIVE_FLAG"='Y' AND "A29"."COMPARISON_OPERATOR_CODE"='='
AND "A29"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A29"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A29"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A28"."LIST_HEADER_ID"="A30"."LIST_HEADER_ID" AND
"A28"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A28"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A27"."CUST_ACCOUNT_ID") OR
"A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A28"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A27"."SALES_CHANNEL_CODE"))
AND "A28"."ACTIVE_FLAG"='Y' AND
"A28"."COMPARISON_OPERATOR_CODE"='=' AND
"A28"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A28"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A28"."END_DA
TE_ACTIVE",SYSDATE@!+1) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A51" WHERE
"A51"."LIST_HEADER_ID"="A30"."LIST_HEADER_ID" AND
"A51"."QUALIFIER_CONTEXT"='ORDER' AND
"A51"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A51"."ACTIVE_FLAG"='Y' AND "A51"."COMPARISON_OPERATOR_CODE"='='
AND "A51"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A51"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A51"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A26"."LIST_HEADER_ID"
"LIST_HEADER_ID","A26"."NAME" "NAME","A26"."DESCRIPTION"
"DESCRIPTION","A26"."CURRENCY_CODE"
"CURRENCY_CODE",TO_NUMBER("A25"."QUALIFIER_ATTR_VALUE")
"PRICE_LIST_ID",(-1) "CUST_ACCOUNT_ID",(-1)
"ORDER_TYPE_ID","A24"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A24"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1","A25"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A25"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3","A24"."QUALIFIER_ATTR_VALUE"
"SITE_USE_ID",NULL "CDB_BRANCH" FROM (SELECT
"A72"."CURRENCY_CODE" "CURRENCY_CODE","A72"."LIST_HEADER_ID"
"LIST_HEADER_ID","A72"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A71"."NAME" "NAME","A71"."DESCRIPTION"
"DESCRIPTION","A72"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A72","QP"."QP_LIST_HEADERS_TL" "A71"
WHERE "A72"."LIST_HEADER_ID"="A71"."LIST_HEADER_ID" AND
"A71"."LANGUAGE"=USERENV('LANG')) "A26","QP"."QP_QUALIFIERS"
"A25","QP"."QP_QUALIFIERS" "A24" WHERE "A26"."ACTIVE_FLAG"='Y'
AND "A26"."LIST_TYPE_CODE"='DLT' AND
"A25"."LIST_HEADER_ID"="A26"."LIST_HEADER_ID" AND
"A25"."QUALIFIER_CONTEXT"='MODLIST' AND
"A25"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A25"."ACTIVE_FLAG"='Y' AND "A25"."COMPARISON_OPERATOR_CODE"='='
AND "A25"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A25"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A25"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A24"."LIST_HEADER_ID"="A26"."LIST_HEADER_ID" AND
"A24"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A24"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14' OR
"A24"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11') AND
"A24"."ACTIVE_FLAG"='Y' AND "A24"."COMPARISON_OPERATOR_CODE"='='
AND "A24"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A24"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A24"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A52" WHERE
"A52"."LIST_HEADER_ID"="A26"."LIST_HEADER_ID" AND
"A52"."QUALIFIER_CONTEXT"='ORDER' AND
"A52"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A52"."ACTIVE_FLAG"='Y' AND "A52"."COMPARISON_OPERATOR_CODE"='='
AND "A52"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A52"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A52"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A23"."LIST_HEADER_ID"
"LIST_HEADER_ID","A23"."NAME" "NAME","A23"."DESCRIPTION"
"DESCRIPTION","A23"."CURRENCY_CODE" "CURRENCY_CODE",(-1)
"PRICE_LIST_ID","A20"."CUST_ACCOUNT_ID"
"CUST_ACCOUNT_ID",TO_NUMBER("A22"."QUALIFIER_ATTR_VALUE")
"ORDER_TYPE_ID","A22"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A22"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2","A21"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT3","A21"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A70"."CURRENCY_CODE"
"CURRENCY_CODE","A70"."LIST_HEADER_ID"
"LIST_HEADER_ID","A70"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A69"."NAME" "NAME","A69"."DESCRIPTION"
"DESCRIPTION","A70"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A70","QP"."QP_LIST_HEADERS_TL" "A69"
WHERE "A70"."LIST_HEADER_ID"="A69"."LIST_HEADER_ID" AND
"A69"."LANGUAGE"=USERENV('LANG')) "A23","QP"."QP_QUALIFIERS"
"A22","QP"."QP_QUALIFIERS" "A21","AR"."HZ_CUST_ACCOUNTS" "A20"
WHERE "A23"."ACTIVE_FLAG"='Y' AND "A23"."LIST_TYPE_CODE"='DLT'
AND "A22"."LIST_HEADER_ID"="A23"."LIST_HEADER_ID" AND
"A22"."QUALIFIER_CONTEXT"='ORDER' AND
"A22"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A22"."ACTIVE_FLAG"='Y' AND "A22"."COMPARISON_OPERATOR_CODE"='='
AND "A22"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A22"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A22"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A21"."LIST_HEADER_ID"="A23"."LIST_HEADER_ID" AND
"A21"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A21"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A20"."CUST_ACCOUNT_ID") OR
"A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A21"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A20"."SALES_CHANNEL_CODE"))
AND "A21"."ACTIVE_FLAG"='Y' AND
"A21"."COMPARISON_OPERATOR_CODE"='=' AND
"A21"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A21"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A21"."END_DA
TE_ACTIVE",SYSDATE@!+1) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A53" WHERE
"A53"."LIST_HEADER_ID"="A23"."LIST_HEADER_ID" AND
"A53"."QUALIFIER_CONTEXT"='MODLIST' AND
"A53"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A53"."ACTIVE_FLAG"='Y' AND "A53"."COMPARISON_OPERATOR_CODE"='='
AND "A53"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A53"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A53"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A19"."LIST_HEADER_ID"
"LIST_HEADER_ID","A19"."NAME" "NAME","A19"."DESCRIPTION"
"DESCRIPTION","A19"."CURRENCY_CODE" "CURRENCY_CODE",(-1)
"PRICE_LIST_ID",(-1) "CUST_ACCOUNT_ID",TO_NUMBER("A18"."QUALIFIER
_ATTR_VALUE") "ORDER_TYPE_ID","A18"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A18"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2","A17"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT3","A17"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE3","A17"."QUALIFIER_ATTR_VALUE"
"SITE_USE_ID",NULL "CDB_BRANCH" FROM (SELECT
"A68"."CURRENCY_CODE" "CURRENCY_CODE","A68"."LIST_HEADER_ID"
"LIST_HEADER_ID","A68"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A67"."NAME" "NAME","A67"."DESCRIPTION"
"DESCRIPTION","A68"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A68","QP"."QP_LIST_HEADERS_TL" "A67"
WHERE "A68"."LIST_HEADER_ID"="A67"."LIST_HEADER_ID" AND
"A67"."LANGUAGE"=USERENV('LANG')) "A19","QP"."QP_QUALIFIERS"
"A18","QP"."QP_QUALIFIERS" "A17" WHERE "A19"."ACTIVE_FLAG"='Y'
AND "A19"."LIST_TYPE_CODE"='DLT' AND
"A18"."LIST_HEADER_ID"="A19"."LIST_HEADER_ID" AND
"A18"."QUALIFIER_CONTEXT"='ORDER' AND
"A18"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A18"."ACTIVE_FLAG"='Y' AND "A18"."COMPARISON_OPERATOR_CODE"='='
AND "A18"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A18"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A18"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A17"."LIST_HEADER_ID"="A19"."LIST_HEADER_ID" AND
"A17"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A17"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14' OR
"A17"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11') AND
"A17"."ACTIVE_FLAG"='Y' AND "A17"."COMPARISON_OPERATOR_CODE"='='
AND "A17"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A17"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A17"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A54" WHERE
"A54"."LIST_HEADER_ID"="A19"."LIST_HEADER_ID" AND
"A54"."QUALIFIER_CONTEXT"='MODLIST' AND
"A54"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A54"."ACTIVE_FLAG"='Y' AND "A54"."COMPARISON_OPERATOR_CODE"='='
AND "A54"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A54"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A54"."END_DATE_ACTIVE",SYSDATE@!+1)))
UNION ALL (SELECT "A16"."LIST_HEADER_ID"
"LIST_HEADER_ID","A16"."NAME" "NAME","A16"."DESCRIPTION"
"DESCRIPTION","A16"."CURRENCY_CODE"
"CURRENCY_CODE",TO_NUMBER("A15"."QUALIFIER_ATTR_VALUE")
"PRICE_LIST_ID","A13"."CUST_ACCOUNT_ID"
"CUST_ACCOUNT_ID",TO_NUMBER("A14"."QUALIFIER_ATTR_VALUE")
"ORDER_TYPE_ID",NULL "QUALIFIER_CONTEXT1",999
"QUALIFIER_PRECEDENCE1","A15"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A15"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2","A14"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT3","A14"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A66"."CURRENCY_CODE"
"CURRENCY_CODE","A66"."LIST_HEADER_ID"
"LIST_HEADER_ID","A66"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A65"."NAME" "NAME","A65"."DESCRIPTION"
"DESCRIPTION","A66"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A66","QP"."QP_LIST_HEADERS_TL" "A65"
WHERE "A66"."LIST_HEADER_ID"="A65"."LIST_HEADER_ID" AND
"A65"."LANGUAGE"=USERENV('LANG')) "A16","QP"."QP_QUALIFIERS"
"A15","QP"."QP_QUALIFIERS" "A14","AR"."HZ_CUST_ACCOUNTS" "A13"
WHERE "A16"."ACTIVE_FLAG"='Y' AND "A16"."LIST_TYPE_CODE"='DLT'
AND "A15"."LIST_HEADER_ID"="A16"."LIST_HEADER_ID" AND
"A15"."QUALIFIER_CONTEXT"='MODLIST' AND
"A15"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A15"."ACTIVE_FLAG"='Y' AND "A15"."COMPARISON_OPERATOR_CODE"='='
AND "A15"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A15"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A15"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A14"."LIST_HEADER_ID"="A16"."LIST_HEADER_ID" AND
"A14"."QUALIFIER_CONTEXT"='ORDER' AND
"A14"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A14"."ACTIVE_FLAG"='Y' AND "A14"."COMPARISON_OPERATOR_CODE"='='
AND "A14"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A14"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A14"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A55" WHERE
"A55"."LIST_HEADER_ID"="A16"."LIST_HEADER_ID" AND
"A55"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A55"."ACTIVE_FLAG"='Y'
AND "A55"."COMPARISON_OPERATOR_CODE"='=' AND
"A55"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A55"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A55"."END_DA
TE_ACTIVE",SYSDATE@!+1))) UNION ALL (SELECT
"A12"."LIST_HEADER_ID" "LIST_HEADER_ID","A12"."NAME"
"NAME","A12"."DESCRIPTION" "DESCRIPTION","A12"."CURRENCY_CODE"
"CURRENCY_CODE",TO_NUMBER("A11"."QUALIFIER_ATTR_VALUE")
"PRICE_LIST_ID","A8"."CUST_ACCOUNT_ID"
"CUST_ACCOUNT_ID",TO_NUMBER("A9"."QUALIFIER_ATTR_VALUE")
"ORDER_TYPE_ID","A10"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A10"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2","A11"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A11"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2","A9"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT3","A9"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID",NULL "CDB_BRANCH"
FROM (SELECT "A64"."CURRENCY_CODE"
"CURRENCY_CODE","A64"."LIST_HEADER_ID"
"LIST_HEADER_ID","A64"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A63"."NAME" "NAME","A63"."DESCRIPTION"
"DESCRIPTION","A64"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A64","QP"."QP_LIST_HEADERS_TL" "A63"
WHERE "A64"."LIST_HEADER_ID"="A63"."LIST_HEADER_ID" AND
"A63"."LANGUAGE"=USERENV('LANG')) "A12","QP"."QP_QUALIFIERS"
"A11","QP"."QP_QUALIFIERS" "A10","QP"."QP_QUALIFIERS"
"A9","AR"."HZ_CUST_ACCOUNTS" "A8" WHERE "A12"."ACTIVE_FLAG"='Y'
AND "A12"."LIST_TYPE_CODE"='DLT' AND
"A11"."LIST_HEADER_ID"="A12"."LIST_HEADER_ID" AND
"A11"."QUALIFIER_CONTEXT"='MODLIST' AND
"A11"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A11"."ACTIVE_FLAG"='Y' AND "A11"."COMPARISON_OPERATOR_CODE"='='
AND "A11"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A11"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A11"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A10"."LIST_HEADER_ID"="A12"."LIST_HEADER_ID" AND
"A10"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A10"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A8"."CUST_ACCOUNT_ID") OR
"A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A10"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A8"."SALES_CHANNEL_CODE"))
AND "A10"."ACTIVE_FLAG"='Y' AND "A10"."COMPARISON_OPERATOR_CODE"=
'=' AND "A10"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A10"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A10"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A9"."LIST_HEADER_ID"="A12"."LIST_HEADER_ID" AND
"A9"."QUALIFIER_CONTEXT"='ORDER' AND
"A9"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A9"."ACTIVE_FLAG"='Y' AND "A9"."COMPARISON_OPERATOR_CODE"='='
AND "A9"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A9"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A9"."END_DATE_ACTIVE",SYSDATE@!+1)) UNION
ALL (SELECT "A7"."LIST_HEADER_ID" "LIST_HEADER_ID","A7"."NAME"
"NAME","A7"."DESCRIPTION" "DESCRIPTION","A7"."CURRENCY_CODE"
"CURRENCY_CODE",TO_NUMBER("A6"."QUALIFIER_ATTR_VALUE")
"PRICE_LIST_ID",(-1) "CUST_ACCOUNT_ID",TO_NUMBER("A4"."QUALIFIER_
ATTR_VALUE") "ORDER_TYPE_ID","A5"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A5"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2","A6"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT2","A6"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE2","A4"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT3","A4"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE3","A5"."QUALIFIER_ATTR_VALUE"
"SITE_USE_ID",NULL "CDB_BRANCH" FROM (SELECT
"A62"."CURRENCY_CODE" "CURRENCY_CODE","A62"."LIST_HEADER_ID"
"LIST_HEADER_ID","A62"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A61"."NAME" "NAME","A61"."DESCRIPTION"
"DESCRIPTION","A62"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A62","QP"."QP_LIST_HEADERS_TL" "A61"
WHERE "A62"."LIST_HEADER_ID"="A61"."LIST_HEADER_ID" AND
"A61"."LANGUAGE"=USERENV('LANG')) "A7","QP"."QP_QUALIFIERS"
"A6","QP"."QP_QUALIFIERS" "A5","QP"."QP_QUALIFIERS" "A4" WHERE
"A7"."ACTIVE_FLAG"='Y' AND "A7"."LIST_TYPE_CODE"='DLT' AND
"A6"."LIST_HEADER_ID"="A7"."LIST_HEADER_ID" AND
"A6"."QUALIFIER_CONTEXT"='MODLIST' AND
"A6"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A6"."ACTIVE_FLAG"='Y' AND "A6"."COMPARISON_OPERATOR_CODE"='='
AND "A6"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A6"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A6"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A5"."LIST_HEADER_ID"="A7"."LIST_HEADER_ID" AND
"A5"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A5"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14' OR
"A5"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11') AND
"A5"."ACTIVE_FLAG"='Y' AND "A5"."COMPARISON_OPERATOR_CODE"='='
AND "A5"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A5"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A5"."END_DATE_ACTIVE",SYSDATE@!+1) AND
"A4"."LIST_HEADER_ID"="A7"."LIST_HEADER_ID" AND
"A4"."QUALIFIER_CONTEXT"='ORDER' AND
"A4"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A4"."ACTIVE_FLAG"='Y' AND "A4"."COMPARISON_OPERATOR_CODE"='='
AND "A4"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A4"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A4"."END_DATE_ACTIVE",SYSDATE@!+1)) UNION
ALL (SELECT "A3"."LIST_HEADER_ID" "LIST_HEADER_ID","A3"."NAME"
"NAME","A3"."DESCRIPTION" "DESCRIPTION","A3"."CURRENCY_CODE"
"CURRENCY_CODE",(-1) "PRICE_LIST_ID",(-1) "CUST_ACCOUNT_ID",(-1)
"ORDER_TYPE_ID","A2"."QUALIFIER_CONTEXT"
"QUALIFIER_CONTEXT1","A2"."QUALIFIER_PRECEDENCE"
"QUALIFIER_PRECEDENCE1",NULL "QUALIFIER_CONTEXT2",999
"QUALIFIER_PRECEDENCE2",NULL "QUALIFIER_CONTEXT3",999
"QUALIFIER_PRECEDENCE3",NULL "SITE_USE_ID","A2"."QUALIFIER_ATTR_V
ALUE" "CDB_BRANCH" FROM (SELECT "A60"."CURRENCY_CODE"
"CURRENCY_CODE","A60"."LIST_HEADER_ID"
"LIST_HEADER_ID","A60"."LIST_TYPE_CODE"
"LIST_TYPE_CODE","A59"."NAME" "NAME","A59"."DESCRIPTION"
"DESCRIPTION","A60"."ACTIVE_FLAG" "ACTIVE_FLAG" FROM
"QP"."QP_LIST_HEADERS_B" "A60","QP"."QP_LIST_HEADERS_TL" "A59"
WHERE "A60"."LIST_HEADER_ID"="A59"."LIST_HEADER_ID" AND
"A59"."LANGUAGE"=USERENV('LANG')) "A3","QP"."QP_QUALIFIERS" "A2"
WHERE "A3"."ACTIVE_FLAG"='Y' AND "A3"."LIST_TYPE_CODE"='DLT' AND
"A2"."LIST_HEADER_ID"="A3"."LIST_HEADER_ID" AND
"A2"."QUALIFIER_CONTEXT"='CUSTOMER' AND
"A2"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE35' AND
"A2"."ACTIVE_FLAG"='Y' AND "A2"."COMPARISON_OPERATOR_CODE"='='
AND "A2"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A2"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A2"."END_DATE_ACTIVE",SYSDATE@!+1) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A58" WHERE
"A58"."LIST_HEADER_ID"="A3"."LIST_HEADER_ID" AND
"A58"."QUALIFIER_CONTEXT"='ORDER' AND "A58"."ACTIVE_FLAG"='Y'
AND "A58"."COMPARISON_OPERATOR_CODE"='=' AND
"A58"."LIST_LINE_ID"=(-1) AND TRUNC(SYSDATE@!)>=NVL("A58"."START_
DATE_ACTIVE",SYSDATE@!-1) AND TRUNC(SYSDATE@!)<=NVL("A58"."END_DA
TE_ACTIVE",SYSDATE@!+1)) AND NOT EXISTS (SELECT 1 FROM
"QP"."QP_QUALIFIERS" "A57" WHERE
"A57"."LIST_HEADER_ID"="A3"."LIST_HEADER_ID" AND
"A57"."QUALIFIER_CONTEXT"='MODLIST' AND
"A57"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND
"A57"."ACTIVE_FLAG"='Y' AND "A57"."COMPARISON_OPERATOR_CODE"='='
AND "A57"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A57"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A57"."END_DATE_ACTIVE",SYSDATE@!+1)) AND
NOT EXISTS (SELECT 1 FROM "QP"."QP_QUALIFIERS" "A56" WHERE
"A56"."LIST_HEADER_ID"="A3"."LIST_HEADER_ID" AND
"A56"."QUALIFIER_CONTEXT"='CUSTOMER' AND
("A56"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14' OR
"A56"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11') AND
"A56"."ACTIVE_FLAG"='Y' AND "A56"."COMPARISON_OPERATOR_CODE"='='
AND "A56"."LIST_LINE_ID"=(-1) AND
TRUNC(SYSDATE@!)>=NVL("A56"."START_DATE_ACTIVE",SYSDATE@!-1) AND
TRUNC(SYSDATE@!)<=NVL("A56"."END_DATE_ACTIVE",SYSDATE@!+1)))
-------------------------------------------------------------------------------
FINDINGS SECTION (3 findings)
-------------------------------------------------------------------------------
1- Statistics Finding
---------------------
Table "APPS"."RV$7B2BCC" was not analyzed.
Recommendation
--------------
- Consider collecting optimizer statistics for this table.
execute dbms_stats.gather_table_stats(ownname => 'APPS', tabname =>
'RV$7B2BCC', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE AUTO');
Rationale
---------
The optimizer requires up-to-date statistics for the table in order to
select a good execution plan.
2- SQL Profile Finding (see explain plans section below)
--------------------------------------------------------
A potentially better execution plan was found for this statement.
Recommendation (estimated benefit: 91.35%)
------------------------------------------
- A manually-created SQL profile is present on the system.
Name: SYS_SQLPROF_018c6a1efa090008
Status: ENABLED
Validation results
------------------
The SQL profile was tested by executing both its plan and the original plan
and measuring their respective execution statistics. A plan may have been
only partially executed if the other could be run to completion in less time.
Original Plan With SQL Profile % Improved
------------- ---------------- ----------
Completion Status: PARTIAL COMPLETE
Elapsed Time (s): 15.271037 1.642416 89.24 %
CPU Time (s): 6.478183 .748601 88.44 %
User I/O Time (s): .000611 .000551 9.81 %
Buffer Gets: 699657 60452 91.35 %
Physical Read Requests: 68 26 61.76 %
Physical Write Requests: 0 0
Physical Read Bytes: 679936 598016 12.04 %
Physical Write Bytes: 0 0
Rows Processed: 0 2169402
Fetches: 0 2169402
Executions: 0 1
3- Restructure SQL finding (see plan 1 in explain plans section)
----------------------------------------------------------------
An expensive cartesian product operation was found at line ID 3 of the
execution plan.
Recommendation
--------------
- Consider removing the disconnected table or view from this statement or
add a join condition which refers to it.
-------------------------------------------------------------------------------
EXPLAIN PLANS SECTION
-------------------------------------------------------------------------------
1- Original With Adjusted Cost
------------------------------
Plan hash value: 2857218771
--------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | 513M| 40G| 4388K (1)| 00:02:52 |
| 1 | LOAD TABLE CONVENTIONAL | RV$7B2BCC | | | | |
| 2 | UNION-ALL | | | | | |
| 3 | MERGE JOIN CARTESIAN | | 513M| 40G| 3156K (1)| 00:02:04 |
|* 4 | HASH JOIN | | 16206 | 1250K| 17473 (1)| 00:00:01 |
|* 5 | HASH JOIN RIGHT ANTI | | 7 | 196 | 17435 (1)| 00:00:01 |
| 6 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 29931 | 321K| 17371 (1)| 00:00:01 |
|* 7 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 8 | VIEW | index$_join$_003 | 700 | 11900 | 63 (0)| 00:00:01 |
|* 9 | HASH JOIN | | | | | |
|* 10 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N3 | 700 | 11900 | 24 (0)| 00:00:01 |
|* 11 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N7 | 700 | 11900 | 39 (0)| 00:00:01 |
|* 12 | TABLE ACCESS FULL | QP_LIST_HEADERS_TL | 7000 | 348K| 37 (0)| 00:00:01 |
| 13 | BUFFER SORT | | 31696 | 185K| 3156K (1)| 00:02:04 |
| 14 | INDEX FULL SCAN | HZ_CUST_ACCOUNTS_U1 | 31696 | 185K| 194 (2)| 00:00:01 |
| 15 | NESTED LOOPS | | 105 | 25095 | 108K (1)| 00:00:05 |
| 16 | NESTED LOOPS ANTI | | 17 | 3842 | 101K (1)| 00:00:04 |
| 17 | NESTED LOOPS ANTI | | 1657 | 310K| 92027 (1)| 00:00:04 |
| 18 | NESTED LOOPS | | 3698 | 491K| 69823 (1)| 00:00:03 |
| 19 | NESTED LOOPS | | 3698 | 306K| 58720 (1)| 00:00:03 |
|* 20 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 13772 | 914K| 17375 (1)| 00:00:01 |
|* 21 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 22 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 23 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 24 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 25 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|* 26 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 27 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 60 | 2040 | 6 (0)| 00:00:01 |
|* 28 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 29 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 6 | 78 | 387 (2)| 00:00:01 |
| 30 | NESTED LOOPS | | 1 | 226 | 59237 (1)| 00:00:03 |
| 31 | NESTED LOOPS | | 1 | 226 | 59237 (1)| 00:00:03 |
| 32 | NESTED LOOPS ANTI | | 1 | 175 | 59234 (1)| 00:00:03 |
| 33 | NESTED LOOPS ANTI | | 1602 | 220K| 49615 (1)| 00:00:02 |
| 34 | NESTED LOOPS | | 3576 | 296K| 28143 (1)| 00:00:02 |
|* 35 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 3587 | 238K| 17375 (1)| 00:00:01 |
|* 36 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 37 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
|* 38 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|* 39 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 40 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 4 | 136 | 6 (0)| 00:00:01 |
|* 41 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 42 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
| 43 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
| 44 | NESTED LOOPS ANTI | | 4 | 816 | 24643 (1)| 00:00:01 |
| 45 | NESTED LOOPS ANTI | | 380 | 64600 | 22361 (1)| 00:00:01 |
| 46 | NESTED LOOPS | | 415 | 56440 | 19869 (1)| 00:00:01 |
| 47 | NESTED LOOPS | | 415 | 35275 | 18623 (1)| 00:00:01 |
|* 48 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 28288 | 17375 (1)| 00:00:01 |
|* 49 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 50 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 51 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 52 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 53 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 5 | 170 | 6 (0)| 00:00:01 |
|* 54 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 55 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 457K| 6 (0)| 00:00:01 |
|* 56 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 57 | NESTED LOOPS ANTI | | 1 | 226 | 17477 (1)| 00:00:01 |
| 58 | NESTED LOOPS ANTI | | 1 | 192 | 17471 (1)| 00:00:01 |
| 59 | NESTED LOOPS | | 8 | 1088 | 17423 (1)| 00:00:01 |
| 60 | NESTED LOOPS | | 8 | 680 | 17399 (1)| 00:00:01 |
|* 61 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 544 | 17375 (1)| 00:00:01 |
|* 62 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 63 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 64 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 65 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 66 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 66 | 3696 | 6 (0)| 00:00:01 |
|* 67 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 68 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 457K| 6 (0)| 00:00:01 |
|* 69 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 70 | NESTED LOOPS | | 13778 | 3673K| 863K (2)| 00:00:34 |
| 71 | NESTED LOOPS | | 2169 | 550K| 24829 (1)| 00:00:01 |
| 72 | NESTED LOOPS ANTI | | 411 | 78912 | 22361 (1)| 00:00:01 |
| 73 | NESTED LOOPS | | 415 | 56440 | 19869 (1)| 00:00:01 |
| 74 | NESTED LOOPS | | 415 | 35275 | 18623 (1)| 00:00:01 |
|* 75 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 416 | 28288 | 17375 (1)| 00:00:01 |
|* 76 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 77 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 78 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 79 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 80 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 56 | 6 (0)| 00:00:01 |
|* 81 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 82 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
|* 83 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 84 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 6 | 78 | 386 (2)| 00:00:01 |
| 85 | NESTED LOOPS | | 2 | 520 | 22367 (1)| 00:00:01 |
| 86 | NESTED LOOPS | | 2 | 520 | 22367 (1)| 00:00:01 |
| 87 | NESTED LOOPS ANTI | | 1 | 192 | 22361 (1)| 00:00:01 |
| 88 | NESTED LOOPS | | 415 | 56440 | 19869 (1)| 00:00:01 |
| 89 | NESTED LOOPS | | 415 | 35275 | 18623 (1)| 00:00:01 |
|* 90 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 416 | 28288 | 17375 (1)| 00:00:01 |
|* 91 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|* 92 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 93 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 94 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 95 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 56 | 6 (0)| 00:00:01 |
|* 96 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 97 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 98 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 2 | 136 | 6 (0)| 00:00:01 |
| 99 | NESTED LOOPS | | 116 | 31668 | 24447 (1)| 00:00:01 |
| 100 | NESTED LOOPS | | 18 | 4680 | 17489 (1)| 00:00:01 |
| 101 | NESTED LOOPS ANTI | | 3 | 576 | 17471 (1)| 00:00:01 |
| 102 | NESTED LOOPS | | 8 | 1088 | 17423 (1)| 00:00:01 |
| 103 | NESTED LOOPS | | 8 | 680 | 17399 (1)| 00:00:01 |
|*104 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 8 | 544 | 17375 (1)| 00:00:01 |
|*105 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|*106 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 107 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*108 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*109 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|*110 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*111 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
|*112 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*113 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 6 | 78 | 387 (2)| 00:00:01 |
| 114 | NESTED LOOPS | | 6 | 1560 | 17489 (1)| 00:00:01 |
| 115 | NESTED LOOPS | | 6 | 1560 | 17489 (1)| 00:00:01 |
| 116 | NESTED LOOPS ANTI | | 3 | 576 | 17471 (1)| 00:00:01 |
| 117 | NESTED LOOPS | | 8 | 1088 | 17423 (1)| 00:00:01 |
| 118 | NESTED LOOPS | | 8 | 680 | 17399 (1)| 00:00:01 |
|*119 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 8 | 544 | 17375 (1)| 00:00:01 |
|*120 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|*121 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 122 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*123 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*124 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|*125 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*126 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*127 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 2 | 136 | 6 (0)| 00:00:01 |
| 128 | MERGE JOIN CARTESIAN | | 1452 | 345K| 22585 (1)| 00:00:01 |
| 129 | NESTED LOOPS ANTI | | 1 | 238 | 22391 (1)| 00:00:01 |
| 130 | NESTED LOOPS | | 5 | 1020 | 22361 (1)| 00:00:01 |
| 131 | NESTED LOOPS | | 415 | 56440 | 19869 (1)| 00:00:01 |
| 132 | NESTED LOOPS | | 415 | 35275 | 18623 (1)| 00:00:01 |
|*133 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 416 | 28288 | 17375 (1)| 00:00:01 |
|*134 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|*135 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 136 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*137 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*138 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*139 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*140 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 13772 | 457K| 6 (0)| 00:00:01 |
|*141 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 142 | BUFFER SORT | | 31696 | 185K| 22579 (1)| 00:00:01 |
| 143 | INDEX FULL SCAN | HZ_CUST_ACCOUNTS_U1 | 31696 | 185K| 194 (2)| 00:00:01 |
| 144 | NESTED LOOPS | | 154 | 43890 | 31668 (1)| 00:00:02 |
| 145 | NESTED LOOPS | | 24 | 6528 | 22391 (1)| 00:00:01 |
| 146 | NESTED LOOPS | | 5 | 1020 | 22361 (1)| 00:00:01 |
| 147 | NESTED LOOPS | | 415 | 56440 | 19869 (1)| 00:00:01 |
| 148 | NESTED LOOPS | | 415 | 35275 | 18623 (1)| 00:00:01 |
|*149 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 416 | 28288 | 17375 (1)| 00:00:01 |
|*150 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|*151 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 152 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*153 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*154 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*155 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*156 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
|*157 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*158 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 6 | 78 | 387 (2)| 00:00:01 |
| 159 | NESTED LOOPS | | 8 | 2176 | 22391 (1)| 00:00:01 |
| 160 | NESTED LOOPS | | 8 | 2176 | 22391 (1)| 00:00:01 |
| 161 | NESTED LOOPS | | 5 | 1020 | 22361 (1)| 00:00:01 |
| 162 | NESTED LOOPS | | 415 | 56440 | 19869 (1)| 00:00:01 |
| 163 | NESTED LOOPS | | 415 | 35275 | 18623 (1)| 00:00:01 |
|*164 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 416 | 28288 | 17375 (1)| 00:00:01 |
|*165 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|*166 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 167 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*168 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*169 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*170 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*171 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*172 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 2 | 136 | 6 (0)| 00:00:01 |
| 173 | NESTED LOOPS ANTI | | 1 | 282 | 17399 (1)| 00:00:01 |
| 174 | NESTED LOOPS ANTI | | 1 | 226 | 17393 (1)| 00:00:01 |
| 175 | NESTED LOOPS ANTI | | 1 | 170 | 17387 (1)| 00:00:01 |
| 176 | NESTED LOOPS | | 1 | 136 | 17381 (1)| 00:00:01 |
| 177 | NESTED LOOPS | | 1 | 85 | 17378 (1)| 00:00:01 |
|*178 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 1 | 68 | 17375 (1)| 00:00:01 |
|*179 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | 29828 | | 206 (1)| 00:00:01 |
|*180 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 181 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*182 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*183 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 5 | 170 | 6 (0)| 00:00:01 |
|*184 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*185 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 23296 | 6 (0)| 00:00:01 |
|*186 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*187 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 3587 | 196K| 6 (0)| 00:00:01 |
|*188 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("A84"."LIST_HEADER_ID"="A83"."LIST_HEADER_ID")
5 - access("A42"."LIST_HEADER_ID"="A84"."LIST_HEADER_ID")
7 - access("A42"."LIST_LINE_ID"=(-1))
8 - filter("A84"."LIST_TYPE_CODE"='DLT' AND "A84"."ACTIVE_FLAG"='Y')
9 - access(ROWID=ROWID)
10 - access("A84"."LIST_TYPE_CODE"='DLT')
11 - access("A84"."ACTIVE_FLAG"='Y')
12 - filter("A83"."LANGUAGE"=USERENV('LANG'))
20 - filter("A38"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A38"."ACTIVE_FLAG"='Y' AND
"A38"."COMPARISON_OPERATOR_CODE"='=' AND NVL("A38"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A38"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
21 - access("A38"."LIST_LINE_ID"=(-1))
22 - access("A38"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID" AND "A82"."LIST_TYPE_CODE"='DLT' AND
"A82"."ACTIVE_FLAG"='Y')
filter("A82"."ACTIVE_FLAG"='Y')
24 - access("A82"."LIST_HEADER_ID"="A81"."LIST_HEADER_ID" AND "A81"."LANGUAGE"=USERENV('LANG'))
25 - filter("A43"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A43"."QUALIFIER_CONTEXT"='MODLIST'
AND NVL("A43"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A43"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
26 - access("A43"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID" AND "A43"."LIST_LINE_ID"=(-1) AND
"A43"."COMPARISON_OPERATOR_CODE"='=' AND "A43"."ACTIVE_FLAG"='Y')
filter("A43"."ACTIVE_FLAG"='Y' AND "A43"."COMPARISON_OPERATOR_CODE"='=')
27 - filter("A44"."QUALIFIER_CONTEXT"='ORDER' AND NVL("A44"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@
!) AND NVL("A44"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
28 - access("A44"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID" AND "A44"."LIST_LINE_ID"=(-1) AND
"A44"."COMPARISON_OPERATOR_CODE"='=' AND "A44"."ACTIVE_FLAG"='Y')
filter("A44"."ACTIVE_FLAG"='Y' AND "A44"."COMPARISON_OPERATOR_CODE"='=')
29 - filter("A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A38"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A37"."CUST_ACCOUNT_ID") OR
"A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A38"."QUALIFIER_ATTR_VALUE"="A37"."SALES_CHANNEL_CODE" AND "A37"."SALES_CHANNEL_CODE" IS NOT NULL)
35 - filter("A35"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A35"."ACTIVE_FLAG"='Y' AND
"A35"."COMPARISON_OPERATOR_CODE"='=' AND ("A35"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11' OR
"A35"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A35"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A35"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
36 - access("A35"."LIST_LINE_ID"=(-1))
37 - access("A35"."LIST_HEADER_ID"="A80"."LIST_HEADER_ID" AND "A80"."LIST_TYPE_CODE"='DLT' AND
"A80"."ACTIVE_FLAG"='Y')
filter("A80"."ACTIVE_FLAG"='Y')
38 - filter("A45"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A45"."QUALIFIER_CONTEXT"='MODLIST'
AND NVL("A45"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A45"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
39 - access("A45"."LIST_HEADER_ID"="A80"."LIST_HEADER_ID" AND "A45"."LIST_LINE_ID"=(-1) AND
"A45"."COMPARISON_OPERATOR_CODE"='=' AND "A45"."ACTIVE_FLAG"='Y')
filter("A45"."ACTIVE_FLAG"='Y' AND "A45"."COMPARISON_OPERATOR_CODE"='=')
40 - filter("A46"."QUALIFIER_CONTEXT"='ORDER' AND NVL("A46"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@
!) AND NVL("A46"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
41 - access("A46"."LIST_HEADER_ID"="A80"."LIST_HEADER_ID" AND "A46"."LIST_LINE_ID"=(-1) AND
"A46"."COMPARISON_OPERATOR_CODE"='=' AND "A46"."ACTIVE_FLAG"='Y')
filter("A46"."ACTIVE_FLAG"='Y' AND "A46"."COMPARISON_OPERATOR_CODE"='=')
42 - access("A80"."LIST_HEADER_ID"="A79"."LIST_HEADER_ID" AND "A79"."LANGUAGE"=USERENV('LANG'))
48 - filter("A33"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A33"."QUALIFIER_CONTEXT"='MODLIST'
AND "A33"."ACTIVE_FLAG"='Y' AND "A33"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A33"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A33"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
49 - access("A33"."LIST_LINE_ID"=(-1))
50 - access("A33"."LIST_HEADER_ID"="A78"."LIST_HEADER_ID" AND "A78"."LIST_TYPE_CODE"='DLT' AND
"A78"."ACTIVE_FLAG"='Y')
filter("A78"."ACTIVE_FLAG"='Y')
52 - access("A78"."LIST_HEADER_ID"="A77"."LIST_HEADER_ID" AND "A77"."LANGUAGE"=USERENV('LANG'))
53 - filter("A47"."QUALIFIER_CONTEXT"='ORDER' AND NVL("A47"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@
!) AND NVL("A47"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
54 - access("A47"."LIST_HEADER_ID"="A78"."LIST_HEADER_ID" AND "A47"."LIST_LINE_ID"=(-1) AND
"A47"."COMPARISON_OPERATOR_CODE"='=' AND "A47"."ACTIVE_FLAG"='Y')
filter("A47"."ACTIVE_FLAG"='Y' AND "A47"."COMPARISON_OPERATOR_CODE"='=')
55 - filter("A48"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A48"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A48"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
56 - access("A48"."LIST_HEADER_ID"="A78"."LIST_HEADER_ID" AND "A48"."LIST_LINE_ID"=(-1) AND
"A48"."COMPARISON_OPERATOR_CODE"='=' AND "A48"."ACTIVE_FLAG"='Y')
filter("A48"."ACTIVE_FLAG"='Y' AND "A48"."COMPARISON_OPERATOR_CODE"='=')
61 - filter("A31"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A31"."QUALIFIER_CONTEXT"='ORDER' AND
"A31"."ACTIVE_FLAG"='Y' AND "A31"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A31"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A31"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
62 - access("A31"."LIST_LINE_ID"=(-1))
63 - access("A31"."LIST_HEADER_ID"="A76"."LIST_HEADER_ID" AND "A76"."LIST_TYPE_CODE"='DLT' AND
"A76"."ACTIVE_FLAG"='Y')
filter("A76"."ACTIVE_FLAG"='Y')
65 - access("A76"."LIST_HEADER_ID"="A75"."LIST_HEADER_ID" AND "A75"."LANGUAGE"=USERENV('LANG'))
66 - filter("A49"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A49"."QUALIFIER_CONTEXT"='MODLIST'
AND NVL("A49"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A49"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
67 - access("A49"."LIST_HEADER_ID"="A76"."LIST_HEADER_ID" AND "A49"."LIST_LINE_ID"=(-1) AND
"A49"."COMPARISON_OPERATOR_CODE"='=' AND "A49"."ACTIVE_FLAG"='Y')
filter("A49"."ACTIVE_FLAG"='Y' AND "A49"."COMPARISON_OPERATOR_CODE"='=')
68 - filter("A50"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A50"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A50"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
69 - access("A50"."LIST_HEADER_ID"="A76"."LIST_HEADER_ID" AND "A50"."LIST_LINE_ID"=(-1) AND
"A50"."COMPARISON_OPERATOR_CODE"='=' AND "A50"."ACTIVE_FLAG"='Y')
filter("A50"."ACTIVE_FLAG"='Y' AND "A50"."COMPARISON_OPERATOR_CODE"='=')
75 - filter("A29"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A29"."QUALIFIER_CONTEXT"='MODLIST'
AND "A29"."ACTIVE_FLAG"='Y' AND "A29"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A29"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A29"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
76 - access("A29"."LIST_LINE_ID"=(-1))
77 - access("A29"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID" AND "A74"."LIST_TYPE_CODE"='DLT' AND
"A74"."ACTIVE_FLAG"='Y')
filter("A74"."ACTIVE_FLAG"='Y')
79 - access("A74"."LIST_HEADER_ID"="A73"."LIST_HEADER_ID" AND "A73"."LANGUAGE"=USERENV('LANG'))
80 - filter("A51"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A51"."QUALIFIER_CONTEXT"='ORDER' AND
NVL("A51"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A51"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
81 - access("A51"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID" AND "A51"."LIST_LINE_ID"=(-1) AND
"A51"."COMPARISON_OPERATOR_CODE"='=' AND "A51"."ACTIVE_FLAG"='Y')
filter("A51"."ACTIVE_FLAG"='Y' AND "A51"."COMPARISON_OPERATOR_CODE"='=')
82 - filter("A28"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A28"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A28"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
83 - access("A28"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID" AND "A28"."LIST_LINE_ID"=(-1) AND
"A28"."COMPARISON_OPERATOR_CODE"='=' AND "A28"."ACTIVE_FLAG"='Y')
filter("A28"."ACTIVE_FLAG"='Y' AND "A28"."COMPARISON_OPERATOR_CODE"='=')
84 - filter("A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A28"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A27"."CUST_ACCOUNT_ID") OR
"A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A28"."QUALIFIER_ATTR_VALUE"="A27"."SALES_CHANNEL_CODE" AND "A27"."SALES_CHANNEL_CODE" IS NOT NULL)
90 - filter("A25"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A25"."QUALIFIER_CONTEXT"='MODLIST'
AND "A25"."ACTIVE_FLAG"='Y' AND "A25"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A25"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A25"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
91 - access("A25"."LIST_LINE_ID"=(-1))
92 - access("A25"."LIST_HEADER_ID"="A72"."LIST_HEADER_ID" AND "A72"."LIST_TYPE_CODE"='DLT' AND
"A72"."ACTIVE_FLAG"='Y')
filter("A72"."ACTIVE_FLAG"='Y')
94 - access("A72"."LIST_HEADER_ID"="A71"."LIST_HEADER_ID" AND "A71"."LANGUAGE"=USERENV('LANG'))
95 - filter("A52"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A52"."QUALIFIER_CONTEXT"='ORDER' AND
NVL("A52"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A52"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
96 - access("A52"."LIST_HEADER_ID"="A72"."LIST_HEADER_ID" AND "A52"."LIST_LINE_ID"=(-1) AND
"A52"."COMPARISON_OPERATOR_CODE"='=' AND "A52"."ACTIVE_FLAG"='Y')
filter("A52"."ACTIVE_FLAG"='Y' AND "A52"."COMPARISON_OPERATOR_CODE"='=')
97 - access("A24"."LIST_HEADER_ID"="A72"."LIST_HEADER_ID" AND "A24"."LIST_LINE_ID"=(-1) AND
"A24"."COMPARISON_OPERATOR_CODE"='=' AND "A24"."ACTIVE_FLAG"='Y')
filter("A24"."ACTIVE_FLAG"='Y' AND "A24"."COMPARISON_OPERATOR_CODE"='=')
98 - filter("A24"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A24"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A24"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A24"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A24"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
104 - filter("A22"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A22"."QUALIFIER_CONTEXT"='ORDER' AND
"A22"."ACTIVE_FLAG"='Y' AND "A22"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A22"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A22"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
105 - access("A22"."LIST_LINE_ID"=(-1))
106 - access("A22"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A70"."LIST_TYPE_CODE"='DLT' AND
"A70"."ACTIVE_FLAG"='Y')
filter("A70"."ACTIVE_FLAG"='Y')
108 - access("A70"."LIST_HEADER_ID"="A69"."LIST_HEADER_ID" AND "A69"."LANGUAGE"=USERENV('LANG'))
109 - filter("A53"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A53"."QUALIFIER_CONTEXT"='MODLIST'
AND NVL("A53"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A53"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
110 - access("A53"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A53"."LIST_LINE_ID"=(-1) AND
"A53"."COMPARISON_OPERATOR_CODE"='=' AND "A53"."ACTIVE_FLAG"='Y')
filter("A53"."ACTIVE_FLAG"='Y' AND "A53"."COMPARISON_OPERATOR_CODE"='=')
111 - filter("A21"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A21"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A21"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
112 - access("A21"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A21"."LIST_LINE_ID"=(-1) AND
"A21"."COMPARISON_OPERATOR_CODE"='=' AND "A21"."ACTIVE_FLAG"='Y')
filter("A21"."ACTIVE_FLAG"='Y' AND "A21"."COMPARISON_OPERATOR_CODE"='=')
113 - filter("A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A21"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A20"."CUST_ACCOUNT_ID") OR
"A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A21"."QUALIFIER_ATTR_VALUE"="A20"."SALES_CHANNEL_CODE" AND "A20"."SALES_CHANNEL_CODE" IS NOT NULL)
119 - filter("A18"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A18"."QUALIFIER_CONTEXT"='ORDER' AND
"A18"."ACTIVE_FLAG"='Y' AND "A18"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A18"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A18"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
120 - access("A18"."LIST_LINE_ID"=(-1))
121 - access("A18"."LIST_HEADER_ID"="A68"."LIST_HEADER_ID" AND "A68"."LIST_TYPE_CODE"='DLT' AND
"A68"."ACTIVE_FLAG"='Y')
filter("A68"."ACTIVE_FLAG"='Y')
123 - access("A68"."LIST_HEADER_ID"="A67"."LIST_HEADER_ID" AND "A67"."LANGUAGE"=USERENV('LANG'))
124 - filter("A54"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A54"."QUALIFIER_CONTEXT"='MODLIST'
AND NVL("A54"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A54"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
125 - access("A54"."LIST_HEADER_ID"="A68"."LIST_HEADER_ID" AND "A54"."LIST_LINE_ID"=(-1) AND
"A54"."COMPARISON_OPERATOR_CODE"='=' AND "A54"."ACTIVE_FLAG"='Y')
filter("A54"."ACTIVE_FLAG"='Y' AND "A54"."COMPARISON_OPERATOR_CODE"='=')
126 - access("A17"."LIST_HEADER_ID"="A68"."LIST_HEADER_ID" AND "A17"."LIST_LINE_ID"=(-1) AND
"A17"."COMPARISON_OPERATOR_CODE"='=' AND "A17"."ACTIVE_FLAG"='Y')
filter("A17"."ACTIVE_FLAG"='Y' AND "A17"."COMPARISON_OPERATOR_CODE"='=')
127 - filter("A17"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A17"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A17"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A17"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A17"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
133 - filter("A15"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A15"."QUALIFIER_CONTEXT"='MODLIST'
AND "A15"."ACTIVE_FLAG"='Y' AND "A15"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A15"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A15"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
134 - access("A15"."LIST_LINE_ID"=(-1))
135 - access("A15"."LIST_HEADER_ID"="A66"."LIST_HEADER_ID" AND "A66"."LIST_TYPE_CODE"='DLT' AND
"A66"."ACTIVE_FLAG"='Y')
filter("A66"."ACTIVE_FLAG"='Y')
137 - access("A66"."LIST_HEADER_ID"="A65"."LIST_HEADER_ID" AND "A65"."LANGUAGE"=USERENV('LANG'))
138 - filter("A14"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A14"."QUALIFIER_CONTEXT"='ORDER' AND
NVL("A14"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A14"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
139 - access("A14"."LIST_HEADER_ID"="A66"."LIST_HEADER_ID" AND "A14"."LIST_LINE_ID"=(-1) AND
"A14"."COMPARISON_OPERATOR_CODE"='=' AND "A14"."ACTIVE_FLAG"='Y')
filter("A14"."ACTIVE_FLAG"='Y' AND "A14"."COMPARISON_OPERATOR_CODE"='=')
140 - filter("A55"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A55"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A55"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
141 - access("A55"."LIST_HEADER_ID"="A66"."LIST_HEADER_ID" AND "A55"."LIST_LINE_ID"=(-1) AND
"A55"."COMPARISON_OPERATOR_CODE"='=' AND "A55"."ACTIVE_FLAG"='Y')
filter("A55"."ACTIVE_FLAG"='Y' AND "A55"."COMPARISON_OPERATOR_CODE"='=')
149 - filter("A11"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A11"."QUALIFIER_CONTEXT"='MODLIST'
AND "A11"."ACTIVE_FLAG"='Y' AND "A11"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A11"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A11"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
150 - access("A11"."LIST_LINE_ID"=(-1))
151 - access("A11"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A64"."LIST_TYPE_CODE"='DLT' AND
"A64"."ACTIVE_FLAG"='Y')
filter("A64"."ACTIVE_FLAG"='Y')
153 - access("A64"."LIST_HEADER_ID"="A63"."LIST_HEADER_ID" AND "A63"."LANGUAGE"=USERENV('LANG'))
154 - filter("A9"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A9"."QUALIFIER_CONTEXT"='ORDER' AND
NVL("A9"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A9"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
155 - access("A9"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A9"."LIST_LINE_ID"=(-1) AND
"A9"."COMPARISON_OPERATOR_CODE"='=' AND "A9"."ACTIVE_FLAG"='Y')
filter("A9"."ACTIVE_FLAG"='Y' AND "A9"."COMPARISON_OPERATOR_CODE"='=')
156 - filter("A10"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A10"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A10"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
157 - access("A10"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A10"."LIST_LINE_ID"=(-1) AND
"A10"."COMPARISON_OPERATOR_CODE"='=' AND "A10"."ACTIVE_FLAG"='Y')
filter("A10"."ACTIVE_FLAG"='Y' AND "A10"."COMPARISON_OPERATOR_CODE"='=')
158 - filter("A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A10"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A8"."CUST_ACCOUNT_ID") OR
"A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND
"A10"."QUALIFIER_ATTR_VALUE"="A8"."SALES_CHANNEL_CODE" AND "A8"."SALES_CHANNEL_CODE" IS NOT NULL)
164 - filter("A6"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A6"."QUALIFIER_CONTEXT"='MODLIST' AND
"A6"."ACTIVE_FLAG"='Y' AND "A6"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A6"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A6"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
165 - access("A6"."LIST_LINE_ID"=(-1))
166 - access("A6"."LIST_HEADER_ID"="A62"."LIST_HEADER_ID" AND "A62"."LIST_TYPE_CODE"='DLT' AND
"A62"."ACTIVE_FLAG"='Y')
filter("A62"."ACTIVE_FLAG"='Y')
168 - access("A62"."LIST_HEADER_ID"="A61"."LIST_HEADER_ID" AND "A61"."LANGUAGE"=USERENV('LANG'))
169 - filter("A4"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND "A4"."QUALIFIER_CONTEXT"='ORDER' AND
NVL("A4"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A4"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
170 - access("A4"."LIST_HEADER_ID"="A62"."LIST_HEADER_ID" AND "A4"."LIST_LINE_ID"=(-1) AND
"A4"."COMPARISON_OPERATOR_CODE"='=' AND "A4"."ACTIVE_FLAG"='Y')
filter("A4"."ACTIVE_FLAG"='Y' AND "A4"."COMPARISON_OPERATOR_CODE"='=')
171 - access("A5"."LIST_HEADER_ID"="A62"."LIST_HEADER_ID" AND "A5"."LIST_LINE_ID"=(-1) AND
"A5"."COMPARISON_OPERATOR_CODE"='=' AND "A5"."ACTIVE_FLAG"='Y')
filter("A5"."ACTIVE_FLAG"='Y' AND "A5"."COMPARISON_OPERATOR_CODE"='=')
172 - filter("A5"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A5"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A5"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A5"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A5"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
178 - filter("A2"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE35' AND "A2"."QUALIFIER_CONTEXT"='CUSTOMER'
AND "A2"."ACTIVE_FLAG"='Y' AND "A2"."COMPARISON_OPERATOR_CODE"='=' AND
NVL("A2"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A2"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
179 - access("A2"."LIST_LINE_ID"=(-1))
180 - access("A2"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A60"."LIST_TYPE_CODE"='DLT' AND
"A60"."ACTIVE_FLAG"='Y')
filter("A60"."ACTIVE_FLAG"='Y')
182 - access("A60"."LIST_HEADER_ID"="A59"."LIST_HEADER_ID" AND "A59"."LANGUAGE"=USERENV('LANG'))
183 - filter("A58"."QUALIFIER_CONTEXT"='ORDER' AND NVL("A58"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@
!) AND NVL("A58"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
184 - access("A58"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A58"."LIST_LINE_ID"=(-1) AND
"A58"."COMPARISON_OPERATOR_CODE"='=' AND "A58"."ACTIVE_FLAG"='Y')
filter("A58"."ACTIVE_FLAG"='Y' AND "A58"."COMPARISON_OPERATOR_CODE"='=')
185 - filter("A57"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A57"."QUALIFIER_CONTEXT"='MODLIST'
AND NVL("A57"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A57"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
186 - access("A57"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A57"."LIST_LINE_ID"=(-1) AND
"A57"."COMPARISON_OPERATOR_CODE"='=' AND "A57"."ACTIVE_FLAG"='Y')
filter("A57"."ACTIVE_FLAG"='Y' AND "A57"."COMPARISON_OPERATOR_CODE"='=')
187 - filter("A56"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A56"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A56"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A56"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A56"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
188 - access("A56"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A56"."LIST_LINE_ID"=(-1) AND
"A56"."COMPARISON_OPERATOR_CODE"='=' AND "A56"."ACTIVE_FLAG"='Y')
filter("A56"."ACTIVE_FLAG"='Y' AND "A56"."COMPARISON_OPERATOR_CODE"='=')
2- Using SQL Profile
--------------------
Plan hash value: 4051570013
----------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | 230K| 20M| 7099 (1)| 00:00:01 |
| 1 | LOAD TABLE CONVENTIONAL | RV$7B2BCC | | | | |
| 2 | UNION-ALL | | | | | |
|* 3 | HASH JOIN | | 221K| 17M| 292 (3)| 00:00:01 |
|* 4 | TABLE ACCESS FULL | QP_LIST_HEADERS_TL | 7000 | 348K| 37 (0)| 00:00:01 |
| 5 | MERGE JOIN CARTESIAN | | 221K| 7367K| 253 (2)| 00:00:01 |
|* 6 | HASH JOIN ANTI | | 7 | 196 | 97 (2)| 00:00:01 |
|* 7 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|* 8 | INDEX FAST FULL SCAN | QP_QUALIFIERS_N1 | 29931 | 321K| 85 (2)| 00:00:01 |
| 9 | BUFFER SORT | | 31696 | 185K| 168 (2)| 00:00:01 |
| 10 | INDEX FAST FULL SCAN | HZ_CUST_ACCOUNTS_U1 | 31696 | 185K| 22 (0)| 00:00:01 |
| 11 | CONCATENATION | | | | | |
|* 12 | HASH JOIN | | 1351 | 315K| 842 (1)| 00:00:01 |
| 13 | NESTED LOOPS | | 17 | 3842 | 453 (1)| 00:00:01 |
| 14 | NESTED LOOPS | | 17 | 3842 | 453 (1)| 00:00:01 |
| 15 | NESTED LOOPS | | 3 | 474 | 435 (1)| 00:00:01 |
|* 16 | HASH JOIN RIGHT ANTI | | 3 | 321 | 426 (1)| 00:00:01 |
|* 17 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 60 | 2040 | 174 (0)| 00:00:01 |
|* 18 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 57 | | 33 (0)| 00:00:01 |
|* 19 | HASH JOIN ANTI | | 314 | 22922 | 252 (2)| 00:00:01 |
|* 20 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|* 21 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 416 | 23296 | 240 (2)| 00:00:01 |
| 22 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 23 | BITMAP AND | | | | | |
| 24 | BITMAP CONVERSION FROM ROWIDS | | | | | |
| 25 | SORT ORDER BY | | | | | |
|* 26 | INDEX RANGE SCAN | QP_QUALIFIERS_N13 | | | 33 (0)| 00:00:01 |
| 27 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 28 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | | | 206 (1)| 00:00:01 |
| 29 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 30 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 31 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 32 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
|* 33 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 12481 | 158K| 388 (2)| 00:00:01 |
|* 34 | HASH JOIN | | 18 | 4302 | 842 (1)| 00:00:01 |
| 35 | NESTED LOOPS | | 17 | 3842 | 453 (1)| 00:00:01 |
| 36 | NESTED LOOPS | | 17 | 3842 | 453 (1)| 00:00:01 |
| 37 | NESTED LOOPS | | 3 | 474 | 435 (1)| 00:00:01 |
|* 38 | HASH JOIN RIGHT ANTI | | 3 | 321 | 426 (1)| 00:00:01 |
|* 39 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 60 | 2040 | 174 (0)| 00:00:01 |
|* 40 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 57 | | 33 (0)| 00:00:01 |
|* 41 | HASH JOIN ANTI | | 314 | 22922 | 252 (2)| 00:00:01 |
|* 42 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|* 43 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 416 | 23296 | 240 (2)| 00:00:01 |
| 44 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 45 | BITMAP AND | | | | | |
| 46 | BITMAP CONVERSION FROM ROWIDS | | | | | |
| 47 | SORT ORDER BY | | | | | |
|* 48 | INDEX RANGE SCAN | QP_QUALIFIERS_N13 | | | 33 (0)| 00:00:01 |
| 49 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 50 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | | | 206 (1)| 00:00:01 |
| 51 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 52 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 53 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 54 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
| 55 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 31696 | 402K| 388 (2)| 00:00:01 |
| 56 | NESTED LOOPS | | 2 | 452 | 441 (1)| 00:00:01 |
| 57 | NESTED LOOPS | | 2 | 452 | 441 (1)| 00:00:01 |
| 58 | NESTED LOOPS | | 1 | 158 | 435 (1)| 00:00:01 |
|* 59 | HASH JOIN RIGHT ANTI | | 3 | 321 | 426 (1)| 00:00:01 |
|* 60 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 60 | 2040 | 174 (0)| 00:00:01 |
|* 61 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 57 | | 33 (0)| 00:00:01 |
|* 62 | HASH JOIN ANTI | | 314 | 22922 | 252 (2)| 00:00:01 |
|* 63 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|* 64 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 23296 | 240 (2)| 00:00:01 |
| 65 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 66 | BITMAP AND | | | | | |
| 67 | BITMAP CONVERSION FROM ROWIDS | | | | | |
| 68 | SORT ORDER BY | | | | | |
|* 69 | INDEX RANGE SCAN | QP_QUALIFIERS_N13 | | | 33 (0)| 00:00:01 |
| 70 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 71 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | | | 206 (1)| 00:00:01 |
| 72 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 73 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 74 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|* 75 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 2 | 136 | 6 (0)| 00:00:01 |
| 76 | NESTED LOOPS ANTI | | 1 | 204 | 435 (1)| 00:00:01 |
| 77 | NESTED LOOPS | | 1 | 170 | 429 (1)| 00:00:01 |
|* 78 | HASH JOIN RIGHT ANTI | | 1 | 119 | 426 (1)| 00:00:01 |
|* 79 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 60 | 2040 | 174 (0)| 00:00:01 |
|* 80 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 57 | | 33 (0)| 00:00:01 |
|* 81 | HASH JOIN | | 415 | 35275 | 252 (2)| 00:00:01 |
|* 82 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|* 83 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 28288 | 240 (2)| 00:00:01 |
| 84 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 85 | BITMAP AND | | | | | |
| 86 | BITMAP CONVERSION FROM ROWIDS | | | | | |
| 87 | SORT ORDER BY | | | | | |
|* 88 | INDEX RANGE SCAN | QP_QUALIFIERS_N13 | | | 33 (0)| 00:00:01 |
| 89 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 90 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | | | 206 (1)| 00:00:01 |
| 91 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|* 92 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|* 93 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 457K| 6 (0)| 00:00:01 |
|* 94 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 95 | NESTED LOOPS ANTI | | 1 | 226 | 111 (0)| 00:00:01 |
| 96 | NESTED LOOPS | | 1 | 170 | 105 (0)| 00:00:01 |
| 97 | NESTED LOOPS ANTI | | 1 | 119 | 102 (0)| 00:00:01 |
|* 98 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|* 99 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*100 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*101 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*102 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 457K| 6 (0)| 00:00:01 |
|*103 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 104 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 13 | 663 | 3 (0)| 00:00:01 |
|*105 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*106 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 23296 | 6 (0)| 00:00:01 |
|*107 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 108 | CONCATENATION | | | | | |
|*109 | HASH JOIN | | 3146 | 838K| 753 (2)| 00:00:01 |
|*110 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 12481 | 158K| 388 (2)| 00:00:01 |
|*111 | HASH JOIN | | 2169 | 550K| 365 (2)| 00:00:01 |
|*112 | HASH JOIN | | 411 | 78912 | 332 (2)| 00:00:01 |
|*113 | HASH JOIN RIGHT ANTI | | 411 | 57951 | 294 (2)| 00:00:01 |
|*114 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 448 | 42 (0)| 00:00:01 |
|*115 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*116 | HASH JOIN | | 415 | 35275 | 252 (2)| 00:00:01 |
|*117 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*118 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 28288 | 240 (2)| 00:00:01 |
| 119 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 120 | BITMAP AND | | | | | |
| 121 | BITMAP CONVERSION FROM ROWIDS | | | | | |
| 122 | SORT ORDER BY | | | | | |
|*123 | INDEX RANGE SCAN | QP_QUALIFIERS_N13 | | | 33 (0)| 00:00:01 |
| 124 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|*125 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | | | 206 (1)| 00:00:01 |
|*126 | TABLE ACCESS FULL | QP_LIST_HEADERS_TL | 7000 | 348K| 37 (0)| 00:00:01 |
|*127 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 914K| 33 (0)| 00:00:01 |
|*128 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 2 | | 27 (0)| 00:00:01 |
|*129 | HASH JOIN | | 2395 | 638K| 753 (2)| 00:00:01 |
|*130 | HASH JOIN | | 2169 | 550K| 365 (2)| 00:00:01 |
|*131 | HASH JOIN | | 411 | 78912 | 332 (2)| 00:00:01 |
|*132 | HASH JOIN RIGHT ANTI | | 411 | 57951 | 294 (2)| 00:00:01 |
|*133 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 448 | 42 (0)| 00:00:01 |
|*134 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*135 | HASH JOIN | | 415 | 35275 | 252 (2)| 00:00:01 |
|*136 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*137 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 28288 | 240 (2)| 00:00:01 |
| 138 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 139 | BITMAP AND | | | | | |
| 140 | BITMAP CONVERSION FROM ROWIDS | | | | | |
| 141 | SORT ORDER BY | | | | | |
|*142 | INDEX RANGE SCAN | QP_QUALIFIERS_N13 | | | 33 (0)| 00:00:01 |
| 143 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|*144 | INDEX RANGE SCAN | QP_QUALIFIERS_N2 | | | 206 (1)| 00:00:01 |
|*145 | TABLE ACCESS FULL | QP_LIST_HEADERS_TL | 7000 | 348K| 37 (0)| 00:00:01 |
|*146 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 914K| 33 (0)| 00:00:01 |
|*147 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 2 | | 27 (0)| 00:00:01 |
| 148 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 31696 | 402K| 388 (2)| 00:00:01 |
| 149 | NESTED LOOPS | | 2 | 520 | 128 (1)| 00:00:01 |
| 150 | NESTED LOOPS | | 2 | 520 | 128 (1)| 00:00:01 |
| 151 | NESTED LOOPS | | 1 | 192 | 122 (1)| 00:00:01 |
|*152 | HASH JOIN | | 5 | 620 | 92 (2)| 00:00:01 |
|*153 | HASH JOIN RIGHT ANTI | | 692 | 50516 | 54 (0)| 00:00:01 |
|*154 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 448 | 42 (0)| 00:00:01 |
|*155 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*156 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*157 | TABLE ACCESS FULL | QP_LIST_HEADERS_TL | 7000 | 348K| 37 (0)| 00:00:01 |
|*158 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*159 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*160 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*161 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 2 | 136 | 6 (0)| 00:00:01 |
| 162 | CONCATENATION | | | | | |
|*163 | HASH JOIN | | 1490 | 397K| 518 (1)| 00:00:01 |
| 164 | NESTED LOOPS | | 18 | 4680 | 129 (0)| 00:00:01 |
| 165 | NESTED LOOPS | | 18 | 4680 | 129 (0)| 00:00:01 |
| 166 | NESTED LOOPS | | 3 | 576 | 111 (0)| 00:00:01 |
| 167 | NESTED LOOPS ANTI | | 3 | 423 | 102 (0)| 00:00:01 |
|*168 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*169 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*170 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*171 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*172 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|*173 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 174 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*175 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*176 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*177 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
|*178 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 12481 | 158K| 388 (2)| 00:00:01 |
|*179 | HASH JOIN | | 20 | 5460 | 518 (1)| 00:00:01 |
| 180 | NESTED LOOPS | | 18 | 4680 | 129 (0)| 00:00:01 |
| 181 | NESTED LOOPS | | 18 | 4680 | 129 (0)| 00:00:01 |
| 182 | NESTED LOOPS | | 3 | 576 | 111 (0)| 00:00:01 |
| 183 | NESTED LOOPS ANTI | | 3 | 423 | 102 (0)| 00:00:01 |
|*184 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*185 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*186 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*187 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*188 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|*189 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 190 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*191 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*192 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*193 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
| 194 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 31696 | 402K| 388 (2)| 00:00:01 |
| 195 | NESTED LOOPS ANTI | | 1 | 260 | 111 (0)| 00:00:01 |
| 196 | NESTED LOOPS | | 1 | 204 | 105 (0)| 00:00:01 |
| 197 | NESTED LOOPS | | 1 | 153 | 102 (0)| 00:00:01 |
|*198 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*199 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*200 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*201 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*202 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*203 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 204 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*205 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*206 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 230 | 12880 | 6 (0)| 00:00:01 |
|*207 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 208 | MERGE JOIN CARTESIAN | | 317 | 77348 | 135 (1)| 00:00:01 |
| 209 | NESTED LOOPS ANTI | | 1 | 238 | 111 (0)| 00:00:01 |
| 210 | NESTED LOOPS | | 1 | 204 | 105 (0)| 00:00:01 |
| 211 | NESTED LOOPS | | 1 | 153 | 102 (0)| 00:00:01 |
|*212 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*213 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*214 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*215 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*216 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*217 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 218 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*219 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*220 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 13772 | 457K| 6 (0)| 00:00:01 |
|*221 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 222 | BUFFER SORT | | 31696 | 185K| 129 (1)| 00:00:01 |
| 223 | INDEX FAST FULL SCAN | HZ_CUST_ACCOUNTS_U1 | 31696 | 185K| 23 (0)| 00:00:01 |
| 224 | CONCATENATION | | | | | |
|*225 | HASH JOIN | | 35 | 9975 | 536 (1)| 00:00:01 |
| 226 | NESTED LOOPS | | 24 | 6528 | 147 (0)| 00:00:01 |
| 227 | NESTED LOOPS | | 24 | 6528 | 147 (0)| 00:00:01 |
| 228 | NESTED LOOPS | | 5 | 1020 | 117 (0)| 00:00:01 |
| 229 | NESTED LOOPS | | 5 | 765 | 102 (0)| 00:00:01 |
|*230 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*231 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*232 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*233 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*234 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*235 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 236 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*237 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*238 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*239 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
|*240 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 12481 | 158K| 388 (2)| 00:00:01 |
|*241 | HASH JOIN | | 27 | 7695 | 536 (1)| 00:00:01 |
| 242 | NESTED LOOPS | | 24 | 6528 | 147 (0)| 00:00:01 |
| 243 | NESTED LOOPS | | 24 | 6528 | 147 (0)| 00:00:01 |
| 244 | NESTED LOOPS | | 5 | 1020 | 117 (0)| 00:00:01 |
| 245 | NESTED LOOPS | | 5 | 765 | 102 (0)| 00:00:01 |
|*246 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*247 | TABLE ACCESS BY INDEX ROWID BATCHED| QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*248 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*249 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*250 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*251 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 252 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*253 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*254 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*255 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 5 | 340 | 6 (0)| 00:00:01 |
| 256 | TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 31696 | 402K| 388 (2)| 00:00:01 |
| 257 | NESTED LOOPS | | 2 | 544 | 111 (0)| 00:00:01 |
| 258 | NESTED LOOPS | | 2 | 544 | 111 (0)| 00:00:01 |
| 259 | NESTED LOOPS | | 1 | 204 | 105 (0)| 00:00:01 |
| 260 | NESTED LOOPS | | 1 | 153 | 102 (0)| 00:00:01 |
|*261 | HASH JOIN | | 8 | 680 | 54 (0)| 00:00:01 |
|*262 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 8 | 544 | 42 (0)| 00:00:01 |
|*263 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 6 | | 27 (0)| 00:00:01 |
|*264 | INDEX FAST FULL SCAN | QP_LIST_HEADERS_B_N1 | 700 | 11900 | 12 (0)| 00:00:01 |
|*265 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 6 (0)| 00:00:01 |
|*266 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
| 267 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*268 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*269 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*270 | TABLE ACCESS BY INDEX ROWID | QP_QUALIFIERS | 2 | 136 | 6 (0)| 00:00:01 |
| 271 | NESTED LOOPS ANTI | | 1 | 282 | 36 (0)| 00:00:01 |
| 272 | NESTED LOOPS ANTI | | 1 | 226 | 30 (0)| 00:00:01 |
| 273 | NESTED LOOPS ANTI | | 1 | 170 | 24 (0)| 00:00:01 |
| 274 | NESTED LOOPS | | 1 | 136 | 18 (0)| 00:00:01 |
| 275 | NESTED LOOPS | | 1 | 85 | 15 (0)| 00:00:01 |
|*276 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 1 | 68 | 12 (0)| 00:00:01 |
|*277 | INDEX RANGE SCAN | QP_QUALIFIERS_N4 | 1 | | 9 (0)| 00:00:01 |
|*278 | INDEX RANGE SCAN | QP_LIST_HEADERS_B_N9 | 1 | 17 | 3 (0)| 00:00:01 |
| 279 | TABLE ACCESS BY INDEX ROWID | QP_LIST_HEADERS_TL | 1 | 51 | 3 (0)| 00:00:01 |
|*280 | INDEX UNIQUE SCAN | QP_LIST_HEADERS_TL_PK | 1 | | 1 (0)| 00:00:01 |
|*281 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 5 | 170 | 6 (0)| 00:00:01 |
|*282 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*283 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 416 | 23296 | 6 (0)| 00:00:01 |
|*284 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
|*285 | TABLE ACCESS BY INDEX ROWID BATCHED | QP_QUALIFIERS | 3587 | 196K| 6 (0)| 00:00:01 |
|*286 | INDEX RANGE SCAN | QP_QUALIFIERS_N1 | 1 | | 3 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("A84"."LIST_HEADER_ID"="A83"."LIST_HEADER_ID")
4 - filter("A83"."LANGUAGE"=USERENV('LANG'))
6 - access("A42"."LIST_HEADER_ID"="A84"."LIST_HEADER_ID")
7 - filter("A84"."LIST_TYPE_CODE"='DLT' AND "A84"."ACTIVE_FLAG"='Y')
8 - filter("A42"."LIST_LINE_ID"=(-1))
12 - access("A38"."QUALIFIER_ATTR_VALUE"="A37"."SALES_CHANNEL_CODE")
16 - access("A44"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID")
17 - filter(NVL("A44"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A44"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
18 - access("A44"."QUALIFIER_CONTEXT"='ORDER' AND "A44"."COMPARISON_OPERATOR_CODE"='=' AND
"A44"."ACTIVE_FLAG"='Y' AND "A44"."LIST_LINE_ID"=(-1))
filter("A44"."LIST_LINE_ID"=(-1) AND "A44"."ACTIVE_FLAG"='Y' AND "A44"."COMPARISON_OPERATOR_CODE"='=')
19 - access("A43"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID")
20 - filter("A82"."LIST_TYPE_CODE"='DLT' AND "A82"."ACTIVE_FLAG"='Y')
21 - filter(NVL("A43"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A43"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
26 - access("A43"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A43"."QUALIFIER_CONTEXT"='MODLIST' AND
"A43"."COMPARISON_OPERATOR_CODE"='=' AND "A43"."ACTIVE_FLAG"='Y')
filter("A43"."ACTIVE_FLAG"='Y' AND "A43"."COMPARISON_OPERATOR_CODE"='=' AND
"A43"."QUALIFIER_CONTEXT"='MODLIST' AND "A43"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4')
28 - access("A43"."LIST_LINE_ID"=(-1))
30 - access("A82"."LIST_HEADER_ID"="A81"."LIST_HEADER_ID" AND "A81"."LANGUAGE"=USERENV('LANG'))
31 - access("A38"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID" AND "A38"."LIST_LINE_ID"=(-1) AND
"A38"."COMPARISON_OPERATOR_CODE"='=' AND "A38"."ACTIVE_FLAG"='Y')
filter("A38"."ACTIVE_FLAG"='Y' AND "A38"."COMPARISON_OPERATOR_CODE"='=')
32 - filter("A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND "A38"."QUALIFIER_CONTEXT"='CUSTOMER'
AND NVL("A38"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A38"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
33 - filter("A37"."SALES_CHANNEL_CODE" IS NOT NULL)
34 - access("A38"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A37"."CUST_ACCOUNT_ID"))
filter(LNNVL("A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13') OR
LNNVL("A38"."QUALIFIER_ATTR_VALUE"="A37"."SALES_CHANNEL_CODE") OR LNNVL("A37"."SALES_CHANNEL_CODE" IS NOT
NULL))
38 - access("A44"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID")
39 - filter(NVL("A44"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A44"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
40 - access("A44"."QUALIFIER_CONTEXT"='ORDER' AND "A44"."COMPARISON_OPERATOR_CODE"='=' AND
"A44"."ACTIVE_FLAG"='Y' AND "A44"."LIST_LINE_ID"=(-1))
filter("A44"."LIST_LINE_ID"=(-1) AND "A44"."ACTIVE_FLAG"='Y' AND "A44"."COMPARISON_OPERATOR_CODE"='=')
41 - access("A43"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID")
42 - filter("A82"."LIST_TYPE_CODE"='DLT' AND "A82"."ACTIVE_FLAG"='Y')
43 - filter(NVL("A43"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A43"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
48 - access("A43"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A43"."QUALIFIER_CONTEXT"='MODLIST' AND
"A43"."COMPARISON_OPERATOR_CODE"='=' AND "A43"."ACTIVE_FLAG"='Y')
filter("A43"."ACTIVE_FLAG"='Y' AND "A43"."COMPARISON_OPERATOR_CODE"='=' AND
"A43"."QUALIFIER_CONTEXT"='MODLIST' AND "A43"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4')
50 - access("A43"."LIST_LINE_ID"=(-1))
52 - access("A82"."LIST_HEADER_ID"="A81"."LIST_HEADER_ID" AND "A81"."LANGUAGE"=USERENV('LANG'))
53 - access("A38"."LIST_HEADER_ID"="A82"."LIST_HEADER_ID" AND "A38"."LIST_LINE_ID"=(-1) AND
"A38"."COMPARISON_OPERATOR_CODE"='=' AND "A38"."ACTIVE_FLAG"='Y')
filter("A38"."ACTIVE_FLAG"='Y' AND "A38"."COMPARISON_OPERATOR_CODE"='=')
54 - filter("A38"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND "A38"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A38"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A38"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
59 - access("A46"."LIST_HEADER_ID"="A80"."LIST_HEADER_ID")
60 - filter(NVL("A46"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A46"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
61 - access("A46"."QUALIFIER_CONTEXT"='ORDER' AND "A46"."COMPARISON_OPERATOR_CODE"='=' AND
"A46"."ACTIVE_FLAG"='Y' AND "A46"."LIST_LINE_ID"=(-1))
filter("A46"."LIST_LINE_ID"=(-1) AND "A46"."ACTIVE_FLAG"='Y' AND "A46"."COMPARISON_OPERATOR_CODE"='=')
62 - access("A45"."LIST_HEADER_ID"="A80"."LIST_HEADER_ID")
63 - filter("A80"."LIST_TYPE_CODE"='DLT' AND "A80"."ACTIVE_FLAG"='Y')
64 - filter(NVL("A45"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A45"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
69 - access("A45"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A45"."QUALIFIER_CONTEXT"='MODLIST' AND
"A45"."COMPARISON_OPERATOR_CODE"='=' AND "A45"."ACTIVE_FLAG"='Y')
filter("A45"."ACTIVE_FLAG"='Y' AND "A45"."COMPARISON_OPERATOR_CODE"='=' AND
"A45"."QUALIFIER_CONTEXT"='MODLIST' AND "A45"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4')
71 - access("A45"."LIST_LINE_ID"=(-1))
73 - access("A80"."LIST_HEADER_ID"="A79"."LIST_HEADER_ID" AND "A79"."LANGUAGE"=USERENV('LANG'))
74 - access("A35"."LIST_HEADER_ID"="A80"."LIST_HEADER_ID" AND "A35"."LIST_LINE_ID"=(-1) AND
"A35"."COMPARISON_OPERATOR_CODE"='=' AND "A35"."ACTIVE_FLAG"='Y')
filter("A35"."ACTIVE_FLAG"='Y' AND "A35"."COMPARISON_OPERATOR_CODE"='=')
75 - filter("A35"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A35"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A35"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A35"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A35"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
78 - access("A47"."LIST_HEADER_ID"="A78"."LIST_HEADER_ID")
79 - filter(NVL("A47"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A47"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
80 - access("A47"."QUALIFIER_CONTEXT"='ORDER' AND "A47"."COMPARISON_OPERATOR_CODE"='=' AND
"A47"."ACTIVE_FLAG"='Y' AND "A47"."LIST_LINE_ID"=(-1))
filter("A47"."LIST_LINE_ID"=(-1) AND "A47"."ACTIVE_FLAG"='Y' AND "A47"."COMPARISON_OPERATOR_CODE"='=')
81 - access("A33"."LIST_HEADER_ID"="A78"."LIST_HEADER_ID")
82 - filter("A78"."LIST_TYPE_CODE"='DLT' AND "A78"."ACTIVE_FLAG"='Y')
83 - filter(NVL("A33"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A33"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
88 - access("A33"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A33"."QUALIFIER_CONTEXT"='MODLIST' AND
"A33"."COMPARISON_OPERATOR_CODE"='=' AND "A33"."ACTIVE_FLAG"='Y')
filter("A33"."ACTIVE_FLAG"='Y' AND "A33"."COMPARISON_OPERATOR_CODE"='=' AND
"A33"."QUALIFIER_CONTEXT"='MODLIST' AND "A33"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4')
90 - access("A33"."LIST_LINE_ID"=(-1))
92 - access("A78"."LIST_HEADER_ID"="A77"."LIST_HEADER_ID" AND "A77"."LANGUAGE"=USERENV('LANG'))
93 - filter("A48"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A48"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A48"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
94 - access("A48"."LIST_HEADER_ID"="A78"."LIST_HEADER_ID" AND "A48"."LIST_LINE_ID"=(-1) AND
"A48"."COMPARISON_OPERATOR_CODE"='=' AND "A48"."ACTIVE_FLAG"='Y')
filter("A48"."ACTIVE_FLAG"='Y' AND "A48"."COMPARISON_OPERATOR_CODE"='=')
98 - access("A31"."LIST_HEADER_ID"="A76"."LIST_HEADER_ID")
99 - filter(NVL("A31"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A31"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
100 - access("A31"."QUALIFIER_CONTEXT"='ORDER' AND "A31"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A31"."COMPARISON_OPERATOR_CODE"='=' AND "A31"."ACTIVE_FLAG"='Y' AND "A31"."LIST_LINE_ID"=(-1))
filter("A31"."LIST_LINE_ID"=(-1) AND "A31"."ACTIVE_FLAG"='Y' AND "A31"."COMPARISON_OPERATOR_CODE"='=')
101 - filter("A76"."LIST_TYPE_CODE"='DLT' AND "A76"."ACTIVE_FLAG"='Y')
102 - filter("A50"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A50"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A50"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
103 - access("A50"."LIST_HEADER_ID"="A76"."LIST_HEADER_ID" AND "A50"."LIST_LINE_ID"=(-1) AND
"A50"."COMPARISON_OPERATOR_CODE"='=' AND "A50"."ACTIVE_FLAG"='Y')
filter("A50"."ACTIVE_FLAG"='Y' AND "A50"."COMPARISON_OPERATOR_CODE"='=')
105 - access("A76"."LIST_HEADER_ID"="A75"."LIST_HEADER_ID" AND "A75"."LANGUAGE"=USERENV('LANG'))
106 - filter("A49"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A49"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A49"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A49"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
107 - access("A49"."LIST_HEADER_ID"="A76"."LIST_HEADER_ID" AND "A49"."LIST_LINE_ID"=(-1) AND
"A49"."COMPARISON_OPERATOR_CODE"='=' AND "A49"."ACTIVE_FLAG"='Y')
filter("A49"."ACTIVE_FLAG"='Y' AND "A49"."COMPARISON_OPERATOR_CODE"='=')
109 - access("A28"."QUALIFIER_ATTR_VALUE"="A27"."SALES_CHANNEL_CODE")
110 - filter("A27"."SALES_CHANNEL_CODE" IS NOT NULL)
111 - access("A28"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID")
112 - access("A74"."LIST_HEADER_ID"="A73"."LIST_HEADER_ID")
113 - access("A51"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID")
114 - filter(NVL("A51"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A51"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
115 - access("A51"."QUALIFIER_CONTEXT"='ORDER' AND "A51"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A51"."COMPARISON_OPERATOR_CODE"='=' AND "A51"."ACTIVE_FLAG"='Y' AND "A51"."LIST_LINE_ID"=(-1))
filter("A51"."LIST_LINE_ID"=(-1) AND "A51"."ACTIVE_FLAG"='Y' AND "A51"."COMPARISON_OPERATOR_CODE"='=')
116 - access("A29"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID")
117 - filter("A74"."LIST_TYPE_CODE"='DLT' AND "A74"."ACTIVE_FLAG"='Y')
118 - filter(NVL("A29"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A29"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
123 - access("A29"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A29"."QUALIFIER_CONTEXT"='MODLIST' AND
"A29"."COMPARISON_OPERATOR_CODE"='=' AND "A29"."ACTIVE_FLAG"='Y')
filter("A29"."ACTIVE_FLAG"='Y' AND "A29"."COMPARISON_OPERATOR_CODE"='=' AND
"A29"."QUALIFIER_CONTEXT"='MODLIST' AND "A29"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4')
125 - access("A29"."LIST_LINE_ID"=(-1))
126 - filter("A73"."LANGUAGE"=USERENV('LANG'))
127 - filter(NVL("A28"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A28"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
128 - access("A28"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13'
AND "A28"."COMPARISON_OPERATOR_CODE"='=' AND "A28"."ACTIVE_FLAG"='Y' AND "A28"."LIST_LINE_ID"=(-1))
filter("A28"."LIST_LINE_ID"=(-1) AND "A28"."ACTIVE_FLAG"='Y' AND "A28"."COMPARISON_OPERATOR_CODE"='=')
129 - access("A28"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A27"."CUST_ACCOUNT_ID"))
filter(LNNVL("A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13') OR
LNNVL("A28"."QUALIFIER_ATTR_VALUE"="A27"."SALES_CHANNEL_CODE") OR LNNVL("A27"."SALES_CHANNEL_CODE" IS NOT
NULL))
130 - access("A28"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID")
131 - access("A74"."LIST_HEADER_ID"="A73"."LIST_HEADER_ID")
132 - access("A51"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID")
133 - filter(NVL("A51"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A51"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
134 - access("A51"."QUALIFIER_CONTEXT"='ORDER' AND "A51"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A51"."COMPARISON_OPERATOR_CODE"='=' AND "A51"."ACTIVE_FLAG"='Y' AND "A51"."LIST_LINE_ID"=(-1))
filter("A51"."LIST_LINE_ID"=(-1) AND "A51"."ACTIVE_FLAG"='Y' AND "A51"."COMPARISON_OPERATOR_CODE"='=')
135 - access("A29"."LIST_HEADER_ID"="A74"."LIST_HEADER_ID")
136 - filter("A74"."LIST_TYPE_CODE"='DLT' AND "A74"."ACTIVE_FLAG"='Y')
137 - filter(NVL("A29"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A29"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
142 - access("A29"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A29"."QUALIFIER_CONTEXT"='MODLIST' AND
"A29"."COMPARISON_OPERATOR_CODE"='=' AND "A29"."ACTIVE_FLAG"='Y')
filter("A29"."ACTIVE_FLAG"='Y' AND "A29"."COMPARISON_OPERATOR_CODE"='=' AND
"A29"."QUALIFIER_CONTEXT"='MODLIST' AND "A29"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4')
144 - access("A29"."LIST_LINE_ID"=(-1))
145 - filter("A73"."LANGUAGE"=USERENV('LANG'))
146 - filter(NVL("A28"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A28"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
147 - access("A28"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A28"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND
"A28"."COMPARISON_OPERATOR_CODE"='=' AND "A28"."ACTIVE_FLAG"='Y' AND "A28"."LIST_LINE_ID"=(-1))
filter("A28"."LIST_LINE_ID"=(-1) AND "A28"."ACTIVE_FLAG"='Y' AND "A28"."COMPARISON_OPERATOR_CODE"='=')
152 - access("A72"."LIST_HEADER_ID"="A71"."LIST_HEADER_ID")
153 - access("A52"."LIST_HEADER_ID"="A72"."LIST_HEADER_ID")
154 - filter(NVL("A52"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A52"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
155 - access("A52"."QUALIFIER_CONTEXT"='ORDER' AND "A52"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A52"."COMPARISON_OPERATOR_CODE"='=' AND "A52"."ACTIVE_FLAG"='Y' AND "A52"."LIST_LINE_ID"=(-1))
filter("A52"."LIST_LINE_ID"=(-1) AND "A52"."ACTIVE_FLAG"='Y' AND "A52"."COMPARISON_OPERATOR_CODE"='=')
156 - filter("A72"."LIST_TYPE_CODE"='DLT' AND "A72"."ACTIVE_FLAG"='Y')
157 - filter("A71"."LANGUAGE"=USERENV('LANG'))
158 - filter("A25"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A25"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A25"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A25"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
159 - access("A25"."LIST_HEADER_ID"="A72"."LIST_HEADER_ID" AND "A25"."LIST_LINE_ID"=(-1) AND
"A25"."COMPARISON_OPERATOR_CODE"='=' AND "A25"."ACTIVE_FLAG"='Y')
filter("A25"."ACTIVE_FLAG"='Y' AND "A25"."COMPARISON_OPERATOR_CODE"='=')
160 - access("A24"."LIST_HEADER_ID"="A72"."LIST_HEADER_ID" AND "A24"."LIST_LINE_ID"=(-1) AND
"A24"."COMPARISON_OPERATOR_CODE"='=' AND "A24"."ACTIVE_FLAG"='Y')
filter("A24"."ACTIVE_FLAG"='Y' AND "A24"."COMPARISON_OPERATOR_CODE"='=')
161 - filter("A24"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A24"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A24"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A24"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A24"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
163 - access("A21"."QUALIFIER_ATTR_VALUE"="A20"."SALES_CHANNEL_CODE")
168 - access("A22"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID")
169 - filter(NVL("A22"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A22"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
170 - access("A22"."QUALIFIER_CONTEXT"='ORDER' AND "A22"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A22"."COMPARISON_OPERATOR_CODE"='=' AND "A22"."ACTIVE_FLAG"='Y' AND "A22"."LIST_LINE_ID"=(-1))
filter("A22"."LIST_LINE_ID"=(-1) AND "A22"."ACTIVE_FLAG"='Y' AND "A22"."COMPARISON_OPERATOR_CODE"='=')
171 - filter("A70"."LIST_TYPE_CODE"='DLT' AND "A70"."ACTIVE_FLAG"='Y')
172 - filter("A53"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A53"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A53"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A53"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
173 - access("A53"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A53"."LIST_LINE_ID"=(-1) AND
"A53"."COMPARISON_OPERATOR_CODE"='=' AND "A53"."ACTIVE_FLAG"='Y')
filter("A53"."ACTIVE_FLAG"='Y' AND "A53"."COMPARISON_OPERATOR_CODE"='=')
175 - access("A70"."LIST_HEADER_ID"="A69"."LIST_HEADER_ID" AND "A69"."LANGUAGE"=USERENV('LANG'))
176 - access("A21"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A21"."LIST_LINE_ID"=(-1) AND
"A21"."COMPARISON_OPERATOR_CODE"='=' AND "A21"."ACTIVE_FLAG"='Y')
filter("A21"."ACTIVE_FLAG"='Y' AND "A21"."COMPARISON_OPERATOR_CODE"='=')
177 - filter("A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND "A21"."QUALIFIER_CONTEXT"='CUSTOMER'
AND NVL("A21"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A21"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
178 - filter("A20"."SALES_CHANNEL_CODE" IS NOT NULL)
179 - access("A21"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A20"."CUST_ACCOUNT_ID"))
filter(LNNVL("A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13') OR
LNNVL("A21"."QUALIFIER_ATTR_VALUE"="A20"."SALES_CHANNEL_CODE") OR LNNVL("A20"."SALES_CHANNEL_CODE" IS NOT
NULL))
184 - access("A22"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID")
185 - filter(NVL("A22"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A22"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
186 - access("A22"."QUALIFIER_CONTEXT"='ORDER' AND "A22"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A22"."COMPARISON_OPERATOR_CODE"='=' AND "A22"."ACTIVE_FLAG"='Y' AND "A22"."LIST_LINE_ID"=(-1))
filter("A22"."LIST_LINE_ID"=(-1) AND "A22"."ACTIVE_FLAG"='Y' AND "A22"."COMPARISON_OPERATOR_CODE"='=')
187 - filter("A70"."LIST_TYPE_CODE"='DLT' AND "A70"."ACTIVE_FLAG"='Y')
188 - filter("A53"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A53"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A53"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A53"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
189 - access("A53"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A53"."LIST_LINE_ID"=(-1) AND
"A53"."COMPARISON_OPERATOR_CODE"='=' AND "A53"."ACTIVE_FLAG"='Y')
filter("A53"."ACTIVE_FLAG"='Y' AND "A53"."COMPARISON_OPERATOR_CODE"='=')
191 - access("A70"."LIST_HEADER_ID"="A69"."LIST_HEADER_ID" AND "A69"."LANGUAGE"=USERENV('LANG'))
192 - access("A21"."LIST_HEADER_ID"="A70"."LIST_HEADER_ID" AND "A21"."LIST_LINE_ID"=(-1) AND
"A21"."COMPARISON_OPERATOR_CODE"='=' AND "A21"."ACTIVE_FLAG"='Y')
filter("A21"."ACTIVE_FLAG"='Y' AND "A21"."COMPARISON_OPERATOR_CODE"='=')
193 - filter("A21"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND "A21"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A21"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A21"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
198 - access("A18"."LIST_HEADER_ID"="A68"."LIST_HEADER_ID")
199 - filter(NVL("A18"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A18"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
200 - access("A18"."QUALIFIER_CONTEXT"='ORDER' AND "A18"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A18"."COMPARISON_OPERATOR_CODE"='=' AND "A18"."ACTIVE_FLAG"='Y' AND "A18"."LIST_LINE_ID"=(-1))
filter("A18"."LIST_LINE_ID"=(-1) AND "A18"."ACTIVE_FLAG"='Y' AND "A18"."COMPARISON_OPERATOR_CODE"='=')
201 - filter("A68"."LIST_TYPE_CODE"='DLT' AND "A68"."ACTIVE_FLAG"='Y')
202 - filter("A17"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A17"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A17"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A17"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A17"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
203 - access("A17"."LIST_HEADER_ID"="A68"."LIST_HEADER_ID" AND "A17"."LIST_LINE_ID"=(-1) AND
"A17"."COMPARISON_OPERATOR_CODE"='=' AND "A17"."ACTIVE_FLAG"='Y')
filter("A17"."ACTIVE_FLAG"='Y' AND "A17"."COMPARISON_OPERATOR_CODE"='=')
205 - access("A68"."LIST_HEADER_ID"="A67"."LIST_HEADER_ID" AND "A67"."LANGUAGE"=USERENV('LANG'))
206 - filter("A54"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A54"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A54"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A54"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
207 - access("A54"."LIST_HEADER_ID"="A68"."LIST_HEADER_ID" AND "A54"."LIST_LINE_ID"=(-1) AND
"A54"."COMPARISON_OPERATOR_CODE"='=' AND "A54"."ACTIVE_FLAG"='Y')
filter("A54"."ACTIVE_FLAG"='Y' AND "A54"."COMPARISON_OPERATOR_CODE"='=')
212 - access("A14"."LIST_HEADER_ID"="A66"."LIST_HEADER_ID")
213 - filter(NVL("A14"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A14"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
214 - access("A14"."QUALIFIER_CONTEXT"='ORDER' AND "A14"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A14"."COMPARISON_OPERATOR_CODE"='=' AND "A14"."ACTIVE_FLAG"='Y' AND "A14"."LIST_LINE_ID"=(-1))
filter("A14"."LIST_LINE_ID"=(-1) AND "A14"."ACTIVE_FLAG"='Y' AND "A14"."COMPARISON_OPERATOR_CODE"='=')
215 - filter("A66"."LIST_TYPE_CODE"='DLT' AND "A66"."ACTIVE_FLAG"='Y')
216 - filter("A15"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A15"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A15"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A15"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
217 - access("A15"."LIST_HEADER_ID"="A66"."LIST_HEADER_ID" AND "A15"."LIST_LINE_ID"=(-1) AND
"A15"."COMPARISON_OPERATOR_CODE"='=' AND "A15"."ACTIVE_FLAG"='Y')
filter("A15"."ACTIVE_FLAG"='Y' AND "A15"."COMPARISON_OPERATOR_CODE"='=')
219 - access("A66"."LIST_HEADER_ID"="A65"."LIST_HEADER_ID" AND "A65"."LANGUAGE"=USERENV('LANG'))
220 - filter("A55"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A55"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A55"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
221 - access("A55"."LIST_HEADER_ID"="A66"."LIST_HEADER_ID" AND "A55"."LIST_LINE_ID"=(-1) AND
"A55"."COMPARISON_OPERATOR_CODE"='=' AND "A55"."ACTIVE_FLAG"='Y')
filter("A55"."ACTIVE_FLAG"='Y' AND "A55"."COMPARISON_OPERATOR_CODE"='=')
225 - access("A10"."QUALIFIER_ATTR_VALUE"="A8"."SALES_CHANNEL_CODE")
230 - access("A9"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID")
231 - filter(NVL("A9"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A9"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
232 - access("A9"."QUALIFIER_CONTEXT"='ORDER' AND "A9"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A9"."COMPARISON_OPERATOR_CODE"='=' AND "A9"."ACTIVE_FLAG"='Y' AND "A9"."LIST_LINE_ID"=(-1))
filter("A9"."LIST_LINE_ID"=(-1) AND "A9"."ACTIVE_FLAG"='Y' AND "A9"."COMPARISON_OPERATOR_CODE"='=')
233 - filter("A64"."LIST_TYPE_CODE"='DLT' AND "A64"."ACTIVE_FLAG"='Y')
234 - filter("A11"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A11"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A11"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A11"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
235 - access("A11"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A11"."LIST_LINE_ID"=(-1) AND
"A11"."COMPARISON_OPERATOR_CODE"='=' AND "A11"."ACTIVE_FLAG"='Y')
filter("A11"."ACTIVE_FLAG"='Y' AND "A11"."COMPARISON_OPERATOR_CODE"='=')
237 - access("A64"."LIST_HEADER_ID"="A63"."LIST_HEADER_ID" AND "A63"."LANGUAGE"=USERENV('LANG'))
238 - access("A10"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A10"."LIST_LINE_ID"=(-1) AND
"A10"."COMPARISON_OPERATOR_CODE"='=' AND "A10"."ACTIVE_FLAG"='Y')
filter("A10"."ACTIVE_FLAG"='Y' AND "A10"."COMPARISON_OPERATOR_CODE"='=')
239 - filter("A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13' AND "A10"."QUALIFIER_CONTEXT"='CUSTOMER'
AND NVL("A10"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A10"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
240 - filter("A8"."SALES_CHANNEL_CODE" IS NOT NULL)
241 - access("A10"."QUALIFIER_ATTR_VALUE"=TO_CHAR("A8"."CUST_ACCOUNT_ID"))
filter(LNNVL("A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE13') OR
LNNVL("A10"."QUALIFIER_ATTR_VALUE"="A8"."SALES_CHANNEL_CODE") OR LNNVL("A8"."SALES_CHANNEL_CODE" IS NOT NULL))
246 - access("A9"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID")
247 - filter(NVL("A9"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A9"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
248 - access("A9"."QUALIFIER_CONTEXT"='ORDER' AND "A9"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A9"."COMPARISON_OPERATOR_CODE"='=' AND "A9"."ACTIVE_FLAG"='Y' AND "A9"."LIST_LINE_ID"=(-1))
filter("A9"."LIST_LINE_ID"=(-1) AND "A9"."ACTIVE_FLAG"='Y' AND "A9"."COMPARISON_OPERATOR_CODE"='=')
249 - filter("A64"."LIST_TYPE_CODE"='DLT' AND "A64"."ACTIVE_FLAG"='Y')
250 - filter("A11"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A11"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A11"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A11"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
251 - access("A11"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A11"."LIST_LINE_ID"=(-1) AND
"A11"."COMPARISON_OPERATOR_CODE"='=' AND "A11"."ACTIVE_FLAG"='Y')
filter("A11"."ACTIVE_FLAG"='Y' AND "A11"."COMPARISON_OPERATOR_CODE"='=')
253 - access("A64"."LIST_HEADER_ID"="A63"."LIST_HEADER_ID" AND "A63"."LANGUAGE"=USERENV('LANG'))
254 - access("A10"."LIST_HEADER_ID"="A64"."LIST_HEADER_ID" AND "A10"."LIST_LINE_ID"=(-1) AND
"A10"."COMPARISON_OPERATOR_CODE"='=' AND "A10"."ACTIVE_FLAG"='Y')
filter("A10"."ACTIVE_FLAG"='Y' AND "A10"."COMPARISON_OPERATOR_CODE"='=')
255 - filter("A10"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE2' AND "A10"."QUALIFIER_CONTEXT"='CUSTOMER' AND
NVL("A10"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A10"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
261 - access("A4"."LIST_HEADER_ID"="A62"."LIST_HEADER_ID")
262 - filter(NVL("A4"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A4"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
263 - access("A4"."QUALIFIER_CONTEXT"='ORDER' AND "A4"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE9' AND
"A4"."COMPARISON_OPERATOR_CODE"='=' AND "A4"."ACTIVE_FLAG"='Y' AND "A4"."LIST_LINE_ID"=(-1))
filter("A4"."LIST_LINE_ID"=(-1) AND "A4"."ACTIVE_FLAG"='Y' AND "A4"."COMPARISON_OPERATOR_CODE"='=')
264 - filter("A62"."LIST_TYPE_CODE"='DLT' AND "A62"."ACTIVE_FLAG"='Y')
265 - filter("A6"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A6"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A6"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A6"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
266 - access("A6"."LIST_HEADER_ID"="A62"."LIST_HEADER_ID" AND "A6"."LIST_LINE_ID"=(-1) AND
"A6"."COMPARISON_OPERATOR_CODE"='=' AND "A6"."ACTIVE_FLAG"='Y')
filter("A6"."ACTIVE_FLAG"='Y' AND "A6"."COMPARISON_OPERATOR_CODE"='=')
268 - access("A62"."LIST_HEADER_ID"="A61"."LIST_HEADER_ID" AND "A61"."LANGUAGE"=USERENV('LANG'))
269 - access("A5"."LIST_HEADER_ID"="A62"."LIST_HEADER_ID" AND "A5"."LIST_LINE_ID"=(-1) AND
"A5"."COMPARISON_OPERATOR_CODE"='=' AND "A5"."ACTIVE_FLAG"='Y')
filter("A5"."ACTIVE_FLAG"='Y' AND "A5"."COMPARISON_OPERATOR_CODE"='=')
270 - filter("A5"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A5"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11' OR
"A5"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A5"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A5"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
276 - filter(NVL("A2"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A2"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
277 - access("A2"."QUALIFIER_CONTEXT"='CUSTOMER' AND "A2"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE35' AND
"A2"."COMPARISON_OPERATOR_CODE"='=' AND "A2"."ACTIVE_FLAG"='Y' AND "A2"."LIST_LINE_ID"=(-1))
filter("A2"."LIST_LINE_ID"=(-1) AND "A2"."ACTIVE_FLAG"='Y' AND "A2"."COMPARISON_OPERATOR_CODE"='=')
278 - access("A2"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A60"."LIST_TYPE_CODE"='DLT' AND
"A60"."ACTIVE_FLAG"='Y')
filter("A60"."ACTIVE_FLAG"='Y')
280 - access("A60"."LIST_HEADER_ID"="A59"."LIST_HEADER_ID" AND "A59"."LANGUAGE"=USERENV('LANG'))
281 - filter("A58"."QUALIFIER_CONTEXT"='ORDER' AND NVL("A58"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!)
AND NVL("A58"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
282 - access("A58"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A58"."LIST_LINE_ID"=(-1) AND
"A58"."COMPARISON_OPERATOR_CODE"='=' AND "A58"."ACTIVE_FLAG"='Y')
filter("A58"."ACTIVE_FLAG"='Y' AND "A58"."COMPARISON_OPERATOR_CODE"='=')
283 - filter("A57"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE4' AND "A57"."QUALIFIER_CONTEXT"='MODLIST' AND
NVL("A57"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A57"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
284 - access("A57"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A57"."LIST_LINE_ID"=(-1) AND
"A57"."COMPARISON_OPERATOR_CODE"='=' AND "A57"."ACTIVE_FLAG"='Y')
filter("A57"."ACTIVE_FLAG"='Y' AND "A57"."COMPARISON_OPERATOR_CODE"='=')
285 - filter("A56"."QUALIFIER_CONTEXT"='CUSTOMER' AND ("A56"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE11'
OR "A56"."QUALIFIER_ATTRIBUTE"='QUALIFIER_ATTRIBUTE14') AND
NVL("A56"."END_DATE_ACTIVE",SYSDATE@!+1)>=TRUNC(SYSDATE@!) AND
NVL("A56"."START_DATE_ACTIVE",SYSDATE@!-1)<=TRUNC(SYSDATE@!))
286 - access("A56"."LIST_HEADER_ID"="A60"."LIST_HEADER_ID" AND "A56"."LIST_LINE_ID"=(-1) AND
"A56"."COMPARISON_OPERATOR_CODE"='=' AND "A56"."ACTIVE_FLAG"='Y')
filter("A56"."ACTIVE_FLAG"='Y' AND "A56"."COMPARISON_OPERATOR_CODE"='=')
-------------------------------------------------------------------------------