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.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 3471: FROM HZ_CUST_SITE_USES_ALL

3467: BEGIN
3468:
3469: SELECT CUST_ACCT_SITE_ID,SITE_USE_CODE,ORG_ID
3470: INTO l_cust_acct_site_id,l_cust_acct_site_use_code,l_org_id
3471: FROM HZ_CUST_SITE_USES_ALL
3472: WHERE SITE_USE_ID = p_customer_profile_rec.site_use_id;
3473:
3474: -- Bug 4650473. Check if org is accessible.
3475: BEGIN

Line 7773: * against hz_cust_site_uses_all table instead of the

7769: * 06-13-2002 P.Suresh Bug No : 2403263. Added validation that the contact_id
7770: * should be a foreign key to hz_cust_account_roles.
7771: * cust_account_role_id.
7772: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7773: * against hz_cust_site_uses_all table instead of the
7774: * org stripped view, hz_cust_site_uses.
7775: * 03-May-3004 Venkata Sowjanya S Bug No : 3609601. Commented the statements which sets tokens Column1,Column2
7776: * for message HZ_API_INACTIVE_CANNOT_PRIM
7777: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)

Line 7853: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

7849: l_created_by_module, l_application_id, l_status, l_ship_via, l_freight_term,
7850: l_ship_sets_inc_lines_f,l_arrivalsets_inc_lines_f,l_tax_code,l_demand_class_code,
7851: l_primary_salesrep_id,l_finchrg_receivables_trx_id,l_order_type_id,l_price_list_id,
7852: l_fob_point,l_item_cross_ref_pref,l_warehouse_id,l_date_type_preference
7853: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
7854: WHERE ROWID = p_rowid;
7855: END IF;
7856:
7857: --------------------------------------

Line 7875: FROM HZ_CUST_SITE_USES_ALL

7871: p_cust_site_use_rec.site_use_id <> FND_API.G_MISS_NUM
7872: THEN
7873: BEGIN
7874: SELECT 'Y' INTO l_dummy
7875: FROM HZ_CUST_SITE_USES_ALL
7876: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id;
7877:
7878: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7879: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_site_use_id' );

Line 8128: HZ_CUST_SITE_USES_ALL su

8124: IF l_site_use_code IN ( 'DUN', 'STMTS', 'LEGAL' ) THEN
8125: BEGIN
8126: SELECT 'Y' INTO l_dummy
8127: FROM HZ_CUST_ACCT_SITES_ALL site,
8128: HZ_CUST_SITE_USES_ALL su
8129: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
8130: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
8131: AND su.SITE_USE_CODE = l_site_use_code
8132: AND su.STATUS = 'A'

Line 8172: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

8168: then
8169: -- Bug 3988537.
8170: BEGIN
8171: SELECT 'Y' INTO l_dummy
8172: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
8173: WHERE CUST_ACCT_SITE_ID = nvl(p_cust_site_use_rec.cust_acct_site_id,l_cust_acct_site_id)
8174: AND SITE_USE_CODE = nvl(p_cust_site_use_rec.site_use_code,l_site_use_code)
8175: AND SITE_USE_ID <> nvl(p_cust_site_use_rec.site_use_id,fnd_api.g_miss_num)
8176: AND STATUS = 'A'

Line 8275: HZ_CUST_SITE_USES_ALL su

8271: --Bug No : 2998504. Status check added to the where clause.
8272:
8273: SELECT 'Y' INTO l_dummy
8274: FROM HZ_CUST_ACCT_SITES_ALL site,
8275: HZ_CUST_SITE_USES_ALL su
8276: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
8277: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
8278: AND su.SITE_USE_CODE = l_site_use_code
8279: AND su.LOCATION = p_cust_site_use_rec.location

Line 8348: HZ_CUST_SITE_USES_ALL su

8344: IF l_site_use_code = 'SHIP_TO' THEN
8345: BEGIN
8346: SELECT 'Y' INTO l_dummy
8347: FROM HZ_CUST_ACCT_SITES_ALL site,
8348: HZ_CUST_SITE_USES_ALL su
8349: WHERE su.SITE_USE_ID = p_cust_site_use_rec.bill_to_site_use_id
8350: AND su.SITE_USE_CODE = 'BILL_TO'
8351: AND su.STATUS = 'A'
8352: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID

Line 8399: FROM hz_cust_site_uses_all hsu

8395: THEN
8396: BEGIN
8397: SELECT 'Y'
8398: INTO l_exist_flag
8399: FROM hz_cust_site_uses_all hsu
8400: WHERE hsu.site_use_code = 'SHIP_TO'
8401: AND hsu.status = 'A'
8402: AND hsu.bill_to_site_use_id = p_cust_site_use_rec.site_use_id
8403: AND rownum = 1;

Line 8444: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',

8440:
8441: hz_orig_system_ref_pub.get_owner_table_id
8442: (p_orig_system => p_cust_site_use_rec.orig_system,
8443: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
8444: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
8445: x_owner_table_id => l_mosr_owner_table_id,
8446: x_return_status => l_temp_return_status);
8447:
8448: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 11024: FROM HZ_CUST_SITE_USES_ALL

11020: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
11021: BEGIN
11022:
11023: SELECT org_id INTO l_org_id
11024: FROM HZ_CUST_SITE_USES_ALL
11025: WHERE SITE_USE_ID = p_column_value;
11026:
11027: -- Bug 4650473. Check if org is accessible.
11028: BEGIN