VIEW: APPS.WIPBV_WIP_JOBS

Source

View Text - Preformatted

SELECT EN.WIP_ENTITY_NAME , '_LA:en.entity_type:MFG_LOOKUPS:WIP_ENTITY:MEANING' , '_LA:di.job_type:MFG_LOOKUPS:WIP_DISCRETE_JOB:MEANING' , '_LA:di.status_type:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING' , '_LA:di.firm_planned_flag:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:di.wip_supply_type:MFG_LOOKUPS:WIP_SUPPLY:MEANING' , DI.START_QUANTITY , DI.QUANTITY_COMPLETED , DI.QUANTITY_SCRAPPED , DI.NET_QUANTITY , DI.DATE_RELEASED , DI.DATE_COMPLETED , DI.SCHEDULED_START_DATE , DI.SCHEDULED_COMPLETION_DATE , DI.DATE_CLOSED , DI.BOM_REVISION_DATE , DI.ROUTING_REVISION_DATE , DI.LOT_NUMBER , DI.ALTERNATE_BOM_DESIGNATOR , DI.ALTERNATE_ROUTING_DESIGNATOR , DI.BUILD_SEQUENCE , DI.DEMAND_CLASS , '_LA:DI.po_creation_time:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING' , DI.END_ITEM_UNIT_NUMBER , '_LA:DI.OVERCOMPLETION_TOLERANCE_TYPE:MFG_LOOKUPS:WIP_TOLERANCE_TYPE:MEANING' , DI.OVERCOMPLETION_TOLERANCE_VALUE , DI.DESCRIPTION , DI.WIP_ENTITY_ID , DI.ORGANIZATION_ID , DI.PRIMARY_ITEM_ID , DI.CLASS_CODE , DI.BOM_REFERENCE_ID , DI.COMMON_BOM_SEQUENCE_ID , DI.BOM_REVISION , DI.ROUTING_REFERENCE_ID , DI.COMMON_ROUTING_SEQUENCE_ID , DI.ROUTING_REVISION , DI.COMPLETION_SUBINVENTORY , DI.COMPLETION_LOCATOR_ID , DI.SCHEDULE_GROUP_ID , DI.LINE_ID , DI.PROJECT_ID , DI.TASK_ID , DI.KANBAN_CARD_ID , DI.MATERIAL_ACCOUNT , DI.MATERIAL_OVERHEAD_ACCOUNT , DI.RESOURCE_ACCOUNT , DI.OUTSIDE_PROCESSING_ACCOUNT , DI.MATERIAL_VARIANCE_ACCOUNT , DI.RESOURCE_VARIANCE_ACCOUNT , DI.OUTSIDE_PROC_VARIANCE_ACCOUNT , DI.STD_COST_ADJUSTMENT_ACCOUNT , DI.OVERHEAD_ACCOUNT , DI.OVERHEAD_VARIANCE_ACCOUNT , DI.CREATION_DATE , DI.CREATED_BY , DI.LAST_UPDATE_DATE , DI.LAST_UPDATED_BY FROM WIP_ENTITIES EN , WIP_DISCRETE_JOBS DI WHERE DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND '_SEC:di.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT EN.WIP_ENTITY_NAME
, '_LA:EN.ENTITY_TYPE:MFG_LOOKUPS:WIP_ENTITY:MEANING'
, '_LA:DI.JOB_TYPE:MFG_LOOKUPS:WIP_DISCRETE_JOB:MEANING'
, '_LA:DI.STATUS_TYPE:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING'
, '_LA:DI.FIRM_PLANNED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:DI.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, DI.START_QUANTITY
, DI.QUANTITY_COMPLETED
, DI.QUANTITY_SCRAPPED
, DI.NET_QUANTITY
, DI.DATE_RELEASED
, DI.DATE_COMPLETED
, DI.SCHEDULED_START_DATE
, DI.SCHEDULED_COMPLETION_DATE
, DI.DATE_CLOSED
, DI.BOM_REVISION_DATE
, DI.ROUTING_REVISION_DATE
, DI.LOT_NUMBER
, DI.ALTERNATE_BOM_DESIGNATOR
, DI.ALTERNATE_ROUTING_DESIGNATOR
, DI.BUILD_SEQUENCE
, DI.DEMAND_CLASS
, '_LA:DI.PO_CREATION_TIME:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING'
, DI.END_ITEM_UNIT_NUMBER
, '_LA:DI.OVERCOMPLETION_TOLERANCE_TYPE:MFG_LOOKUPS:WIP_TOLERANCE_TYPE:MEANING'
, DI.OVERCOMPLETION_TOLERANCE_VALUE
, DI.DESCRIPTION
, DI.WIP_ENTITY_ID
, DI.ORGANIZATION_ID
, DI.PRIMARY_ITEM_ID
, DI.CLASS_CODE
, DI.BOM_REFERENCE_ID
, DI.COMMON_BOM_SEQUENCE_ID
, DI.BOM_REVISION
, DI.ROUTING_REFERENCE_ID
, DI.COMMON_ROUTING_SEQUENCE_ID
, DI.ROUTING_REVISION
, DI.COMPLETION_SUBINVENTORY
, DI.COMPLETION_LOCATOR_ID
, DI.SCHEDULE_GROUP_ID
, DI.LINE_ID
, DI.PROJECT_ID
, DI.TASK_ID
, DI.KANBAN_CARD_ID
, DI.MATERIAL_ACCOUNT
, DI.MATERIAL_OVERHEAD_ACCOUNT
, DI.RESOURCE_ACCOUNT
, DI.OUTSIDE_PROCESSING_ACCOUNT
, DI.MATERIAL_VARIANCE_ACCOUNT
, DI.RESOURCE_VARIANCE_ACCOUNT
, DI.OUTSIDE_PROC_VARIANCE_ACCOUNT
, DI.STD_COST_ADJUSTMENT_ACCOUNT
, DI.OVERHEAD_ACCOUNT
, DI.OVERHEAD_VARIANCE_ACCOUNT
, DI.CREATION_DATE
, DI.CREATED_BY
, DI.LAST_UPDATE_DATE
, DI.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
WHERE DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND '_SEC:DI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY