求助：请求名“弹性域 PL/SQL 预先处理程序”是在做什么动作提交的请求啊

flying11102 · 发表于 2007/6/7 14:28:03

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ： 83569622 　。

您需要登录才可以下载或查看，没有帐号？注册

x

请求名“弹性域 PL/SQL 预先处理程序，弹性域视图生成器”是在做什么动作提交的请求啊，麻烦知道的帮忙告知一声，谢谢啊！

纵横四海 · 发表于 2007/6/7 14:42:35

切换到英文环境，把这个请求的英文名称贴出来。我帮你到metalink上去查查。
“弹性域 PL/SQL 预先处理程序，弹性域视图生成器”这个还真没有用到。

gaoyiming · 发表于 2007/6/7 15:41:44

好像是把弹性域生成为数据库项目，
生成了之后就可以直接在写程序或者编辑公式的时候引用相应的字段了

NosameVista · 发表于 2007/6/7 19:53:04

--请求名“弹性域 PL/SQL 预先处理程序，弹性域视图生成器”是在做什么动作提交的请求
运行时间：是在新建或者修改新建弹性域后，系统自动运行；当然自己也可以手动运行
目的：完善弹性域表数据库结构
过程:
--修改完弹性域内容后,保存,提示:
The flexfield was compiled successfully.
Submitted request to generate flexfield view ...

--点击OK
request form中可以看到Flexfield View Generator正在运行 --就是将扩展信息规则保存起来，并声称一个View视图供使用

--这样打开相应的扩展信息显示窗口
可以看到会根据填入的扩展上下文参数不同(Flexfield Context)，显示不同的扩展信息内容

flying11102 · 发表于 2007/6/7 22:15:10

谢谢NosameVista,纵横四海 ,gaoyiming
,感谢你们热情的解答，thank you very much !

纵横四海 · 发表于 2008/2/10 12:47:28

弹性域 PL/SQL 预先处理程序　的英文名称是：Flexfield PL/SQL Pre-Processor

我发现我的环境中也莫名其妙的被运行了一次，以下是运行后的输出文件：

编码的PL/SQL预处理器参数:-
开始扩展标志
扩展文件: /u01/oracle/app/prodappl/ar/11.5.0/sql/ARFXVIEW.txt
扩展标志: &AR_OVERRIDE_SEGMENT
扩展标志: &AR_ALL_SEGMENT_VALUES
扩展标志: &AR_VALUE_SEGMENT_IDS
扩展标志: &AR_ALL_END_DATES
扩展标志: &AR_ALL_FROM_POSTALS
扩展标志: &AR_ALL_START_DATES
扩展标志: &AR_EACH_LOCATION_RATE
扩展标志: &AR_ALL_TAX_RATES
扩展标志: &AR_ALL_TO_POSTALS
扩展标志: &AR_LOCATION_RATE_TABLES
扩展标志: &AR_FROM_POSTAL_CONDITION
扩展标志: &AR_TO_POSTAL_CONDITION
扩展标志: &AR_START_DATE_CONDITION
扩展标志: &AR_END_DATE_CONDITION
扩展标志: &AR_SEGMENT_ID_EQUALS_PARAMS
扩展标志: &AR_SUM_ALL_TAX_RATES
扩展标志: &AR_TAX_RATE_EQUALS_TABLES
扩展标志: &AR_ANY_SEGMENT_EQUALS_ID
扩展标志: &AR_CCIDS_EQUALS_PARAMS
扩展标志: &AR_ACTIVE_SEGMENTS_EQUAL_VALUES
扩展标志: &AR_PARENT_LOC_IDS_EQUALS_ID
扩展标志: &AR_NAME_EACH_LOCATION
扩展标志: &AR_LOCATION_STRUCTURE_ID
扩展标志: &AR_FIND_EACH_SEGMENT
扩展标志: &AR_POPULATE_PARENT
扩展标志: &AR_INVALID_SEGMENTS
扩展标志: &AR_ACTIVE_LOC_IDS
扩展标志: &AR_ALL_SEGMENT_QUALIFIERS
扩展标志: &AR_FIRST_SEGMENT_QUALIFIER
扩展标志: &AR_LAST_SEGMENT_QUALIFIER
扩展标志: &AR_TAX_ACCOUNT_SEGMENT
扩展标志: &AR_CCID_EQUALS_LOCATION_ID
扩展标志: &AR_TAX_EXEMPT_CHK_LOC_IDS
扩展标志: &AR_TAX_EXEMPT_JOIN_VALUES
扩展标志: &AR_DIS_LOCATIONS_ALLBUTLAST_DF
扩展标志: &AR_DIS_LOCATIONS_LAST_DF
扩展标志: &AR_EXEMPTION_LEVEL_OPEN
扩展标志: &AR_EXEMPTION_LEVEL_CLOSE
扩展标志: &AR_ALL_LOCATION_QUALIFIERS
“扩展标志完成”
REM --------------------------------------------------------------------
REM Begin expansion for Org ID = 161
REM --------------------------------------------------------------------
/*===========================================================================+
| $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ |
*===========================================================================+
+===========================================================================+
| |
| FILENAME |
| |
| ARFVIEW.fxp Flexfield pre-processed views |
| |
| DESCRIPTION |
| |
| This file creates database views that need to be pre-processed |
| using the AR Flexfield PL/SQL Pre-processor. |
| |
| IMPORTANT : VERSION INFO |
| This file has been changed completely to incorporate Multi-Org changes |
| in Rel 10.7. Ensure that bugfixes are for both 10.6 and 10.7 and to the|
| right version as version nos. are "leap froged" for 10.6 and 10.7. |
| |
| Release 10.4, 10.5 and 10.6, LATEST version is 70.12 |
| |
| Release 10.7, the latest version is |
| |
| VIEWS CREATED |
| |
| TAX_EXEMPTIONS_QP_V |
| |
| This view lists all exemptions for a given BILL TO CUSTOMER and |
| SHIP TO SITE. Since an exemption can be at one or more levels, all |
| applicable exemptions are listed on the quickpick and the user is |
| allowed to select from any of the candidates. |
| |
| MODIFICATION HISTORY |
| 17 MAY, 1994 Nigel Smith Created |
| 2 Aug, 1994 Nigel Smith Bugfix: 228807, Customer exemptions are now |
| managed by Bill To Customer; New column |
| BILL_TO_CUSTOMER_ID has been implemented for |
| Release 10.4; column SHIP_TO_CUSTOMER_ID |
| will be dropped at Release 10.5 |
| 12 Oct, 1994 Nigel Smith Bugfix: 232727, Tax Exemptions QP View fails |
| when system installs just one segment in |
| sales tax location flexfield. |
| Bugfix: 237413, Exemptions that had NO |
| Certificate Number did not appear in the |
| Order Entry Quick pick. |
| Lookups are outer joinded; in case any |
| receivable quickcodes are deleted. |
| 11 Sep, 1995 Mahesh S. Bugfix: 305029, Concurrent request to rebuild|
| Tax packages fails. |
| |
| 18-Mar-2002 Satya, Ahmed Bug 2265200 |
| 29-Oct-2002 D. Jancis Removed reference to ra site_uses and |
| replaced with hz_cust_site_uses. |
+===========================================================================*/
REM dbdrv: none
SET VERIFY OFF
WHENEVER SQLERROR CONTINUE;
/*--------------------------------------------------------------------------+
| Bugfix: 305029 |
| In a Multi-Org install, a synonym to the tax view referencing the |
| APPS Schema will exist, drop the synonym and create the view. |
+--------------------------------------------------------------------------*/
drop synonym TAX_EXEMPTIONS_QP_V;
create or replace force view TAX_EXEMPTIONS_QP_V as
&START_VIEW_BODY
select
/* $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ */
s.site_use_id SHIP_TO_SITE_USE_ID,
a.cust_account_id SHIP_TO_CUSTOMER_ID,
x.customer_id BILL_TO_CUSTOMER_ID,
x.site_use_id EXEMPTION_SHIP_TO_SITE_USE_ID,
NULL ||
v1.location_segment_user_value
LOCATION,
decode(x.customer_exemption_number,
null, ' ',
x.customer_exemption_number)
TAX_EXEMPT_NUMBER,
x.reason_code TAX_EXEMPT_REASON_CODE,
nvl(arl.meaning,x.reason_code)
TAX_EXEMPT_REASON_MEANING,
x.percent_exempt PERCENT_EXEMPT,
x.status STATUS_CODE,
nvl(ars.meaning,
x.status) STATUS_MEANING,
x.start_date START_DATE,
x.end_date END_DATE,
x.tax_exemption_id TAX_EXEMPTION_ID,
decode( x.site_use_id, null,
decode(x.location_id_segment_1, null,
11, 1), 0 )
+decode( x.status, 'PRIMARY', 0,
'MANUAL', 1000,
'UNAPPROVED', 2000,
'EXPIRED', 3000, 4000 )
DISPLAY_ORDER,
x.tax_code TAX_CODE
from
hz_cust_site_uses s,
hz_cust_acct_sites_all a,
hz_party_sites p,
hz_loc_assignments la,
ra_tax_exemptions x,
ar_lookups ars,
ar_lookups arl,
ar_location_combinations c,
ar_location_values v1,
ar_system_parameters sys
where la.loc_id = c.location_id(+)
and a.party_site_id = p.party_site_id
and p.location_id = la.location_id
and nvl(a.org_id,-99) = nvl(la.org_id,-99)
and s.cust_acct_site_id = a.cust_acct_site_id
and nvl(a.org_id,nvl(to_number(decode
(substrb(userenv('CLIENT_INFO'),1,1), ' ' ,NULL,
substrb(userenv('CLIENT_INFO'),1,10))),-99)) =
nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),
' ',NULL,substrb(userenv('CLIENT_INFO'),1,10))),-99)
and nvl(x.location_id_segment_1, nvl(c.location_id_segment_1,-1)) = nvl(c.location_id_segment_1,-1)
and v1.location_segment_id(+) = x.location_id_segment_1
and arl.lookup_type(+) = 'TAX_REASON'
and arl.lookup_code(+) = x.reason_code
and ars.lookup_type = 'TAX_EXEMPT_STATUS'
and ars.lookup_code = x.status
and x.exemption_type = 'CUSTOMER'
and nvl( x.site_use_id, s.site_use_id ) = s.site_use_id
&END_VIEW_BODY
/
commit;
exit;
REM --------------------------------------------------------------------
REM End expansion for Org ID = 161
REM --------------------------------------------------------------------
文件完成的扩展
扩展标志: &AR_OVERRIDE_SEGMENT
扩展标志: &AR_ALL_SEGMENT_VALUES
扩展标志: &AR_VALUE_SEGMENT_IDS
扩展标志: &AR_ALL_END_DATES
扩展标志: &AR_ALL_FROM_POSTALS
扩展标志: &AR_ALL_START_DATES
扩展标志: &AR_EACH_LOCATION_RATE
扩展标志: &AR_ALL_TAX_RATES
扩展标志: &AR_ALL_TO_POSTALS
扩展标志: &AR_LOCATION_RATE_TABLES
扩展标志: &AR_FROM_POSTAL_CONDITION
扩展标志: &AR_TO_POSTAL_CONDITION
扩展标志: &AR_START_DATE_CONDITION
扩展标志: &AR_END_DATE_CONDITION
扩展标志: &AR_SEGMENT_ID_EQUALS_PARAMS
扩展标志: &AR_SUM_ALL_TAX_RATES
扩展标志: &AR_TAX_RATE_EQUALS_TABLES
扩展标志: &AR_ANY_SEGMENT_EQUALS_ID
扩展标志: &AR_CCIDS_EQUALS_PARAMS
扩展标志: &AR_ACTIVE_SEGMENTS_EQUAL_VALUES
扩展标志: &AR_PARENT_LOC_IDS_EQUALS_ID
扩展标志: &AR_NAME_EACH_LOCATION
扩展标志: &AR_LOCATION_STRUCTURE_ID
扩展标志: &AR_FIND_EACH_SEGMENT
扩展标志: &AR_POPULATE_PARENT
扩展标志: &AR_INVALID_SEGMENTS
扩展标志: &AR_ACTIVE_LOC_IDS
扩展标志: &AR_ALL_SEGMENT_QUALIFIERS
扩展标志: &AR_FIRST_SEGMENT_QUALIFIER
扩展标志: &AR_LAST_SEGMENT_QUALIFIER
扩展标志: &AR_TAX_ACCOUNT_SEGMENT
扩展标志: &AR_CCID_EQUALS_LOCATION_ID
扩展标志: &AR_TAX_EXEMPT_CHK_LOC_IDS
扩展标志: &AR_TAX_EXEMPT_JOIN_VALUES
扩展标志: &AR_DIS_LOCATIONS_ALLBUTLAST_DF
扩展标志: &AR_DIS_LOCATIONS_LAST_DF
扩展标志: &AR_EXEMPTION_LEVEL_OPEN
扩展标志: &AR_EXEMPTION_LEVEL_CLOSE
扩展标志: &AR_ALL_LOCATION_QUALIFIERS
“扩展标志完成”
REM --------------------------------------------------------------------
REM Begin expansion for Org ID = 101
REM --------------------------------------------------------------------
/*===========================================================================+
| $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ |
*===========================================================================+
+===========================================================================+
| |
| FILENAME |
| |
| ARFVIEW.fxp Flexfield pre-processed views |
| |
| DESCRIPTION |
| |
| This file creates database views that need to be pre-processed |
| using the AR Flexfield PL/SQL Pre-processor. |
| |
| IMPORTANT : VERSION INFO |
| This file has been changed completely to incorporate Multi-Org changes |
| in Rel 10.7. Ensure that bugfixes are for both 10.6 and 10.7 and to the|
| right version as version nos. are "leap froged" for 10.6 and 10.7. |
| |
| Release 10.4, 10.5 and 10.6, LATEST version is 70.12 |
| |
| Release 10.7, the latest version is |
| |
| VIEWS CREATED |
| |
| TAX_EXEMPTIONS_QP_V |
| |
| This view lists all exemptions for a given BILL TO CUSTOMER and |
| SHIP TO SITE. Since an exemption can be at one or more levels, all |
| applicable exemptions are listed on the quickpick and the user is |
| allowed to select from any of the candidates. |
| |
| MODIFICATION HISTORY |
| 17 MAY, 1994 Nigel Smith Created |
| 2 Aug, 1994 Nigel Smith Bugfix: 228807, Customer exemptions are now |
| managed by Bill To Customer; New column |
| BILL_TO_CUSTOMER_ID has been implemented for |
| Release 10.4; column SHIP_TO_CUSTOMER_ID |
| will be dropped at Release 10.5 |
| 12 Oct, 1994 Nigel Smith Bugfix: 232727, Tax Exemptions QP View fails |
| when system installs just one segment in |
| sales tax location flexfield. |
| Bugfix: 237413, Exemptions that had NO |
| Certificate Number did not appear in the |
| Order Entry Quick pick. |
| Lookups are outer joinded; in case any |
| receivable quickcodes are deleted. |
| 11 Sep, 1995 Mahesh S. Bugfix: 305029, Concurrent request to rebuild|
| Tax packages fails. |
| |
| 18-Mar-2002 Satya, Ahmed Bug 2265200 |
| 29-Oct-2002 D. Jancis Removed reference to ra site_uses and |
| replaced with hz_cust_site_uses. |
+===========================================================================*/
REM dbdrv: none
SET VERIFY OFF
WHENEVER SQLERROR CONTINUE;
/*--------------------------------------------------------------------------+
| Bugfix: 305029 |
| In a Multi-Org install, a synonym to the tax view referencing the |
| APPS Schema will exist, drop the synonym and create the view. |
+--------------------------------------------------------------------------*/
drop synonym TAX_EXEMPTIONS_QP_V;
create or replace force view TAX_EXEMPTIONS_QP_V as
&START_VIEW_BODY
select
/* $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ */
s.site_use_id SHIP_TO_SITE_USE_ID,
a.cust_account_id SHIP_TO_CUSTOMER_ID,
x.customer_id BILL_TO_CUSTOMER_ID,
x.site_use_id EXEMPTION_SHIP_TO_SITE_USE_ID,
v1.location_segment_user_value || decode ( v2.location_segment_user_value, NULL, NULL, '.' ) ||
v2.location_segment_user_value || decode ( v3.location_segment_user_value, NULL, NULL, '.' ) ||
v3.location_segment_user_value
LOCATION,
decode(x.customer_exemption_number,
null, ' ',
x.customer_exemption_number)
TAX_EXEMPT_NUMBER,
x.reason_code TAX_EXEMPT_REASON_CODE,
nvl(arl.meaning,x.reason_code)
TAX_EXEMPT_REASON_MEANING,
x.percent_exempt PERCENT_EXEMPT,
x.status STATUS_CODE,
nvl(ars.meaning,
x.status) STATUS_MEANING,
x.start_date START_DATE,
x.end_date END_DATE,
x.tax_exemption_id TAX_EXEMPTION_ID,
decode( x.site_use_id, null,
decode(x.location_id_segment_3, null,
decode(x.location_id_segment_2, null,
decode(x.location_id_segment_1, null,
11, 3), 2), 1), 0 )
+decode( x.status, 'PRIMARY', 0,
'MANUAL', 1000,
'UNAPPROVED', 2000,
'EXPIRED', 3000, 4000 )
DISPLAY_ORDER,
x.tax_code TAX_CODE
from
hz_cust_site_uses s,
hz_cust_acct_sites_all a,
hz_party_sites p,
hz_loc_assignments la,
ra_tax_exemptions x,
ar_lookups ars,
ar_lookups arl,
ar_location_combinations c,
ar_location_values v1,
ar_location_values v2,
ar_location_values v3,
ar_system_parameters sys
where la.loc_id = c.location_id(+)
and a.party_site_id = p.party_site_id
and p.location_id = la.location_id
and nvl(a.org_id,-99) = nvl(la.org_id,-99)
and s.cust_acct_site_id = a.cust_acct_site_id
and nvl(a.org_id,nvl(to_number(decode
(substrb(userenv('CLIENT_INFO'),1,1), ' ' ,NULL,
substrb(userenv('CLIENT_INFO'),1,10))),-99)) =
nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),
' ',NULL,substrb(userenv('CLIENT_INFO'),1,10))),-99)
and nvl(x.location_id_segment_1, nvl(c.location_id_segment_1,-1)) = nvl(c.location_id_segment_1,-1)
and nvl(x.location_id_segment_2, nvl(c.location_id_segment_2,-1)) = nvl(c.location_id_segment_2,-1)
and nvl(x.location_id_segment_3, nvl(c.location_id_segment_3,-1)) = nvl(c.location_id_segment_3,-1)
and v1.location_segment_id(+) = x.location_id_segment_1
and v2.location_segment_id(+) = x.location_id_segment_2
and v3.location_segment_id(+) = x.location_id_segment_3
and arl.lookup_type(+) = 'TAX_REASON'
and arl.lookup_code(+) = x.reason_code
and ars.lookup_type = 'TAX_EXEMPT_STATUS'
and ars.lookup_code = x.status
and x.exemption_type = 'CUSTOMER'
and nvl( x.site_use_id, s.site_use_id ) = s.site_use_id
&END_VIEW_BODY
/
commit;
exit;
REM --------------------------------------------------------------------
REM End expansion for Org ID = 101
REM --------------------------------------------------------------------
文件完成的扩展
扩展标志: &AR_OVERRIDE_SEGMENT
扩展标志: &AR_ALL_SEGMENT_VALUES
扩展标志: &AR_VALUE_SEGMENT_IDS
扩展标志: &AR_ALL_END_DATES
扩展标志: &AR_ALL_FROM_POSTALS
扩展标志: &AR_ALL_START_DATES
扩展标志: &AR_EACH_LOCATION_RATE
扩展标志: &AR_ALL_TAX_RATES
扩展标志: &AR_ALL_TO_POSTALS
扩展标志: &AR_LOCATION_RATE_TABLES
扩展标志: &AR_FROM_POSTAL_CONDITION
扩展标志: &AR_TO_POSTAL_CONDITION
扩展标志: &AR_START_DATE_CONDITION
扩展标志: &AR_END_DATE_CONDITION
扩展标志: &AR_SEGMENT_ID_EQUALS_PARAMS
扩展标志: &AR_SUM_ALL_TAX_RATES
扩展标志: &AR_TAX_RATE_EQUALS_TABLES
扩展标志: &AR_ANY_SEGMENT_EQUALS_ID
扩展标志: &AR_CCIDS_EQUALS_PARAMS
扩展标志: &AR_ACTIVE_SEGMENTS_EQUAL_VALUES
扩展标志: &AR_PARENT_LOC_IDS_EQUALS_ID
扩展标志: &AR_NAME_EACH_LOCATION
扩展标志: &AR_LOCATION_STRUCTURE_ID
扩展标志: &AR_FIND_EACH_SEGMENT
扩展标志: &AR_POPULATE_PARENT
扩展标志: &AR_INVALID_SEGMENTS
扩展标志: &AR_ACTIVE_LOC_IDS
扩展标志: &AR_ALL_SEGMENT_QUALIFIERS
扩展标志: &AR_FIRST_SEGMENT_QUALIFIER
扩展标志: &AR_LAST_SEGMENT_QUALIFIER
扩展标志: &AR_TAX_ACCOUNT_SEGMENT
扩展标志: &AR_CCID_EQUALS_LOCATION_ID
扩展标志: &AR_TAX_EXEMPT_CHK_LOC_IDS
扩展标志: &AR_TAX_EXEMPT_JOIN_VALUES
扩展标志: &AR_DIS_LOCATIONS_ALLBUTLAST_DF
扩展标志: &AR_DIS_LOCATIONS_LAST_DF
扩展标志: &AR_EXEMPTION_LEVEL_OPEN
扩展标志: &AR_EXEMPTION_LEVEL_CLOSE
扩展标志: &AR_ALL_LOCATION_QUALIFIERS
“扩展标志完成”
REM --------------------------------------------------------------------
REM Begin expansion for Org ID = 141
REM --------------------------------------------------------------------
/*===========================================================================+
| $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ |
*===========================================================================+
+===========================================================================+
| |
| FILENAME |
| |
| ARFVIEW.fxp Flexfield pre-processed views |
| |
| DESCRIPTION |
| |
| This file creates database views that need to be pre-processed |
| using the AR Flexfield PL/SQL Pre-processor. |
| |
| IMPORTANT : VERSION INFO |
| This file has been changed completely to incorporate Multi-Org changes |
| in Rel 10.7. Ensure that bugfixes are for both 10.6 and 10.7 and to the|
| right version as version nos. are "leap froged" for 10.6 and 10.7. |
| |
| Release 10.4, 10.5 and 10.6, LATEST version is 70.12 |
| |
| Release 10.7, the latest version is |
| |
| VIEWS CREATED |
| |
| TAX_EXEMPTIONS_QP_V |
| |
| This view lists all exemptions for a given BILL TO CUSTOMER and |
| SHIP TO SITE. Since an exemption can be at one or more levels, all |
| applicable exemptions are listed on the quickpick and the user is |
| allowed to select from any of the candidates. |
| |
| MODIFICATION HISTORY |
| 17 MAY, 1994 Nigel Smith Created |
| 2 Aug, 1994 Nigel Smith Bugfix: 228807, Customer exemptions are now |
| managed by Bill To Customer; New column |
| BILL_TO_CUSTOMER_ID has been implemented for |
| Release 10.4; column SHIP_TO_CUSTOMER_ID |
| will be dropped at Release 10.5 |
| 12 Oct, 1994 Nigel Smith Bugfix: 232727, Tax Exemptions QP View fails |
| when system installs just one segment in |
| sales tax location flexfield. |
| Bugfix: 237413, Exemptions that had NO |
| Certificate Number did not appear in the |
| Order Entry Quick pick. |
| Lookups are outer joinded; in case any |
| receivable quickcodes are deleted. |
| 11 Sep, 1995 Mahesh S. Bugfix: 305029, Concurrent request to rebuild|
| Tax packages fails. |
| |
| 18-Mar-2002 Satya, Ahmed Bug 2265200 |
| 29-Oct-2002 D. Jancis Removed reference to ra site_uses and |
| replaced with hz_cust_site_uses. |
+===========================================================================*/
REM dbdrv: none
SET VERIFY OFF
WHENEVER SQLERROR CONTINUE;
/*--------------------------------------------------------------------------+
| Bugfix: 305029 |
| In a Multi-Org install, a synonym to the tax view referencing the |
| APPS Schema will exist, drop the synonym and create the view. |
+--------------------------------------------------------------------------*/
drop synonym TAX_EXEMPTIONS_QP_V;
create or replace force view TAX_EXEMPTIONS_QP_V as
&START_VIEW_BODY
select
/* $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ */
s.site_use_id SHIP_TO_SITE_USE_ID,
a.cust_account_id SHIP_TO_CUSTOMER_ID,
x.customer_id BILL_TO_CUSTOMER_ID,
x.site_use_id EXEMPTION_SHIP_TO_SITE_USE_ID,
v1.location_segment_user_value || decode ( v2.location_segment_user_value, NULL, NULL, '.' ) ||
v2.location_segment_user_value || decode ( v3.location_segment_user_value, NULL, NULL, '.' ) ||
v3.location_segment_user_value
LOCATION,
decode(x.customer_exemption_number,
null, ' ',
x.customer_exemption_number)
TAX_EXEMPT_NUMBER,
x.reason_code TAX_EXEMPT_REASON_CODE,
nvl(arl.meaning,x.reason_code)
TAX_EXEMPT_REASON_MEANING,
x.percent_exempt PERCENT_EXEMPT,
x.status STATUS_CODE,
nvl(ars.meaning,
x.status) STATUS_MEANING,
x.start_date START_DATE,
x.end_date END_DATE,
x.tax_exemption_id TAX_EXEMPTION_ID,
decode( x.site_use_id, null,
decode(x.location_id_segment_3, null,
decode(x.location_id_segment_2, null,
decode(x.location_id_segment_1, null,
11, 3), 2), 1), 0 )
+decode( x.status, 'PRIMARY', 0,
'MANUAL', 1000,
'UNAPPROVED', 2000,
'EXPIRED', 3000, 4000 )
DISPLAY_ORDER,
x.tax_code TAX_CODE
from
hz_cust_site_uses s,
hz_cust_acct_sites_all a,
hz_party_sites p,
hz_loc_assignments la,
ra_tax_exemptions x,
ar_lookups ars,
ar_lookups arl,
ar_location_combinations c,
ar_location_values v1,
ar_location_values v2,
ar_location_values v3,
ar_system_parameters sys
where la.loc_id = c.location_id(+)
and a.party_site_id = p.party_site_id
and p.location_id = la.location_id
and nvl(a.org_id,-99) = nvl(la.org_id,-99)
and s.cust_acct_site_id = a.cust_acct_site_id
and nvl(a.org_id,nvl(to_number(decode
(substrb(userenv('CLIENT_INFO'),1,1), ' ' ,NULL,
substrb(userenv('CLIENT_INFO'),1,10))),-99)) =
nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),
' ',NULL,substrb(userenv('CLIENT_INFO'),1,10))),-99)
and nvl(x.location_id_segment_1, nvl(c.location_id_segment_1,-1)) = nvl(c.location_id_segment_1,-1)
and nvl(x.location_id_segment_2, nvl(c.location_id_segment_2,-1)) = nvl(c.location_id_segment_2,-1)
and nvl(x.location_id_segment_3, nvl(c.location_id_segment_3,-1)) = nvl(c.location_id_segment_3,-1)
and v1.location_segment_id(+) = x.location_id_segment_1
and v2.location_segment_id(+) = x.location_id_segment_2
and v3.location_segment_id(+) = x.location_id_segment_3
and arl.lookup_type(+) = 'TAX_REASON'
and arl.lookup_code(+) = x.reason_code
and ars.lookup_type = 'TAX_EXEMPT_STATUS'
and ars.lookup_code = x.status
and x.exemption_type = 'CUSTOMER'
and nvl( x.site_use_id, s.site_use_id ) = s.site_use_id
&END_VIEW_BODY
/
commit;
exit;
REM --------------------------------------------------------------------
REM End expansion for Org ID = 141
REM --------------------------------------------------------------------
文件完成的扩展
扩展标志: &AR_OVERRIDE_SEGMENT
扩展标志: &AR_ALL_SEGMENT_VALUES
扩展标志: &AR_VALUE_SEGMENT_IDS
扩展标志: &AR_ALL_END_DATES
扩展标志: &AR_ALL_FROM_POSTALS
扩展标志: &AR_ALL_START_DATES
扩展标志: &AR_EACH_LOCATION_RATE
扩展标志: &AR_ALL_TAX_RATES
扩展标志: &AR_ALL_TO_POSTALS
扩展标志: &AR_LOCATION_RATE_TABLES
扩展标志: &AR_FROM_POSTAL_CONDITION
扩展标志: &AR_TO_POSTAL_CONDITION
扩展标志: &AR_START_DATE_CONDITION
扩展标志: &AR_END_DATE_CONDITION
扩展标志: &AR_SEGMENT_ID_EQUALS_PARAMS
扩展标志: &AR_SUM_ALL_TAX_RATES
扩展标志: &AR_TAX_RATE_EQUALS_TABLES
扩展标志: &AR_ANY_SEGMENT_EQUALS_ID
扩展标志: &AR_CCIDS_EQUALS_PARAMS
扩展标志: &AR_ACTIVE_SEGMENTS_EQUAL_VALUES
扩展标志: &AR_PARENT_LOC_IDS_EQUALS_ID
扩展标志: &AR_NAME_EACH_LOCATION
扩展标志: &AR_LOCATION_STRUCTURE_ID
扩展标志: &AR_FIND_EACH_SEGMENT
扩展标志: &AR_POPULATE_PARENT
扩展标志: &AR_INVALID_SEGMENTS
扩展标志: &AR_ACTIVE_LOC_IDS
扩展标志: &AR_ALL_SEGMENT_QUALIFIERS
扩展标志: &AR_FIRST_SEGMENT_QUALIFIER
扩展标志: &AR_LAST_SEGMENT_QUALIFIER
扩展标志: &AR_TAX_ACCOUNT_SEGMENT
扩展标志: &AR_CCID_EQUALS_LOCATION_ID
扩展标志: &AR_TAX_EXEMPT_CHK_LOC_IDS
扩展标志: &AR_TAX_EXEMPT_JOIN_VALUES
扩展标志: &AR_DIS_LOCATIONS_ALLBUTLAST_DF
扩展标志: &AR_DIS_LOCATIONS_LAST_DF
扩展标志: &AR_EXEMPTION_LEVEL_OPEN
扩展标志: &AR_EXEMPTION_LEVEL_CLOSE
扩展标志: &AR_ALL_LOCATION_QUALIFIERS
“扩展标志完成”
REM --------------------------------------------------------------------
REM Begin expansion for Org ID = 121
REM --------------------------------------------------------------------
/*===========================================================================+
| $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ |
*===========================================================================+
+===========================================================================+
| |
| FILENAME |
| |
| ARFVIEW.fxp Flexfield pre-processed views |
| |
| DESCRIPTION |
| |
| This file creates database views that need to be pre-processed |
| using the AR Flexfield PL/SQL Pre-processor. |
| |
| IMPORTANT : VERSION INFO |
| This file has been changed completely to incorporate Multi-Org changes |
| in Rel 10.7. Ensure that bugfixes are for both 10.6 and 10.7 and to the|
| right version as version nos. are "leap froged" for 10.6 and 10.7. |
| |
| Release 10.4, 10.5 and 10.6, LATEST version is 70.12 |
| |
| Release 10.7, the latest version is |
| |
| VIEWS CREATED |
| |
| TAX_EXEMPTIONS_QP_V |
| |
| This view lists all exemptions for a given BILL TO CUSTOMER and |
| SHIP TO SITE. Since an exemption can be at one or more levels, all |
| applicable exemptions are listed on the quickpick and the user is |
| allowed to select from any of the candidates. |
| |
| MODIFICATION HISTORY |
| 17 MAY, 1994 Nigel Smith Created |
| 2 Aug, 1994 Nigel Smith Bugfix: 228807, Customer exemptions are now |
| managed by Bill To Customer; New column |
| BILL_TO_CUSTOMER_ID has been implemented for |
| Release 10.4; column SHIP_TO_CUSTOMER_ID |
| will be dropped at Release 10.5 |
| 12 Oct, 1994 Nigel Smith Bugfix: 232727, Tax Exemptions QP View fails |
| when system installs just one segment in |
| sales tax location flexfield. |
| Bugfix: 237413, Exemptions that had NO |
| Certificate Number did not appear in the |
| Order Entry Quick pick. |
| Lookups are outer joinded; in case any |
| receivable quickcodes are deleted. |
| 11 Sep, 1995 Mahesh S. Bugfix: 305029, Concurrent request to rebuild|
| Tax packages fails. |
| |
| 18-Mar-2002 Satya, Ahmed Bug 2265200 |
| 29-Oct-2002 D. Jancis Removed reference to ra site_uses and |
| replaced with hz_cust_site_uses. |
+===========================================================================*/
REM dbdrv: none
SET VERIFY OFF
WHENEVER SQLERROR CONTINUE;
/*--------------------------------------------------------------------------+
| Bugfix: 305029 |
| In a Multi-Org install, a synonym to the tax view referencing the |
| APPS Schema will exist, drop the synonym and create the view. |
+--------------------------------------------------------------------------*/
drop synonym TAX_EXEMPTIONS_QP_V;
create or replace force view TAX_EXEMPTIONS_QP_V as
&START_VIEW_BODY
select
/* $Header: ARFXVIEW.txt 115.1 2002/10/29 15:50:19 djancis noship $ */
s.site_use_id SHIP_TO_SITE_USE_ID,
a.cust_account_id SHIP_TO_CUSTOMER_ID,
x.customer_id BILL_TO_CUSTOMER_ID,
x.site_use_id EXEMPTION_SHIP_TO_SITE_USE_ID,
v1.location_segment_user_value || decode ( v2.location_segment_user_value, NULL, NULL, '.' ) ||
v2.location_segment_user_value || decode ( v3.location_segment_user_value, NULL, NULL, '.' ) ||
v3.location_segment_user_value
LOCATION,
decode(x.customer_exemption_number,
null, ' ',
x.customer_exemption_number)
TAX_EXEMPT_NUMBER,
x.reason_code TAX_EXEMPT_REASON_CODE,
nvl(arl.meaning,x.reason_code)
TAX_EXEMPT_REASON_MEANING,
x.percent_exempt PERCENT_EXEMPT,
x.status STATUS_CODE,
nvl(ars.meaning,
x.status) STATUS_MEANING,
x.start_date START_DATE,
x.end_date END_DATE,
x.tax_exemption_id TAX_EXEMPTION_ID,
decode( x.site_use_id, null,
decode(x.location_id_segment_3, null,
decode(x.location_id_segment_2, null,
decode(x.location_id_segment_1, null,
11, 3), 2), 1), 0 )
+decode( x.status, 'PRIMARY', 0,
'MANUAL', 1000,
'UNAPPROVED', 2000,
'EXPIRED', 3000, 4000 )
DISPLAY_ORDER,
x.tax_code TAX_CODE
from
hz_cust_site_uses s,
hz_cust_acct_sites_all a,
hz_party_sites p,
hz_loc_assignments la,
ra_tax_exemptions x,
ar_lookups ars,
ar_lookups arl,
ar_location_combinations c,
ar_location_values v1,
ar_location_values v2,
ar_location_values v3,
ar_system_parameters sys
where la.loc_id = c.location_id(+)
and a.party_site_id = p.party_site_id
and p.location_id = la.location_id
and nvl(a.org_id,-99) = nvl(la.org_id,-99)
and s.cust_acct_site_id = a.cust_acct_site_id
and nvl(a.org_id,nvl(to_number(decode
(substrb(userenv('CLIENT_INFO'),1,1), ' ' ,NULL,
substrb(userenv('CLIENT_INFO'),1,10))),-99)) =
nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),
' ',NULL,substrb(userenv('CLIENT_INFO'),1,10))),-99)
and nvl(x.location_id_segment_1, nvl(c.location_id_segment_1,-1)) = nvl(c.location_id_segment_1,-1)
and nvl(x.location_id_segment_2, nvl(c.location_id_segment_2,-1)) = nvl(c.location_id_segment_2,-1)
and nvl(x.location_id_segment_3, nvl(c.location_id_segment_3,-1)) = nvl(c.location_id_segment_3,-1)
and v1.location_segment_id(+) = x.location_id_segment_1
and v2.location_segment_id(+) = x.location_id_segment_2
and v3.location_segment_id(+) = x.location_id_segment_3
and arl.lookup_type(+) = 'TAX_REASON'
and arl.lookup_code(+) = x.reason_code
and ars.lookup_type = 'TAX_EXEMPT_STATUS'
and ars.lookup_code = x.status
and x.exemption_type = 'CUSTOMER'
and nvl( x.site_use_id, s.site_use_id ) = s.site_use_id
&END_VIEW_BODY
/
commit;
exit;
REM --------------------------------------------------------------------
REM End expansion for Org ID = 121
REM --------------------------------------------------------------------
文件完成的扩展
运行文件: /u01/oracle/app/prodcomn/temp/OFEbNGeM.t
扩展完成没有任何错误

复制代码

帐号		自动登录	找回密码
密码			注册

社区人物壹佰网重点话题	分享知识原创连载活动正式启动已有673人参加查看全部会员靓照旅行分享文学连载	壹佰读书会开始招收成员了
招聘求职壹佰网信息化选型平台	倾听用户的心声纵横四海谈IT如何提升企业管理管理小说连载《苏州桥》	如何获取努力值
原创连载－我来管管看 ERP分享+	推荐连载：[已结帖][分享知识原创连载]财务供应链项目新手实施手记：记录自己正	入门学习-致所有初学者

求助：请求名“弹性域 PL/SQL 预先处理程序”是在做什么动作提交的请求啊

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ： 83569622 。

浏览过的版块

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ： 83569622 　。