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

Line 877: select 'Exists from dual' from dual

873: WHERE ps.trx_number = l_matching_number1
874: AND ps.trx_date = l_resolved_matching1_date /* Bug fix 2926664 */
875: AND (EXISTS
876: (
877: select 'Exists from dual' from dual
878: where l_customer_id = ps.customer_id
879: union
880: select 'Exists from hz_cust_acct_relate'
881: from hz_cust_acct_relate rel

Line 927: select 'Exists from dual' from dual

923: where ps.trx_number = l_matching_number1
924: and ps.trx_date = l_resolved_matching1_date /* Bug fix 2926664 */
925: and (EXISTS
926: (
927: select 'Exists from dual' from dual
928: where l_customer_id = ps.customer_id
929: union
930: select 'Exists from hz_cust_acct_relate'
931: from hz_cust_acct_relate rel

Line 956: select 'Exists from dual' from dual

952: 'N', 'OP',
953: ps.status))
954: AND (EXISTS
955: (
956: select 'Exists from dual' from dual
957: where l_customer_id = ps.customer_id
958: union
959: select 'Exists from hz_cust_acct_relate'
960: from hz_cust_acct_relate rel

Line 1415: select 'Exists from dual' from dual

1411: WHERE ps.trx_number = l_matching_number2
1412: AND ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1413: AND (EXISTS
1414: (
1415: select 'Exists from dual' from dual
1416: where l_customer_id = ps.customer_id
1417: union
1418: select 'Exists from hz_cust_acct_relate'
1419: from hz_cust_acct_relate rel

Line 1465: select 'Exists from dual' from dual

1461: where ps.trx_number = l_matching_number2
1462: and ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1463: and (EXISTS /* subquery */
1464: (
1465: select 'Exists from dual' from dual
1466: where l_customer_id = ps.customer_id
1467: union
1468: select 'Exists from hz_cust_acct_relate'
1469: from hz_cust_acct_relate rel

Line 1494: select 'Exists from dual' from dual

1490: 'N' , 'OP',
1491: ps.status))
1492: and (EXISTS /* main query */
1493: (
1494: select 'Exists from dual' from dual
1495: where l_customer_id = ps.customer_id
1496: union
1497: select 'Exists from hz_cust_acct_relate'
1498: from hz_cust_acct_relate rel

Line 1945: select 'Exists from dual' from dual

1941: WHERE ps.trx_number = l_matching_number3
1942: AND ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1943: AND (EXISTS
1944: (
1945: select 'Exists from dual' from dual
1946: where l_customer_id = ps.customer_id
1947: union
1948: select 'Exists from hz_cust_acct_relate'
1949: from hz_cust_acct_relate rel

Line 1995: select 'Exists from dual' from dual

1991: where ps.trx_number = l_matching_number3
1992: and ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1993: and (EXISTS
1994: (
1995: select 'Exists from dual' from dual
1996: where l_customer_id = ps.customer_id
1997: union
1998: select 'Exists from hz_cust_acct_relate'
1999: from hz_cust_acct_relate rel

Line 2024: select 'Exists from dual' from dual

2020: 'N','OP',
2021: ps.status))
2022: and (EXISTS
2023: (
2024: select 'Exists from dual' from dual
2025: where l_customer_id = ps.customer_id
2026: union
2027: select 'Exists from hz_cust_acct_relate'
2028: from hz_cust_acct_relate rel

Line 2481: select 'Exists from dual' from dual

2477: WHERE ps.trx_number = l_matching_number4
2478: AND ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2479: AND (EXISTS
2480: (
2481: select 'Exists from dual' from dual
2482: where l_customer_id = ps.customer_id
2483: union
2484: select 'Exists from hz_cust_acct_relate'
2485: from hz_cust_acct_relate rel

Line 2531: select 'Exists from dual' from dual

2527: where ps.trx_number = l_matching_number4
2528: and ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2529: and (EXISTS
2530: (
2531: select 'Exists from dual' from dual
2532: where l_customer_id = ps.customer_id
2533: union
2534: select 'Exists from hz_cust_acct_relate'
2535: from hz_cust_acct_relate rel

Line 2560: select 'Exists from dual' from dual

2556: 'N' , 'OP',
2557: ps.status))
2558: and (EXISTS
2559: (
2560: select 'Exists from dual' from dual
2561: where l_customer_id = ps.customer_id
2562: union
2563: select 'Exists from hz_cust_acct_relate'
2564: from hz_cust_acct_relate rel

Line 3013: select 'Exists from dual' from dual

3009: WHERE ps.trx_number = l_matching_number5
3010: AND ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
3011: AND (EXISTS
3012: (
3013: select 'Exists from dual' from dual
3014: where l_customer_id = ps.customer_id
3015: union
3016: select 'Exists from hz_cust_acct_relate'
3017: from hz_cust_acct_relate rel

Line 3063: select 'Exists from dual' from dual

3059: where ps.trx_number = l_matching_number5
3060: and ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
3061: and (EXISTS
3062: (
3063: select 'Exists from dual' from dual
3064: where l_customer_id = ps.customer_id
3065: union
3066: select 'Exists from hz_cust_acct_relate'
3067: from hz_cust_acct_relate rel

Line 3092: select 'Exists from dual' from dual

3088: 'N', 'OP',
3089: ps.status))
3090: and (EXISTS
3091: (
3092: select 'Exists from dual' from dual
3093: where l_customer_id = ps.customer_id
3094: union
3095: select 'Exists from hz_cust_acct_relate'
3096: from hz_cust_acct_relate rel

Line 3544: select 'Exists from dual' from dual

3540: WHERE ps.trx_number = l_matching_number6
3541: AND ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3542: AND (EXISTS
3543: (
3544: select 'Exists from dual' from dual
3545: where l_customer_id = ps.customer_id
3546: union
3547: select 'Exists from hz_cust_acct_relate'
3548: from hz_cust_acct_relate rel

Line 3594: select 'Exists from dual' from dual

3590: where ps.trx_number = l_matching_number6
3591: and ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3592: and (EXISTS
3593: (
3594: select 'Exists from dual' from dual
3595: where l_customer_id = ps.customer_id
3596: union
3597: select 'Exists from hz_cust_acct_relate'
3598: from hz_cust_acct_relate rel

Line 3623: select 'Exists from dual' from dual

3619: 'N', 'OP',
3620: ps.status))
3621: and (EXISTS
3622: (
3623: select 'Exists from dual' from dual
3624: where l_customer_id = ps.customer_id
3625: union
3626: select 'Exists from hz_cust_acct_relate'
3627: from hz_cust_acct_relate rel

Line 4074: select 'Exists from dual' from dual

4070: WHERE ps.trx_number = l_matching_number7
4071: AND ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4072: AND (EXISTS
4073: (
4074: select 'Exists from dual' from dual
4075: where l_customer_id = ps.customer_id
4076: union
4077: select 'Exists from hz_cust_acct_relate'
4078: from hz_cust_acct_relate rel

Line 4124: select 'Exists from dual' from dual

4120: where ps.trx_number = l_matching_number7
4121: and ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4122: and (EXISTS
4123: (
4124: select 'Exists from dual' from dual
4125: where l_customer_id = ps.customer_id
4126: union
4127: select 'Exists from hz_cust_acct_relate'
4128: from hz_cust_acct_relate rel

Line 4153: select 'Exists from dual' from dual

4149: 'N' , 'OP',
4150: ps.status))
4151: and (EXISTS
4152: (
4153: select 'Exists from dual' from dual
4154: where l_customer_id = ps.customer_id
4155: union
4156: select 'Exists from hz_cust_acct_relate'
4157: from hz_cust_acct_relate rel

Line 4605: select 'Exists from dual' from dual

4601: WHERE ps.trx_number = l_matching_number8
4602: AND ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4603: AND (EXISTS
4604: (
4605: select 'Exists from dual' from dual
4606: where l_customer_id = ps.customer_id
4607: union
4608: select 'Exists from hz_cust_acct_relate'
4609: from hz_cust_acct_relate rel

Line 4655: select 'Exists from dual' from dual

4651: where ps.trx_number = l_matching_number8
4652: and ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4653: and (EXISTS
4654: (
4655: select 'Exists from dual' from dual
4656: where l_customer_id = ps.customer_id
4657: union
4658: select 'Exists from hz_cust_acct_relate'
4659: from hz_cust_acct_relate rel

Line 4684: select 'Exists from dual' from dual

4680: 'N', 'OP',
4681: ps.status))
4682: and (EXISTS
4683: (
4684: select 'Exists from dual' from dual
4685: where l_customer_id = ps.customer_id
4686: union
4687: select 'Exists from hz_cust_acct_relate'
4688: from hz_cust_acct_relate rel