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.WSMPLBMI dependencies on WIP_MOVE_TRANSACTIONS

Line 3831: from wip_move_transactions

3827: --***VJ Changed for Performance Upgrade***--
3828: BEGIN
3829: select max(transaction_id)
3830: into l_max_txn_id
3831: from wip_move_transactions
3832: where organization_id = p_org_id
3833: and wip_entity_id = l_wip_entity_id
3834: -- and to_operation_seq_num = g_prev_last_op -- l_wsm_last_op --**VJ: Deleted for removal of 9999**
3835: --***VJ Changed for Performance Upgrade***--

Line 3890: from wip_move_transactions

3886: l_cmp_txn_qty,
3887: l_cmp_batch_id,
3888: --l_wmt_scrap_acc, --bug 4090866 get scrap_account_id from WMT
3889: x_undo_source_code
3890: from wip_move_transactions
3891: where transaction_id = l_max_txn_id; --***VJ Changed for Performance Upgrade***--
3892:
3893: --mes
3894: IF ((nvl(x_undo_source_code, 'interface') IN ('move in oa page', 'move out oa page', 'jump oa page',

Line 3994: FROM WIP_MOVE_TRANSACTIONS WMT

3990: l_wmt_pri_scrap_qty,
3991: l_wmt_scrap_at_op_flag,
3992: x_old_scrap_transaction_id,
3993: l_wmt_scrap_acc
3994: FROM WIP_MOVE_TRANSACTIONS WMT
3995: WHERE organization_id = p_org_id
3996: and wip_entity_id = l_wip_entity_id
3997: --FP bug 5178168 (base bug 5168406) changed the line below
3998: --and WMT.batch_id=l_max_txn_id

Line 4430: FROM wip_move_transactions

4426: -- Start fix for bug #2095253
4427: BEGIN
4428: SELECT max(transaction_id)
4429: INTO l_txn_id
4430: FROM wip_move_transactions
4431: WHERE organization_id = p_org_id
4432: AND wip_entity_id = l_wip_entity_id
4433: --move enh added transaction_id = batch_id --FP bug 5178168 (base bug 5168406) changed the line below
4434: --AND transaction_id = batch_id;

Line 4467: from wip_move_transactions

4463: --***VJ Changed for Performance Upgrade***--
4464: BEGIN
4465: select max(transaction_id)
4466: into l_txn_id
4467: from wip_move_transactions
4468: where organization_id = p_org_id
4469: and wip_entity_id = l_wip_entity_id
4470: and to_operation_seq_num = l_wo_op_seq_num
4471: and to_intraoperation_step_type IN (l_wo_qty_iop_step, l_wo_qty_scrap_step)

Line 4536: from wip_move_transactions

4532: --bug 5349187 reversed part of the fix for bug 5185751 by uncommenting following line since
4533: --l_wmt_scrap_acct_id was not getting populated for undo of scrap only transaction
4534: l_wmt_scrap_acct_id,
4535: x_undo_source_code
4536: from wip_move_transactions
4537: where transaction_id = l_txn_id;
4538:
4539: --mes
4540:

Line 4583: FROM WIP_MOVE_TRANSACTIONS

4579: l_wmt_pri_scrap_qty,
4580: l_wmt_scrap_at_op_flag,
4581: x_old_scrap_transaction_id,
4582: l_wmt_scrap_acct_id
4583: FROM WIP_MOVE_TRANSACTIONS
4584: --move enh 115.135 added wip_entity_id after perf check
4585: WHERE wip_entity_id = l_wip_entity_id
4586: --FP bug 5178168 (base bug 5168406) changed the line below
4587: --AND batch_id=l_txn_id

Line 4600: p_msg_text => 'After select on WIP_MOVE_TRANSACTIONS: '||

4596: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4597: l_msg_tokens.delete;
4598: WSM_log_PVT.logMessage (
4599: p_module_name => l_module,
4600: p_msg_text => 'After select on WIP_MOVE_TRANSACTIONS: '||
4601: 'l_wmt_scrap_qty '||l_wmt_scrap_qty||
4602: '; l_wmt_pri_scrap_qty '||l_wmt_pri_scrap_qty||
4603: '; l_wmt_scrap_at_op_flag '||l_wmt_scrap_at_op_flag||
4604: '; l_wmt_pri_txn_qty '||l_wmt_pri_txn_qty||

Line 5502: from wip_move_transactions

5498:
5499: BEGIN
5500: select distinct(wip_entity_id)
5501: into l_temp
5502: from wip_move_transactions
5503: where organization_id = p_org_id
5504: and wip_entity_id = p_wip_entity_id
5505: and FM_OPERATION_SEQ_NUM = p_to_op_seq_num
5506: and nvl(FM_OPERATION_CODE, '&&!!@@') = nvl(p_to_op_code, '&&!!@@')

Line 5532: from wip_move_transactions

5528: select PRIMARY_QUANTITY, -- CZH: BUG2154720
5529: transaction_date -- ADD: BUG2804111 use txn time
5530: into l_orig_mv_txn_qty,
5531: l_wmt_time -- ADD: BUG2804111 use txn time
5532: from wip_move_transactions
5533: where transaction_id = ( select max(wmt1.transaction_id)
5534: from wip_move_transactions wmt1
5535: where wmt1.organization_id = p_org_id
5536: and wmt1.wip_entity_id = p_wip_entity_id

Line 5534: from wip_move_transactions wmt1

5530: into l_orig_mv_txn_qty,
5531: l_wmt_time -- ADD: BUG2804111 use txn time
5532: from wip_move_transactions
5533: where transaction_id = ( select max(wmt1.transaction_id)
5534: from wip_move_transactions wmt1
5535: where wmt1.organization_id = p_org_id
5536: and wmt1.wip_entity_id = p_wip_entity_id
5537: and wmt1.wsm_undo_txn_id IS NULL
5538: --move enh --FP bug 5178168 (base bug 5168406) changed the line below

Line 5651: from wip_move_transactions

5647: --select max(batch_id)
5648: select max(nvl(batch_id, transaction_id))
5649: -- into x_undone_txn_id
5650: into x_undone_batch_id
5651: from wip_move_transactions
5652: where organization_id = p_org_id
5653: and wip_entity_id = p_wip_entity_id
5654: and wsm_undo_txn_id IS NULL
5655: --FP bug 5178168 (base bug 5168406) changed the line below

Line 5678: update wip_move_transactions

5674: END IF;
5675: -- update transaction idi, so that
5676: --move enh
5677: l_stmt_num := 20;
5678: update wip_move_transactions
5679: --FP bug 5178168 (base bug 5168406) changed the line below
5680: --set wsm_undo_txn_id = decode(batch_id,
5681: set wsm_undo_txn_id = decode(nvl(batch_id, transaction_id),
5682: p_undo_txn_id, x_undone_batch_id,

Line 5691: /* update wip_move_transactions

5687: --FP bug 5178168 (base bug 5168406) changed the line below
5688: --and batch_id in (p_undo_txn_id, x_undone_batch_id);
5689: and nvl(batch_id, transaction_id) in (p_undo_txn_id, x_undone_batch_id);
5690:
5691: /* update wip_move_transactions
5692: set wsm_undo_txn_id = x_undone_batch_id
5693: where organization_id = p_org_id
5694: and wip_entity_id = p_wip_entity_id
5695: -- and transaction_id in (p_undo_txn_id, x_undone_txn_id);

Line 5698: update wip_move_transactions

5694: and wip_entity_id = p_wip_entity_id
5695: -- and transaction_id in (p_undo_txn_id, x_undone_txn_id);
5696: and batch_id = p_undo_txn_id;
5697:
5698: update wip_move_transactions
5699: set wsm_undo_txn_id = p_undo_txn_id
5700: where organization_id = p_org_id
5701: and wip_entity_id = p_wip_entity_id
5702: -- and transaction_id in (p_undo_txn_id, x_undone_txn_id);

Line 6201: l_undone_txn_source_code WIP_MOVE_TRANSACTIONS.source_code%type;

6197: --Bug 5480482:Following variable declaration is commented.
6198: --l_wco_fm_op_network_start WSM_COPY_OPERATIONS.network_start_end%TYPE;
6199: --l_wco_to_op_network_end WSM_COPY_OPERATIONS.network_start_end%TYPE;
6200: --l_wo_min_op_seq_num NUMBER;
6201: l_undone_txn_source_code WIP_MOVE_TRANSACTIONS.source_code%type;
6202: l_mes_scrap_txn_id NUMBER; --bug 5446252
6203: --MES END
6204:
6205: l_temp_txn_type NUMBER; --bug 4380374

Line 9624: and not exists (select 1 from wip_move_transactions wmt

9620: SET actual_start_date = p_operation_start_date,
9621: LAST_UPDATE_DATE = sysdate,
9622: LAST_UPDATED_BY = g_user_id
9623: WHERE wip_entity_id = l_wip_entity_id
9624: and not exists (select 1 from wip_move_transactions wmt
9625: where wmt.wip_entity_id = wdj.wip_entity_id
9626: and wmt.organization_id = wdj.organization_id
9627: and wmt.transaction_id <> l_transaction_id
9628: and wmt.wsm_undo_txn_id is NULL);

Line 9681: -- and not exists (select 1 from wip_move_transactions wmt

9677: -- SET actual_start_date = null,
9678: -- LAST_UPDATE_DATE = sysdate,
9679: -- LAST_UPDATED_BY = g_user_id
9680: -- WHERE wip_entity_id = l_wip_entity_id
9681: -- and not exists (select 1 from wip_move_transactions wmt
9682: -- where wmt.wip_entity_id = wdj.wip_entity_id
9683: -- and wmt.organization_id = wdj.organization_id
9684: -- and wmt.wsm_undo_txn_id is NULL);
9685: --END IF;

Line 10403: WIP_MOVE_TRANSACTIONS wmt,

10399: FROM WIP_OPERATIONS wop2,
10400: WIP_OPERATION_YIELDS woy2,
10401: WSM_PARAMETERS wp, -- ESA
10402: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10403: WIP_MOVE_TRANSACTIONS wmt,
10404: WSM_LOT_MOVE_TXN_INTERFACE wlmti
10405: --bug 3615826
10406: -- WHERE wmt.group_id = l_wmti_group_id
10407: WHERE wlmti.group_id = p_group_id

Line 10491: WIP_MOVE_TRANSACTIONS wmt,

10487: FROM WIP_OPERATIONS wop2,
10488: WIP_OPERATION_YIELDS woy2,
10489: WSM_PARAMETERS wp, -- ESA
10490: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10491: WIP_MOVE_TRANSACTIONS wmt,
10492: WSM_LOT_MOVE_TXN_INTERFACE wlmti
10493: --bug 3615826
10494: -- WHERE wmt.group_id = l_wmti_group_id
10495: WHERE wlmti.group_id = p_group_id

Line 10694: -- FROM wip_move_transactions wmt

10690: )
10691: *********/
10692: );
10693: -- AND wlmti.transaction_id IN (SELECT wmt.batch_id
10694: -- FROM wip_move_transactions wmt
10695: -- WHERE wmt.group_id = l_wmti_group_id);
10696:
10697: l_dup_flag NUMBER :=0;
10698: undo_jump_from_queue BOOLEAN := FALSE;

Line 10734: and not exists (select 1 from wip_move_transactions wmt

10730: SET actual_start_date = null,
10731: LAST_UPDATE_DATE = sysdate,
10732: LAST_UPDATED_BY = g_user_id
10733: WHERE wip_entity_id = rec.wip_entity_id
10734: and not exists (select 1 from wip_move_transactions wmt
10735: where wmt.wip_entity_id = wdj.wip_entity_id
10736: and wmt.organization_id = wdj.organization_id
10737: and wmt.wsm_undo_txn_id is NULL);
10738: end if;--End of check on source_code.

Line 10748: fnd_file.put_line(fnd_file.log, 'wip_move_transactions: set wsm_undo_txn_id failed');

10744: fnd_file.put_line(fnd_file.log, 'set_undo_txn_id undo_txn_id= '||l_undo_txn_id);
10745: END IF;
10746:
10747: IF (x_return_code <> 0) THEN
10748: fnd_file.put_line(fnd_file.log, 'wip_move_transactions: set wsm_undo_txn_id failed');
10749: END IF;
10750:
10751: END IF; /* End of if (undo_exists) */
10752: /* EA: CZH.JUMPENH */

Line 10811: -- FROM wip_move_transactions wmt

10807: l_wmti_group_id)
10808: )
10809: );
10810: -- AND wlmti.transaction_id IN (SELECT wmt.batch_id
10811: -- FROM wip_move_transactions wmt
10812: -- WHERE wmt.group_id = l_wmti_group_id);
10813: BEGIN
10814: FOR rec IN ac_ar_txns LOOP
10815:

Line 10872: and not exists (select 1 from wip_move_transactions wmt

10868: SET actual_start_date = null,
10869: LAST_UPDATE_DATE = sysdate,
10870: LAST_UPDATED_BY = g_user_id
10871: WHERE wip_entity_id = rec.wip_entity_id
10872: and not exists (select 1 from wip_move_transactions wmt
10873: where wmt.wip_entity_id = wdj.wip_entity_id
10874: and wmt.organization_id = wdj.organization_id
10875: and wmt.wsm_undo_txn_id is NULL);
10876: end if;--End of check on source_code.

Line 10887: fnd_file.put_line(fnd_file.log, 'wip_move_transactions: set wsm_undo_txn_id failed');

10883: fnd_file.put_line(fnd_file.log, 'set_undo_txn_id undo_txn_id= '||l_batch_id);
10884: END IF;
10885:
10886: IF (x_return_code <> 0) THEN
10887: fnd_file.put_line(fnd_file.log, 'wip_move_transactions: set wsm_undo_txn_id failed');
10888: END IF;
10889: -- Commented for bug 5286219. Code for trf reservation during return txn will be present
10890: -- before we call move processor.
10891: /*

Line 11019: -- from wip_move_transactions wmt,

11015: --
11016: -- -- Delete the inserted records for Attributes...
11017: -- DELETE wsm_serial_txn_interface
11018: -- WHERE header_id IN (Select wmt.transaction_id
11019: -- from wip_move_transactions wmt,
11020: -- wsm_lot_move_txn_interface wlmti
11021: -- where wlmti.group_id = l_wmti_group_id
11022: -- and wlmti.wip_entity_id = wmt.wip_entity_id
11023: -- and wlmti.status = WIP_CONSTANTS.COMPLETED)

Line 11057: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI

11053: UPDATE WIP_OPERATIONS
11054: SET wsm_costed_quantity_completed = quantity_completed
11055: WHERE ROWID IN
11056: (SELECT WO.ROWID
11057: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI
11058: WHERE WLMTI.group_id = p_group_id
11059: AND WMT.transaction_id = WLMTI.transaction_id
11060: AND WO.wip_entity_id = WMT.wip_entity_id
11061: AND (WO.operation_seq_num IN (WMT.fm_operation_seq_num, WMT.to_operation_seq_num))