Home » Applications » Oracle Fusion Apps & E-Business Suite » Bill-to/Ship-to Customer id
Bill-to/Ship-to Customer id [message #292077] Mon, 07 January 2008 13:13 Go to next message
iamrajarajan
Messages: 15
Registered: November 2006
Location: Bangalore
Junior Member

How to find the Bill to Customer id and Ship to Customer id belongs to the particular Organisation? Also how to check the Bill to Customer id and Ship to Customer id of an Organisation is Valid?

Thanks
Rajarajan.A
Re: Bill-to/Ship-to Customer id [message #292232 is a reply to message #292077] Tue, 08 January 2008 04:23 Go to previous messageGo to next message
orafan23
Messages: 13
Registered: December 2005
Junior Member
Query the RA_CUSTOMERS_INTERFACE table.Should have the information there.
icon7.gif  Re: Bill-to/Ship-to Customer id [message #295641 is a reply to message #292232] Tue, 22 January 2008 23:46 Go to previous message
amritaseema
Messages: 47
Registered: January 2008
Member
Hi,
By this query you can get the ship_to address



select hcs.location "Location",
hl.CITY ||', '||hl.STATE ||', '||hl.POSTAL_CODE ||', '||hl.COUNTRY "Ship To Address"
from hz_locations hl,
oe_order_headers_all oeh,
hz_cust_site_uses_all hcs,
hz_cust_acct_sites_all hcas,
hz_party_sites hps
where hcs.SITE_USE_ID=oeh.SHIP_TO_ORG_ID
and hcs.cust_acct_site_id=hcas.cust_acct_site_id
and hcas.party_site_id=hps.party_site_id
and hl.location_id=hps.location_id
and oeh.order_number=&order_num
Previous Topic: How to get the PO number for the respective invoice number?
Next Topic: ORA-01631 ERROR
Goto Forum:
  


Current Time: Sun Dec 11 00:13:28 CST 2016

Total time taken to generate the page: 0.07766 seconds