Product: | XTR - Treasury |
---|---|
Description: | View for XTR_IG_JOURNAL_STRUCTURES table. |
Implementation/DBA Data: | APPS.XTR_IG_JOURNAL_STRUCTURES_V |
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