VIEW: APPS.PAY_JP_ITWB_SAL_ACT_PAY_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_number.canonical_to_number(col_mth1), fnd_number.canonical_to_number(col_mth2), fnd_number.canonical_to_number(col_mth3), fnd_number.canonical_to_number(col_mth4), fnd_number.canonical_to_number(col_mth5), fnd_number.canonical_to_number(col_mth6), fnd_number.canonical_to_number(col_mth7), fnd_number.canonical_to_number(col_mth8), fnd_number.canonical_to_number(col_mth9), fnd_number.canonical_to_number(col_mth10), fnd_number.canonical_to_number(col_mth11), fnd_number.canonical_to_number(col_mth12), last_update_login, last_updated_by, last_update_date, created_by, creation_date from pay_jp_itwb_sal_act_v where category = 'PAY'

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_NUMBER.CANONICAL_TO_NUMBER(COL_MTH1)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH2)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH3)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH4)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH5)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH6)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH7)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH8)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH9)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH10)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH11)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_MTH12)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_SAL_ACT_V
WHERE CATEGORY = 'PAY'