[Home] [Help]
25: TO_CHAR(NULL) site_uses,
26: -1 org_id,
27: 'N' selected,
28: TO_CHAR(NULL) location
29: FROM hz_cust_accounts cust,
30: hz_parties party
31: WHERE cust.party_id = party.party_id AND
32: cust.cust_account_id = p_customer_id
33:
51: -- For Bug# 13688313
52: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
53: HZ_LOCATIONS LOC ,
54: FND_TERRITORIES_VL T,
55: HZ_CUST_ACCOUNTS HCA,
56: HZ_PARTIES HP
57: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
58: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
59: AND PARTY_SITE.PARTY_ID = HCA.PARTY_ID
85: cus.org_id,
86: 'N' selected,
87: '' location
88: FROM
89: hz_cust_accounts cus,
90: hz_parties party,
91: ra_customer_trx ct
92: WHERE
93: ct.trx_number = p_search_criteria
109: TO_CHAR(NULL) site_uses,
110: -1 org_id,
111: 'N' selected,
112: TO_CHAR(NULL) location
113: FROM hz_cust_accounts cust,
114: hz_parties party
115: WHERE cust.party_id = party.party_id AND
116: cust.ACCOUNT_NUMBER LIKE p_customer_name_number
117:
129: TO_CHAR(NULL) site_uses,
130: -1 org_id,
131: 'N' selected,
132: TO_CHAR(NULL) location
133: FROM hz_cust_accounts cust,
134: hz_parties party
135: WHERE cust.party_id = party.party_id
136: AND party.PARTY_NAME LIKE p_customer_name_number
137: )
155: HZ_PARTY_SITES PARTY_SITE ,
156: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
157: HZ_LOCATIONS LOC ,
158: FND_TERRITORIES_VL T,
159: HZ_CUST_ACCOUNTS HCA,
160: HZ_PARTIES HP
161: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
162: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
163: AND PARTY_SITE.PARTY_ID = HCA.PARTY_ID
190: HZ_PARTY_SITES PARTY_SITE ,
191: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
192: HZ_LOCATIONS LOC ,
193: FND_TERRITORIES_VL T,
194: HZ_CUST_ACCOUNTS HCA,
195: HZ_PARTIES HP
196: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
197: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
198: AND PARTY_SITE.PARTY_ID = HCA.PARTY_ID
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:
220: -- Bug 2094233
221: -- krmenon 28 Dec 2001 Removed the order by clause for performance issues
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
232: AND adr.cust_account_id = cus.cust_account_id
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
927: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
928: AND cust.cust_account_id = Sites_assigned.cust_account_id
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
1127: Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
1128: AND cust.cust_account_id = Sites_assigned.cust_account_id
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
1261: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
1262: AND cust.cust_account_id = Sites_assigned.cust_account_id