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

Line 244: FROM HZ_CUST_SITE_USES_ALL

240:
241: --ER#12571983 start
242: CURSOR endcust_loc_cur IS
243: select substrb(location,1,50) location
244: FROM HZ_CUST_SITE_USES_ALL
245: WHERE status='A'
246: AND SITE_USE_CODE in ('SHIP_TO','SOLD_TO','DELIVER_TO','BILL_TO')
247: AND SITE_USE_ID = p_hold_entity_id;
248: --ER#12571983 end

Line 2552: FROM HZ_CUST_SITE_USES_ALL

2548: ELSIF p_hold_source_rec.hold_entity_code2 ='EL' THEN
2549:
2550: SELECT 'Valid Entity'
2551: INTO l_dummy
2552: FROM HZ_CUST_SITE_USES_ALL
2553: WHERE status='A'
2554: AND SITE_USE_CODE in ('SHIP_TO','SOLD_TO','DELIVER_TO','BILL_TO')
2555: AND SITE_USE_ID = p_hold_source_rec.hold_entity_id2;
2556: --ER#12571983 end

Line 12910: l_hold_entity_where_clause := ' and exists (Select 1 FROM HZ_CUST_ACCOUNTS_ALL cust ,HZ_CUST_ACCT_SITES_ALL site,hz_cust_site_uses_all siteuse WHERE cust.cust_account_id = '

12906: --If(p_hold_source_rec.line_id is not null ) then --Bug 13565716
12907: OE_DEBUG_PUB.ADD('Not a Header based Hold');
12908:
12909: OE_DEBUG_PUB.ADD('Calling InsertTable_OOH_Line for C, BillTOLine');
12910: l_hold_entity_where_clause := ' and exists (Select 1 FROM HZ_CUST_ACCOUNTS_ALL cust ,HZ_CUST_ACCT_SITES_ALL site,hz_cust_site_uses_all siteuse WHERE cust.cust_account_id = '
12911: ||''''||p_hold_source_rec.hold_entity_id||''''||'and ol.INVOICE_TO_ORG_ID = siteuse.site_use_id'
12912: ||' AND cust.cust_account_id =site.cust_account_id AND site.cust_acct_site_id = siteuse.cust_acct_site_id AND siteuse.site_use_code ='||'''BILL_TO'''||' AND siteuse.status = '||'''A'''||')';
12913:
12914:

Line 12945: l_hold_entity_where_clause := ' and exists (Select 1 FROM HZ_CUST_ACCOUNTS_ALL cust ,HZ_CUST_ACCT_SITES_ALL site,hz_cust_site_uses_all siteuse WHERE cust.cust_account_id = '

12941: --
12942: if(p_hold_source_rec.hold_entity_code='C' AND l_credithold_cust = 'BTH' and p_hold_source_rec.hold_id =1) then
12943: --and p_hold_source_rec.hold_id =1 and p_hold_source_rec.header_id is NOT NULL ) then --Bug 13565716
12944: OE_DEBUG_PUB.ADD('Calling InsertTable_OOH_Header as Credit Hold System Paramter at BillTOCustHeader');
12945: l_hold_entity_where_clause := ' and exists (Select 1 FROM HZ_CUST_ACCOUNTS_ALL cust ,HZ_CUST_ACCT_SITES_ALL site,hz_cust_site_uses_all siteuse WHERE cust.cust_account_id = '
12946: ||''''||p_hold_source_rec.hold_entity_id||''''||'and h.INVOICE_TO_ORG_ID = siteuse.site_use_id'
12947: ||' AND cust.cust_account_id =site.cust_account_id AND site.cust_acct_site_id = siteuse.cust_acct_site_id AND siteuse.site_use_code ='||'''BILL_TO'''||' AND siteuse.status = '||'''A'''||')';
12948:
12949: