how to write formula column in XML data template in apps R12
Hi All,
Could you please help me how to write formula column in XML data template?
function C_REMIT_TO_CONCATENATEDFormula return VARCHAR2 is Remit_To_String VARCHAR2(5000); address_style VARCHAR2(30); address1 VARCHAR2(240); address2 VARCHAR2(240); address3 VARCHAR2(240); address4 VARCHAR2(240); city VARCHAR2(60); county VARCHAR2(60); state VARCHAR2(60); province VARCHAR2(60); postal_code VARCHAR2(60); territory_short_name VARCHAR2(80); country_code VARCHAR2(60); customer_name VARCHAR2(50); bill_to_location VARCHAR2(40); first_name VARCHAR2(40); last_name VARCHAR2(50); mail_stop VARCHAR2(60); default_country_code VARCHAR2(60); default_country_desc VARCHAR2(80); print_home_country_flag VARCHAR2(5); print_default_attn_flag VARCHAR2(5); width NUMBER(3); height_min NUMBER(3); height_max NUMBER(3);BEGIN srw.reference(:REMIT_ADDRESS1); srw.reference(:REMIT_ADDRESS2); srw.reference(:REMIT_ADDRESS3); srw.reference(:REMIT_ADDRESS4); srw.reference(:REMIT_CITY); srw.reference(:REMIT_STATE); srw.reference(:REMIT_POSTAL_CODE); srw.reference(:REMIT_COUNTRY); srw.reference(:P_default_country); srw.reference(:P_default_country_description); srw.reference(:P_print_home_country_flag); srw.reference(:BILL_COUNTRY); /* only when country of Bill-To Address is Japan, let the format_address() consider JP style address formatting, otherwise default format style is forced to be used. *//* bug1808782 : RAXINV does not
0