Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 关于索引优化器选择路径上

张沛

0 积分	1 好友	29 主题

发消息

[RAC性能调优] 关于索引优化器选择路径上

1^#

发表于 2013-1-21 14:03:57 | 查看: 4208| 回复: 6

我先问问题，底下是执行计划，由于太长，分两部分粘贴了
我找到24和37可能是导致这条语句比较慢的原因
我在ctlgd表的COLLECTED_TAX_CCID，ACCOUNT_CLASS，ACCOUNT_SET_FLAG这三列创建了位图索引，因为经过我查询后，它一列只有几类数据

SQL> select count(*) from AR.RA_CUST_TRX_LINE_GL_DIST_ALL ctlgd;
COUNT(*)
----------
2120591
SQL> select count(*) from FND_LOOKUP_VALUES LV;
COUNT(*)
----------
482547
SQL> select ACCOUNT_SET_FLAG from AR.RA_CUST_TRX_LINE_GL_DIST_ALL group by ACCOU
NT_SET_FLAG;
AC
--
N
SQL> select ACCOUNT_CLASS from AR.RA_CUST_TRX_LINE_GL_DIST_ALL group by ACCOUNT
_CLASS;
ACCOUNT_CLASS
----------------------------------------
REC
REV
ROUND
TAX
SQL> select COLLECTED_TAX_CCID from AR.RA_CUST_TRX_LINE_GL_DIST_ALL group by CO
LLECTED_TAX_CCID;
COLLECTED_TAX_CCID
------------------

复制代码

第一个和最后一个由于环境变量问题查询结果稍有不同，但是总体也就几种
我在这些列上添加索引后为什么优化器没有选择我建的索引呢？我觉得位图索引要比全表扫描要好，不需要在sql中指定它引用索引吧。

分享0

收藏0 回复只看该作者道具举报

张沛

2^#

发表于 2013-1-21 14:04:30

1
2 -----------------------------------------------------------------------------------------------------------------------------
3 | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)|
4 -----------------------------------------------------------------------------------------------------------------------------
5 | 0 | SELECT STATEMENT | | 162 | 143K| | 23799 (3)|
6 |* 1 | HASH JOIN RIGHT OUTER | | 162 | 143K| | 23799 (3)|
7 |* 2 | TABLE ACCESS FULL | MTL_UNITS_OF_MEASURE_TL | 17 | 221 | | 5 (0)|
8 | 3 | NESTED LOOPS | | 162 | 141K| | 23794 (3)|
9 | 4 | NESTED LOOPS | | 162 | 135K| | 23632 (3)|
10 | 5 | NESTED LOOPS | | 162 | 131K| | 23470 (3)|
11 |* 6 | HASH JOIN RIGHT OUTER | | 162 | 127K| | 23307 (3)|
12 | 7 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | | 5 (0)|
13 |* 8 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | | 3 (0)|
14 |* 9 | HASH JOIN RIGHT OUTER | | 162 | 118K| | 23302 (3)|
15 | 10 | TABLE ACCESS FULL | AR_VAT_TAX_ALL_B | 13 | 247 | | 5 (0)|
16 | 11 | NESTED LOOPS OUTER | | 162 | 115K| | 23296 (3)|
17 | 12 | NESTED LOOPS OUTER | | 162 | 113K| | 22810 (3)|
18 | 13 | NESTED LOOPS OUTER | | 162 | 110K| | 22809 (3)|
19 |* 14 | HASH JOIN OUTER | | 162 | 96228 | | 22491 (3)|
20 | 15 | NESTED LOOPS OUTER | | 162 | 92664 | | 22468 (3)|
21 |* 16 | HASH JOIN | | 162 | 89586 | | 22467 (3)|
22 | 17 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | | 5 (0)|
23 |* 18 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | | 3 (0)|
24 |* 19 | HASH JOIN | | 311 | 150K| | 22462 (3)|
25 | 20 | TABLE ACCESS FULL | RA_CUST_TRX_TYPES_ALL | 242 | 7502 | | 5 (0)|
26 |* 21 | HASH JOIN | | 1452 | 656K| | 22456 (3)|
27 | 22 | TABLE ACCESS FULL | RA_BATCH_SOURCES_ALL | 76 | 2128 | | 5 (0)|
28 |* 23 | HASH JOIN | | 3438 | 1460K| 11M| 22451 (3)|
29 |* 24 | HASH JOIN | | 30941 | 10M| | 12667 (3)|
30 |* 25 | TABLE ACCESS FULL | FND_LOOKUP_VALUES | 13548 | 780K| | 2185 (2)|
31 |* 26 | HASH JOIN RIGHT OUTER | | 1102K| 324M| | 10471 (4)|
32 | 27 | TABLE ACCESS FULL | JTF_RS_SALESREPS | 441 | 10143 | | 5 (0)|
33 |* 28 | HASH JOIN | | 1102K| 300M| | 10455 (3)|
34 | 29 | NESTED LOOPS | | 1 | 177 | | 9 (0)|
35 | 30 | NESTED LOOPS | | 1 | 118 | | 5 (0)|
36 | 31 | TABLE ACCESS BY INDEX ROWID| FND_LOOKUP_VALUES | 1 | 59 | | 3 (0)|
37 |* 32 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | | 2 (0)|
38 | 33 | TABLE ACCESS BY INDEX ROWID| FND_LOOKUP_VALUES | 1 | 59 | | 2 (0)|
39 |* 34 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | | 1 (0)|
40 | 35 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | | 4 (0)|
41 |* 36 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | | 2 (0)|
42 |* 37 | TABLE ACCESS FULL | RA_CUST_TRX_LINE_GL_DIST_ALL | 2120K| 220M| | 10424 (3)|
43 | 38 | TABLE ACCESS FULL | RA_CUSTOMER_TRX_ALL | 372K| 23M| | 7825 (2)|
44 | 39 | TABLE ACCESS BY INDEX ROWID | GL_DAILY_CONVERSION_TYPES | 1 | 19 | | 1 (0)|
45 |* 40 | INDEX UNIQUE SCAN | GL_DAILY_CONVERSION_TYPES_U1 | 1 | | | 0 (0)|
46 | 41 | TABLE ACCESS FULL | FND_DOCUMENT_SEQUENCES | 3296 | 72512 | | 22 (0)|
47 |* 42 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 105 | | 3 (0)|
48 |* 43 | INDEX RANGE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | | 2 (0)|
49 | 44 | TABLE ACCESS BY INDEX ROWID | RA_RULES | 1 | 18 | | 1 (0)|
50 |* 45 | INDEX UNIQUE SCAN | RA_RULES_U1 | 1 | | | 0 (0)|
51 |* 46 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 14 | | 3 (0)|
52 |* 47 | INDEX RANGE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | | 2 (0)|
53 | 48 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 21 | | 1 (0)|
54 |* 49 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_U1 | 1 | | | 0 (0)|
55 | 50 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_SITE_USES_ALL | 1 | 25 | | 1 (0)|
56 |* 51 | INDEX UNIQUE SCAN | HZ_CUST_SITE_USES_U1 | 1 | | | 0 (0)|
57 | 52 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 40 | | 1 (0)|
58 |* 53 | INDEX UNIQUE SCAN | HZ_PARTIES_U1 | 1 | | | 0 (0)|
59 -----------------------------------------------------------------------------------------------------------------------------

复制代码

回复只看该作者道具举报

张沛

3^#

发表于 2013-1-21 14:05:35

61 Predicate Information (identified by operation id):
62 ---------------------------------------------------
63
64 1 - access("UOM_CODE"(+)="CTL"."UOM_CODE")
65 2 - filter("LANGUAGE"(+)=USERENV('LANG'))
66 6 - access("LV"."LOOKUP_CODE"(+)="CTL"."LINE_TYPE")
67 8 - access("LV"."LOOKUP_TYPE"(+)='STD_LINE_TYPE' AND "LV"."VIEW_APPLICATION_ID"(+)=222 AND
68 "LV"."SECURITY_GROUP_ID"(+)=0 AND "LV"."LANGUAGE"(+)=USERENV('LANG'))
69 filter("LV"."LANGUAGE"(+)=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"(+)=0)
70 9 - access("AVT"."VAT_TAX_ID"(+)="CTL"."VAT_TAX_ID" AND NVL("AVT"."ORG_ID"(+),(-99))=NVL("CTL"."ORG_ID",(-99)))
71 14 - access("CT"."DOC_SEQUENCE_ID"="FD"."DOC_SEQUENCE_ID"(+))
72 16 - access("LV"."LOOKUP_CODE"="CTT"."TYPE")
73 18 - access("LV"."LOOKUP_TYPE"='INV/CM' AND "LV"."VIEW_APPLICATION_ID"=222 AND "LV"."SECURITY_GROUP_ID"=0 AND
74 "LV"."LANGUAGE"=USERENV('LANG'))
75 filter("LV"."LANGUAGE"=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"=0)
76 19 - access("CT"."CUST_TRX_TYPE_ID"="CTT"."CUST_TRX_TYPE_ID" AND
77 NVL("CT"."ORG_ID",(-99))=NVL("CTT"."ORG_ID",(-99)))
78 21 - access("CT"."BATCH_SOURCE_ID"="BS"."BATCH_SOURCE_ID" AND NVL("CT"."ORG_ID",(-99))=NVL("BS"."ORG_ID",(-99)))
79 23 - access("CT"."CUSTOMER_TRX_ID"="CTLGD"."CUSTOMER_TRX_ID" AND
80 NVL("CT"."ORG_ID",(-99))=NVL("CTLGD"."ORG_ID",(-99)))
81 filter(NVL("CT"."ORG_ID",(-99))=DECODE(TO_CHAR("S"."SALESREP_ID"),NULL,NVL("CT"."ORG_ID",(-99)),NVL("S"."ORG_I
82 D",(-99))))
83 24 - access("LV"."LOOKUP_TYPE"=DECODE(TO_CHAR("CTLGD"."COLLECTED_TAX_CCID"),NULL,'AUTOGL_TYPE','DISTRIBUTION_SOURCE
84 _TYPE') AND "LV"."LOOKUP_CODE"=DECODE(TO_CHAR("CTLGD"."COLLECTED_TAX_CCID"),NULL,NVL("CTLGD"."ACCOUNT_CLASS",'REV'),'
85 DEFERRED_TAX'))
86 25 - filter("LV"."VIEW_APPLICATION_ID"=222 AND "LV"."LANGUAGE"=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"=0)
87 26 - access("S"."SALESREP_ID"(+)="CTLGD"."CUST_TRX_LINE_SALESREP_ID")
88 28 - access("LV"."LOOKUP_CODE"=DECODE("CTLGD"."POSTING_CONTROL_ID",(-3),'N','Y'))
89 32 - access("LV"."LOOKUP_TYPE"='VIEW_ACCOUNTING' AND "LV"."VIEW_APPLICATION_ID"=222 AND "LV"."LOOKUP_CODE"='LINE'
90 AND "LV"."SECURITY_GROUP_ID"=0 AND "LV"."LANGUAGE"=USERENV('LANG'))
91 34 - access("LV"."LOOKUP_TYPE"='VIEW_ACCOUNTING' AND "LV"."VIEW_APPLICATION_ID"=222 AND
92 "LV"."LOOKUP_CODE"='DETAIL_LINE' AND "LV"."SECURITY_GROUP_ID"=0 AND "LV"."LANGUAGE"=USERENV('LANG'))
93 36 - access("LV"."LOOKUP_TYPE"='YES/NO' AND "LV"."VIEW_APPLICATION_ID"=222 AND "LV"."SECURITY_GROUP_ID"=0 AND
94 "LV"."LANGUAGE"=USERENV('LANG'))
95 filter("LV"."LANGUAGE"=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"=0)
96 37 - filter("CTLGD"."ACCOUNT_SET_FLAG"='N')
97 40 - access("CT"."EXCHANGE_RATE_TYPE"="GLCT"."CONVERSION_TYPE"(+))
98 42 - filter(NVL("CTLGD"."ORG_ID",(-99))=NVL("CTL"."ORG_ID"(+),(-99)))
99 43 - access("CTLGD"."CUSTOMER_TRX_LINE_ID"="CTL"."CUSTOMER_TRX_LINE_ID"(+))
100 45 - access("RR"."RULE_ID"(+)="CTL"."ACCOUNTING_RULE_ID")
101 46 - filter(NVL("CTL"."ORG_ID",(-99))=NVL("CTL2"."ORG_ID"(+),(-99)))
102 47 - access("CTL"."LINK_TO_CUST_TRX_LINE_ID"="CTL2"."CUSTOMER_TRX_LINE_ID"(+))
103 49 - access("CT"."BILL_TO_CUSTOMER_ID"="CUST_ACCT"."CUST_ACCOUNT_ID")
104 51 - access("CT"."BILL_TO_SITE_USE_ID"="SU"."SITE_USE_ID")
105 53 - access("CUST_ACCT"."PARTY_ID"="PARTY"."PARTY_ID")
106
107 Note
108 -----
109 - 'PLAN_TABLE' is old version

复制代码

回复只看该作者道具举报

张沛

4^#

发表于 2013-1-21 15:21:40

下半部分的执行计划

1
2 ---------------------------------------------------------------------------------------------------------------------
3 | Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
4 ---------------------------------------------------------------------------------------------------------------------
5 | 0 | SELECT STATEMENT | | 1 | 772 | 3484 (1)|
6 | 1 | NESTED LOOPS OUTER | | 1 | 772 | 3484 (1)|
7 | 2 | NESTED LOOPS OUTER | | 1 | 713 | 3482 (1)|
8 | 3 | NESTED LOOPS | | 1 | 694 | 3479 (1)|
9 | 4 | NESTED LOOPS | | 1 | 635 | 3477 (1)|
10 | 5 | NESTED LOOPS OUTER | | 1 | 604 | 3475 (1)|
11 | 6 | NESTED LOOPS | | 1 | 582 | 3474 (1)|
12 | 7 | NESTED LOOPS | | 1 | 539 | 3472 (1)|
13 | 8 | NESTED LOOPS | | 1 | 480 | 3470 (1)|
14 | 9 | NESTED LOOPS | | 1 | 467 | 3468 (1)|
15 | 10 | NESTED LOOPS OUTER | | 1 | 431 | 3466 (1)|
16 |* 11 | FILTER | | | | |
17 | 12 | NESTED LOOPS OUTER | | 1 | 391 | 3465 (1)|
18 | 13 | NESTED LOOPS OUTER | | 1 | 362 | 3464 (1)|
19 | 14 | NESTED LOOPS OUTER | | 1 | 341 | 3463 (1)|
20 | 15 | NESTED LOOPS | | 1 | 322 | 3462 (1)|
21 | 16 | NESTED LOOPS | | 1 | 263 | 3460 (1)|
22 | 17 | NESTED LOOPS | | 1 | 171 | 3457 (1)|
23 | 18 | NESTED LOOPS | | 1 | 118 | 7 (0)|
24 | 19 | TABLE ACCESS BY INDEX ROWID| FND_LOOKUP_VALUES | 1 | 59 | 3 (0)|
25 |* 20 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | 2 (0)|
26 | 21 | TABLE ACCESS BY INDEX ROWID| FND_LOOKUP_VALUES | 1 | 59 | 4 (0)|
27 |* 22 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | 2 (0)|
28 |* 23 | TABLE ACCESS BY INDEX ROWID | AR_RECEIVABLE_APPLICATIONS_ALL | 1 | 53 | 3450 (1)|
29 |* 24 | INDEX FULL SCAN | AR_RECEIVABLE_APPLICATIONS_N2 | 8330 | | 32 (0)|
30 |* 25 | TABLE ACCESS BY INDEX ROWID | AR_DISTRIBUTIONS_ALL | 1 | 92 | 3 (0)|
31 |* 26 | INDEX RANGE SCAN | AR_DISTRIBUTIONS_N1 | 1 | | 2 (0)|
32 | 27 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | 2 (0)|
33 |* 28 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | 1 (0)|
34 | 29 | TABLE ACCESS BY INDEX ROWID | GL_DAILY_CONVERSION_TYPES | 1 | 19 | 1 (0)|
35 |* 30 | INDEX UNIQUE SCAN | GL_DAILY_CONVERSION_TYPES_U1 | 1 | | 0 (0)|
36 | 31 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_ACCOUNTS | 1 | 21 | 1 (0)|
37 |* 32 | INDEX UNIQUE SCAN | HZ_CUST_ACCOUNTS_U1 | 1 | | 0 (0)|
38 | 33 | TABLE ACCESS BY INDEX ROWID | HZ_CUST_SITE_USES_ALL | 1 | 29 | 1 (0)|
39 |* 34 | INDEX UNIQUE SCAN | HZ_CUST_SITE_USES_U1 | 1 | | 0 (0)|
40 | 35 | TABLE ACCESS BY INDEX ROWID | HZ_PARTIES | 1 | 40 | 1 (0)|
41 |* 36 | INDEX UNIQUE SCAN | HZ_PARTIES_U1 | 1 | | 0 (0)|
42 |* 37 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 36 | 2 (0)|
43 |* 38 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | 1 (0)|
44 | 39 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 13 | 2 (0)|
45 |* 40 | INDEX RANGE SCAN | RA_CUST_TRX_TYPES_U1 | 1 | | 1 (0)|
46 | 41 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | 2 (0)|
47 |* 42 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | 1 (0)|
48 |* 43 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_ALL | 1 | 43 | 2 (0)|
49 |* 44 | INDEX UNIQUE SCAN | RA_CUSTOMER_TRX_U1 | 1 | | 1 (0)|
50 | 45 | TABLE ACCESS BY INDEX ROWID | FND_DOCUMENT_SEQUENCES | 1 | 22 | 1 (0)|
51 |* 46 | INDEX UNIQUE SCAN | FND_DOCUMENT_SEQUENCES_U1 | 1 | | 0 (0)|
52 | 47 | TABLE ACCESS BY INDEX ROWID | RA_CUST_TRX_TYPES_ALL | 1 | 31 | 2 (0)|
53 |* 48 | INDEX RANGE SCAN | RA_CUST_TRX_TYPES_U1 | 1 | | 1 (0)|
54 | 49 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | 2 (0)|
55 |* 50 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | 1 (0)|
56 |* 51 | TABLE ACCESS BY INDEX ROWID | RA_CUSTOMER_TRX_LINES_ALL | 1 | 19 | 3 (0)|
57 |* 52 | INDEX RANGE SCAN | RA_CUSTOMER_TRX_LINES_U1 | 1 | | 2 (0)|
58 | 53 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 1 | 59 | 2 (0)|
59 |* 54 | INDEX UNIQUE SCAN | FND_LOOKUP_VALUES_U1 | 1 | | 1 (0)|

复制代码

回复只看该作者道具举报

张沛

5^#

发表于 2013-1-21 15:22:12

张沛发表于 2013-1-21 15:21
下半部分的执行计划

62 Predicate Information (identified by operation id):
63 ---------------------------------------------------
64
65 11 - filter(DECODE(TO_CHAR("ARD"."THIRD_PARTY_SUB_ID"),NULL,(-99),NVL("ARD"."ORG_ID",(-99)))=NVL("SU"."ORG_
66 ID",(-99)))
67 20 - access("LV"."LOOKUP_TYPE"='VIEW_ACCOUNTING' AND "LV"."VIEW_APPLICATION_ID"=222 AND
68 "LV"."LOOKUP_CODE"='APPLIED_TO' AND "LV"."SECURITY_GROUP_ID"=0 AND "LV"."LANGUAGE"=USERENV('LANG'))
69 22 - access("LV"."LOOKUP_TYPE"='YES/NO' AND "LV"."VIEW_APPLICATION_ID"=222 AND "LV"."SECURITY_GROUP_ID"=0
70 AND "LV"."LANGUAGE"=USERENV('LANG'))
71 filter("LV"."LANGUAGE"=USERENV('LANG') AND "LV"."SECURITY_GROUP_ID"=0)
72 23 - filter("RA"."APPLIED_CUSTOMER_TRX_ID" IS NOT NULL AND "RA"."APPLICATION_TYPE"='CM' AND
73 NVL("RA"."CONFIRMED_FLAG",'Y')='Y' AND NVL("RA"."POSTABLE",'Y')='Y' AND
74 "LV"."LOOKUP_CODE"=DECODE("RA"."POSTING_CONTROL_ID",(-3),'N','Y'))
75 24 - filter("RA"."CUSTOMER_TRX_ID" IS NOT NULL)
76 25 - filter(NVL("ARD"."ORG_ID",(-99))=NVL("RA"."ORG_ID",(-99)))
77 26 - access("ARD"."SOURCE_ID"="RA"."RECEIVABLE_APPLICATION_ID" AND "ARD"."SOURCE_TABLE"='RA')
78 28 - access("LV"."LOOKUP_TYPE"='DISTRIBUTION_SOURCE_TYPE' AND "LV"."VIEW_APPLICATION_ID"=222 AND
79 "LV"."LOOKUP_CODE"="ARD"."SOURCE_TYPE" AND "LV"."SECURITY_GROUP_ID"=0 AND "LV"."LANGUAGE"=USERENV('LANG'))
80 30 - access("GLCT"."CONVERSION_TYPE"(+)="ARD"."CURRENCY_CONVERSION_TYPE")
81 32 - access("ARD"."THIRD_PARTY_ID"="CUST_ACCT"."CUST_ACCOUNT_ID"(+))
82 34 - access("ARD"."THIRD_PARTY_SUB_ID"="SU"."SITE_USE_ID"(+))
83 36 - access("CUST_ACCT"."PARTY_ID"="PARTY"."PARTY_ID"(+))
84 37 - filter(NVL("CTINV"."ORG_ID",(-99))=NVL("RA"."ORG_ID",(-99)))
85 38 - access("CTINV"."CUSTOMER_TRX_ID"="RA"."APPLIED_CUSTOMER_TRX_ID")
86 40 - access("CTTCM2"."CUST_TRX_TYPE_ID"="CTINV"."CUST_TRX_TYPE_ID")
87 filter(NVL("CTTCM2"."ORG_ID",(-99))=NVL("CTINV"."ORG_ID",(-99)))
88 42 - access("LV"."LOOKUP_TYPE"='INV/CM' AND "LV"."VIEW_APPLICATION_ID"=222 AND
89 "LV"."LOOKUP_CODE"="CTTCM2"."TYPE" AND "LV"."SECURITY_GROUP_ID"=0 AND "LV"."LANGUAGE"=USERENV('LANG'))
90 43 - filter(NVL("RA"."ORG_ID",(-99))=NVL("CTCM"."ORG_ID",(-99)))
91 44 - access("RA"."CUSTOMER_TRX_ID"="CTCM"."CUSTOMER_TRX_ID")
92 46 - access("SEQ"."DOC_SEQUENCE_ID"(+)="CTCM"."DOC_SEQUENCE_ID")
93 48 - access("CTTCM"."CUST_TRX_TYPE_ID"="CTCM"."CUST_TRX_TYPE_ID")
94 filter(NVL("CTTCM"."ORG_ID",(-99))=NVL("CTCM"."ORG_ID",(-99)))
95 50 - access("LV"."LOOKUP_TYPE"='INV/CM' AND "LV"."VIEW_APPLICATION_ID"=222 AND
96 "LV"."LOOKUP_CODE"="CTTCM"."TYPE" AND "LV"."SECURITY_GROUP_ID"=0 AND "LV"."LANGUAGE"=USERENV('LANG'))
97 51 - filter(NVL("CTLINV"."ORG_ID"(+),(-99))=NVL("RA"."ORG_ID",(-99)))
98 52 - access("CTLINV"."CUSTOMER_TRX_LINE_ID"(+)="RA"."APPLIED_CUSTOMER_TRX_LINE_ID")
99 54 - access("LV"."LOOKUP_TYPE"(+)='STD_LINE_TYPE' AND "LV"."VIEW_APPLICATION_ID"(+)=222 AND
100 "LV"."LOOKUP_CODE"(+)="CTLINV"."LINE_TYPE" AND "LV"."SECURITY_GROUP_ID"(+)=0 AND
101 "LV"."LANGUAGE"(+)=USERENV('LANG'))
102
103 Note
104 -----
105 - 'PLAN_TABLE' is old version