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_TRANSACTION_ACCOUNTS

Line 745: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';

741: x_purge_rec.entity_name := p_purge_request.wip_entity_name;
742: x_purge_rec.line_code := p_purge_request.line_code;
743:
744:
745: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';
746: /* Bug 4082908 -> Changed following deletion statement to consider
747: lot-merge transactions, so that they are purged as a unit */
748: if (p_option = REPORT_ONLY) then
749: SELECT count(*) into x_num_rows_non_lot

Line 750: FROM WIP_TRANSACTION_ACCOUNTS WTA

746: /* Bug 4082908 -> Changed following deletion statement to consider
747: lot-merge transactions, so that they are purged as a unit */
748: if (p_option = REPORT_ONLY) then
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

Line 757: FROM WIP_TRANSACTION_ACCOUNTS WTA

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
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

Line 764: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

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
765: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
766: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
767: AND NVL(WDJ.DATE_CLOSED,SYSDATE) >= p_cut_off_date)
768: UNION

Line 770: FROM WIP_TRANSACTION_ACCOUNTS WT

766: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
767: AND NVL(WDJ.DATE_CLOSED,SYSDATE) >= p_cut_off_date)
768: UNION
769: SELECT WT.TRANSACTION_ID
770: FROM WIP_TRANSACTION_ACCOUNTS WT
771: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
772: AND NOT EXISTS
773: ( SELECT 1 FROM
774: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

Line 774: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

770: FROM WIP_TRANSACTION_ACCOUNTS WT
771: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
772: AND NOT EXISTS
773: ( SELECT 1 FROM
774: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ
775: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
776: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
777: AND NVL(WDJ.DATE_CLOSED,SYSDATE) > p_cut_off_date)
778: );

Line 780: DELETE FROM WIP_TRANSACTION_ACCOUNTS WTA

776: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
777: AND NVL(WDJ.DATE_CLOSED,SYSDATE) > p_cut_off_date)
778: );
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

Line 789: DELETE FROM WIP_TRANSACTION_ACCOUNTS WTA

785: AND WT.TRANSACTION_TYPE NOT IN (11,12));
786:
787: x_num_rows_non_lot := nvl(SQL%ROWCOUNT,0);
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

Line 796: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

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
797: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
798: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
799: AND NVL(WDJ.DATE_CLOSED,SYSDATE) >= p_cut_off_date)
800: UNION

Line 802: FROM WIP_TRANSACTION_ACCOUNTS WT

798: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
799: AND NVL(WDJ.DATE_CLOSED,SYSDATE) >= p_cut_off_date)
800: UNION
801: SELECT WT.TRANSACTION_ID
802: FROM WIP_TRANSACTION_ACCOUNTS WT
803: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
804: AND NOT EXISTS
805: ( SELECT 1 FROM
806: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

Line 806: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

802: FROM WIP_TRANSACTION_ACCOUNTS WT
803: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
804: AND NOT EXISTS
805: ( SELECT 1 FROM
806: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ
807: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
808: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
809: AND NVL(WDJ.DATE_CLOSED,SYSDATE) > p_cut_off_date)
810: );

Line 903: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';

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 ;
906:
907:

Line 939: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';

935: p_purge_rec => x_purge_rec);
936: l_num_rows := 0;
937:
938:
939: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';
940:
941: savepoint sched_cost02;
942: DELETE FROM WIP_TRANSACTION_ACCOUNTS
943: WHERE TRANSACTION_ID IN (

Line 942: DELETE FROM WIP_TRANSACTION_ACCOUNTS

938:
939: x_purge_rec.table_name := 'WIP_TRANSACTION_ACCOUNTS';
940:
941: savepoint sched_cost02;
942: DELETE FROM WIP_TRANSACTION_ACCOUNTS
943: WHERE TRANSACTION_ID IN (
944: SELECT out_wta.transaction_id
945: FROM wip_txn_allocations out_wta
946: WHERE out_wta.organization_id = p_purge_request.organization_id