APPS.WMS_RULES_WORKBENCH_PVT dependencies on HZ_PARTIES

Line 172: hz_parties party,

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

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

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

Line 188: FROM HZ_PARTIES PARTY,

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

Line 196: FROM HZ_PARTIES PARTY,

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

Line 1735: HZ_PARTIES hz

1731: oola.freight_carrier_code
1732: INTO l_customer_id,
1733: l_freight_code
1734: FROM oe_order_lines_all oola,
1735: HZ_PARTIES hz
1736: WHERE oola.line_id = l_trx_source_line_id
1737: AND hz.party_id = oola.sold_to_org_id;
1738:
1739: if l_debug = 1 then