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_INVOICE_UTILS dependencies on HZ_CUST_ACCOUNTS

Line 457: FROM hz_cust_accounts cust_acct

453: FROM ar_trx_header_gt gt
454: WHERE gt.paying_customer_id IS NOT NULL
455: AND NOT EXISTS (
456: SELECT 'X'
457: FROM hz_cust_accounts cust_acct
458: WHERE cust_acct.cust_account_id = gt.paying_customer_id
459: AND cust_acct.status = 'A' );
460: ELSIF p_trx_system_param_rec.pay_unrelated_invoices_flag = 'N'
461: THEN

Line 473: FROM hz_cust_accounts cust_acct

469: FROM ar_trx_header_gt gt
470: WHERE gt.paying_customer_id IS NOT NULL
471: AND NOT EXISTS
472: ( SELECT 'X'
473: FROM hz_cust_accounts cust_acct
474: WHERE cust_acct.cust_account_id = gt.paying_customer_id
475: AND cust_acct.status = 'A'
476: AND cust_acct.cust_account_id IN
477: (

Line 488: FROM ar_paying_relationships_v rel, hz_cust_accounts acc

484: SELECT to_number(gt.bill_to_customer_id)
485: FROM DUAL
486: UNION
487: SELECT acc.cust_account_id
488: FROM ar_paying_relationships_v rel, hz_cust_accounts acc
489: WHERE rel.party_id = acc.party_id
490: AND rel.related_cust_account_id = gt.bill_to_customer_id
491: AND gt.trx_date BETWEEN effective_start_date
492: AND effective_end_date)

Line 579: FROM hz_cust_accounts cust_acct

575: FROM ar_trx_header_gt gt
576: WHERE gt.sold_to_customer_id IS NOT NULL
577: AND NOT EXISTS
578: (SELECT 'X'
579: FROM hz_cust_accounts cust_acct
580: WHERE cust_acct.cust_account_id = gt.sold_to_customer_id
581: AND cust_acct.status = 'A');
582:
583: IF pg_debug = 'Y' THEN

Line 620: FROM hz_cust_accounts cust_acct,

616: FROM ar_trx_header_gt gt
617: WHERE gt.ship_to_customer_name IS NOT NULL
618: AND NOT EXISTS
619: (SELECT 'X'
620: FROM hz_cust_accounts cust_acct,
621: hz_parties party
622: WHERE cust_acct.party_id = party.party_id
623: AND party.party_name = gt.ship_to_customer_name);
624:

Line 662: FROM hz_cust_accounts cust_acct

658: FROM ar_trx_header_gt gt
659: WHERE gt.ship_to_account_number IS NOT NULL
660: AND NOT EXISTS
661: (SELECT 'X'
662: FROM hz_cust_accounts cust_acct
663: WHERE cust_acct.account_number = gt.ship_to_account_number);
664:
665: IF pg_debug = 'Y' THEN
666: debug ('ar_invoice_utils.validate_ship_to_cust_number(-)' );

Line 702: FROM hz_cust_accounts cust_acct,

698: FROM ar_trx_header_gt gt
699: WHERE gt.bill_to_customer_name IS NOT NULL
700: AND NOT EXISTS
701: (SELECT 'X'
702: FROM hz_cust_accounts cust_acct,
703: hz_parties party
704: WHERE cust_acct.party_id = party.party_id
705: AND party.party_name = gt.bill_to_customer_name);
706:

Line 744: FROM hz_cust_accounts cust_acct

740: FROM ar_trx_header_gt gt
741: WHERE gt.bill_to_account_number IS NOT NULL
742: AND NOT EXISTS
743: (SELECT 'X'
744: FROM hz_cust_accounts cust_acct
745: WHERE cust_acct.account_number = gt.bill_to_account_number);
746:
747: IF pg_debug = 'Y' THEN
748: debug ('ar_invoice_utils.validate_bill_to_cust_number(-)' );

Line 1599: FROM hz_cust_accounts ct

1595: FROM ar_trx_header_gt gt
1596: WHERE gt.bill_to_customer_id IS NOT NULL
1597: AND NOT EXISTS (
1598: SELECT 'X'
1599: FROM hz_cust_accounts ct
1600: WHERE ct.cust_account_id = gt.bill_to_customer_id
1601: AND status = 'A');
1602:
1603: IF pg_debug = 'Y'

Line 1738: FROM hz_cust_accounts ct

1734: FROM ar_trx_header_gt gt
1735: WHERE gt.ship_to_customer_id IS NOT NULL
1736: AND NOT EXISTS (
1737: SELECT 'X'
1738: FROM hz_cust_accounts ct
1739: WHERE ct.cust_account_id = gt.ship_to_customer_id
1740: AND ct.status = 'A');
1741: -- OR gt.ship_to_customer_id IS NOT NULL);
1742:

Line 2459: hz_cust_accounts acc

2455: --from dual
2456: UNION
2457: SELECT acc.cust_account_id
2458: FROM ar_paying_relationships_v rel,
2459: hz_cust_accounts acc
2460: WHERE rel.party_id = acc.party_id
2461: AND rel.related_cust_account_id = gt.bill_to_customer_id
2462: AND gt.trx_date BETWEEN effective_start_date
2463: AND effective_end_date));

Line 2626: from hz_cust_accounts cust_acct,

2622: FROM ar_trx_header_gt gt
2623: WHERE gt.agreement_id IS NOT NULL
2624: AND NOT EXISTS (
2625: SELECT 'X'
2626: from hz_cust_accounts cust_acct,
2627: hz_parties party,
2628: so_agreements a,
2629: qp_lookups sl
2630: where a.agreement_type_code = sl.lookup_code

Line 2929: FROM hz_cust_accounts cust_acct

2925:
2926: UPDATE ar_trx_header_gt gt
2927: SET gt.bill_to_customer_id =
2928: (SELECT cust_acct.cust_account_id
2929: FROM hz_cust_accounts cust_acct
2930: WHERE cust_acct.account_number = gt.bill_to_account_number
2931: AND cust_acct.status = 'A'
2932: AND gt.bill_to_customer_id IS NULL
2933: AND gt.bill_to_account_number IS NOT NULL

Line 2944: FROM hz_cust_accounts cust_acct

2940:
2941: UPDATE ar_trx_header_gt gt
2942: SET gt.bill_to_customer_id =
2943: (SELECT cust_acct.cust_account_id
2944: FROM hz_cust_accounts cust_acct
2945: WHERE cust_acct.account_number = gt.ship_to_account_number
2946: AND cust_acct.status = 'A'
2947: AND gt.bill_to_customer_id IS NULL
2948: AND gt.ship_to_account_number IS NOT NULL

Line 2968: FROM hz_cust_accounts cust_acct,

2964:
2965: UPDATE ar_trx_header_gt gt
2966: SET gt.bill_to_customer_id =
2967: (SELECT cust_acct.cust_account_id
2968: FROM hz_cust_accounts cust_acct,
2969: hz_parties party
2970: WHERE cust_acct.party_id = party.party_id
2971: AND party.party_name = gt.bill_to_customer_name
2972: AND gt.bill_to_customer_id IS NULL

Line 3365: FROM hz_cust_accounts cust_acct

3361:
3362: UPDATE ar_trx_header_gt gt
3363: SET gt.ship_to_customer_id =
3364: (SELECT cust_acct.cust_account_id
3365: FROM hz_cust_accounts cust_acct
3366: WHERE cust_acct.account_number = gt.ship_to_account_number
3367: AND cust_acct.status = 'A'
3368: AND gt.ship_to_customer_id IS NULL
3369: AND gt.ship_to_account_number IS NOT NULL

Line 3380: FROM hz_cust_accounts cust_acct,

3376:
3377: UPDATE ar_trx_header_gt gt
3378: SET gt.ship_to_customer_id =
3379: (SELECT cust_acct.cust_account_id
3380: FROM hz_cust_accounts cust_acct,
3381: hz_parties party
3382: WHERE cust_acct.party_id = party.party_id
3383: AND party.party_name = gt.ship_to_customer_name
3384: AND cust_acct.status = 'A'

Line 5189: FROM hz_cust_accounts hca,

5185: FOR ctrxHeaderRec IN ctrxHeader
5186: LOOP
5187: SELECT party.party_id
5188: INTO l_party_id
5189: FROM hz_cust_accounts hca,
5190: hz_parties party
5191: WHERE hca.party_id = party.party_id
5192: AND hca.cust_account_id = ctrxHeaderRec.paying_customer_id ;
5193: