View: WIP_OSP_REP_ASSY_VAL_V

Product:	WIP - Work in Process
Description:	Repetitive assemblies and production lines with schedules with outside processing resources
Implementation/DBA Data:	APPS.WIP_OSP_REP_ASSY_VAL_V

View Text

SELECT WRI.ORGANIZATION_ID
, WRI.PRIMARY_ITEM_ID
, WRI.LINE_ID
FROM WIP_REPETITIVE_ITEMS WRI
WHERE EXISTS (SELECT 'LOOKING FOR OSP RESOURCES'
FROM WIP_OPERATION_RESOURCES WOR
, WIP_FIRST_ACTIVE_SCHEDULE_V WRS
WHERE WRS.ORGANIZATION_ID = WRI.ORGANIZATION_ID
AND WRS.LINE_ID = WRI.LINE_ID
AND WRS.WIP_ENTITY_ID = WRI.WIP_ENTITY_ID
AND WRS.ORGANIZATION_ID = WOR.ORGANIZATION_ID
AND WRS.REPETITIVE_SCHEDULE_ID = WOR.REPETITIVE_SCHEDULE_ID
AND WOR.AUTOCHARGE_TYPE IN (3
, 4))

Columns