APPS.OE_BLANKET_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 149: HZ_CUST_ACCT_SITES ACCT_SITE

145:
146: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
147: Into l_dummy
148: FROM HZ_CUST_SITE_USES_ALL SITE,
149: HZ_CUST_ACCT_SITES ACCT_SITE
150: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
151: AND SITE.SITE_USE_CODE = l_site_use_code
152: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
153: AND SITE.STATUS = 'A'

Line 228: HZ_CUST_ACCT_SITES ACCT_SITE

224:
225: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
226: Into l_dummy
227: FROM HZ_CUST_SITE_USES_ALL SITE,
228: HZ_CUST_ACCT_SITES ACCT_SITE
229: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
230: AND SITE.SITE_USE_CODE = l_site_use_code
231: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
232: AND SITE.STATUS = 'A'

Line 316: HZ_CUST_ACCT_SITES ACCT_SITE

312:
313: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
314: Into l_dummy
315: FROM HZ_CUST_SITE_USES_ALL SITE,
316: HZ_CUST_ACCT_SITES ACCT_SITE
317: WHERE SITE.SITE_USE_ID = p_invoice_to_org_id
318: AND SITE.SITE_USE_CODE = l_site_use_code
319: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
320: AND SITE.STATUS = 'A'

Line 3544: HZ_CUST_ACCT_SITES ACCT_SITE

3540: SELECT 'VALID'
3541: INTO l_dummy
3542: FROM
3543: HZ_CUST_SITE_USES SITE,
3544: HZ_CUST_ACCT_SITES ACCT_SITE
3545: WHERE
3546: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
3547: AND SITE.SITE_USE_CODE = 'SOLD_TO'
3548: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 9434: FROM HZ_CUST_SITE_USES u,HZ_CUST_ACCT_SITES s

9430:
9431: SELECT u.cust_acct_site_id,s.cust_account_id
9432: INTO l_address_id,
9433: l_cust_id
9434: FROM HZ_CUST_SITE_USES u,HZ_CUST_ACCT_SITES s
9435: WHERE u.cust_acct_site_id = s.cust_acct_site_id
9436: AND u.site_use_id = p_x_line_rec.ship_to_org_id
9437: AND u.site_use_code = 'SHIP_TO';
9438: oe_debug_pub.add('ship to address:' || l_address_id||' - Customer:'||to_char(l_cust_id));