APPS.INVBV_ORGANIZATION_ITEMS
[Home] [Help]
| Product: | INV - Inventory |
|---|---|
| Description: | - Retrofitted |
| Implementation/DBA Data: |
APPS.INVBV_ORGANIZATION_ITEMS
|
SELECT PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY'
, SY.DESCRIPTION
, SY.MARKET_PRICE
, SY.QTY_RCV_TOLERANCE
, SY.LIST_PRICE_PER_UNIT
, SY.PRICE_TOLERANCE_PERCENT
, SY.ROUNDING_FACTOR
, SY.UNIT_OF_ISSUE
, SY.DAYS_EARLY_RECEIPT_ALLOWED
, SY.DAYS_LATE_RECEIPT_ALLOWED
, SY.INVOICE_CLOSE_TOLERANCE
, SY.RECEIVE_CLOSE_TOLERANCE
, SY.AUTO_LOT_ALPHA_PREFIX
, SY.START_AUTO_LOT_NUMBER
, SY.SHELF_LIFE_DAYS
, SY.START_AUTO_SERIAL_NUMBER
, SY.AUTO_SERIAL_ALPHA_PREFIX
, SY.SOURCE_SUBINVENTORY
, SY.UNIT_WEIGHT
, SY.WEIGHT_UOM_CODE
, SY.VOLUME_UOM_CODE
, SY.UNIT_VOLUME
, SY.SHRINKAGE_RATE
, SY.ACCEPTABLE_EARLY_DAYS
, SY.LEAD_TIME_LOT_SIZE
, SY.STD_LOT_SIZE STANDARD_LOT_SIZE
, SY.CUM_MANUFACTURING_LEAD_TIME
, SY.OVERRUN_PERCENTAGE
, SY.ACCEPTABLE_RATE_INCREASE
, SY.ACCEPTABLE_RATE_DECREASE
, SY.CUMULATIVE_TOTAL_LEAD_TIME
, SY.PLANNING_TIME_FENCE_DAYS
, SY.DEMAND_TIME_FENCE_DAYS
, SY.PLANNING_EXCEPTION_SET
, SY.FIXED_LEAD_TIME
, SY.VARIABLE_LEAD_TIME
, SY.WIP_SUPPLY_SUBINVENTORY
, SY.PRIMARY_UOM_CODE
, SY.PRIMARY_UNIT_OF_MEASURE
, SY.INVENTORY_ITEM_STATUS_CODE
, SY.PLANNER_CODE
, SY.FIXED_LOT_MULTIPLIER
, SY.CARRYING_COST
, SY.POSTPROCESSING_LEAD_TIME
, SY.PREPROCESSING_LEAD_TIME
, SY.FULL_LEAD_TIME
, SY.ORDER_COST
, SY.MRP_SAFETY_STOCK_PERCENT
, SY.MIN_MINMAX_QUANTITY
, SY.MAX_MINMAX_QUANTITY
, SY.MINIMUM_ORDER_QUANTITY
, SY.FIXED_ORDER_QUANTITY
, SY.FIXED_DAYS_SUPPLY
, SY.MAXIMUM_ORDER_QUANTITY
, SY.POSITIVE_MEASUREMENT_ERROR
, SY.NEGATIVE_MEASUREMENT_ERROR
, SY.ENGINEERING_ECN_CODE
, SY.ENGINEERING_DATE
, SY.SERVICE_STARTING_DELAY
, SY.SERVICE_DURATION
, SY.TAX_CODE
, SY.SAFETY_STOCK_BUCKET_DAYS
, SY.RELEASE_TIME_FENCE_DAYS
, SY.MAXIMUM_LOAD_WEIGHT
, SY.MINIMUM_FILL_PERCENT
, SY.INTERNAL_VOLUME
, '_LA:SY.PURCHASING_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.SHIPPABLE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.CUSTOMER_ORDER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INTERNAL_ORDER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.SERVICE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INVENTORY_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.ENG_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INVENTORY_ASSET_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.PURCHASING_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.CUSTOMER_ORDER_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INTERNAL_ORDER_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.SO_TRANSACTIONS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.MTL_TRANSACTIONS_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.STOCK_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.BOM_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.BUILD_IN_WIP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.REVISION_QTY_CONTROL_CODE:MFG_LOOKUPS:MTL_ENG_QUANTITY:MEANING'
, '_LA:SY.CATALOG_STATUS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.RETURNABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.COLLATERAL_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA: SY.TAXABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.QTY_RCV_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DESCRIPTION'
, '_LA: SY.ALLOW_ITEM_DESC_UPDATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INSPECTION_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.RECEIPT_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.RFQ_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.ENFORCE_SHIP_TO_LOCATION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DESCRIPTION'
, '_LA:SY.ALLOW_SUBSTITUTE_RECEIPTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.ALLOW_UNORDERED_RECEIPTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.ALLOW_EXPRESS_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.RECEIPT_DAYS_EXCEPTION_CODE:PO_LOOKUP_CODES:RECEIVING CONTROL LEVEL:DESCRIPTION'
, '_LA: SY.LOT_CONTROL_CODE:MFG_LOOKUPS:MTL_LOT_CONTROL:MEANING'
, '_LA:SY.SHELF_LIFE_CODE:MFG_LOOKUPS:MTL_SHELF_LIFE:MEANING'
, '_LA:SY.SERIAL_NUMBER_CONTROL_CODE:MFG_LOOKUPS:MTL_SERIAL_NUMBER:MEANING'
, '_LA:SY.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING'
, '_LA:SY.RESTRICT_SUBINVENTORIES_CODE:MFG_LOOKUPS:MTL_SUBINVENTORY_RESTRICTIONS:MEANING'
, '_LA:SY.RESTRICT_LOCATORS_CODE:MFG_LOOKUPS:MTL_LOCATOR_RESTRICTIONS:MEANING'
, '_LA:SY.LOCATION_CONTROL_CODE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING'
, '_LA:SY.PLANNING_TIME_FENCE_CODE:MFG_LOOKUPS:MTL_TIME_FENCE:MEANING'
, '_LA: SY.DEMAND_TIME_FENCE_CODE:MFG_LOOKUPS:MTL_TIME_FENCE:MEANING'
, '_LA:SY.MRP_CALCULATE_ATP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.END_ASSEMBLY_PEGGING_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.REPETITIVE_PLANNING_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING'
, '_LA:SY.PICK_COMPONENTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.REPLENISH_TO_ORDER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.ATP_COMPONENTS_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.ATP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, '_LA:SY.ALLOWED_UNITS_LOOKUP_CODE:MFG_LOOKUPS:MTL_CONVERSION_TYPE:MEANING'
, '_LA:SY.DEFAULT_INCLUDE_IN_ROLLUP_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INVENTORY_PLANNING_CODE:MFG_LOOKUPS:MTL_MATERIAL_PLANNING:MEANING'
, '_LA:SY.PLANNING_MAKE_BUY_CODE:MFG_LOOKUPS:MTL_PLANNING_MAKE_BUY:MEANING'
, '_LA:SY.ROUNDING_CONTROL_TYPE:MFG_LOOKUPS:MTL_ROUNDING:MEANING'
, '_LA:SY.MRP_SAFETY_STOCK_CODE:MFG_LOOKUPS:MTL_SAFETY_STOCK_TYPE:MEANING'
, '_LA:SY.RESERVABLE_TYPE:MFG_LOOKUPS:MTL_RESERVATION_CONTROL:MEANING'
, '_LA:SY.VENDOR_WARRANTY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.SERVICEABLE_PRODUCT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.MATERIAL_BILLABLE_FLAG:CS_LOOKUPS:MTL_SERVICE_BILLABLE_FLAG:MEANING'
, '_LA:SY.INVOICEABLE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.INVOICE_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.MUST_USE_APPROVED_VENDOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.OUTSIDE_OPERATION_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.OUTSIDE_OPERATION_UOM_TYPE:PO_LOOKUP_CODES:OUTSIDE OPERATION UOM TYPE:DESCRIPTION'
, '_LA:SY.AUTO_REDUCE_MPS:MFG_LOOKUPS:MRP_AUTO_REDUCE_MPS:MEANING'
, '_LA:SY.COSTING_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.CYCLE_COUNT_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.SHIP_MODEL_COMPLETE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.MRP_PLANNING_CODE:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING'
, '_LA:SY.RETURN_INSPECTION_REQUIREMENT:MFG_LOOKUPS:MTL_RETURN_INSPECTION:MEANING'
, '_LA:SY.ATO_FORECAST_CONTROL:MFG_LOOKUPS:MRP_ATO_FORECAST_CONTROL:MEANING'
, '_LA:SY.RELEASE_TIME_FENCE_CODE:MFG_LOOKUPS:MTL_RELEASE_TIME_FENCE:MEANING'
, '_LA:SY.CONTAINER_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:SY.VEHICLE_ITEM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, SY.CONTAINER_TYPE_CODE
, SY.ITEM_TYPE
, SY.INVENTORY_ITEM_ID
, SY.ORGANIZATION_ID
, SY.BUYER_ID
, SY.ACCOUNTING_RULE_ID
, SY.INVOICING_RULE_ID
, SY.ITEM_CATALOG_GROUP_ID
, SY.DEFAULT_SHIPPING_ORG
, SY.HAZARD_CLASS_ID
, SY.UN_NUMBER_ID
, SY.ASSET_CATEGORY_ID
, SY.RECEIVING_ROUTING_ID
, SY.SOURCE_ORGANIZATION_ID
, SY.EXPENSE_ACCOUNT
, SY.ENCUMBRANCE_ACCOUNT
, SY.BASE_ITEM_ID
, SY.WIP_SUPPLY_LOCATOR_ID
, SY.COST_OF_SALES_ACCOUNT
, SY.SALES_ACCOUNT
, SY.ATP_RULE_ID
, SY.PICKING_RULE_ID
, SY.ENGINEERING_ITEM_ID
, SY.PAYMENT_TERMS_ID
, SY.COVERAGE_SCHEDULE_ID
, SY.PRODUCT_FAMILY_ITEM_ID
, SY.LAST_UPDATE_DATE
, SY.LAST_UPDATED_BY
, SY.CREATION_DATE
, SY.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
WHERE SY.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SY.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:SY.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY