[Home] [Help]
View: INVFV_ORGANIZATION_ITEMS
View Text
SELECT PA1.ORGANIZATION_CODE
, AL1.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
, 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.SERVICE_DURATION_PERIOD_CODE
, SY.TAX_CODE
, SY.SAFETY_STOCK_BUCKET_DAYS
, SY.RELEASE_TIME_FENCE_DAYS
, SY.MAXIMUM_LOAD_WEIGHT
, SY.MINIMUM_FILL_PERCENT
, SY.INTERNAL_VOLUME
, SY.PURCHASING_TAX_CODE
, '_KF:SQLGL:GL#:CO1'
, '_KF:SQLGL:GL#:CO2'
, '_KF:INV:MSTK:SY1'
, '_KF:INV:MTLL:IT'
, '_KF:SQLGL:GL#:CO3'
, '_KF:SQLGL:GL#:CO4'
, '_KF:INV:MSTK:SY2'
, '_KF:INV:MSTK:SY3'
, '_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: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:ASSEMBLY_PEGGING_CODE: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'
, '_DF:INV:MTL_SYSTEM_ITEMS:SY'
, SY.INVENTORY_ITEM_ID
, SY.SEGMENT1
, 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.ITEM_TYPE
, SY.CONTAINER_TYPE_CODE
, SY.LAST_UPDATE_DATE
, SY.LAST_UPDATED_BY
, SY.CREATION_DATE
, SY.CREATED_BY
FROM FND_COMMON_LOOKUPS COLO2
, FND_COMMON_LOOKUPS COLO1
, CS_COVERAGES_ACTIVE_V COAC
, MTL_SYSTEM_ITEMS SY3
, RA_TERMS TE
, MTL_SYSTEM_ITEMS SY2
, MTL_PICKING_RULES PI
, MTL_ATP_RULES AT
, GL_CODE_COMBINATIONS CO4
, GL_CODE_COMBINATIONS CO3
, MTL_ITEM_LOCATIONS IT
, MTL_SYSTEM_ITEMS SY1
, 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
, MTL_PARAMETERS PA2
, RA_RULES RU2
, RA_RULES RU1
, PER_PEOPLE_X EM
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA1
, MTL_SYSTEM_ITEMS SY
WHERE SY.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND SY.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND SY.BUYER_ID = EM.PERSON_ID(+)
AND SY.ACCOUNTING_RULE_ID = RU1.RULE_ID(+)
AND SY.INVOICING_RULE_ID = RU2.RULE_ID(+)
AND SY.DEFAULT_SHIPPING_ORG = PA2.ORGANIZATION_ID(+)
AND SY.DEFAULT_SHIPPING_ORG = AL2.ORGANIZATION_ID(+)
AND SY.HAZARD_CLASS_ID = HA.HAZARD_CLASS_ID(+)
AND SY.UN_NUMBER_ID = UN.UN_NUMBER_ID(+)
AND SY.ASSET_CATEGORY_ID = CA.CATEGORY_ID(+)
AND SY.RECEIVING_ROUTING_ID = RO.ROUTING_HEADER_ID(+)
AND SY.SOURCE_ORGANIZATION_ID = PA3.ORGANIZATION_ID(+)
AND SY.SOURCE_ORGANIZATION_ID = AL3.ORGANIZATION_ID(+)
AND SY.EXPENSE_ACCOUNT = CO1.CODE_COMBINATION_ID(+)
AND SY.ENCUMBRANCE_ACCOUNT = CO2.CODE_COMBINATION_ID(+)
AND SY.BASE_ITEM_ID = SY1.INVENTORY_ITEM_ID(+)
AND SY.ORGANIZATION_ID = SY1.ORGANIZATION_ID(+)
AND SY.WIP_SUPPLY_LOCATOR_ID = IT.INVENTORY_LOCATION_ID(+)
AND SY.ORGANIZATION_ID = IT.ORGANIZATION_ID(+)
AND SY.COST_OF_SALES_ACCOUNT = CO3.CODE_COMBINATION_ID(+)
AND SY.SALES_ACCOUNT = CO4.CODE_COMBINATION_ID(+)
AND SY.ATP_RULE_ID = AT.RULE_ID(+)
AND SY.PICKING_RULE_ID = PI.PICKING_RULE_ID(+)
AND SY.ENGINEERING_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND SY.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND SY.PAYMENT_TERMS_ID = TE.TERM_ID(+)
AND SY.PRODUCT_FAMILY_ITEM_ID = SY3.INVENTORY_ITEM_ID(+)
AND SY.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+)
AND SY.COVERAGE_SCHEDULE_ID = COAC.COVERAGE_ID(+)
AND SY.ITEM_TYPE = COLO1.LOOKUP_CODE(+)
AND COLO1.LOOKUP_TYPE(+ )= 'ITEM_TYPE'
AND COLO1.APPLICATION_ID(+) = 401
AND SY.CONTAINER_TYPE_CODE = COLO2.LOOKUP_CODE(+)
AND COLO2.LOOKUP_TYPE(+) = 'CONTAINER_TYPE'
AND COLO2.APPLICATION_ID(+) = 401
AND '_SEC:SY.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| ORGANIZATION_CODE |
| ORGANIZATION_NAME |
| "_KF:ITEM:INVENTORY:_CO" |
| DESCRIPTION |
| MARKET_PRICE |
| OVERRECEIPT_TOLERANCE_PERCENT |
| LIST_PRICE |
| PRICE_TOLERANCE_PERCENT |
| ROUNDING_FACTOR |
| UNIT_OF_ISSUE |
| ALLOWED_EARLY_RECEIPT_DAYS |
| ALLOWED_LATE_RECEIPT_DAYS |
| INVOICE_CLOSE_TOLERANCE_PRCNT |
| RECEIPT_CLOSE_TOLERANCE_PRCNT |
| LOT_STARTING_PREFIX |
| LOT_STARTING_NUMBER |
| SHELF_LIFE_DAYS |
| SERIAL_STARTING_NUMBER |
| SERIAL_STARTING_PREFIX |
| SOURCE_SUBINVENTORY |
| UNIT_WEIGHT |
| WEIGHT_UOM_CODE |
| VOLUME_UOM_CODE |
| UNIT_VOLUME |
| SHRINKAGE_RATE |
| ACCEPTABLE_EARLY_DAYS |
| LEAD_TIME_LOT_SIZE |
| STANDARD_LOT_SIZE |
| CUMULATIVE_MFG_LEAD_TIME |
| OVERRUN_PERCENT |
| ACCEPTABLE_RATE_INCREASE |
| ACCEPTABLE_RATE_DECREASE |
| CUMULATIVE_TOTAL_LEAD_TIME |
| PLANNING_TIME_FENCE_DAYS |
| DEMAND_TIME_FENCE_DAYS |
| PLANNING_EXCEPTION_SET |
| FIXED_LEAD_TIME |
| VARIABLE_LEAD_TIME |
| WIP_SUPPLY_SUBINVENTORY |
| PRIMARY_UOM_CODE |
| PRIMARY_UNIT_OF_MEASURE |
| INVENTORY_ITEM_STATUS_CODE |
| PLANNER_CODE |
| FIXED_LOT_MULTIPLIER |
| CARRYING_COST_PERCENT |
| POSTPROCESSING_LEAD_TIME |
| PREPROCESSING_LEAD_TIME |
| PROCESSING_LEAD_TIME |
| ORDER_COST |
| SAFETY_STOCK_PERCENT |
| MINIMUM_MIN_MAX_QUANTITY |
| MAXIMUM_MIN_MAX_QUANTITY |
| MINIMUM_ORDER_QUANTITY |
| FIXED_ORDER_QUANTITY |
| FIXED_SUPPLY_DAYS |
| MAXIMUM_ORDER_QUANTITY |
| POSITIVE_MEASUREMENT_ERROR |
| NEGATIVE_MEASUREMENT_ERROR |
| ENGINEERING_CHANGE_ORDER |
| ENGINEERING_DATE |
| SERVICE_STARTING_DELAY_DAYS |
| SERVICE_DURATION_VALUE |
| SERVICE_DURATION_PERIOD_CODE |
| TAX_CODE |
| SAFETY_STOCK_BUCKET_DAYS |
| RELEASE_TIME_FENCE_DAYS |
| MAXIMUM_LOAD_WEIGHT |
| MINIMUM_FILL_PERCENT |
| INTERNAL_VOLUME |
| PURCHASING_TAX_CODE |
| "_KF:ACCOUNT:EXPENSE:_CO" |
| "_KF:ACCOUNT:ENCUMBRANCE:_CO" |
| "_KF:ITEM:BASE_MODEL:_CO" |
| "_KF:SUPPLY_LOCATOR_NAME:_CO" |
| "_KF:ACCOUNT:COST_OF_SALE:_CO" |
| "_KF:ACCOUNT:SALES:_CO" |
| "_KF:ITEM:ENGINEERING:_CO" |
| "_KF:ITEM:PRODUCT_FAMILY:_CO" |
| "_KF:ASSET_CATEGORY:_CO" |
| BUYER |
| ACCOUNTING_RULE |
| INVOICING_RULE |
| DEFAULT_SHIPPING_ORG_CODE |
| DEFAULT_SHIPPING_ORG_NAME |
| HAZARD_CLASS |
| UNITED_NATIONS_HAZARD_NUMBER |
| RECEIVING_ROUTING |
| SOURCE_ORGANIZATION_CODE |
| SOURCE_ORGANIZATION_NAME |
| ATP_RULE |
| PICKING_RULE |
| PAYMENT_TERMS |
| SERVICE_COVERAGE |
| ITEM_TYPE_NAME |
| CONTAINER_ITEM_TYPE_NAME |
| "_LA:PURCHASED_FLAG" |
| "_LA:SHIPPABLE_FLAG" |
| "_LA:CUSTOMER_ORDERED_FLAG" |
| "_LA:INTERNAL_ORDERED_FLAG" |
| "_LA:SUPPORT_SERVICE_FLAG" |
| "_LA:INVENTORY_ITEM_FLAG" |
| "_LA:ENGINEERING_ITEM_FLAG" |
| "_LA:INV_ASSET_VALUE_FLAG" |
| "_LA:PURCHASABLE_FLAG" |
| "_LA:CUST_ORDERS_ENABLED_FLAG" |
| "_LA:INT_ORDERS_ENABLED_FLAG" |
| "_LA:OE_TRANSACTABLE_FLAG" |
| "_LA:TRANSACTABLE_FLAG" |
| "_LA:STOCKABLE_FLAG" |
| "_LA:BOM_ALLOWED_FLAG" |
| "_LA:BUILD_IN_WIP_FLAG" |
| "_LA:REVISION_CONTROL_TYPE" |
| "_LA:CATALOG_COMPLETE_FLAG" |
| "_LA:RETURNABLE_FLAG" |
| "_LA:COLLATERAL_ITEM_FLAG" |
| "_LA:TAXABLE_FLAG" |
| "_LA:OVERRECEIPT_QTY_ACTION" |
| "_LA:ALLOW_DESC_UPDATE_FLAG" |
| "_LA:INSPECTION_REQUIRED_FLAG" |
| "_LA:RECEIPT_REQUIRED_FLAG" |
| "_LA:RFQ_REQUIRED_FLAG" |
| "_LA:ENFORCE_SHIP_TO_LOCATION" |
| "_LA:SUBSTITUTE_RECEIPTS_FLAG" |
| "_LA:UNORDERED_RECEIPTS_FLAG" |
| "_LA:EXPRESS_TRANSACTION_FLAG" |
| "_LA:RECEIPT_DATE_ACTION" |
| "_LA:LOT_CONTROL" |
| "_LA:SHELF_LIFE_CONTROL" |
| "_LA:SERIAL_GENERATION_TYPE" |
| "_LA:SOURCE_TYPE" |
| "_LA:RESTRICT_SUBINV_FLAG" |
| "_LA:RESTRICT_LOCATORS_FLAG" |
| "_LA:LOCATION_CONTROL" |
| "_LA:PLANNING_ITEM_FENCE_TYPE" |
| "_LA:DEMAND_TIME_FENCE_TYPE" |
| "_LA:CALCULATE_ATP_FLAG" |
| "_LA:PEGGING_TYPE" |
| "_LA:REPETITIVE_PLANNING_FLAG" |
| "_LA:BOM_ITEM_TYPE" |
| "_LA:PICK_COMPONENTS_FLAG" |
| "_LA:ASSEMBLE_TO_ORDER_FLAG" |
| "_LA:ATP_COMPONENTS_FLAG" |
| "_LA:CHECK_ATP_FLAG" |
| "_LA:SUPPLY_TYPE" |
| "_LA:UOM_CONVERSION_OPTION" |
| "_LA:INCLUDE_IN_ROLLUP_FLAG" |
| "_LA:INV_PLANNING_METHOD" |
| "_LA:MAKE_OR_BUY_FLAG" |
| "_LA:ROUND_ORDER_QTY_FLAG" |
| "_LA:SAFETY_STOCK_METHOD" |
| "_LA:RESERVABLE_FLAG" |
| "_LA:SERVICE_WARRANTY_FLAG" |
| "_LA:SERVICEABLE_PRODUCT_FLAG" |
| "_LA:BILLING_TYPE" |
| "_LA:INVOICEABLE_ITEM_FLAG" |
| "_LA:INVOICE_ENABLED_FLAG" |
| "_LA:APPROVED_SUPPLIER_FLAG" |
| "_LA:OUTSIDE_PROCESSING_FLAG" |
| "_LA:OUTSIDE_PROCESSING_UNIT" |
| "_LA:REDUCE_MPS_EVENT" |
| "_LA:COSTING_ENABLED_FLAG" |
| "_LA:CYCLE_COUNT_ENABLED_FLAG" |
| "_LA:SHIP_MODEL_COMPLETE_FLAG" |
| "_LA:PLANNING_METHOD" |
| "_LA:RMA_INSPECTION_REQD_FLAG" |
| "_LA:FORECAST_CONTROL_TYPE" |
| "_LA:RELEASE_TIME_FENCE_TYPE" |
| "_LA:CONTAINER_FLAG" |
| "_LA:VEHICLE_FLAG" |
| "_DF" |
| INVENTORY_ITEM_ID |
| INVENTORY_ITEM_SEGMENT1 |
| ORGANIZATION_ID |
| BUYER_ID |
| ACCOUNTING_RULE_ID |
| INVOICING_RULE_ID |
| ITEM_CATALOG_GROUP_ID |
| DEFAULT_SHIPPING_ORG |
| HAZARD_CLASS_ID |
| UN_NUMBER_ID |
| ASSET_CATEGORY_ID |
| RECEIVING_ROUTING_ID |
| SOURCE_ORGANIZATION_ID |
| EXPENSE_ACCOUNT_ID |
| ENCUMBRANCE_ACCOUNT_ID |
| BASE_ITEM_ID |
| WIP_SUPPLY_LOCATOR_ID |
| COST_OF_SALES_ACCOUNT_ID |
| SALES_ACCOUNT_ID |
| ATP_RULE_ID |
| PICKING_RULE_ID |
| ENGINEERING_ITEM_ID |
| PAYMENT_TERMS_ID |
| COVERAGE_SCHEDULE_ID |
| PRODUCT_FAMILY_ITEM_ID |
| ITEM_TYPE |
| CONTAINER_TYPE_CODE |
| LAST_UPDATED_DATE |
| LAST_UPDATED_BY |
| CREATED_DATE |
| CREATED_BY |
| Name |
APPS.INVFV_ORGANIZATION_ITEMS