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_SERIAL_TXN_INTERFACE

Line 313: from wsm_serial_txn_interface wsti,

309: decode(wsti.attribute12 , l_null_char ,l_miss_char , wsti.attribute12 ),
310: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
311: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
312: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
313: from wsm_serial_txn_interface wsti,
314: mtl_serial_numbers msn
315: where header_id = p_header_id
316: and transaction_type_id = 1
317: and wsti.serial_number = msn.serial_number (+)

Line 3056: from wsm_serial_txn_interface wsti,

3052: decode(wsti.attribute12 , l_null_char ,l_miss_char , wsti.attribute12 ),
3053: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
3054: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
3055: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
3056: from wsm_serial_txn_interface wsti,
3057: mtl_serial_numbers msn
3058: where wsti.header_id = p_header_id
3059: and wsti.transaction_type_id = 2
3060: and (wsti.action_flag >= 5 AND wsti.action_flag <= 6) -- select the move/scrap

Line 3150: from wsm_serial_txn_interface wsti,

3146: decode(wsti.attribute12 , l_null_char ,l_miss_char , wsti.attribute12 ),
3147: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
3148: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
3149: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
3150: from wsm_serial_txn_interface wsti,
3151: mtl_serial_numbers msn
3152: where wsti.header_id = p_header_id
3153: and wsti.transaction_type_id = 2
3154: and (nvl(wsti.action_flag,wsti.generate_serial_number) >= 1 AND nvl(wsti.action_flag,wsti.generate_serial_number) <= 3) -- select the move/scrap

Line 3236: update wsm_serial_txn_interface

3232: l_stmt_num := 30;
3233: -- issue an update statement to the interface records setting them to errored..
3234: l_row_updated := 0;
3235: IF p_wsm_serial_nums_tbl.count = 0 THEN
3236: update wsm_serial_txn_interface
3237: set process_status = wip_constants.error
3238: where header_id = p_header_id
3239: and transaction_type_id = 2;
3240:

Line 3320: update wsm_serial_txn_interface wsti

3316:
3317: l_stmt_num := 70;
3318: l_row_updated := 0;
3319: IF p_wsm_serial_nums_tbl.count = 0 then
3320: update wsm_serial_txn_interface wsti
3321: set wsti.process_status = wip_constants.error
3322: where wsti.header_id = p_header_id
3323: and wsti.transaction_type_id = 2
3324: and wsti.action_flag in (5,6);

Line 3353: update wsm_serial_txn_interface wsti

3349: ELSE
3350: l_stmt_num := 90;
3351:
3352: IF p_wsm_serial_nums_tbl.count = 0 then
3353: update wsm_serial_txn_interface wsti
3354: set wsti.process_status = wip_constants.error
3355: where wsti.header_id = p_header_id
3356: and wsti.transaction_type_id = 2
3357: and wsti.action_flag in (5,6)

Line 5148: from wsm_serial_txn_interface wsti,

5144: decode(wsti.attribute12 , l_null_char ,l_miss_char , wsti.attribute12 ),
5145: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
5146: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
5147: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
5148: from wsm_serial_txn_interface wsti,
5149: mtl_serial_numbers msn
5150: where header_id = p_header_id
5151: and transaction_type_id = 3
5152: and wsti.serial_number = msn.serial_number (+)

Line 5297: update wsm_serial_txn_interface wsti

5293: p_run_log_level => l_log_level
5294: );
5295: END IF;
5296:
5297: update wsm_serial_txn_interface wsti
5298: set wsti.process_status = wip_constants.error
5299: where wsti.header_id = p_header_id
5300: and wsti.transaction_type_id = 3
5301: and serial_number not in ( SELECT MSN.serial_number

Line 5341: update wsm_serial_txn_interface wsti

5337:
5338: elsif p_wlt_txn_type = (WSMPCNST.UPDATE_QUANTITY) THEN
5339:
5340: l_stmt_num := 60;
5341: update wsm_serial_txn_interface wsti
5342: set wsti.process_status = wip_constants.error
5343: where wsti.header_id = p_header_id
5344: and wsti.transaction_type_id = 3
5345: and action_flag not in (WSM_GASSOC_SERIAL_NUM,WSM_ADD_SERIAL_NUM);

Line 7742: insert into wsm_serial_txn_interface

7738: l_stmt_num := 20;
7739:
7740: -- We are having a direct insert because
7741: -- this procedure will be invoked for a batch of move txn records each belonging to a distinct job
7742: insert into wsm_serial_txn_interface
7743: (
7744: HEADER_ID ,
7745: TRANSACTION_TYPE_ID ,
7746: SERIAL_NUMBER ,

Line 8355: from wsm_serial_txn_interface wsti

8351: attribute12 ,
8352: attribute13 ,
8353: attribute14 ,
8354: attribute15
8355: from wsm_serial_txn_interface wsti
8356: where header_id IN (Select wmt.transaction_id
8357: from wip_move_transactions wmt,
8358: wsm_lot_move_txn_interface wlmti
8359: where wlmti.group_id = p_group_id

Line 8805: delete from wsm_serial_txn_interface

8801:
8802: l_stmt_num := 270;
8803:
8804: forall l_header in indices OF l_serial_txn_tbl
8805: delete from wsm_serial_txn_interface
8806: where header_id = l_serial_txn_tbl(l_header)
8807: and transaction_type_id = 5;
8808:
8809: end loop;