View: WIPFV_FLOW_SCHEDULES

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

View Text

SELECT EN.WIP_ENTITY_NAME
, '_LA:FL.STATUS:MFG_LOOKUPS:WIP_FLOW_SCHEDULE_STATUS:MEANING'
, FL.SCHEDULED_FLAG
, FL.PLANNED_QUANTITY
, FL.BUILD_SEQUENCE
, FL.SCHEDULE_NUMBER
, FL.MPS_NET_QUANTITY
, FL.SCHEDULED_START_DATE
, FL.MPS_SCHEDULED_COMPLETION_DATE
, FL.DATE_CLOSED
, FL.QUANTITY_COMPLETED
, FL.BOM_REVISION_DATE
, FL.ROUTING_REVISION_DATE
, FL.ALTERNATE_BOM_DESIGNATOR
, FL.ALTERNATE_ROUTING_DESIGNATOR
, FL.DEMAND_CLASS
, FL.QUANTITY_SCRAPPED
, FL.END_ITEM_UNIT_NUMBER
, FL.DEMAND_SOURCE_HEADER_ID
, FL.DEMAND_SOURCE_LINE
, FL.DEMAND_SOURCE_DELIVERY
, FL.DEMAND_SOURCE_TYPE
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY'
, ITLO.DESCRIPTION
, SC.SCHEDULE_GROUP_NAME
, LI.LINE_CODE
, PR.PROJECT_NUMBER
, PR.PROJECT_NAME
, TA.TASK_NUMBER
, TA.TASK_NAME
, KA.KANBAN_CARD_NUMBER
, '_KF:SQLGL:GL#:CO1'
, '_KF:SQLGL:GL#:CO2'
, '_KF:SQLGL:GL#:CO3'
, '_KF:SQLGL:GL#:CO4'
, '_KF:SQLGL:GL#:CO5'
, '_KF:SQLGL:GL#:CO6'
, '_KF:SQLGL:GL#:CO7'
, '_KF:SQLGL:GL#:CO8'
, '_KF:SQLGL:GL#:CO9'
, '_KF:SQLGL:GL#:CO10'
, '_DF:WIP:WIP_FLOW_SCHEDULES:FL'
, FL.WIP_ENTITY_ID
, FL.ORGANIZATION_ID
, FL.PRIMARY_ITEM_ID
, FL.CLASS_CODE
, FL.BOM_REVISION
, FL.ROUTING_REVISION
, FL.COMPLETION_SUBINVENTORY
, FL.COMPLETION_LOCATOR_ID
, FL.SCHEDULE_GROUP_ID
, FL.LINE_ID
, FL.PROJECT_ID
, FL.TASK_ID
, FL.KANBAN_CARD_ID
, FL.MATERIAL_ACCOUNT
, FL.MATERIAL_OVERHEAD_ACCOUNT
, FL.RESOURCE_ACCOUNT
, FL.OUTSIDE_PROCESSING_ACCOUNT
, FL.MATERIAL_VARIANCE_ACCOUNT
, FL.RESOURCE_VARIANCE_ACCOUNT
, FL.OUTSIDE_PROC_VARIANCE_ACCOUNT
, FL.STD_COST_ADJUSTMENT_ACCOUNT
, FL.OVERHEAD_ACCOUNT
, FL.OVERHEAD_VARIANCE_ACCOUNT
, FL.CREATION_DATE
, FL.CREATED_BY
, FL.LAST_UPDATE_DATE
, FL.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, MTL_ITEM_LOCATIONS ITLO
, MTL_ITEM_REVISIONS ITRE
, MTL_RTG_ITEM_REVISIONS RT
, MTL_ITEM_SUB_INVENTORIES ITSU
, WIP_SCHEDULE_GROUPS SC
, WIP_LINES LI
, PJMFV_PROJECT_MFG_PROJECTS PR
, PJM_UNIT_NUMBERS UN
, PA_TASKS TA
, MTL_KANBAN_CARDS KA
, GL_CODE_COMBINATIONS CO1
, GL_CODE_COMBINATIONS CO2
, GL_CODE_COMBINATIONS CO3
, GL_CODE_COMBINATIONS CO4
, GL_CODE_COMBINATIONS CO5
, GL_CODE_COMBINATIONS CO6
, GL_CODE_COMBINATIONS CO7
, GL_CODE_COMBINATIONS CO8
, GL_CODE_COMBINATIONS CO9
, GL_CODE_COMBINATIONS CO10
, WIP_ENTITIES EN
, WIP_ACCOUNTING_CLASSES AC
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_FLOW_SCHEDULES FL
WHERE FL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND FL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND FL.CLASS_CODE = AC.CLASS_CODE
AND FL.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND FL.MATERIAL_ACCOUNT = CO1.CODE_COMBINATION_ID(+)
AND FL.MATERIAL_OVERHEAD_ACCOUNT = CO2.CODE_COMBINATION_ID(+)
AND FL.RESOURCE_ACCOUNT = CO3.CODE_COMBINATION_ID(+)
AND FL.OUTSIDE_PROCESSING_ACCOUNT = CO4.CODE_COMBINATION_ID(+)
AND FL.MATERIAL_VARIANCE_ACCOUNT = CO5.CODE_COMBINATION_ID(+)
AND FL.RESOURCE_VARIANCE_ACCOUNT = CO6.CODE_COMBINATION_ID(+)
AND FL.OUTSIDE_PROC_VARIANCE_ACCOUNT = CO7.CODE_COMBINATION_ID(+)
AND FL.STD_COST_ADJUSTMENT_ACCOUNT = CO8.CODE_COMBINATION_ID(+)
AND FL.OVERHEAD_ACCOUNT = CO9.CODE_COMBINATION_ID(+)
AND FL.OVERHEAD_VARIANCE_ACCOUNT = CO10.CODE_COMBINATION_ID(+)
AND FL.PROJECT_ID = PR.PROJECT_ID(+)
AND FL.END_ITEM_UNIT_NUMBER = UN.UNIT_NUMBER(+)
AND FL.TASK_ID = TA.TASK_ID(+)
AND FL.KANBAN_CARD_ID = KA.KANBAN_CARD_ID(+)
AND FL.LINE_ID = LI.LINE_ID(+)
AND FL.ORGANIZATION_ID = LI.ORGANIZATION_ID(+)
AND FL.SCHEDULE_GROUP_ID = SC.SCHEDULE_GROUP_ID(+)
AND FL.COMPLETION_LOCATOR_ID= ITLO.INVENTORY_LOCATION_ID(+)
AND FL.ORGANIZATION_ID = ITLO.ORGANIZATION_ID(+)
AND FL.PRIMARY_ITEM_ID = ITRE.INVENTORY_ITEM_ID(+)
AND FL.ORGANIZATION_ID = ITRE.ORGANIZATION_ID(+)
AND FL.BOM_REVISION = ITRE.REVISION(+)
AND FL.ROUTING_REVISION = RT.PROCESS_REVISION(+)
AND FL.PRIMARY_ITEM_ID = RT.INVENTORY_ITEM_ID(+)
AND FL.ORGANIZATION_ID = RT.ORGANIZATION_ID(+)
AND FL.PRIMARY_ITEM_ID = ITSU.INVENTORY_ITEM_ID(+)
AND FL.ORGANIZATION_ID = ITSU.ORGANIZATION_ID(+)
AND FL.COMPLETION_SUBINVENTORY=ITSU.SECONDARY_INVENTORY(+)
AND FL.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID(+)
AND FL.ORGANIZATION_ID = SY.ORGANIZATION_ID(+)
AND '_SEC:FL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns