View: MTL_AGREEMENT_DETAILS_V

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

View Text

SELECT CONTRACT_HEADER.CONTRACT_NUMBER
, MCP.CLIENT_CODE
, MCP.CLIENT_ID
, MCP.CLIENT_NUMBER
, MSIB.CONCATENATED_SEGMENTS SEGMENT1
, MSIB.PRIMARY_UOM_CODE
, CONTRACT_LINES.START_DATE SERVICE_LINE_START_DATE
, CONTRACT_LINES.END_DATE SERVICE_LINE_END_DATE
, MSIB.INVENTORY_ITEM_ID
, OKI.CLE_ID
, OKI.DNZ_CHR_ID
, CONTRACT_LINES.CUST_ACCT_ID
, CONTRACT_HEADER.ID
FROM MTL_SYSTEM_ITEMS_B_KFV MSIB
, OKC_K_ITEMS OKI
, OKC_K_HEADERS_ALL_B CONTRACT_HEADER
, OKC_K_LINES_B CONTRACT_LINES
, MTL_CLIENT_PARAMETERS MCP
WHERE MSIB.INVENTORY_ITEM_ID = TO_NUMBER(OKI.OBJECT1_ID1)
AND MSIB.ORGANIZATION_ID = TO_NUMBER(OKI.OBJECT1_ID2)
AND OKI.DNZ_CHR_ID = CONTRACT_HEADER.ID
AND OKI.JTOT_OBJECT1_CODE = 'OKX_USAGE'
AND CONTRACT_LINES.CHR_ID = OKI.DNZ_CHR_ID
AND CONTRACT_LINES.ID = OKI.CLE_ID
AND MCP.CLIENT_ID = CONTRACT_LINES.CUST_ACCT_ID

Columns