View: WIPBV_WIP_INTRAOPERATION_STEPS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_WIP_INTRAOPERATION_STEPS

View Text

SELECT /* REGULAR ATTRIBUTES */ LO.MEANING
, VA.ORGANIZATION_ID
, VA.RECORD_CREATOR
, VA.STEP_MEANING
, /* RESOLVED FOREIGN KEYS */ PA.ORGANIZATION_CODE
, AL.NAME
, /* WHO */ VA.CREATION_DATE
, VA.CREATED_BY
, VA.LAST_UPDATE_DATE
, VA.LAST_UPDATED_BY
FROM MFG_LOOKUPS LO
, WIP_PARAMETERS WPA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_VALID_INTRAOPERATION_STEPS VA
WHERE VA.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND VA.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND VA.ORGANIZATION_ID = WPA.ORGANIZATION_ID
AND LO.LOOKUP_CODE = VA.STEP_LOOKUP_TYPE
AND LO.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND '_SEC:VA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns