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.JL_ZZ_AUTO_INVOICE dependencies on RA_CUSTOMER_TRX

Line 1453: l_trx_number ra_customer_trx_all.trx_number%TYPE;

1449: p_org_id IN NUMBER DEFAULT --Bugfix 2367111
1450: to_number(fnd_profile.value('ORG_ID'))
1451: ) RETURN VARCHAR2 IS
1452:
1453: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1454: l_country_code VARCHAR2(2);
1455: l_org_id NUMBER;
1456:
1457: BEGIN

Line 1481: update ra_customer_trx

1477: l_status_code number := 1;
1478:
1479: BEGIN
1480:
1481: update ra_customer_trx
1482: set status_trx ='VD'
1483: where customer_trx_id in (select trx.previous_customer_trx_id
1484: from ra_customer_trx trx,
1485: ra_cust_trx_types trx_type

Line 1484: from ra_customer_trx trx,

1480:
1481: update ra_customer_trx
1482: set status_trx ='VD'
1483: where customer_trx_id in (select trx.previous_customer_trx_id
1484: from ra_customer_trx trx,
1485: ra_cust_trx_types trx_type
1486: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
1487: and trx.request_id = p_request_id
1488: and trx_type.type = 'CM'