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.WMS_DEPLOY dependencies on HZ_PARTIES

Line 284: | hz_parties |

280: | fnd_api.g_ret_sts_error, if error occurred |
281: | x_client_id - The client ID for which the details needs to be passed |
282: | x_client_code - The client Code for which the details needs to be passed|
283: | x_client_name - The client name corresponding to client ID fetched from |
284: | hz_parties |
285: *================================================================================== */
286:
287:
288: PROCEDURE get_client_details

Line 292: , x_client_name OUT NOCOPY HZ_PARTIES.PARTY_NAME%TYPE

288: PROCEDURE get_client_details
289: (
290: x_client_id IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE
291: , x_client_code IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_CODE%TYPE
292: , x_client_name OUT NOCOPY HZ_PARTIES.PARTY_NAME%TYPE
293: , x_return_status OUT NOCOPY VARCHAR2
294: )as
295:
296: BEGIN

Line 324: FROM hz_parties client, hz_cust_accounts cust_account

320:
321: BEGIN
322: SELECT client.party_name
323: INTO x_client_name
324: FROM hz_parties client, hz_cust_accounts cust_account
325: WHERE client.party_id = cust_account.party_id
326: AND cust_account.cust_account_id = x_client_id;
327: END;
328: