[Home] [Help]
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
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
882: and rel.status = 'A'
883: and rel.bill_to_flag = 'Y'
884: union
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
929: = l_customer_id
930: and rel.status = 'A'
931: and rel.bill_to_flag = 'Y'
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
958: and rel.status = 'A'
959: and rel.bill_to_flag = 'Y'
960: union
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
1414: and rel.status = 'A'
1415: and rel.bill_to_flag = 'Y'
1416: union
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
1461: = l_customer_id
1462: and rel.status = 'A'
1463: and rel.bill_to_flag = 'Y'
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
1490: and rel.status = 'A'
1491: and rel.bill_to_flag = 'Y'
1492: union
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
1938: and rel.status = 'A'
1939: and rel.bill_to_flag = 'Y'
1940: union
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
1985: = l_customer_id
1986: and rel.status = 'A'
1987: and rel.bill_to_flag = 'Y'
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
2014: and rel.status = 'A'
2015: and rel.bill_to_flag = 'Y'
2016: union
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
2468: and rel.status = 'A'
2469: and rel.bill_to_flag = 'Y'
2470: union
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
2515: = l_customer_id
2516: and rel.status = 'A'
2517: and rel.bill_to_flag = 'Y'
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
2544: and rel.status = 'A'
2545: and rel.bill_to_flag = 'Y'
2546: union
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
2994: and rel.status = 'A'
2995: and rel.bill_to_flag = 'Y'
2996: union
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
3041: = l_customer_id
3042: and rel.status = 'A'
3043: and rel.bill_to_flag = 'Y'
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
3070: and rel.status = 'A'
3071: and rel.bill_to_flag = 'Y'
3072: union
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
3519: and rel.status = 'A'
3520: and rel.bill_to_flag = 'Y'
3521: union
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
3566: = l_customer_id
3567: and rel.status = 'A'
3568: and rel.bill_to_flag = 'Y'
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
3595: and rel.status = 'A'
3596: and rel.bill_to_flag = 'Y'
3597: union
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
4043: and rel.status = 'A'
4044: and rel.bill_to_flag = 'Y'
4045: union
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
4090: = l_customer_id
4091: and rel.status = 'A'
4092: and rel.bill_to_flag = 'Y'
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
4119: and rel.status = 'A'
4120: and rel.bill_to_flag = 'Y'
4121: union
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
4568: and rel.status = 'A'
4569: and rel.bill_to_flag = 'Y'
4570: union
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
4615: = l_customer_id
4616: and rel.status = 'A'
4617: and rel.bill_to_flag = 'Y'
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
4644: and rel.status = 'A'
4645: and rel.bill_to_flag = 'Y'
4646: union