APPS.AR_CC_LOCKBOX dependencies on HZ_CUST_ACCT_RELATE

Line 356: | hz_cust_acct_relate to specifically check

352: | trans_to_receipt_rate is zero.
353: | Fixed the problem by regarding zero-rate
354: | as null.
355: | 05/21/2001 Debbie Jancis Added bill_to_flag in all queries to
356: | hz_cust_acct_relate to specifically check
357: | for a Bill_to Relationship instead of
358: | just the existance of a record in the table
359: | 10/20/2001 Chelvi B. Bug 2066679 Instead of updating
360: | invoice2_status with AR_PLB_CURRENCY_BAD

Line 880: select 'Exists from hz_cust_acct_relate'

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
882: where rel.cust_account_id = l_customer_id
883: and related_cust_account_id = ps.customer_id
884: and rel.status = 'A'

Line 881: from hz_cust_acct_relate rel

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
882: where rel.cust_account_id = l_customer_id
883: and related_cust_account_id = ps.customer_id
884: and rel.status = 'A'
885: and rel.bill_to_flag = 'Y'

Line 930: select 'Exists from hz_cust_acct_relate'

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
932: where rel.cust_account_id = l_customer_id
933: and related_cust_account_id = ps.customer_id
934: and rel.status = 'A'

Line 931: from hz_cust_acct_relate rel

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
932: where rel.cust_account_id = l_customer_id
933: and related_cust_account_id = ps.customer_id
934: and rel.status = 'A'
935: and rel.bill_to_flag = 'Y'

Line 959: select 'Exists from hz_cust_acct_relate'

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
961: where rel.cust_account_id = l_customer_id
962: and related_cust_account_id = ps.customer_id
963: and rel.status = 'A'

Line 960: from hz_cust_acct_relate rel

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
961: where rel.cust_account_id = l_customer_id
962: and related_cust_account_id = ps.customer_id
963: and rel.status = 'A'
964: and rel.bill_to_flag = 'Y'

Line 1418: select 'Exists from hz_cust_acct_relate'

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
1420: where rel.cust_account_id = l_customer_id
1421: and related_cust_account_id = ps.customer_id
1422: and rel.status = 'A'

Line 1419: from hz_cust_acct_relate rel

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
1420: where rel.cust_account_id = l_customer_id
1421: and related_cust_account_id = ps.customer_id
1422: and rel.status = 'A'
1423: and rel.bill_to_flag = 'Y'

Line 1468: select 'Exists from hz_cust_acct_relate'

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
1470: where rel.cust_account_id = l_customer_id
1471: and related_cust_account_id = ps.customer_id
1472: and rel.status = 'A'

Line 1469: from hz_cust_acct_relate rel

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
1470: where rel.cust_account_id = l_customer_id
1471: and related_cust_account_id = ps.customer_id
1472: and rel.status = 'A'
1473: and rel.bill_to_flag = 'Y'

Line 1497: select 'Exists from hz_cust_acct_relate'

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
1499: where rel.cust_account_id = l_customer_id
1500: and related_cust_account_id = ps.customer_id
1501: and rel.status = 'A'

Line 1498: from hz_cust_acct_relate rel

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
1499: where rel.cust_account_id = l_customer_id
1500: and related_cust_account_id = ps.customer_id
1501: and rel.status = 'A'
1502: and rel.bill_to_flag = 'Y'

Line 1948: select 'Exists from hz_cust_acct_relate'

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
1950: where rel.cust_account_id = l_customer_id
1951: and related_cust_account_id = ps.customer_id
1952: and rel.status = 'A'

Line 1949: from hz_cust_acct_relate rel

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
1950: where rel.cust_account_id = l_customer_id
1951: and related_cust_account_id = ps.customer_id
1952: and rel.status = 'A'
1953: and rel.bill_to_flag = 'Y'

Line 1998: select 'Exists from hz_cust_acct_relate'

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
2000: where rel.cust_account_id = l_customer_id
2001: and related_cust_account_id = ps.customer_id
2002: and rel.status = 'A'

Line 1999: from hz_cust_acct_relate rel

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
2000: where rel.cust_account_id = l_customer_id
2001: and related_cust_account_id = ps.customer_id
2002: and rel.status = 'A'
2003: and rel.bill_to_flag = 'Y'

Line 2027: select 'Exists from hz_cust_acct_relate'

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
2029: where rel.cust_account_id = l_customer_id
2030: and related_cust_account_id = ps.customer_id
2031: and rel.status = 'A'

Line 2028: from hz_cust_acct_relate rel

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
2029: where rel.cust_account_id = l_customer_id
2030: and related_cust_account_id = ps.customer_id
2031: and rel.status = 'A'
2032: and rel.bill_to_flag = 'Y'

Line 2484: select 'Exists from hz_cust_acct_relate'

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
2486: where rel.cust_account_id = l_customer_id
2487: and related_cust_account_id = ps.customer_id
2488: and rel.status = 'A'

Line 2485: from hz_cust_acct_relate rel

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
2486: where rel.cust_account_id = l_customer_id
2487: and related_cust_account_id = ps.customer_id
2488: and rel.status = 'A'
2489: and rel.bill_to_flag = 'Y'

Line 2534: select 'Exists from hz_cust_acct_relate'

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
2536: where rel.cust_account_id = l_customer_id
2537: and related_cust_account_id = ps.customer_id
2538: and rel.status = 'A'

Line 2535: from hz_cust_acct_relate rel

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
2536: where rel.cust_account_id = l_customer_id
2537: and related_cust_account_id = ps.customer_id
2538: and rel.status = 'A'
2539: and rel.bill_to_flag = 'Y'

Line 2563: select 'Exists from hz_cust_acct_relate'

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
2565: where rel.cust_account_id = l_customer_id
2566: and related_cust_account_id = ps.customer_id
2567: and rel.status = 'A'

Line 2564: from hz_cust_acct_relate rel

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
2565: where rel.cust_account_id = l_customer_id
2566: and related_cust_account_id = ps.customer_id
2567: and rel.status = 'A'
2568: and rel.bill_to_flag = 'Y'

Line 3016: select 'Exists from hz_cust_acct_relate'

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
3018: where rel.cust_account_id = l_customer_id
3019: and related_cust_account_id = ps.customer_id
3020: and rel.status = 'A'

Line 3017: from hz_cust_acct_relate rel

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
3018: where rel.cust_account_id = l_customer_id
3019: and related_cust_account_id = ps.customer_id
3020: and rel.status = 'A'
3021: and rel.bill_to_flag = 'Y'

Line 3066: select 'Exists from hz_cust_acct_relate'

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
3068: where rel.cust_account_id = l_customer_id
3069: and related_cust_account_id = ps.customer_id
3070: and rel.status = 'A'

Line 3067: from hz_cust_acct_relate rel

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
3068: where rel.cust_account_id = l_customer_id
3069: and related_cust_account_id = ps.customer_id
3070: and rel.status = 'A'
3071: and rel.bill_to_flag = 'Y'

Line 3095: select 'Exists from hz_cust_acct_relate'

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
3097: where rel.cust_account_id = l_customer_id
3098: and related_cust_account_id = ps.customer_id
3099: and rel.status = 'A'

Line 3096: from hz_cust_acct_relate rel

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
3097: where rel.cust_account_id = l_customer_id
3098: and related_cust_account_id = ps.customer_id
3099: and rel.status = 'A'
3100: and rel.bill_to_flag = 'Y'

Line 3547: select 'Exists from hz_cust_acct_relate'

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
3549: where rel.cust_account_id = l_customer_id
3550: and related_cust_account_id = ps.customer_id
3551: and rel.status = 'A'

Line 3548: from hz_cust_acct_relate rel

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
3549: where rel.cust_account_id = l_customer_id
3550: and related_cust_account_id = ps.customer_id
3551: and rel.status = 'A'
3552: and rel.bill_to_flag = 'Y'

Line 3597: select 'Exists from hz_cust_acct_relate'

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
3599: where rel.cust_account_id = l_customer_id
3600: and related_cust_account_id = ps.customer_id
3601: and rel.status = 'A'

Line 3598: from hz_cust_acct_relate rel

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
3599: where rel.cust_account_id = l_customer_id
3600: and related_cust_account_id = ps.customer_id
3601: and rel.status = 'A'
3602: and rel.bill_to_flag = 'Y'

Line 3626: select 'Exists from hz_cust_acct_relate'

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
3628: where rel.cust_account_id = l_customer_id
3629: and related_cust_account_id = ps.customer_id
3630: and rel.status = 'A'

Line 3627: from hz_cust_acct_relate rel

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
3628: where rel.cust_account_id = l_customer_id
3629: and related_cust_account_id = ps.customer_id
3630: and rel.status = 'A'
3631: and rel.bill_to_flag = 'Y'

Line 4077: select 'Exists from hz_cust_acct_relate'

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
4079: where rel.cust_account_id = l_customer_id
4080: and related_cust_account_id = ps.customer_id
4081: and rel.status = 'A'

Line 4078: from hz_cust_acct_relate rel

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
4079: where rel.cust_account_id = l_customer_id
4080: and related_cust_account_id = ps.customer_id
4081: and rel.status = 'A'
4082: and rel.bill_to_flag = 'Y'

Line 4127: select 'Exists from hz_cust_acct_relate'

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
4129: where rel.cust_account_id = l_customer_id
4130: and related_cust_account_id = ps.customer_id
4131: and rel.status = 'A'

Line 4128: from hz_cust_acct_relate rel

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
4129: where rel.cust_account_id = l_customer_id
4130: and related_cust_account_id = ps.customer_id
4131: and rel.status = 'A'
4132: and rel.bill_to_flag = 'Y'

Line 4156: select 'Exists from hz_cust_acct_relate'

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
4158: where rel.cust_account_id = l_customer_id
4159: and related_cust_account_id = ps.customer_id
4160: and rel.status = 'A'

Line 4157: from hz_cust_acct_relate rel

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
4158: where rel.cust_account_id = l_customer_id
4159: and related_cust_account_id = ps.customer_id
4160: and rel.status = 'A'
4161: and rel.bill_to_flag = 'Y'

Line 4608: select 'Exists from hz_cust_acct_relate'

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
4610: where rel.cust_account_id = l_customer_id
4611: and related_cust_account_id = ps.customer_id
4612: and rel.status = 'A'

Line 4609: from hz_cust_acct_relate rel

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
4610: where rel.cust_account_id = l_customer_id
4611: and related_cust_account_id = ps.customer_id
4612: and rel.status = 'A'
4613: and rel.bill_to_flag = 'Y'

Line 4658: select 'Exists from hz_cust_acct_relate'

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
4660: where rel.cust_account_id = l_customer_id
4661: and related_cust_account_id = ps.customer_id
4662: and rel.status = 'A'

Line 4659: from hz_cust_acct_relate rel

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
4660: where rel.cust_account_id = l_customer_id
4661: and related_cust_account_id = ps.customer_id
4662: and rel.status = 'A'
4663: and rel.bill_to_flag = 'Y'

Line 4687: select 'Exists from hz_cust_acct_relate'

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
4689: where rel.cust_account_id = l_customer_id
4690: and related_cust_account_id = ps.customer_id
4691: and rel.status = 'A'

Line 4688: from hz_cust_acct_relate rel

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
4689: where rel.cust_account_id = l_customer_id
4690: and related_cust_account_id = ps.customer_id
4691: and rel.status = 'A'
4692: and rel.bill_to_flag = 'Y'