Home » Applications » Oracle Fusion Apps & E-Business Suite » Vendor Sites
Vendor Sites [message #173679] Wed, 24 May 2006 00:00 Go to next message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
hi all,
I want to know that is there any way to query the vendor sites in AP from backend because when i query po_vendor_sites_v no row is selected but table definition exists. How data hiding is implemented by oracle? Any suggestions?

Regards
Fakhar.
Re: Vendor Sites [message #173680 is a reply to message #173679] Wed, 24 May 2006 00:13 Go to previous messageGo to next message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member

Hello,
Use either PO_VENDOR_SITES_ALL table or set environment (Operating Unit) at sql client and then use view PO_VENDOR_SITES_V. See SELECT statement behind this view to get an idea.

Vasant
Re: Vendor Sites [message #173731 is a reply to message #173679] Wed, 24 May 2006 04:28 Go to previous message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
hi manwadkar,
Thanks a lot dear. thanks.
Previous Topic: where is password
Next Topic: sql validation in profile?
Goto Forum:
  


Current Time: Sun May 19 04:28:21 CDT 2024