eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WSM_LOT_BASED_JOBS

Line 764: -- Query up the serial_start_flag from WSM_LOT_BASED_JOBS

760: END IF;
761:
762: l_stmt_num := 60;
763: --
764: -- Query up the serial_start_flag from WSM_LOT_BASED_JOBS
765: --
766: BEGIN
767: SELECT WDJ.serialization_start_op,
768: first_serial_txn_id,

Line 773: FROM WSM_LOT_BASED_JOBS WLBJ,WIP_DISCRETE_JOBS WDJ

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:

Line 3661: -- if serialization begun at this move transaction update the field in WSM_LOT_BASED_JOBS, WIP_DISCRETE_JOBS

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;

Line 3667: UPDATE WSM_LOT_BASED_JOBS

3663: THEN
3664:
3665: l_stmt_num := 40;
3666: -- Update WDJ also...
3667: UPDATE WSM_LOT_BASED_JOBS
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;

Line 3730: -- WSM_LOT_BASED_JOBS

3726: END IF;
3727: end if;
3728:
3729: -- if the old txn_id = first serial move transaction id, then clear the fields in
3730: -- WSM_LOT_BASED_JOBS
3731: l_stmt_num := 70;
3732:
3733: -- The field in WDJ can be cleared only after the Txn is successful...
3734: UPDATE WSM_LOT_BASED_JOBS

Line 3734: UPDATE WSM_LOT_BASED_JOBS

3730: -- WSM_LOT_BASED_JOBS
3731: l_stmt_num := 70;
3732:
3733: -- The field in WDJ can be cleared only after the Txn is successful...
3734: UPDATE WSM_LOT_BASED_JOBS
3735: set first_serial_txn_id = null
3736: WHERE wip_entity_id = p_wip_entity_id
3737: AND first_serial_txn_id = p_old_move_txn_id;
3738:

Line 3742: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' records in WSM_LOT_BASED_JOBS',

3738:
3739: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
3740: l_msg_tokens.delete;
3741: WSM_log_PVT.logMessage (p_module_name => l_module ,
3742: p_msg_text => 'Updated ' || SQL%ROWCOUNT || ' records in WSM_LOT_BASED_JOBS',
3743: p_stmt_num => l_stmt_num ,
3744: p_msg_tokens => l_msg_tokens ,
3745: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
3746: p_run_log_level => l_log_level

Line 6796: update wsm_lot_based_jobs

6792: from wsm_sm_resulting_jobs
6793: where transaction_id = p_txn_id);
6794:
6795: -- We set the first_serial_txn_id as a non-NULL value as some code depends on it.. in Move
6796: update wsm_lot_based_jobs
6797: set first_serial_txn_id = -1
6798: where wip_entity_id in (select wip_entity_id
6799: from wsm_sm_resulting_jobs
6800: where transaction_id = p_txn_id);

Line 7019: update wsm_lot_based_jobs

7015: from wsm_sm_resulting_jobs
7016: where transaction_id = p_txn_id);
7017:
7018: -- We set the first_serial_txn_id to NULL as some code depends on it.. in Move
7019: update wsm_lot_based_jobs
7020: set first_serial_txn_id = -1
7021: where wip_entity_id in (select wip_entity_id
7022: from wsm_sm_resulting_jobs
7023: where transaction_id = p_txn_id);

Line 8197: wsm_lot_based_jobs wlbj

8193: wmt.wip_entity_id
8194: from mtl_serial_numbers msn,
8195: wip_move_transactions wmt,
8196: wsm_lot_move_txn_interface wlmti,
8197: wsm_lot_based_jobs wlbj
8198: where wlmti.group_id = p_group_id
8199: and wlmti.internal_group_id = p_internal_group_id
8200: and wlmti.wip_entity_id = wmt.wip_entity_id
8201: and wmt.group_id = p_internal_group_id

Line 8219: wsm_lot_based_jobs wlbj

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
8223: and wlmti.status = WIP_CONSTANTS.COMPLETED

Line 8241: wsm_lot_based_jobs wlbj

8237: msn.current_organization_id,
8238: wmt.wip_entity_id
8239: from mtl_serial_numbers msn,
8240: wip_move_transactions wmt,
8241: wsm_lot_based_jobs wlbj
8242: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)
8243: and wmt.wip_entity_id = wlbj.wip_entity_id
8244: and wlbj.first_serial_txn_id IS NULL
8245: and msn.inventory_item_id = wmt.primary_item_id

Line 8259: wsm_lot_based_jobs wlbj

8255: wmt.wip_entity_id
8256: from mtl_serial_numbers msn,
8257: wip_move_transactions wmt,
8258: wip_serial_move_transactions wsmt,
8259: wsm_lot_based_jobs wlbj
8260: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)
8261: and wmt.wip_entity_id = wlbj.wip_entity_id
8262: and wmt.transaction_id = wsmt.transaction_id
8263: and wlbj.first_serial_txn_id = -1 -- It will be set to -1 only for those jobs created through Lot Creation form..