cancel
Showing results for 
Search instead for 
Did you mean: 

BOM Updation alert

0 Kudos

Dear All,

Bill of Material update alert needed, because to update FG standard cost. Please help me

Accepted Solutions (1)

Accepted Solutions (1)

frank_wang6
Active Contributor
0 Kudos

SELECT Code FROM OITT T0

WHERE T0.UpdateDate IS NOT NULL

AND CONVERT(VARCHAR(10), T0.UpdateDate, 101) = CONVERT(VARCHAR(10), GETDATE(), 101)

Answers (1)

Answers (1)

Former Member
0 Kudos

BOM UPDATION ALERT:

select code,updatedate

as UpdatedOn,(select U_NAME from OUSR where UserSign2 in (select UserSign2 from AITT where UpdateDate='2011-09-19')) UpdatedBy

from AITT A1 where UpdateDate=

(select CONVERT(varchar(10), GETDATE(),121))