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_STOCK_PKG dependencies on XTR_BANK_ACCOUNTS

Line 28: from XTR_BANK_ACCOUNTS_V

24: /* Bug 3737048 Added the new status in the cursor. */
25:
26: Cursor cur_cparty_acct is
27: select ACCOUNT_NUMBER
28: from XTR_BANK_ACCOUNTS_V
29: where PARTY_CODE = D.CPARTY_CODE
30: and CURRENCY = D.CURRENCY
31: and ((PARTY_TYPE = 'CP' and BANK_SHORT_CODE = D.CPARTY_REF)
32: or(PARTY_TYPE = 'C' and substr(BANK_SHORT_CODE, 1, 7) = D.CPARTY_REF));

Line 702: from XTR_BANK_ACCOUNTS_V

698: BUY DEAL_DETAIL%ROWTYPE;
699:
700: Cursor cur_cparty_acct is
701: select ACCOUNT_NUMBER
702: from XTR_BANK_ACCOUNTS_V
703: where PARTY_CODE = BUY.CPARTY_CODE
704: and CURRENCY = BUY.CURRENCY
705: and ((PARTY_TYPE = 'CP' and BANK_SHORT_CODE = BUY.CPARTY_REF)
706: or(PARTY_TYPE = 'C' and substr(BANK_SHORT_CODE, 1, 7) = BUY.CPARTY_REF));

Line 765: l_cparty_ref XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;

761:
762: /* for bug 5917859 starts */
763:
764: L_STOCK_ISSUER XTR_STOCK_ISSUES.STOCK_ISSUER%TYPE;
765: l_cparty_ref XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;
766:
767:
768: CURSOR C_STOCK_ISSUER IS
769: SELECT STOCK_ISSUER