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 106: -- srajasek 06-APR-00 Changed ra_addresses_all to hz_cust_acct_sites_all because of tca changes in 11.5.1

102:
103: --
104: -- Get ALL matching addresses returned by the context search
105: --
106: -- srajasek 06-APR-00 Changed ra_addresses_all to hz_cust_acct_sites_all because of tca changes in 11.5.1
107:
108: -- modified for tca uptake. replaced ra_customers with hz_cust_accounts and
109: -- hz_parties.
110:

Line 118: FROM hz_cust_acct_sites_all adr,

114: -- krmenon 07 Jan 2002 Changed the Cursor to remove extra joins and reintroduce
115: -- the order by score since this is necessary to get the high score results
116: CURSOR ctx_cur (p_keyword VARCHAR2) IS
117: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
118: FROM hz_cust_acct_sites_all adr,
119: hz_cust_accounts cus,
120: hz_parties party,
121: ar_system_parameters_all sys
122: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

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

125: AND adr.org_id = sys.org_id ;
126: ORDER BY score(1) desc, cus.cust_account_id,
127: party.party_name, cus.account_number, adr.cust_acct_site_id;
128: --*/
129: /* Bug2288089: Removed _all for hz_cust_acct_sites */
130: CURSOR ctx_cur (p_keyword VARCHAR2) IS
131: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
132: FROM hz_cust_acct_sites adr
133: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0

Line 132: FROM hz_cust_acct_sites adr

128: --*/
129: /* Bug2288089: Removed _all for hz_cust_acct_sites */
130: CURSOR ctx_cur (p_keyword VARCHAR2) IS
131: SELECT adr.cust_acct_site_id address_id, adr.cust_account_id customer_id, score(1) total_score
132: FROM hz_cust_acct_sites adr
133: WHERE ctxsys.CONTAINS (address_text, NVL(p_keyword, '%') , 1) > 0
134: ORDER BY score(1) desc;
135:
136: l_cust_tab cust_tab;

Line 786: hz_cust_acct_sites acct_sites,

782: CURSOR FETCH_SITES_ID_CURSOR IS
783: SELECT
784: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
785: FROM
786: hz_cust_acct_sites acct_sites,
787: hz_party_sites party_sites,
788: hz_cust_accounts Cust,
789: ar_sites_assigned_v Sites_assigned
790: WHERE Sites_assigned.party_id = p_party_id

Line 819: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id

815: IF (p_is_internal_user='Y') THEN
816:
817: IF ( p_site_use_id is null and p_customer_id is not null) THEN
818: FOR account_assigned_site IN (
819: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
820: )LOOP
821:
822: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
823: INSERT INTO ar_irec_user_acct_sites_all

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

854: 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)
855: )LOOP
856:
857: FOR account_assigned_site IN (
858: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
859: )LOOP
860:
861: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
862: INSERT INTO ar_irec_user_acct_sites_all

Line 919: hz_cust_acct_sites acct_sites,

915: CURSOR FETCH_SITES_ID_CURSOR IS
916: SELECT
917: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
918: FROM
919: hz_cust_acct_sites acct_sites,
920: hz_party_sites party_sites,
921: hz_cust_accounts Cust,
922: ar_sites_assigned_v Sites_assigned
923: WHERE -- Sites_assigned.party_id = p_party_id AND

Line 946: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id

942: IF (p_is_internal_user='Y') THEN
943:
944: IF ( p_site_use_id is null and p_customer_id is not null) THEN
945: FOR account_assigned_site IN (
946: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
947: )LOOP
948:
949: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
950: INSERT INTO ar_irec_user_acct_sites_all

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

981: select cust_account_id from ar_customers_assigned_v where cust_account_id=nvl(p_customer_id,cust_account_id)
982: )LOOP
983:
984: FOR account_assigned_site IN (
985: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
986: )LOOP
987:
988: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
989: INSERT INTO ar_irec_user_acct_sites_all

Line 1041: hz_cust_acct_sites acct_sites,

1037: CURSOR FETCH_SITES_ID_CURSOR IS
1038: SELECT
1039: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1040: FROM
1041: hz_cust_acct_sites acct_sites,
1042: hz_party_sites party_sites,
1043: hz_cust_accounts Cust,
1044: ar_sites_assigned_v Sites_assigned
1045: WHERE Sites_assigned.party_id = p_party_id

Line 1061: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id

1057: select person_party_id into p_party_id from fnd_user where user_id = p_user_id;
1058:
1059: IF (p_is_internal_user='Y') THEN
1060: FOR account_assigned_site IN (
1061: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
1062: )LOOP
1063: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1064: INSERT INTO ar_irec_user_acct_sites_all
1065: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)

Line 1083: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id

1079: END IF;
1080: END LOOP;
1081: /* Check for account level access and insert all bill to sites */
1082: FOR account_assigned_site IN (
1083: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id
1084: )LOOP
1085:
1086: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1087: INSERT INTO ar_irec_user_acct_sites_all