sql for customer bill to address

SELECT c.site_use_id,

a.cust_account_id,

e.address1,

e.address2,

e.address3,

e.address4,

e.postal_code,

e.province,

e.state,

country

FROM hz_cust_accounts a,

hz_cust_acct_sites_all b,

hz_cust_site_uses_all c,

hz_party_sites d,

hz_locations e

WHERE a.cust_account_id = b.cust_account_id

AND b.cust_acct_site_id = c.cust_acct_site_id

AND b.party_site_id = d.party_site_id

AND d.location_id = e.location_id

AND c.site_use_code = 'BILL_TO'

AND c.status = 'A'

AND b.org_id = c.org_id

AND b.org_id = 160

AND a.cust_account_id IN (595595, 555158)

improving performance with pipelined table functions

http://www.oracle-developer.net/display.php?id=429

Unix Command to send mail with attachment

$ echo "something"|mailx -s "subject" recipient@somewhere.com

WITH ATTACHMENT
--------------------------

$ uuencode   |mailx -s "subject" recipient@somewhere.com

Oracle Apps -Concurrent program schedule details

https://forums.oracle.com/forums/thread.jspa?messageID=6500691&tstart=0#6500691

SQL Queries for checking Profile Option Values

SELECT

substr(pro1.user_profile_option_name,1,35) Profile,

decode(pov.level_id,

10001,'Site',

10002,'Application',

10003,'Resp',

10004,'User') Option_Level,

decode(pov.level_id,

10001,'Site',

10002,appl.application_short_name,

10003,resp.responsibility_name,

10004,u.user_name) Level_Value,

nvl(pov.profile_option_value,'Is Null') Profile_option_Value

FROM

fnd_profile_option_values pov,

fnd_responsibility_tl resp,

fnd_application appl,

fnd_user u,

fnd_profile_options pro,

fnd_profile_options_tl pro1

WHERE

pro1.user_profile_option_name like ('%Ledger%')

and pro.profile_option_name = pro1.profile_option_name

and pro.profile_option_id = pov.profile_option_id

and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */

and pov.level_value = resp.responsibility_id (+)

and pov.level_value = appl.application_id (+)

and pov.level_value = u.user_id (+)

order by 1,2;

Function is not available for this responsibility.Contact your system Administrator or change the responsibility

Function is not available for this responsibility.Contact your system Administrator or change the responsibility


Solution:
======


Put entry of the custom top in the default.env file under $INST_TOP/ora/10.1.2/forms/server.

eg:XXXX_TOP=$APPL_TOP/xxxx/12.0.0 (better write full path of $APPL_TOP insted of writing $APPL_TOP)