View: WSM_WIP_GENEALOGY_V

Product:	WSM - Shop Floor Management
Description:
Implementation/DBA Data:	APPS.WSM_WIP_GENEALOGY_V

View Text

SELECT DSJ.WIP_ENTITY_ID
, DSJ.WIP_ENTITY_NAME
, DSJ.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, DSJ.STATUS_TYPE_DISP
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, DSJ.FIRM_PLANNED_FLAG
, DSJ.CLASS_CODE
, DSJ.SCHEDULED_START_DATE
, DSJ.DATE_RELEASED
, DSJ.SCHEDULED_COMPLETION_DATE
, DSJ.DATE_COMPLETED
, DSJ.DATE_CLOSED
, DSJ.START_QUANTITY
, DSJ.QUANTITY_REMAINING
, DSJ.QUANTITY_COMPLETED
, DSJ.QUANTITY_SCRAPPED
, DSJ.NET_QUANTITY
, DSJ.COMPLETION_SUBINVENTORY
, DSJ.JOB_TYPE
FROM MTL_PARAMETERS ORG
, HR_ORGANIZATION_UNITS HOU
, WIP_DISCRETE_JOBS_V DSJ
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE DSJ.PRIMARY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND DSJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND DSJ.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = HOU.ORGANIZATION_ID

Columns