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

VIEW: APPS.MTL_AGREEMENT_DETAILS_V

Object Details
Object Name: MTL_AGREEMENT_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_AGREEMENT_DETAILS_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 Mandatory Comments
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
CLIENT_CODE VARCHAR2 (10) Yes Client Code
CLIENT_ID NUMBER
Yes Client ID
CLIENT_NUMBER VARCHAR2 (30) Yes Client Number
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit Of Measure
SERVICE_LINE_START_DATE DATE

Service line start date
SERVICE_LINE_END_DATE DATE

Service line end date
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID
CLE_ID NUMBER
Yes ID of the Contract Line to which this item belongs. Refers to ID in OKC_K_LINES_B
DNZ_CHR_ID NUMBER
Yes Contract ID. Denormalized for performance.
CUST_ACCT_ID NUMBER (15)
Customer account
ID NUMBER
Yes System generated unique identifier. Primary key column of the table
Query Text

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


SELECT CONTRACT_NUMBER
,      CLIENT_CODE
,      CLIENT_ID
,      CLIENT_NUMBER
,      SEGMENT1
,      PRIMARY_UOM_CODE
,      SERVICE_LINE_START_DATE
,      SERVICE_LINE_END_DATE
,      INVENTORY_ITEM_ID
,      CLE_ID
,      DNZ_CHR_ID
,      CUST_ACCT_ID
,      ID
FROM APPS.MTL_AGREEMENT_DETAILS_V;

Dependencies

[top of page]

APPS.MTL_AGREEMENT_DETAILS_V references the following:

SchemaAPPS
SynonymMTL_CLIENT_PARAMETERS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
APPS.MTL_AGREEMENT_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyINV_3PL_BILLING_UNITS_PVT - show dependent code