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.XTR_EFT_SCRIPT_P dependencies on XTR_SETTLEMENT_SUMMARY

Line 686: from xtr_settlement_summary

682: and s.cparty = nvl(l_cparty,s.cparty);
683:
684: cursor NET_COUNT is
685: select count(*)
686: from xtr_settlement_summary
687: where net_id = v_settlement_summary_id;
688:
689:
690: cursor correct_counterparty is

Line 700: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

696: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));
697:
698: cursor correct_counterparty_net is
699: select count(*)
700: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
701: xtr_settlement_summary s2
702: where s1.settlement_number = v_settlement_number
703: and s1.settlement_summary_id = s2.net_id
704: and s2.settlement_number = x.settlement_number

Line 701: xtr_settlement_summary s2

697:
698: cursor correct_counterparty_net is
699: select count(*)
700: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
701: xtr_settlement_summary s2
702: where s1.settlement_number = v_settlement_number
703: and s1.settlement_summary_id = s2.net_id
704: and s2.settlement_number = x.settlement_number
705: and ((x.beneficiary_account_no is not null and v_cparty = x.beneficiary_party)

Line 717: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

713: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
714:
715: cursor settlement_actioned_net is
716: select count(*)
717: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
718: xtr_settlement_summary s2
719: where s1.settlement_number = v_settlement_number
720: and s1.settlement_summary_id = s2.net_id
721: and s2.settlement_number = x.settlement_number

Line 718: xtr_settlement_summary s2

714:
715: cursor settlement_actioned_net is
716: select count(*)
717: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
718: xtr_settlement_summary s2
719: where s1.settlement_number = v_settlement_number
720: and s1.settlement_summary_id = s2.net_id
721: and s2.settlement_number = x.settlement_number
722: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));

Line 729: from xtr_settlement_summary

725: cursor get_groupid(p_netid VARCHAR2) is
726: SELECT netoff_number
727: FROM xtr_deal_date_amounts
728: where settlement_number = (select settlement_number
729: from xtr_settlement_summary
730: WHERE net_id = p_netid
731: and ROWNUM=1);
732:
733: --bug 3195086

Line 883: (select settlement_number from xtr_settlement_summary x

879: update XTR_DEAL_DATE_AMOUNTS d
880: set d.SETTLEMENT_ACTIONED = 'Y',
881: d.SETTLEMENT_ACTIONED_FILE = l_file_name
882: where SETTLEMENT_NUMBER in
883: (select settlement_number from xtr_settlement_summary x
884: where x.net_id = v_settlement_summary_id);
885: else
886: update XTR_DEAL_DATE_AMOUNTS d
887: set d.SETTLEMENT_ACTIONED = 'Y',

Line 1003: from xtr_settlement_summary x

999: and s.cparty = nvl(l_cparty,s.cparty);
1000:
1001: cursor NET_COUNT is
1002: select count(*)
1003: from xtr_settlement_summary x
1004: where x.net_id = v_settlement_summary_id;
1005:
1006: cursor settlement_actioned is
1007: select count(*)

Line 1014: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

1010: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
1011:
1012: cursor settlement_actioned_net is
1013: select count(*)
1014: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
1015: xtr_settlement_summary s2
1016: where s1.settlement_number = v_settlement_number
1017: and s1.settlement_summary_id = s2.net_id
1018: and s2.settlement_number = x.settlement_number

Line 1015: xtr_settlement_summary s2

1011:
1012: cursor settlement_actioned_net is
1013: select count(*)
1014: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
1015: xtr_settlement_summary s2
1016: where s1.settlement_number = v_settlement_number
1017: and s1.settlement_summary_id = s2.net_id
1018: and s2.settlement_number = x.settlement_number
1019: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));

Line 1031: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

1027: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));
1028:
1029: cursor correct_counterparty_net is
1030: select count(*)
1031: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
1032: xtr_settlement_summary s2
1033: where s1.settlement_number = v_settlement_number
1034: and s1.settlement_summary_id = s2.net_id
1035: and s2.settlement_number = x.settlement_number

Line 1032: xtr_settlement_summary s2

1028:
1029: cursor correct_counterparty_net is
1030: select count(*)
1031: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
1032: xtr_settlement_summary s2
1033: where s1.settlement_number = v_settlement_number
1034: and s1.settlement_summary_id = s2.net_id
1035: and s2.settlement_number = x.settlement_number
1036: and ((x.beneficiary_account_no is not null and v_cparty = x.beneficiary_party)

Line 1209: (select settlement_number from xtr_settlement_summary x

1205: update XTR_DEAL_DATE_AMOUNTS d
1206: set d.SETTLEMENT_ACTIONED = 'Y',
1207: d.SETTLEMENT_ACTIONED_FILE = l_file_name
1208: where SETTLEMENT_NUMBER in
1209: (select settlement_number from xtr_settlement_summary x
1210: where x.net_id = v_settlement_summary_id);
1211: else
1212: update XTR_DEAL_DATE_AMOUNTS d
1213: set d.SETTLEMENT_ACTIONED = 'Y',