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.AR_ARXCCS_XMLP_PKG dependencies on AR_ADJUSTMENTS

Line 572: from ar_adjustments,

568: count(adjustment_id)
569: into l_ytd_finance_charge_amount,
570: l_ytd_convert_finance_charge,
571: l_ytd_finance_charge_count
572: from ar_adjustments,
573: ar_receivables_trx,
574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id

Line 575: where ar_adjustments.payment_schedule_id=

571: l_ytd_finance_charge_count
572: from ar_adjustments,
573: ar_receivables_trx,
574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id

Line 579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id

575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id

Line 581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate

577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id
584: and ar_payment_schedules.customer_id=customer_id_1
585: ;

Line 582: and nvl(ar_adjustments.postable,'Y')='Y'

578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id
584: and ar_payment_schedules.customer_id=customer_id_1
585: ;
586:

Line 587: select nvl(sum(ar_adjustments.amount), 0),

583: --and ar_payment_schedules.customer_id=customer_id
584: and ar_payment_schedules.customer_id=customer_id_1
585: ;
586:
587: select nvl(sum(ar_adjustments.amount), 0),
588: nvl(max(decode(ar_payment_schedules.invoice_currency_code,
589: functional_currency, ' ',
590: decode(ar_payment_schedules.exchange_rate,
591: NULL, '*', ' '))), ' ')

Line 594: from ar_adjustments,

590: decode(ar_payment_schedules.exchange_rate,
591: NULL, '*', ' '))), ' ')
592: into l_ytd_writeoff_amount,
593: l_ytd_convert_writeoff
594: from ar_adjustments,
595: ar_lookups lk,
596: ar_payment_schedules
597: where ar_adjustments.reason_code
598: = lk.lookup_code(+)

Line 597: where ar_adjustments.reason_code

593: l_ytd_convert_writeoff
594: from ar_adjustments,
595: ar_lookups lk,
596: ar_payment_schedules
597: where ar_adjustments.reason_code
598: = lk.lookup_code(+)
599: and lk.lookup_code(+) = 'WRITE OFF'
600: and lk.lookup_type(+) = 'ADJUST_REASON'
601: --and ar_payment_schedules.customer_id = customer_id

Line 605: and ar_adjustments.payment_schedule_id =

601: --and ar_payment_schedules.customer_id = customer_id
602: and ar_payment_schedules.customer_id = customer_id_1
603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id
607: and ar_adjustments.apply_date between
608: add_months(sysdate, -12) and sysdate
609: and nvl(ar_adjustments.postable, 'Y') = 'Y'

Line 607: and ar_adjustments.apply_date between

603: and ar_payment_schedules.customer_site_use_id = site_use_id
604: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id
607: and ar_adjustments.apply_date between
608: add_months(sysdate, -12) and sysdate
609: and nvl(ar_adjustments.postable, 'Y') = 'Y'
610: ;
611:

Line 609: and nvl(ar_adjustments.postable, 'Y') = 'Y'

605: and ar_adjustments.payment_schedule_id =
606: ar_payment_schedules.payment_schedule_id
607: and ar_adjustments.apply_date between
608: add_months(sysdate, -12) and sysdate
609: and nvl(ar_adjustments.postable, 'Y') = 'Y'
610: ;
611:
612: select nvl(sum(ar_receivable_applications.earned_discount_taken ), 0) earned,
613: nvl(max(decode(nvl(ar_receivable_applications.earned_discount_taken, 0),

Line 1931: AR_ADJUSTMENTS.AMOUNT,

1927: CURSOR C_ADJUSTMENT IS
1928: SELECT LK.MEANING,
1929: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
1930: ar_payment_schedules.invoice_currency_code,
1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)

Line 1934: AR_ADJUSTMENTS.APPLY_DATE,

1930: ar_payment_schedules.invoice_currency_code,
1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES

Line 1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)

1931: AR_ADJUSTMENTS.AMOUNT,
1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)

Line 1936: FROM AR_ADJUSTMENTS,

1932: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
1933: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
1934: AR_ADJUSTMENTS.APPLY_DATE,
1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'

Line 1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)

1935: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
1936: FROM AR_ADJUSTMENTS,
1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'

Line 1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =

1937: AR_LOOKUPS LK,
1938: AR_PAYMENT_SCHEDULES
1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id

Line 1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'

1939: WHERE AR_ADJUSTMENTS.REASON_CODE = LK.LOOKUP_CODE (+)
1940: AND LK.LOOKUP_TYPE = 'ADJUST_REASON'
1941: AND AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID =
1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
1947: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC

Line 1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,

1942: AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID
1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
1947: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
1948: ;
1949:
1950:

Line 1947: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC

1943: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
1944: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
1945: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
1946: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
1947: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
1948: ;
1949:
1950:
1951: BEGIN

Line 2028: AR_ADJUSTMENTS.AMOUNT,

2024: CURSOR C_WRITEOFF IS
2025: SELECT LK.LOOKUP_CODE,
2026: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)

Line 2031: AR_ADJUSTMENTS.APPLY_DATE,

2027: AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE,
2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES

Line 2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)

2028: AR_ADJUSTMENTS.AMOUNT,
2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE

Line 2033: FROM AR_ADJUSTMENTS,

2029: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2030: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' ')),
2031: AR_ADJUSTMENTS.APPLY_DATE,
2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)

Line 2036: WHERE AR_ADJUSTMENTS.REASON_CODE

2032: ROUND(TRUNC(SYSDATE) - AR_ADJUSTMENTS.APPLY_DATE)
2033: FROM AR_ADJUSTMENTS,
2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)
2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'

Line 2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID

2034: AR_LOOKUPS LK,
2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)
2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'
2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID

Line 2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'

2035: AR_PAYMENT_SCHEDULES
2036: WHERE AR_ADJUSTMENTS.REASON_CODE
2037: = LK.LOOKUP_CODE(+)
2038: AND AR_ADJUSTMENTS.CUSTOMER_TRX_ID = AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
2039: AND NVL(AR_ADJUSTMENTS.POSTABLE, 'Y') = 'Y'
2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'
2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
2043: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id

Line 2044: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,

2040: AND LK.LOOKUP_CODE(+) = 'WRITE OFF'
2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
2043: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
2044: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
2045: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
2046: ;
2047:
2048: BEGIN

Line 2045: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC

2041: AND LK.LOOKUP_TYPE(+) = 'ADJUST_REASON'
2042: AND AR_PAYMENT_SCHEDULES.CUSTOMER_ID = CUSTOMER_ID
2043: AND AR_PAYMENT_SCHEDULES.CUSTOMER_SITE_USE_ID = site_use_id
2044: ORDER BY AR_ADJUSTMENTS.CREATION_DATE DESC,
2045: AR_ADJUSTMENTS.ADJUSTMENT_ID DESC
2046: ;
2047:
2048: BEGIN
2049: