eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 12: , ra_customer_trx_all trx

8: CURSOR check_trx_type IS
9: SELECT trx_types.type
10: FROM
11: ra_customer_trx_lines_all trxl
12: , ra_customer_trx_all trx
13: , ra_cust_trx_types_all trx_types
14: WHERE trxl.customer_trx_id = trx.customer_trx_id
15: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
16: AND trxl.customer_trx_line_id = pn_customer_trx_line_id;

Line 63: v_order_number ra_customer_trx_all.interface_header_attribute1%type; /for bug 14089006. Earlier size was varchar2(30)/

59: v_organization_id NUMBER ;
60: v_location_id NUMBER ;
61: v_batch_source_id NUMBER ;
62: v_register_code VARCHAR2(50);
63: v_order_number ra_customer_trx_all.interface_header_attribute1%type; /*for bug 14089006. Earlier size was varchar2(30)*/
64: v_order_type ra_customer_trx_all.interface_header_attribute2%type;
65: v_org_id NUMBER(15); -- added by sriram because the orgid value is not going into temp_lines_insert table
66: v_tax_exists NUMBER :=0; --added by mmurtuza for bug 13042890
67:

Line 64: v_order_type ra_customer_trx_all.interface_header_attribute2%type;

60: v_location_id NUMBER ;
61: v_batch_source_id NUMBER ;
62: v_register_code VARCHAR2(50);
63: v_order_number ra_customer_trx_all.interface_header_attribute1%type; /*for bug 14089006. Earlier size was varchar2(30)*/
64: v_order_type ra_customer_trx_all.interface_header_attribute2%type;
65: v_org_id NUMBER(15); -- added by sriram because the orgid value is not going into temp_lines_insert table
66: v_tax_exists NUMBER :=0; --added by mmurtuza for bug 13042890
67:
68: --v_ORDER_PRICE_EXCISE_INCLUSIVE JAI_CMN_INVENTORY_ORGS.ORDER_PRICE_EXCISE_INCLUSIVE%type; ---- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22, TD18

Line 72: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type; /* bug# 6012570 (5876390) */

68: --v_ORDER_PRICE_EXCISE_INCLUSIVE JAI_CMN_INVENTORY_ORGS.ORDER_PRICE_EXCISE_INCLUSIVE%type; ---- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22, TD18
69:
70: ln_inv_curr_precision NUMBER; /* added by CSahoo - bug# 5364120*/
71: --commented by kunkumar for bug#6066813
72: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type; /* bug# 6012570 (5876390) */
73:
74: /*Bug 11821537 - Fetch the effective date on which Service Tax needs to accounted in accrual basis instead of cash - Start*/
75: ld_st_accrual_date DATE;
76: ld_trx_date DATE;

Line 91: FROM ra_customer_trx_all

87:
88: CURSOR c_get_trx_date
89: IS
90: SELECT trx_date
91: FROM ra_customer_trx_all
92: WHERE customer_trx_id = v_customer_trx_id;
93: */
94: --Commented by Chong.Lei for POT code port end
95: --Added by Chong.Lei for POT code port begin

Line 185: FROM RA_CUSTOMER_TRX_ALL

181: SELECT set_of_books_id, primary_salesrep_id, org_id , invoice_currency_code, exchange_rate_type,
182: exchange_date, exchange_rate
183: --commented by kunkumar for Bug#6066813
184: ,interface_header_context /* 6012570 (5876390) */
185: FROM RA_CUSTOMER_TRX_ALL
186: WHERE customer_trx_id = v_customer_trx_id;
187:
188: --Commented for bug#4468353
189: /*

Line 199: FROM RA_CUSTOMER_TRX_ALL

195:
196: /* Added by Ramananda for bug#4468353 , start */
197: CURSOR ORG_CUR IS
198: SELECT ORG_ID
199: FROM RA_CUSTOMER_TRX_ALL
200: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
201:
202: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
203: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;

Line 215: FROM ra_customer_trx_all

211: WHERE B.tax_id = p_tax_id ;
212:
213: CURSOR CREATED_FROM_CUR IS
214: SELECT created_from, interface_header_attribute1,interface_header_attribute2
215: FROM ra_customer_trx_all
216: WHERE customer_trx_id = v_customer_trx_id;
217:
218: CURSOR SO_AR_HDR_INFO IS
219: SELECT organization_id, location_id, batch_source_id /*uncommented for bug#8775345*/

Line 295: trx_number FROM ra_customer_trx_all WHERE

291: * Removed cursor set_of_books_cur and c_opr_set_of_books_id
292: * and implemented caching logic.
293: */
294: CURSOR trx_num(v_cust_trx_id NUMBER) IS SELECT
295: trx_number FROM ra_customer_trx_all WHERE
296: customer_trx_id = v_cust_trx_id;
297:
298: -- following cursor added by sriram -3266982
299:

Line 334: v_trx_num ra_customer_trx_all.trx_number%TYPE ;

330: lv_error_message VARCHAR2(4000) ;
331: -- End of bug 4089440
332:
333: v_err_mesg VARCHAR2(250) ;
334: v_trx_num ra_customer_trx_all.trx_number%TYPE ;
335:
336: /* Bug 5243532. Added by Lakshmi Gopalsami
337: * Defined variable for implementing caching logic
338: */

Line 460: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is

456: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.
457: Without this join, if the same sales order number is associated to multiple order types,
458: there is scope for the wrong order number to be chosen and comparison done on that basis.
459:
460: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is
461: compared to the 'Name' field in the oe_transaction_types_tl.
462:
463: 11. 2005/27/01 aiyer - Bug # 4089440 File Version 115.1
464: Issue:-

Line 611: Fix: Mdofied the definition of variable v_order_number from varchar2(30) to ra_customer_trx_all.interface_header_attribute1%type

607: imported from projects.
608:
609: 34. 18-May-2012 mmurtuza for bug 14089006
610: Issue: ERROR ENCOUNTERED IN TRANSACTION WORKBENCH
611: Fix: Mdofied the definition of variable v_order_number from varchar2(30) to ra_customer_trx_all.interface_header_attribute1%type
612:
613: 35. 10-Dec-2012 mmurtuza for bug 14846750
614: Issue: INDIA LOCALIZATION ERROR IN AUTO INVOICE IMPORT FOR SUPPLEMENTARY INVOICES.
615: Fix: Removed parameter and condition of order_number in cursor check_rma_credit_cur

Line 1305: v_org_id ra_customer_trx_all.org_id%type;

1301: v_location_id NUMBER ;
1302: v_batch_source_id NUMBER ;
1303: v_register_code VARCHAR2(50);
1304: -- added by sriram - bug # 2779967
1305: v_org_id ra_customer_trx_all.org_id%type;
1306: /*Bug 8371741 - Start*/
1307: v_line_amount NUMBER := 0;
1308: v_quantity NUMBER;
1309: v_trans_type VARCHAR2(30);

Line 1346: FROM ra_customer_trx_all

1342:
1343: CURSOR c_get_trx_date
1344: IS
1345: SELECT trx_date
1346: FROM ra_customer_trx_all
1347: WHERE customer_trx_id = v_customer_trx_id;
1348: */
1349: --Commented by Chong.Lei for POT code port end
1350: -- Added by Chong.Lei for POT code port begin

Line 1406: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

1402: WHERE REGIME_CODE = CP_REGIME_CODE;
1403:
1404: Cursor transaction_type_cur IS
1405: Select a.type
1406: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
1407: Where a.cust_trx_type_id = b.cust_trx_type_id
1408: And b.customer_trx_id = v_customer_trx_id
1409: And NVL(a.org_id,0) = NVL(b.org_id,0);
1410:

Line 1416: FROM RA_CUSTOMER_TRX_ALL RCTA

1412: SELECT RCTA.org_id,
1413: RCTA.bill_to_customer_id,
1414: NVL(RCTA.bill_to_site_use_id,0),
1415: RCTA.trx_date
1416: FROM RA_CUSTOMER_TRX_ALL RCTA
1417: WHERE RCTA.customer_trx_id = v_customer_trx_id;
1418:
1419: /*Bug 8371741 - End*/
1420: /*Commented by kunkumar for bug#6066813 start Bug 6012570 (5876390) */

Line 1424: from ra_customer_trx_all

1420: /*Commented by kunkumar for bug#6066813 start Bug 6012570 (5876390) */
1421: /*cursor c_get_hdr_ctx
1422: is
1423: select interface_header_context
1424: from ra_customer_trx_all
1425: where customer_trx_id = pr_new.customer_trx_id;*/
1426: /*commented the above cursor and added the following for bug#5597146*/
1427: /*commented the cursor c_get_hdr_ctx for bug#8310220
1428: cursor c_get_hdr_ctx

Line 1438: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type ;

1434: and interface_line_context is not null
1435: and rownum = 1;*/
1436:
1437:
1438: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type ;
1439: /* End commented by kunkumar for bug#6066813 */
1440: /*end Bug 6012570 (5876390) */
1441:
1442: -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22 Begin

Line 1529: FROM RA_CUSTOMER_TRX_ALL

1525:
1526: /* Added by Ramananda for bug#4468353 , start
1527: CURSOR ORG_CUR IS
1528: SELECT ORG_ID
1529: FROM RA_CUSTOMER_TRX_ALL
1530: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;*/
1531:
1532: --commented the above org_cur cursor and added the following org_cur cursor for bug#5597146
1533: CURSOR ORG_CUR IS

Line 1557: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636

1553: WHERE CUSTOMER_TRX_LINE_ID = pr_old.customer_trx_line_id;
1554:
1555: CURSOR CREATED_FROM_CUR IS
1556: SELECT created_from
1557: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636
1558: WHERE customer_trx_id = v_customer_trx_id;
1559:
1560: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
1561: SELECT INSERT_UPDATE_FLAG

Line 1666: Reference to table RA_CUSTOMER_TRX_ALL was present in the cursor Created_from_cur

1662: 6. 2002/05/09 Sriram
1663: Added the if condition at the bottom of the trigger to conditionally call the concurrent
1664: only if is a manual invoice.
1665: 7. 2003/01/02 Ssumaith Bug # 2728636 File Version 615.2
1666: Reference to table RA_CUSTOMER_TRX_ALL was present in the cursor Created_from_cur
1667: Which was causing a mutating error and causing the transaction to error out
1668: with unhandled exception.This has been changed to point to JAI_AR_TRXS
1669: table instead which takes care of the issue.
1670: 8. 2003/04/07 SSUMAITH.Bug # 2779967

Line 2469: FROM ra_customer_trx_all

2465:
2466: if (pr_new.tax_category_id is NULL and l_tcs_sur_line_num = 0) then
2467: if (c_conversion_date is NULL) then
2468: SELECT trx_date INTO c_conversion_date
2469: FROM ra_customer_trx_all
2470: WHERE customer_trx_id = v_customer_trx_id;
2471: end if;
2472:
2473: OPEN transaction_type_cur;