VIEW: APPS.INV_3PL_CLIENTS_V

Source

View Text - Preformatted

SELECT DISTINCT client_param.client_name, client_param.client_code, client_param.client_number, client_param.client_id, contract_header.authoring_org_id from mtl_client_parameters_v client_param, mtl_service_contracts_v contract_header WHERE EXISTS (SELECT 1 FROM mtl_billing_rule_lines rule_line, mtl_billing_rule_headers_vl rule_headers, okc_k_lines_b contract_line WHERE client_param.client_code = rule_line.client_code AND rule_line.service_agreement_line_id = contract_line.id AND rule_headers.billing_rule_header_id = rule_line.billing_rule_header_id and contract_header.id = rule_headers.service_agreement_id and sysdate between contract_line.start_date AND contract_line.end_date)

View Text - HTML Formatted

SELECT DISTINCT CLIENT_PARAM.CLIENT_NAME
, CLIENT_PARAM.CLIENT_CODE
, CLIENT_PARAM.CLIENT_NUMBER
, CLIENT_PARAM.CLIENT_ID
, CONTRACT_HEADER.AUTHORING_ORG_ID
FROM MTL_CLIENT_PARAMETERS_V CLIENT_PARAM
, MTL_SERVICE_CONTRACTS_V CONTRACT_HEADER
WHERE EXISTS (SELECT 1
FROM MTL_BILLING_RULE_LINES RULE_LINE
, MTL_BILLING_RULE_HEADERS_VL RULE_HEADERS
, OKC_K_LINES_B CONTRACT_LINE
WHERE CLIENT_PARAM.CLIENT_CODE = RULE_LINE.CLIENT_CODE
AND RULE_LINE.SERVICE_AGREEMENT_LINE_ID = CONTRACT_LINE.ID
AND RULE_HEADERS.BILLING_RULE_HEADER_ID = RULE_LINE.BILLING_RULE_HEADER_ID
AND CONTRACT_HEADER.ID = RULE_HEADERS.SERVICE_AGREEMENT_ID
AND SYSDATE BETWEEN CONTRACT_LINE.START_DATE
AND CONTRACT_LINE.END_DATE)