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_ACCT_SITES_ALL

Line 2798: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;

2794: l_credit_classification HZ_CUSTOMER_PROFILES.CREDIT_CLASSIFICATION%TYPE;
2795:
2796: l_cust_acct_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;
2797: l_return_status VARCHAR2(1);
2798: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
2799:
2800: l_ckeck_acc_bfb_enabled VARCHAR2(1);
2801: ll_cons_inv_flag VARCHAR2(1);
2802:

Line 3458: FROM HZ_CUST_ACCT_SITES_ALL

3454: END;
3455:
3456: -- cust_account_id should be same as cust_account_id site_use_id belongs to.
3457: SELECT CUST_ACCOUNT_ID INTO l_cust_account_id
3458: FROM HZ_CUST_ACCT_SITES_ALL
3459: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3460:
3461: IF l_cust_account_id <> p_customer_profile_rec.cust_account_id THEN
3462: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_ACCT_SITEUSE_MISMATCH' );

Line 6755: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

6751: SELECT CUST_ACCOUNT_ID, PARTY_SITE_ID, ORIG_SYSTEM_REFERENCE,
6752: CREATED_BY_MODULE, APPLICATION_ID, STATUS, CUSTOMER_CATEGORY_CODE
6753: INTO l_cust_account_id, l_party_site_id, l_orig_system_reference,
6754: l_created_by_module, l_application_id, l_status, l_customer_category_code
6755: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
6756: WHERE ROWID = p_rowid;
6757: END IF;
6758:
6759: --------------------------------------

Line 6775: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

6771: p_cust_acct_site_rec.cust_acct_site_id <> FND_API.G_MISS_NUM
6772: THEN
6773: BEGIN
6774: SELECT 'Y' INTO l_dummy
6775: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
6776: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id;
6777:
6778: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
6779: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );

Line 6990: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

6986: -- cust_account_id and party_site_id together should be unique.
6987: -- Bug 3456489. Post MOAC, this uniqueness should be within orgs.
6988: BEGIN
6989: SELECT 'Y' INTO l_dummy
6990: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
6991: WHERE CUST_ACCOUNT_ID = p_cust_acct_site_rec.cust_account_id
6992: AND PARTY_SITE_ID = p_cust_acct_site_rec.party_site_id
6993: AND ORG_ID = p_cust_acct_site_rec.org_id -- Bug 3456489
6994: AND ROWNUM = 1;

Line 7041: FROM HZ_CUST_ACCT_SITES_ALL

7037: p_cust_acct_site_rec.orig_system_reference <> FND_API.G_MISS_CHAR
7038: THEN
7039: BEGIN
7040: SELECT 'Y' INTO l_dummy
7041: FROM HZ_CUST_ACCT_SITES_ALL
7042: WHERE ORIG_SYSTEM_REFERENCE = p_cust_acct_site_rec.orig_system_reference
7043: AND ORG_ID = p_cust_acct_site_rec.org_id;
7044:
7045: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );

Line 7085: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',

7081: then
7082: hz_orig_system_ref_pub.get_owner_table_id
7083: (p_orig_system => p_cust_acct_site_rec.orig_system,
7084: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
7085: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
7086: x_owner_table_id => l_mosr_owner_table_id,
7087: x_return_status => l_temp_return_status);
7088:
7089: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 7144: FROM HZ_CUST_ACCT_SITES_ALL

7140: p_cust_acct_site_rec.tp_header_id <> FND_API.G_MISS_NUM
7141: THEN
7142: BEGIN
7143: SELECT ROWID INTO l_rowid
7144: FROM HZ_CUST_ACCT_SITES_ALL
7145: WHERE TP_HEADER_ID = p_cust_acct_site_rec.tp_header_id
7146: AND ORG_ID = p_cust_acct_site_rec.org_id; -- Bug 3456489
7147:
7148: IF p_create_update_flag = 'C' OR

Line 7397: from hz_cust_acct_sites_all addr -- Bug 3456489

7393: p_cust_acct_site_rec.ece_tp_location_code <> FND_API.G_MISS_CHAR
7394: THEN
7395: select count(1)
7396: into l_count
7397: from hz_cust_acct_sites_all addr -- Bug 3456489
7398: where addr.cust_account_id = p_cust_acct_site_rec.cust_account_id
7399: and addr.ece_tp_location_code = p_cust_acct_site_rec.ece_tp_location_code
7400: and org_id = p_cust_acct_site_rec.org_id; -- Bug 3456489
7401:

Line 7415: from hz_cust_acct_sites_all addr -- Bug 3456489

7411: p_cust_acct_site_rec.ece_tp_location_code <> FND_API.G_MISS_CHAR
7412: THEN
7413: select count(1)
7414: into l_count
7415: from hz_cust_acct_sites_all addr -- Bug 3456489
7416: where addr.cust_account_id = l_cust_account_id
7417: and addr.ece_tp_location_code = p_cust_acct_site_rec.ece_tp_location_code
7418: and addr.cust_acct_site_id <> p_cust_acct_site_rec.cust_acct_site_id
7419: and org_id = p_cust_acct_site_rec.org_id; -- Bug 3456489

Line 7703: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

7699: -- Find customer account id this site use belongs to.
7700: -- For later use.
7701:
7702: SELECT CUST_ACCOUNT_ID INTO l_cust_account_id
7703: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
7704: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
7705:
7706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7707: hz_utility_v2pub.debug(p_message=>'(+) after validate cust_acct_site_id ... ' ||

Line 7848: FROM HZ_CUST_ACCT_SITES_ALL site,

7844:
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

Line 7991: FROM HZ_CUST_ACCT_SITES_ALL site,

7987:
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

Line 8064: FROM HZ_CUST_ACCT_SITES_ALL site,

8060: THEN
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'

Line 9484: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;

9480: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9481: l_validate_flag varchar2(1) := 'Y';
9482: l_mosr_owner_table_id number;
9483: l_return_status VARCHAR2(1);
9484: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
9485: l_temp_return_status VARCHAR2(10); -- for storing return status from
9486: -- hz_orig_system_ref_pub.get_owner_table_id
9487:
9488: BEGIN

Line 9753: FROM HZ_CUST_ACCT_SITES_ALL

9749: BEGIN
9750:
9751: SELECT CUST_ACCOUNT_ID,ORG_ID
9752: INTO l_cust_account_id,l_org_id
9753: FROM HZ_CUST_ACCT_SITES_ALL
9754: WHERE CUST_ACCT_SITE_ID = p_cust_account_role_rec.cust_acct_site_id;
9755:
9756: -- Bug 4650473. Check if org is accessible.
9757: BEGIN

Line 10707: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

10703:
10704: BEGIN
10705:
10706: SELECT 'Y' INTO l_dummy
10707: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
10708: WHERE CUST_ACCT_SITE_ID = p_column_value
10709: AND ORG_ID = p_org_id; -- Bug 3456489
10710:
10711: EXCEPTION

Line 10729: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;

10725: x_return_status IN OUT NOCOPY VARCHAR2
10726: ) IS
10727:
10728: l_return_status VARCHAR2(1);
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