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.JA_JAINVAR_XMLP_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 475: RA_CUSTOMER_TRX_ALL

471: CURSOR TRANSACTION_CURR_CUR IS
472: SELECT
473: INVOICE_CURRENCY_CODE
474: FROM
475: RA_CUSTOMER_TRX_ALL
476: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;
477: V_TRANS_CURR VARCHAR2(15);
478: BEGIN
479: OPEN TRANSACTION_CURR_CUR;

Line 496: RA_CUSTOMER_TRX_ALL

492: WHERE SET_OF_BOOKS_ID in (
493: SELECT
494: SET_OF_BOOKS_ID
495: FROM
496: RA_CUSTOMER_TRX_ALL
497: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1 );
498: V_FUNC_CURR VARCHAR2(15);
499: BEGIN
500: OPEN FUNC_CURR_CUR;

Line 571: RA_CUSTOMER_TRX_ALL

567: NVL(EXCHANGE_DATE
568: ,TRX_DATE) EXCHANGE_DATE,
569: EXCHANGE_RATE
570: FROM
571: RA_CUSTOMER_TRX_ALL
572: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;
573: V_BOOKS_ID NUMBER := 1;
574: C_FROM_CURRENCY_CODE VARCHAR2(15);
575: C_CONVERSION_TYPE VARCHAR2(30);

Line 605: RA_CUSTOMER_TRX_ALL

601: NVL(EXCHANGE_DATE
602: ,TRX_DATE) EXCHANGE_DATE,
603: EXCHANGE_RATE
604: FROM
605: RA_CUSTOMER_TRX_ALL
606: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;
607: V_BOOKS_ID NUMBER := 1;
608: C_FROM_CURRENCY_CODE VARCHAR2(15);
609: C_CONVERSION_TYPE VARCHAR2(30);

Line 664: RA_CUSTOMER_TRX_ALL

660: NVL(EXCHANGE_DATE
661: ,TRX_DATE) EXCHANGE_DATE,
662: EXCHANGE_RATE
663: FROM
664: RA_CUSTOMER_TRX_ALL
665: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;
666: BEGIN
667: IF NVL(AUTO_INVOICE_FLAG
668: ,'N') = 'Y' THEN