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.OE_PREPAYMENT_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 353: FROM hz_cust_accounts

349: AND oh.order_type_id = NVL(p_order_type_id, oh.order_type_id)
350: AND oh.org_id = hs.org_id --moac
351: AND hs.org_id = hd.org_id --moac
352: AND oh.sold_to_org_id IN (SELECT cust_account_id
353: FROM hz_cust_accounts
354: WHERE account_number BETWEEN NVL(p_customer_number_from, account_number)
355: AND NVL(p_customer_number_to, account_number)
356: AND nvl(CUSTOMER_CLASS_CODE, 'XXX') = NVL(p_customer_class_code, nvl(CUSTOMER_CLASS_CODE, 'XXX')))
357: AND oh.order_number BETWEEN NVL(p_order_number_from, oh.order_number)

Line 402: FROM hz_cust_accounts

398: AND oh.order_type_id = NVL(p_order_type_id, oh.order_type_id)
399: AND oh.org_id = hs.org_id -- moac
400: AND hs.org_id = hd.org_id --moac
401: AND oh.sold_to_org_id IN (SELECT cust_account_id
402: FROM hz_cust_accounts
403: WHERE account_number BETWEEN NVL(p_customer_number_from, account_number)
404: AND NVL(p_customer_number_to, account_number)
405: AND nvl(CUSTOMER_CLASS_CODE, 'XXX') = NVL(p_customer_class_code, nvl(CUSTOMER_CLASS_CODE, 'XXX')))
406: AND oh.order_number BETWEEN NVL(p_order_number_from, oh.order_number)

Line 446: FROM hz_cust_accounts

442: AND oh.order_type_id = NVL(p_order_type_id, oh.order_type_id)
443: AND oh.org_id = hs.org_id --moac
444: AND hs.org_id = hd.org_id --moac
445: AND oh.sold_to_org_id IN (SELECT cust_account_id
446: FROM hz_cust_accounts
447: WHERE account_number BETWEEN NVL(p_customer_number_from, account_number)
448: AND NVL(p_customer_number_to, account_number)
449: AND nvl(CUSTOMER_CLASS_CODE, 'XXX') = NVL(p_customer_class_code, nvl(CUSTOMER_CLASS_CODE, 'XXX')))
450: AND oh.order_number BETWEEN NVL(p_order_number_from, oh.order_number)

Line 491: FROM hz_cust_accounts

487: AND oh.order_type_id = NVL(p_order_type_id, oh.order_type_id)
488: AND oh.org_id = hs.org_id --moac
489: AND hs.org_id = hd.org_id --moac
490: AND oh.sold_to_org_id IN (SELECT cust_account_id
491: FROM hz_cust_accounts
492: WHERE account_number BETWEEN NVL(p_customer_number_from, account_number)
493: AND NVL(p_customer_number_to, account_number)
494: AND nvl(CUSTOMER_CLASS_CODE, 'XXX') = NVL(p_customer_class_code, nvl(CUSTOMER_CLASS_CODE, 'XXX')))
495: AND oh.order_number BETWEEN NVL(p_order_number_from, oh.order_number)