在oracle创建一个联系人表,Oracle EBS R12 客户表结构

R12 客户表结构

客户表/联系人/PARTY关联

HZ_PARTIES

客户账户表

HZ_CUST_ACCOUNTS

例子：

SELECT hp.party_number --客户注册标识

, hp.party_name --组织名/客户

, hp.known_as --别名

, http://www.doczj.com/doc/7ab51efcf705cc1755270962.htmlanization_name_phonetic --名称拼音

, acc.account_number --帐号

, flv_sale.meaning sales_channel_code --销售渠道

, acc.account_name --账记说明

, flv_customer.meaning customer_class_code --分类

, acc.orig_system_reference --参考

, flv_status.meaning status --状态

, flv_type.meaning customer_type --账户类型

, acc.attribute_category --上下文

, acc.attribute1 --注册

, acc.attribute2 --人员推广

, acc.attribute3 --特殊要求

, acc.Attribute4 --发货单是否打印价格

, acc.Attribute5 --所属利润

FROM hz_parties hp

, hz_cust_accounts acc

, fnd_lookup_values flv_sale --销售渠道

, fnd_lookup_values flv_customer --分类

, fnd_lookup_values flv_status --状态

, fnd_lookup_values flv_type --账户类型

WHERE hp.party_id = acc.party_id

AND acc.sales_channel_code = flv_sale.lookup_code

AND flv_sale.lookup_type = 'SALES_CHANNEL'

AND flv_http://www.doczj.com/doc/7ab51efcf705cc1755270962.htmlNGUAGE = userenv('LANG')

AND acc.customer_class_code = flv_customer.lookup_code

AND flv_customer.lookup_type = 'CUSTOMER CLASS'

AND flv_http://www.doczj.com/doc/7ab51efcf705cc1755270962.htmlNGUAGE = userenv('LANG')

AND acc.status = flv_status.lookup_code

AND flv_status.lookup_type = 'HZ_CPUI_REGISTRY_STATUS' AND flv_http://www.doczj.com/doc/7ab51efcf705cc1755270962.htmlNGUAGE = userenv('LANG')

AND acc.customer_type = flv_type.lookup_code