[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
| Name |
| ORGANIZATION_ID |
| PRIMARY_ITEM_ID |
| LINE_ID |
| WIP_ENTITY_ID |
| REPETITIVE_SCHEDULE_ID |