SELECT "MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID", "MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID", "MTL_SYSTEM_ITEMS_B"."LAST_UPDATE_DATE", "MTL_SYSTEM_ITEMS_B"."CREATION_DATE", "MTL_SYSTEM_ITEMS_B"."START_DATE_ACTIVE", "MTL_SYSTEM_ITEMS_B"."DESCRIPTION", "MTL_SYSTEM_ITEMS_B"."SEGMENT1", "MTL_SYSTEM_ITEMS_B"."ATTRIBUTE7", "MTL_SYSTEM_ITEMS_B"."ATTRIBUTE10", "MTL_SYSTEM_ITEMS_B"."ATTRIBUTE15", "MTL_SYSTEM_ITEMS_B"."UNIT_OF_ISSUE", "MTL_SYSTEM_ITEMS_B"."SOURCE_SUBINVENTORY", "MTL_SYSTEM_ITEMS_B"."CUMULATIVE_TOTAL_LEAD_TIME", "MTL_SYSTEM_ITEMS_B"."CUM_MANUFACTURING_LEAD_TIME", "MTL_SYSTEM_ITEMS_B"."FULL_LEAD_TIME", "MTL_SYSTEM_ITEMS_B"."BOM_ITEM_TYPE", "MTL_SYSTEM_ITEMS_B"."PRIMARY_UOM_CODE", "MTL_SYSTEM_ITEMS_B"."PRIMARY_UNIT_OF_MEASURE", "MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_STATUS_CODE", "MTL_SYSTEM_ITEMS_B"."MIN_MINMAX_QUANTITY", "MTL_SYSTEM_ITEMS_B"."MAX_MINMAX_QUANTITY", "MTL_SYSTEM_ITEMS_B"."SAFETY_STOCK_BUCKET_DAYS", "MTL_SYSTEM_ITEMS_B"."ITEM_TYPE", "MTL_PARAMETERS"."ORGANIZATION_CODE", "HR_ORGANIZATION_UNITS"."LOCATION_ID", "MTL_ITEM_CATEGORIES"."CATEGORY_SET_ID", "MTL_ITEM_CATEGORIES"."LAST_UPDATE_DATE", "MTL_CATEGORIES_B"."CATEGORY_ID", "MTL_CATEGORIES_B"."LAST_UPDATE_DATE", "MTL_CATEGORIES_B"."DESCRIPTION", "MTL_CATEGORIES_B"."DISABLE_DATE", "MTL_CATEGORIES_B"."SEGMENT1", "MTL_CATEGORIES_B"."ATTRIBUTE7", "GL_SETS_OF_BOOKS"."CURRENCY_CODE", "MTL_ITEM_FLEXFIELDS"."COST_OF_SALES_ACCOUNT", "FND_CURRENCIES_TL"."DESCRIPTION", "FND_CURRENCIES_TL"."LAST_UPDATE_DATE", "MTL_ITEM_FLEXFIELDS"."SALES_ACCOUNT", "FND_FLEX_VALUES_TL"."DESCRIPTION", "MFG_LOOKUPS"."LOOKUP_TYPE", "MFG_LOOKUPS"."LOOKUP_CODE", "MFG_LOOKUPS"."MEANING", "MFG_LOOKUPS"."DESCRIPTION", "MFG_LOOKUPS"."LAST_UPDATE_DATE", "CST_ITEM_COSTS"."COST_TYPE_ID", "CST_ITEM_COSTS"."LAST_UPDATE_DATE", "CST_ITEM_COSTS"."MATERIAL_COST", "CST_ITEM_COSTS"."MATERIAL_OVERHEAD_COST", "CST_ITEM_COSTS"."RESOURCE_COST", "CST_ITEM_COSTS"."OUTSIDE_PROCESSING_COST", "CST_ITEM_COSTS"."OVERHEAD_COST", "CST_ITEM_COSTS"."ITEM_COST", "CST_ITEM_COSTS"."UNBURDENED_COST", "CST_ITEM_COSTS"."BURDEN_COST", "CST_COST_TYPES"."DEFAULT_COST_TYPE_ID", "CST_COST_TYPES"."LAST_UPDATE_DATE", "CST_COST_TYPES"."COST_TYPE", "CST_COST_TYPES"."DESCRIPTION", "MTL_SYSTEM_ITEMS_B"."PURCHASING_ITEM_FLAG", "MTL_SYSTEM_ITEMS_B"."MUST_USE_APPROVED_VENDOR_FLAG", "MTL_SYSTEM_ITEMS_B"."PURCHASING_ENABLED_FLAG", "MTL_SYSTEM_ITEMS_B"."BUILD_IN_WIP_FLAG", "MTL_SYSTEM_ITEMS_B"."PICK_COMPONENTS_FLAG", "MTL_SYSTEM_ITEMS_B"."INVOICEABLE_ITEM_FLAG", "MTL_SYSTEM_ITEMS_B"."SO_TRANSACTIONS_FLAG", "MTL_SYSTEM_ITEMS_B"."SHIPPABLE_ITEM_FLAG", "MTL_SYSTEM_ITEMS_B"."CUSTOMER_ORDER_FLAG", "MTL_SYSTEM_ITEMS_B"."CUSTOMER_ORDER_ENABLED_FLAG", "MFG_LOOKUPS_3"."MEANING", "MTL_SYSTEM_ITEMS_B"."FIXED_LOT_MULTIPLIER", "MTL_SYSTEM_ITEMS_B"."MINIMUM_ORDER_QUANTITY", "MTL_SYSTEM_ITEMS_B"."MAXIMUM_ORDER_QUANTITY", "MFG_LOOKUPS_1"."MEANING", "MFG_LOOKUPS_2"."MEANING", "MTL_SYSTEM_ITEMS_B"."FIXED_LEAD_TIME", "MTL_SYSTEM_ITEMS_B"."PREPROCESSING_LEAD_TIME", "MTL_SYSTEM_ITEMS_B"."POSTPROCESSING_LEAD_TIME", "MTL_SYSTEM_ITEMS_B"."CONSIGNED_FLAG", "MTL_SYSTEM_ITEMS_B"."ATP_FLAG", "MTL_SYSTEM_ITEMS_B"."PLANNER_CODE", "HR_ORGANIZATION_UNITS"."NAME" FROM "INV"."MTL_CATEGORY_SETS_TL" "MTL_CATEGORY_SETS_TL", "APPS"."MFG_LOOKUPS" "MFG_LOOKUPS_3", "APPS"."MFG_LOOKUPS" "MFG_LOOKUPS_2", "APPS"."MFG_LOOKUPS" "MFG_LOOKUPS_1", "APPS"."MFG_LOOKUPS" "MFG_LOOKUPS", "APPLSYS"."FND_CURRENCIES_TL" "FND_CURRENCIES_TL", "GL"."GL_SETS_OF_BOOKS" "GL_SETS_OF_BOOKS", "APPS"."HR_ORGANIZATION_UNITS" "HR_ORGANIZATION_UNITS", "INV"."MTL_PARAMETERS" "MTL_PARAMETERS", "APPS"."ORG_ORGANIZATION_DEFINITIONS" "ORG_ORGANIZATION_DEFINITIONS", "APPS"."MTL_ITEM_FLEXFIELDS" "MTL_ITEM_FLEXFIELDS", "BOM"."CST_COST_TYPES" "CST_COST_TYPES", "BOM"."CST_ITEM_COSTS" "CST_ITEM_COSTS", "INV"."MTL_SYSTEM_ITEMS_B" "MTL_SYSTEM_ITEMS_B", "INV"."MTL_ITEM_CATEGORIES" "MTL_ITEM_CATEGORIES", "INV"."MTL_CATEGORIES_B" "MTL_CATEGORIES_B", "APPLSYS"."FND_FLEX_VALUES_TL" "FND_FLEX_VALUES_TL", "APPLSYS"."FND_FLEX_VALUE_SETS" "FND_FLEX_VALUE_SETS", "APPLSYS"."FND_FLEX_VALUES" "FND_FLEX_VALUES", inv.mtl_atp_rules r WHERE ("MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID" = "CST_ITEM_COSTS"."INVENTORY_ITEM_ID") AND ("MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID" = "CST_ITEM_COSTS"."ORGANIZATION_ID") AND ("MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID" = "MTL_ITEM_CATEGORIES"."INVENTORY_ITEM_ID") AND ("MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID" = "MTL_ITEM_CATEGORIES"."ORGANIZATION_ID") AND ("MTL_ITEM_CATEGORIES"."CATEGORY_SET_ID" = "MTL_CATEGORY_SETS_TL"."CATEGORY_SET_ID") AND ("MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID" = "MTL_ITEM_FLEXFIELDS"."INVENTORY_ITEM_ID") AND ("MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID" = "MTL_ITEM_FLEXFIELDS"."ORGANIZATION_ID") AND ("MTL_ITEM_FLEXFIELDS"."ORGANIZATION_ID" = "ORG_ORGANIZATION_DEFINITIONS"."ORGANIZATION_ID") AND ("ORG_ORGANIZATION_DEFINITIONS"."ORGANIZATION_ID" = "MTL_PARAMETERS"."ORGANIZATION_ID") AND ("MTL_PARAMETERS"."ORGANIZATION_ID" = "HR_ORGANIZATION_UNITS"."ORGANIZATION_ID") AND ("ORG_ORGANIZATION_DEFINITIONS"."SET_OF_BOOKS_ID" = "GL_SETS_OF_BOOKS"."SET_OF_BOOKS_ID") AND ("GL_SETS_OF_BOOKS"."CURRENCY_CODE" = "FND_CURRENCIES_TL"."CURRENCY_CODE") AND ("FND_CURRENCIES_TL"."LANGUAGE" = 'US') AND ("MTL_ITEM_CATEGORIES"."CATEGORY_ID" = "MTL_CATEGORIES_B"."CATEGORY_ID") AND ("FND_FLEX_VALUE_SETS"."FLEX_VALUE_SET_ID" = "FND_FLEX_VALUES"."FLEX_VALUE_SET_ID") AND ("FND_FLEX_VALUES"."FLEX_VALUE_ID" = "FND_FLEX_VALUES_TL"."FLEX_VALUE_ID") AND ("FND_FLEX_VALUES_TL"."LANGUAGE" = 'US') AND ("MTL_CATEGORIES_B"."SEGMENT1" = "FND_FLEX_VALUES"."FLEX_VALUE") AND ("CST_ITEM_COSTS"."COST_TYPE_ID" = "CST_COST_TYPES"."COST_TYPE_ID") AND ("MTL_SYSTEM_ITEMS_B"."BOM_ITEM_TYPE" = "MFG_LOOKUPS"."LOOKUP_CODE") AND ("MTL_SYSTEM_ITEMS_B"."INVENTORY_PLANNING_CODE" = "MFG_LOOKUPS_1"."LOOKUP_CODE") AND ("MTL_SYSTEM_ITEMS_B"."MRP_PLANNING_CODE" = "MFG_LOOKUPS_2"."LOOKUP_CODE") AND ("MTL_SYSTEM_ITEMS_B"."PLANNING_MAKE_BUY_CODE" = "MFG_LOOKUPS_3"."LOOKUP_CODE") AND (r.RULE_ID(+) = "MTL_SYSTEM_ITEMS_B".atp_rule_id) AND (("MTL_SYSTEM_ITEMS_B"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MTL_SYSTEM_ITEMS_B"."LAST_UPDATE_DATE" <= SYSDATE) OR ("MTL_CATEGORY_SETS_TL"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MTL_CATEGORY_SETS_TL"."LAST_UPDATE_DATE" <= SYSDATE) OR ("MFG_LOOKUPS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MFG_LOOKUPS"."LAST_UPDATE_DATE" <= SYSDATE) OR ("FND_CURRENCIES_TL"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "FND_CURRENCIES_TL"."LAST_UPDATE_DATE" <= SYSDATE) OR ("HR_ORGANIZATION_UNITS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "HR_ORGANIZATION_UNITS"."LAST_UPDATE_DATE" <= SYSDATE) OR ("GL_SETS_OF_BOOKS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "GL_SETS_OF_BOOKS"."LAST_UPDATE_DATE" <= SYSDATE) OR ("MTL_PARAMETERS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MTL_PARAMETERS"."LAST_UPDATE_DATE" <= SYSDATE - 1) OR /*"ORG_ORGANIZATION_DEFINITIONS"."LAST_UPDATE_DATE" >= SYSDATE -15 OR*/ ("MTL_ITEM_FLEXFIELDS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MTL_ITEM_FLEXFIELDS"."LAST_UPDATE_DATE" <= SYSDATE) OR ("CST_COST_TYPES"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "CST_COST_TYPES"."LAST_UPDATE_DATE" <= SYSDATE) OR ("CST_ITEM_COSTS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "CST_ITEM_COSTS"."LAST_UPDATE_DATE" <= SYSDATE) OR ("MTL_ITEM_CATEGORIES"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MTL_ITEM_CATEGORIES"."LAST_UPDATE_DATE" <= SYSDATE) OR ("MTL_CATEGORIES_B"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "MTL_CATEGORIES_B"."LAST_UPDATE_DATE" <= SYSDATE) OR ("FND_FLEX_VALUES_TL"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "FND_FLEX_VALUES_TL"."LAST_UPDATE_DATE" <= SYSDATE) OR ("FND_FLEX_VALUE_SETS"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "FND_FLEX_VALUE_SETS"."LAST_UPDATE_DATE" <= SYSDATE) OR ("FND_FLEX_VALUES"."LAST_UPDATE_DATE" >= SYSDATE - 1 AND "FND_FLEX_VALUES"."LAST_UPDATE_DATE" <= SYSDATE) OR (R.LAST_UPDATE_DATE >= SYSDATE - 1 AND R.LAST_UPDATE_DATE <= SYSDATE))