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_PAYMENT_TRXN_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 129: From HZ_CUST_SITE_USES_ALL SITE,

125:
126: BEGIN
127: Select hca.party_id, acct_site.cust_account_id,acct_site.party_site_id
128: Into l_party_id, l_cust_account_id,l_party_site_id
129: From HZ_CUST_SITE_USES_ALL SITE,
130: HZ_CUST_ACCT_SITES ACCT_SITE,
131: HZ_CUST_ACCOUNTS_ALL HCA
132: Where SITE.SITE_USE_ID = p_site_use_id
133: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 770: From HZ_CUST_SITE_USES_ALL SITE,

766:
767: Begin
768: Select hca.party_id, acct_site.cust_account_id,acct_site.party_site_id
769: Into l_party_id, l_cust_account_id,l_party_site_id
770: From HZ_CUST_SITE_USES_ALL SITE,
771: HZ_CUST_ACCT_SITES ACCT_SITE,
772: HZ_CUST_ACCOUNTS_ALL HCA
773: Where SITE.SITE_USE_ID = p_site_use_id
774: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 1634: From HZ_CUST_SITE_USES_ALL SITE,

1630:
1631: Begin
1632: Select hca.party_id, acct_site.cust_account_id
1633: Into l_party_id, l_cust_account_id
1634: From HZ_CUST_SITE_USES_ALL SITE,
1635: HZ_CUST_ACCT_SITES ACCT_SITE,
1636: HZ_CUST_ACCOUNTS_ALL HCA
1637: Where SITE.SITE_USE_ID = p_site_use_id
1638: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 2167: From HZ_CUST_SITE_USES_ALL SITE,

2163: END IF;
2164:
2165: Select hca.party_id, acct_site.cust_account_id
2166: Into l_party_id, l_cust_account_id
2167: From HZ_CUST_SITE_USES_ALL SITE,
2168: HZ_CUST_ACCT_SITES ACCT_SITE,
2169: HZ_CUST_ACCOUNTS_ALL HCA
2170: Where SITE.SITE_USE_ID = l_site_use_id
2171: AND SITE.SITE_USE_CODE = 'BILL_TO'