[Home] [Help]
379: -- Get the staus of the job...
380: -- has to be only (1,3,6) Unreleased, Released or ONHold..
381: select status_type
382: into l_status_type
383: from wip_discrete_jobs
384: where wip_entity_id = p_wip_entity_id
385: and organization_id = p_organization_id;
386:
387: -- Fix for Bug 4665172 : Move this code after the code to fetch the data from the intf table.
769: WLBJ.serialization_start_op
770: INTO x_serial_start_flag,
771: x_first_serial_txn_id,
772: x_serial_start_op
773: FROM WSM_LOT_BASED_JOBS WLBJ,WIP_DISCRETE_JOBS WDJ
774: WHERE WLBJ.wip_entity_id = p_wip_entity_id
775: AND WDJ.wip_entity_id = WLBJ.wip_entity_id
776: AND WLBJ.organization_id = p_organization_id;
777:
919: l_stmt_num := 30;
920:
921: SELECT start_quantity
922: into l_job_qty
923: from wip_discrete_jobs
924: where wip_entity_id = p_wip_entity_id
925: and organization_id = p_organization_id;
926:
927: BEGIN
3657: p_run_log_level => l_log_level
3658: );
3659: END IF;
3660:
3661: -- if serialization begun at this move transaction update the field in WSM_LOT_BASED_JOBS, WIP_DISCRETE_JOBS
3662: IF l_old_serial_track_flag IS NULL and x_serial_track_flag IS NOT NULL
3663: THEN
3664:
3665: l_stmt_num := 40;
3668: SET first_serial_txn_id = p_move_txn_id
3669: WHERE wip_entity_id = p_wip_entity_id;
3670:
3671: l_stmt_num := 50;
3672: UPDATE WIP_DISCRETE_JOBS
3673: SET serialization_start_op = 10
3674: WHERE wip_entity_id = p_wip_entity_id;
3675:
3676: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3675:
3676: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3677: l_msg_tokens.delete;
3678: WSM_log_PVT.logMessage (p_module_name => l_module ,
3679: p_msg_text => 'Updated WIP_DISCRETE_JOBS to set the serialization_start_op',
3680: p_stmt_num => l_stmt_num ,
3681: p_msg_tokens => l_msg_tokens ,
3682: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3683: p_run_log_level => l_log_level
5200: -- These two can cause error...
5201: select we.wip_entity_id,wdj.primary_item_id
5202: into l_wip_entity_id,l_inventory_item_id
5203: from wip_entities we,
5204: wip_discrete_jobs wdj
5205: where we.wip_entity_name = p_wip_entity_name
5206: and we.wip_entity_id = wdj.wip_entity_id
5207: and we.organization_id = p_organization_id;
5208:
5241: -- These two can cause error...
5242: select we.wip_entity_id,wdj.primary_item_id
5243: into l_wip_entity_id,l_inventory_item_id
5244: from wip_entities we,
5245: wip_discrete_jobs wdj
5246: where we.wip_entity_name = nvl(p_wip_entity_name,we.wip_entity_name)
5247: and we.wip_entity_id = wdj.wip_entity_id
5248: and we.wip_entity_id = p_wip_entity_id
5249: and we.organization_id = p_organization_id;
5418:
5419: CURSOR c_job_serials IS
5420: select serial_number
5421: from mtl_serial_numbers MSN,
5422: wip_discrete_jobs WDJ
5423: where MSN.inventory_item_id = WDJ.primary_item_id
5424: and MSN.wip_entity_id = p_split_txn_job_id
5425: and MSN.current_organization_id = WDJ.organization_id
5426: and WDJ.wip_entity_id = p_split_txn_job_id
6785: and nvl(MSN.intraoperation_step_type,-1) <> 5;
6786:
6787: -- If the parent is serial tracked then all child jobs will also be serial tracked...
6788: IF l_serial_start_flag IS NOT NULL THEN
6789: update wip_discrete_jobs
6790: set serialization_start_op = 10
6791: where wip_entity_id in (select wip_entity_id
6792: from wsm_sm_resulting_jobs
6793: where transaction_id = p_txn_id);
7008: END IF;
7009:
7010: -- If the parent is serial tracked then all child jobs will also be serial tracked...
7011: IF l_serial_start_flag IS NOT NULL THEN
7012: update wip_discrete_jobs
7013: set serialization_start_op = 10
7014: where wip_entity_id in (select wip_entity_id
7015: from wsm_sm_resulting_jobs
7016: where transaction_id = p_txn_id);
8214: msn.current_organization_id,
8215: wdj.wip_entity_id
8216: from mtl_serial_numbers msn,
8217: wsm_lot_move_txn_interface wlmti,
8218: wip_discrete_jobs wdj,
8219: wsm_lot_based_jobs wlbj
8220: where wlmti.group_id = p_group_id
8221: and wlmti.internal_group_id = p_internal_group_id
8222: and wlmti.wip_entity_id = wdj.wip_entity_id