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.