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.ARW_SEARCH_CUSTOMERS dependencies on HZ_CUST_ACCT_SITES

Line 49: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

45: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
46: ACCT_SITE.org_id,
47: 'N' selected,
48: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
49: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
50: HZ_PARTY_SITES PARTY_SITE ,
51: -- For Bug# 13688313
52: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
53: HZ_LOCATIONS LOC ,

Line 154: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

150: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
151: ACCT_SITE.org_id,
152: 'N' selected,
153: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
154: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
155: HZ_PARTY_SITES PARTY_SITE ,
156: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
157: HZ_LOCATIONS LOC ,
158: FND_TERRITORIES_VL T,

Line 189: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

185: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
186: ACCT_SITE.org_id,
187: 'N' selected,
188: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
189: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
190: HZ_PARTY_SITES PARTY_SITE ,
191: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
192: HZ_LOCATIONS LOC ,
193: FND_TERRITORIES_VL T,

Line 215: -- srajasek 06-APR-00 Changed ra_addresses_all to hz_cust_acct_sites_all because of tca changes in 11.5.1

211:
212: --
213: -- Get ALL matching addresses returned by the context search
214: --
215: -- srajasek 06-APR-00 Changed ra_addresses_all to hz_cust_acct_sites_all because of tca changes in 11.5.1
216:
217: -- modified for tca uptake. replaced ra_customers with hz_cust_accounts and
218: -- hz_parties.
219:

Line 227: FROM hz_cust_acct_sites_all adr,

223: -- krmenon 07 Jan 2002 Changed the Cursor to remove extra joins and reintroduce
224: -- the order by score since this is necessary to get the high score results
225: CURSOR ctx_cur (p_keyword VARCHAR2) IS
226: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
227: FROM hz_cust_acct_sites_all adr,
228: hz_cust_accounts cus,
229: hz_parties party,
230: ar_system_parameters_all sys
231: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

Line 238: /* Bug2288089: Removed _all for hz_cust_acct_sites */

234: AND adr.org_id = sys.org_id ;
235: ORDER BY score(1) desc, cus.cust_account_id,
236: party.party_name, cus.account_number, adr.cust_acct_site_id;
237: --*/
238: /* Bug2288089: Removed _all for hz_cust_acct_sites */
239: CURSOR ctx_cur (p_keyword VARCHAR2) IS
240: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
241: FROM hz_cust_acct_sites adr
242: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

Line 241: FROM hz_cust_acct_sites adr

237: --*/
238: /* Bug2288089: Removed _all for hz_cust_acct_sites */
239: CURSOR ctx_cur (p_keyword VARCHAR2) IS
240: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
241: FROM hz_cust_acct_sites adr
242: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0
243: ORDER BY score(1) desc;
244:
245: l_cust_tab cust_tab;

Line 922: hz_cust_acct_sites acct_sites,

918: CURSOR FETCH_SITES_ID_CURSOR IS
919: SELECT
920: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id,acct_sites.org_id org_id
921: FROM
922: hz_cust_acct_sites acct_sites,
923: hz_party_sites party_sites,
924: hz_cust_accounts Cust,
925: ar_sites_assigned_v Sites_assigned
926: WHERE Sites_assigned.party_id = p_party_id

Line 974: select CUST_ACCT_SITE_ID,org_id from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id

970: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
971: VALUES(p_session_id,p_customer_id,'-1',p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
972:
973: FOR account_assigned_site IN (
974: select CUST_ACCT_SITE_ID,org_id from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
975: )LOOP
976:
977: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
978: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => account_assigned_site.org_id, p_customer_id => p_customer_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);

Line 1023: select CUST_ACCT_SITE_ID,org_id from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id

1019: select cust_account_id from ar_customers_assigned_v where party_id=p_party_id AND cust_account_id=nvl(p_customer_id,cust_account_id)
1020: )LOOP
1021:
1022: FOR account_assigned_site IN (
1023: select CUST_ACCT_SITE_ID,org_id from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
1024: )LOOP
1025: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1026: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => account_assigned_site.org_id, p_customer_id => customer_assigned_record.cust_account_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1027:

Line 1122: hz_cust_acct_sites acct_sites,

1118: CURSOR FETCH_SITES_ID_CURSOR IS
1119: SELECT
1120: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1121: FROM
1122: hz_cust_acct_sites acct_sites,
1123: hz_party_sites party_sites,
1124: hz_cust_accounts Cust,
1125: ar_sites_assigned_v Sites_assigned
1126: WHERE -- Sites_assigned.party_id = p_party_id AND

Line 1152: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id

1148: IF (p_is_internal_user='Y') THEN
1149:
1150: IF ( p_site_use_id is null and p_customer_id is not null) THEN
1151: FOR account_assigned_site IN (
1152: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
1153: )LOOP
1154:
1155: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1156: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => p_customer_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);

Line 1200: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id

1196: select cust_account_id from ar_customers_assigned_v where cust_account_id=nvl(p_customer_id,cust_account_id)
1197: )LOOP
1198:
1199: FOR account_assigned_site IN (
1200: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
1201: )LOOP
1202: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1203: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => customer_assigned_record.cust_account_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1204: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

Line 1256: hz_cust_acct_sites acct_sites,

1252: CURSOR FETCH_SITES_ID_CURSOR IS
1253: SELECT
1254: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1255: FROM
1256: hz_cust_acct_sites acct_sites,
1257: hz_party_sites party_sites,
1258: hz_cust_accounts Cust,
1259: ar_sites_assigned_v Sites_assigned
1260: WHERE Sites_assigned.party_id = p_party_id

Line 1283: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id

1279: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE,RELATED_CUSTOMER_FLAG)
1280: VALUES(p_session_id,p_customer_id,'-1',p_user_id,trunc(sysdate),p_org_id, trunc(sysdate),'Y');
1281:
1282: FOR account_assigned_site IN (
1283: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
1284: )LOOP
1285: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1286: INSERT INTO ar_irec_user_acct_sites_all
1287: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)

Line 1305: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id

1301: END IF;
1302: END LOOP;
1303: /* Check for account level access and insert all bill to sites */
1304: FOR account_assigned_site IN (
1305: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id
1306: )LOOP
1307:
1308: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1309: INSERT INTO ar_irec_user_acct_sites_all