VIEW: APPS.HZ_CREDIT_PROFILES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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