OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Bill-to/Ship-to Customer id

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Bill-to/Ship-to Customer id [message #292077]

Mon, 07 January 2008 13:13

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

Report message to a moderator

Re: Bill-to/Ship-to Customer id [message #292232 is a reply to message #292077]

Tue, 08 January 2008 04:23

orafan23
Messages: 13
Registered: December 2005

Junior Member

Query the RA_CUSTOMERS_INTERFACE table.Should have the information there.

Report message to a moderator

Re: Bill-to/Ship-to Customer id [message #295641 is a reply to message #292232]

Tue, 22 January 2008 23:46

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

Report message to a moderator

Previous Topic:	How to get the PO number for the respective invoice number?
Next Topic:	ORA-01631 ERROR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 23:59:18 CDT 2024