DBA Data[Home] [Help]

VIEW: APPS.WIP_OSP_REP_SCHED_VAL_V

Source

View Text - Preformatted

SELECT WRI.ORGANIZATION_ID , WRI.PRIMARY_ITEM_ID , WRI.LINE_ID , WRI.WIP_ENTITY_ID , WRS.REPETITIVE_SCHEDULE_ID FROM WIP_FIRST_ACTIVE_SCHEDULE_V WRS , WIP_REPETITIVE_ITEMS WRI WHERE WRS.ORGANIZATION_ID = WRI.ORGANIZATION_ID AND WRS.LINE_ID = WRI.LINE_ID AND WRS.WIP_ENTITY_ID = WRI.WIP_ENTITY_ID
View Text - HTML Formatted

SELECT WRI.ORGANIZATION_ID
, WRI.PRIMARY_ITEM_ID
, WRI.LINE_ID
, WRI.WIP_ENTITY_ID
, WRS.REPETITIVE_SCHEDULE_ID
FROM WIP_FIRST_ACTIVE_SCHEDULE_V WRS
, WIP_REPETITIVE_ITEMS WRI
WHERE WRS.ORGANIZATION_ID = WRI.ORGANIZATION_ID
AND WRS.LINE_ID = WRI.LINE_ID
AND WRS.WIP_ENTITY_ID = WRI.WIP_ENTITY_ID