VIEW: APPS.MTL_BILLING_RULE_LINES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )