View: INV_3PL_CLIENTS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INV_3PL_CLIENTS_V

View Text

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)

Columns