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 3444: FROM HZ_CUST_SITE_USES_ALL

3440: BEGIN
3441:
3442: SELECT CUST_ACCT_SITE_ID,SITE_USE_CODE,ORG_ID
3443: INTO l_cust_acct_site_id,l_cust_acct_site_use_code,l_org_id
3444: FROM HZ_CUST_SITE_USES_ALL
3445: WHERE SITE_USE_ID = p_customer_profile_rec.site_use_id;
3446:
3447: -- Bug 4650473. Check if org is accessible.
3448: BEGIN

Line 7498: * against hz_cust_site_uses_all table instead of the

7494: * 06-13-2002 P.Suresh Bug No : 2403263. Added validation that the contact_id
7495: * should be a foreign key to hz_cust_account_roles.
7496: * cust_account_role_id.
7497: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7498: * against hz_cust_site_uses_all table instead of the
7499: * org stripped view, hz_cust_site_uses.
7500: * 03-May-3004 Venkata Sowjanya S Bug No : 3609601. Commented the statements which sets tokens Column1,Column2
7501: * for message HZ_API_INACTIVE_CANNOT_PRIM
7502: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)

Line 7578: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

7574: l_created_by_module, l_application_id, l_status, l_ship_via, l_freight_term,
7575: l_ship_sets_inc_lines_f,l_arrivalsets_inc_lines_f,l_tax_code,l_demand_class_code,
7576: l_primary_salesrep_id,l_finchrg_receivables_trx_id,l_order_type_id,l_price_list_id,
7577: l_fob_point,l_item_cross_ref_pref,l_warehouse_id,l_date_type_preference
7578: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
7579: WHERE ROWID = p_rowid;
7580: END IF;
7581:
7582: --------------------------------------

Line 7600: FROM HZ_CUST_SITE_USES_ALL

7596: p_cust_site_use_rec.site_use_id <> FND_API.G_MISS_NUM
7597: THEN
7598: BEGIN
7599: SELECT 'Y' INTO l_dummy
7600: FROM HZ_CUST_SITE_USES_ALL
7601: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id;
7602:
7603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7604: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_site_use_id' );

Line 7849: HZ_CUST_SITE_USES_ALL su

7845: IF l_site_use_code IN ( 'DUN', 'STMTS', 'LEGAL' ) THEN
7846: BEGIN
7847: SELECT 'Y' INTO l_dummy
7848: FROM HZ_CUST_ACCT_SITES_ALL site,
7849: HZ_CUST_SITE_USES_ALL su
7850: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
7851: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
7852: AND su.SITE_USE_CODE = l_site_use_code
7853: AND su.STATUS = 'A'

Line 7890: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

7886:
7887: -- Bug 3988537.
7888: BEGIN
7889: SELECT 'Y' INTO l_dummy
7890: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
7891: WHERE CUST_ACCT_SITE_ID = nvl(p_cust_site_use_rec.cust_acct_site_id,l_cust_acct_site_id)
7892: AND SITE_USE_CODE = nvl(p_cust_site_use_rec.site_use_code,l_site_use_code)
7893: AND SITE_USE_ID <> nvl(p_cust_site_use_rec.site_use_id,fnd_api.g_miss_num)
7894: AND STATUS = 'A'

Line 7992: HZ_CUST_SITE_USES_ALL su

7988: --Bug No : 2998504. Status check added to the where clause.
7989:
7990: SELECT 'Y' INTO l_dummy
7991: FROM HZ_CUST_ACCT_SITES_ALL site,
7992: HZ_CUST_SITE_USES_ALL su
7993: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
7994: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
7995: AND su.SITE_USE_CODE = l_site_use_code
7996: AND su.LOCATION = p_cust_site_use_rec.location

Line 8065: HZ_CUST_SITE_USES_ALL su

8061: IF l_site_use_code = 'SHIP_TO' THEN
8062: BEGIN
8063: SELECT 'Y' INTO l_dummy
8064: FROM HZ_CUST_ACCT_SITES_ALL site,
8065: HZ_CUST_SITE_USES_ALL su
8066: WHERE su.SITE_USE_ID = p_cust_site_use_rec.bill_to_site_use_id
8067: AND su.SITE_USE_CODE = 'BILL_TO'
8068: AND su.STATUS = 'A'
8069: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID

Line 8116: FROM hz_cust_site_uses_all hsu

8112: THEN
8113: BEGIN
8114: SELECT 'Y'
8115: INTO l_exist_flag
8116: FROM hz_cust_site_uses_all hsu
8117: WHERE hsu.site_use_code = 'SHIP_TO'
8118: AND hsu.status = 'A'
8119: AND hsu.bill_to_site_use_id = p_cust_site_use_rec.site_use_id
8120: AND rownum = 1;

Line 8161: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',

8157:
8158: hz_orig_system_ref_pub.get_owner_table_id
8159: (p_orig_system => p_cust_site_use_rec.orig_system,
8160: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
8161: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
8162: x_owner_table_id => l_mosr_owner_table_id,
8163: x_return_status => l_temp_return_status);
8164:
8165: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 10733: FROM HZ_CUST_SITE_USES_ALL

10729: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
10730: BEGIN
10731:
10732: SELECT org_id INTO l_org_id
10733: FROM HZ_CUST_SITE_USES_ALL
10734: WHERE SITE_USE_ID = p_column_value;
10735:
10736: -- Bug 4650473. Check if org is accessible.
10737: BEGIN