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 464: FROM hz_cust_accounts cust_acct

460: FROM ar_trx_header_gt gt
461: WHERE gt.paying_customer_id IS NOT NULL
462: AND NOT EXISTS (
463: SELECT 'X'
464: FROM hz_cust_accounts cust_acct
465: WHERE cust_acct.cust_account_id = gt.paying_customer_id
466: AND cust_acct.status = 'A' );
467: ELSIF p_trx_system_param_rec.pay_unrelated_invoices_flag = 'N'
468: THEN

Line 480: FROM hz_cust_accounts cust_acct

476: FROM ar_trx_header_gt gt
477: WHERE gt.paying_customer_id IS NOT NULL
478: AND NOT EXISTS
479: ( SELECT 'X'
480: FROM hz_cust_accounts cust_acct
481: WHERE cust_acct.cust_account_id = gt.paying_customer_id
482: AND cust_acct.status = 'A'
483: AND cust_acct.cust_account_id IN
484: (

Line 495: FROM ar_paying_relationships_v rel, hz_cust_accounts acc

491: SELECT to_number(gt.bill_to_customer_id)
492: FROM DUAL
493: UNION
494: SELECT acc.cust_account_id
495: FROM ar_paying_relationships_v rel, hz_cust_accounts acc
496: WHERE rel.party_id = acc.party_id
497: AND rel.related_cust_account_id = gt.bill_to_customer_id
498: AND gt.trx_date BETWEEN effective_start_date
499: AND effective_end_date)

Line 586: FROM hz_cust_accounts cust_acct

582: FROM ar_trx_header_gt gt
583: WHERE gt.sold_to_customer_id IS NOT NULL
584: AND NOT EXISTS
585: (SELECT 'X'
586: FROM hz_cust_accounts cust_acct
587: WHERE cust_acct.cust_account_id = gt.sold_to_customer_id
588: AND cust_acct.status = 'A');
589:
590: IF pg_debug = 'Y' THEN

Line 627: FROM hz_cust_accounts cust_acct,

623: FROM ar_trx_header_gt gt
624: WHERE gt.ship_to_customer_name IS NOT NULL
625: AND NOT EXISTS
626: (SELECT 'X'
627: FROM hz_cust_accounts cust_acct,
628: hz_parties party
629: WHERE cust_acct.party_id = party.party_id
630: AND party.party_name = gt.ship_to_customer_name);
631:

Line 669: FROM hz_cust_accounts cust_acct

665: FROM ar_trx_header_gt gt
666: WHERE gt.ship_to_account_number IS NOT NULL
667: AND NOT EXISTS
668: (SELECT 'X'
669: FROM hz_cust_accounts cust_acct
670: WHERE cust_acct.account_number = gt.ship_to_account_number);
671:
672: IF pg_debug = 'Y' THEN
673: debug ('ar_invoice_utils.validate_ship_to_cust_number(-)' );

Line 709: FROM hz_cust_accounts cust_acct,

705: FROM ar_trx_header_gt gt
706: WHERE gt.bill_to_customer_name IS NOT NULL
707: AND NOT EXISTS
708: (SELECT 'X'
709: FROM hz_cust_accounts cust_acct,
710: hz_parties party
711: WHERE cust_acct.party_id = party.party_id
712: AND party.party_name = gt.bill_to_customer_name);
713:

Line 751: FROM hz_cust_accounts cust_acct

747: FROM ar_trx_header_gt gt
748: WHERE gt.bill_to_account_number IS NOT NULL
749: AND NOT EXISTS
750: (SELECT 'X'
751: FROM hz_cust_accounts cust_acct
752: WHERE cust_acct.account_number = gt.bill_to_account_number);
753:
754: IF pg_debug = 'Y' THEN
755: debug ('ar_invoice_utils.validate_bill_to_cust_number(-)' );

Line 1640: FROM hz_cust_accounts ct

1636: FROM ar_trx_header_gt gt
1637: WHERE gt.bill_to_customer_id IS NOT NULL
1638: AND NOT EXISTS (
1639: SELECT 'X'
1640: FROM hz_cust_accounts ct
1641: WHERE ct.cust_account_id = gt.bill_to_customer_id
1642: AND status = 'A');
1643:
1644: IF pg_debug = 'Y'

Line 1792: FROM hz_cust_accounts ct

1788: FROM ar_trx_header_gt gt
1789: WHERE gt.ship_to_customer_id IS NOT NULL
1790: AND NOT EXISTS (
1791: SELECT 'X'
1792: FROM hz_cust_accounts ct
1793: WHERE ct.cust_account_id = gt.ship_to_customer_id
1794: AND ct.status = 'A');
1795: -- OR gt.ship_to_customer_id IS NOT NULL);
1796:

Line 2536: hz_cust_accounts acc

2532: --from dual
2533: UNION
2534: SELECT acc.cust_account_id
2535: FROM ar_paying_relationships_v rel,
2536: hz_cust_accounts acc
2537: WHERE rel.party_id = acc.party_id
2538: AND rel.related_cust_account_id = gt.bill_to_customer_id
2539: AND gt.trx_date BETWEEN effective_start_date
2540: AND effective_end_date));

Line 2703: from hz_cust_accounts cust_acct,

2699: FROM ar_trx_header_gt gt
2700: WHERE gt.agreement_id IS NOT NULL
2701: AND NOT EXISTS (
2702: SELECT 'X'
2703: from hz_cust_accounts cust_acct,
2704: hz_parties party,
2705: so_agreements a,
2706: qp_lookups sl
2707: where a.agreement_type_code = sl.lookup_code

Line 3008: FROM hz_cust_accounts cust_acct

3004:
3005: UPDATE ar_trx_header_gt gt
3006: SET gt.bill_to_customer_id =
3007: (SELECT cust_acct.cust_account_id
3008: FROM hz_cust_accounts cust_acct
3009: WHERE cust_acct.account_number = gt.bill_to_account_number
3010: AND cust_acct.status = 'A'
3011: AND gt.bill_to_customer_id IS NULL
3012: AND gt.bill_to_account_number IS NOT NULL

Line 3023: FROM hz_cust_accounts cust_acct

3019:
3020: UPDATE ar_trx_header_gt gt
3021: SET gt.bill_to_customer_id =
3022: (SELECT cust_acct.cust_account_id
3023: FROM hz_cust_accounts cust_acct
3024: WHERE cust_acct.account_number = gt.ship_to_account_number
3025: AND cust_acct.status = 'A'
3026: AND gt.bill_to_customer_id IS NULL
3027: AND gt.ship_to_account_number IS NOT NULL

Line 3047: FROM hz_cust_accounts cust_acct,

3043:
3044: UPDATE ar_trx_header_gt gt
3045: SET gt.bill_to_customer_id =
3046: (SELECT cust_acct.cust_account_id
3047: FROM hz_cust_accounts cust_acct,
3048: hz_parties party
3049: WHERE cust_acct.party_id = party.party_id
3050: AND party.party_name = gt.bill_to_customer_name
3051: AND gt.bill_to_customer_id IS NULL

Line 3460: FROM hz_cust_accounts cust_acct

3456:
3457: UPDATE ar_trx_header_gt gt
3458: SET gt.ship_to_customer_id =
3459: (SELECT cust_acct.cust_account_id
3460: FROM hz_cust_accounts cust_acct
3461: WHERE cust_acct.account_number = gt.ship_to_account_number
3462: AND cust_acct.status = 'A'
3463: AND gt.ship_to_customer_id IS NULL
3464: AND gt.ship_to_account_number IS NOT NULL

Line 3475: FROM hz_cust_accounts cust_acct,

3471:
3472: UPDATE ar_trx_header_gt gt
3473: SET gt.ship_to_customer_id =
3474: (SELECT cust_acct.cust_account_id
3475: FROM hz_cust_accounts cust_acct,
3476: hz_parties party
3477: WHERE cust_acct.party_id = party.party_id
3478: AND party.party_name = gt.ship_to_customer_name
3479: AND cust_acct.status = 'A'

Line 5316: FROM hz_cust_accounts hca,

5312: FOR ctrxHeaderRec IN ctrxHeader
5313: LOOP
5314: SELECT party.party_id
5315: INTO l_party_id
5316: FROM hz_cust_accounts hca,
5317: hz_parties party
5318: WHERE hca.party_id = party.party_id
5319: AND hca.cust_account_id = ctrxHeaderRec.paying_customer_id ;
5320: