Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CARA.ROWID
, CARA.CODE_COMBINATION_ID
, CARA.LAST_UPDATE_DATE
, CARA.LAST_UPDATED_BY
, CARA.LAST_UPDATE_LOGIN
, CARA.CREATION_DATE
, CARA.CREATED_BY
, CARA.STRUCTURE_ID
, CARA.SEGMENT1
, CARA.SEGMENT2
, CARA.SEGMENT3
, CARA.SEGMENT4
, CARA.SEGMENT5
, CARA.SEGMENT6
, CARA.SEGMENT7
, CARA.SEGMENT8
, CARA.SEGMENT9
, CARA.SEGMENT10
, CARA.SEGMENT11
, CARA.SEGMENT12
, CARA.SEGMENT13
, CARA.SEGMENT14
, CARA.SEGMENT15
, CARA.PROFILE_ID
, CARP.NAME
, CARP.DESCRIPTION
, CARP.START_DATE
, CARP.END_DATE
, CARA.START_DATE_ACTIVE
, CARA.END_DATE_ACTIVE
, CARA.SUMMARY_FLAG
, CARA.ENABLED_FLAG
, CARA.ATTRIBUTE_CATEGORY
, CARA.ATTRIBUTE1
, CARA.ATTRIBUTE2
, CARA.ATTRIBUTE3
, CARA.ATTRIBUTE4
, CARA.ATTRIBUTE5
, CARA.ATTRIBUTE6
, CARA.ATTRIBUTE7
, CARA.ATTRIBUTE8
, CARA.ATTRIBUTE9
, CARA.ATTRIBUTE10
, CARA.ATTRIBUTE11
, CARA.ATTRIBUTE12
, CARA.ATTRIBUTE13
, CARA.ATTRIBUTE14
, CARA.ATTRIBUTE15
, CARA.ORG_ID
FROM AR_TA_REMIT_PROF CARP
, AR_TA_PROF_ASSGNT CARA
WHERE CARA.PROFILE_ID = CARP.PROFILE_ID