EBS Bill to / ship to example tutorial

This article mainly introduces the "EBS Bill-to / ship-to example tutorial". In the daily operation, I believe many people have doubts on the EBS Bill-to / ship-to example tutorial. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "EBS Bill-to / ship-to example tutorial". Next, please follow the editor to study!

Select rt.name, hcas.org_idfrom ar.hz_cust_acct_sites_all hcas,ar.hz_cust_site_uses_all hcsu Ra_terms_vl rtwhere 1 = 1and hcas.status = 'A'and hcsu.status =' A'and hcsu.cust_acct_site_id = hcas.cust_acct_site_idand hcsu.site_use_code = 'BILL_TO'-- ShIP_TOand rt.term_id = hcsu.payment_term_idand rt.name is not nulland hcas.cust_account_id = 13434343-- hca.cust_account_id--cusomter_idselect hl.address1 | |','| hl.address2 address, hou.name business entity Decode (hcsua2.site_use_code,'BILL_TO',' Bill to', 'DRAWEE',' payer', 'SHIP_TO',' consignee') related person from hz_cust_acct_sites_all cas,apps.hz_cust_site_uses_all hcsua2,hz_party_sites hps,hz_locations hl Hr_operating_units houwhere cas.party_site_id = hps.party_site_idand hps.location_id = hl.location_idand cas.org_id = hou.organization_idand hcsua2.cust_acct_site_id = cas.cust_acct_site_idand hcsua2.primary_flag = 'Y'and cas.cust_account_id = 134343-- CUSTOMER_ID here The study on "EBS Bill-to / ship-to example tutorial" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!