VIEW: APPS.XTR_IG_JOURNAL_STRUCTURES_V

Source

View Text - Preformatted

SELECT ig.rowid row_id, ig.xtr_ig_journal_structure_id xtr_ig_journal_structure_id, ig.company_code company_code, ig.cparty_code cparty_code, pty.full_name cparty_name, ig.principal_gl principal_gl, ig.interest_gl interest_gl, nvl(ba.bank_code,ba.bank_short_code) cp_bank_code, ig.cp_currency cp_currency, ig.cp_acct_no cp_acct_no, ig.created_by created_by, ig.creation_date creation_date, ig.last_updated_by last_updated_by, ig.last_update_date last_update_date, ig.last_update_login last_update_login, ba.authorised authorized From xtr_ig_journal_structures ig, xtr_bank_accounts ba, xtr_party_info pty WHERE ig.cparty_code = ba.party_code and ig.cp_currency = ba.currency and ig.cp_acct_no = ba.account_number and ig.cparty_code = pty.party_code

View Text - HTML Formatted

SELECT IG.ROWID ROW_ID
, IG.XTR_IG_JOURNAL_STRUCTURE_ID XTR_IG_JOURNAL_STRUCTURE_ID
, IG.COMPANY_CODE COMPANY_CODE
, IG.CPARTY_CODE CPARTY_CODE
, PTY.FULL_NAME CPARTY_NAME
, IG.PRINCIPAL_GL PRINCIPAL_GL
, IG.INTEREST_GL INTEREST_GL
, NVL(BA.BANK_CODE
, BA.BANK_SHORT_CODE) CP_BANK_CODE
, IG.CP_CURRENCY CP_CURRENCY
, IG.CP_ACCT_NO CP_ACCT_NO
, IG.CREATED_BY CREATED_BY
, IG.CREATION_DATE CREATION_DATE
, IG.LAST_UPDATED_BY LAST_UPDATED_BY
, IG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BA.AUTHORISED AUTHORIZED
FROM XTR_IG_JOURNAL_STRUCTURES IG
, XTR_BANK_ACCOUNTS BA
, XTR_PARTY_INFO PTY
WHERE IG.CPARTY_CODE = BA.PARTY_CODE
AND IG.CP_CURRENCY = BA.CURRENCY
AND IG.CP_ACCT_NO = BA.ACCOUNT_NUMBER
AND IG.CPARTY_CODE = PTY.PARTY_CODE