Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / V$SORT_Segment)
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Jan 2020 17:10:11 +0000
Message-ID: <LNXP265MB156219ED89D28DF3E514DEF9A50C0_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>
From: Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: 22 January 2020 16:29
To: Jonathan Lewis; Cary Millsap; andy_at_oracledepot.com Cc: Oracle L
Subject: Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / V$SORT_Segment)
| 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 | | |
*/
75 - filter((LNNVL("PO"."WHOLESALER_PURCHASE_ORDER_ID"="INV"."PURCHASE_ORDER_ID") OR LNNVL("INV"."IS_CREDIT"=CASE WHEN
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Cary Millsap <cary.millsap_at_method-r.com<mailto: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)
Date: Wed, 22 Jan 2020 17:10:11 +0000
Message-ID: <LNXP265MB156219ED89D28DF3E514DEF9A50C0_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>
From: Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: 22 January 2020 16:29
To: Jonathan Lewis; Cary Millsap; andy_at_oracledepot.com Cc: Oracle L
Subject: Re: 12.1.0.2 ADG Reading 1 block at a time? (TEMP / V$SORT_Segment)
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"@"SEL$1")
NO_ACCESS(_at_"SEL$057B6AC8" "from$_subquery$_036"@"SEL$36")
INDEX_FFS(_at_"SEL$057B6AC8" "WIT"@"SEL$35" ("ITEM"."NDC" "ITEM"."ITEM_ID" "ITEM"."ITEM_NUMBER"))
NO_ACCESS(_at_"SEL$057B6AC8" "PVI"@"SEL$37")
NO_ACCESS(_at_"SEL$057B6AC8" "from$_subquery$_072"@"SEL$48")
LEADING(_at_"SEL$057B6AC8" "from$_subquery$_036"@"SEL$36" "WIT"@"SEL$35" "PVI"@"SEL$37" "from$_subquery$_072"@"SEL$48")
USE_HASH(_at_"SEL$057B6AC8" "WIT"@"SEL$35")
USE_HASH(_at_"SEL$057B6AC8" "PVI"@"SEL$37")
USE_NL(_at_"SEL$057B6AC8" "from$_subquery$_072"@"SEL$48")
NO_ACCESS(_at_"SEL$5A696D79" "from$_subquery$_019"@"SEL$19")
INDEX_RS_ASC(_at_"SEL$5A696D79" "PO"@"SEL$20" ("PURCHASE_ORDER"."PURCHASE_ORDER_ID"))
INDEX_RS_ASC(_at_"SEL$5A696D79" "WPO"@"SEL$31" ("PURCHASE_ORDER"."PURCHASE_ORDER_ID"))
INDEX_RS_ASC(_at_"SEL$5A696D79" "PRICE_LIST2"@"SEL$18" ("PRICE_LIST2"."ACCOUNT_ID" "PRICE_LIST2"."NDC"))
INDEX_RS_ASC(_at_"SEL$5A696D79" "OEO"@"SEL$25" ("EXTERNAL_ORDER"."REPLENISHMENT_ID"))
NO_ACCESS(_at_"SEL$5A696D79" "from$_subquery$_064"@"SEL$24")
INDEX_RS_ASC(_at_"SEL$5A696D79" "WIL"@"SEL$33" ("INVOICE_LINE"."INVOICE_ID"))
NO_ACCESS(_at_"SEL$5A696D79" "from$_subquery$_066"@"SEL$28")
FULL(_at_"SEL$5A696D79" "WLS"@"SEL$29")
LEADING(_at_"SEL$5A696D79" "from$_subquery$_019"@"SEL$19" "PO"@"SEL$20" "WPO"@"SEL$31" "PRICE_LIST2"@"SEL$18" "OEO"@"SEL$25"
"from$_subquery$_064"_at_"SEL$24" "WIL"@"SEL$33" "from$_subquery$_066"@"SEL$28" "WLS"@"SEL$29")
USE_NL(_at_"SEL$5A696D79" "PO"@"SEL$20")
USE_NL(_at_"SEL$5A696D79" "WPO"@"SEL$31")
USE_NL(_at_"SEL$5A696D79" "PRICE_LIST2"@"SEL$18")
USE_NL(_at_"SEL$5A696D79" "OEO"@"SEL$25")
USE_NL(_at_"SEL$5A696D79" "from$_subquery$_064"@"SEL$24")
USE_NL(_at_"SEL$5A696D79" "WIL"@"SEL$33")
USE_NL(_at_"SEL$5A696D79" "from$_subquery$_066"@"SEL$28")
USE_HASH(_at_"SEL$5A696D79" "WLS"@"SEL$29")
FULL(_at_"SEL$C400B828" "I"@"SEL$41")
INDEX_FFS(_at_"SEL$C400B828" "L"@"SEL$40" ("LOOKUP"."PHARMACY_ID" "LOOKUP"."SITE_NUMBER"))
LEADING(_at_"SEL$C400B828" "I"@"SEL$41" "L"@"SEL$40")
USE_HASH(_at_"SEL$C400B828" "L"@"SEL$40")
NO_ACCESS(_at_"SEL$46" "CCE"@"SEL$46")
PQ_FILTER(_at_"SEL$46" SERIAL)
FULL(_at_"SEL$985ADCC9" "T1"@"SEL$985ADCC9")
NO_ACCESS(_at_"SEL$47" "INNER"@"SEL$47")
FULL(_at_"SEL$985ADCC8" "T1"@"SEL$985ADCC8")
INDEX_RS_ASC(_at_"SEL$91EBC5DD" "IDTYPE"@"SEL$39" "IDENTIFIER_TYPE_IDX01")
INDEX(_at_"SEL$91EBC5DD" "PL"@"SEL$39" ("LOOKUP"."PHARMACY_ID" "LOOKUP"."IDENTIFIER_TYPE_ID"))
LEADING(_at_"SEL$91EBC5DD" "IDTYPE"@"SEL$39" "PL"@"SEL$39")
USE_NL(_at_"SEL$91EBC5DD" "PL"@"SEL$39")
NLJ_PREFETCH(_at_"SEL$91EBC5DD" "PL"@"SEL$39")
INDEX_RS_ASC(_at_"SEL$21E57174" "IDTYPE"@"SEL$38" "IDENTIFIER_TYPE_IDX01")
INDEX(_at_"SEL$21E57174" "PL"@"SEL$38" ("LOOKUP"."PHARMACY_ID" "LOOKUP"."IDENTIFIER_TYPE_ID"))
LEADING(_at_"SEL$21E57174" "IDTYPE"@"SEL$38" "PL"@"SEL$38")
USE_NL(_at_"SEL$21E57174" "PL"@"SEL$38")
NLJ_PREFETCH(_at_"SEL$21E57174" "PL"@"SEL$38")
INDEX_RS_ASC(_at_"SEL$D57D4812" "C"@"SEL$16" ("CONTRACT"."CONTRACT_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "R"@"SEL$7" ("REPLENISHMENT"."CONTRACT_ID" "REPLENISHMENT"."VOIDED_ON"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "MIA"@"SEL$8" ("MANUAL_INVENTORY_ADJUSTMENT"."REPLENISHMENT_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "MIAL"@"SEL$10" ("MANUAL_INV_ADJUSTMENT_LOG"."REPLENISHMENT_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "U"@"SEL$12" ("USERS"."USER_ID"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "D"@"SEL$6" ("DRUG"."NDC"))
INDEX_RS_ASC(_at_"SEL$D57D4812" "ROLO"@"SEL$14" ("INFO"."ROLODEX_ID"))
LEADING(_at_"SEL$D57D4812" "C"@"SEL$16" "R"@"SEL$7" "MIA"@"SEL$8" "MIAL"@"SEL$10" "U"@"SEL$12" "D"@"SEL$6" "ROLO"@"SEL$14")
USE_NL(_at_"SEL$D57D4812" "R"@"SEL$7")
USE_NL(_at_"SEL$D57D4812" "MIA"@"SEL$8")
USE_NL(_at_"SEL$D57D4812" "MIAL"@"SEL$10")
USE_NL(_at_"SEL$D57D4812" "U"@"SEL$12")
USE_NL(_at_"SEL$D57D4812" "D"@"SEL$6")
USE_NL(_at_"SEL$D57D4812" "ROLO"@"SEL$14")
INDEX_RS_ASC(_at_"SEL$22_1" "INV"@"SEL$22" ("INVOICE"."PURCHASE_ORDER_ID"))
INDEX_RS_ASC(_at_"SEL$22_2" "INV"@"SEL$22_2" ("INVOICE"."INVOICE_ID"))
PQ_FILTER(_at_"SEL$22" SERIAL)
FULL(_at_"SEL$27" "ACC"@"SEL$27")
INDEX(_at_"SEL$23" "INV2"@"SEL$23" ("INVOICE"."INVOICE_ID"))
INDEX_FFS(_at_"SEL$5B5BD84E" "C"@"SEL$3" ("CONTRACT"."CONTRACT_ID"))
FULL(_at_"SEL$5B5BD84E" "SC"@"SEL$2")
FULL(_at_"SEL$5B5BD84E" "CE"@"SEL$4")
LEADING(_at_"SEL$5B5BD84E" "C"@"SEL$3" "SC"@"SEL$2" "CE"@"SEL$4")
USE_HASH(_at_"SEL$5B5BD84E" "SC"@"SEL$2")
USE_HASH(_at_"SEL$5B5BD84E" "CE"@"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<mailto: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<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Cary Millsap <cary.millsap_at_method-r.com<mailto: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:
- 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...)
- 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><mailto: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><mailto: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><mailto: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 - 18:10:11 CET