5d.399. Account Purchase (OCI360_ACCOUNTDETAILS)

         PURCHASE$PURCHASEDRESOURCES$PURCHASETYPE
         *

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(16)
 PAYG                                                                                         VARCHAR2(1)
 STATUS                                                                                       VARCHAR2(8)
 PROMOTION                                                                                    VARCHAR2(1)
 SOFTLIMIT                                                                                    NUMBER
 BILLINGTYPE                                                                                  VARCHAR2(16)
 SERVICETYPE                                                                                  VARCHAR2(4)
 HARDLIMITALL                                                                                 NUMBER
 HARDLIMITNEW                                                                                 NUMBER
 CANONICALLINK                                                                                VARCHAR2(128)
 ENTITLEMENTID                                                                                VARCHAR2(16)
 CLOUDBUCKSTYPE                                                                               VARCHAR2(8)
 OVERAGESALLOWED                                                                              VARCHAR2(8)
 SUBSCRIPTIONTYPE                                                                             VARCHAR2(16)
 SUBSCRIPTIONCATEGORY                                                                         VARCHAR2(16)
 BALANCE$ID                                                                                   VARCHAR2(16)
 BALANCE$CREATEDON                                                                            VARCHAR2(32)
 BALANCE$PURCHASEDRESOURCES$NAME                                                              VARCHAR2(32)
 BALANCE$PURCHASEDRESOURCES$UNIT                                                              VARCHAR2(4)
 BALANCE$PURCHASEDRESOURCES$VALUE                                                             NUMBER
 BALANCE$PURCHASEDRESOURCES$DERIVED                                                           VARCHAR2(1)
 BALANCE$PURCHASEDRESOURCES$CREATEDON                                                         VARCHAR2(32)
 BALANCE$PURCHASEDRESOURCES$MODIFIEDON                                                        VARCHAR2(32)
 PURCHASE$ID                                                                                  VARCHAR2(16)
 PURCHASE$CREATEDON                                                                           VARCHAR2(32)
 PURCHASE$SOFTLIMIT                                                                           NUMBER
 PURCHASE$HARDLIMITALL                                                                        NUMBER
 PURCHASE$HARDLIMITNEW                                                                        NUMBER
 PURCHASE$OVERAGESALLOWED                                                                     VARCHAR2(8)
 PURCHASE$PURCHASEDRESOURCES$NAME                                                             VARCHAR2(64)
 PURCHASE$PURCHASEDRESOURCES$UNIT                                                             VARCHAR2(4)
 PURCHASE$PURCHASEDRESOURCES$VALUE                                                            NUMBER
 PURCHASE$PURCHASEDRESOURCES$DERIVED                                                          VARCHAR2(1)
 PURCHASE$PURCHASEDRESOURCES$ENDDATE                                                          VARCHAR2(32)
 PURCHASE$PURCHASEDRESOURCES$CREATEDON                                                        VARCHAR2(32)
 PURCHASE$PURCHASEDRESOURCES$STARTDATE                                                        VARCHAR2(32)
 PURCHASE$PURCHASEDRESOURCES$DISPLAYNAME                                                      VARCHAR2(64)
 PURCHASE$PURCHASEDRESOURCES$SERVICENAME                                                      VARCHAR2(4)
 RUNNINGBALANCE$ID                                                                            VARCHAR2(16)
 RUNNINGBALANCE$CREATEDON                                                                     VARCHAR2(32)
 RUNNINGBALANCE$PURCHASEDRESOURCES$NAME                                                       VARCHAR2(32)
 RUNNINGBALANCE$PURCHASEDRESOURCES$UNIT                                                       VARCHAR2(4)
 RUNNINGBALANCE$PURCHASEDRESOURCES$VALUE                                                      NUMBER
 RUNNINGBALANCE$PURCHASEDRESOURCES$DERIVED                                                    VARCHAR2(1)
 RUNNINGBALANCE$PURCHASEDRESOURCES$CREATEDON                                                  VARCHAR2(32)
 RUNNINGBALANCE$PURCHASEDRESOURCES$MODIFIEDON                                                 VARCHAR2(32)


SELECT   PURCHASE$ID,
         PURCHASE$CREATEDON,
         PURCHASE$SOFTLIMIT,
         PURCHASE$HARDLIMITALL,
         PURCHASE$HARDLIMITNEW,
         PURCHASE$OVERAGESALLOWED,
         PURCHASE$PURCHASEDRESOURCES$NAME,
         PURCHASE$PURCHASEDRESOURCES$UNIT,
         PURCHASE$PURCHASEDRESOURCES$VALUE,
         PURCHASE$PURCHASEDRESOURCES$ENDDATE,
         PURCHASE$PURCHASEDRESOURCES$CREATEDON,
         PURCHASE$PURCHASEDRESOURCES$STARTDATE,
         PURCHASE$PURCHASEDRESOURCES$PURCHASETYPE
FROM     OCI360_ACCOUNTDETAILS t1
WHERE    PURCHASE$ID is not null
ORDER BY PURCHASE$PURCHASEDRESOURCES$STARTDATE ASC;


-1 rows selected.