View: WIP_BIS_PERF_TO_PLAN_V

Product:	WIP - Work in Process
Description:	Number of items produced/scheduled
Implementation/DBA Data:	APPS.WIP_BIS_PERF_TO_PLAN_V

View Text

SELECT WBPTP.ORGANIZATION_ID
, OOD.ORGANIZATION_NAME
, OOD.LEGAL_ENTITY
, WBPTP.SCHEDULE_DATE
, BOCWV.WEEK_START_DATE
, (BOCWV.NEXT_DATE - 1) WEEK_END_DATE
, BOCWV.SEQ_NUM
, MIF.ITEM_NUMBER
, MIF.DESCRIPTION
, MIF.PRIMARY_UOM_CODE
, MIC.CATEGORY_ID
, MCKFV.CONCATENATED_SEGMENTS
, WBPTP.SCHEDULE_QUANTITY
, WBPTP.ACTUAL_QUANTITY
FROM MTL_ITEM_FLEXFIELDS MIF
, BOM_ORG_CAL_WEEKS_VIEW BOCWV
, ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_CATEGORIES_KFV MCKFV
, MTL_ITEM_CATEGORIES MIC
, MTL_DEFAULT_CATEGORY_SETS MDCS
, WIP_BIS_PERF_TO_PLAN WBPTP
WHERE WBPTP.EXISTING_FLAG = 1
AND OOD.ORGANIZATION_ID = WBPTP.ORGANIZATION_ID
AND MIF.ORGANIZATION_ID = WBPTP.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = WBPTP.INVENTORY_ITEM_ID
AND BOCWV.ORGANIZATION_ID = WBPTP.ORGANIZATION_ID
AND WBPTP.SCHEDULE_DATE BETWEEN BOCWV.WEEK_START_DATE
AND (BOCWV.NEXT_DATE -1)
AND MIC.ORGANIZATION_ID = WBPTP.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = WBPTP.INVENTORY_ITEM_ID
AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID
AND MDCS.FUNCTIONAL_AREA_ID = 1
AND MCKFV.CATEGORY_ID = MIC.CATEGORY_ID

Columns