DBA Data[Home] [Help]

VIEW: APPS.IGS_PR_MILESTONE_V

Source

View Text - Preformatted

SELECT PERSON_ID, CA_SEQUENCE_NUMBER, SEQUENCE_NUMBER, MILESTONE_TYPE, MILESTONE_STATUS, DUE_DT, DESCRIPTION, ACTUAL_REACHED_DT, 'N' INCLUDE_REACHED_MILESTONES, NVL(PERSON_ID,NULL) PRECED_PERSON_ID, NVL(CA_SEQUENCE_NUMBER,NULL) PRECED_CA_SEQUENCE_NUMBER, PRECED_SEQUENCE_NUMBER, OVRD_NTFCTN_IMMINENT_DAYS, OVRD_NTFCTN_REMINDER_DAYS, OVRD_NTFCTN_RE_REMINDER_DAYS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, COMMENTS FROM IGS_PR_MILESTONE mil
View Text - HTML Formatted

SELECT PERSON_ID
, CA_SEQUENCE_NUMBER
, SEQUENCE_NUMBER
, MILESTONE_TYPE
, MILESTONE_STATUS
, DUE_DT
, DESCRIPTION
, ACTUAL_REACHED_DT
, 'N' INCLUDE_REACHED_MILESTONES
, NVL(PERSON_ID
, NULL) PRECED_PERSON_ID
, NVL(CA_SEQUENCE_NUMBER
, NULL) PRECED_CA_SEQUENCE_NUMBER
, PRECED_SEQUENCE_NUMBER
, OVRD_NTFCTN_IMMINENT_DAYS
, OVRD_NTFCTN_REMINDER_DAYS
, OVRD_NTFCTN_RE_REMINDER_DAYS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, COMMENTS
FROM IGS_PR_MILESTONE MIL