VIEW: INV.MTL_DEMAND_INTERFACE#

Source

View Text - Preformatted

select SCHEDULE_GROUP_ID SCHEDULE_GROUP_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, LOCK_FLAG LOCK_FLAG, ATP_CHECK ATP_CHECK, ACTION_CODE ACTION_CODE, VALIDATE_ROWS VALIDATE_ROWS, TRANSACTION_MODE TRANSACTION_MODE, PROCESS_FLAG PROCESS_FLAG, SINGLE_LOT_FLAG SINGLE_LOT_FLAG, DETAIL_RESERVE_FLAG DETAIL_RESERVE_FLAG, RESERVE_LEVEL RESERVE_LEVEL, CHECK_ATR CHECK_ATR, 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, ERROR_CODE ERROR_CODE, ERR_EXPLANATION ERR_EXPLANATION, REQUIREMENT_DATE REQUIREMENT_DATE, LINE_ITEM_UNIT_OF_MEASURE LINE_ITEM_UNIT_OF_MEASURE, LINE_ITEM_UOM LINE_ITEM_UOM, LINE_ITEM_QUANTITY LINE_ITEM_QUANTITY, LINE_ITEM_RESERVATION_QTY LINE_ITEM_RESERVATION_QTY, PRIMARY_UOM PRIMARY_UOM, PRIMARY_UOM_QUANTITY PRIMARY_UOM_QUANTITY, RESERVATION_QUANTITY RESERVATION_QUANTITY, ATP_RULE_ID ATP_RULE_ID, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_NAME ORGANIZATION_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_SEGMENT1 ITEM_SEGMENT1, ITEM_SEGMENT2 ITEM_SEGMENT2, ITEM_SEGMENT3 ITEM_SEGMENT3, ITEM_SEGMENT4 ITEM_SEGMENT4, ITEM_SEGMENT5 ITEM_SEGMENT5, ITEM_SEGMENT6 ITEM_SEGMENT6, ITEM_SEGMENT7 ITEM_SEGMENT7, ITEM_SEGMENT8 ITEM_SEGMENT8, ITEM_SEGMENT9 ITEM_SEGMENT9, ITEM_SEGMENT10 ITEM_SEGMENT10, ITEM_SEGMENT11 ITEM_SEGMENT11, ITEM_SEGMENT12 ITEM_SEGMENT12, ITEM_SEGMENT13 ITEM_SEGMENT13, ITEM_SEGMENT14 ITEM_SEGMENT14, ITEM_SEGMENT15 ITEM_SEGMENT15, ITEM_SEGMENT16 ITEM_SEGMENT16, ITEM_SEGMENT17 ITEM_SEGMENT17, ITEM_SEGMENT18 ITEM_SEGMENT18, ITEM_SEGMENT19 ITEM_SEGMENT19, ITEM_SEGMENT20 ITEM_SEGMENT20, DEMAND_HEADER_SEGMENT1 DEMAND_HEADER_SEGMENT1, DEMAND_HEADER_SEGMENT2 DEMAND_HEADER_SEGMENT2, DEMAND_HEADER_SEGMENT3 DEMAND_HEADER_SEGMENT3, DEMAND_HEADER_SEGMENT4 DEMAND_HEADER_SEGMENT4, DEMAND_HEADER_SEGMENT5 DEMAND_HEADER_SEGMENT5, DEMAND_HEADER_SEGMENT6 DEMAND_HEADER_SEGMENT6, DEMAND_HEADER_SEGMENT7 DEMAND_HEADER_SEGMENT7, DEMAND_HEADER_SEGMENT8 DEMAND_HEADER_SEGMENT8, DEMAND_HEADER_SEGMENT9 DEMAND_HEADER_SEGMENT9, DEMAND_HEADER_SEGMENT10 DEMAND_HEADER_SEGMENT10, DEMAND_HEADER_SEGMENT11 DEMAND_HEADER_SEGMENT11, DEMAND_HEADER_SEGMENT12 DEMAND_HEADER_SEGMENT12, DEMAND_HEADER_SEGMENT13 DEMAND_HEADER_SEGMENT13, DEMAND_HEADER_SEGMENT14 DEMAND_HEADER_SEGMENT14, DEMAND_HEADER_SEGMENT15 DEMAND_HEADER_SEGMENT15, DEMAND_HEADER_SEGMENT16 DEMAND_HEADER_SEGMENT16, DEMAND_HEADER_SEGMENT17 DEMAND_HEADER_SEGMENT17, DEMAND_HEADER_SEGMENT18 DEMAND_HEADER_SEGMENT18, DEMAND_HEADER_SEGMENT19 DEMAND_HEADER_SEGMENT19, DEMAND_HEADER_SEGMENT20 DEMAND_HEADER_SEGMENT20, DEMAND_HEADER_SEGMENT21 DEMAND_HEADER_SEGMENT21, DEMAND_HEADER_SEGMENT22 DEMAND_HEADER_SEGMENT22, DEMAND_HEADER_SEGMENT23 DEMAND_HEADER_SEGMENT23, DEMAND_HEADER_SEGMENT24 DEMAND_HEADER_SEGMENT24, DEMAND_HEADER_SEGMENT25 DEMAND_HEADER_SEGMENT25, DEMAND_HEADER_SEGMENT26 DEMAND_HEADER_SEGMENT26, DEMAND_HEADER_SEGMENT27 DEMAND_HEADER_SEGMENT27, DEMAND_HEADER_SEGMENT28 DEMAND_HEADER_SEGMENT28, DEMAND_HEADER_SEGMENT29 DEMAND_HEADER_SEGMENT29, DEMAND_HEADER_SEGMENT30 DEMAND_HEADER_SEGMENT30, EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE, EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE, SUPPLY_HEADER_ID SUPPLY_HEADER_ID, USER_LINE_NUM USER_LINE_NUM, USER_DELIVERY USER_DELIVERY, REVISION REVISION, LOT_NUMBER LOT_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, SUBINVENTORY SUBINVENTORY, LOCATOR_ID LOCATOR_ID, LOC_SEGMENT1 LOC_SEGMENT1, LOC_SEGMENT2 LOC_SEGMENT2, LOC_SEGMENT3 LOC_SEGMENT3, LOC_SEGMENT4 LOC_SEGMENT4, LOC_SEGMENT5 LOC_SEGMENT5, LOC_SEGMENT6 LOC_SEGMENT6, LOC_SEGMENT7 LOC_SEGMENT7, LOC_SEGMENT8 LOC_SEGMENT8, LOC_SEGMENT9 LOC_SEGMENT9, LOC_SEGMENT10 LOC_SEGMENT10, LOC_SEGMENT11 LOC_SEGMENT11, LOC_SEGMENT12 LOC_SEGMENT12, LOC_SEGMENT13 LOC_SEGMENT13, LOC_SEGMENT14 LOC_SEGMENT14, LOC_SEGMENT15 LOC_SEGMENT15, LOC_SEGMENT16 LOC_SEGMENT16, LOC_SEGMENT17 LOC_SEGMENT17, LOC_SEGMENT18 LOC_SEGMENT18, LOC_SEGMENT19 LOC_SEGMENT19, LOC_SEGMENT20 LOC_SEGMENT20, AUTODETAIL_GROUP_ID AUTODETAIL_GROUP_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, OLD_REVISION OLD_REVISION, OLD_LOT_NUMBER OLD_LOT_NUMBER, OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER, OLD_SUBINVENTORY OLD_SUBINVENTORY, OLD_LOCATOR_ID OLD_LOCATOR_ID, OLD_LOC_SEGMENT1 OLD_LOC_SEGMENT1, OLD_LOC_SEGMENT2 OLD_LOC_SEGMENT2, OLD_LOC_SEGMENT3 OLD_LOC_SEGMENT3, OLD_LOC_SEGMENT4 OLD_LOC_SEGMENT4, OLD_LOC_SEGMENT5 OLD_LOC_SEGMENT5, OLD_LOC_SEGMENT6 OLD_LOC_SEGMENT6, OLD_LOC_SEGMENT7 OLD_LOC_SEGMENT7, OLD_LOC_SEGMENT8 OLD_LOC_SEGMENT8, OLD_LOC_SEGMENT9 OLD_LOC_SEGMENT9, OLD_LOC_SEGMENT10 OLD_LOC_SEGMENT10, OLD_LOC_SEGMENT11 OLD_LOC_SEGMENT11, OLD_LOC_SEGMENT12 OLD_LOC_SEGMENT12, OLD_LOC_SEGMENT13 OLD_LOC_SEGMENT13, OLD_LOC_SEGMENT14 OLD_LOC_SEGMENT14, OLD_LOC_SEGMENT15 OLD_LOC_SEGMENT15, OLD_LOC_SEGMENT16 OLD_LOC_SEGMENT16, OLD_LOC_SEGMENT17 OLD_LOC_SEGMENT17, OLD_LOC_SEGMENT18 OLD_LOC_SEGMENT18, OLD_LOC_SEGMENT19 OLD_LOC_SEGMENT19, OLD_LOC_SEGMENT20 OLD_LOC_SEGMENT20, SUPPLY_GROUP_ID SUPPLY_GROUP_ID, DEMAND_CLASS DEMAND_CLASS, 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, DESCRIPTION DESCRIPTION, LOT_EXPIRATION_CUTOFF_DATE LOT_EXPIRATION_CUTOFF_DATE, PARTIALS_ALLOWED_FLAG PARTIALS_ALLOWED_FLAG, AUTOSCHEDULE_DEMAND_QUANTITY AUTOSCHEDULE_DEMAND_QUANTITY, REQUEST_DATE_ATP_QUANTITY REQUEST_DATE_ATP_QUANTITY, EARLIEST_ATP_DATE EARLIEST_ATP_DATE, EARLIEST_ATP_DATE_QUANTITY EARLIEST_ATP_DATE_QUANTITY, REQUEST_ATP_DATE REQUEST_ATP_DATE, REQUEST_ATP_DATE_QUANTITY REQUEST_ATP_DATE_QUANTITY, GROUP_AVAILABLE_DATE GROUP_AVAILABLE_DATE, ACCUMULATION_WINDOW ACCUMULATION_WINDOW, ATP_LEAD_TIME ATP_LEAD_TIME, INFINITE_TIME_FENCE_DATE INFINITE_TIME_FENCE_DATE, GROUP_ATP_CHECK GROUP_ATP_CHECK, BOM_LEVEL BOM_LEVEL, EXPLOSION_EFFECTIVITY_DATE EXPLOSION_EFFECTIVITY_DATE, 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, C_COLUMN1 C_COLUMN1, C_COLUMN2 C_COLUMN2, C_COLUMN3 C_COLUMN3, C_COLUMN4 C_COLUMN4, C_COLUMN5 C_COLUMN5, C_COLUMN6 C_COLUMN6, C_COLUMN7 C_COLUMN7, C_COLUMN8 C_COLUMN8, N_COLUMN1 N_COLUMN1, N_COLUMN2 N_COLUMN2, N_COLUMN3 N_COLUMN3, N_COLUMN4 N_COLUMN4, N_COLUMN5 N_COLUMN5, D_COLUMN1 D_COLUMN1, D_COLUMN2 D_COLUMN2, D_COLUMN3 D_COLUMN3, D_COLUMN4 D_COLUMN4, D_COLUMN5 D_COLUMN5, ATP_GROUP_ID ATP_GROUP_ID, TRANSACTION_PROCESS_ORDER TRANSACTION_PROCESS_ORDER, DEMAND_ID DEMAND_ID, SESSION_ID SESSION_ID, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME, DEMAND_TYPE DEMAND_TYPE, AUTODETAILED_QUANTITY AUTODETAILED_QUANTITY, AVAILABLE_TO_RESERVE AVAILABLE_TO_RESERVE, QUANTITY_ON_HAND QUANTITY_ON_HAND, EXPLOSION_GROUP_ID EXPLOSION_GROUP_ID, RESERVATION_TYPE RESERVATION_TYPE, ORDERED_ITEM_ID ORDERED_ITEM_ID, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, ATP_CALENDAR_ORGANIZATION_ID ATP_CALENDAR_ORGANIZATION_ID, AUTODETAIL_EXPENSE_SUBINV_FLAG AUTODETAIL_EXPENSE_SUBINV_FLAG, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, SHIP_METHOD SHIP_METHOD, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID from "INV"."MTL_DEMAND_INTERFACE"

View Text - HTML Formatted

SELECT SCHEDULE_GROUP_ID SCHEDULE_GROUP_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
, LOCK_FLAG LOCK_FLAG
, ATP_CHECK ATP_CHECK
, ACTION_CODE ACTION_CODE
, VALIDATE_ROWS VALIDATE_ROWS
, TRANSACTION_MODE TRANSACTION_MODE
, PROCESS_FLAG PROCESS_FLAG
, SINGLE_LOT_FLAG SINGLE_LOT_FLAG
, DETAIL_RESERVE_FLAG DETAIL_RESERVE_FLAG
, RESERVE_LEVEL RESERVE_LEVEL
, CHECK_ATR CHECK_ATR
, 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
, ERROR_CODE ERROR_CODE
, ERR_EXPLANATION ERR_EXPLANATION
, REQUIREMENT_DATE REQUIREMENT_DATE
, LINE_ITEM_UNIT_OF_MEASURE LINE_ITEM_UNIT_OF_MEASURE
, LINE_ITEM_UOM LINE_ITEM_UOM
, LINE_ITEM_QUANTITY LINE_ITEM_QUANTITY
, LINE_ITEM_RESERVATION_QTY LINE_ITEM_RESERVATION_QTY
, PRIMARY_UOM PRIMARY_UOM
, PRIMARY_UOM_QUANTITY PRIMARY_UOM_QUANTITY
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, ATP_RULE_ID ATP_RULE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_SEGMENT1 ITEM_SEGMENT1
, ITEM_SEGMENT2 ITEM_SEGMENT2
, ITEM_SEGMENT3 ITEM_SEGMENT3
, ITEM_SEGMENT4 ITEM_SEGMENT4
, ITEM_SEGMENT5 ITEM_SEGMENT5
, ITEM_SEGMENT6 ITEM_SEGMENT6
, ITEM_SEGMENT7 ITEM_SEGMENT7
, ITEM_SEGMENT8 ITEM_SEGMENT8
, ITEM_SEGMENT9 ITEM_SEGMENT9
, ITEM_SEGMENT10 ITEM_SEGMENT10
, ITEM_SEGMENT11 ITEM_SEGMENT11
, ITEM_SEGMENT12 ITEM_SEGMENT12
, ITEM_SEGMENT13 ITEM_SEGMENT13
, ITEM_SEGMENT14 ITEM_SEGMENT14
, ITEM_SEGMENT15 ITEM_SEGMENT15
, ITEM_SEGMENT16 ITEM_SEGMENT16
, ITEM_SEGMENT17 ITEM_SEGMENT17
, ITEM_SEGMENT18 ITEM_SEGMENT18
, ITEM_SEGMENT19 ITEM_SEGMENT19
, ITEM_SEGMENT20 ITEM_SEGMENT20
, DEMAND_HEADER_SEGMENT1 DEMAND_HEADER_SEGMENT1
, DEMAND_HEADER_SEGMENT2 DEMAND_HEADER_SEGMENT2
, DEMAND_HEADER_SEGMENT3 DEMAND_HEADER_SEGMENT3
, DEMAND_HEADER_SEGMENT4 DEMAND_HEADER_SEGMENT4
, DEMAND_HEADER_SEGMENT5 DEMAND_HEADER_SEGMENT5
, DEMAND_HEADER_SEGMENT6 DEMAND_HEADER_SEGMENT6
, DEMAND_HEADER_SEGMENT7 DEMAND_HEADER_SEGMENT7
, DEMAND_HEADER_SEGMENT8 DEMAND_HEADER_SEGMENT8
, DEMAND_HEADER_SEGMENT9 DEMAND_HEADER_SEGMENT9
, DEMAND_HEADER_SEGMENT10 DEMAND_HEADER_SEGMENT10
, DEMAND_HEADER_SEGMENT11 DEMAND_HEADER_SEGMENT11
, DEMAND_HEADER_SEGMENT12 DEMAND_HEADER_SEGMENT12
, DEMAND_HEADER_SEGMENT13 DEMAND_HEADER_SEGMENT13
, DEMAND_HEADER_SEGMENT14 DEMAND_HEADER_SEGMENT14
, DEMAND_HEADER_SEGMENT15 DEMAND_HEADER_SEGMENT15
, DEMAND_HEADER_SEGMENT16 DEMAND_HEADER_SEGMENT16
, DEMAND_HEADER_SEGMENT17 DEMAND_HEADER_SEGMENT17
, DEMAND_HEADER_SEGMENT18 DEMAND_HEADER_SEGMENT18
, DEMAND_HEADER_SEGMENT19 DEMAND_HEADER_SEGMENT19
, DEMAND_HEADER_SEGMENT20 DEMAND_HEADER_SEGMENT20
, DEMAND_HEADER_SEGMENT21 DEMAND_HEADER_SEGMENT21
, DEMAND_HEADER_SEGMENT22 DEMAND_HEADER_SEGMENT22
, DEMAND_HEADER_SEGMENT23 DEMAND_HEADER_SEGMENT23
, DEMAND_HEADER_SEGMENT24 DEMAND_HEADER_SEGMENT24
, DEMAND_HEADER_SEGMENT25 DEMAND_HEADER_SEGMENT25
, DEMAND_HEADER_SEGMENT26 DEMAND_HEADER_SEGMENT26
, DEMAND_HEADER_SEGMENT27 DEMAND_HEADER_SEGMENT27
, DEMAND_HEADER_SEGMENT28 DEMAND_HEADER_SEGMENT28
, DEMAND_HEADER_SEGMENT29 DEMAND_HEADER_SEGMENT29
, DEMAND_HEADER_SEGMENT30 DEMAND_HEADER_SEGMENT30
, EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE
, EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID
, SUPPLY_SOURCE_TYPE SUPPLY_SOURCE_TYPE
, SUPPLY_HEADER_ID SUPPLY_HEADER_ID
, USER_LINE_NUM USER_LINE_NUM
, USER_DELIVERY USER_DELIVERY
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, SUBINVENTORY SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, LOC_SEGMENT1 LOC_SEGMENT1
, LOC_SEGMENT2 LOC_SEGMENT2
, LOC_SEGMENT3 LOC_SEGMENT3
, LOC_SEGMENT4 LOC_SEGMENT4
, LOC_SEGMENT5 LOC_SEGMENT5
, LOC_SEGMENT6 LOC_SEGMENT6
, LOC_SEGMENT7 LOC_SEGMENT7
, LOC_SEGMENT8 LOC_SEGMENT8
, LOC_SEGMENT9 LOC_SEGMENT9
, LOC_SEGMENT10 LOC_SEGMENT10
, LOC_SEGMENT11 LOC_SEGMENT11
, LOC_SEGMENT12 LOC_SEGMENT12
, LOC_SEGMENT13 LOC_SEGMENT13
, LOC_SEGMENT14 LOC_SEGMENT14
, LOC_SEGMENT15 LOC_SEGMENT15
, LOC_SEGMENT16 LOC_SEGMENT16
, LOC_SEGMENT17 LOC_SEGMENT17
, LOC_SEGMENT18 LOC_SEGMENT18
, LOC_SEGMENT19 LOC_SEGMENT19
, LOC_SEGMENT20 LOC_SEGMENT20
, AUTODETAIL_GROUP_ID AUTODETAIL_GROUP_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
, OLD_REVISION OLD_REVISION
, OLD_LOT_NUMBER OLD_LOT_NUMBER
, OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER
, OLD_SUBINVENTORY OLD_SUBINVENTORY
, OLD_LOCATOR_ID OLD_LOCATOR_ID
, OLD_LOC_SEGMENT1 OLD_LOC_SEGMENT1
, OLD_LOC_SEGMENT2 OLD_LOC_SEGMENT2
, OLD_LOC_SEGMENT3 OLD_LOC_SEGMENT3
, OLD_LOC_SEGMENT4 OLD_LOC_SEGMENT4
, OLD_LOC_SEGMENT5 OLD_LOC_SEGMENT5
, OLD_LOC_SEGMENT6 OLD_LOC_SEGMENT6
, OLD_LOC_SEGMENT7 OLD_LOC_SEGMENT7
, OLD_LOC_SEGMENT8 OLD_LOC_SEGMENT8
, OLD_LOC_SEGMENT9 OLD_LOC_SEGMENT9
, OLD_LOC_SEGMENT10 OLD_LOC_SEGMENT10
, OLD_LOC_SEGMENT11 OLD_LOC_SEGMENT11
, OLD_LOC_SEGMENT12 OLD_LOC_SEGMENT12
, OLD_LOC_SEGMENT13 OLD_LOC_SEGMENT13
, OLD_LOC_SEGMENT14 OLD_LOC_SEGMENT14
, OLD_LOC_SEGMENT15 OLD_LOC_SEGMENT15
, OLD_LOC_SEGMENT16 OLD_LOC_SEGMENT16
, OLD_LOC_SEGMENT17 OLD_LOC_SEGMENT17
, OLD_LOC_SEGMENT18 OLD_LOC_SEGMENT18
, OLD_LOC_SEGMENT19 OLD_LOC_SEGMENT19
, OLD_LOC_SEGMENT20 OLD_LOC_SEGMENT20
, SUPPLY_GROUP_ID SUPPLY_GROUP_ID
, DEMAND_CLASS DEMAND_CLASS
, 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
, DESCRIPTION DESCRIPTION
, LOT_EXPIRATION_CUTOFF_DATE LOT_EXPIRATION_CUTOFF_DATE
, PARTIALS_ALLOWED_FLAG PARTIALS_ALLOWED_FLAG
, AUTOSCHEDULE_DEMAND_QUANTITY AUTOSCHEDULE_DEMAND_QUANTITY
, REQUEST_DATE_ATP_QUANTITY REQUEST_DATE_ATP_QUANTITY
, EARLIEST_ATP_DATE EARLIEST_ATP_DATE
, EARLIEST_ATP_DATE_QUANTITY EARLIEST_ATP_DATE_QUANTITY
, REQUEST_ATP_DATE REQUEST_ATP_DATE
, REQUEST_ATP_DATE_QUANTITY REQUEST_ATP_DATE_QUANTITY
, GROUP_AVAILABLE_DATE GROUP_AVAILABLE_DATE
, ACCUMULATION_WINDOW ACCUMULATION_WINDOW
, ATP_LEAD_TIME ATP_LEAD_TIME
, INFINITE_TIME_FENCE_DATE INFINITE_TIME_FENCE_DATE
, GROUP_ATP_CHECK GROUP_ATP_CHECK
, BOM_LEVEL BOM_LEVEL
, EXPLOSION_EFFECTIVITY_DATE EXPLOSION_EFFECTIVITY_DATE
, 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
, C_COLUMN1 C_COLUMN1
, C_COLUMN2 C_COLUMN2
, C_COLUMN3 C_COLUMN3
, C_COLUMN4 C_COLUMN4
, C_COLUMN5 C_COLUMN5
, C_COLUMN6 C_COLUMN6
, C_COLUMN7 C_COLUMN7
, C_COLUMN8 C_COLUMN8
, N_COLUMN1 N_COLUMN1
, N_COLUMN2 N_COLUMN2
, N_COLUMN3 N_COLUMN3
, N_COLUMN4 N_COLUMN4
, N_COLUMN5 N_COLUMN5
, D_COLUMN1 D_COLUMN1
, D_COLUMN2 D_COLUMN2
, D_COLUMN3 D_COLUMN3
, D_COLUMN4 D_COLUMN4
, D_COLUMN5 D_COLUMN5
, ATP_GROUP_ID ATP_GROUP_ID
, TRANSACTION_PROCESS_ORDER TRANSACTION_PROCESS_ORDER
, DEMAND_ID DEMAND_ID
, SESSION_ID SESSION_ID
, DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME
, DEMAND_TYPE DEMAND_TYPE
, AUTODETAILED_QUANTITY AUTODETAILED_QUANTITY
, AVAILABLE_TO_RESERVE AVAILABLE_TO_RESERVE
, QUANTITY_ON_HAND QUANTITY_ON_HAND
, EXPLOSION_GROUP_ID EXPLOSION_GROUP_ID
, RESERVATION_TYPE RESERVATION_TYPE
, ORDERED_ITEM_ID ORDERED_ITEM_ID
, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, ATP_CALENDAR_ORGANIZATION_ID ATP_CALENDAR_ORGANIZATION_ID
, AUTODETAIL_EXPENSE_SUBINV_FLAG AUTODETAIL_EXPENSE_SUBINV_FLAG
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME
, SHIP_METHOD SHIP_METHOD
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
FROM "INV"."MTL_DEMAND_INTERFACE"