craft central Craft Central, Craft Directory
Industry Overview | Craft Publications | Trade Associations | Articles
   
craft central
Art and Craft SuppliersCraft Manufacturers DirectoryCraft Suppliers DirectoryCraft IndustryCraft Wholesaler Suppliers
Create Free Website
select * from ( SELECT ETO_OFR_ID, A.FK_GL_COUNTRY_ISO, OFR_DATE, GL_COUNTRY_ISO, ETO_OFR_TITLE, PRE_ISO,OFR_DATE_DIFF_INMINUTE FROM ( select * from ( SELECT ETO_OFR.ETO_OFR_DISPLAY_ID ETO_OFR_ID, ETO_OFR.FK_GLCAT_CAT_ID, ETO_OFR.FK_GL_COUNTRY_ISO, FN_OFR_CAD(ETO_OFR.ETO_CREDITS, ETO_OFR.ETO_OFR_POSTDATE_ORIG, ETO_OFR.ETO_OFR_QUALITY, ETO_OFR.ETO_OFR_RESPONSE) OFRCAD, TO_CHAR(ETO_OFR.ETO_OFR_DATE,'DD MON') OFR_DATE, (SYSDATE - ETO_OFR.ETO_OFR_DATE)*24*60 OFR_DATE_DIFF_INMINUTE, ETO_OFR.FK_GLUSR_USR_ID, ETO_OFR.ETO_OFR_TITLE ,(TRUNC(ETO_OFR.ETO_OFR_EXP_DATE) - TRUNC(SYSDATE)) DATE_DIFF, LAG(ETO_OFR.FK_GL_COUNTRY_ISO, 1, 0) OVER(PARTITION BY 1 ORDER BY ETO_OFR_DATE DESC) PRE_ISO FROM ETO_OFR , HT_GLCAT_GRP_TO_CAT WHERE ETO_OFR.ETO_OFR_TYP = 'B' AND ETO_OFR.ETO_OFR_QUALITY <> 'D' AND ETO_OFR.ETO_OFR_APPROV = 'A' AND ETO_OFR.ETO_OFR_PREFERED_FK_GLUSR_ID IS NULL AND ETO_OFR.FK_GLCAT_CAT_ID = HT_GLCAT_GRP_TO_CAT.FK_GLCAT_CAT_ID AND FK_HT_GLCAT_GRP_ID in(24) ORDER BY ETO_OFR_DATE DESC ) where rownum <=40) A, GLUSR_USR, GL_COUNTRY WHERE A.FK_GLUSR_USR_ID = GLUSR_USR.GLUSR_USR_ID and GL_COUNTRY.GL_COUNTRY_ISO = GLUSR_USR.FK_GL_COUNTRY_ISO and GLUSR_USR.GLUSR_USR_APPROV IN ('A','W') AND DECODE(GL_COUNTRY_ISO, 'IN', DECODE(PRE_ISO, 'IN', 0, 1), 1)=1)

ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 691 in 'select * from ( SELECT ETO_OFR_ID, A.FK_GL_COUNTRY_ISO, OFR_DATE, GL_COUNTRY_ISO, ETO_OFR_TITLE, PRE_ISO,OFR_DATE_DIFF_INMINUTE FROM ( select * from ( SELECT ETO_OFR.ETO_OFR_DISPLAY_ID ETO_OFR_ID, ETO_OFR.FK_GLCAT_CAT_ID, ETO_OFR.FK_GL_COUNTRY_ISO, FN_OFR_CAD(ETO_OFR.ETO_CREDITS, ETO_OFR.ETO_OFR_POSTDATE_ORIG, ETO_OFR.ETO_OFR_QUALITY, ETO_OFR.ETO_OFR_RESPONSE) OFRCAD, TO_CHAR(ETO_OFR.ETO_OFR_DATE,'DD MON') OFR_DATE, (SYSDATE - ETO_OFR.ETO_OFR_DATE)*24*60 OFR_DATE_DIFF_INMINUTE, ETO_OFR.FK_GLUSR_USR_ID, ETO_OFR.ETO_OFR_TITLE ,(TRUNC(ETO_OFR.ETO_OFR_EXP_DATE) - TRUNC(SYSDATE)) DATE_DIFF, LAG(ETO_OFR.FK_GL_COUNTRY_ISO, 1, 0) OVER(PARTITION BY 1 ORDER BY ETO_OFR_DATE DESC) PRE_ISO FROM <*>ETO_OFR , HT_GLCAT_GRP_TO_CAT WHERE ETO_OFR.ETO_OFR_TYP = 'B' AND ETO_OFR.ETO_OFR_QUALITY <> 'D' AND ETO_OFR.ETO_OFR_APPROV = 'A' AND ETO_OFR.ETO_OFR_PREFERED_FK_GLUSR_ID IS NULL AND ETO_OFR.FK_GLCAT_CAT_ID = HT_GLCAT_GRP_TO_CAT.FK_GLCAT_CAT_ID AND FK_HT_GLCAT_GRP_ID in(24) ORDER BY ETO_OFR_DATE DESC ) where rownum <=40) A, GLUSR_USR, GL_COUNTRY WHERE A.FK_GLUSR_USR_ID = GLUSR_USR.GLUSR_USR_ID and GL_COUNTRY.GL_COUNTRY_ISO = GLUSR_USR.FK_GL_COUNTRY_ISO and GLUSR_USR.GLUSR_USR_APPROV IN ('A','W') AND DECODE(GL_COUNTRY_ISO, 'IN', DECODE(PRE_ISO, 'IN', 0, 1), 1)=1)')
Featured Articles
How to Select Chandeliers? ...
Technically speaking, a chandelier is a branched, decorative lighting fixture that has a number of bulbs or candles and is suspended from a ceiling. However, speaking from the point of interior decor, it is one such lighting that is capable of giving unique style to any room of your ....

Click for Article Archive » »
Recent Articles

Publications

Trade Associations
Japan

Click for more Associations » »

Craft Central- Global Marketplace
Welcome to the comprehensive crafts products suppliers directory, the global platform to source and share business information. Craftcentral.com offers a rich and reliable database of craft products manufacturers, exporters, suppliers, wholesalers, and other crafts traders. It also provides value added services in form of industry relevant news and analysis, information about trade associations, tenders and publications, articles, trade fairs and much more along with free business listing for craft product manufacturers, suppliers and traders..

List Your Business | Disclaimer | Feedback
Copyright © craftcentral.com. All rights reserved