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_CALL_ACTIONS

Line 2481: AR_CALL_ACTIONS.ACTION_AMOUNT,

2477: 'TLX', cont_point.telex_number,
2478: cont_point.phone_number),15)),
2479: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,
2481: AR_CALL_ACTIONS.ACTION_AMOUNT,
2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,
2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),
2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,

Line 2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,

2478: cont_point.phone_number),15)),
2479: AR_PAYMENT_SCHEDULES.TRX_NUMBER,
2480: AR_PAYMENT_SCHEDULES.invoice_currency_code,
2481: AR_CALL_ACTIONS.ACTION_AMOUNT,
2482: DECODE(AR_CALL_ACTIONS.ACTION_AMOUNT, NULL, NULL,
2483: DECODE(AR_PAYMENT_SCHEDULES.INVOICE_CURRENCY_CODE, functional_currency, ' ',
2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),
2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)

Line 2489: AR_PAYMENT_SCHEDULES, AR_CUSTOMER_CALL_TOPICS, AR_CALL_ACTIONS

2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)
2487: FROM hz_contact_points cont_point,
2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,
2489: AR_PAYMENT_SCHEDULES, AR_CUSTOMER_CALL_TOPICS, AR_CALL_ACTIONS
2490: --WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID
2491: WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID_1
2492: --and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id
2493: and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id_1

Line 2502: AR_CALL_ACTIONS.CUSTOMER_CALL_TOPIC_ID (+)

2498: AND cont_point.contact_point_type not in ('EDI','EMAIL','WEB')
2499: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_TRX_ID =
2500: AR_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID (+)
2501: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_CALL_TOPIC_ID =
2502: AR_CALL_ACTIONS.CUSTOMER_CALL_TOPIC_ID (+)
2503: AND AR_CUSTOMER_CALL_TOPICS.FOLLOW_UP_ACTION =
2504: LKUPS.LOOKUP_CODE (+)
2505: ORDER BY AR_CUSTOMER_CALL_TOPICS.CALL_DATE DESC,
2506: AR_CUSTOMER_CALL_TOPICS.CUSTOMER_CALL_ID DESC