Skip to main content

Hello everyone

 

I have updated the purchase Order view by error , and the rowkey Activited is not checked also Prompt has been updated, It is an error due to this SQL  Request : ( the error is in the end of the request on comment on table “'LU=PurchaseRequisition^PROMPT=*lobby IFS-83^TABLE=SAV_PURCHASE_REQUISITION^MODULE=PURCH^';”) , LU is SAV_PURCHASE_REQUISITION and not PURCHASE_REQUISTION)

 

CREATE OR REPLACE VIEW SAV_PURCHASE_REQUISITION AS

SELECT

COUNT(*)

OVER(PARTITION BY requisitioner_code, objstate) AS nombre,

requisition_no,

requisitioner_code,

objstate

FROM

purchase_requisition

WHERE

objstate = 'Released'

AND requisitioner_code NOT IN ( 'INV', 'MRP', 'OE', 'INT', 'MS',

'WO' )

ORDER BY

requisitioner_code ASC,

objstate

WITH READ ONLY;

 

COMMENT ON TABLE "IFSAPP"."SAV_PURCHASE_REQUISITION" IS 'LU=PurchaseRequisition^PROMPT=*lobby IFS-83^TABLE=SAV_PURCHASE_REQUISITION^MODULE=PURCH^';

 

does someone know how to initialize the LU PURCHASE_REQUISTION PLEASE ? 

 

 

Thank you in Advance.