Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_CREDIT_PROFILES_V |
SELECT 'OPERATING_UNIT' PROFILE_TYPE
, CP.CREDIT_PROFILE_ID
, CP.ORGANIZATION_ID
, TO_NUMBER(NULL) ITEM_CATEGORY_ID
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.LAST_UPDATE_LOGIN
, CP.PROGRAM_APPLICATION_ID
, CP.PROGRAM_ID
, CP.PROGRAM_UPDATE_DATE
, CP.REQUEST_ID
, CP.ENABLE_FLAG
, CP.EFFECTIVE_DATE_FROM
, CP.EFFECTIVE_DATE_TO
, CP.CREDIT_CHECKING
, CP.NEXT_CREDIT_REVIEW_DATE
, CP.TOLERANCE
, CP.CREDIT_HOLD
, CP.CREDIT_RATING
, CP.ATTRIBUTE_CATEGORY
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
FROM HZ_CREDIT_PROFILES CP
WHERE ITEM_CATEGORY_ID IS NULL UNION SELECT 'ITEM_CATEGORY' PROFILE_TYPE
, CP.CREDIT_PROFILE_ID
, TO_NUMBER(NULL) ORGANIZATION_ID
, CP.ITEM_CATEGORY_ID
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.LAST_UPDATE_LOGIN
, CP.PROGRAM_APPLICATION_ID
, CP.PROGRAM_ID
, CP.PROGRAM_UPDATE_DATE
, CP.REQUEST_ID
, CP.ENABLE_FLAG
, CP.EFFECTIVE_DATE_FROM
, CP.EFFECTIVE_DATE_TO
, CP.CREDIT_CHECKING
, CP.NEXT_CREDIT_REVIEW_DATE
, CP.TOLERANCE
, CP.CREDIT_HOLD
, CP.CREDIT_RATING
, CP.ATTRIBUTE_CATEGORY
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
FROM HZ_CREDIT_PROFILES CP
WHERE ORGANIZATION_ID IS NULL