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_CMGT_AGING dependencies on DUAL

Line 230: select p_party_id from dual

226: and hierarchy_type =
227: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
228: and pg_source_name <> 'LNS'
229: union
230: select p_party_id from dual
231: UNION
232: select hz_party_id
233: from LNS_LOAN_PARTICIPANTS_V
234: where loan_id = pg_source_id

Line 242: select p_customer_id from dual

238: (sysdate between start_date_active and end_date_active)
239: )
240: )
241: union
242: select p_customer_id from dual
243: )
244: and decode(p_site_use_id,
245: NULL, ps.customer_site_use_id,
246: p_site_use_id) = ps.customer_site_use_id

Line 373: select p_party_id from dual

369: and hierarchy_type =
370: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
371: and pg_source_name <> 'LNS'
372: union
373: select p_party_id from dual
374: UNION
375: select hz_party_id
376: from LNS_LOAN_PARTICIPANTS_V
377: where loan_id = pg_source_id

Line 385: select p_customer_id from dual

381: (sysdate between start_date_active and end_date_active)
382: )
383: )
384: union
385: select p_customer_id from dual
386: )
387: and decode(p_site_use_id,
388: NULL, ps.customer_site_use_id,
389: p_site_use_id) = ps.customer_site_use_id

Line 497: select p_party_id from dual

493: and hierarchy_type =
494: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
495: and pg_source_name <> 'LNS'
496: union
497: select p_party_id from dual
498: UNION
499: select hz_party_id
500: from LNS_LOAN_PARTICIPANTS_V
501: where loan_id = pg_source_id

Line 509: select p_customer_id from dual

505: (sysdate between start_date_active and end_date_active)
506: )
507: )
508: union
509: select p_customer_id from dual
510: )
511: and decode(p_site_use_id,
512: NULL, ps.customer_site_use_id,
513: p_site_use_id) = ps.customer_site_use_id

Line 640: select p_party_id from dual

636: and hierarchy_type =
637: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
638: and pg_source_name <> 'LNS'
639: union
640: select p_party_id from dual
641: UNION
642: select hz_party_id
643: from LNS_LOAN_PARTICIPANTS_V
644: where loan_id = pg_source_id

Line 652: select p_customer_id from dual

648: (sysdate between start_date_active and end_date_active)
649: )
650: )
651: union
652: select p_customer_id from dual
653: )
654: and decode(p_site_use_id,
655: NULL, ps.customer_site_use_id,
656: p_site_use_id) = ps.customer_site_use_id