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.WIP_WICTPG dependencies on WIP_SERIAL_MOVE_TRANSACTIONS

Line 511: x_purge_rec.table_name := 'WIP_SERIAL_MOVE_TRANSACTIONS';

507: x_purge_rec.info_type := ROWS_AFFECTED;
508: x_purge_rec.entity_name := p_purge_request.wip_entity_name;
509: x_purge_rec.line_code := p_purge_request.line_code;
510:
511: x_purge_rec.table_name := 'WIP_SERIAL_MOVE_TRANSACTIONS';
512: if ( p_option = REPORT_ONLY ) then
513: select count(*) into x_num_rows
514: from wip_serial_move_transactions wsmt
515: where wsmt.transaction_id in (select wmt.transaction_id

Line 514: from wip_serial_move_transactions wsmt

510:
511: x_purge_rec.table_name := 'WIP_SERIAL_MOVE_TRANSACTIONS';
512: if ( p_option = REPORT_ONLY ) then
513: select count(*) into x_num_rows
514: from wip_serial_move_transactions wsmt
515: where wsmt.transaction_id in (select wmt.transaction_id
516: from wip_move_transactions wmt
517: where wmt.wip_entity_id = x_purge_rec.wip_entity_id);
518: else

Line 519: delete from wip_serial_move_transactions

515: where wsmt.transaction_id in (select wmt.transaction_id
516: from wip_move_transactions wmt
517: where wmt.wip_entity_id = x_purge_rec.wip_entity_id);
518: else
519: delete from wip_serial_move_transactions
520: where transaction_id in (select wmt.transaction_id
521: from wip_move_transactions wmt
522: where wmt.wip_entity_id = x_purge_rec.wip_entity_id);
523: x_num_rows := SQL%ROWCOUNT;