DBA Data[Home] [Help]

APPS.INV_ONHAND_BALANCE dependencies on MTL_CLIENT_PARAMETERS

Line 84: FROM mtl_client_parameters

80: IF (l_wms_deployment_mode = 'L') THEN
81:
82: SELECT trading_partner_site_id
83: INTO l_Party_Site_ID
84: FROM mtl_client_parameters
85: WHERE client_id IN (SELECT cust_account_id
86: FROM hz_cust_accounts
87: WHERE party_id = P_txn_hist_record.trading_partner_id);
88:

Line 360: FROM mtl_client_parameters

356: SELECT party_id
357: INTO l_party_id
358: FROM hz_cust_accounts
359: WHERE cust_account_id IN (SELECT client_id
360: FROM mtl_client_parameters
361: WHERE client_code = P_client_code);
362: else
363:
364: select location_id