View: WIP_DISCRETE_JOBS_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_DISCRETE_JOBS
Implementation/DBA Data:	APPS.WIP_DISCRETE_JOBS_V

View Text

SELECT WDJ.ROWID ROW_ID
, WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WE.ROWID WE_ROW_ID
, WDJ.ORGANIZATION_ID
, WDJ.LAST_UPDATE_DATE
, WDJ.LAST_UPDATED_BY
, WDJ.CREATION_DATE
, WDJ.CREATED_BY
, WDJ.LAST_UPDATE_LOGIN
, WDJ.REQUEST_ID
, WDJ.PROGRAM_APPLICATION_ID
, WDJ.PROGRAM_ID
, WDJ.PROGRAM_UPDATE_DATE
, WDJ.DESCRIPTION
, WDJ.STATUS_TYPE
, WDJ.PRIMARY_ITEM_ID
, WDJ.FIRM_PLANNED_FLAG
, WDJ.JOB_TYPE
, LU3.MEANING
, WDJ.WIP_SUPPLY_TYPE
, WDJ.CLASS_CODE
, WDJ.MATERIAL_ACCOUNT
, WDJ.MATERIAL_OVERHEAD_ACCOUNT
, WDJ.RESOURCE_ACCOUNT
, WDJ.OUTSIDE_PROCESSING_ACCOUNT
, WDJ.MATERIAL_VARIANCE_ACCOUNT
, WDJ.RESOURCE_VARIANCE_ACCOUNT
, WDJ.OUTSIDE_PROC_VARIANCE_ACCOUNT
, WDJ.STD_COST_ADJUSTMENT_ACCOUNT
, WDJ.OVERHEAD_ACCOUNT
, WDJ.OVERHEAD_VARIANCE_ACCOUNT
, WDJ.SCHEDULED_START_DATE
, WDJ.DATE_RELEASED
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.DATE_COMPLETED
, WDJ.DATE_CLOSED
, WDJ.START_QUANTITY
, DECODE(WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED
, 0
, NULL
, WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED) "QUANTITY_REMAINING"
, DECODE(WDJ.QUANTITY_COMPLETED
, 0
, NULL
, WDJ.QUANTITY_COMPLETED) "QUANTITY_COMPLETED"
, DECODE(WDJ.QUANTITY_SCRAPPED
, 0
, NULL
, WDJ.QUANTITY_SCRAPPED) "QUANTITY_SCRAPPED"
, WDJ.NET_QUANTITY
, WDJ.BOM_REFERENCE_ID
, WDJ.ROUTING_REFERENCE_ID
, WDJ.COMMON_BOM_SEQUENCE_ID
, WDJ.COMMON_ROUTING_SEQUENCE_ID
, WDJ.BOM_REVISION
, WDJ.ROUTING_REVISION
, WDJ.BOM_REVISION_DATE
, WDJ.ROUTING_REVISION_DATE
, WDJ.LOT_NUMBER
, WDJ.ALTERNATE_BOM_DESIGNATOR
, WDJ.ALTERNATE_ROUTING_DESIGNATOR
, WDJ.COMPLETION_SUBINVENTORY
, WDJ.COMPLETION_LOCATOR_ID
, DECODE(WDJ.COMPLETION_SUBINVENTORY
, NULL
, 1
, MSUB.LOCATOR_TYPE) SUB_LOCATOR_CONTROL
, WDJ.DEMAND_CLASS
, WSG.SCHEDULE_GROUP_NAME
, WDJ.SCHEDULE_GROUP_ID
, WDJ.BUILD_SEQUENCE
, WL.LINE_CODE
, WDJ.LINE_ID
, PJM_PROJECT.ALL_PROJ_IDTONAME(WDJ.PROJECT_ID) PROJECT_NAME
, PJM_PROJECT.ALL_PROJ_IDTONUM(WDJ.PROJECT_ID) PROJECT_NUMBER
, WDJ.PROJECT_ID
, PJM_PROJECT.ALL_TASK_IDTONAME(WDJ.TASK_ID)TASK_NAME
, PJM_PROJECT.ALL_TASK_IDTONUM(WDJ.TASK_ID)TASK_NUMBER
, WDJ.TASK_ID
, WDJ.END_ITEM_UNIT_NUMBER
, WDJ.ATTRIBUTE_CATEGORY
, WDJ.ATTRIBUTE1
, WDJ.ATTRIBUTE2
, WDJ.ATTRIBUTE3
, WDJ.ATTRIBUTE4
, WDJ.ATTRIBUTE5
, WDJ.ATTRIBUTE6
, WDJ.ATTRIBUTE7
, WDJ.ATTRIBUTE8
, WDJ.ATTRIBUTE9
, WDJ.ATTRIBUTE10
, WDJ.ATTRIBUTE11
, WDJ.ATTRIBUTE12
, WDJ.ATTRIBUTE13
, WDJ.ATTRIBUTE14
, WDJ.ATTRIBUTE15
, LU1.MEANING STATUS_TYPE_DISP
, LU2.MEANING WIP_SUPPLY_TYPE_DISP
, WDJ.OVERCOMPLETION_TOLERANCE_TYPE
, WDJ.OVERCOMPLETION_TOLERANCE_VALUE
, WDJ.KANBAN_CARD_ID
, KC.KANBAN_CARD_NUMBER
, WDJ.PO_CREATION_TIME
, WDJ.PRIORITY
, WDJ.DUE_DATE
, WDJ.EST_SCRAP_ACCOUNT
, WDJ.EST_SCRAP_VAR_ACCOUNT
, WE.ENTITY_TYPE
, WDJ.DUE_DATE_PENALTY
, WDJ.DUE_DATE_TOLERANCE
, WDJ.COPRODUCTS_SUPPLY
, WDJ.REQUESTED_START_DATE
, WDJ.SERIALIZATION_START_OP
, WDJ.ACTUAL_START_DATE
, WDJ.EXPECTED_HOLD_RELEASE_DATE
FROM MTL_SECONDARY_INVENTORIES MSUB
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_LINES WL
, WIP_SCHEDULE_GROUPS WSG
, MTL_KANBAN_CARDS KC
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND MSUB.SECONDARY_INVENTORY_NAME (+) = WDJ.COMPLETION_SUBINVENTORY
AND MSUB.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WDJ.SCHEDULE_GROUP_ID
AND WL.LINE_ID (+) = WDJ.LINE_ID
AND WL.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND LU2.LOOKUP_TYPE = 'WIP_SUPPLY'
AND LU1.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LU3.LOOKUP_TYPE = 'WIP_DISCRETE_JOB'
AND LU1.LOOKUP_CODE = WDJ.STATUS_TYPE
AND LU2.LOOKUP_CODE = WDJ.WIP_SUPPLY_TYPE
AND LU3.LOOKUP_CODE = WDJ.JOB_TYPE
AND KC.KANBAN_CARD_ID (+) = WDJ.KANBAN_CARD_ID

Columns