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_BLANKET_UTIL dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 70: HZ_CUST_ACCT_RELATE_ALL h WHERE

66: ACCT_SITE.CUST_ACCOUNT_ID in (
67: SELECT p_sold_to_org_id FROM DUAL
68: UNION
69: SELECT CUST_ACCOUNT_ID FROM
70: HZ_CUST_ACCT_RELATE_ALL h WHERE
71: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
72: and h.org_id=acct_site.org_id
73: and ship_to_flag = 'Y' and status = 'A')
74: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =

Line 149: HZ_CUST_ACCT_RELATE_ALL h WHERE

145: ACCT_SITE.CUST_ACCOUNT_ID in (
146: SELECT p_sold_to_org_id FROM DUAL
147: UNION
148: SELECT CUST_ACCOUNT_ID FROM
149: HZ_CUST_ACCT_RELATE_ALL h WHERE
150: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
151: and h.org_id=acct_site.org_id
152: and ship_to_flag = 'Y' and status='A')
153: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =

Line 237: HZ_CUST_ACCT_RELATE_ALL h WHERE

233: ACCT_SITE.CUST_ACCOUNT_ID in (
234: SELECT p_sold_to_org_id FROM DUAL
235: UNION
236: SELECT CUST_ACCOUNT_ID FROM
237: HZ_CUST_ACCT_RELATE_ALL h WHERE
238: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
239: and h.org_id=acct_site.org_id
240: and bill_to_flag = 'Y' and status='A')
241: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')