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

Line 283: select p_party_id from dual

279: and hierarchy_type =
280: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
281: and g_source_name <> 'LNS'
282: UNION
283: select p_party_id from dual
284: UNION
285: select hz_party_id
286: from LNS_LOAN_PARTICIPANTS_V
287: where loan_id = g_source_id

Line 504: union select :5 from dual

500: and effective_end_date >= sysdate
501: and hierarchy_type =
502: FND_PROFILE.VALUE(''AR_CMGT_HIERARCHY_TYPE'')
503: and :4 <> ''LNS''
504: union select :5 from dual
505: union
506: select hz_party_id
507: from LNS_LOAN_PARTICIPANTS_V
508: where loan_id = :6

Line 585: union select :4 from dual

581: and effective_start_date <= sysdate
582: and effective_end_date >= sysdate
583: and hierarchy_type =
584: FND_PROFILE.VALUE(''AR_CMGT_HIERARCHY_TYPE'')
585: union select :4 from dual
586: ))
587: and currency = :5
588: and largest_inv_cust_trx_id is not null
589: and as_of_date >= ADD_MONTHS(sysdate,(-:6)) )

Line 744: (max) at one time, then substr them out to individual

740: BEGIN
741:
742: /* 6513911 - revised sql to not require all currencies
743: This code now selects the converted amount and date
744: (max) at one time, then substr them out to individual
745: fields for the datapoint(s). Incidentally, the original
746: logic returned the raw amount (in AR_TRX_SUMMARY currency)
747: rather than the converted amount -- I considered this a bug
748: and now return the converted amount (to CF currency) */

Line 776: SELECT p_party_id FROM DUAL

772: AND hierarchy_type =
773: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
774: AND g_source_name <> 'LNS'
775: UNION
776: SELECT p_party_id FROM DUAL
777: UNION
778: SELECT hz_party_id
779: FROM LNS_LOAN_PARTICIPANTS_V
780: WHERE loan_id = g_source_id

Line 898: union select p_party_id from dual

894: and effective_start_date <= sysdate
895: and effective_end_date >= sysdate
896: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
897: and g_source_name <> 'LNS'
898: union select p_party_id from dual
899: UNION
900: select hz_party_id
901: from LNS_LOAN_PARTICIPANTS_V
902: where loan_id = g_source_id

Line 931: union select p_party_id from dual

927: and effective_start_date <= sysdate
928: and effective_end_date >= sysdate
929: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
930: and g_source_name <> 'LNS'
931: union select p_party_id from dual
932: UNION
933: select hz_party_id
934: from LNS_LOAN_PARTICIPANTS_V
935: where loan_id = g_source_id

Line 1150: union select p_party_id from dual

1146: and effective_end_date >= sysdate
1147: and hierarchy_type =
1148: FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
1149: and g_source_name <> 'LNS'
1150: union select p_party_id from dual
1151: UNION
1152: select hz_party_id
1153: from LNS_LOAN_PARTICIPANTS_V
1154: where loan_id = g_source_id

Line 2815: FROM dual;

2811: g_data_case_folder_exists := 'N';
2812: -- Get id from sequence
2813: SELECT ar_cmgt_case_folders_s.nextval
2814: INTO p_case_folder_id
2815: FROM dual;
2816:
2817: IF pg_wf_debug = 'Y'
2818: THEN
2819: ar_cmgt_util.wf_debug(p_case_folder_id,

Line 2828: FROM dual;

2824: IF p_case_folder_number IS NULL
2825: THEN
2826: SELECT ar_cmgt_case_folder_number_s.nextval
2827: INTO l_case_folder_number
2828: FROM dual;
2829: ELSE
2830: l_case_folder_number := p_case_folder_number;
2831: END IF;
2832: -- insert into case_folder table

Line 2894: FROM dual;

2890: WHEN NO_DATA_FOUND THEN
2891: BEGIN
2892: SELECT ar_cmgt_case_folders_s.nextval
2893: INTO g_data_case_folder_id
2894: FROM dual;
2895: g_data_case_folder_exists := 'N';
2896: AR_CMGT_CONTROLS.populate_case_folder (
2897: p_case_folder_id => g_data_case_folder_id,
2898: p_case_folder_number => l_case_folder_number,

Line 4881: union select p_party_id from dual

4877: and effective_start_date <= sysdate
4878: and effective_end_date >= sysdate
4879: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
4880: and g_source_name <> 'LNS'
4881: union select p_party_id from dual
4882: UNION
4883: select hz_party_id
4884: from LNS_LOAN_PARTICIPANTS_V
4885: where loan_id = g_source_id

Line 5253: union select p_party_id from dual

5249: and effective_start_date <= sysdate
5250: and effective_end_date >= sysdate
5251: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5252: and g_source_name <> 'LNS'
5253: union select p_party_id from dual
5254: UNION
5255: select hz_party_id
5256: from LNS_LOAN_PARTICIPANTS_V
5257: where loan_id = g_source_id

Line 5507: union select p_party_id from dual

5503: and effective_start_date <= sysdate
5504: and effective_end_date >= sysdate
5505: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5506: and g_source_name <> 'LNS'
5507: union select p_party_id from dual
5508: UNION
5509: select hz_party_id
5510: from LNS_LOAN_PARTICIPANTS_V
5511: where loan_id = g_source_id

Line 5611: union select p_party_id from dual

5607: and effective_start_date <= sysdate
5608: and effective_end_date >= sysdate
5609: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
5610: and g_source_name <> 'LNS'
5611: union select p_party_id from dual
5612: UNION
5613: select hz_party_id
5614: from LNS_LOAN_PARTICIPANTS_V
5615: where loan_id = g_source_id

Line 6295: union select p_party_id from dual

6291: and effective_start_date <= sysdate
6292: and effective_end_date >= sysdate
6293: and hierarchy_type = FND_PROFILE.VALUE('AR_CMGT_HIERARCHY_TYPE')
6294: and g_source_name <> 'LNS'
6295: union select p_party_id from dual
6296: UNION
6297: select hz_party_id
6298: from LNS_LOAN_PARTICIPANTS_V
6299: where loan_id = g_source_id