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_MOVE_TRANSACTIONS

Line 516: from wip_move_transactions wmt

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
519: delete from wip_serial_move_transactions
520: where transaction_id in (select wmt.transaction_id

Line 521: 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;
524: end if;
525: if x_num_rows > 0 then

Line 533: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';

529: num_rows => x_num_rows);
530: end if;
531:
532: x_num_rows := 0;
533: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';
534:
535: if (p_option = REPORT_ONLY) then
536: select count(*) into x_num_rows from WIP_MOVE_TRANSACTIONS
537: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 536: select count(*) into x_num_rows from WIP_MOVE_TRANSACTIONS

532: x_num_rows := 0;
533: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';
534:
535: if (p_option = REPORT_ONLY) then
536: select count(*) into x_num_rows from WIP_MOVE_TRANSACTIONS
537: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
538: else
539: DELETE FROM WIP_MOVE_TRANSACTIONS
540: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 539: DELETE FROM WIP_MOVE_TRANSACTIONS

535: if (p_option = REPORT_ONLY) then
536: select count(*) into x_num_rows from WIP_MOVE_TRANSACTIONS
537: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
538: else
539: DELETE FROM WIP_MOVE_TRANSACTIONS
540: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
541: x_num_rows := SQL%ROWCOUNT;
542: end if;
543:

Line 646: -- in the WIP_MOVE_TRANSACTIONS table.

642: end if;
643: l_num_rows := 0;
644:
645: -- If records whre found then it means that there records still sitting
646: -- in the WIP_MOVE_TRANSACTIONS table.
647:
648: if x_records_found then
649: p_sched_move_txn_flag := TRUE ;
650: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';

Line 650: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';

646: -- in the WIP_MOVE_TRANSACTIONS table.
647:
648: if x_records_found then
649: p_sched_move_txn_flag := TRUE ;
650: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';
651: append_report(x_purge_rec,p_option);
652: end if ;
653:
654:

Line 656: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';

652: end if ;
653:
654:
655: x_purge_rec.info_type := ROWS_AFFECTED;
656: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';
657:
658: savepoint wictpg_sp01;
659: DELETE FROM WIP_MOVE_TRANSACTIONS
660: WHERE TRANSACTION_ID IN (

Line 659: DELETE FROM WIP_MOVE_TRANSACTIONS

655: x_purge_rec.info_type := ROWS_AFFECTED;
656: x_purge_rec.table_name := 'WIP_MOVE_TRANSACTIONS';
657:
658: savepoint wictpg_sp01;
659: DELETE FROM WIP_MOVE_TRANSACTIONS
660: WHERE TRANSACTION_ID IN (
661: SELECT out_wmta.transaction_id
662: FROM wip_move_txn_allocations out_wmta
663: WHERE out_wmta.organization_id = p_purge_request.organization_id