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

Line 22: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

18: -- Declaration part
19:
20: CURSOR C_BATCH_SOURCE IS
21: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') GLOBAL_ATTRIBUTE5
22: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
23: WHERE T.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
24: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
25:
26: CURSOR C_CUST_EXT IS

Line 77: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

73: PROCEDURE Set_Trx_Lock_Status(p_customer_trx_id IN NUMBER) IS
74:
75: CURSOR C_BATCH_SOURCE IS
76: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') GLOBAL_ATTRIBUTE5
77: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
78: WHERE T.CUSTOMER_TRX_ID = p_customer_trx_id
79: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
80: l_country_code varchar2(30);
81: BEGIN

Line 104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;

100:
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;

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 263: RA_CUSTOMER_TRX TRX

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)
267: FROM RA_INTERFACE_LINES_GT GT_2

Line 284: RA_CUSTOMER_TRX TRX,

280: JLEXT.HEADER_GDF_ATTRIBUTE37,
281: JLEXT.HEADER_GDF_ATTRIBUTE38,
282: JLEXT.HEADER_GDF_ATTRIBUTE39 --BUG 11825724
283: FROM RA_INTERFACE_LINES_ALL GT,
284: RA_CUSTOMER_TRX TRX,
285: JL_BR_INTERFACE_LINES_EXTS JLEXT
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

Line 329: RA_CUSTOMER_TRX TRX

325: JLEXT.LINE_GDF_ATTRIBUTE49,
326: JLEXT.LINE_GDF_ATTRIBUTE50
327: FROM JL_BR_INTERFACE_LINES_EXTS JLEXT,
328: RA_INTERFACE_LINES_ALL ARINT,
329: RA_CUSTOMER_TRX TRX
330: WHERE TRX.REQUEST_ID = P_REQUEST_ID
331: AND ARINT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
332: AND ARINT.ROWID = JLEXT.JL_BR_INTERFACE_LINK_ID;
333:

Line 362: FROM RA_CUSTOMER_TRX WHERE REQUEST_ID = P_REQUEST_ID) NEW_TRX

358: ,OLD_TRX.TOWING_VEH_PLATE_STATE_CODE5
359: ,OLD_TRX.SRV_EXEC_DATE --BUG 11825724 Service Execution Date
360: FROM JL_BR_CUSTOMER_TRX_EXTS OLD_TRX,
361: (SELECT TRX_NUMBER, CUSTOMER_TRX_ID,RECURRED_FROM_TRX_NUMBER,BATCH_SOURCE_ID
362: FROM RA_CUSTOMER_TRX WHERE REQUEST_ID = P_REQUEST_ID) NEW_TRX
363: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX
364: WHERE TRX_NUMBER = NEW_TRX.RECURRED_FROM_TRX_NUMBER
365: AND BATCH_SOURCE_ID = NEW_TRX.BATCH_SOURCE_ID);
366:

Line 363: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX

359: ,OLD_TRX.SRV_EXEC_DATE --BUG 11825724 Service Execution Date
360: FROM JL_BR_CUSTOMER_TRX_EXTS OLD_TRX,
361: (SELECT TRX_NUMBER, CUSTOMER_TRX_ID,RECURRED_FROM_TRX_NUMBER,BATCH_SOURCE_ID
362: FROM RA_CUSTOMER_TRX WHERE REQUEST_ID = P_REQUEST_ID) NEW_TRX
363: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX
364: WHERE TRX_NUMBER = NEW_TRX.RECURRED_FROM_TRX_NUMBER
365: AND BATCH_SOURCE_ID = NEW_TRX.BATCH_SOURCE_ID);
366:
367: /*Added for ER 9974789*/

Line 402: RA_CUSTOMER_TRX TRX,

398: OLD.INDUSTRY_ATTRIBUTE28,
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

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 428: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

424: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
425:
426: BEGIN
427: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') INTO L_ISSUE_AUTHORITY
428: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
429: WHERE T.REQUEST_ID = P_REQUEST_ID
430: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID
431: AND ROWNUM = 1;
432: EXCEPTION

Line 935: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;

931: the the extension table */
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:

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;

Line 1112: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

1108: FOR I IN 1..CUSTOMER_TRX_ID.COUNT
1109: LOOP
1110: BEGIN
1111: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') INTO L_ISSUE_AUTHORITY
1112: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
1113: WHERE T.CUSTOMER_TRX_ID = CUSTOMER_TRX_ID(I)
1114: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
1115:
1116: IF L_ISSUE_AUTHORITY = 'Y' THEN