[Home] [Help]
566: wop.operation_seq_num,
567: wop.organization_id,
568: wop.repetitive_schedule_id
569: FROM wip_operations wop,
570: wip_repetitive_schedules wrs,
571: wip_move_txn_interface wmti
572: WHERE wop.organization_id = wmti.organization_id
573: AND wop.wip_entity_id = wmti.wip_entity_id
574: AND wmti.group_id = p_group_id
696: wo1.quantity_rejected reject_qty,
697: wo1.quantity_scrapped scrap_qty
698: FROM wip_operations wo1,
699: wip_operations wo2,
700: wip_repetitive_schedules wrs,
701: wip_mtl_allocations_temp wmat
702: WHERE wrs.repetitive_schedule_id = wmat.repetitive_schedule_id(+)
703: AND wrs.organization_id = wmat.organization_id(+)
704: AND wrs.organization_id = wo1.organization_id
5736: wmti.overcompletion_primary_qty oc_qty
5737: FROM wip_move_txn_interface wmti,
5738: wip_operations wo,
5739: wip_operation_resources wor,
5740: wip_repetitive_schedules wrs
5741: WHERE wmti.group_id = p_group_id
5742: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5743: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5744: AND wmti.overcompletion_transaction_qty IS NOT NULL
6136: mtl_system_items msi,
6137: mtl_parameters mp,
6138: hr_organization_information hoi,
6139: wip_entities we,
6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6142: wip_operations wo1,
6143: wip_operations wo2,
6144: wip_move_txn_allocations wma,
6564: mtl_system_items msi,
6565: mtl_parameters mp,
6566: hr_organization_information hoi,
6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
6570: wip_operations wo1,
6571: wip_operations wo2,
6572: wip_move_txn_allocations wma,
7664:
7665: /*****************************************************************************
7666: * This procedure is equivalent to witpsst_scrap_txns in wiltps5.ppc
7667: * This procedure is used to update scrap quantity in WIP_DISCRETE_JOBS for
7668: * discrete and OSFM jobs, and WIP_REPETITIVE_SCHEDULES for repetitive
7669: * schedules.
7670: * This procedure also insert into MTL_MATERIAL_TRANSACTIONS_TEMP for costing
7671: * purpose IF the user provide scrap account.
7672: ****************************************************************************/
7967: | For repetitive schedules, we do not set the date_closed, since this
7968: | is only done manually, via the form. It is not set automatically for
7969: | regular completions, so we will not set it here. rkaiser
7970: +------------------------------------------------------------------*/
7971: UPDATE wip_repetitive_schedules wrs
7972: SET (status_type) =
7973: (SELECT DECODE(SIGN(
7974: (wrs.daily_production_rate * wrs.processing_work_days -
7975: wrs.quantity_completed) -
7982: WHERE wrs.status_type IN (WIP_CONSTANTS.RELEASED,
7983: WIP_CONSTANTS.COMP_CHRG)
7984: AND wrs.rowid IN
7985: (SELECT wrs2.rowid
7986: FROM wip_repetitive_schedules wrs2,
7987: wip_move_txn_interface wmti
7988: WHERE wmti.group_id = p_gib.group_id
7989: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
7990: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
7999: -- IF debug message level = 2, write statement below to log file
8000: IF (l_logLevel <= wip_constants.full_logging) THEN
8001: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8002: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8003: fnd_message.set_token('ENTITY2', 'WIP_REPETITIVE_SCHEDULES');
8004: l_msg := fnd_message.get;
8005: wip_logger.log(p_msg => l_msg,
8006: x_returnStatus => l_returnStatus);
8007: END IF;
8267: p_gib.mtl_header_id, -- transaction_batch_id
8268: WIP_CONSTANTS.ASSY_BATCH_SEQ -- transaction_batch_seq
8269: FROM wip_move_txn_interface wmti,
8270: mtl_system_items msi,
8271: wip_repetitive_schedules wrs
8272: WHERE wmti.group_id = p_gib.group_id
8273: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8274: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
8275: AND wmti.process_status = WIP_CONSTANTS.RUNNING
8765: wmti.qa_collection_id
8766: FROM wip_move_txn_interface wmti,
8767: wip_operations wop,
8768: mtl_system_items msi,
8769: wip_repetitive_schedules wrs,
8770: wip_repetitive_items wri
8771: WHERE wmti.group_id = p_gib.group_id
8772: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8773: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC