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

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 2407: FROM hz_cust_site_uses -- Bug 2138398

2403:
2404: ELSIF p_hold_source_rec.hold_entity_code = 'S' THEN
2405: SELECT 'Valid Entity'
2406: INTO l_dummy
2407: FROM hz_cust_site_uses -- Bug 2138398
2408: WHERE site_use_id = p_hold_source_rec.hold_entity_id
2409: AND site_use_code = 'SHIP_TO'
2410: AND STATUS='A';
2411:

Line 2424: FROM hz_cust_site_uses -- Bug 2138398

2420:
2421: ELSIF p_hold_source_rec.hold_entity_code = 'B' THEN
2422: SELECT 'Valid Entity'
2423: INTO l_dummy
2424: FROM hz_cust_site_uses -- Bug 2138398
2425: WHERE site_use_id = p_hold_source_rec.hold_entity_id
2426: AND site_use_code = 'BILL_TO'
2427: AND STATUS='A';
2428: --ER#7479609 start

Line 2432: FROM hz_cust_site_uses

2428: --ER#7479609 start
2429: ELSIF p_hold_source_rec.hold_entity_code = 'D' THEN
2430: SELECT 'Valid Entity'
2431: INTO l_dummy
2432: FROM hz_cust_site_uses
2433: WHERE site_use_id = p_hold_source_rec.hold_entity_id
2434: AND site_use_code = 'DELIVER_TO'
2435: AND STATUS='A';
2436: --ER#7479609 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 2561: FROM hz_cust_site_uses -- Bug 2138398

2557:
2558: ELSIF p_hold_source_rec.hold_entity_code2 = 'S' THEN
2559: SELECT 'Valid Entity'
2560: INTO l_dummy
2561: FROM hz_cust_site_uses -- Bug 2138398
2562: WHERE SITE_USE_ID = p_hold_source_rec.hold_entity_id2
2563: AND site_use_code = 'SHIP_TO';
2564:
2565:

Line 2577: FROM hz_cust_site_uses -- Bug 2138398

2573:
2574: ELSIF p_hold_source_rec.hold_entity_code2 = 'B' THEN
2575: SELECT 'Valid Entity'
2576: INTO l_dummy
2577: FROM hz_cust_site_uses -- Bug 2138398
2578: WHERE SITE_USE_ID = p_hold_source_rec.hold_entity_id2
2579: AND site_use_code = 'BILL_TO';
2580: ELSIF p_hold_source_rec.hold_entity_code2 = 'H' THEN
2581: SELECT 'Valid Entity'

Line 2606: FROM hz_cust_site_uses

2602: WHERE user_id = p_hold_source_rec.hold_entity_id2;
2603: ELSIF p_hold_source_rec.hold_entity_code2 = 'D' THEN
2604: SELECT 'Valid Entity'
2605: INTO l_dummy
2606: FROM hz_cust_site_uses
2607: WHERE SITE_USE_ID = p_hold_source_rec.hold_entity_id2
2608: AND site_use_code = 'DELIVER_TO';
2609: ELSIF p_hold_source_rec.hold_entity_code2 in ('LT','OT') THEN
2610: SELECT 'Valid Entity'

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: