158: -- progress until all the child processes have
159: -- completed successfully.
160: -- ------------------------------------------------
161: /* FIX for BUG # 1695577 */
162: /* Removed TO_NUMBER(NULL) and replaced with STANDARD_QTY */
163: /* in the Select statement */
164:
165: INSERT INTO OPI_EDW_JOB_DETAIL_FSTG
166: (
311: TO_NUMBER(NULL),
312: TO_NUMBER(NULL),
313: TO_NUMBER(NULL),
314: TO_NUMBER(NULL),
315: STANDARD_QTY,
316: STD_TIME,
317: STD_VAL_B,
318: STD_VAL_B * CONVERSION_RATE,
319: 'NA_EDW',