View: AR_TA_REMIT_PROF

View Text

SELECT PROFILE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, NAME
, DESCRIPTION
, START_DATE
, END_DATE
, DISCOUNT
, ALLOW_RECEIPTS_ONLY_FLAG
, FINANCE_CHARGES_FLAG
, ITEMS_ON_DISPUTE_FLAG
, RULE_SET_ID
, DEFAULT_TRX_SET_ID
, APPLY_PARTIAL_RECEIPT_FLAG
, MATCHED_UNDR_PAY_RULE
, MATCHED_OVER_PAY_RULE
, UNMATCHED_POS_PAY_RULE
, UNMATCHED_NEG_PAY_RULE
, WRITE_OFF_OVER_PAY_FLAG
, WRITE_OFF_OVER_PAY_THRESHOLD
, WRITE_OFF_UNDR_PAY_FLAG
, WRITE_OFF_UNDR_PAY_THRESHOLD
, RECEIVABLES_TRX_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, APPLY_DATE_FLAG
, DEPOSIT_DATE_FLAG
, POSTMARK_DATE_FLAG
, APPLY_GRACE_DAYS
, DEPOSIT_GRACE_DAYS
, POSTMARK_GRACE_DAYS
, FULL_DISCOUNT_FLAG
, DISCOUNT_BASIS
FROM AR_TA_REMIT_PROF_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns