DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on STANDARD

Line 127: standard_operation_id,

123: first_unit_start_date,
124: first_unit_completion_date,
125: last_unit_start_date,
126: last_unit_completion_date,
127: standard_operation_id,
128: description,
129: long_description,
130: attribute_category,
131: attribute1,

Line 169: bos.standard_operation_id,

165: bos.backflush_flag,
166: nvl(bos.minimum_transfer_quantity, 0),
167: p_startDate, p_endDate,
168: p_startDate, p_endDate,
169: bos.standard_operation_id,
170: bos.operation_description,
171: bos.long_description,
172: bos.attribute_category,
173: bos.attribute1,

Line 220: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,

216: group by bos.operation_seq_num,
217: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
218: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
219: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
220: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
221: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
222: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,
223: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,
224: bos.attribute14, bos.attribute15, bos.check_skill;

Line 269: standard_rate_flag,

265: activity_id,
266: scheduled_flag,
267: assigned_units,
268: autocharge_type,
269: standard_rate_flag,
270: applied_resource_units,
271: applied_resource_value,
272: start_date,
273: completion_date,

Line 317: bor.standard_rate_flag,

313: bor.activity_id,
314: bor.schedule_flag,
315: bor.assigned_units,
316: bor.autocharge_type,
317: bor.standard_rate_flag,
318: 0, 0,
319: p_startDate,
320: p_endDate,
321: bor.schedule_seq_num,

Line 404: standard_rate_flag,

400: activity_id,
401: scheduled_flag,
402: assigned_units,
403: autocharge_type,
404: standard_rate_flag,
405: applied_resource_units,
406: applied_resource_value,
407: start_date,
408: completion_date,

Line 452: bsor.standard_rate_flag,

448: bsor.activity_id,
449: bsor.schedule_flag,
450: bsor.assigned_units,
451: bsor.autocharge_type,
452: bsor.standard_rate_flag,
453: 0, 0,
454: wo.first_unit_start_date,
455: wo.last_unit_completion_date,
456: bsor.schedule_seq_num,

Line 519: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,

515:
516: INSERT INTO WIP_OPERATION_COMPETENCIES
517: (LEVEL_ID, ORGANIZATION_ID,
518: WIP_ENTITY_ID, OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID,
519: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,
520: QUALIFICATION_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
521: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
522: SELECT
523: 3, WO.ORGANIZATION_ID,

Line 525: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,

521: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
522: SELECT
523: 3, WO.ORGANIZATION_ID,
524: WO.WIP_ENTITY_ID, WO.OPERATION_SEQ_NUM, BOS.OPERATION_SEQUENCE_ID,
525: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
526: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
527: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
528: FROM BOM_OPERATION_SKILLS BOS,
529: WIP_OPERATIONS WO,

Line 654: if ( p_jobType = wip_constants.nonstandard ) then

650: l_entityType := wip_constants.repetitive;
651: end if;
652:
653: l_mrpFlag := wip_constants.yes;
654: if ( p_jobType = wip_constants.nonstandard ) then
655: l_mrpFlag := wip_constants.no;
656: end if;
657:
658: /*