Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CRP.ROWID
, CRP.LAST_UPDATE_DATE
, CRP.LAST_UPDATED_BY
, CRP.LAST_UPDATE_LOGIN
, CRP.CREATION_DATE
, CRP.CREATED_BY
, CRP.PROFILE_ID
, CRP.NAME
, CRP.DESCRIPTION
, CRP.START_DATE
, CRP.END_DATE
, CRP.DISCOUNT
, CRP.FINANCE_CHARGES_FLAG
, CRP.ITEMS_ON_DISPUTE_FLAG
, CRP.RULE_SET_ID
, CRS.NAME
, CRS.START_DATE
, CRS.END_DATE
, CRP.ALLOW_RECEIPTS_ONLY_FLAG
, CRP.DEFAULT_TRX_SET_ID
, TRS.NAME
, TRS.START_DATE
, TRS.END_DATE
, CRP.APPLY_PARTIAL_RECEIPT_FLAG
, CRP.MATCHED_UNDR_PAY_RULE
, CRP.MATCHED_OVER_PAY_RULE
, CRP.UNMATCHED_POS_PAY_RULE
, CRP.UNMATCHED_NEG_PAY_RULE
, CRP.WRITE_OFF_OVER_PAY_FLAG
, CRP.WRITE_OFF_OVER_PAY_THRESHOLD
, CRP.WRITE_OFF_UNDR_PAY_FLAG
, CRP.WRITE_OFF_UNDR_PAY_THRESHOLD
, CRP.RECEIVABLES_TRX_ID
, ART.NAME
, CRP.ATTRIBUTE_CATEGORY
, CRP.ATTRIBUTE1
, CRP.ATTRIBUTE2
, CRP.ATTRIBUTE3
, CRP.ATTRIBUTE4
, CRP.ATTRIBUTE5
, CRP.ATTRIBUTE6
, CRP.ATTRIBUTE7
, CRP.ATTRIBUTE8
, CRP.ATTRIBUTE9
, CRP.ATTRIBUTE10
, CRP.ATTRIBUTE11
, CRP.ATTRIBUTE12
, CRP.ATTRIBUTE13
, CRP.ATTRIBUTE14
, CRP.ATTRIBUTE15
, CRP.ORG_ID
, CRP.APPLY_DATE_FLAG
, CRP.DEPOSIT_DATE_FLAG
, CRP.POSTMARK_DATE_FLAG
, CRP.APPLY_GRACE_DAYS
, CRP.DEPOSIT_GRACE_DAYS
, CRP.POSTMARK_GRACE_DAYS
, CRP.FULL_DISCOUNT_FLAG
, CRP.DISCOUNT_BASIS
FROM AR_TA_REMIT_PROF CRP
, AR_TA_RULE_SETS CRS
, AR_TA_TRX_SETS TRS
, AR_RECEIVABLES_TRX ART
WHERE CRP.RULE_SET_ID = CRS.RULE_SET_ID
AND CRP.DEFAULT_TRX_SET_ID = TRS.TRX_SET_ID
AND CRP.RECEIVABLES_TRX_ID = ART.RECEIVABLES_TRX_ID (+)