APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MTL_CLIENT_PARAMETERS

Line 169: lc_client_id mtl_client_parameters.client_id%TYPE;

165: d_sql_p INTEGER := NULL;
166: d_sql_rows_processed INTEGER := NULL;
167: d_sql_stmt VARCHAR2(32700) := NULL;
168: d_space_seeded_src_used NUMBER := 0;
169: lc_client_id mtl_client_parameters.client_id%TYPE;
170: lc_client_code mtl_client_parameters.client_code%TYPE;
171: lc_client_name hz_parties.party_name%TYPE;
172: lc_client_number mtl_client_parameters.client_number%TYPE;
173: lc_contract_id okc_k_headers_all_b.id%TYPE;

Line 170: lc_client_code mtl_client_parameters.client_code%TYPE;

166: d_sql_rows_processed INTEGER := NULL;
167: d_sql_stmt VARCHAR2(32700) := NULL;
168: d_space_seeded_src_used NUMBER := 0;
169: lc_client_id mtl_client_parameters.client_id%TYPE;
170: lc_client_code mtl_client_parameters.client_code%TYPE;
171: lc_client_name hz_parties.party_name%TYPE;
172: lc_client_number mtl_client_parameters.client_number%TYPE;
173: lc_contract_id okc_k_headers_all_b.id%TYPE;
174: lc_contract_number okc_k_headers_all_b.contract_number%TYPE;

Line 172: lc_client_number mtl_client_parameters.client_number%TYPE;

168: d_space_seeded_src_used NUMBER := 0;
169: lc_client_id mtl_client_parameters.client_id%TYPE;
170: lc_client_code mtl_client_parameters.client_code%TYPE;
171: lc_client_name hz_parties.party_name%TYPE;
172: lc_client_number mtl_client_parameters.client_number%TYPE;
173: lc_contract_id okc_k_headers_all_b.id%TYPE;
174: lc_contract_number okc_k_headers_all_b.contract_number%TYPE;
175: lc_counter_item_id mtl_system_items.inventory_item_id%TYPE;
176: lc_net_Reading csi_counter_readings.net_Reading%TYPE;

Line 205: || 'mtl_client_parameters mcp '

201: 'SELECT count(*) cnt '
202: || 'FROM mtl_billing_rule_lines rule_lines, '
203: || 'mtl_billing_rule_headers_b rule_headers, '
204: || 'okc_k_headers_all_b contract_headers, '
205: || 'mtl_client_parameters mcp '
206: || 'WHERE rule_headers.billing_rule_header_id = rule_lines.billing_rule_header_id '
207: || 'AND contract_headers.authoring_org_id = :OU_Id '
208: || 'AND rule_headers.service_agreement_id = contract_headers.id '
209: || 'AND mcp.client_code = rule_lines.client_code ';

Line 304: FROM mtl_client_parameters

300: BEGIN
301: debug('Get l_client_code');
302: SELECT client_code
303: INTO l_client_code
304: FROM mtl_client_parameters
305: WHERE client_id = p_client_id;
306:
307: IF g_debug = 1 THEN
308: debug('l_client_code -> '||l_client_code);