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_AR_POPULATE_PKG dependencies on AR_DISTRIBUTIONS_ALL

Line 1415: FROM AR_DISTRIBUTIONS_ALL ARDTAX,

1411: C_TAX_ID IN NUMBER ) IS
1412: SELECT SUM(NVL(ARDTAX.AMOUNT_CR,0) - NVL(ARDTAX.AMOUNT_DR,0)),
1413: SUM(NVL(ARDTAX.TAXABLE_ENTERED_CR,0) -
1414: NVL(ARDTAX.TAXABLE_ENTERED_DR,0))
1415: FROM AR_DISTRIBUTIONS_ALL ARDTAX,
1416: AR_RECEIVABLE_APPLICATIONS_ALL APP,
1417: RA_CUSTOMER_TRX_ALL TRXCM
1418: WHERE TRXCM.CUSTOMER_TRX_ID = C_TRX_ID
1419: AND APP.APPLIED_CUSTOMER_TRX_ID = TRXCM.CUSTOMER_TRX_ID

Line 2567: FROM ar_distributions_all dist,

2563:
2564: CURSOR trx_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2565: SELECT
2566: ael.code_combination_id
2567: FROM ar_distributions_all dist,
2568: xla_distribution_links lnk,
2569: xla_ae_lines ael
2570: WHERE dist.line_id = p_actg_source_id
2571: AND lnk.application_id = 222

Line 2572: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2568: xla_distribution_links lnk,
2569: xla_ae_lines ael
2570: WHERE dist.line_id = p_actg_source_id
2571: AND lnk.application_id = 222
2572: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2573: AND lnk.source_distribution_id_num_1 = dist.line_id
2574: AND lnk.ae_header_id = ael.ae_header_id
2575: AND lnk.ae_line_num = ael.ae_line_num
2576: AND lnk.event_id = c_event_id

Line 2583: FROM ar_distributions_all dist,

2579: AND rownum =1;
2580:
2581: CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2582: SELECT ael.code_combination_id
2583: FROM ar_distributions_all dist,
2584: ar_distributions_all taxdist,
2585: xla_distribution_links lnk,
2586: xla_ae_lines ael
2587: WHERE taxdist.line_id = p_actg_source_id

Line 2584: ar_distributions_all taxdist,

2580:
2581: CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2582: SELECT ael.code_combination_id
2583: FROM ar_distributions_all dist,
2584: ar_distributions_all taxdist,
2585: xla_distribution_links lnk,
2586: xla_ae_lines ael
2587: WHERE taxdist.line_id = p_actg_source_id
2588: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')

Line 2593: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2589: AND dist.tax_link_id = taxdist.tax_link_id
2590: AND dist.source_id = taxdist.source_id
2591: AND lnk.source_distribution_id_num_1 = dist.line_id
2592: AND lnk.application_id = 222
2593: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2594: AND lnk.ae_header_id = ael.ae_header_id
2595: AND lnk.ae_line_num = ael.ae_line_num
2596: AND lnk.event_id = c_event_id
2597: AND lnk.ae_header_id = c_ae_header_id

Line 2603: FROM ar_distributions_all dist,

2599: AND rownum =1;
2600:
2601: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2602: SELECT ael.code_combination_id
2603: FROM ar_distributions_all dist,
2604: ar_distributions_all taxdist,
2605: xla_distribution_links lnk,
2606: xla_ae_lines ael
2607: WHERE dist.line_id = p_actg_source_id

Line 2604: ar_distributions_all taxdist,

2600:
2601: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2602: SELECT ael.code_combination_id
2603: FROM ar_distributions_all dist,
2604: ar_distributions_all taxdist,
2605: xla_distribution_links lnk,
2606: xla_ae_lines ael
2607: WHERE dist.line_id = p_actg_source_id
2608: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')

Line 2613: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2609: AND dist.tax_link_id = taxdist.tax_link_id
2610: AND dist.source_id = taxdist.source_id
2611: AND lnk.source_distribution_id_num_1 = taxdist.line_id
2612: AND lnk.application_id = 222
2613: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2614: AND lnk.ae_header_id = ael.ae_header_id
2615: AND lnk.ae_line_num = ael.ae_line_num
2616: AND lnk.event_id = c_event_id
2617: AND lnk.ae_header_id = c_ae_header_id

Line 2624: FROM ar_distributions_all taxdist,

2620:
2621: CURSOR tax_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2622: SELECT
2623: ael.code_combination_id
2624: FROM ar_distributions_all taxdist,
2625: xla_distribution_links lnk,
2626: xla_ae_lines ael
2627: WHERE taxdist.line_id = p_actg_source_id
2628: AND lnk.application_id = 222

Line 2629: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2625: xla_distribution_links lnk,
2626: xla_ae_lines ael
2627: WHERE taxdist.line_id = p_actg_source_id
2628: AND lnk.application_id = 222
2629: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2630: AND lnk.source_distribution_id_num_1 = taxdist.line_id
2631: AND lnk.ae_header_id = ael.ae_header_id
2632: AND lnk.ae_line_num = ael.ae_line_num
2633: AND lnk.event_id = c_event_id

Line 2926: FROM AR_DISTRIBUTIONS_ALL

2922: ELSE -- Adjustments for Tax Reconciliation Report ---
2923:
2924: BEGIN
2925: SELECT CODE_COMBINATION_ID INTO l_ccid
2926: FROM AR_DISTRIBUTIONS_ALL
2927: WHERE LINE_ID = P_ACTG_SOURCE_ID;
2928: --SOURCE_ID = P_TRX_LINE_ID
2929:
2930: agt_actg_line_ccid(j) := l_ccid;

Line 2987: FROM AR_DISTRIBUTIONS_ALL

2983:
2984: /* IF P_TRX_LINE_ID IS NOT NULL THEN
2985: BEGIN
2986: SELECT CODE_COMBINATION_ID INTO l_ccid
2987: FROM AR_DISTRIBUTIONS_ALL
2988: WHERE LINE_ID = P_TRX_LINE_ID;
2989: --SOURCE_ID = P_TRX_ID
2990:
2991:

Line 3123: FROM ar_distributions_all dist,

3119: -- Transaction Header Level
3120: CURSOR taxable_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3121: c_event_id NUMBER,c_ledger_id NUMBER) IS
3122: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3123: FROM ar_distributions_all dist,
3124: xla_distribution_links lnk,
3125: xla_ae_headers aeh,
3126: xla_ae_lines ael
3127: WHERE dist.line_id = c_actg_source_id

Line 3129: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3125: xla_ae_headers aeh,
3126: xla_ae_lines ael
3127: WHERE dist.line_id = c_actg_source_id
3128: AND lnk.application_id = 222
3129: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3130: AND lnk.source_distribution_id_num_1 = dist.line_id
3131: AND lnk.ae_header_id = c_ae_header_id
3132: AND lnk.event_id = c_event_id
3133: AND lnk.ae_line_num = ael.ae_line_num

Line 3144: FROM AR_DISTRIBUTIONS_ALL dist,

3140:
3141: CURSOR tax_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3142: c_event_id NUMBER,c_ledger_id NUMBER) IS
3143: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3144: FROM AR_DISTRIBUTIONS_ALL dist,
3145: AR_DISTRIBUTIONS_ALL taxdist,
3146: xla_distribution_links lnk,
3147: xla_ae_headers aeh,
3148: xla_ae_lines ael

Line 3145: AR_DISTRIBUTIONS_ALL taxdist,

3141: CURSOR tax_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3142: c_event_id NUMBER,c_ledger_id NUMBER) IS
3143: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3144: FROM AR_DISTRIBUTIONS_ALL dist,
3145: AR_DISTRIBUTIONS_ALL taxdist,
3146: xla_distribution_links lnk,
3147: xla_ae_headers aeh,
3148: xla_ae_lines ael
3149: WHERE dist.line_id = c_actg_source_id

Line 3155: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3151: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
3152: AND taxdist.source_id = dist.source_id
3153: AND lnk.source_distribution_id_num_1 = taxdist.line_id
3154: AND lnk.application_id = 222
3155: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3156: AND lnk.ae_header_id = c_ae_header_id
3157: AND lnk.event_id = c_event_id
3158: AND lnk.ae_line_num = ael.ae_line_num
3159: AND aeh.ae_header_id = ael.ae_header_id

Line 3170: FROM AR_DISTRIBUTIONS_ALL dist,

3166: -- Transaction Distribution Level
3167:
3168: CURSOR taxable_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
3169: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3170: FROM AR_DISTRIBUTIONS_ALL dist,
3171: AR_DISTRIBUTIONS_ALL taxdist,
3172: xla_distribution_links lnk,
3173: xla_ae_headers aeh,
3174: xla_ae_lines ael

Line 3171: AR_DISTRIBUTIONS_ALL taxdist,

3167:
3168: CURSOR taxable_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
3169: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3170: FROM AR_DISTRIBUTIONS_ALL dist,
3171: AR_DISTRIBUTIONS_ALL taxdist,
3172: xla_distribution_links lnk,
3173: xla_ae_headers aeh,
3174: xla_ae_lines ael
3175: WHERE taxdist.line_id = c_actg_source_id

Line 3181: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3177: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
3178: AND taxdist.source_id = dist.source_id
3179: AND lnk.source_distribution_id_num_1 = dist.line_id
3180: AND lnk.application_id = 222
3181: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3182: AND lnk.ae_header_id = c_ae_header_id
3183: AND lnk.event_id = c_event_id
3184: AND lnk.ae_line_num = ael.ae_line_num
3185: AND aeh.ae_header_id = ael.ae_header_id

Line 3194: FROM ar_distributions_all taxdist,

3190:
3191: CURSOR tax_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3192: c_event_id NUMBER,c_ledger_id NUMBER) IS
3193: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3194: FROM ar_distributions_all taxdist,
3195: xla_distribution_links lnk,
3196: xla_ae_headers aeh,
3197: xla_ae_lines ael
3198: WHERE taxdist.line_id = c_actg_source_id

Line 3200: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3196: xla_ae_headers aeh,
3197: xla_ae_lines ael
3198: WHERE taxdist.line_id = c_actg_source_id
3199: AND lnk.application_id = 222
3200: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3201: AND lnk.source_distribution_id_num_1 = taxdist.line_id
3202: AND lnk.ae_header_id = c_ae_header_id
3203: AND lnk.event_id = c_event_id
3204: AND lnk.ae_line_num = ael.ae_line_num