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_AP_POPULATE_PKG dependencies on ZX_REC_NREC_DIST

Line 1311: FROM zx_rec_nrec_dist zx_dist,

1307: c_event_id number,
1308: c_ae_header_id number) IS
1309: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1310: ael.code_combination_id
1311: FROM zx_rec_nrec_dist zx_dist,
1312: xla_distribution_links lnk,
1313: xla_ae_lines ael
1314: WHERE zx_dist.trx_id = c_trx_id
1315: AND zx_dist.APPLICATION_ID = c_application_id

Line 1339: FROM zx_rec_nrec_dist zx_dist,

1335: c_event_id NUMBER,
1336: c_ae_header_id NUMBER) IS
1337: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1338: ael.code_combination_id
1339: FROM zx_rec_nrec_dist zx_dist,
1340: xla_distribution_links lnk,
1341: xla_ae_lines ael
1342: WHERE zx_dist.trx_id = c_trx_id
1343: AND zx_dist.APPLICATION_ID = c_application_id

Line 1372: FROM zx_rec_nrec_dist zx_dist,

1368: c_event_id NUMBER,
1369: c_ae_header_id NUMBER) IS
1370: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1371: ael.code_combination_id
1372: FROM zx_rec_nrec_dist zx_dist,
1373: xla_distribution_links lnk,
1374: xla_ae_lines ael
1375: WHERE zx_dist.trx_id = c_trx_id
1376: AND zx_dist.APPLICATION_ID = c_application_id

Line 1405: FROM zx_rec_nrec_dist zx_dist,

1401: c_ae_header_id NUMBER,
1402: c_ledger_id NUMBER) IS
1403: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1404: ael.code_combination_id
1405: FROM zx_rec_nrec_dist zx_dist,
1406: xla_distribution_links lnk,
1407: xla_ae_lines ael
1408: WHERE zx_dist.trx_id = c_trx_id
1409: AND zx_dist.APPLICATION_ID = c_application_id

Line 1434: FROM zx_rec_nrec_dist zx_dist,

1430: c_event_id number,
1431: c_ae_header_id number) IS
1432: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) */
1433: ael.code_combination_id
1434: FROM zx_rec_nrec_dist zx_dist,
1435: xla_distribution_links lnk,
1436: xla_ae_lines ael
1437: WHERE zx_dist.trx_id = c_trx_id
1438: AND zx_dist.APPLICATION_ID = c_application_id

Line 1463: FROM zx_rec_nrec_dist zx_dist,

1459: c_event_id number,
1460: c_ae_header_id number) IS
1461: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) */
1462: ael.code_combination_id
1463: FROM zx_rec_nrec_dist zx_dist,
1464: xla_distribution_links lnk,
1465: xla_ae_lines ael
1466: WHERE zx_dist.trx_id = c_trx_id
1467: AND zx_dist.APPLICATION_ID = c_application_id

Line 1496: FROM zx_rec_nrec_dist zx_dist,

1492: c_event_id number,
1493: c_ae_header_id number) IS
1494: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) */
1495: ael.code_combination_id
1496: FROM zx_rec_nrec_dist zx_dist,
1497: xla_distribution_links lnk,
1498: xla_ae_lines ael
1499: WHERE zx_dist.trx_id = c_trx_id
1500: AND zx_dist.APPLICATION_ID = c_application_id

Line 2165: FROM zx_rec_nrec_dist zx_dist,

2161: c_ae_header_id NUMBER,
2162: c_event_id NUMBER,
2163: c_ledger_id NUMBER) IS
2164: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2165: FROM zx_rec_nrec_dist zx_dist,
2166: xla_distribution_links lnk,
2167: xla_ae_headers aeh,
2168: xla_ae_lines ael
2169: WHERE zx_dist.trx_id = c_trx_id

Line 2197: FROM zx_rec_nrec_dist zx_dist,

2193: c_ae_header_id NUMBER,
2194: c_event_id NUMBER,
2195: c_ledger_id NUMBER) IS
2196: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2197: FROM zx_rec_nrec_dist zx_dist,
2198: xla_distribution_links lnk,
2199: xla_ae_headers aeh,
2200: xla_ae_lines ael
2201: WHERE zx_dist.trx_id = c_trx_id

Line 2231: FROM zx_rec_nrec_dist zx_dist,

2227: c_ae_header_id NUMBER,
2228: c_event_id NUMBER,
2229: c_ledger_id NUMBER) IS
2230: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2231: FROM zx_rec_nrec_dist zx_dist,
2232: xla_distribution_links lnk,
2233: xla_ae_headers aeh,
2234: xla_ae_lines ael
2235: WHERE zx_dist.trx_id = c_trx_id

Line 2264: FROM zx_rec_nrec_dist zx_dist,

2260: c_ae_header_id NUMBER,
2261: c_event_id NUMBER,
2262: c_ledger_id NUMBER) IS
2263: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2264: FROM zx_rec_nrec_dist zx_dist,
2265: xla_distribution_links lnk,
2266: xla_ae_headers aeh,
2267: xla_ae_lines ael
2268: WHERE zx_dist.trx_id = c_trx_id

Line 2295: FROM zx_rec_nrec_dist zx_dist,

2291: c_event_id NUMBER,
2292: c_ae_line_num NUMBER ) IS
2293: SELECT SUM( nvl(lnk.UNROUNDED_ENTERED_DR,0) - (nvl(lnk.UNROUNDED_ENTERED_CR,0) )) ,
2294: SUM( nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0) ))
2295: FROM zx_rec_nrec_dist zx_dist,
2296: xla_distribution_links lnk,
2297: xla_ae_lines ael
2298: WHERE zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
2299: AND lnk.application_id = 200

Line 2320: FROM zx_rec_nrec_dist zx_dist,

2316: SUM(decode(zx_dist.reverse_flag, 'Y',
2317: (abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)))*
2318: (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT)))),
2319: (nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))))
2320: FROM zx_rec_nrec_dist zx_dist,
2321: xla_distribution_links lnk,
2322: xla_ae_lines ael
2323: WHERE zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
2324: AND lnk.application_id = 200

Line 2339: FROM zx_rec_nrec_dist zx_dist,

2335: c_event_id NUMBER,
2336: c_tax_dist_id NUMBER ) IS
2337: SELECT SUM( (nvl(lnk.UNROUNDED_ENTERED_DR,0) - nvl(lnk.UNROUNDED_ENTERED_CR,0))),
2338: SUM( (nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)))
2339: FROM zx_rec_nrec_dist zx_dist,
2340: xla_distribution_links lnk,
2341: xla_ae_lines ael
2342: WHERE zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
2343: AND lnk.application_id = 200

Line 2376: FROM zx_rec_nrec_dist zx_dist,

2372: -- SELECT SUM( abs(nvl(lnk.UNROUNDED_ENTERED_DR,0) - (nvl(lnk.UNROUNDED_ENTERED_CR,0))) *
2373: -- (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT)))),
2374: -- SUM( abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))) *
2375: -- (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT))))
2376: FROM zx_rec_nrec_dist zx_dist,
2377: xla_distribution_links lnk,
2378: xla_ae_headers aeh,
2379: xla_ae_lines ael
2380: WHERE zx_dist.trx_id = c_trx_id

Line 2421: FROM zx_rec_nrec_dist zx_dist,

2417: SUM(decode(zx_dist.reverse_flag, 'Y',
2418: (abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)))*
2419: (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT)))),
2420: (nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))))
2421: FROM zx_rec_nrec_dist zx_dist,
2422: xla_ae_lines ael,
2423: xla_distribution_links lnk
2424: WHERE zx_dist.trx_id = c_trx_id
2425: AND zx_dist.APPLICATION_ID = c_application_id

Line 2727: zx_rec_nrec_dist zx_dist

2723: FROM ap_invoice_distributions_all aid,
2724: ap_invoice_payments_all aip,
2725: ap_payment_hist_dists aphd,
2726: ap_payment_history_all aph,
2727: zx_rec_nrec_dist zx_dist
2728: WHERE aid.invoice_id = p_trx_id
2729: AND aid.invoice_id = aip.invoice_id
2730: AND zx_dist.recoverable_flag = p_tax_rec_flag
2731: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 2844: zx_rec_nrec_dist zx_dist

2840: FROM ap_invoice_distributions_all aid,
2841: ap_invoice_payments_all aip,
2842: ap_payment_hist_dists aphd,
2843: ap_payment_history_all aph,
2844: zx_rec_nrec_dist zx_dist
2845: WHERE aid.invoice_id = p_trx_id
2846: AND aid.invoice_id = aip.invoice_id
2847: AND aid.tax_recoverable_flag = p_tax_rec_flag
2848: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 2979: zx_rec_nrec_dist zx_dist

2975: -- ap_invoices_all ai,
2976: ap_invoice_payments_all aip,
2977: ap_payment_hist_dists aphd,
2978: ap_payment_history_all aph,
2979: zx_rec_nrec_dist zx_dist
2980: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2981: AND aid.invoice_id = aip.invoice_id
2982: and ((zx_dist.trx_line_dist_id = aid.invoice_distribution_id) OR
2983: ((aid.line_type_lookup_code='IPV') and (zx_dist.trx_line_dist_id = aid.related_id)))