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 AR_PAYING_RELATIONSHIPS_V

Line 887: select 'Exists ar_paying_relationships_v'

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

Line 888: from ar_paying_relationships_v rel,

884: and rel.status = 'A'
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

Line 937: select 'Exists ar_paying_relationships_v'

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

Line 938: from ar_paying_relationships_v rel,

934: and rel.status = 'A'
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

Line 966: select 'Exists ar_paying_relationships_v'

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

Line 967: from ar_paying_relationships_v rel,

963: and rel.status = 'A'
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

Line 1425: select 'Exists ar_paying_relationships_v'

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

Line 1426: from ar_paying_relationships_v rel,

1422: and rel.status = 'A'
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

Line 1475: select 'Exists ar_paying_relationships_v'

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

Line 1476: from ar_paying_relationships_v rel,

1472: and rel.status = 'A'
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

Line 1504: select 'Exists ar_paying_relationships_v'

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

Line 1505: from ar_paying_relationships_v rel,

1501: and rel.status = 'A'
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

Line 1955: select 'Exists ar_paying_relationships_v'

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

Line 1956: from ar_paying_relationships_v rel,

1952: and rel.status = 'A'
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

Line 2005: select 'Exists ar_paying_relationships_v'

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

Line 2006: from ar_paying_relationships_v rel,

2002: and rel.status = 'A'
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

Line 2034: select 'Exists ar_paying_relationships_v'

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

Line 2035: from ar_paying_relationships_v rel,

2031: and rel.status = 'A'
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

Line 2491: select 'Exists ar_paying_relationships_v'

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

Line 2492: from ar_paying_relationships_v rel,

2488: and rel.status = 'A'
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

Line 2541: select 'Exists ar_paying_relationships_v'

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

Line 2542: from ar_paying_relationships_v rel,

2538: and rel.status = 'A'
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

Line 2570: select 'Exists ar_paying_relationships_v'

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

Line 2571: from ar_paying_relationships_v rel,

2567: and rel.status = 'A'
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

Line 3023: select 'Exists ar_paying_relationships_v'

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

Line 3024: from ar_paying_relationships_v rel,

3020: and rel.status = 'A'
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

Line 3073: select 'Exists ar_paying_relationships_v'

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

Line 3074: from ar_paying_relationships_v rel,

3070: and rel.status = 'A'
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

Line 3102: select 'Exists ar_paying_relationships_v'

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

Line 3103: from ar_paying_relationships_v rel,

3099: and rel.status = 'A'
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

Line 3554: select 'Exists ar_paying_relationships_v'

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

Line 3555: from ar_paying_relationships_v rel,

3551: and rel.status = 'A'
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

Line 3604: select 'Exists ar_paying_relationships_v'

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

Line 3605: from ar_paying_relationships_v rel,

3601: and rel.status = 'A'
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

Line 3633: select 'Exists ar_paying_relationships_v'

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

Line 3634: from ar_paying_relationships_v rel,

3630: and rel.status = 'A'
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

Line 4084: select 'Exists ar_paying_relationships_v'

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

Line 4085: from ar_paying_relationships_v rel,

4081: and rel.status = 'A'
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

Line 4134: select 'Exists ar_paying_relationships_v'

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

Line 4135: from ar_paying_relationships_v rel,

4131: and rel.status = 'A'
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

Line 4163: select 'Exists ar_paying_relationships_v'

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

Line 4164: from ar_paying_relationships_v rel,

4160: and rel.status = 'A'
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

Line 4615: select 'Exists ar_paying_relationships_v'

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

Line 4616: from ar_paying_relationships_v rel,

4612: and rel.status = 'A'
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

Line 4665: select 'Exists ar_paying_relationships_v'

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

Line 4666: from ar_paying_relationships_v rel,

4662: and rel.status = 'A'
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

Line 4694: select 'Exists ar_paying_relationships_v'

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

Line 4695: from ar_paying_relationships_v rel,

4691: and rel.status = 'A'
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