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
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
|
|
|