FND Design Data [Home] [Help]

View: AR_TA_PROF_ASSGNT_V

Product: AR - Receivables
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

Name
ROW_ID
CODE_COMBINATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
STRUCTURE_ID
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
SEGMENT8
SEGMENT9
SEGMENT10
SEGMENT11
SEGMENT12
SEGMENT13
SEGMENT14
SEGMENT15
PROFILE_ID
PROFILE_NAME
PROFILE_DESCRIPTION
PROFILE_START_DATE
PROFILE_END_DATE
START_DATE_ACTIVE
END_DATE_ACTIVE
SUMMARY_FLAG
ENABLED_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ORG_ID