View: OKS_BILLPRST_USGSUBLINE_V

Product:	OKS - Service Contracts
Description:
Implementation/DBA Data:	APPS.OKS_BILLPRST_USGSUBLINE_V

View Text

SELECT 'USAGE' TYPE
, IT.NAME NAME
, CG.SOURCE_OBJECT_CODE || ';' || CP.SERIAL_NUMBER || ';' || CP.INSTANCE_NUMBER DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, TO_NUMBER(NULL) EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKX_SYSTEM_ITEMS_V IT
, CSI_ITEM_INSTANCES CP
, OKX_COUNTER_GROUPS_V CG
, OKX_COUNTERS_V COU
, OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
WHERE LINE.LSE_ID = 13
AND RLINE.CLE_ID = LINE.ID
AND ITM.CLE_ID = LINE.ID
AND LINE.DNZ_CHR_ID = HDR.ID
AND BSL.CLE_ID = LINE.ID
AND COU.ID1 = ITM.OBJECT1_ID1
AND CG.COUNTER_GROUP_ID = COU.COUNTER_GROUP_ID
AND CG.SOURCE_OBJECT_CODE = 'CP'
AND CG.SOURCE_OBJECT_ID = CP.INSTANCE_ID
AND IT.ID1 = CP.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = HDR.AUTHORING_ORG_ID
AND TXN.BSL_ID = BSL.ID
AND TXN.BCL_ID = BSL.BCL_ID

Columns