DBA Data[Home] [Help]

APPS.AR_CC_LOCKBOX dependencies on DUAL

Line 877: select l_customer_id from dual

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

Line 924: select l_customer_id from dual

920: where ps.trx_number = l_matching_number1
921: and ps.trx_date = l_resolved_matching1_date /* Bug fix 2926664 */
922: and (ps.customer_id IN
923: (
924: select l_customer_id from dual
925: union
926: select related_cust_account_id
927: from hz_cust_acct_relate rel
928: where rel.cust_account_id

Line 953: select l_customer_id from dual

949: 'N', 'OP',
950: ps.status))
951: AND (ps.customer_id IN
952: (
953: select l_customer_id from dual
954: union
955: select related_cust_account_id
956: from hz_cust_acct_relate rel
957: where rel.cust_account_id = l_customer_id

Line 1409: select l_customer_id from dual

1405: WHERE ps.trx_number = l_matching_number2
1406: AND ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1407: AND (ps.customer_id IN
1408: (
1409: select l_customer_id from dual
1410: union
1411: select related_cust_account_id
1412: from hz_cust_acct_relate rel
1413: where rel.cust_account_id = l_customer_id

Line 1456: select l_customer_id from dual

1452: where ps.trx_number = l_matching_number2
1453: and ps.trx_date = l_resolved_matching2_date /* Bug fix 2926664 */
1454: and (ps.customer_id IN
1455: (
1456: select l_customer_id from dual
1457: union
1458: select related_cust_account_id
1459: from hz_cust_acct_relate rel
1460: where rel.cust_account_id

Line 1485: select l_customer_id from dual

1481: 'N' , 'OP',
1482: ps.status))
1483: AND (ps.customer_id IN
1484: (
1485: select l_customer_id from dual
1486: union
1487: select related_cust_account_id
1488: from hz_cust_acct_relate rel
1489: where rel.cust_account_id = l_customer_id

Line 1933: select l_customer_id from dual

1929: WHERE ps.trx_number = l_matching_number3
1930: AND ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1931: AND (ps.customer_id IN
1932: (
1933: select l_customer_id from dual
1934: union
1935: select related_cust_account_id
1936: from hz_cust_acct_relate rel
1937: where rel.cust_account_id = l_customer_id

Line 1980: select l_customer_id from dual

1976: where ps.trx_number = l_matching_number3
1977: and ps.trx_date = l_resolved_matching3_date /* Bug fix 2926664 */
1978: and (ps.customer_id IN
1979: (
1980: select l_customer_id from dual
1981: union
1982: select related_cust_account_id
1983: from hz_cust_acct_relate rel
1984: where rel.cust_account_id

Line 2009: select l_customer_id from dual

2005: 'N','OP',
2006: ps.status))
2007: AND (ps.customer_id IN
2008: (
2009: select l_customer_id from dual
2010: union
2011: select related_cust_account_id
2012: from hz_cust_acct_relate rel
2013: where rel.cust_account_id = l_customer_id

Line 2463: select l_customer_id from dual

2459: WHERE ps.trx_number = l_matching_number4
2460: AND ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2461: AND (ps.customer_id IN
2462: (
2463: select l_customer_id from dual
2464: union
2465: select related_cust_account_id
2466: from hz_cust_acct_relate rel
2467: where rel.cust_account_id = l_customer_id

Line 2510: select l_customer_id from dual

2506: where ps.trx_number = l_matching_number4
2507: and ps.trx_date = l_resolved_matching4_date /* Bug fix 2926664 */
2508: and (ps.customer_id IN
2509: (
2510: select l_customer_id from dual
2511: union
2512: select related_cust_account_id
2513: from hz_cust_acct_relate rel
2514: where rel.cust_account_id

Line 2539: select l_customer_id from dual

2535: 'N' , 'OP',
2536: ps.status))
2537: AND (ps.customer_id IN
2538: (
2539: select l_customer_id from dual
2540: union
2541: select related_cust_account_id
2542: from hz_cust_acct_relate rel
2543: where rel.cust_account_id = l_customer_id

Line 2989: select l_customer_id from dual

2985: WHERE ps.trx_number = l_matching_number5
2986: AND ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
2987: AND (ps.customer_id IN
2988: (
2989: select l_customer_id from dual
2990: union
2991: select related_cust_account_id
2992: from hz_cust_acct_relate rel
2993: where rel.cust_account_id = l_customer_id

Line 3036: select l_customer_id from dual

3032: where ps.trx_number = l_matching_number5
3033: and ps.trx_date = l_resolved_matching5_date /* Bug fix 2926664 */
3034: and (ps.customer_id IN
3035: (
3036: select l_customer_id from dual
3037: union
3038: select related_cust_account_id
3039: from hz_cust_acct_relate rel
3040: where rel.cust_account_id

Line 3065: select l_customer_id from dual

3061: 'N', 'OP',
3062: ps.status))
3063: AND (ps.customer_id IN
3064: (
3065: select l_customer_id from dual
3066: union
3067: select related_cust_account_id
3068: from hz_cust_acct_relate rel
3069: where rel.cust_account_id = l_customer_id

Line 3514: select l_customer_id from dual

3510: WHERE ps.trx_number = l_matching_number6
3511: AND ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3512: AND (ps.customer_id IN
3513: (
3514: select l_customer_id from dual
3515: union
3516: select related_cust_account_id
3517: from hz_cust_acct_relate rel
3518: where rel.cust_account_id = l_customer_id

Line 3561: select l_customer_id from dual

3557: where ps.trx_number = l_matching_number6
3558: and ps.trx_date = l_resolved_matching6_date /* Bug fix 2926664 */
3559: and (ps.customer_id IN
3560: (
3561: select l_customer_id from dual
3562: union
3563: select related_cust_account_id
3564: from hz_cust_acct_relate rel
3565: where rel.cust_account_id

Line 3590: select l_customer_id from dual

3586: 'N', 'OP',
3587: ps.status))
3588: AND (ps.customer_id IN
3589: (
3590: select l_customer_id from dual
3591: union
3592: select related_cust_account_id
3593: from hz_cust_acct_relate rel
3594: where rel.cust_account_id = l_customer_id

Line 4038: select l_customer_id from dual

4034: WHERE ps.trx_number = l_matching_number7
4035: AND ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4036: AND (ps.customer_id IN
4037: (
4038: select l_customer_id from dual
4039: union
4040: select related_cust_account_id
4041: from hz_cust_acct_relate rel
4042: where rel.cust_account_id = l_customer_id

Line 4085: select l_customer_id from dual

4081: where ps.trx_number = l_matching_number7
4082: and ps.trx_date = l_resolved_matching7_date /* Bug fix 2926664 */
4083: and (ps.customer_id IN
4084: (
4085: select l_customer_id from dual
4086: union
4087: select related_cust_account_id
4088: from hz_cust_acct_relate rel
4089: where rel.cust_account_id

Line 4114: select l_customer_id from dual

4110: 'N' , 'OP',
4111: ps.status))
4112: AND (ps.customer_id IN
4113: (
4114: select l_customer_id from dual
4115: union
4116: select related_cust_account_id
4117: from hz_cust_acct_relate rel
4118: where rel.cust_account_id = l_customer_id

Line 4563: select l_customer_id from dual

4559: WHERE ps.trx_number = l_matching_number8
4560: AND ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4561: AND (ps.customer_id IN
4562: (
4563: select l_customer_id from dual
4564: union
4565: select related_cust_account_id
4566: from hz_cust_acct_relate rel
4567: where rel.cust_account_id = l_customer_id

Line 4610: select l_customer_id from dual

4606: where ps.trx_number = l_matching_number8
4607: and ps.trx_date = l_resolved_matching8_date /* Bug fix 2926664 */
4608: and (ps.customer_id IN
4609: (
4610: select l_customer_id from dual
4611: union
4612: select related_cust_account_id
4613: from hz_cust_acct_relate rel
4614: where rel.cust_account_id

Line 4639: select l_customer_id from dual

4635: 'N', 'OP',
4636: ps.status))
4637: AND (ps.customer_id IN
4638: (
4639: select l_customer_id from dual
4640: union
4641: select related_cust_account_id
4642: from hz_cust_acct_relate rel
4643: where rel.cust_account_id = l_customer_id