VIEW: APPS.PAY_JP_ITWB_BON_ACT_ERD_V

Source

View Text - Preformatted

SELECT row_id, action_information_id, object_version_number, assignment_action_id, action_context_type, assignment_id, effective_date, action_information_category, category, fnd_date.canonical_to_date(col_cnt1), fnd_date.canonical_to_date(col_cnt2), fnd_date.canonical_to_date(col_cnt3), fnd_date.canonical_to_date(col_cnt4), fnd_date.canonical_to_date(col_cnt5), fnd_date.canonical_to_date(col_cnt6), fnd_date.canonical_to_date(col_cnt7), fnd_date.canonical_to_date(col_cnt8), fnd_date.canonical_to_date(col_cnt9), fnd_date.canonical_to_date(col_cnt10), fnd_date.canonical_to_date(col_cnt11), fnd_date.canonical_to_date(col_cnt12), fnd_date.canonical_to_date(col_cnt13), fnd_date.canonical_to_date(col_cnt14), fnd_date.canonical_to_date(col_cnt15), last_update_login, last_updated_by, last_update_date, created_by, creation_date from pay_jp_itwb_bon_act_v where category = 'ERD'

View Text - HTML Formatted

SELECT ROW_ID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_ACTION_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, CATEGORY
, FND_DATE.CANONICAL_TO_DATE(COL_CNT1)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT2)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT3)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT4)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT5)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT6)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT7)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT8)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT9)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT10)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT11)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT12)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT13)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT14)
, FND_DATE.CANONICAL_TO_DATE(COL_CNT15)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_BON_ACT_V
WHERE CATEGORY = 'ERD'