[Home] [Help]
147: first_unit_start_date,
148: first_unit_completion_date,
149: last_unit_start_date,
150: last_unit_completion_date,
151: standard_operation_id,
152: description,
153: long_description,
154: attribute_category,
155: attribute1,
189: bos.backflush_flag,
190: nvl(bos.minimum_transfer_quantity, 0),
191: p_startDate, p_endDate,
192: p_startDate, p_endDate,
193: bos.standard_operation_id,
194: bos.operation_description,
195: bos.long_description,
196: bos.attribute_category,
197: bos.attribute1,
240: group by bos.operation_seq_num,
241: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
242: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
243: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
244: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
245: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
246: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,
247: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,
248: bos.attribute14, bos.attribute15, bos.check_skill;
289: activity_id,
290: scheduled_flag,
291: assigned_units,
292: autocharge_type,
293: standard_rate_flag,
294: applied_resource_units,
295: applied_resource_value,
296: start_date,
297: completion_date,
337: bor.activity_id,
338: bor.schedule_flag,
339: bor.assigned_units,
340: bor.autocharge_type,
341: bor.standard_rate_flag,
342: 0, 0,
343: p_startDate,
344: p_endDate,
345: bor.schedule_seq_num,
424: activity_id,
425: scheduled_flag,
426: assigned_units,
427: autocharge_type,
428: standard_rate_flag,
429: applied_resource_units,
430: applied_resource_value,
431: start_date,
432: completion_date,
472: bsor.activity_id,
473: bsor.schedule_flag,
474: bsor.assigned_units,
475: bsor.autocharge_type,
476: bsor.standard_rate_flag,
477: 0, 0,
478: wo.first_unit_start_date,
479: wo.last_unit_completion_date,
480: bsor.schedule_seq_num,
539:
540: INSERT INTO WIP_OPERATION_COMPETENCIES
541: (LEVEL_ID, ORGANIZATION_ID,
542: WIP_ENTITY_ID, OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID,
543: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,
544: QUALIFICATION_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
545: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
546: SELECT
547: 3, WO.ORGANIZATION_ID,
545: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
546: SELECT
547: 3, WO.ORGANIZATION_ID,
548: WO.WIP_ENTITY_ID, WO.OPERATION_SEQ_NUM, BOS.OPERATION_SEQUENCE_ID,
549: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
550: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
551: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
552: FROM BOM_OPERATION_SKILLS BOS,
553: WIP_OPERATIONS WO,
676: l_entityType := wip_constants.repetitive;
677: end if;
678:
679: l_mrpFlag := wip_constants.yes;
680: /*If non-standard job, set mrpFlag based on WIP: Enable MRP Net for Non-standard Job Requirements profile value for bug 7719689 (FP of bug 7506349) */
681: if ( p_jobType = wip_constants.nonstandard ) then
682: l_mrpFlag := TO_NUMBER(FND_PROFILE.value('WIP_NON_STD_MRP_NET')); /*code changed for bug 7719689 (FP of bug 7506349) */
683: end if;
684:
677: end if;
678:
679: l_mrpFlag := wip_constants.yes;
680: /*If non-standard job, set mrpFlag based on WIP: Enable MRP Net for Non-standard Job Requirements profile value for bug 7719689 (FP of bug 7506349) */
681: if ( p_jobType = wip_constants.nonstandard ) then
682: l_mrpFlag := TO_NUMBER(FND_PROFILE.value('WIP_NON_STD_MRP_NET')); /*code changed for bug 7719689 (FP of bug 7506349) */
683: end if;
684:
685: /*