eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_BILLING_RULE_LINES_V

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

View Text

SELECT RULE_LINES.ROWID ROW_ID
, RULE_LINES.BILLING_RULE_LINE_ID
, RULE_HEADER.BILLING_RULE_HEADER_ID
, AGREEMENT_LINES.CLIENT_ID
, AGREEMENT_LINES.CLIENT_CODE
, AGREEMENT_LINES.CLIENT_NUMBER
, AGREEMENT_LINES.CLIENT_NAME
, AGREEMENT_LINES.CONTRACT_ID
, AGREEMENT_LINES.AUTHORING_ORG_ID
, AGREEMENT_LINES.CONTRACT_NUMBER
, RULE_HEADER.NAME RULE_NAME
, AGREEMENT_LINES.SERVICE_ITEM
, AGREEMENT_LINES.SERVICE_ITEM_ORG_ID
, RULE_LINES.SERVICE_AGREEMENT_LINE_ID
, AGREEMENT_LINES.INVENTORY_ITEM_ID
, AGREEMENT_LINES.BILLING_UOM
, AGREEMENT_LINES.SERVICE_LINE_START_DATE
, AGREEMENT_LINES.SERVICE_LINE_END_DATE
, RULE_LINES.BILLING_SOURCE_ID
, SOURCES.BILLING_SOURCE_CODE
, SOURCES.NAME BILLING_SOURCE_NAME
, AGREEMENT_LINES.COUNTER_ITEM_ID
, COUNTERS.NAME
, AGREEMENT_LINES.NET_READING
, AGREEMENT_LINES.LAST_COMPUTATION_DATE
, AGREEMENT_LINES.LAST_READING
, RULE_LINES.CREATION_DATE
, RULE_LINES.CREATED_BY
, RULE_LINES.LAST_UPDATE_DATE
, RULE_LINES.LAST_UPDATED_BY
, RULE_LINES.LAST_UPDATE_LOGIN
FROM MTL_FETCH_AGREEMENT_LINES AGREEMENT_LINES
, CSI_COUNTERS_VL COUNTERS
, MTL_BILLING_RULE_HEADERS_VL RULE_HEADER
, MTL_BILLING_RULE_LINES RULE_LINES
, MTL_BILLING_SOURCES_VL SOURCES
WHERE RULE_HEADER.SERVICE_AGREEMENT_ID = AGREEMENT_LINES.CONTRACT_ID
AND RULE_HEADER.BILLING_RULE_HEADER_ID = RULE_LINES.BILLING_RULE_HEADER_ID
AND COUNTERS.COUNTER_ID = AGREEMENT_LINES.COUNTER_ITEM_ID
AND AGREEMENT_LINES.SERVICE_AGREEMENT_LINE_ID = RULE_LINES.SERVICE_AGREEMENT_LINE_ID
AND SOURCES.BILLING_SOURCE_ID(+) = RULE_LINES.BILLING_SOURCE_ID UNION SELECT NULL ROW_ID
, NULL BILLING_RULE_LINE_ID
, NULL BILLING_RULE_HEADER_ID
, AGREEMENT_LINES.CLIENT_ID
, AGREEMENT_LINES.CLIENT_CODE
, AGREEMENT_LINES.CLIENT_NUMBER
, AGREEMENT_LINES.CLIENT_NAME
, AGREEMENT_LINES.CONTRACT_ID
, AGREEMENT_LINES.AUTHORING_ORG_ID
, AGREEMENT_LINES.CONTRACT_NUMBER
, NULL RULE_NAME
, AGREEMENT_LINES.SERVICE_ITEM
, AGREEMENT_LINES.SERVICE_ITEM_ORG_ID
, AGREEMENT_LINES.SERVICE_AGREEMENT_LINE_ID
, AGREEMENT_LINES.INVENTORY_ITEM_ID
, AGREEMENT_LINES.BILLING_UOM
, AGREEMENT_LINES.SERVICE_LINE_START_DATE
, AGREEMENT_LINES.SERVICE_LINE_END_DATE
, NULL BILLING_SOURCE_ID
, NULL BILLING_SOURCE_CODE
, NULL BILLING_SOURCE_NAME
, AGREEMENT_LINES.COUNTER_ITEM_ID
, COUNTERS.NAME
, AGREEMENT_LINES.NET_READING
, AGREEMENT_LINES.LAST_COMPUTATION_DATE
, AGREEMENT_LINES.LAST_READING
, NULL CREATION_DATE
, NULL CREATED_BY
, NULL LAST_UPDATE_DATE
, NULL LAST_UPDATED_BY
, NULL LAST_UPDATE_LOGIN
FROM MTL_FETCH_AGREEMENT_LINES AGREEMENT_LINES
, CSI_COUNTERS_VL COUNTERS
WHERE COUNTERS.COUNTER_ID = AGREEMENT_LINES.COUNTER_ITEM_ID
AND NOT EXISTS ( SELECT 1
FROM MTL_BILLING_RULE_LINES MBRV
WHERE MBRV.SERVICE_AGREEMENT_LINE_ID = AGREEMENT_LINES.SERVICE_AGREEMENT_LINE_ID )

Columns

Name
ROW_ID
BILLING_RULE_LINE_ID
BILLING_RULE_HEADER_ID
CLIENT_ID
CLIENT_CODE
CLIENT_NUMBER
CLIENT_NAME
CONTRACT_ID
AUTHORING_ORG_ID
CONTRACT_NUMBER
RULE_NAME
SERVICE_ITEM
SERVICE_ITEM_ORG_ID
SERVICE_AGREEMENT_LINE_ID
INVENTORY_ITEM_ID
BILLING_UOM
SERVICE_LINE_START_DATE
SERVICE_LINE_END_DATE
BILLING_SOURCE_ID
BILLING_SOURCE_CODE
BILLING_SOURCE_NAME
COUNTER_ITEM_ID
COUNTER_NAME
NET_READING
LAST_COMPUTATION_DATE
LAST_READING
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN