[Home] [Help]
1647: select trx.customer_trx_id , trx.org_id , trx.trx_number , trx.cust_trx_type_id , trx.created_from,
1648: nvl(trx.bill_to_customer_id,trx.ship_to_customer_id) customer_id, nvl(trx.bill_to_site_use_id,trx.ship_to_site_use_id) customer_site_id,
1649: decode( trx_types.TYPE ,'INV','Invoice','CM','Credit Memo','DM','Debit Memo',trx_types.TYPE ) document_type /*JMEENA for bug#4932256( FP 4913641)*/
1650: from ra_customer_Trx_all trx ,
1651: ra_cust_trx_types_all trx_types ,
1652: jai_ar_trxs jtrx /* Added for bug#5376622 */
1653: where
1654: trx.customer_trx_id = jtrx.customer_trx_id AND
1655: (trx.bill_to_customer_id = nvl(p_party_id,trx.bill_to_customer_id)
1728: where customer_trx_id = p_invoice_id;
1729:
1730: cursor c_trx_type(p_cust_trx_type_id number) is
1731: select type
1732: from ra_cust_trx_types_all
1733: where cust_trx_type_id = p_cust_trx_type_id;
1734:
1735: v_hdr_record_exists number;
1736: v_st_hdr_id number;
1750: const_autoinv constant ra_customer_trx_all.created_from%type := 'RAXTRX';
1751: v_some_errors char(1); -- := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1752: v_orgn_id number;
1753: v_locn_id number;
1754: v_trx_type ra_cust_trx_types_all.type%type;
1755: v_order_flag char(1); --:= 'O'; --Ramananda for File.Sql.35
1756:
1757: /*
1758: the purpose of the following function is to calculate the base tax amounts