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_CUSTOMER_CALL_TOPICS

Line 2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,

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)
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

Line 2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)

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)
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

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 2490: --WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID

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
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id

Line 2491: WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID_1

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
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id
2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id

Line 2492: --and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id

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
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id
2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id
2496: AND car.party_id = cont_point.owner_table_id

Line 2493: and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id_1

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
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id
2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id
2496: AND car.party_id = cont_point.owner_table_id
2497: AND cont_point.owner_table_name = 'HZ_PARTIES'

Line 2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id

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
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id
2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id
2496: AND car.party_id = cont_point.owner_table_id
2497: AND cont_point.owner_table_name = 'HZ_PARTIES'
2498: AND cont_point.contact_point_type not in ('EDI','EMAIL','WEB')

Line 2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_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
2494: AND AR_CUSTOMER_CALL_TOPICS.PHONE_ID = cont_point.contact_point_id
2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id
2496: AND car.party_id = cont_point.owner_table_id
2497: AND cont_point.owner_table_name = 'HZ_PARTIES'
2498: AND cont_point.contact_point_type not in ('EDI','EMAIL','WEB')
2499: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_TRX_ID =

Line 2499: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_TRX_ID =

2495: AND AR_CUSTOMER_CALL_TOPICS.CONTACT_ID = car.cust_account_role_id
2496: AND car.party_id = cont_point.owner_table_id
2497: AND cont_point.owner_table_name = 'HZ_PARTIES'
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 =

Line 2501: AND AR_CUSTOMER_CALL_TOPICS.CUSTOMER_CALL_TOPIC_ID =

2497: AND cont_point.owner_table_name = 'HZ_PARTIES'
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,

Line 2503: AND AR_CUSTOMER_CALL_TOPICS.FOLLOW_UP_ACTION =

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
2507: ;

Line 2505: ORDER BY AR_CUSTOMER_CALL_TOPICS.CALL_DATE DESC,

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
2507: ;
2508:
2509: BEGIN

Line 2506: AR_CUSTOMER_CALL_TOPICS.CUSTOMER_CALL_ID DESC

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
2507: ;
2508:
2509: BEGIN
2510: