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.JA_JAINEXCLIABILITY_XMLP_PKG dependencies on JAI_CMN_RG_PLA_CMP_DTLS

Line 272: JAI_CMN_RG_PLA_CMP_DTLS

268: ,0);
269: FOR SLNO_REC IN (SELECT
270: MIN(REGISTER_ID) LO
271: FROM
272: JAI_CMN_RG_PLA_CMP_DTLS
273: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
274: AND LOCATION_ID = P_LOCATION_ID
275: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
276: ,TRUNC(TRANSACTION_DATE))

Line 284: JAI_CMN_RG_PLA_CMP_DTLS

280: BASIC_OPENING_BALANCE BASICOB,
281: ADDITIONAL_OPENING_BALANCE ADLOB,
282: OTHER_OPENING_BALANCE OTHOB
283: FROM
284: JAI_CMN_RG_PLA_CMP_DTLS
285: WHERE REGISTER_ID = SLNO_REC.LO) LOOP
286: P_CENOBPLA := NVL(VAL_REC.BASICOB
287: ,0);
288: P_ADLOBPLA := NVL(VAL_REC.ADLOB

Line 311: JAI_CMN_RG_PLA_CMP_DTLS

307: ,0) SEDCT,
308: NVL(SUM(CR_ADDITIONAL_ED)
309: ,0) ADLCT
310: FROM
311: JAI_CMN_RG_PLA_CMP_DTLS
312: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
313: AND LOCATION_ID = P_LOCATION_ID
314: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
315: ,TRUNC(TRANSACTION_DATE))

Line 336: JAI_CMN_RG_PLA_CMP_DTLS

332: ,0) SEDCU,
333: NVL(SUM(DR_ADDITIONAL_ED)
334: ,0) ADLCU
335: FROM
336: JAI_CMN_RG_PLA_CMP_DTLS
337: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
338: AND LOCATION_ID = P_LOCATION_ID
339: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
340: ,TRUNC(TRANSACTION_DATE))