View: INVFV_ITEMS

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INVFV_ITEMS

View Text

SELECT PA1.ORGANIZATION_CODE
, AL1.NAME
, '_KF:INV:MSTK:SY1'
, SY1.DESCRIPTION
, SY1.MARKET_PRICE
, SY1.QTY_RCV_TOLERANCE
, SY1.LIST_PRICE_PER_UNIT
, SY1.PRICE_TOLERANCE_PERCENT
, SY1.ROUNDING_FACTOR
, SY1.UNIT_OF_ISSUE
, SY1.DAYS_EARLY_RECEIPT_ALLOWED
, SY1.DAYS_LATE_RECEIPT_ALLOWED
, SY1.INVOICE_CLOSE_TOLERANCE
, SY1.RECEIVE_CLOSE_TOLERANCE
, SY1.AUTO_LOT_ALPHA_PREFIX
, SY1.START_AUTO_LOT_NUMBER
, SY1.SHELF_LIFE_DAYS
, SY1.START_AUTO_SERIAL_NUMBER
, SY1.AUTO_SERIAL_ALPHA_PREFIX
, SY1.SOURCE_SUBINVENTORY
, SY1.UNIT_WEIGHT
, SY1.WEIGHT_UOM_CODE
, SY1.VOLUME_UOM_CODE
, SY1.UNIT_VOLUME
, SY1.SHRINKAGE_RATE
, SY1.ACCEPTABLE_EARLY_DAYS
, SY1.LEAD_TIME_LOT_SIZE
, SY1.STD_LOT_SIZE
, SY1.CUM_MANUFACTURING_LEAD_TIME
, SY1.OVERRUN_PERCENTAGE
, SY1.ACCEPTABLE_RATE_INCREASE
, SY1.ACCEPTABLE_RATE_DECREASE
, SY1.CUMULATIVE_TOTAL_LEAD_TIME
, SY1.PLANNING_TIME_FENCE_DAYS
, SY1.DEMAND_TIME_FENCE_DAYS
, SY1.PLANNING_EXCEPTION_SET
, SY1.FIXED_LEAD_TIME
, SY1.VARIABLE_LEAD_TIME
, SY1.WIP_SUPPLY_SUBINVENTORY
, SY1.PRIMARY_UOM_CODE
, SY1.PRIMARY_UNIT_OF_MEASURE
, SY1.INVENTORY_ITEM_STATUS_CODE
, SY1.PLANNER_CODE
, SY1.FIXED_LOT_MULTIPLIER
, SY1.CARRYING_COST
, SY1.POSTPROCESSING_LEAD_TIME
, SY1.PREPROCESSING_LEAD_TIME
, SY1.FULL_LEAD_TIME
, SY1.ORDER_COST
, SY1.MRP_SAFETY_STOCK_PERCENT
, SY1.MIN_MINMAX_QUANTITY
, SY1.MAX_MINMAX_QUANTITY
, SY1.MINIMUM_ORDER_QUANTITY
, SY1.FIXED_ORDER_QUANTITY
, SY1.FIXED_DAYS_SUPPLY
, SY1.MAXIMUM_ORDER_QUANTITY
, SY1.POSITIVE_MEASUREMENT_ERROR
, SY1.NEGATIVE_MEASUREMENT_ERROR
, SY1.ENGINEERING_ECN_CODE
, SY1.ENGINEERING_DATE
, SY1.SERVICE_STARTING_DELAY
, SY1.SERVICE_DURATION
, SY1.SERVICE_DURATION_PERIOD_CODE
, SY1.TAX_CODE
, SY1.SAFETY_STOCK_BUCKET_DAYS
, SY1.RELEASE_TIME_FENCE_DAYS
, SY1.MAXIMUM_LOAD_WEIGHT
, SY1.MINIMUM_FILL_PERCENT
, SY1.INTERNAL_VOLUME
, SY1.PURCHASING_TAX_CODE
, '_KF:INV:MICG:IT'
, '_KF:SQLGL:GL#:CO1'
, '_KF:SQLGL:GL#:CO2'
, '_KF:INV:MSTK:SY2'
, '_KF:INV:MTLL:ITLO'
, '_KF:SQLGL:GL#:CO3'
, '_KF:SQLGL:GL#:CO4'
, '_KF:INV:MSTK:SY3'
, '_KF:INV:MSTK:SY4'
, '_KF:OFA:CAT#:CA'
, EM.FULL_NAME
, RU1.NAME
, RU2.NAME
, PA2.ORGANIZATION_CODE
, AL2.NAME
, HA.HAZARD_CLASS
, UN.UN_NUMBER
, RO.ROUTING_NAME
, PA3.ORGANIZATION_CODE
, AL3.NAME
, AT.RULE_NAME
, PI.PICKING_RULE_NAME
, TE.NAME
, COAC.NAME
, COLO1.MEANING
, COLO2.MEANING
, '_LA:SY1.PURCHASING_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.SHIPPABLE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.CUSTOMER_ORDER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INTERNAL_ORDER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.SERVICE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INVENTORY_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.ENG_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INVENTORY_ASSET_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.PURCHASING_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.CUSTOMER_ORDER_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INTERNAL_ORDER_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.SO_TRANSACTIONS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.MTL_TRANSACTIONS_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.STOCK_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.BOM_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.BUILD_IN_WIP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.REVISION_QTY_CONTROL_CODE:MFG_LOOKUPS:MTL_ENG_QUANTITY:MEANING'
, '_LA:SY1.CATALOG_STATUS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.RETURNABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.COLLATERAL_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA: SY1.TAXABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DESCRIPTION'
, '_LA: SY1.ALLOW_ITEM_DESC_UPDATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INSPECTION_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.RECEIPT_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.RFQ_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.ENFORCE_SHIP_TO_LOCATION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DESCRIPTION'
, '_LA:SY1.ALLOW_SUBSTITUTE_RECEIPTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.ALLOW_UNORDERED_RECEIPTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.ALLOW_EXPRESS_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.RECEIPT_DAYS_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DESCRIPTION'
, '_LA: SY1.LOT_CONTROL_CODE:MFG_LOOKUPS:MTL_LOT_CONTROL:MEANING'
, '_LA:SY1.SHELF_LIFE_CODE:MFG_LOOKUPS:MTL_SHELF_LIFE:MEANING'
, '_LA:SY1.SERIAL_NUMBER_CONTROL_CODE:MFG_LOOKUPS:MTL_SERIAL_NUMBER:MEANING'
, '_LA:SY1.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING'
, '_LA:SY1.RESTRICT_SUBINVENTORIES_CODE:MFG_LOOKUPS:MTL_SUBINVENTORY_RESTRICTIONS:MEANING'
, '_LA:SY1.RESTRICT_LOCATORS_CODE:MFG_LOOKUPS:MTL_LOCATOR_RESTRICTIONS:MEANING'
, '_LA:SY1.LOCATION_CONTROL_CODE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING'
, '_LA:SY1.PLANNING_TIME_FENCE_CODE:MFG_LOOKUPS:MTL_TIME_FENCE:MEANING'
, '_LA: SY1.DEMAND_TIME_FENCE_CODE:MFG_LOOKUPS:MTL_TIME_FENCE:MEANING'
, '_LA:SY1.MRP_CALCULATE_ATP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.END_ASSEMBLY_PEGGING_FLAG:FND_LOOKUPS:ASSEMBLY_PEGGING_CODE:MEANING'
, '_LA:SY1.REPETITIVE_PLANNING_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING'
, '_LA:SY1.PICK_COMPONENTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.REPLENISH_TO_ORDER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.ATP_COMPONENTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.ATP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, '_LA:SY1.ALLOWED_UNITS_LOOKUP_CODE:MFG_LOOKUPS:MTL_CONVERSION_TYPE:MEANING'
, '_LA:SY1.DEFAULT_INCLUDE_IN_ROLLUP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INVENTORY_PLANNING_CODE:MFG_LOOKUPS:MTL_MATERIAL_PLANNING:MEANING'
, '_LA:SY1.PLANNING_MAKE_BUY_CODE:MFG_LOOKUPS:MTL_PLANNING_MAKE_BUY:MEANING'
, '_LA:SY1.ROUNDING_CONTROL_TYPE:MFG_LOOKUPS:MTL_ROUNDING:MEANING'
, '_LA:SY1.MRP_SAFETY_STOCK_CODE:MFG_LOOKUPS:MTL_SAFETY_STOCK_TYPE:MEANING'
, '_LA:SY1.RESERVABLE_TYPE:MFG_LOOKUPS:MTL_RESERVATION_CONTROL:MEANING'
, '_LA:SY1.VENDOR_WARRANTY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.SERVICEABLE_PRODUCT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.MATERIAL_BILLABLE_FLAG:CS_LOOKUPS:MTL_SERVICE_BILLABLE_FLAG:MEANING'
, '_LA:SY1.INVOICEABLE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.INVOICE_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.MUST_USE_APPROVED_VENDOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.OUTSIDE_OPERATION_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.OUTSIDE_OPERATION_UOM_TYPE:PO_LOOKUP_CODES:OUTSIDE OPERATION UOM TYPE:DESCRIPTION'
, '_LA:SY1.AUTO_REDUCE_MPS:MFG_LOOKUPS:MRP_AUTO_REDUCE_MPS:MEANING'
, '_LA:SY1.COSTING_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.CYCLE_COUNT_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.SHIP_MODEL_COMPLETE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.MRP_PLANNING_CODE:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING'
, '_LA:SY1.RETURN_INSPECTION_REQUIREMENT:MFG_LOOKUPS:MTL_RETURN_INSPECTION:MEANING'
, '_LA:SY1.ATO_FORECAST_CONTROL:MFG_LOOKUPS:MRP_ATO_FORECAST_CONTROL:MEANING'
, '_LA:SY1.RELEASE_TIME_FENCE_CODE:MFG_LOOKUPS:MTL_RELEASE_TIME_FENCE:MEANING'
, '_LA:SY1.CONTAINER_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY1.VEHICLE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:INV:MTL_SYSTEM_ITEMS:SY1'
, SY1.INVENTORY_ITEM_ID
, SY1.ORGANIZATION_ID
, SY1.BUYER_ID
, SY1.ACCOUNTING_RULE_ID
, SY1.INVOICING_RULE_ID
, SY1.ITEM_CATALOG_GROUP_ID
, SY1.DEFAULT_SHIPPING_ORG
, SY1.HAZARD_CLASS_ID
, SY1.UN_NUMBER_ID
, SY1.ASSET_CATEGORY_ID
, SY1.RECEIVING_ROUTING_ID
, SY1.SOURCE_ORGANIZATION_ID
, SY1.EXPENSE_ACCOUNT
, SY1.ENCUMBRANCE_ACCOUNT
, SY1.BASE_ITEM_ID
, SY1.WIP_SUPPLY_LOCATOR_ID
, SY1.COST_OF_SALES_ACCOUNT
, SY1.SALES_ACCOUNT
, SY1.ATP_RULE_ID
, SY1.PICKING_RULE_ID
, SY1.ENGINEERING_ITEM_ID
, SY1.PAYMENT_TERMS_ID
, SY1.COVERAGE_SCHEDULE_ID
, SY1.PRODUCT_FAMILY_ITEM_ID
, SY1.ITEM_TYPE
, SY1.CONTAINER_TYPE_CODE
, SY1.LAST_UPDATE_DATE
, SY1.LAST_UPDATED_BY
, SY1.CREATION_DATE
, SY1.CREATED_BY
FROM FND_COMMON_LOOKUPS COLO2
, FND_COMMON_LOOKUPS COLO1
, CS_COVERAGES_ACTIVE_V COAC
, MTL_SYSTEM_ITEMS SY4
, RA_TERMS TE
, MTL_SYSTEM_ITEMS SY3
, MTL_PICKING_RULES PI
, MTL_ATP_RULES AT
, GL_CODE_COMBINATIONS CO3
, GL_CODE_COMBINATIONS CO4
, MTL_ITEM_LOCATIONS ITLO
, MTL_SYSTEM_ITEMS SY2
, GL_CODE_COMBINATIONS CO2
, GL_CODE_COMBINATIONS CO1
, HR_ALL_ORGANIZATION_UNITS AL3
, MTL_PARAMETERS PA3
, RCV_ROUTING_HEADERS RO
, FA_CATEGORIES CA
, PO_UN_NUMBERS UN
, PO_HAZARD_CLASSES HA
, HR_ALL_ORGANIZATION_UNITS AL2
, PER_PEOPLE_X EM
, MTL_PARAMETERS PA2
, MTL_ITEM_CATALOG_GROUPS IT
, RA_RULES RU2
, RA_RULES RU1
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA1
, MTL_SYSTEM_ITEMS SY1
WHERE SY1.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND SY1.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND SY1.BUYER_ID = EM.PERSON_ID(+)
AND SY1.ACCOUNTING_RULE_ID = RU1.RULE_ID(+)
AND SY1.INVOICING_RULE_ID = RU2.RULE_ID(+)
AND SY1.ITEM_CATALOG_GROUP_ID = IT.ITEM_CATALOG_GROUP_ID(+)
AND SY1.DEFAULT_SHIPPING_ORG = PA2.ORGANIZATION_ID(+)
AND SY1.DEFAULT_SHIPPING_ORG = AL2.ORGANIZATION_ID(+)
AND SY1.HAZARD_CLASS_ID = HA.HAZARD_CLASS_ID(+)
AND SY1.UN_NUMBER_ID = UN.UN_NUMBER_ID(+)
AND SY1.ASSET_CATEGORY_ID = CA.CATEGORY_ID(+)
AND SY1.RECEIVING_ROUTING_ID = RO.ROUTING_HEADER_ID(+)
AND SY1.SOURCE_ORGANIZATION_ID = PA3.ORGANIZATION_ID(+)
AND SY1.SOURCE_ORGANIZATION_ID = AL3.ORGANIZATION_ID(+)
AND SY1.EXPENSE_ACCOUNT = CO1.CODE_COMBINATION_ID(+)
AND SY1.ENCUMBRANCE_ACCOUNT = CO2.CODE_COMBINATION_ID(+)
AND SY1.BASE_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND SY1.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND SY1.WIP_SUPPLY_LOCATOR_ID = ITLO.INVENTORY_LOCATION_ID(+)
AND SY1 .ORGANIZATION_ID = ITLO.ORGANIZATION_ID(+)
AND SY1.COST_OF_SALES_ACCOUNT = CO3.CODE_COMBINATION_ID(+)
AND SY1.SALES_ACCOUNT = CO4.CODE_COMBINATION_ID(+)
AND SY1.ATP_RULE_ID = AT.RULE_ID(+)
AND SY1.PICKING_RULE_ID = PI.PICKING_RULE_ID(+)
AND SY1.ENGINEERING_ITEM_ID = SY3.INVENTORY_ITEM_ID(+)
AND SY1.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+)
AND SY1.PAYMENT_TERMS_ID = TE.TERM_ID(+)
AND SY1.PRODUCT_FAMILY_ITEM_ID = SY4.INVENTORY_ITEM_ID(+)
AND SY1.ORGANIZATION_ID = SY4.ORGANIZATION_ID(+)
AND SY1.COVERAGE_SCHEDULE_ID = COAC.COVERAGE_ID(+)
AND SY1.ITEM_TYPE = COLO1.LOOKUP_CODE(+)
AND COLO1.LOOKUP_TYPE(+) = 'ITEM_TYPE'
AND COLO1.APPLICATION_ID(+) = 401
AND SY1.CONTAINER_TYPE_CODE = COLO2.LOOKUP_CODE(+)
AND COLO2.LOOKUP_TYPE(+) = 'CONTAINER_TYPE'
AND COLO2.APPLICATION_ID(+) = 401
AND '_SEC:SY1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns