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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MTL_BILLING_RULE_LINES_V

Object Details

Object Name:	MTL_BILLING_RULE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_BILLING_RULE_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row ID
BILLING_RULE_LINE_ID	NUMBER		Billing Rule Line ID
BILLING_RULE_HEADER_ID	NUMBER		Billing rule header ID
CLIENT_ID	NUMBER		Client ID
CLIENT_CODE	VARCHAR2	(10)	Client Code
CLIENT_NUMBER	VARCHAR2	(30)	Client Number
CLIENT_NAME	VARCHAR2	(360)	Client Name
CONTRACT_ID	NUMBER		Contract ID
AUTHORING_ORG_ID	NUMBER		Authorization organization ID
CONTRACT_NUMBER	VARCHAR2	(120)	Contract Number
RULE_NAME	VARCHAR2	(80)	Bill Rule Name
SERVICE_ITEM	VARCHAR2	(40)	Service Item
SERVICE_ITEM_ORG_ID	VARCHAR2	(200)	Service Item Organization ID
SERVICE_AGREEMENT_LINE_ID	NUMBER		Service agreement line ID
INVENTORY_ITEM_ID	NUMBER		Inventory item ID
BILLING_UOM	VARCHAR2	(3)	Billing Unit of Measurement
SERVICE_LINE_START_DATE	DATE		Service line start date
SERVICE_LINE_END_DATE	DATE		Service line end date
BILLING_SOURCE_ID	NUMBER		Billing Source Id
BILLING_SOURCE_CODE	VARCHAR2	(1)	Billing source code
BILLING_SOURCE_NAME	VARCHAR2	(80)	Billing source name
COUNTER_ITEM_ID	NUMBER		Counter of Item ID
COUNTER_NAME	VARCHAR2	(80)	Counter Name
NET_READING	NUMBER		Net reading
LAST_COMPUTATION_DATE	DATE		Last calculation date
LAST_READING	NUMBER		Last reading
CREATION_DATE	DATE		Creation date
CREATED_BY	NUMBER		Created by
LAST_UPDATE_DATE	DATE		Last updated date
LAST_UPDATED_BY	NUMBER		Last updated by
LAST_UPDATE_LOGIN	NUMBER		Last updated login details

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.MTL_BILLING_RULE_LINES_V;

Dependencies

[top of page]

APPS.MTL_BILLING_RULE_LINES_V references the following:

APPS: CSI_COUNTERS_VL; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; INV_3PL_BILLING_COUNTER_PVT - show dependent code; MTL_BILLING_RULE_HEADERS_VL; MTL_BILLING_RULE_LINES; MTL_BILLING_SOURCES_VL; MTL_FETCH_AGREEMENT_LINES

APPS.MTL_BILLING_RULE_LINES_V is referenced by following:

APPS: INV_3PL_BILLING_UNITS_PVT - show dependent code