Translate

Sunday, May 26, 2019

BEGIN
GO_BLOCK('XXPRG_IS');
FIRST_RECORD;
LOOP
IF :XXPRG_IS.DIS_HEADID  <> :XXPRG_IS.BS_ID_CHECK AND :XXPRG_IS.DIS_HEADID  <> :XXPRG_IS.ID_CHECK THEN
INSERT INTO XXPRG_REPORT(XXPRG_REPORT.HEADNAME,XXPRG_REPORT.HEADID)
VALUES(:XXPRG_IS.DIS_HEADNAME,:XXPRG_IS.DIS_HEADID);
END IF;
EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
END;

No comments:

Post a Comment

Text Message

WIP TABLES in Oracle Apps R12

  WIP TABLES Oracle Apps WIP KEY Tables   WIP_LINES   WIP_LINES stores production line information. Each row includes a line name, maximum a...