综合查询客户主数据代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】综合查询客户主数据

作者:Dezai.CN / 发布于2012/12/5/ 563

-- 客户主数据
SELECT hca.cust_account_id     customer_id,
       hp.party_number         customer_number,
       hp.party_name           customer_name,
       hp.party_name           customer_short_name,
       hca.customer_type       customer_type,
       alt.meaning             customer_type_meaning,
       hca.customer_class_code customer_class,
       alc.meaning             customer_class_meaning,
       hp.tax_reference        tax_registered_name,
       rt.name                 term_name,
       hca.creation_date       creation_date,
       hca.created_by          created_by,
       hca.last_update_date     last_update_date,
       hca.last_updated_by     last_updated_by,
       hca.last_update_login   last_update_login
  FROM hz_parties           hp,
       hz_cust_accounts     hca,
       ar_lookups           alt,
       ar_lookups           alc,
       hz_customer_profiles hcp,
       ra_terms             rt
  WHERE hp.party_id = hca.party_id
   AND hca.customer_type = alt.lookup_code(+)
   AND alt.lookup_type = 'CUSTOMER_TYPE'
   AND hca.customer_class_code = alc.lookup_code(+)
   AND alc.lookup_type(+) = 'CUSTOMER CLASS'
   AND hca.cust_account_id = hcp.cust_account_id(+)
   AND hcp.standard_terms = rt.term_id(+)

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　客户主数据　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)