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_BR_SPED_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

101: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
102: TYPE LINE_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.LINE_GDF_ATTRIBUTE1%TYPE; --ER 9974789
103:
104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
106:
107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;

Line 403: RA_CUSTOMER_TRX_LINES TRXL,

399: OLD.INDUSTRY_ATTRIBUTE29,
400: OLD.INDUSTRY_ATTRIBUTE30
401: FROM JL_BR_CUST_TRX_LINES_EXTS OLD,
402: RA_CUSTOMER_TRX TRX,
403: RA_CUSTOMER_TRX_LINES TRXL,
404: (SELECT RATRX.TRX_NUMBER, RATRX.CUSTOMER_TRX_ID, RATRX.RECURRED_FROM_TRX_NUMBER, RATRX.BATCH_SOURCE_ID,
405: RATXL.CUSTOMER_TRX_LINE_ID, RATXL.LINE_NUMBER, RATXL.LINE_TYPE
406: FROM RA_CUSTOMER_TRX RATRX, RA_CUSTOMER_TRX_LINES RATXL
407: WHERE RATRX.REQUEST_ID = P_REQUEST_ID

Line 406: FROM RA_CUSTOMER_TRX RATRX, RA_CUSTOMER_TRX_LINES RATXL

402: RA_CUSTOMER_TRX TRX,
403: RA_CUSTOMER_TRX_LINES TRXL,
404: (SELECT RATRX.TRX_NUMBER, RATRX.CUSTOMER_TRX_ID, RATRX.RECURRED_FROM_TRX_NUMBER, RATRX.BATCH_SOURCE_ID,
405: RATXL.CUSTOMER_TRX_LINE_ID, RATXL.LINE_NUMBER, RATXL.LINE_TYPE
406: FROM RA_CUSTOMER_TRX RATRX, RA_CUSTOMER_TRX_LINES RATXL
407: WHERE RATRX.REQUEST_ID = P_REQUEST_ID
408: AND RATRX.CUSTOMER_TRX_ID = RATXL.CUSTOMER_TRX_ID) NEW
409: WHERE TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID
410: AND TRX.CUSTOMER_TRX_ID = OLD.CUSTOMER_TRX_ID

Line 936: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

932: FUNCTION COPY_GDF_ATTRIBUTES_API (P_CUSTOMER_TRX_ID IN NUMBER) RETURN NUMBER IS
933:
934: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
935: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
936: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
937: TYPE INDUSTRY_ATTRIBUTE_TYPE IS TABLE OF JL_BR_CUST_TRX_LINES_EXTS.INDUSTRY_ATTRIBUTE1%TYPE;
938: TYPE SERVICE_EXEC_DATE_TYPE IS TABLE OF JL_BR_INV_API_TRX_LINES_T.SRV_EXEC_DATE%TYPE; --BUG 11825724
939:
940: CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID_TYPE;