VIEW: FUN.FUN_NET_AGREEMENTS_ALL#

Source

View Text - Preformatted

select AGREEMENT_ID AGREEMENT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AGREEMENT_NAME AGREEMENT_NAME, PARTNER_REFERENCE PARTNER_REFERENCE, AGREEMENT_START_DATE AGREEMENT_START_DATE, AGREEMENT_END_DATE AGREEMENT_END_DATE, IN_PROCESS_FLAG IN_PROCESS_FLAG, SEL_REC_PAST_DUE_TXNS_FLAG SEL_REC_PAST_DUE_TXNS_FLAG, DAYS_PAST_DUE DAYS_PAST_DUE, NET_CURRENCY_RULE_CODE NET_CURRENCY_RULE_CODE, NET_ORDER_RULE_CODE NET_ORDER_RULE_CODE, NET_BALANCE_RULE_CODE NET_BALANCE_RULE_CODE, SHIKYU_RULE_CODE SHIKYU_RULE_CODE, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, NET_CURRENCY_CODE NET_CURRENCY_CODE, APPROVER_NAME APPROVER_NAME, NON_RESPONSE_ACTION_CODE NON_RESPONSE_ACTION_CODE, ORG_ID ORG_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ALLOW_DISC_FLAG ALLOW_DISC_FLAG from "FUN"."FUN_NET_AGREEMENTS_ALL"

View Text - HTML Formatted

SELECT AGREEMENT_ID AGREEMENT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AGREEMENT_NAME AGREEMENT_NAME
, PARTNER_REFERENCE PARTNER_REFERENCE
, AGREEMENT_START_DATE AGREEMENT_START_DATE
, AGREEMENT_END_DATE AGREEMENT_END_DATE
, IN_PROCESS_FLAG IN_PROCESS_FLAG
, SEL_REC_PAST_DUE_TXNS_FLAG SEL_REC_PAST_DUE_TXNS_FLAG
, DAYS_PAST_DUE DAYS_PAST_DUE
, NET_CURRENCY_RULE_CODE NET_CURRENCY_RULE_CODE
, NET_ORDER_RULE_CODE NET_ORDER_RULE_CODE
, NET_BALANCE_RULE_CODE NET_BALANCE_RULE_CODE
, SHIKYU_RULE_CODE SHIKYU_RULE_CODE
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, NET_CURRENCY_CODE NET_CURRENCY_CODE
, APPROVER_NAME APPROVER_NAME
, NON_RESPONSE_ACTION_CODE NON_RESPONSE_ACTION_CODE
, ORG_ID ORG_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ALLOW_DISC_FLAG ALLOW_DISC_FLAG
FROM "FUN"."FUN_NET_AGREEMENTS_ALL"