VIEW: INV.MTL_DEMAND#

Source

View Text - Preformatted

select DEMAND_ID DEMAND_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME, UOM_CODE UOM_CODE, LINE_ITEM_QUANTITY LINE_ITEM_QUANTITY, PRIMARY_UOM_QUANTITY PRIMARY_UOM_QUANTITY, LINE_ITEM_RESERVATION_QTY LINE_ITEM_RESERVATION_QTY, RESERVATION_QUANTITY RESERVATION_QUANTITY, COMPLETED_QUANTITY COMPLETED_QUANTITY, REQUIREMENT_DATE REQUIREMENT_DATE, RESERVATION_TYPE RESERVATION_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PARENT_DEMAND_ID PARENT_DEMAND_ID, EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE, EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID, USER_LINE_NUM USER_LINE_NUM, USER_DELIVERY USER_DELIVERY, SCHEDULE_ID SCHEDULE_ID, AUTODETAIL_GROUP_ID AUTODETAIL_GROUP_ID, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID, SUPPLY_GROUP_ID SUPPLY_GROUP_ID, UPDATED_FLAG UPDATED_FLAG, REVISION REVISION, LOT_NUMBER LOT_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, SUBINVENTORY SUBINVENTORY, LOCATOR_ID LOCATOR_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, PARENT_COMPONENT_SEQ_ID PARENT_COMPONENT_SEQ_ID, RTO_MODEL_SOURCE_LINE RTO_MODEL_SOURCE_LINE, RTO_PREVIOUS_QTY RTO_PREVIOUS_QTY, CONFIG_STATUS CONFIG_STATUS, AVAILABLE_TO_MRP AVAILABLE_TO_MRP, AVAILABLE_TO_ATP AVAILABLE_TO_ATP, ESTIMATED_RELEASE_DATE ESTIMATED_RELEASE_DATE, DEMAND_CLASS DEMAND_CLASS, ROW_STATUS_FLAG ROW_STATUS_FLAG, ORDER_CHANGE_REPORT_FLAG ORDER_CHANGE_REPORT_FLAG, ATP_LEAD_TIME ATP_LEAD_TIME, EXPLOSION_EFFECTIVITY_DATE EXPLOSION_EFFECTIVITY_DATE, BOM_LEVEL BOM_LEVEL, MRP_DATE MRP_DATE, MRP_QUANTITY MRP_QUANTITY, CUSTOMER_ID CUSTOMER_ID, TERRITORY_ID TERRITORY_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, MASTER_RESERVATION_QTY MASTER_RESERVATION_QTY, DESCRIPTION DESCRIPTION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, DEMAND_TYPE DEMAND_TYPE, DUPLICATED_CONFIG_ITEM_ID DUPLICATED_CONFIG_ITEM_ID, DUPLICATED_CONFIG_DEMAND_ID DUPLICATED_CONFIG_DEMAND_ID, EXPLOSION_GROUP_ID EXPLOSION_GROUP_ID, ORDERED_ITEM_ID ORDERED_ITEM_ID, CONFIG_GROUP_ID CONFIG_GROUP_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, N_COLUMN1 N_COLUMN1 from "INV"."MTL_DEMAND"

View Text - HTML Formatted

SELECT DEMAND_ID DEMAND_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME
, UOM_CODE UOM_CODE
, LINE_ITEM_QUANTITY LINE_ITEM_QUANTITY
, PRIMARY_UOM_QUANTITY PRIMARY_UOM_QUANTITY
, LINE_ITEM_RESERVATION_QTY LINE_ITEM_RESERVATION_QTY
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, COMPLETED_QUANTITY COMPLETED_QUANTITY
, REQUIREMENT_DATE REQUIREMENT_DATE
, RESERVATION_TYPE RESERVATION_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PARENT_DEMAND_ID PARENT_DEMAND_ID
, EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE
, EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID
, USER_LINE_NUM USER_LINE_NUM
, USER_DELIVERY USER_DELIVERY
, SCHEDULE_ID SCHEDULE_ID
, AUTODETAIL_GROUP_ID AUTODETAIL_GROUP_ID
, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE
, SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID
, SUPPLY_GROUP_ID SUPPLY_GROUP_ID
, UPDATED_FLAG UPDATED_FLAG
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, SUBINVENTORY SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, PARENT_COMPONENT_SEQ_ID PARENT_COMPONENT_SEQ_ID
, RTO_MODEL_SOURCE_LINE RTO_MODEL_SOURCE_LINE
, RTO_PREVIOUS_QTY RTO_PREVIOUS_QTY
, CONFIG_STATUS CONFIG_STATUS
, AVAILABLE_TO_MRP AVAILABLE_TO_MRP
, AVAILABLE_TO_ATP AVAILABLE_TO_ATP
, ESTIMATED_RELEASE_DATE ESTIMATED_RELEASE_DATE
, DEMAND_CLASS DEMAND_CLASS
, ROW_STATUS_FLAG ROW_STATUS_FLAG
, ORDER_CHANGE_REPORT_FLAG ORDER_CHANGE_REPORT_FLAG
, ATP_LEAD_TIME ATP_LEAD_TIME
, EXPLOSION_EFFECTIVITY_DATE EXPLOSION_EFFECTIVITY_DATE
, BOM_LEVEL BOM_LEVEL
, MRP_DATE MRP_DATE
, MRP_QUANTITY MRP_QUANTITY
, CUSTOMER_ID CUSTOMER_ID
, TERRITORY_ID TERRITORY_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, MASTER_RESERVATION_QTY MASTER_RESERVATION_QTY
, DESCRIPTION DESCRIPTION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, DEMAND_TYPE DEMAND_TYPE
, DUPLICATED_CONFIG_ITEM_ID DUPLICATED_CONFIG_ITEM_ID
, DUPLICATED_CONFIG_DEMAND_ID DUPLICATED_CONFIG_DEMAND_ID
, EXPLOSION_GROUP_ID EXPLOSION_GROUP_ID
, ORDERED_ITEM_ID ORDERED_ITEM_ID
, CONFIG_GROUP_ID CONFIG_GROUP_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, N_COLUMN1 N_COLUMN1
FROM "INV"."MTL_DEMAND"