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

Line 2114: l_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;

2110: PROCEDURE DERIVE_POA_ADDRESS_CODE
2111: IS
2112: l_poa_geocode VARCHAR2(10);
2113: l_poa_in_out_flag VARCHAR2(1);
2114: l_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;
2115:
2116: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_POA_ADDRESS_CODE';
2117:
2118: BEGIN

Line 2132: FROM ra_customer_trx_all

2128: ELSE
2129: BEGIN
2130: SELECT primary_salesrep_id
2131: INTO l_sales_repid
2132: FROM ra_customer_trx_all
2133: WHERE customer_trx_id = adjusted_doc_trx_id_tab(i);
2134: EXCEPTION
2135: WHEN NO_DATA_FOUND THEN
2136: l_sales_repid := NULL;

Line 2163: FROM ra_customer_trx_all

2159: ELSE
2160: BEGIN
2161: SELECT primary_salesrep_id
2162: INTO l_sales_repid
2163: FROM ra_customer_trx_all
2164: WHERE customer_trx_id = trx_id_tab(i);
2165: EXCEPTION
2166: WHEN NO_DATA_FOUND THEN
2167: l_sales_repid := NULL;