APPS.JAI_CMN_ST_FORMS_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 1797: ra_cust_trx_types_all trx_types ,

1793: select trx.customer_trx_id , trx.org_id , trx.trx_number , trx.cust_trx_type_id , trx.created_from,
1794: 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,
1795: decode( trx_types.TYPE ,'INV','Invoice','CM','Credit Memo','DM','Debit Memo',trx_types.TYPE ) document_type /*JMEENA for bug#4932256( FP 4913641)*/
1796: from ra_customer_Trx_all trx ,
1797: ra_cust_trx_types_all trx_types ,
1798: jai_ar_trxs jtrx /* Added for bug#5376622 */
1799: where
1800: trx.customer_trx_id = jtrx.customer_trx_id AND
1801: (trx.bill_to_customer_id = nvl(p_party_id,trx.bill_to_customer_id)

Line 1879: from ra_cust_trx_types_all

1875: where customer_trx_id = p_invoice_id;
1876:
1877: cursor c_trx_type(p_cust_trx_type_id number) is
1878: select type
1879: from ra_cust_trx_types_all
1880: where cust_trx_type_id = p_cust_trx_type_id;
1881:
1882: v_hdr_record_exists number;
1883: v_st_hdr_id number;

Line 1901: v_trx_type ra_cust_trx_types_all.type%type;

1897: const_autoinv constant ra_customer_trx_all.created_from%type := 'RAXTRX';
1898: v_some_errors char(1); -- := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1899: v_orgn_id number;
1900: v_locn_id number;
1901: v_trx_type ra_cust_trx_types_all.type%type;
1902: v_order_flag char(1); --:= 'O'; --Ramananda for File.Sql.35
1903:
1904: /*
1905: the purpose of the following function is to calculate the base tax amounts