VIEW: APPS.WSM_WIP_GENEALOGY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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