Skip to main content
Question

Purchase Order View updated by error

  • December 23, 2021
  • 1 reply
  • 69 views

Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 8 replies

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.

This topic has been closed for comments

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings