APPS.INV_3PL_BILLING_UNITS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 173: lc_contract_id okc_k_headers_all_b.id%TYPE;

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;
177: lc_last_reading csi_counter_readings.net_Reading%TYPE;

Line 174: lc_contract_number okc_k_headers_all_b.contract_number%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;
177: lc_last_reading csi_counter_readings.net_Reading%TYPE;
178: lc_billing_uom mtl_system_items.primary_uom_code%TYPE;

Line 204: || 'okc_k_headers_all_b contract_headers, '

200: d_sql_stmt :=
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 '