FND Design Data [Home] [Help]

View: WIP_OSP_REP_SCHED_VAL_V

Product: WIP - Work in Process
Description: Repetitive schedules with outside processing resources
Implementation/DBA Data: ViewAPPS.WIP_OSP_REP_SCHED_VAL_V
View Text

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

Columns

Name
ORGANIZATION_ID
PRIMARY_ITEM_ID
LINE_ID
WIP_ENTITY_ID
REPETITIVE_SCHEDULE_ID