APPS.WMS_RULES_WORKBENCH_PVT dependencies on HZ_PARTIES

Line 173: hz_parties party,

169:
170: Function get_customer_name(p_customer_id IN NUMBER)
171: Return VARCHAR2 is
172: /* TCA changes : replaced ra_customer by
173: hz_parties party,
174: hz_cust_accounts cust_acct
175: */
176: g_pkg_name constant VARCHAR2(50) := 'WMS_SELECTION_CRITERIA_PVT';
177: l_api_name constant VARCHAR2(30) := 'GET_CUSTOMER_NAME';

Line 179: l_customer_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

175: */
176: g_pkg_name constant VARCHAR2(50) := 'WMS_SELECTION_CRITERIA_PVT';
177: l_api_name constant VARCHAR2(30) := 'GET_CUSTOMER_NAME';
178:
179: l_customer_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
180: Begin
181:
182: /*select rc.customer_name
183: into l_customer_name

Line 189: FROM HZ_PARTIES PARTY,

185: where rc.customer_id = p_customer_id;*/
186:
187: /* SELECT distinct substrb ( PARTY.PARTY_NAME, 1, 50 )
188: INTO l_customer_name
189: FROM HZ_PARTIES PARTY,
190: HZ_CUST_ACCOUNTS CUST_ACCT
191: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
192: AND PARTY.PARTY_ID = p_customer_id; */
193:

Line 197: FROM HZ_PARTIES PARTY,

193:
194:
195: SELECT distinct substrb ( PARTY.PARTY_NAME, 1, 50 )
196: INTO l_customer_name
197: FROM HZ_PARTIES PARTY,
198: HZ_CUST_ACCOUNTS CUST_ACCT
199: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
200: AND CUST_ACCT.CUST_ACCOUNT_ID = p_customer_id;
201:

Line 2034: HZ_PARTIES hz

2030: oola.freight_carrier_code
2031: INTO l_customer_id,
2032: l_freight_code
2033: FROM oe_order_lines_all oola,
2034: HZ_PARTIES hz
2035: WHERE oola.line_id = l_trx_source_line_id
2036: AND hz.party_id = oola.sold_to_org_id;
2037:
2038: if l_debug = 1 then