Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / V$SORT_Segment)
Date: Wed, 22 Jan 2020 11:29:23 -0500
Message-ID: <CAP79kiTLYu6s381VJ7rzz6gXvJRyCsPD0DwPt0z8t1QndcxQsw_at_mail.gmail.com>
Let me address all the questions (so far) here:
- _at_jonathan Version: Oracle 12.1.0.2 x86-64 with 12.1.0.2.180717 bundle patch TEMP is bigfile tablespace Yes 4096 DB_FILES parameter with 3103 datafiles in use plus 1 tempfile (DB Size ~ 120TB)
- Plans are identical between non-standby and standby databases. I've actually tried 3 separate plans via SQL Profiles and tested after the profile was replicated to the standby databases and verified the PHV in the trace file changes. Also purged the SQL_ID (and even flushed the shared pool on the standbys) between executions.
- _at_cary a.) "Why are we seeing evidence of 128-block reads happening upon adjacent blocks? --- That's why I asked if anyone had seen anything like this LOL b.) "If each of these reads really were a 1-block read, it would not be a db file scattered read call" -- I agree completely - again, thats part of why I'm puzzled. Also note the run times for the SQL in the standby is many times greater in the standby (using the same plans) than in the primarys/clones.
NOTE: I've attached the latest (non-forced plan) information from the standby db below that is still showing "the single-block read that think it's a multi-block read" oddity below.
I don't see any Windowing functions involved but this query does do a SELECT .... FROM ( WITH CTE as .... ) . Still doesn't explain this behavior i think.
Also it does several DIRECT PATH WRITES prior to the READS and all the DIRECT PATH WRITES are multi-block.
Plan hash value: 453582601
| Id | Operation | Name
| Rows | Bytes |TempSpc| Cost (%CPU)| Time |
Pstart| Pstop |
| 0 | SELECT STATEMENT |
| | | | 41G(100)| |
| |
| 1 | SORT AGGREGATE |
| 1 | 28 | | | |
| |
| 2 | TABLE ACCESS BY INDEX ROWID | LOOKUP
| 1 | 19 | | 3 (34)| 00:00:01 |
| |
| 3 | NESTED LOOPS |
| 1 | 28 | | 5 (20)| 00:00:01 |
| |
| 4 | TABLE ACCESS BY INDEX ROWID |
IDENTIFIER_TYPE | 1 | 9 | | 3 (34)|
00:00:01 | | |
|* 5 | INDEX RANGE SCAN |
IDENTIFIER_TYPE_IDX01 | 1 | | | 2 (50)|
00:00:01 | | |
|* 6 | INDEX RANGE SCAN |
LOOKUP_IDX01 | 1 | | | 2 (50)|
00:00:01 | | |
| 7 | SORT AGGREGATE |
| 1 | 28 | | | |
| |
| 8 | TABLE ACCESS BY INDEX ROWID | LOOKUP
| 1 | 19 | | 3 (34)| 00:00:01 |
| |
| 9 | NESTED LOOPS |
| 1 | 28 | | 5 (20)| 00:00:01 |
| |
| 10 | TABLE ACCESS BY INDEX ROWID |
IDENTIFIER_TYPE | 1 | 9 | | 3 (34)|
00:00:01 | | |
|* 11 | INDEX RANGE SCAN |
IDENTIFIER_TYPE_IDX01 | 1 | | | 2 (50)|
00:00:01 | | |
|* 12 | INDEX RANGE SCAN |
LOOKUP_IDX01 | 1 | | | 2 (50)|
00:00:01 | | |
| 13 | SORT GROUP BY |
| 1 | 7692 | | 41G (36)| 75:19:11 |
| |
| 14 | VIEW |
| 7374G| 50P| | 34G (23)| 62:37:29 |
| |
| 15 | TEMP TABLE TRANSFORMATION |
| | | | | |
| |
| 16 | LOAD AS SELECT |
| | | | | |
| |
|* 17 | HASH JOIN OUTER |
| 223K| 8739K| 6992K| 1389 (4)| 00:00:01 |
| |
|* 18 | HASH JOIN OUTER |
| 223K| 4369K| | 522 (7)| 00:00:01 |
| |
| 19 | INDEX FAST FULL SCAN |
SYS_C0011219 | 10494 | 52470 | | 11 (10)|
00:00:01 | | |
| 20 | TABLE ACCESS FULL |
SUBCONTRACT | 223K| 3277K| | 499 (4)|
00:00:01 | | |
| 21 | TABLE ACCESS FULL |
COVERED_ENTITY | 12292 | 240K| | 150 (2)|
00:00:01 | | |
| 22 | SORT GROUP BY |
| 7374G| 29P| 107P| 34G (23)| 62:37:29 |
| |
| 23 | NESTED LOOPS OUTER |
| 7374G| 29P| | 16G (4)| 29:18:29 |
| |
|* 24 | HASH JOIN OUTER |
| 32M| 138G| 8127M| 168M (3)| 00:18:29 |
| |
|* 25 | FILTER |
| | | | | |
| |
|* 26 | HASH JOIN OUTER |
| 16M| 7939M| 7845M| 167M (3)| 00:18:24 |
| |
| 27 | VIEW |
| 16M| 7657M| | 166M (3)| 00:18:19 |
| |
|* 28 | HASH JOIN OUTER |
| 16M| 41G| 41G| 166M (3)| 00:18:19 |
| |
|* 29 | FILTER |
| | | | | |
| |
| 30 | NESTED LOOPS OUTER |
| 16M| 41G| | 162M (3)| 00:17:52 |
| |
| 31 | NESTED LOOPS OUTER |
| 747K| 1798M| | 422K (1)| 00:00:03 |
| |
|* 32 | FILTER |
| | | | | |
| |
| 33 | NESTED LOOPS OUTER |
| 105K| 250M| | 488 (1)| 00:00:01 |
| |
| 34 | NESTED LOOPS OUTER |
| 1 | 2198 | | 480 (1)| 00:00:01 |
| |
| 35 | NESTED LOOPS OUTER |
| 1 | 2151 | | 477 (1)| 00:00:01 |
| |
|* 36 | FILTER |
| | | | | |
| |
| 37 | NESTED LOOPS OUTER |
| 1 | 2122 | | 474 (1)| 00:00:01 |
| |
| 38 | NESTED LOOPS OUTER |
| 1 | 2098 | | 472 (1)| 00:00:01 |
| |
| 39 | VIEW |
| 1 | 2086 | | 470 (1)| 00:00:01 |
| |
| 40 | NESTED LOOPS OUTER |
| 1 | 247 | | 470 (1)| 00:00:01 |
| |
| 41 | NESTED LOOPS OUTER |
| 1 | 224 | | 467 (1)| 00:00:01 |
| |
| 42 | NESTED LOOPS OUTER |
| 1 | 204 | | 465 (1)| 00:00:01 |
| |
| 43 | NESTED LOOPS OUTER |
| 1 | 192 | | 464 (1)| 00:00:01 |
| |
| 44 | NESTED LOOPS OUTER |
| 1 | 181 | | 462 (1)| 00:00:01 |
| |
| 45 | NESTED LOOPS |
| 1 | 155 | | 461 (1)| 00:00:01 |
| |
|* 46 | TABLE ACCESS BY INDEX ROWID| CONTRACT
| 1 | 76 | | 3 (34)| 00:00:01 |
| |
|* 47 | INDEX UNIQUE SCAN |
SYS_C0011219 | 1 | | | 2 (50)|
00:00:01 | | |
|* 48 | TABLE ACCESS BY INDEX ROWID|
REPLENISHMENT | 1 | 79 | | 459 (1)|
00:00:01 | | |
|* 49 | INDEX RANGE SCAN |
REPLENISHMENT_CONTRACT_ID_KEY | 5037 | | | 18 (6)|
00:00:01 | | |
| 50 | TABLE ACCESS BY INDEX ROWID |
MANUAL_INVENTORY_ADJUSTMENT | 1 | 26 | | 2 (50)|
00:00:01 | | |
|* 51 | INDEX UNIQUE SCAN |
SYS_C008920523 | 1 | | | 1 (100)|
00:00:01 | | |
| 52 | TABLE ACCESS BY INDEX ROWID |
MANUAL_INV_ADJUSTMENT_LOG | 1 | 11 | | 3 (34)|
00:00:01 | | |
|* 53 | INDEX UNIQUE SCAN |
MAN_INV_ADJ_REPL_ID_IDX | 1 | | | 2 (50)|
00:00:01 | | |
| 54 | TABLE ACCESS BY INDEX ROWID | USERS
| 1 | 12 | | 2 (50)| 00:00:01 |
| |
|* 55 | INDEX UNIQUE SCAN |
SYS_C005482 | 1 | | | 1 (100)|
00:00:01 | | |
| 56 | TABLE ACCESS BY INDEX ROWID | DRUG
| 1 | 20 | | 3 (34)| 00:00:01 |
| |
|* 57 | INDEX UNIQUE SCAN | DRUG_PKEY
| 1 | | | 2 (50)| 00:00:01 |
| |
| 58 | TABLE ACCESS BY INDEX ROWID | INFO
| 1 | 23 | | 4 (25)| 00:00:01 |
| |
|* 59 | INDEX UNIQUE SCAN |
ROLODEX_INFO_PK | 1 | | | 3 (34)|
00:00:01 | | |
| 60 | TABLE ACCESS BY INDEX ROWID |
PURCHASE_ORDER | 1 | 12 | | 3 (34)|
00:00:01 | | |
|* 61 | INDEX UNIQUE SCAN |
SYS_C005823 | 1 | | | 2 (50)|
00:00:01 | | |
| 62 | TABLE ACCESS BY INDEX ROWID |
PURCHASE_ORDER | 1 | 24 | | 3 (34)|
00:00:01 | | |
|* 63 | INDEX UNIQUE SCAN |
PURCHASE_ORDER_PKEY | 1 | | | 2 (50)|
00:00:01 | | |
| 64 | PARTITION LIST ITERATOR |
| 1 | 29 | | 4 (25)| 00:00:01 | KEY
| KEY |
| 65 | TABLE ACCESS BY LOCAL INDEX ROWID |
PRICE_LIST2 | 1 | 29 | | 4 (25)|
00:00:01 | KEY | KEY |
|* 66 | INDEX RANGE SCAN |
PRICE_LIST2_ACCT_NDC_IDX | 1 | | | 3 (34)|
00:00:01 | KEY | KEY |
| 67 | TABLE ACCESS BY INDEX ROWID |
EXTERNAL_ORDER | 1 | 47 | | 4 (25)|
00:00:01 | | |
|* 68 | INDEX RANGE SCAN |
EXTERNAL_ORDER_REP_ID_IDX | 1 | | | 3 (34)|
00:00:01 | | |
| 69 | VIEW |
| 104K| 29M| | 9 (12)| 00:00:01 |
| |
| 70 | CONCATENATION |
| | | | | |
| |
|* 71 | FILTER |
| | | | | |
| |
|* 72 | TABLE ACCESS BY INDEX ROWID | INVOICE
| 104K| 5008K| | 4 (25)| 00:00:01 |
| |
|* 73 | INDEX RANGE SCAN |
INVOICE_PURCHASE_ORDER_ID_IDX | 83729 | | | 3 (34)|
00:00:01 | | |
|* 74 | INDEX UNIQUE SCAN |
INVOICES_PKEY | 1 | 6 | | 3 (34)|
00:00:01 | | |
|* 75 | FILTER |
| | | | | |
| |
| 76 | TABLE ACCESS BY INDEX ROWID | INVOICE
| 1 | 49 | | 4 (25)| 00:00:01 |
| |
|* 77 | INDEX UNIQUE SCAN |
INVOICES_PKEY | 1 | | | 3 (34)|
00:00:01 | | |
|* 78 | INDEX UNIQUE SCAN |
INVOICES_PKEY | 1 | 6 | | 3 (34)|
00:00:01 | | |
| 79 | TABLE ACCESS BY INDEX ROWID |
INVOICE_LINE | 7 | 175 | | 5 (20)|
00:00:01 | | |
|* 80 | INDEX RANGE SCAN |
INV_LINE_INVOICE_ID_FK | 7 | | | 4 (25)|
00:00:01 | | |
| 81 | VIEW |
| 22 | 3410 | | 217 (3)| 00:00:01 |
| |
|* 82 | TABLE ACCESS FULL | ACCOUNT
| 22 | 418 | | 217 (3)| 00:00:01 |
| |
| 83 | TABLE ACCESS FULL |
WHOLESALERS | 312 | 8112 | | 15 (7)|
00:00:01 | | |
| 84 | INDEX FAST FULL SCAN |
NDC_ITEM_IDX | 3448K| 59M| | 9268 (4)|
00:00:01 | | |
| 85 | VIEW | VW_INFO
| 28512 | 109M| | 705 (3)| 00:00:01 |
| |
| 86 | SORT GROUP BY |
| 28512 | 1837K| 4280K| 705 (3)| 00:00:01 |
| |
|* 87 | HASH JOIN OUTER |
| 28512 | 1837K| | 145 (5)| 00:00:01 |
| |
| 88 | TABLE ACCESS FULL | INFO
| 15187 | 875K| | 99 (3)| 00:00:01 |
| |
| 89 | INDEX FAST FULL SCAN |
PARM_ID_SITE_NUMBER_UNQ_IDX | 28512 | 194K| | 44 (7)|
00:00:01 | | |
| 90 | VIEW |
| 223K| 5899K| | 481 (4)| 00:00:01 |
| |
|* 91 | FILTER |
| | | | | |
| |
|* 92 | VIEW |
| 223K| 14M| | 481 (4)| 00:00:01 |
| |
| 93 | TABLE ACCESS FULL |
SYS_TEMP_0FDA10BC5_37DC306C | 223K| 6554K| | 481 (4)|
00:00:01 | | |
|* 94 | VIEW |
| 223K| 5680K| | 481 (4)| 00:00:01 |
| |
| 95 | TABLE ACCESS FULL |
SYS_TEMP_0FDA10BC5_37DC306C | 223K| 6554K| | 481 (4)|
00:00:01 | | |
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
1 - SEL$21E57174 2 - SEL$21E57174 / PL_at_SEL$38 4 - SEL$21E57174 / IDTYPE_at_SEL$38 5 - SEL$21E57174 / IDTYPE_at_SEL$38 6 - SEL$21E57174 / PL_at_SEL$38 7 - SEL$91EBC5DD 8 - SEL$91EBC5DD / PL_at_SEL$39 10 - SEL$91EBC5DD / IDTYPE_at_SEL$39 11 - SEL$91EBC5DD / IDTYPE_at_SEL$39 12 - SEL$91EBC5DD / PL_at_SEL$39 13 - SEL$1 14 - SEL$057B6AC8 / from$_subquery$_001_at_SEL$1 15 - SEL$057B6AC8 16 - SEL$5B5BD84E 19 - SEL$5B5BD84E / C_at_SEL$3 20 - SEL$5B5BD84E / SC_at_SEL$2 21 - SEL$5B5BD84E / CE_at_SEL$4 27 - SEL$5A696D79 / from$_subquery$_036_at_SEL$36 28 - SEL$5A696D79 39 - SEL$D57D4812 / from$_subquery$_019_at_SEL$19 40 - SEL$D57D4812 46 - SEL$D57D4812 / C_at_SEL$16 47 - SEL$D57D4812 / C_at_SEL$16 48 - SEL$D57D4812 / R_at_SEL$7 49 - SEL$D57D4812 / R_at_SEL$7 50 - SEL$D57D4812 / MIA_at_SEL$8 51 - SEL$D57D4812 / MIA_at_SEL$8 52 - SEL$D57D4812 / MIAL_at_SEL$10 53 - SEL$D57D4812 / MIAL_at_SEL$10 54 - SEL$D57D4812 / U_at_SEL$12 55 - SEL$D57D4812 / U_at_SEL$12 56 - SEL$D57D4812 / D_at_SEL$6 57 - SEL$D57D4812 / D_at_SEL$6 58 - SEL$D57D4812 / ROLO_at_SEL$14 59 - SEL$D57D4812 / ROLO_at_SEL$14 60 - SEL$5A696D79 / PO_at_SEL$20 61 - SEL$5A696D79 / PO_at_SEL$20 62 - SEL$5A696D79 / WPO_at_SEL$31 63 - SEL$5A696D79 / WPO_at_SEL$31 65 - SEL$5A696D79 / PRICE_LIST2_at_SEL$18 66 - SEL$5A696D79 / PRICE_LIST2_at_SEL$18 67 - SEL$5A696D79 / OEO_at_SEL$25 68 - SEL$5A696D79 / OEO_at_SEL$25 69 - SEL$22 / from$_subquery$_064_at_SEL$24 70 - SEL$22 72 - SEL$22_1 / INV_at_SEL$22 73 - SEL$22_1 / INV_at_SEL$22 74 - SEL$23 / INV2_at_SEL$23 76 - SEL$22_2 / INV_at_SEL$22_2 77 - SEL$22_2 / INV_at_SEL$22_2 78 - SEL$23 / INV2_at_SEL$23 79 - SEL$5A696D79 / WIL_at_SEL$33 80 - SEL$5A696D79 / WIL_at_SEL$33 81 - SEL$27 / from$_subquery$_066_at_SEL$28 82 - SEL$27 / ACC_at_SEL$27 83 - SEL$5A696D79 / WLS_at_SEL$29 84 - SEL$057B6AC8 / WIT_at_SEL$35 85 - SEL$C400B828 / PVI_at_SEL$37 86 - SEL$C400B828 88 - SEL$C400B828 / I_at_SEL$41 89 - SEL$C400B828 / L_at_SEL$40 90 - SEL$46 / from$_subquery$_072_at_SEL$48 91 - SEL$46 92 - SEL$985ADCC9 / CCE_at_SEL$46 93 - SEL$985ADCC9 / T1_at_SEL$985ADCC9 94 - SEL$985ADCC8 / INNER_at_SEL$47 95 - SEL$985ADCC8 / T1_at_SEL$985ADCC8
Outline Data
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('9.2.0.8')
DB_VERSION('12.1.0.2')
OPT_PARAM('_optim_peek_user_binds' 'false')
OPT_PARAM('optimizer_dynamic_sampling' 2)
OPT_PARAM('_optimizer_extended_stats_usage_control' 224)
OPT_PARAM('_fix_control' '20355502:8')
OUTLINE_LEAF(_at_"SEL$5B5BD84E")
MERGE(_at_"SEL$829C93BE")
OUTLINE_LEAF(_at_"SEL$D57D4812")
MERGE(_at_"SEL$D1237EDC")
OUTLINE_LEAF(_at_"SEL$23")
OUTLINE_LEAF(_at_"SEL$22")
OUTLINE_LEAF(_at_"SEL$27")
OUTLINE_LEAF(_at_"SEL$5A696D79")
MERGE(_at_"SEL$18")
OUTLINE_LEAF(_at_"SEL$21E57174")
MERGE(_at_"SEL$38")
OUTLINE_LEAF(_at_"SEL$91EBC5DD")
MERGE(_at_"SEL$39")
OUTLINE_LEAF(_at_"SEL$C400B828")
MERGE(_at_"SEL$D0D16D4C")
OUTLINE_LEAF(_at_"SEL$985ADCC8")
OUTLINE_LEAF(_at_"SEL$47")
OUTLINE_LEAF(_at_"SEL$985ADCC9")
OUTLINE_LEAF(_at_"SEL$46")
OUTLINE_LEAF(_at_"SEL$057B6AC8")
MERGE(_at_"SEL$19F000E3")
OUTLINE_LEAF(_at_"SEL$1")
OUTLINE_LEAF(_at_"SEL$22_1")
USE_CONCAT(_at_"SEL$22" 8 OR_PREDICATES(1) PREDICATE_REORDERS((5 4) (6
5) (4 6)))
OUTLINE_LEAF(_at_"SEL$22_2")
OUTLINE(_at_"SEL$49")
OUTLINE(_at_"SEL$829C93BE")
MERGE(_at_"SEL$4")
MERGE(_at_"SEL$64EAE176")
OUTLINE(_at_"SEL$16")
OUTLINE(_at_"SEL$D1237EDC")
MERGE(_at_"SEL$14")
MERGE(_at_"SEL$BA9AC2A2")
OUTLINE(_at_"SEL$86507448")
MERGE(_at_"SEL$33")
MERGE(_at_"SEL$73651AEE")
OUTLINE(_at_"SEL$18")
OUTLINE(_at_"SEL$43")
OUTLINE(_at_"SEL$38")
OUTLINE(_at_"SEL$44")
OUTLINE(_at_"SEL$39")
OUTLINE(_at_"SEL$42")
OUTLINE(_at_"SEL$D0D16D4C")
MERGE(_at_"SEL$40")
OUTLINE(_at_"SEL$5B5BD84E")
MERGE(_at_"SEL$829C93BE")
OUTLINE(_at_"SEL$50")
OUTLINE(_at_"SEL$19F000E3")
MERGE(_at_"SEL$6B1DAA04")
OUTLINE(_at_"SEL$22")
OUTLINE(_at_"SEL$5")
OUTLINE(_at_"SEL$4")
OUTLINE(_at_"SEL$64EAE176")
MERGE(_at_"SEL$2")
OUTLINE(_at_"SEL$15")
OUTLINE(_at_"SEL$14")
OUTLINE(_at_"SEL$BA9AC2A2")
MERGE(_at_"SEL$12")
MERGE(_at_"SEL$D6CC616B")
OUTLINE(_at_"SEL$34")
OUTLINE(_at_"SEL$33")
OUTLINE(_at_"SEL$73651AEE")
MERGE(_at_"SEL$31")
MERGE(_at_"SEL$A3806644")
OUTLINE(_at_"SEL$41")
OUTLINE(_at_"SEL$40")
OUTLINE(_at_"SEL$48")
OUTLINE(_at_"SEL$6B1DAA04")
MERGE(_at_"SEL$37")
MERGE(_at_"SEL$8AC23089")
OUTLINE(_at_"SEL$3")
OUTLINE(_at_"SEL$2")
OUTLINE(_at_"SEL$13")
OUTLINE(_at_"SEL$12")
OUTLINE(_at_"SEL$D6CC616B")
MERGE(_at_"SEL$10")
MERGE(_at_"SEL$303152C2")
OUTLINE(_at_"SEL$32")
OUTLINE(_at_"SEL$31")
OUTLINE(_at_"SEL$A3806644")
MERGE(_at_"SEL$29")
MERGE(_at_"SEL$300AA7E3")
OUTLINE(_at_"SEL$45")
OUTLINE(_at_"SEL$37")
OUTLINE(_at_"SEL$8AC23089")
MERGE(_at_"SEL$35")
OUTLINE(_at_"SEL$11")
OUTLINE(_at_"SEL$10")
OUTLINE(_at_"SEL$303152C2")
MERGE(_at_"SEL$6DE49B00")
MERGE(_at_"SEL$8")
OUTLINE(_at_"SEL$30")
OUTLINE(_at_"SEL$29")
OUTLINE(_at_"SEL$300AA7E3")
MERGE(_at_"SEL$E85F5604")
OUTLINE(_at_"SEL$36")
OUTLINE(_at_"SEL$35")
OUTLINE(_at_"SEL$9")
OUTLINE(_at_"SEL$6DE49B00")
MERGE(_at_"SEL$6")
OUTLINE(_at_"SEL$8")
OUTLINE(_at_"SEL$28")
OUTLINE(_at_"SEL$E85F5604")
MERGE(_at_"SEL$1C5C48EF")
MERGE(_at_"SEL$25")
OUTLINE(_at_"SEL$7")
OUTLINE(_at_"SEL$6")
OUTLINE(_at_"SEL$26")
OUTLINE(_at_"SEL$1C5C48EF")
MERGE(_at_"SEL$88651B05")
OUTLINE(_at_"SEL$25")
OUTLINE(_at_"SEL$24")
OUTLINE(_at_"SEL$88651B05")
MERGE(_at_"SEL$20")
MERGE(_at_"SEL$32561052")
OUTLINE(_at_"SEL$21")
OUTLINE(_at_"SEL$20")
OUTLINE(_at_"SEL$32561052")
MERGE(_at_"SEL$17")
OUTLINE(_at_"SEL$19")
OUTLINE(_at_"SEL$17")
NO_ACCESS(_at_"SEL$1" "from$_subquery$_001"_at_"SEL$1")
NO_ACCESS(_at_"SEL$057B6AC8" "from$_subquery$_036"_at_"SEL$36")
INDEX_FFS(_at_"SEL$057B6AC8" "WIT"_at_"SEL$35" ("ITEM"."NDC"
"ITEM"."ITEM_ID" "ITEM"."ITEM_NUMBER"))
NO_ACCESS(_at_"SEL$057B6AC8" "PVI"_at_"SEL$37")
NO_ACCESS(_at_"SEL$057B6AC8" "from$_subquery$_072"_at_"SEL$48")
LEADING(_at_"SEL$057B6AC8" "from$_subquery$_036"_at_"SEL$36" "WIT"@"SEL$35"
"PVI"_at_"SEL$37" "from$_subquery$_072"_at_"SEL$48")
USE_HASH(_at_"SEL$057B6AC8" "WIT"_at_"SEL$35")
USE_HASH(_at_"SEL$057B6AC8" "PVI"_at_"SEL$37")
USE_NL(_at_"SEL$057B6AC8" "from$_subquery$_072"_at_"SEL$48")
NO_ACCESS(_at_"SEL$5A696D79" "from$_subquery$_019"_at_"SEL$19")
INDEX_RS_ASC(_at_"SEL$5A696D79" "PO"_at_"SEL$20"
("PURCHASE_ORDER"."PURCHASE_ORDER_ID"))
INDEX_RS_ASC(_at_"SEL$5A696D79" "WPO"_at_"SEL$31"
("PURCHASE_ORDER"."PURCHASE_ORDER_ID"))
INDEX_RS_ASC(_at_"SEL$5A696D79" "PRICE_LIST2"_at_"SEL$18"
("PRICE_LIST2"."ACCOUNT_ID" "PRICE_LIST2"."NDC"))
INDEX_RS_ASC(_at_"SEL$5A696D79" "OEO"_at_"SEL$25"
("EXTERNAL_ORDER"."REPLENISHMENT_ID"))
NO_ACCESS(_at_"SEL$5A696D79" "from$_subquery$_064"_at_"SEL$24")
INDEX_RS_ASC(_at_"SEL$5A696D79" "WIL"_at_"SEL$33"
("INVOICE_LINE"."INVOICE_ID"))
NO_ACCESS(_at_"SEL$5A696D79" "from$_subquery$_066"_at_"SEL$28")
FULL(_at_"SEL$5A696D79" "WLS"_at_"SEL$29")
LEADING(_at_"SEL$5A696D79" "from$_subquery$_019"_at_"SEL$19" "PO"@"SEL$20"
"WPO"_at_"SEL$31" "PRICE_LIST2"_at_"SEL$18" "OEO"@"SEL$25"
"from$_subquery$_064"_at_"SEL$24" "WIL"_at_"SEL$33"
"from$_subquery$_066"_at_"SEL$28" "WLS"_at_"SEL$29")
USE_NL(_at_"SEL$5A696D79" "PO"_at_"SEL$20")
USE_NL(_at_"SEL$5A696D79" "WPO"_at_"SEL$31")
USE_NL(_at_"SEL$5A696D79" "PRICE_LIST2"_at_"SEL$18")
USE_NL(_at_"SEL$5A696D79" "OEO"_at_"SEL$25")
USE_NL(_at_"SEL$5A696D79" "from$_subquery$_064"_at_"SEL$24")
USE_NL(_at_"SEL$5A696D79" "WIL"_at_"SEL$33")
USE_NL(_at_"SEL$5A696D79" "from$_subquery$_066"_at_"SEL$28")
USE_HASH(_at_"SEL$5A696D79" "WLS"_at_"SEL$29")
FULL(_at_"SEL$C400B828" "I"_at_"SEL$41")
INDEX_FFS(_at_"SEL$C400B828" "L"_at_"SEL$40" ("LOOKUP"."PHARMACY_ID"
"LOOKUP"."SITE_NUMBER"))
LEADING(_at_"SEL$C400B828" "I"_at_"SEL$41" "L"@"SEL$40")
USE_HASH(_at_"SEL$C400B828" "L"_at_"SEL$40")
NO_ACCESS(_at_"SEL$46" "CCE"_at_"SEL$46")
PQ_FILTER(_at_"SEL$46" SERIAL)
FULL(_at_"SEL$985ADCC9" "T1"_at_"SEL$985ADCC9")
NO_ACCESS(_at_"SEL$47" "INNER"_at_"SEL$47")
FULL(_at_"SEL$985ADCC8" "T1"_at_"SEL$985ADCC8")
INDEX_RS_ASC(_at_"SEL$91EBC5DD" "IDTYPE"_at_"SEL$39"
"IDENTIFIER_TYPE_IDX01")
INDEX(_at_"SEL$91EBC5DD" "PL"_at_"SEL$39" ("LOOKUP"."PHARMACY_ID"
"LOOKUP"."IDENTIFIER_TYPE_ID"))
LEADING(_at_"SEL$91EBC5DD" "IDTYPE"_at_"SEL$39" "PL"@"SEL$39")
USE_NL(_at_"SEL$91EBC5DD" "PL"_at_"SEL$39")
NLJ_PREFETCH(_at_"SEL$91EBC5DD" "PL"_at_"SEL$39")
INDEX_RS_ASC(_at_"SEL$21E57174" "IDTYPE"_at_"SEL$38"
"IDENTIFIER_TYPE_IDX01")
INDEX(_at_"SEL$21E57174" "PL"_at_"SEL$38" ("LOOKUP"."PHARMACY_ID"
"LOOKUP"."IDENTIFIER_TYPE_ID"))
LEADING(_at_"SEL$21E57174" "IDTYPE"_at_"SEL$38" "PL"@"SEL$38")
USE_NL(_at_"SEL$21E57174" "PL"_at_"SEL$38")
NLJ_PREFETCH(_at_"SEL$21E57174" "PL"_at_"SEL$38")
INDEX_RS_ASC(_at_"SEL$D57D4812" "C"_at_"SEL$16" ("CONTRACT"."CONTRACT_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "R"_at_"SEL$7"
("REPLENISHMENT"."CONTRACT_ID" "REPLENISHMENT"."VOIDED_ON"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "MIA"_at_"SEL$8"
("MANUAL_INVENTORY_ADJUSTMENT"."REPLENISHMENT_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "MIAL"_at_"SEL$10"
("MANUAL_INV_ADJUSTMENT_LOG"."REPLENISHMENT_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "U"_at_"SEL$12" ("USERS"."USER_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "D"_at_"SEL$6" ("DRUG"."NDC"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "ROLO"_at_"SEL$14" ("INFO"."ROLODEX_ID"))
LEADING(_at_"SEL$D57D4812" "C"_at_"SEL$16" "R"@"SEL$7" "MIA"@"SEL$8"
"MIAL"_at_"SEL$10" "U"_at_"SEL$12" "D"@"SEL$6" "ROLO"@"SEL$14")
USE_NL(_at_"SEL$D57D4812" "R"_at_"SEL$7")
USE_NL(_at_"SEL$D57D4812" "MIA"_at_"SEL$8")
USE_NL(_at_"SEL$D57D4812" "MIAL"_at_"SEL$10")
USE_NL(_at_"SEL$D57D4812" "U"_at_"SEL$12")
USE_NL(_at_"SEL$D57D4812" "D"_at_"SEL$6")
USE_NL(_at_"SEL$D57D4812" "ROLO"_at_"SEL$14")
INDEX_RS_ASC(_at_"SEL$22_1" "INV"_at_"SEL$22"
("INVOICE"."PURCHASE_ORDER_ID"))
INDEX_RS_ASC(_at_"SEL$22_2" "INV"_at_"SEL$22_2" ("INVOICE"."INVOICE_ID"))
PQ_FILTER(_at_"SEL$22" SERIAL)
FULL(_at_"SEL$27" "ACC"_at_"SEL$27")
INDEX(_at_"SEL$23" "INV2"_at_"SEL$23" ("INVOICE"."INVOICE_ID"))
INDEX_FFS(_at_"SEL$5B5BD84E" "C"_at_"SEL$3" ("CONTRACT"."CONTRACT_ID"))
FULL(_at_"SEL$5B5BD84E" "SC"_at_"SEL$2")
FULL(_at_"SEL$5B5BD84E" "CE"_at_"SEL$4")
LEADING(_at_"SEL$5B5BD84E" "C"_at_"SEL$3" "SC"@"SEL$2" "CE"@"SEL$4")
USE_HASH(_at_"SEL$5B5BD84E" "SC"_at_"SEL$2")
USE_HASH(_at_"SEL$5B5BD84E" "CE"_at_"SEL$4")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
5 - access("IDTYPE"."SYS_NC00004$"='NABP') 6 - access("PL"."PHARMACY_ID"=:B1 AND "IDTYPE"."IDENTIFIER_TYPE_ID"="PL"."IDENTIFIER_TYPE_ID") 11 - access("IDTYPE"."SYS_NC00004$"='NPI') 12 - access("PL"."PHARMACY_ID"=:B1 AND "IDTYPE"."IDENTIFIER_TYPE_ID"="PL"."IDENTIFIER_TYPE_ID")
17 - access("CE"."COVERED_ENTITY_ID"="SC"."COVERED_ENTITY_ID")
18 - access("SC"."CONTRACT_ID"="C"."CONTRACT_ID")
24 - access("PVI"."PHARMACY_ID"="from$_subquery$_036"."PHARMACY_ID")
25 - filter(CASE WHEN ("from$_subquery$_036"."QCSJ_C000000003600000" IS
NULL OR "WIT"."ITEM_ID" IS NULL) THEN 1 ELSE "WIT"."ITEM_ID" END =CASE WHEN
(("from$_subquery$_036"."QCSJ_C000000003600000" IS NULL) OR
("from$_subquery$_036"."QCSJ_C000000003600005" IS NULL)) THEN 1 ELSE
"from$_subquery$_036"."QCSJ_C000000003600005" END )
26 - access("WIL"."ITEM_ID"="WIT"."ITEM_ID")
filter("R"."NDC"=COALESCE(SUBSTR("WIL"."NDC",-11),"WIT"."NDC"))
28 - access("ACC"."WHOLESALER_ID"="WLS"."WHOLESALER_ID")
29 - filter((:WHOLESALER_ACCOUNT_ID IS NULL OR
"ACC"."ACCOUNT_ID"=:WHOLESALER_ACCOUNT_ID))
32 - filter(((:WHOLESALER_INVOICE_ID IS NULL OR
"INV"."INVOICE_ID"=:WHOLESALER_INVOICE_ID) AND (:WHOLESALER_INV_DATE_START
IS NULL OR
"INV"."INVOICE_DATE">=:WHOLESALER_INV_DATE_START) AND (:WHOLESALER_INV_DATE_END IS NULL OR
"INV"."INVOICE_DATE"<=:WHOLESALER_INV_DATE_END))) 36 - filter((:WHOLESALER_PURCH_ORDER_ID IS NULL OR "WPO"."PURCHASE_ORDER_ID"=:WHOLESALER_PURCH_ORDER_ID)) 46 - filter((:SUPERCONTRACT_ID IS NULL OR "C"."SUPERCONTRACT_ID"=:SUPERCONTRACT_ID)) 47 - access("C"."CONTRACT_ID"=9423)
48 - filter(((:REPLENISHMENT_ID IS NULL OR "R"."REPLENISHMENT_ID"=:REPLENISHMENT_ID) AND (:NDC IS NULL OR "R"."NDC"=:NDC) AND
(NVL("R"."REPLENISHMENT_TYPE",'normal')=:REPLENISHMENT_TYPE OR :REPLENISHMENT_TYPE IS NULL) AND (:REPLENISHED_ON_START IS NULL OR "R"."REPLENISHED_ON">=:REPLENISHED_ON_START) AND (:REPLENISHED_ON_END IS NULL OR "R"."REPLENISHED_ON"<=:REPLENISHED_ON_END)))
49 - access("R"."CONTRACT_ID"=9423 AND "R"."VOIDED_ON" IS NULL)
51 - access("R"."REPLENISHMENT_ID"="MIA"."REPLENISHMENT_ID")
53 - access("R"."REPLENISHMENT_ID"="MIAL"."REPLENISHMENT_ID")
55 - access("MIAL"."ADJUSTED_BY"="U"."USER_ID")
57 - access("R"."NDC"="D"."NDC")
59 - access("U"."ROLODEX_ID"="ROLO"."ROLODEX_ID")
61 -
access("from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"="PO"."PURCHASE_ORDER_ID")
63 - access("PO"."WHOLESALER_PURCHASE_ORDER_ID"="WPO"."PURCHASE_ORDER_ID")
66 - access("C"."RETAIL_ACCOUNT_ID"="ACCOUNT_ID" AND "R"."NDC"="NDC")
68 -
access("OEO"."REPLENISHMENT_ID"="from$_subquery$_019"."QCSJ_C000000001100000") 71 - filter( IS NULL)
72 - filter("INV"."IS_CREDIT"=CASE WHEN ("from$_subquery$_019"."QCSJ_C000000001300002">0) THEN 0 ELSE 1 END )
73 - access("PO"."WHOLESALER_PURCHASE_ORDER_ID"="INV"."PURCHASE_ORDER_ID")
74 - access("INV2"."INVOICE_ID"=:B1)
75 -
filter((LNNVL("PO"."WHOLESALER_PURCHASE_ORDER_ID"="INV"."PURCHASE_ORDER_ID") OR LNNVL("INV"."IS_CREDIT"=CASE WHEN
("from$_subquery$_019"."QCSJ_C000000001300002">0) THEN 0 ELSE 1 END ) OR LNNVL( IS NULL)))
77 -
access("from$_subquery$_019"."WHOLESALER_INVOICE_ID"="INV"."INVOICE_ID")
78 - access("INV2"."INVOICE_ID"=:B1)
80 - access("WIL"."INVOICE_ID"="INV"."INVOICE_ID")
82 - filter((("INV"."ACCOUNT_ID" IS NULL AND
"OEO"."WHOLESALER_ACCOUNT_NUMBER"="ACC"."ACCOUNT_NUMBER") OR
("OEO"."WHOLESALER_ACCOUNT_NUMBER" IS NULL
AND "INV"."ACCOUNT_ID"="ACC"."ACCOUNT_ID")))
87 - access("L"."PHARMACY_ID"="I"."PHARMACY_ID")
91 - filter(("CCE"."PARENT_ID" IS NULL OR
"CCE"."PARENT_ID"="CCE"."COVERED_ENTITY_ID" OR IS NULL))
92 -
filter("CCE"."CONTRACT_ID"="from$_subquery$_036"."QCSJ_C000000001300000") 94 - filter(("INNER"."CONTRACT_ID"=:B1 AND "COVERED_ENTITY_ID" IS NOT NULL AND LNNVL("COVERED_ENTITY_ID"<>:B2)))
Column Projection Information (identified by operation id):
1 - (#keys=0) unknown-uag()[4000]
2 - "PL".ROWID[ROWID,10], "PL"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"PL"."IDENTIFIER_VALUE"[VARCHAR2,100], "PL"."PHARMACY_ID"[NUMBER,22],
"IDTYPE".ROWID[ROWID,10], "IDTYPE"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"IDTYPE"."SYS_NC00004$"[VARCHAR2,100]
3 - "IDTYPE".ROWID[ROWID,10], "IDTYPE"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"IDTYPE"."SYS_NC00004$"[VARCHAR2,100], "PL".ROWID[ROWID,10],
"PL"."PHARMACY_ID"[NUMBER,22], "PL"."IDENTIFIER_TYPE_ID"[NUMBER,22]
4 - "IDTYPE".ROWID[ROWID,10], "IDTYPE"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"IDTYPE"."SYS_NC00004$"[VARCHAR2,100]
5 - "IDTYPE".ROWID[ROWID,10], "IDTYPE"."SYS_NC00004$"[VARCHAR2,100]
6 - "PL".ROWID[ROWID,10], "PL"."PHARMACY_ID"[NUMBER,22],
"PL"."IDENTIFIER_TYPE_ID"[NUMBER,22]
7 - (#keys=0) unknown-uag()[4000]
8 - "PL".ROWID[ROWID,10], "PL"."IDENTIFIER_TYPE_ID"[NUMBER,22], "PL"."IDENTIFIER_VALUE"[VARCHAR2,100], "PL"."PHARMACY_ID"[NUMBER,22],
"IDTYPE".ROWID[ROWID,10], "IDTYPE"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"IDTYPE"."SYS_NC00004$"[VARCHAR2,100]
9 - "IDTYPE".ROWID[ROWID,10], "IDTYPE"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"IDTYPE"."SYS_NC00004$"[VARCHAR2,100], "PL".ROWID[ROWID,10],
"PL"."PHARMACY_ID"[NUMBER,22], "PL"."IDENTIFIER_TYPE_ID"[NUMBER,22]
10 - "IDTYPE".ROWID[ROWID,10], "IDTYPE"."IDENTIFIER_TYPE_ID"[NUMBER,22],
"IDTYPE"."SYS_NC00004$"[VARCHAR2,100]
11 - "IDTYPE".ROWID[ROWID,10], "IDTYPE"."SYS_NC00004$"[VARCHAR2,100]
12 - "PL".ROWID[ROWID,10], "PL"."PHARMACY_ID"[NUMBER,22],
"PL"."IDENTIFIER_TYPE_ID"[NUMBER,22]
13 - (#keys=15) "REPLENISHMENT_ID"[NUMBER,22], "CONTRACT_ID"[NUMBER,22], "NDC"[CHARACTER,11], "QUANTITY"[NUMBER,22], "DRUG_NAME"[VARCHAR2,4000], "REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "COST"[NUMBER,22], "MANUAL_DESCRIPTION"[VARCHAR2,200], "NOTE"[VARCHAR2,255], "PUBLIC_NOTE"[VARCHAR2,255],
"CONTRACT_NAME"[VARCHAR2,120], "REPLENISHMENT_TYPE"[VARCHAR2,8], "NABP"[VARCHAR2,4000], "NPI"[VARCHAR2,4000], "GOVERNMENT_ID"[VARCHAR2,50], MIN("INVOICE_DATE")[10], MIN("REPLENISHED_ON")[10], MIN("ACCOUNT_ID")[22], MIN("RETAIL_PRICE")[22], MIN("WHOLESALER_INVOICE_ID")[22],
MIN("WHOLESALER_PURCHASE_ORDER_ID")[22], MIN("REPLENISHED_AT")[29], MIN("RECORDED_BY")[129], MIN("WHOLESALER_ACCOUNT_NUMBER")[255], MIN("INVOICE_NUMBER")[255],
MIN("WHOLESALER_PURCHASE_ORDER_NO")[255], MIN("WHOLESALER_NAME")[2000] 14 - "REPLENISHMENT_ID"[NUMBER,22], "CONTRACT_ID"[NUMBER,22], "NDC"[CHARACTER,11], "DRUG_NAME"[VARCHAR2,4000], "QUANTITY"[NUMBER,22], "REPLENISHED_ON"[VARCHAR2,10], "REPLENISHED_AT"[VARCHAR2,29], "REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], "WHOLESALER_PURCHASE_ORDER_NO"[VARCHAR2,255], "COST"[NUMBER,22], "WHOLESALER_INVOICE_ID"[NUMBER,22], "MANUAL_DESCRIPTION"[VARCHAR2,200], "NOTE"[VARCHAR2,255], "PUBLIC_NOTE"[VARCHAR2,255], "RETAIL_PRICE"[NUMBER,22], "INVOICE_NUMBER"[VARCHAR2,255], "INVOICE_DATE"[VARCHAR2,10],
"ACCOUNT_ID"[NUMBER,22], "WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255], "CONTRACT_NAME"[VARCHAR2,120], "REPLENISHMENT_TYPE"[VARCHAR2,8], "RECORDED_BY"[VARCHAR2,129], "NABP"[VARCHAR2,4000], "NPI"[VARCHAR2,4000], "GOVERNMENT_ID"[VARCHAR2,50], "WHOLESALER_NAME"[VARCHAR2,2000]
15 - "from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000000900000"[CHARACTER,11], "from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11], "from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7],
"from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255],
"from$_subquery$_036"."COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22],
"from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."PACK_QTY"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255],
"from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11],
"from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255],
"from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64],
"from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "PVI"."NABP"[VARCHAR2,4000],
"PVI"."NPI"[VARCHAR2,4000],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000], COUNT(DISTINCT
NLSSORT("CCE"."GOVERNMENT_ID",'nls_sort=''BINARY'''))[22],
MAX("CCE"."GOVERNMENT_ID")[50]
16 - SYSDEF[4], SYSDEF[0], SYSDEF[1], SYSDEF[112], SYSDEF[0]
17 - (#keys=1) "SC"."COVERED_ENTITY_ID"[NUMBER,22],
"CE"."COVERED_ENTITY_ID"[NUMBER,22], "C"."CONTRACT_ID"[NUMBER,22],
"SC"."CONTRACT_ID"[NUMBER,22],
"SC"."SUBCONTRACT_ID"[NUMBER,22], "CE"."PARENT_ID"[NUMBER,22],
"CE"."GOVERNMENT_ID"[VARCHAR2,50]
18 - (#keys=1) "C"."CONTRACT_ID"[NUMBER,22],
"SC"."CONTRACT_ID"[NUMBER,22], "SC"."SUBCONTRACT_ID"[NUMBER,22],
"SC"."COVERED_ENTITY_ID"[NUMBER,22]
19 - "C"."CONTRACT_ID"[NUMBER,22]
20 - "SC"."SUBCONTRACT_ID"[NUMBER,22], "SC"."CONTRACT_ID"[NUMBER,22],
"SC"."COVERED_ENTITY_ID"[NUMBER,22]
21 - "CE"."COVERED_ENTITY_ID"[NUMBER,22],
"CE"."GOVERNMENT_ID"[VARCHAR2,50], "CE"."PARENT_ID"[NUMBER,22]
22 - (#keys=39) "from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000000900000"[CHARACTER,11], "from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11], "from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7],
"from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255],
"from$_subquery$_036"."COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22],
"from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."PACK_QTY"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255],
"from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11],
"from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255],
"from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64],
"from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "PVI"."NABP"[VARCHAR2,4000],
"PVI"."NPI"[VARCHAR2,4000],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000], COUNT(DISTINCT
NLSSORT("CCE"."GOVERNMENT_ID",'nls_sort=''BINARY'''))[22],
MAX("CCE"."GOVERNMENT_ID")[50]
23 - "from$_subquery$_036"."PHARMACY_ID"[NUMBER,22],
"PVI"."PHARMACY_ID"[NUMBER,22], "WIL"."ITEM_ID"[NUMBER,22],
"WIT"."ITEM_ID"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_036"."COST"[NUMBER,22],
"from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_036"."PACK_QTY"[NUMBER,22],
"from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11],
"from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "WIT"."NDC"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120], "from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22], "from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7], "from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255],
"WIL"."NDC"[VARCHAR2,255], "PVI"."NPI"[VARCHAR2,4000],
"PVI"."NABP"[VARCHAR2,4000],
"CCE"."GOVERNMENT_ID"[VARCHAR2,50]
24 - (#keys=1) "from$_subquery$_036"."PHARMACY_ID"[NUMBER,22],
"PVI"."PHARMACY_ID"[NUMBER,22], "WIL"."ITEM_ID"[NUMBER,22],
"WIT"."ITEM_ID"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_036"."COST"[NUMBER,22],
"from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_036"."PACK_QTY"[NUMBER,22],
"from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11],
"from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "WIT"."NDC"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120], "from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22], "from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7], "from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255],
"WIL"."NDC"[VARCHAR2,255], "PVI"."NPI"[VARCHAR2,4000],
"PVI"."NABP"[VARCHAR2,4000]
25 - "WIL"."ITEM_ID"[NUMBER,22], "WIT"."ITEM_ID"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11], "from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_036"."COST"[NUMBER,22], "from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8], "from$_subquery$_036"."PACK_QTY"[NUMBER,22], "from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000], "from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11], "from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64],
"from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_036"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120], "from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22], "from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7], "from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255], "WIL"."NDC"[VARCHAR2,255], "WIT"."NDC"[VARCHAR2,255] 26 - (#keys=1) "WIL"."ITEM_ID"[NUMBER,22], "WIT"."ITEM_ID"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11], "from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_036"."COST"[NUMBER,22], "from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8], "from$_subquery$_036"."PACK_QTY"[NUMBER,22], "from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000], "from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11], "from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64],
"from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_036"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120], "from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22], "from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7], "from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255],
"WIL"."NDC"[VARCHAR2,255], "WIT"."NDC"[VARCHAR2,255]
27 - "from$_subquery$_036"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_036"."QCSJ_C000000001300002"[NUMBER,22], "from$_subquery$_036"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_036"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_036"."COST"[NUMBER,22],
"from$_subquery$_036"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_036"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_036"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_036"."PACK_QTY"[NUMBER,22],
"from$_subquery$_036"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_036"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_036"."QCSJ_C000000003000000"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003400002"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500004"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002500002"[TIMESTAMP,11],
"from$_subquery$_036"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_036"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_036"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000001900001"[VARCHAR2,120], "from$_subquery$_036"."QCSJ_C000000002100003"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003600000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000002500003"[DATE,7],
"from$_subquery$_036"."QCSJ_C000000002500005"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000002800000"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002500007"[NUMBER,22], "from$_subquery$_036"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."QCSJ_C000000002800001"[VARCHAR2,255], "from$_subquery$_036"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_036"."DATE_OF_DELIVERY"[DATE,7], "from$_subquery$_036"."EXTENDED_COST"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400000"[NUMBER,22], "from$_subquery$_036"."QCSJ_C000000003000001"[VARCHAR2,255],
"from$_subquery$_036"."SHORT_NAME"[VARCHAR2,255], "from$_subquery$_036"."QCSJ_C000000003600006"[NUMBER,22],
"from$_subquery$_036"."QCSJ_C000000003400003"[VARCHAR2,255],
"WIL"."NDC"[VARCHAR2,255], "WIL"."ITEM_ID"[NUMBER,22]
28 - (#keys=1) "ACC"."WHOLESALER_ID"[NUMBER,22],
"WLS"."WHOLESALER_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11], "from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22],
"from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200],
"from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255],
"from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22],
"from$_subquery$_019"."PACK_SIZE"[NUMBER,22],
"from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000], "from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11], "from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64],
"from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22], "WPO"."PO_NUMBER"[VARCHAR2,255],
ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22], "NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22], "OEO"."REPLENISHMENT_ID"[NUMBER,22], "INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255], "INV"."INVOICE_NUMBER"[VARCHAR2,255], "INV"."INVOICE_DATE"[DATE,7], "INV"."ACCOUNT_ID"[NUMBER,22],
"INV"."INVOICE_ID"[NUMBER,22], "WIL".ROWID[ROWID,10], "WIL"."INVOICE_ID"[NUMBER,22], "WIL"."NDC"[VARCHAR2,255], "WIL"."ITEM_ID"[NUMBER,22],
"ACC"."ACCOUNT_NUMBER"[VARCHAR2,255], "ACC"."ACCOUNT_ID"[NUMBER,22], "WLS"."SHORT_NAME"[VARCHAR2,255]
29 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22], "from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22], "from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22],
"OEO"."REPLENISHMENT_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."INVOICE_NUMBER"[VARCHAR2,255], "INV"."INVOICE_DATE"[DATE,7],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_ID"[NUMBER,22],
"WIL".ROWID[ROWID,10], "WIL"."INVOICE_ID"[NUMBER,22],
"WIL"."NDC"[VARCHAR2,255],
"WIL"."ITEM_ID"[NUMBER,22], "ACC"."ACCOUNT_NUMBER"[VARCHAR2,255],
"ACC"."WHOLESALER_ID"[NUMBER,22], "ACC"."ACCOUNT_ID"[NUMBER,22]
30 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22],
"OEO"."REPLENISHMENT_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."INVOICE_NUMBER"[VARCHAR2,255], "INV"."INVOICE_DATE"[DATE,7],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_ID"[NUMBER,22],
"WIL".ROWID[ROWID,10], "WIL"."INVOICE_ID"[NUMBER,22],
"WIL"."NDC"[VARCHAR2,255],
"WIL"."ITEM_ID"[NUMBER,22], "ACC"."ACCOUNT_NUMBER"[VARCHAR2,255],
"ACC"."WHOLESALER_ID"[NUMBER,22], "ACC"."ACCOUNT_ID"[NUMBER,22]
31 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22],
"OEO"."REPLENISHMENT_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."INVOICE_NUMBER"[VARCHAR2,255], "INV"."INVOICE_DATE"[DATE,7],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_ID"[NUMBER,22],
"WIL".ROWID[ROWID,10], "WIL"."INVOICE_ID"[NUMBER,22],
"WIL"."NDC"[VARCHAR2,255],
"WIL"."ITEM_ID"[NUMBER,22]
32 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22],
"OEO"."REPLENISHMENT_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."INVOICE_NUMBER"[VARCHAR2,255], "INV"."INVOICE_DATE"[DATE,7],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_ID"[NUMBER,22]
33 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22], "from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22],
"OEO"."REPLENISHMENT_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."INVOICE_NUMBER"[VARCHAR2,255], "INV"."INVOICE_DATE"[DATE,7],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_ID"[NUMBER,22]
34 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22], "from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255],
"PRICE"[NUMBER,22], "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255],
"OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"OEO"."INVOICE_NUMBER"[VARCHAR2,255],
"OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22],
"OEO"."REPLENISHMENT_ID"[NUMBER,22]
35 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22],
"WPO"."PO_NUMBER"[VARCHAR2,255], ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22],
"NDC"[VARCHAR2,255], "PRICE"[NUMBER,22]
36 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22], "WPO"."PO_NUMBER"[VARCHAR2,255]
37 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22], ROWID[ROWID,10],
"WPO"."PURCHASE_ORDER_ID"[NUMBER,22], "WPO"."PO_NUMBER"[VARCHAR2,255]
38 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22],
"PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],
"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22]
39 - "from$_subquery$_019"."QCSJ_C000000001100000"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001300000"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"from$_subquery$_019"."QCSJ_C000000001300002"[NUMBER,22],
"from$_subquery$_019"."REPLENISHED_ON"[TIMESTAMP,11],
"from$_subquery$_019"."VOIDED_ON"[TIMESTAMP,11], "from$_subquery$_019"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"from$_subquery$_019"."COST"[NUMBER,22], "from$_subquery$_019"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"from$_subquery$_019"."MANUAL_DESCRIPTION"[VARCHAR2,200], "from$_subquery$_019"."QCSJ_C000000001300004"[VARCHAR2,255],
"from$_subquery$_019"."QCSJ_C000000001300006"[VARCHAR2,255], "from$_subquery$_019"."REPLENISHMENT_TYPE"[VARCHAR2,8],
"from$_subquery$_019"."PACK_QTY"[NUMBER,22], "from$_subquery$_019"."PACK_SIZE"[NUMBER,22], "from$_subquery$_019"."DISTRIBUTOR"[VARCHAR2,2000],
"from$_subquery$_019"."ACCOUNT_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."PO_NUMBER"[VARCHAR2,255],
"from$_subquery$_019"."INVOICE_NUMBER"[VARCHAR2,255], "from$_subquery$_019"."INVOICE_DATE"[TIMESTAMP,11],
"from$_subquery$_019"."FIRST_NAME"[VARCHAR2,64], "from$_subquery$_019"."LAST_NAME"[VARCHAR2,64], "from$_subquery$_019"."PHARMACY_ID"[NUMBER,22],
"from$_subquery$_019"."QCSJ_C000000001900001"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"from$_subquery$_019"."SUPERCONTRACT_ID"[NUMBER,22]
40 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22],
"C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22], "R".ROWID[ROWID,10],
"R"."REPLENISHMENT_ID"[NUMBER,22], "R"."CONTRACT_ID"[NUMBER,22],
"R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22], "R"."REPLENISHED_ON"[TIMESTAMP,11],
"R"."VOIDED_ON"[TIMESTAMP,11],
"R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22],
"R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22],
"R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255],
"R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8], "MIA".ROWID[ROWID,10],
"MIA"."REPLENISHMENT_ID"[NUMBER,22],
"MIA"."DISTRIBUTOR"[VARCHAR2,2000],
"MIA"."ACCOUNT_NUMBER"[VARCHAR2,255], "MIA"."PO_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_DATE"[TIMESTAMP,11], "MIAL".ROWID[ROWID,10],
"MIAL"."REPLENISHMENT_ID"[NUMBER,22], "MIAL"."ADJUSTED_BY"[NUMBER,22],
"U".ROWID[ROWID,10],
"U"."USER_ID"[NUMBER,22], "U"."ROLODEX_ID"[NUMBER,22],
"D".ROWID[ROWID,10], "D"."NDC"[CHARACTER,11], "D"."PACK_QTY"[NUMBER,22],
"D"."PACK_SIZE"[NUMBER,22], "ROLO".ROWID[ROWID,10],
"ROLO"."ROLODEX_ID"[NUMBER,22], "ROLO"."FIRST_NAME"[VARCHAR2,64],
"ROLO"."LAST_NAME"[VARCHAR2,64]
41 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22],
"C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22], "R".ROWID[ROWID,10], "R"."REPLENISHMENT_ID"[NUMBER,22], "R"."CONTRACT_ID"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22], "R"."REPLENISHED_ON"[TIMESTAMP,11], "R"."VOIDED_ON"[TIMESTAMP,11],
"R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22], "R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255], "R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8], "MIA".ROWID[ROWID,10], "MIA"."REPLENISHMENT_ID"[NUMBER,22],
"MIA"."DISTRIBUTOR"[VARCHAR2,2000], "MIA"."ACCOUNT_NUMBER"[VARCHAR2,255], "MIA"."PO_NUMBER"[VARCHAR2,255], "MIA"."INVOICE_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_DATE"[TIMESTAMP,11], "MIAL".ROWID[ROWID,10], "MIAL"."REPLENISHMENT_ID"[NUMBER,22], "MIAL"."ADJUSTED_BY"[NUMBER,22], "U".ROWID[ROWID,10],
"U"."USER_ID"[NUMBER,22], "U"."ROLODEX_ID"[NUMBER,22], "D".ROWID[ROWID,10], "D"."NDC"[CHARACTER,11], "D"."PACK_QTY"[NUMBER,22], "D"."PACK_SIZE"[NUMBER,22]
42 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22], "C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120], "C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22], "R".ROWID[ROWID,10], "R"."REPLENISHMENT_ID"[NUMBER,22], "R"."CONTRACT_ID"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22], "R"."REPLENISHED_ON"[TIMESTAMP,11], "R"."VOIDED_ON"[TIMESTAMP,11],
"R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22], "R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255], "R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8], "MIA".ROWID[ROWID,10], "MIA"."REPLENISHMENT_ID"[NUMBER,22],
"MIA"."DISTRIBUTOR"[VARCHAR2,2000], "MIA"."ACCOUNT_NUMBER"[VARCHAR2,255], "MIA"."PO_NUMBER"[VARCHAR2,255], "MIA"."INVOICE_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_DATE"[TIMESTAMP,11], "MIAL".ROWID[ROWID,10], "MIAL"."REPLENISHMENT_ID"[NUMBER,22], "MIAL"."ADJUSTED_BY"[NUMBER,22], "U".ROWID[ROWID,10],
"U"."USER_ID"[NUMBER,22], "U"."ROLODEX_ID"[NUMBER,22] 43 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22], "C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120], "C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22], "R".ROWID[ROWID,10], "R"."REPLENISHMENT_ID"[NUMBER,22], "R"."CONTRACT_ID"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22], "R"."REPLENISHED_ON"[TIMESTAMP,11], "R"."VOIDED_ON"[TIMESTAMP,11],
"R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22], "R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255], "R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8], "MIA".ROWID[ROWID,10], "MIA"."REPLENISHMENT_ID"[NUMBER,22],
"MIA"."DISTRIBUTOR"[VARCHAR2,2000], "MIA"."ACCOUNT_NUMBER"[VARCHAR2,255], "MIA"."PO_NUMBER"[VARCHAR2,255], "MIA"."INVOICE_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_DATE"[TIMESTAMP,11], "MIAL".ROWID[ROWID,10],
"MIAL"."REPLENISHMENT_ID"[NUMBER,22], "MIAL"."ADJUSTED_BY"[NUMBER,22]
44 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22],
"C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120],
"C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22], "R".ROWID[ROWID,10], "R"."REPLENISHMENT_ID"[NUMBER,22], "R"."CONTRACT_ID"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22], "R"."REPLENISHED_ON"[TIMESTAMP,11], "R"."VOIDED_ON"[TIMESTAMP,11],
"R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22], "R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255], "R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8], "MIA".ROWID[ROWID,10], "MIA"."REPLENISHMENT_ID"[NUMBER,22],
"MIA"."DISTRIBUTOR"[VARCHAR2,2000], "MIA"."ACCOUNT_NUMBER"[VARCHAR2,255], "MIA"."PO_NUMBER"[VARCHAR2,255], "MIA"."INVOICE_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_DATE"[TIMESTAMP,11] 45 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22], "C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120], "C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22], "R".ROWID[ROWID,10], "R"."REPLENISHMENT_ID"[NUMBER,22], "R"."CONTRACT_ID"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22], "R"."REPLENISHED_ON"[TIMESTAMP,11], "R"."VOIDED_ON"[TIMESTAMP,11],
"R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22], "R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255], "R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8] 46 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22], "C"."PHARMACY_ID"[NUMBER,22], "C"."NAME"[VARCHAR2,120], "C"."RETAIL_ACCOUNT_ID"[NUMBER,22],
"C"."SUPERCONTRACT_ID"[NUMBER,22]
47 - "C".ROWID[ROWID,10], "C"."CONTRACT_ID"[NUMBER,22]
48 - "R".ROWID[ROWID,10], "R"."REPLENISHMENT_ID"[NUMBER,22],
"R"."CONTRACT_ID"[NUMBER,22], "R"."NDC"[CHARACTER,11],
"R"."QUANTITY"[NUMBER,22],
"R"."REPLENISHED_ON"[TIMESTAMP,11], "R"."VOIDED_ON"[TIMESTAMP,11], "R"."REPLENISHING_PURCHASE_ORDER_ID"[NUMBER,22], "R"."COST"[NUMBER,22], "R"."WHOLESALER_INVOICE_ID"[NUMBER,22], "R"."MANUAL_DESCRIPTION"[VARCHAR2,200], "R"."NOTE"[VARCHAR2,255], "R"."PUBLIC_NOTE"[VARCHAR2,255],
NVL("R"."REPLENISHMENT_TYPE",'normal')[8] 49 - "R".ROWID[ROWID,10], "R"."CONTRACT_ID"[NUMBER,22], "R"."VOIDED_ON"[TIMESTAMP,11]
50 - "MIA".ROWID[ROWID,10], "MIA"."REPLENISHMENT_ID"[NUMBER,22], "MIA"."DISTRIBUTOR"[VARCHAR2,2000], "MIA"."ACCOUNT_NUMBER"[VARCHAR2,255], "MIA"."PO_NUMBER"[VARCHAR2,255],
"MIA"."INVOICE_NUMBER"[VARCHAR2,255], "MIA"."INVOICE_DATE"[TIMESTAMP,11]
51 - "MIA".ROWID[ROWID,10], "MIA"."REPLENISHMENT_ID"[NUMBER,22] 52 - "MIAL".ROWID[ROWID,10], "MIAL"."REPLENISHMENT_ID"[NUMBER,22], "MIAL"."ADJUSTED_BY"[NUMBER,22] 53 - "MIAL".ROWID[ROWID,10], "MIAL"."REPLENISHMENT_ID"[NUMBER,22] 54 - "U".ROWID[ROWID,10], "U"."USER_ID"[NUMBER,22], "U"."ROLODEX_ID"[NUMBER,22]
55 - "U".ROWID[ROWID,10], "U"."USER_ID"[NUMBER,22] 56 - "D".ROWID[ROWID,10], "D"."NDC"[CHARACTER,11], "D"."PACK_QTY"[NUMBER,22], "D"."PACK_SIZE"[NUMBER,22]
57 - "D".ROWID[ROWID,10], "D"."NDC"[CHARACTER,11] 58 - "ROLO".ROWID[ROWID,10], "ROLO"."ROLODEX_ID"[NUMBER,22], "ROLO"."FIRST_NAME"[VARCHAR2,64], "ROLO"."LAST_NAME"[VARCHAR2,64] 59 - "ROLO".ROWID[ROWID,10], "ROLO"."ROLODEX_ID"[NUMBER,22] 60 - "PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22],"PO"."WHOLESALER_PURCHASE_ORDER_ID"[NUMBER,22] 61 - "PO".ROWID[ROWID,10], "PO"."PURCHASE_ORDER_ID"[NUMBER,22] 62 - ROWID[ROWID,10], "WPO"."PURCHASE_ORDER_ID"[NUMBER,22], "WPO"."PO_NUMBER"[VARCHAR2,255]
63 - ROWID[ROWID,10], "WPO"."PURCHASE_ORDER_ID"[NUMBER,22] 64 - ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22], "NDC"[VARCHAR2,255], "PRICE"[NUMBER,22]
65 - ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22], "NDC"[VARCHAR2,255], "PRICE"[NUMBER,22]
66 - ROWID[ROWID,10], "ACCOUNT_ID"[NUMBER,22], "NDC"[VARCHAR2,255] 67 - "OEO".ROWID[ROWID,10],
"OEO"."WHOLESALER_ACCOUNT_NUMBER"[VARCHAR2,255], "OEO"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255], "OEO"."INVOICE_NUMBER"[VARCHAR2,255], "OEO"."DATE_OF_DELIVERY"[DATE,7], "OEO"."EXTENDED_COST"[NUMBER,22], "OEO"."REPLENISHMENT_ID"[NUMBER,22]
68 - "OEO".ROWID[ROWID,10], "OEO"."REPLENISHMENT_ID"[NUMBER,22] 69 - "INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255], "INV"."INVOICE_NUMBER"[VARCHAR2,255],
"INV"."INVOICE_DATE"[DATE,7], "INV"."ACCOUNT_ID"[NUMBER,22],
"INV"."INVOICE_ID"[NUMBER,22]
70 - "INV".ROWID[ROWID,10], "INV"."INVOICE_ID"[NUMBER,22],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_DATE"[DATE,7],
"INV"."INVOICE_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."IS_CREDIT"[NUMBER,22]
71 - "INV".ROWID[ROWID,10], "INV"."INVOICE_ID"[NUMBER,22],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_DATE"[DATE,7],
"INV"."INVOICE_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."IS_CREDIT"[NUMBER,22]
72 - "INV".ROWID[ROWID,10], "INV"."INVOICE_ID"[NUMBER,22],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_DATE"[DATE,7],
"INV"."INVOICE_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."IS_CREDIT"[NUMBER,22]
73 - "INV".ROWID[ROWID,10], "INV"."PURCHASE_ORDER_ID"[NUMBER,22]
74 - "INV2".ROWID[ROWID,10], "INV2"."INVOICE_ID"[NUMBER,22]
75 - "INV".ROWID[ROWID,10], "INV"."INVOICE_ID"[NUMBER,22],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_DATE"[DATE,7],
"INV"."INVOICE_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."IS_CREDIT"[NUMBER,22]
76 - "INV".ROWID[ROWID,10], "INV"."INVOICE_ID"[NUMBER,22],
"INV"."ACCOUNT_ID"[NUMBER,22], "INV"."INVOICE_DATE"[DATE,7],
"INV"."INVOICE_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_NUMBER"[VARCHAR2,255],
"INV"."PURCHASE_ORDER_ID"[NUMBER,22], "INV"."IS_CREDIT"[NUMBER,22]
77 - "INV".ROWID[ROWID,10], "INV"."INVOICE_ID"[NUMBER,22]
78 - "INV2".ROWID[ROWID,10], "INV2"."INVOICE_ID"[NUMBER,22]
79 - "WIL".ROWID[ROWID,10], "WIL"."INVOICE_ID"[NUMBER,22],
"WIL"."NDC"[VARCHAR2,255], "WIL"."ITEM_ID"[NUMBER,22]
80 - "WIL".ROWID[ROWID,10], "WIL"."INVOICE_ID"[NUMBER,22]
81 - "ACC"."ACCOUNT_NUMBER"[VARCHAR2,255],
"ACC"."WHOLESALER_ID"[NUMBER,22], "ACC"."ACCOUNT_ID"[NUMBER,22]
82 - "ACC"."ACCOUNT_ID"[NUMBER,22], "ACC"."WHOLESALER_ID"[NUMBER,22],
"ACC"."ACCOUNT_NUMBER"[VARCHAR2,255]
83 - "WLS"."WHOLESALER_ID"[NUMBER,22], "WLS"."SHORT_NAME"[VARCHAR2,255] 84 - "WIT"."ITEM_ID"[NUMBER,22], "WIT"."NDC"[VARCHAR2,255] 85 - "PVI"."PHARMACY_ID"[NUMBER,22], "PVI"."NABP"[VARCHAR2,4000],"PVI"."NPI"[VARCHAR2,4000]
86 - (#keys=12) "I"."PHARMACY_ID"[NUMBER,22], "I"."PHARMACY_CHAIN_ID"[NUMBER,22], "I"."NAME"[VARCHAR2,100], "I"."PRIMARY_CONTACT_ROLODEX_ID"[NUMBER,22], "I"."DATA_SOURCE_ID"[NUMBER,22], "I"."DISTANCE_FROM_ENTITY"[NUMBER,22], "I"."IS_RURAL"[NUMBER,22],
"I"."LIVE"[NUMBER,22], "I"."STORE_NUMBER"[VARCHAR2,100], "I"."SWITCH_TYPE_ID"[NUMBER,22], DECODE(TO_CHAR(SYS_OP_VECBIT("SYS_NC00012$",0)),NULL,NVL("I"."REQUIRE_SITE_NUMBER_MATCH",0),'0',NVL("I"."REQUIRE_SITE_NUMBER_MATCH",0),'1',"I"."REQUIRE_ SITE_NUMBER_MATCH")[22], "L"."SITE_NUMBER"[VARCHAR2,11] 87 - (#keys=1) "I"."PHARMACY_ID"[NUMBER,22], "L"."PHARMACY_ID"[NUMBER,22],
DECODE(TO_CHAR(SYS_OP_VECBIT("SYS_NC00012$",0)),NULL,NVL("I"."REQUIRE_SITE_NUMBER_MATCH",0),'0',NVL("I"."REQUIRE_SITE_NUMBER_MATCH",0),'1',"I"."REQUIRE_
SITE_NUMBER_MATCH")[22], "I"."PHARMACY_CHAIN_ID"[NUMBER,22],
"I"."NAME"[VARCHAR2,100], "I"."PRIMARY_CONTACT_ROLODEX_ID"[NUMBER,22],
"I"."DATA_SOURCE_ID"[NUMBER,22],
"I"."DISTANCE_FROM_ENTITY"[NUMBER,22], "I"."IS_RURAL"[NUMBER,22],
"I"."STORE_NUMBER"[VARCHAR2,100],
"I"."SWITCH_TYPE_ID"[NUMBER,22], "I"."LIVE"[NUMBER,22],
"SYS_NC00012$"[RAW,126], "L"."SITE_NUMBER"[VARCHAR2,11]
88 - "I"."PHARMACY_ID"[NUMBER,22], "I"."PHARMACY_CHAIN_ID"[NUMBER,22],
"I"."NAME"[VARCHAR2,100], "I"."PRIMARY_CONTACT_ROLODEX_ID"[NUMBER,22],
"I"."DATA_SOURCE_ID"[NUMBER,22],
"I"."DISTANCE_FROM_ENTITY"[NUMBER,22], "I"."IS_RURAL"[NUMBER,22], "I"."STORE_NUMBER"[VARCHAR2,100],
"I"."SWITCH_TYPE_ID"[NUMBER,22], "I"."LIVE"[NUMBER,22], "SYS_NC00012$"[RAW,126], DECODE(TO_CHAR(SYS_OP_VECBIT("SYS_NC00012$",0)),NULL,NVL("I"."REQUIRE_SITE_NUMBER_MATCH",0),'0',NVL("I"."REQUIRE_SITE_NUMBER_MATCH",0),'1',"I"."REQUIRE_ SITE_NUMBER_MATCH")[22]
89 - "L"."PHARMACY_ID"[NUMBER,22], "L"."SITE_NUMBER"[VARCHAR2,11] 90 - "CCE"."GOVERNMENT_ID"[VARCHAR2,50] 91 - "CCE"."CONTRACT_ID"[NUMBER,22],
"CCE"."COVERED_ENTITY_ID"[NUMBER,22], "CCE"."PARENT_ID"[NUMBER,22], "CCE"."GOVERNMENT_ID"[VARCHAR2,50]
92 - "CCE"."CONTRACT_ID"[NUMBER,22],
"CCE"."COVERED_ENTITY_ID"[NUMBER,22], "CCE"."PARENT_ID"[NUMBER,22], "CCE"."GOVERNMENT_ID"[VARCHAR2,50]
93 - "C0"[NUMBER,22], "C1"[NUMBER,22], "C2"[NUMBER,22], "C3"[NUMBER,22], "C4"[VARCHAR2,50]
94 - "INNER"."CONTRACT_ID"[NUMBER,22], "COVERED_ENTITY_ID"[NUMBER,22] 95 - "C0"[NUMBER,22], "C1"[NUMBER,22], "C2"[NUMBER,22], "C3"[NUMBER,22], "C4"[VARCHAR2,50] On Wed, Jan 22, 2020 at 10:28 AM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
> > I think I've seen the anomaly once before - 128 block read requests, but > walking through the file one block at a time. I'm fairly sure it was an > older version of Oracle and it may have been something to do with sorting > for a window (over()) function . I'll see if I can find it in my library. > > Which version of Oracle are you using here ? > Is the TEMPFILE defined a bigfile tablespace or small file, and do you > really have db_files = 4096 in the parameter file ? > > > Regards > Jonathan Lewis > > > ________________________________________ > From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on > behalf of Cary Millsap <cary.millsap_at_method-r.com> > Sent: 22 January 2020 15:21 > To: Chris Taylor > Cc: ORACLE-L > Subject: Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / > V$SORT_Segment) > > So, there are at least two really weird things going on: > > 1. Why are we seeing evidence of 128-block reads happening upon > adjacent blocks? (The nth read would have obtained the first 127 blocks of > the (n + 1)th read...) > 2. If each of these reads really were a 1-block read, it would not be > a db file scattered read call (which, to the best of my knowledge is always > a multi-block read; otherwise, there'd be no blocks to scatter [into the > SGA]). Yes, a db file sequential read can be a multiblock read (back in the > old days), but I don't understand why a db file scattered read would ever > be a single-block read. > > I think it's time for strace! > > > Cary Millsap > Method R Corporation > Author of Optimizing Oracle Performance<http://amzn.to/OM0q75> > and The Method R Guide to Mastering Oracle Trace Data, 3rd edition< > https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed> > > > > On Wed, Jan 22, 2020 at 9:14 AM Cary Millsap <cary.millsap_at_method-r.com > <mailto:cary.millsap_at_method-r.com>> wrote: > Ah. Now I see the block# incrementing by one. (Thank you, Keith Moore, for > spotting that.) > > > Cary Millsap > Method R Corporation > Author of Optimizing Oracle Performance<http://amzn.to/OM0q75> > and The Method R Guide to Mastering Oracle Trace Data, 3rd edition< > https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed> > > > > On Wed, Jan 22, 2020 at 8:41 AM Cary Millsap <cary.millsap_at_method-r.com > <mailto:cary.millsap_at_method-r.com>> wrote: > Hi Chris, > > What in your trace file is giving you the idea that the process is doing > 1-block reads? > > > Cary Millsap > Method R Corporation > Author of Optimizing Oracle Performance<http://amzn.to/OM0q75> > and The Method R Guide to Mastering Oracle Trace Data, 3rd edition< > https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed> > > > > On Tue, Jan 21, 2020 at 6:01 PM Chris Taylor < > christopherdtaylor1994_at_gmail.com<mailto:christopherdtaylor1994_at_gmail.com>> > wrote: > So we use an ADG standby db for reporting and we've got some problem SQLs > that I'm putzing around with because they work fine in all our other > non-standby databases. > > Looking deeper into the tracefile, I see it doing 1 block at a time reads > , even though it says its reading 128. > > It does this on both of our ADG Standby Databases which are on completely > different hardware. > > WAIT #140196872952648: nam='db file scattered read' ela= 1588 file#=4097 > block#=579715946 blocks=128 obj#=-39778567 tim=17263910670242 > WAIT #140196872952648: nam='db file scattered read' ela= 1495 file#=4097 > block#=579715947 blocks=128 obj#=-39778567 tim=17263910672065 > WAIT #140196872952648: nam='db file scattered read' ela= 1671 file#=4097 > block#=579715948 blocks=128 obj#=-39778567 tim=17263910674042 > WAIT #140196872952648: nam='db file scattered read' ela= 1094 file#=4097 > block#=579715949 blocks=128 obj#=-39778567 tim=17263910675443 > > File# in this case is the TEMP Segment from V$SORT_SEGMENT. > > If I check V$SORT_SEGMENT, I don't see any object that has that many > blocks. > > I'm considering dropping & recreating the TEMPFILE in the two standby > databases to see if that will resolve the issue. > > Anyone seen anything like that before? > > Chris > > -- > http://www.freelists.org/webpage/oracle-l > > >
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 22 2020 - 17:29:23 CET