[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|