[Home] [Help]
View: WIP_OSP_REP_SCHED_VAL_V
Product: | WIP - Work in Process |
Description: | Repetitive schedules with outside processing resources |
Implementation/DBA Data: |
APPS.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
ORGANIZATION_ID |
PRIMARY_ITEM_ID |
LINE_ID |
WIP_ENTITY_ID |
REPETITIVE_SCHEDULE_ID |
Name |