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 159: HZ_CUST_ACCT_RELATE_ALL h WHERE

155: ACCT_SITE.CUST_ACCOUNT_ID in (
156: SELECT p_sold_to_org_id FROM DUAL
157: UNION
158: SELECT CUST_ACCOUNT_ID FROM
159: HZ_CUST_ACCT_RELATE_ALL h WHERE
160: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
161: and h.org_id=acct_site.org_id
162: and ship_to_flag = 'Y' and status = 'A')
163: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =

Line 238: HZ_CUST_ACCT_RELATE_ALL h WHERE

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

Line 326: HZ_CUST_ACCT_RELATE_ALL h WHERE

322: ACCT_SITE.CUST_ACCOUNT_ID in (
323: SELECT p_sold_to_org_id FROM DUAL
324: UNION
325: SELECT CUST_ACCOUNT_ID FROM
326: HZ_CUST_ACCT_RELATE_ALL h WHERE
327: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
328: and h.org_id=acct_site.org_id
329: and bill_to_flag = 'Y' and status='A')
330: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')