[Home] [Help]
885: and rel.bill_to_flag = 'Y'
886: union
887: select 'Exists ar_paying_relationships_v'
888: from ar_paying_relationships_v rel,
889: hz_cust_accounts acc
890: where rel.party_id = acc.party_id
891: and acc.cust_account_id = l_customer_id
892: and rel.related_cust_account_id = ps.customer_id
893: and l_receipt_date BETWEEN effective_start_date
935: and rel.bill_to_flag = 'Y'
936: union
937: select 'Exists ar_paying_relationships_v'
938: from ar_paying_relationships_v rel,
939: hz_cust_accounts acc
940: where rel.party_id = acc.party_id
941: and acc.cust_account_id = l_customer_id
942: and rel.related_cust_account_id = ps.customer_id
943: and l_receipt_date BETWEEN effective_start_date
964: and rel.bill_to_flag = 'Y'
965: union
966: select 'Exists ar_paying_relationships_v'
967: from ar_paying_relationships_v rel,
968: hz_cust_accounts acc
969: where rel.party_id = acc.party_id
970: and acc.cust_account_id = l_customer_id
971: and rel.related_cust_account_id = ps.customer_id
972: and l_receipt_date BETWEEN effective_start_date
1423: and rel.bill_to_flag = 'Y'
1424: union
1425: select 'Exists ar_paying_relationships_v'
1426: from ar_paying_relationships_v rel,
1427: hz_cust_accounts acc
1428: where rel.party_id = acc.party_id
1429: and acc.cust_account_id = l_customer_id
1430: and rel.related_cust_account_id = ps.customer_id
1431: and l_receipt_date BETWEEN effective_start_date
1473: and rel.bill_to_flag = 'Y'
1474: union
1475: select 'Exists ar_paying_relationships_v'
1476: from ar_paying_relationships_v rel,
1477: hz_cust_accounts acc
1478: where rel.party_id = acc.party_id
1479: and acc.cust_account_id = l_customer_id
1480: and rel.related_cust_account_id = ps.customer_id
1481: and l_receipt_date BETWEEN effective_start_date
1502: and rel.bill_to_flag = 'Y'
1503: union
1504: select 'Exists ar_paying_relationships_v'
1505: from ar_paying_relationships_v rel,
1506: hz_cust_accounts acc
1507: where rel.party_id = acc.party_id
1508: and acc.cust_account_id = l_customer_id
1509: and rel.related_cust_account_id = ps.customer_id
1510: and l_receipt_date BETWEEN effective_start_date
1953: and rel.bill_to_flag = 'Y'
1954: union
1955: select 'Exists ar_paying_relationships_v'
1956: from ar_paying_relationships_v rel,
1957: hz_cust_accounts acc
1958: where rel.party_id = acc.party_id
1959: and acc.cust_account_id = l_customer_id
1960: and rel.related_cust_account_id = ps.customer_id
1961: and l_receipt_date BETWEEN effective_start_date
2003: and rel.bill_to_flag = 'Y'
2004: union
2005: select 'Exists ar_paying_relationships_v'
2006: from ar_paying_relationships_v rel,
2007: hz_cust_accounts acc
2008: where rel.party_id = acc.party_id
2009: and acc.cust_account_id = l_customer_id
2010: and rel.related_cust_account_id = ps.customer_id
2011: and l_receipt_date BETWEEN effective_start_date
2032: and rel.bill_to_flag = 'Y'
2033: union
2034: select 'Exists ar_paying_relationships_v'
2035: from ar_paying_relationships_v rel,
2036: hz_cust_accounts acc
2037: where rel.party_id = acc.party_id
2038: and acc.cust_account_id = l_customer_id
2039: and rel.related_cust_account_id = ps.customer_id
2040: and l_receipt_date BETWEEN effective_start_date
2489: and rel.bill_to_flag = 'Y'
2490: union
2491: select 'Exists ar_paying_relationships_v'
2492: from ar_paying_relationships_v rel,
2493: hz_cust_accounts acc
2494: where rel.party_id = acc.party_id
2495: and acc.cust_account_id = l_customer_id
2496: and rel.related_cust_account_id = ps.customer_id
2497: and l_receipt_date BETWEEN effective_start_date
2539: and rel.bill_to_flag = 'Y'
2540: union
2541: select 'Exists ar_paying_relationships_v'
2542: from ar_paying_relationships_v rel,
2543: hz_cust_accounts acc
2544: where rel.party_id = acc.party_id
2545: and acc.cust_account_id = l_customer_id
2546: and rel.related_cust_account_id = ps.customer_id
2547: and l_receipt_date BETWEEN effective_start_date
2568: and rel.bill_to_flag = 'Y'
2569: union
2570: select 'Exists ar_paying_relationships_v'
2571: from ar_paying_relationships_v rel,
2572: hz_cust_accounts acc
2573: where rel.party_id = acc.party_id
2574: and acc.cust_account_id = l_customer_id
2575: and rel.related_cust_account_id = ps.customer_id
2576: and l_receipt_date BETWEEN effective_start_date
3021: and rel.bill_to_flag = 'Y'
3022: union
3023: select 'Exists ar_paying_relationships_v'
3024: from ar_paying_relationships_v rel,
3025: hz_cust_accounts acc
3026: where rel.party_id = acc.party_id
3027: and acc.cust_account_id = l_customer_id
3028: and rel.related_cust_account_id = ps.customer_id
3029: and l_receipt_date BETWEEN effective_start_date
3071: and rel.bill_to_flag = 'Y'
3072: union
3073: select 'Exists ar_paying_relationships_v'
3074: from ar_paying_relationships_v rel,
3075: hz_cust_accounts acc
3076: where rel.party_id = acc.party_id
3077: and acc.cust_account_id = l_customer_id
3078: and rel.related_cust_account_id = ps.customer_id
3079: and l_receipt_date BETWEEN effective_start_date
3100: and rel.bill_to_flag = 'Y'
3101: union
3102: select 'Exists ar_paying_relationships_v'
3103: from ar_paying_relationships_v rel,
3104: hz_cust_accounts acc
3105: where rel.party_id = acc.party_id
3106: and acc.cust_account_id = l_customer_id
3107: and rel.related_cust_account_id = ps.customer_id
3108: and l_receipt_date BETWEEN effective_start_date
3552: and rel.bill_to_flag = 'Y'
3553: union
3554: select 'Exists ar_paying_relationships_v'
3555: from ar_paying_relationships_v rel,
3556: hz_cust_accounts acc
3557: where rel.party_id = acc.party_id
3558: and acc.cust_account_id = l_customer_id
3559: and rel.related_cust_account_id = ps.customer_id
3560: and l_receipt_date BETWEEN effective_start_date
3602: and rel.bill_to_flag = 'Y'
3603: union
3604: select 'Exists ar_paying_relationships_v'
3605: from ar_paying_relationships_v rel,
3606: hz_cust_accounts acc
3607: where rel.party_id = acc.party_id
3608: and acc.cust_account_id = l_customer_id
3609: and rel.related_cust_account_id = ps.customer_id
3610: and l_receipt_date BETWEEN effective_start_date
3631: and rel.bill_to_flag = 'Y'
3632: union
3633: select 'Exists ar_paying_relationships_v'
3634: from ar_paying_relationships_v rel,
3635: hz_cust_accounts acc
3636: where rel.party_id = acc.party_id
3637: and acc.cust_account_id = l_customer_id
3638: and rel.related_cust_account_id = ps.customer_id
3639: and l_receipt_date BETWEEN effective_start_date
4082: and rel.bill_to_flag = 'Y'
4083: union
4084: select 'Exists ar_paying_relationships_v'
4085: from ar_paying_relationships_v rel,
4086: hz_cust_accounts acc
4087: where rel.party_id = acc.party_id
4088: and acc.cust_account_id = l_customer_id
4089: and rel.related_cust_account_id = ps.customer_id
4090: and l_receipt_date BETWEEN effective_start_date
4132: and rel.bill_to_flag = 'Y'
4133: union
4134: select 'Exists ar_paying_relationships_v'
4135: from ar_paying_relationships_v rel,
4136: hz_cust_accounts acc
4137: where rel.party_id = acc.party_id
4138: and acc.cust_account_id = l_customer_id
4139: and rel.related_cust_account_id = ps.customer_id
4140: and l_receipt_date BETWEEN effective_start_date
4161: and rel.bill_to_flag = 'Y'
4162: union
4163: select 'Exists ar_paying_relationships_v'
4164: from ar_paying_relationships_v rel,
4165: hz_cust_accounts acc
4166: where rel.party_id = acc.party_id
4167: and acc.cust_account_id = l_customer_id
4168: and rel.related_cust_account_id = ps.customer_id
4169: and l_receipt_date BETWEEN effective_start_date
4613: and rel.bill_to_flag = 'Y'
4614: union
4615: select 'Exists ar_paying_relationships_v'
4616: from ar_paying_relationships_v rel,
4617: hz_cust_accounts acc
4618: where rel.party_id = acc.party_id
4619: and acc.cust_account_id = l_customer_id
4620: and rel.related_cust_account_id = ps.customer_id
4621: and l_receipt_date BETWEEN effective_start_date
4663: and rel.bill_to_flag = 'Y'
4664: union
4665: select 'Exists ar_paying_relationships_v'
4666: from ar_paying_relationships_v rel,
4667: hz_cust_accounts acc
4668: where rel.party_id = acc.party_id
4669: and acc.cust_account_id = l_customer_id
4670: and rel.related_cust_account_id = ps.customer_id
4671: and l_receipt_date BETWEEN effective_start_date
4692: and rel.bill_to_flag = 'Y'
4693: union
4694: select 'Exists ar_paying_relationships_v'
4695: from ar_paying_relationships_v rel,
4696: hz_cust_accounts acc
4697: where rel.party_id = acc.party_id
4698: and acc.cust_account_id = l_customer_id
4699: and rel.related_cust_account_id = ps.customer_id
4700: and l_receipt_date BETWEEN effective_start_date