APPS.OE_BLANKET_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 60: HZ_CUST_ACCT_SITES ACCT_SITE

56:
57: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
58: Into l_dummy
59: FROM HZ_CUST_SITE_USES_ALL SITE,
60: HZ_CUST_ACCT_SITES ACCT_SITE
61: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
62: AND SITE.SITE_USE_CODE = l_site_use_code
63: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
64: AND SITE.STATUS = 'A'

Line 139: HZ_CUST_ACCT_SITES ACCT_SITE

135:
136: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
137: Into l_dummy
138: FROM HZ_CUST_SITE_USES_ALL SITE,
139: HZ_CUST_ACCT_SITES ACCT_SITE
140: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
141: AND SITE.SITE_USE_CODE = l_site_use_code
142: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
143: AND SITE.STATUS = 'A'

Line 227: HZ_CUST_ACCT_SITES ACCT_SITE

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

Line 3353: HZ_CUST_ACCT_SITES ACCT_SITE

3349: SELECT 'VALID'
3350: INTO l_dummy
3351: FROM
3352: HZ_CUST_SITE_USES SITE,
3353: HZ_CUST_ACCT_SITES ACCT_SITE
3354: WHERE
3355: SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
3356: AND SITE.SITE_USE_CODE = 'SOLD_TO'
3357: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 9237: FROM HZ_CUST_SITE_USES u,HZ_CUST_ACCT_SITES s

9233:
9234: SELECT u.cust_acct_site_id,s.cust_account_id
9235: INTO l_address_id,
9236: l_cust_id
9237: FROM HZ_CUST_SITE_USES u,HZ_CUST_ACCT_SITES s
9238: WHERE u.cust_acct_site_id = s.cust_acct_site_id
9239: AND u.site_use_id = p_x_line_rec.ship_to_org_id
9240: AND u.site_use_code = 'SHIP_TO';
9241: oe_debug_pub.add('ship to address:' || l_address_id||' - Customer:'||to_char(l_cust_id));