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_INTERFACE_LINES_GT

Line 262: FROM RA_INTERFACE_LINES_GT GT,

258: GT.HEADER_GDF_ATTRIBUTE29,
259: GT.HEADER_GDF_ATTRIBUTE30,
260: GT.HEADER_GDF_ATTRIBUTE18,
261: GT.HEADER_GDF_ATTRIBUTE28
262: FROM RA_INTERFACE_LINES_GT GT,
263: RA_CUSTOMER_TRX TRX
264: WHERE TRX.REQUEST_ID = P_REQUEST_ID
265: AND GT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
266: AND GT.INTERFACE_LINE_ID = (SELECT MIN(GT_2.INTERFACE_LINE_ID)

Line 267: FROM RA_INTERFACE_LINES_GT GT_2

263: RA_CUSTOMER_TRX TRX
264: WHERE TRX.REQUEST_ID = P_REQUEST_ID
265: AND GT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
266: AND GT.INTERFACE_LINE_ID = (SELECT MIN(GT_2.INTERFACE_LINE_ID)
267: FROM RA_INTERFACE_LINES_GT GT_2
268: WHERE GT_2.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID);
269:
270: -- BUG 10184720
271: -- Cursor Added for Additional Towing Vehicle Attributes

Line 290: FROM RA_INTERFACE_LINES_GT GT_2

286: WHERE TRX.REQUEST_ID = P_REQUEST_ID
287: AND GT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
288: AND GT.ROWID = JLEXT.JL_BR_INTERFACE_LINK_ID
289: AND GT.INTERFACE_LINE_ID = (SELECT MIN(GT_2.INTERFACE_LINE_ID)
290: FROM RA_INTERFACE_LINES_GT GT_2
291: WHERE GT_2.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID);
292:
293: /*Added for ER 9974789*/
294: CURSOR C_AUTOINV_LINE_ATTR IS SELECT