View: OKS_CONTRACT_DTLS_V

Product:	OKS - Service Contracts
Description:	Service contracts invoice details view.
Implementation/DBA Data:	APPS.OKS_CONTRACT_DTLS_V

View Text

SELECT A.CONTRACT_ID CONTRACT_ID
, A.CONTRACT_NUMBER CONTRACT_NUMBER
, A.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, A.START_DATE START_DATE
, A.END_DATE END_DATE
, A.STATUS STATUS
, A.SHORT_DESCRIPTION SHORT_DESCRIPTION
, A.PARTY_ID PARTY_ID
, A.PARTY_NUMBER PARTY_NUMBER
, A.PARTY_NAME PARTY_NAME
, A.HEADER_BTO_ADDRESS HEADER_BTO_ADDRESS
, A.CURRENCY CURRENCY
, A.ORG_ID ORG_ID
, A.INV_ORG_ID INV_ORG_ID
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, B.LINE_ID LINE_ID
, B.LINE_REFERENCE LINE_REFERENCE
, B.SERVICE_LINE_NUMBER SERVICE_LINE_NUMBER
, B.SERVICE_NAME SERVICE_NAME
, B.SERVICE_START_DATE SERVICE_START_DATE
, B.SERVICE_END_DATE SERVICE_END_DATE
, B.CUSTOMER_ACCOUNT_NAME CUSTOMER_ACCOUNT_NAME
, B.LINE_BTO_ADDRESS LINE_BTO_ADDRESS
, B.LINE_STO_ADDRESS LINE_STO_ADDRESS
, C.COVD_LINE_ID COVD_LINE_ID
, C.COVD_LINE_NUMBER COVD_LINE_NUMBER
, C.COVD_LINE_LSE_ID COVD_LINE_LSE_ID
, C.COVERED_LEVEL COVERED_LEVEL
, C.COVERED_SYSTEM COVERED_SYSTEM
, C.COVERED_SERIAL_NO COVERED_SERIAL_NO
, C.COVD_DESCRIPTION COVD_DESCRIPTION
, C.OBJECT_ID OBJECT_ID
, C.QUANTITY QUANTITY
, C.QTY_UOM QTY_UOM
, C.PRICE PRICE
, D.INVOICE_NUMBER
, D.INVOICE_DATE
, D.INVOICE_LINE_TAX_AMOUNT
, D.INVOICE_LINE_AMOUNT
, D.BILL_INSTANCE_NUMBER
, D.BILL_FROM_DATE
, D.BILL_TO_DATE
FROM OKS_HEADER_DETAILS_V A
, OKS_LINE_DETAILS_V B
, OKS_PROD_DETAILS_V C
, OKS_BILLING_DTLS_V D
WHERE A.CONTRACT_ID = B.CONTRACT_ID
AND B.LINE_ID = C.LINE_ID
AND C.COVD_LINE_ID = D.CLE_ID(+)

Columns