VIEW: MRP.MRP_MATERIAL_PLANS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, PLAN_ORGANIZATION_ID PLAN_ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_SEGMENTS ITEM_SEGMENTS, HORIZONTAL_PLAN_TYPE HORIZONTAL_PLAN_TYPE, BUCKET_TYPE BUCKET_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, HORIZONTAL_PLAN_TYPE_TEXT HORIZONTAL_PLAN_TYPE_TEXT, QUANTITY1 QUANTITY1, QUANTITY2 QUANTITY2, QUANTITY3 QUANTITY3, QUANTITY4 QUANTITY4, QUANTITY5 QUANTITY5, QUANTITY6 QUANTITY6, QUANTITY7 QUANTITY7, QUANTITY8 QUANTITY8, QUANTITY9 QUANTITY9, QUANTITY10 QUANTITY10, QUANTITY11 QUANTITY11, QUANTITY12 QUANTITY12, QUANTITY13 QUANTITY13, QUANTITY14 QUANTITY14, QUANTITY15 QUANTITY15, QUANTITY16 QUANTITY16, QUANTITY17 QUANTITY17, QUANTITY18 QUANTITY18, QUANTITY19 QUANTITY19, QUANTITY20 QUANTITY20, QUANTITY21 QUANTITY21, QUANTITY22 QUANTITY22, QUANTITY23 QUANTITY23, QUANTITY24 QUANTITY24, QUANTITY25 QUANTITY25, QUANTITY26 QUANTITY26, QUANTITY27 QUANTITY27, QUANTITY28 QUANTITY28, QUANTITY29 QUANTITY29, QUANTITY30 QUANTITY30, QUANTITY31 QUANTITY31, QUANTITY32 QUANTITY32, QUANTITY33 QUANTITY33, QUANTITY34 QUANTITY34, QUANTITY35 QUANTITY35, QUANTITY36 QUANTITY36 from "MRP"."MRP_MATERIAL_PLANS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, PLAN_ORGANIZATION_ID PLAN_ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_SEGMENTS ITEM_SEGMENTS
, HORIZONTAL_PLAN_TYPE HORIZONTAL_PLAN_TYPE
, BUCKET_TYPE BUCKET_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, HORIZONTAL_PLAN_TYPE_TEXT HORIZONTAL_PLAN_TYPE_TEXT
, QUANTITY1 QUANTITY1
, QUANTITY2 QUANTITY2
, QUANTITY3 QUANTITY3
, QUANTITY4 QUANTITY4
, QUANTITY5 QUANTITY5
, QUANTITY6 QUANTITY6
, QUANTITY7 QUANTITY7
, QUANTITY8 QUANTITY8
, QUANTITY9 QUANTITY9
, QUANTITY10 QUANTITY10
, QUANTITY11 QUANTITY11
, QUANTITY12 QUANTITY12
, QUANTITY13 QUANTITY13
, QUANTITY14 QUANTITY14
, QUANTITY15 QUANTITY15
, QUANTITY16 QUANTITY16
, QUANTITY17 QUANTITY17
, QUANTITY18 QUANTITY18
, QUANTITY19 QUANTITY19
, QUANTITY20 QUANTITY20
, QUANTITY21 QUANTITY21
, QUANTITY22 QUANTITY22
, QUANTITY23 QUANTITY23
, QUANTITY24 QUANTITY24
, QUANTITY25 QUANTITY25
, QUANTITY26 QUANTITY26
, QUANTITY27 QUANTITY27
, QUANTITY28 QUANTITY28
, QUANTITY29 QUANTITY29
, QUANTITY30 QUANTITY30
, QUANTITY31 QUANTITY31
, QUANTITY32 QUANTITY32
, QUANTITY33 QUANTITY33
, QUANTITY34 QUANTITY34
, QUANTITY35 QUANTITY35
, QUANTITY36 QUANTITY36
FROM "MRP"."MRP_MATERIAL_PLANS"