VIEW: APPS.MTL_DEMAND_INTERFACE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'