317: schedule_seq_num
318: )
319: select
320: SYSDATE,
321: FND_GLOBAL.USER_ID,
322: SYSDATE,
323: FND_GLOBAL.USER_ID,
324: FND_GLOBAL.LOGIN_ID,
325: p_organization_id,
319: select
320: SYSDATE,
321: FND_GLOBAL.USER_ID,
322: SYSDATE,
323: FND_GLOBAL.USER_ID,
324: FND_GLOBAL.LOGIN_ID,
325: p_organization_id,
326: l_next_wip_entity_id,
327: NULL,
320: SYSDATE,
321: FND_GLOBAL.USER_ID,
322: SYSDATE,
323: FND_GLOBAL.USER_ID,
324: FND_GLOBAL.LOGIN_ID,
325: p_organization_id,
326: l_next_wip_entity_id,
327: NULL,
328: l_next_operation_seq_num,
374: l_serial_number,
375: START_DATE,
376: COMPLETION_DATE,
377: SYSDATE,
378: FND_GLOBAL.USER_ID,
379: SYSDATE,
380: FND_GLOBAL.USER_ID,
381: LAST_UPDATE_LOGIN
382: from wip_operation_resources
376: COMPLETION_DATE,
377: SYSDATE,
378: FND_GLOBAL.USER_ID,
379: SYSDATE,
380: FND_GLOBAL.USER_ID,
381: LAST_UPDATE_LOGIN
382: from wip_operation_resources
383: where wip_entity_id = l_next_wip_entity_id
384: and organization_id = p_organization_id
419: schedule_seq_num
420: )
421: select
422: SYSDATE,
423: FND_GLOBAL.USER_ID,
424: SYSDATE,
425: FND_GLOBAL.USER_ID,
426: FND_GLOBAL.LOGIN_ID,
427: p_organization_id,
421: select
422: SYSDATE,
423: FND_GLOBAL.USER_ID,
424: SYSDATE,
425: FND_GLOBAL.USER_ID,
426: FND_GLOBAL.LOGIN_ID,
427: p_organization_id,
428: l_next_wip_entity_id,
429: NULL,
422: SYSDATE,
423: FND_GLOBAL.USER_ID,
424: SYSDATE,
425: FND_GLOBAL.USER_ID,
426: FND_GLOBAL.LOGIN_ID,
427: p_organization_id,
428: l_next_wip_entity_id,
429: NULL,
430: l_next_operation_seq_num,
487: instance_rec.serial_number,
488: START_DATE,
489: COMPLETION_DATE,
490: SYSDATE,
491: FND_GLOBAL.USER_ID,
492: SYSDATE,
493: FND_GLOBAL.USER_ID,
494: LAST_UPDATE_LOGIN
495: from wip_operation_resources
489: COMPLETION_DATE,
490: SYSDATE,
491: FND_GLOBAL.USER_ID,
492: SYSDATE,
493: FND_GLOBAL.USER_ID,
494: LAST_UPDATE_LOGIN
495: from wip_operation_resources
496: where wip_entity_id = l_next_wip_entity_id
497: and organization_id = p_organization_id