View: MTL_DEMAND_INTERFACE_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_DEMAND_INTERFACE_V

View Text

SELECT MDI.ROWID ROW_ID
, MDI.SCHEDULE_GROUP_ID
, MDI.DEMAND_SOURCE_TYPE
, MTST1.TRANSACTION_SOURCE_TYPE_NAME DEMAND_SOURCE_TYPE_DESCRIPTION
, MDI.DEMAND_SOURCE_HEADER_ID
, MDI.DEMAND_SOURCE_LINE
, MDI.DEMAND_SOURCE_DELIVERY
, MDI.LOCK_FLAG
, MDI.ATP_CHECK
, MDI.ACTION_CODE
, MFG6.MEANING ACTION_CODE_DESCRIPTION
, MDI.VALIDATE_ROWS
, MDI.TRANSACTION_MODE
, MFG2.MEANING TRANSACTION_MODE_DESCRIPTION
, MDI.PROCESS_FLAG
, MFG3.MEANING PROCESS_FLAG_DESCRIPTION
, MDI.SINGLE_LOT_FLAG
, MDI.DETAIL_RESERVE_FLAG
, MDI.RESERVE_LEVEL
, MDI.CHECK_ATR
, MDI.LAST_UPDATE_DATE
, MDI.LAST_UPDATED_BY
, MDI.CREATION_DATE
, MDI.CREATED_BY
, MDI.LAST_UPDATE_LOGIN
, MDI.ERROR_CODE
, MFG1.MEANING ERROR_CODE_DESCRIPTION
, MFG1.MEANING ERR_EXPLANATION
, MDI.REQUIREMENT_DATE
, MDI.RESERVATION_TYPE
, MDI.LINE_ITEM_UNIT_OF_MEASURE
, MDI.LINE_ITEM_UOM
, MDI.LINE_ITEM_QUANTITY
, MDI.LINE_ITEM_RESERVATION_QTY
, MDI.PRIMARY_UOM
, MDI.PRIMARY_UOM_QUANTITY
, MDI.RESERVATION_QUANTITY
, MDI.ATP_RULE_ID
, MAR.RULE_NAME ATP_RULE_NAME
, MDI.ORGANIZATION_ID
, MO1.ORGANIZATION_CODE
, MDI.ORGANIZATION_NAME
, MDI.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MDI.ITEM_SEGMENT1
, MDI.ITEM_SEGMENT2
, MDI.ITEM_SEGMENT3
, MDI.ITEM_SEGMENT4
, MDI.ITEM_SEGMENT5
, MDI.ITEM_SEGMENT6
, MDI.ITEM_SEGMENT7
, MDI.ITEM_SEGMENT8
, MDI.ITEM_SEGMENT9
, MDI.ITEM_SEGMENT10
, MDI.ITEM_SEGMENT11
, MDI.ITEM_SEGMENT12
, MDI.ITEM_SEGMENT13
, MDI.ITEM_SEGMENT14
, MDI.ITEM_SEGMENT15
, MDI.ITEM_SEGMENT16
, MDI.ITEM_SEGMENT17
, MDI.ITEM_SEGMENT18
, MDI.ITEM_SEGMENT19
, MDI.ITEM_SEGMENT20
, MDI.DEMAND_HEADER_SEGMENT1
, MDI.DEMAND_HEADER_SEGMENT2
, MDI.DEMAND_HEADER_SEGMENT3
, MDI.DEMAND_HEADER_SEGMENT4
, MDI.DEMAND_HEADER_SEGMENT5
, MDI.DEMAND_HEADER_SEGMENT6
, MDI.DEMAND_HEADER_SEGMENT7
, MDI.DEMAND_HEADER_SEGMENT8
, MDI.DEMAND_HEADER_SEGMENT9
, MDI.DEMAND_HEADER_SEGMENT10
, MDI.DEMAND_HEADER_SEGMENT11
, MDI.DEMAND_HEADER_SEGMENT12
, MDI.DEMAND_HEADER_SEGMENT13
, MDI.DEMAND_HEADER_SEGMENT14
, MDI.DEMAND_HEADER_SEGMENT15
, MDI.DEMAND_HEADER_SEGMENT16
, MDI.DEMAND_HEADER_SEGMENT17
, MDI.DEMAND_HEADER_SEGMENT18
, MDI.DEMAND_HEADER_SEGMENT19
, MDI.DEMAND_HEADER_SEGMENT20
, MDI.DEMAND_HEADER_SEGMENT21
, MDI.DEMAND_HEADER_SEGMENT22
, MDI.DEMAND_HEADER_SEGMENT23
, MDI.DEMAND_HEADER_SEGMENT24
, MDI.DEMAND_HEADER_SEGMENT25
, MDI.DEMAND_HEADER_SEGMENT26
, MDI.DEMAND_HEADER_SEGMENT27
, MDI.DEMAND_HEADER_SEGMENT28
, MDI.DEMAND_HEADER_SEGMENT29
, MDI.DEMAND_HEADER_SEGMENT30
, MDI.EXTERNAL_SOURCE_CODE
, MDI.EXTERNAL_SOURCE_LINE_ID
, MDI.SUPPLY_SOURCE_TYPE
, MTST2.TRANSACTION_SOURCE_TYPE_NAME SUPPLY_SOURCE_TYPE_DESCRIPTION
, MDI.SUPPLY_HEADER_ID
, MDI.USER_LINE_NUM
, MDI.USER_DELIVERY
, MDI.REVISION
, MDI.LOT_NUMBER
, MDI.SERIAL_NUMBER
, MDI.SUBINVENTORY
, MDI.LOCATOR_ID
, MDI.LOC_SEGMENT1
, MDI.LOC_SEGMENT2
, MDI.LOC_SEGMENT3
, MDI.LOC_SEGMENT4
, MDI.LOC_SEGMENT5
, MDI.LOC_SEGMENT6
, MDI.LOC_SEGMENT7
, MDI.LOC_SEGMENT8
, MDI.LOC_SEGMENT9
, MDI.LOC_SEGMENT10
, MDI.LOC_SEGMENT11
, MDI.LOC_SEGMENT12
, MDI.LOC_SEGMENT13
, MDI.LOC_SEGMENT14
, MDI.LOC_SEGMENT15
, MDI.LOC_SEGMENT16
, MDI.LOC_SEGMENT17
, MDI.LOC_SEGMENT18
, MDI.LOC_SEGMENT19
, MDI.LOC_SEGMENT20
, MDI.AUTODETAIL_GROUP_ID
, MDI.COMPONENT_SEQUENCE_ID
, MDI.PARENT_COMPONENT_SEQ_ID
, MDI.RTO_MODEL_SOURCE_LINE
, MDI.RTO_PREVIOUS_QTY
, MDI.CONFIG_STATUS
, MDI.OLD_REVISION
, MDI.OLD_LOT_NUMBER
, MDI.OLD_SERIAL_NUMBER
, MDI.OLD_SUBINVENTORY
, MDI.OLD_LOCATOR_ID
, MDI.OLD_LOC_SEGMENT1
, MDI.OLD_LOC_SEGMENT2
, MDI.OLD_LOC_SEGMENT3
, MDI.OLD_LOC_SEGMENT4
, MDI.OLD_LOC_SEGMENT5
, MDI.OLD_LOC_SEGMENT6
, MDI.OLD_LOC_SEGMENT7
, MDI.OLD_LOC_SEGMENT8
, MDI.OLD_LOC_SEGMENT9
, MDI.OLD_LOC_SEGMENT10
, MDI.OLD_LOC_SEGMENT11
, MDI.OLD_LOC_SEGMENT12
, MDI.OLD_LOC_SEGMENT13
, MDI.OLD_LOC_SEGMENT14
, MDI.OLD_LOC_SEGMENT15
, MDI.OLD_LOC_SEGMENT16
, MDI.OLD_LOC_SEGMENT17
, MDI.OLD_LOC_SEGMENT18
, MDI.OLD_LOC_SEGMENT19
, MDI.OLD_LOC_SEGMENT20
, MDI.SUPPLY_GROUP_ID
, MDI.DEMAND_CLASS
, MDI.CUSTOMER_ID
, MDI.TERRITORY_ID
, MDI.BILL_TO_SITE_USE_ID
, MDI.SHIP_TO_SITE_USE_ID
, MDI.DESCRIPTION
, MDI.LOT_EXPIRATION_CUTOFF_DATE
, MDI.PARTIALS_ALLOWED_FLAG
, MDI.AUTOSCHEDULE_DEMAND_QUANTITY
, MDI.REQUEST_DATE_ATP_QUANTITY
, MDI.EARLIEST_ATP_DATE
, MDI.EARLIEST_ATP_DATE_QUANTITY
, MDI.REQUEST_ATP_DATE
, MDI.REQUEST_ATP_DATE_QUANTITY
, MDI.GROUP_AVAILABLE_DATE
, MDI.ACCUMULATION_WINDOW
, MDI.ATP_LEAD_TIME
, MDI.INFINITE_TIME_FENCE_DATE
, MDI.GROUP_ATP_CHECK
, MDI.BOM_LEVEL
, MDI.EXPLOSION_EFFECTIVITY_DATE
, MDI.ATTRIBUTE_CATEGORY
, MDI.ATTRIBUTE1
, MDI.ATTRIBUTE2
, MDI.ATTRIBUTE3
, MDI.ATTRIBUTE4
, MDI.ATTRIBUTE5
, MDI.ATTRIBUTE6
, MDI.ATTRIBUTE7
, MDI.ATTRIBUTE8
, MDI.ATTRIBUTE9
, MDI.ATTRIBUTE10
, MDI.ATTRIBUTE11
, MDI.ATTRIBUTE12
, MDI.ATTRIBUTE13
, MDI.ATTRIBUTE14
, MDI.ATTRIBUTE15
, MDI.C_COLUMN1
, MDI.C_COLUMN2
, MDI.C_COLUMN3
, MDI.C_COLUMN4
, MDI.C_COLUMN5
, MDI.C_COLUMN6
, MDI.C_COLUMN7
, MDI.C_COLUMN8
, MDI.N_COLUMN1
, MDI.N_COLUMN2
, MDI.N_COLUMN3
, MDI.N_COLUMN4
, MDI.N_COLUMN5
, MDI.D_COLUMN1
, MDI.D_COLUMN2
, MDI.D_COLUMN3
, MDI.D_COLUMN4
, MDI.D_COLUMN5
, MDI.TRANSACTION_PROCESS_ORDER
, MDI.DEMAND_ID
, MDI.SESSION_ID
, MDI.DEMAND_SOURCE_NAME
, MDI.DEMAND_TYPE
, MFG5.MEANING DEMAND_TYPE_DESCRIPTION
, MDI.AUTODETAILED_QUANTITY
, MDI.AVAILABLE_TO_RESERVE
, MDI.QUANTITY_ON_HAND
, MDI.EXPLOSION_GROUP_ID
, MDI.ORDERED_ITEM_ID
, MDI.ATP_COMPONENTS_FLAG
, MDI.LATEST_ACCEPTABLE_DATE
, MDI.ATP_CALENDAR_ORGANIZATION_ID
, MO2.ORGANIZATION_CODE ATP_CALENDAR_ORG_CODE
, MDI.AUTODETAIL_EXPENSE_SUBINV_FLAG
FROM MFG_LOOKUPS MFG1
, MFG_LOOKUPS MFG2
, MFG_LOOKUPS MFG3
, MFG_LOOKUPS MFG5
, MFG_LOOKUPS MFG6
, MTL_DEMAND_INTERFACE MDI
, MTL_SYSTEM_ITEMS MSI
, MTL_ATP_RULES MAR
, MTL_TXN_SOURCE_TYPES MTST1
, MTL_TXN_SOURCE_TYPES MTST2
, MTL_PARAMETERS MO1
, MTL_PARAMETERS MO2
WHERE MSI.INVENTORY_ITEM_ID (+) = MDI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = MDI.ORGANIZATION_ID
AND MAR.RULE_ID(+) = MDI.ATP_RULE_ID
AND MO1.ORGANIZATION_ID(+) = MDI.ORGANIZATION_ID
AND MO2.ORGANIZATION_ID(+) = MDI.ATP_CALENDAR_ORGANIZATION_ID
AND MTST1.TRANSACTION_SOURCE_TYPE_ID(+) = MDI.DEMAND_SOURCE_TYPE
AND MTST2.TRANSACTION_SOURCE_TYPE_ID(+) = MDI.SUPPLY_SOURCE_TYPE
AND MFG1.LOOKUP_CODE(+) = MDI.ERROR_CODE
AND MFG1.LOOKUP_TYPE(+) = 'MTL_DEMAND_INTERFACE_ERRORS'
AND MFG2.LOOKUP_CODE(+) = MDI.TRANSACTION_MODE
AND MFG2.LOOKUP_TYPE(+) = 'MTL_TRANSACTION_MODE'
AND MFG3.LOOKUP_CODE(+) = MDI.PROCESS_FLAG
AND MFG3.LOOKUP_TYPE(+) = 'INV_YES_NO_ERROR'
AND MFG5.LOOKUP_CODE(+) = MDI.DEMAND_TYPE
AND MFG5.LOOKUP_TYPE(+) = 'MTL_DEMAND_TYPE'
AND MFG6.LOOKUP_CODE(+) = MDI.ACTION_CODE
AND MFG6.LOOKUP_TYPE(+) = 'MTL_DEMAND_ACTION_CODE'

Columns