create view ,sequence,synonym index

1.create view

CREATE OR REPLACE VIEW BND_WO_CONSUMPTIONS AS

SELECT "WIP_ENTITY_ID", "INVENTORY_ITEM_ID", "ORGANIZATION_ID", "TOTAL_DD_QTY","REMAIN_QTY","WO_CLOSE_DATE","ORG_ID","CREATED_BY","CREATION_DATE","LAST_UPDATE_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN"

     FROM bnd_wo_consumptions_all

    WHERE NVL (org_id,

               NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 1),

                                       ' ', NULL,

                                       SUBSTRB (USERENV ('CLIENT_INFO'), 1,

                                                10)

                                      )

                              ),

                    -99

                   )

              ) =

             NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 1),

                                     ' ', NULL,

                                     SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)

                                    )

                            ),

                  -99

                 )

-----------------------------------------------------------------------------------------------

2. create sequence

create sequence sequence_name_s

minvalue 100

maxvalue 99999   --- nomaxvalue

start with 200

increment by 1

cache 20;

---value  200 ,201,202,203

create synonym msl_bnd_ebpt_history for bnd.msl_bnd_ebpt_history

create index index_name on table_name(column_name)

select userenv('ISDBA') from dual --–Terminal,Client_info,language等

-- Grant/Revoke object privileges

grant select, insert, update, delete, references, alter, index on PO.MPO_SALE_RFQ_ALL to APPS;