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_TRANSACTIONS

Line 620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');

616: x_purge_rec.line_code := p_purge_request.line_code;
617:
618:
619: -- verify that no other schedules exists
620: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
621: x_purge_rec.info := fnd_message.get;
622: x_purge_rec.table_name := 'WIP_MOVE_TXN_ALLOCATIONS';
623: SELECT COUNT(*) into l_num_rows
624: FROM DUAL WHERE EXISTS (

Line 753: FROM WIP_TRANSACTIONS WT

749: SELECT count(*) into x_num_rows_non_lot
750: FROM WIP_TRANSACTION_ACCOUNTS WTA
751: WHERE WTA.TRANSACTION_ID IN
752: ( SELECT WT.TRANSACTION_ID
753: FROM WIP_TRANSACTIONS WT
754: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
755: AND WT.TRANSACTION_TYPE NOT IN (11,12));
756: SELECT count(*) into x_num_rows_lot
757: FROM WIP_TRANSACTION_ACCOUNTS WTA

Line 760: FROM WIP_TRANSACTIONS WT

756: SELECT count(*) into x_num_rows_lot
757: FROM WIP_TRANSACTION_ACCOUNTS WTA
758: WHERE WTA.TRANSACTION_ID IN
759: ( SELECT WT.TRANSACTION_ID
760: FROM WIP_TRANSACTIONS WT
761: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
762: AND WT.TRANSACTION_TYPE IN (11,12)
763: AND NOT EXISTS (SELECT 1 FROM
764: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

Line 783: FROM WIP_TRANSACTIONS WT

779: else
780: DELETE FROM WIP_TRANSACTION_ACCOUNTS WTA
781: WHERE WTA.TRANSACTION_ID IN
782: ( SELECT WT.TRANSACTION_ID
783: FROM WIP_TRANSACTIONS WT
784: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
785: AND WT.TRANSACTION_TYPE NOT IN (11,12));
786:
787: x_num_rows_non_lot := nvl(SQL%ROWCOUNT,0);

Line 792: FROM WIP_TRANSACTIONS WT

788:
789: DELETE FROM WIP_TRANSACTION_ACCOUNTS WTA
790: WHERE WTA.TRANSACTION_ID IN
791: ( SELECT WT.TRANSACTION_ID
792: FROM WIP_TRANSACTIONS WT
793: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
794: AND WT.TRANSACTION_TYPE IN (11,12)
795: AND NOT EXISTS (SELECT 1 FROM
796: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

Line 822: x_purge_rec.table_name := 'WIP_TRANSACTIONS';

818: p_purge_rec => x_purge_rec,
819: num_rows => x_num_rows_non_lot + x_num_rows_lot);
820: end if;
821:
822: x_purge_rec.table_name := 'WIP_TRANSACTIONS';
823: if (p_option = REPORT_ONLY) then
824: select count(*) into x_num_rows from WIP_TRANSACTIONS
825: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
826: else

Line 824: select count(*) into x_num_rows from WIP_TRANSACTIONS

820: end if;
821:
822: x_purge_rec.table_name := 'WIP_TRANSACTIONS';
823: if (p_option = REPORT_ONLY) then
824: select count(*) into x_num_rows from WIP_TRANSACTIONS
825: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
826: else
827: DELETE FROM WIP_TRANSACTIONS
828: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 827: DELETE FROM WIP_TRANSACTIONS

823: if (p_option = REPORT_ONLY) then
824: select count(*) into x_num_rows from WIP_TRANSACTIONS
825: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
826: else
827: DELETE FROM WIP_TRANSACTIONS
828: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
829: x_num_rows := SQL%ROWCOUNT;
830: end if;
831:

Line 871: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');

867: x_purge_rec.line_code := p_purge_request.line_code;
868:
869:
870: -- verify that no other schedules exists
871: fnd_message.set_name('WIP', 'WIP_TRANSACTIONS_PURGE_ERROR');
872: x_purge_rec.info := fnd_message.get;
873: x_purge_rec.table_name := 'WIP_TXN_ALLOCATIONS';
874:
875: SELECT COUNT(*) into l_num_rows

Line 898: -- in the WIP_TRANSACTIONS table.

894: end if;
895: l_num_rows := 0;
896:
897: -- If records whre found then it means that there records still sitting
898: -- in the WIP_TRANSACTIONS table.
899: if x_records_found then
900: p_sched_txn_flag := TRUE ;
901: x_purge_rec.table_name := 'WIP_TRANSACTIONS';
902: append_report(x_purge_rec, p_option);

Line 901: x_purge_rec.table_name := 'WIP_TRANSACTIONS';

897: -- If records whre found then it means that there records still sitting
898: -- in the WIP_TRANSACTIONS table.
899: if x_records_found then
900: p_sched_txn_flag := TRUE ;
901: x_purge_rec.table_name := 'WIP_TRANSACTIONS';
902: append_report(x_purge_rec, p_option);
903: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';
904: append_report(x_purge_rec, p_option);
905: end if ;

Line 909: x_purge_rec.table_name := 'WIP_TRANSACTIONS';

905: end if ;
906:
907:
908: x_purge_rec.info_type := ROWS_AFFECTED;
909: x_purge_rec.table_name := 'WIP_TRANSACTIONS';
910:
911: savepoint sched_cost01;
912: DELETE FROM WIP_TRANSACTIONS
913: WHERE TRANSACTION_ID IN (

Line 912: DELETE FROM WIP_TRANSACTIONS

908: x_purge_rec.info_type := ROWS_AFFECTED;
909: x_purge_rec.table_name := 'WIP_TRANSACTIONS';
910:
911: savepoint sched_cost01;
912: DELETE FROM WIP_TRANSACTIONS
913: WHERE TRANSACTION_ID IN (
914: SELECT out_wta.transaction_id
915: FROM wip_txn_allocations out_wta
916: WHERE out_wta.organization_id = p_purge_request.organization_id