[Compiere-cvslog] CVS: db/database/Create Views.sql,1.91,1.92

[Jorg J. <jj...@us...>]

Update of /cvsroot/compiere/db/database/Create
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30724/database/Create

Modified Files:
	Views.sql 
Log Message:


Index: Views.sql
===================================================================
RCS file: /cvsroot/compiere/db/database/Create/Views.sql,v
retrieving revision 1.91
retrieving revision 1.92
diff -C2 -d -r1.91 -r1.92
*** Views.sql	31 May 2005 18:47:02 -0000	1.91
--- Views.sql	24 Jul 2005 19:37:28 -0000	1.92
***************
*** 923,928 ****
  	i.C_BPartner_ID, i.DocumentNo, i.DateInvoiced, i.GrandTotal, i.GrandTotal AS AmtInWords
  FROM C_PaySelectionLine psl
!   INNER JOIN C_Invoice i ON (psl.C_Invoice_ID=i.C_Invoice_ID), AD_Language l
! WHERE l.IsBaseLanguage='N' AND l.IsSystemLanguage='Y'
  /
  
--- 923,928 ----
  	i.C_BPartner_ID, i.DocumentNo, i.DateInvoiced, i.GrandTotal, i.GrandTotal AS AmtInWords
  FROM C_PaySelectionLine psl
!   INNER JOIN C_Invoice i ON (psl.C_Invoice_ID=i.C_Invoice_ID)
!   INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
  /
  
***************
*** 1215,1219 ****
  AS
  SELECT pl.AD_Client_ID, pl.AD_Org_ID, pl.IsActive, pl.Created, pl.CreatedBy, pl.Updated, pl.UpdatedBy,
! 	'en_US' AS AD_Language,
      pj.C_Project_ID, pl.C_ProjectLine_ID,
      pl.Line, 
--- 1215,1219 ----
  AS
  SELECT pl.AD_Client_ID, pl.AD_Org_ID, pl.IsActive, pl.Created, pl.CreatedBy, pl.Updated, pl.UpdatedBy,
! 	l.AD_Language,
      pj.C_Project_ID, pl.C_ProjectLine_ID,
      pl.Line, 
***************
*** 1230,1233 ****
--- 1230,1234 ----
    INNER JOIN C_Project pj ON (pl.C_Project_ID=pj.C_Project_ID)
    LEFT OUTER JOIN M_Product p ON (pl.M_Product_ID=p.M_Product_ID)
+   INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
  WHERE pl.IsPrinted='Y'  
  /
***************
*** 1265,1269 ****
  SELECT rr.C_RfQResponse_ID, rr.C_RfQ_ID, 
      rr.AD_Client_ID, rr.AD_Org_ID, rr.IsActive, rr.Created, rr.CreatedBy, rr.Updated, rr.UpdatedBy,
! 	'en_US' AS AD_Language,
  	oi.C_Location_ID AS Org_Location_ID, oi.TaxID,
      r.Name, r.Description, r.Help,
--- 1266,1270 ----
  SELECT rr.C_RfQResponse_ID, rr.C_RfQ_ID, 
      rr.AD_Client_ID, rr.AD_Org_ID, rr.IsActive, rr.Created, rr.CreatedBy, rr.Updated, rr.UpdatedBy,
! 	l.AD_Language,
  	oi.C_Location_ID AS Org_Location_ID, oi.TaxID,
      r.Name, r.Description, r.Help,
***************
*** 1281,1284 ****
--- 1282,1286 ----
    INNER JOIN C_BPartner_Location bpl ON (rr.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID)
    LEFT OUTER JOIN AD_User bpc ON (rr.AD_User_ID=bpc.AD_User_ID)
+   INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
  /
  
***************
*** 1320,1324 ****
      rq.C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID,
      rrl.AD_Client_ID, rrl.AD_Org_ID, rrl.IsActive, rrl.Created, rrl.CreatedBy, rrl.Updated, rrl.UpdatedBy,
! 	'en_US' AS AD_Language,
      rl.Line,
      rl.M_Product_ID, rl.M_AttributeSetInstance_ID,
--- 1322,1326 ----
      rq.C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID,
      rrl.AD_Client_ID, rrl.AD_Org_ID, rrl.IsActive, rrl.Created, rrl.CreatedBy, rrl.Updated, rrl.UpdatedBy,
! 	l.AD_Language,
      rl.Line,
      rl.M_Product_ID, rl.M_AttributeSetInstance_ID,
***************
*** 1337,1340 ****
--- 1339,1343 ----
    INNER JOIN C_RfQLine rl ON (rrl.C_RfQLine_ID=rl.C_RfQLine_ID)
    LEFT OUTER JOIN M_Product p ON (rl.M_Product_ID=p.M_Product_ID)
+   INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
  WHERE rq.IsActive='Y' AND q.IsActive='Y'
    AND rrl.IsActive='Y' AND rl.IsActive='Y'
***************
*** 1364,1368 ****
  SELECT rq.C_RfQResponseLine_ID, rq.C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID,
      rq.AD_Client_ID, rq.AD_Org_ID, rq.IsActive, rq.Created, rq.CreatedBy, rq.Updated, rq.UpdatedBy,
! 	'en_US' AS AD_Language,
      q.C_UOM_ID, uom.UOMSymbol,
      q.Qty, rq.Price, rq.Discount
--- 1367,1371 ----
  SELECT rq.C_RfQResponseLine_ID, rq.C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID,
      rq.AD_Client_ID, rq.AD_Org_ID, rq.IsActive, rq.Created, rq.CreatedBy, rq.Updated, rq.UpdatedBy,
! 	l.AD_Language,
      q.C_UOM_ID, uom.UOMSymbol,
      q.Qty, rq.Price, rq.Discount
***************
*** 1370,1373 ****
--- 1373,1377 ----
    INNER JOIN C_RfQLineQty q ON (rq.C_RfQLineQty_ID=q.C_RfQLineQty_ID)
    INNER JOIN C_UOM uom ON (q.C_UOM_ID=uom.C_UOM_ID)
+   INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
  WHERE rq.IsActive='Y' AND q.IsActive='Y'
  /