VIEW: APPS.WIPFV_WIP_SCHEDULE_GROUPS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTES */ SC.SCHEDULE_GROUP_NAME , SC.SCHEDULE_GROUP_ID , SC.DESCRIPTION , SC.INACTIVE_ON /* RESOLVED FOREIGN KEYS */ , PA.ORGANIZATION_CODE , AL.NAME , '_DF:WIP:WIP_SCHEDULE_GROUPS:sc' /* IDS */ , SC.ORGANIZATION_ID /* WHO */ , SC.CREATION_DATE , SC.CREATED_BY , SC.LAST_UPDATE_DATE , SC.LAST_UPDATED_BY FROM WIP_SCHEDULE_GROUPS SC, HR_ALL_ORGANIZATION_UNITS AL, MTL_PARAMETERS PA WHERE SC.ORGANIZATION_ID = PA.ORGANIZATION_ID AND SC.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:sc.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTES */ SC.SCHEDULE_GROUP_NAME
, SC.SCHEDULE_GROUP_ID
, SC.DESCRIPTION
, SC.INACTIVE_ON /* RESOLVED FOREIGN KEYS */
, PA.ORGANIZATION_CODE
, AL.NAME
, '_DF:WIP:WIP_SCHEDULE_GROUPS:SC' /* IDS */
, SC.ORGANIZATION_ID /* WHO */
, SC.CREATION_DATE
, SC.CREATED_BY
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
FROM WIP_SCHEDULE_GROUPS SC
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
WHERE SC.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SC.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:SC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY