Product: | OKS - Service Contracts |
---|---|
Description: | View for the table subscription elements |
Implementation/DBA Data: | APPS.OKS_SUBSCR_ELEMENTS_V |
SELECT SCES.ROWID ROW_ID
, SCES.ID ID
, SCES.OSH_ID OSH_ID
, SCES.DNZ_CHR_ID DNZ_CHR_ID
, SCES.DNZ_CLE_ID DNZ_CLE_ID
, SCES.LINKED_FLAG LINKED_FLAG
, SCES.SEQ_NO SEQ_NO
, SCES.OM_INTERFACE_DATE
, SCES.AMOUNT AMOUNT
, SCES.START_DATE
, SCES.END_DATE
, SCES.QUANTITY
, SCES.UOM_CODE
, SCES.ORDER_HEADER_ID
, SCES.ORDER_LINE_ID
, SCES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SCES.CREATED_BY CREATED_BY
, SCES.CREATION_DATE
, SCES.LAST_UPDATED_BY
, SCES.LAST_UPDATE_DATE
, SCES.LAST_UPDATE_LOGIN
FROM OKS_SUBSCR_ELEMENTS SCES