eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIP_BIS_PERF_TO_PLAN_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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