APPS.EGO_ITEM_SYNC_V
[Home] [Help]
| Product: | EGO - Advanced Product Catalog |
|---|---|
| Description: | This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel |
| Implementation/DBA Data: |
APPS.EGO_ITEM_SYNC_V
|
SELECT B.ROW_ID AS ROW_ID
, B.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID
, B.ORGANIZATION_ID AS ORGANIZATION_ID
, B.PRIMARY_UOM_CODE AS PRIMARY_UOM_CODE
, B.PRIMARY_UNIT_OF_MEASURE AS PRIMARY_UNIT_OF_MEASURE
, B.ITEM_TYPE AS ITEM_TYPE
, B.INVENTORY_ITEM_STATUS_CODE AS INVENTORY_ITEM_STATUS_CODE
, B.ALLOWED_UNITS_LOOKUP_CODE AS ALLOWED_UNITS_LOOKUP_CODE
, B.ITEM_CATALOG_GROUP_ID AS ITEM_CATALOG_GROUP_ID
, B.CATALOG_STATUS_FLAG AS CATALOG_STATUS_FLAG
, B.INVENTORY_ITEM_FLAG AS INVENTORY_ITEM_FLAG
, B.STOCK_ENABLED_FLAG AS STOCK_ENABLED_FLAG
, B.MTL_TRANSACTIONS_ENABLED_FLAG AS MTL_TRANSACTIONS_ENABLED_FLAG
, B.CHECK_SHORTAGES_FLAG AS CHECK_SHORTAGES_FLAG
, B.REVISION_QTY_CONTROL_CODE AS REVISION_QTY_CONTROL_CODE
, B.RESERVABLE_TYPE AS RESERVABLE_TYPE
, B.SHELF_LIFE_CODE AS SHELF_LIFE_CODE
, B.SHELF_LIFE_DAYS AS SHELF_LIFE_DAYS
, B.CYCLE_COUNT_ENABLED_FLAG AS CYCLE_COUNT_ENABLED_FLAG
, B.NEGATIVE_MEASUREMENT_ERROR AS NEGATIVE_MEASUREMENT_ERROR
, B.POSITIVE_MEASUREMENT_ERROR AS POSITIVE_MEASUREMENT_ERROR
, B.LOT_CONTROL_CODE AS LOT_CONTROL_CODE
, B.AUTO_LOT_ALPHA_PREFIX AS AUTO_LOT_ALPHA_PREFIX
, B.START_AUTO_LOT_NUMBER AS START_AUTO_LOT_NUMBER
, B.SERIAL_NUMBER_CONTROL_CODE AS SERIAL_NUMBER_CONTROL_CODE
, B.AUTO_SERIAL_ALPHA_PREFIX AS AUTO_SERIAL_ALPHA_PREFIX
, B.START_AUTO_SERIAL_NUMBER AS START_AUTO_SERIAL_NUMBER
, B.LOCATION_CONTROL_CODE AS LOCATION_CONTROL_CODE
, B.RESTRICT_SUBINVENTORIES_CODE AS RESTRICT_SUBINVENTORIES_CODE
, B.RESTRICT_LOCATORS_CODE AS RESTRICT_LOCATORS_CODE
, B.BOM_ENABLED_FLAG AS BOM_ENABLED_FLAG
, B.BOM_ITEM_TYPE AS BOM_ITEM_TYPE
, B.BASE_ITEM_ID AS BASE_ITEM_ID
, B.EFFECTIVITY_CONTROL AS EFFECTIVITY_CONTROL
, B.ENG_ITEM_FLAG AS ENG_ITEM_FLAG
, B.ENGINEERING_ECN_CODE AS ENGINEERING_ECN_CODE
, B.ENGINEERING_ITEM_ID AS ENGINEERING_ITEM_ID
, B.ENGINEERING_DATE AS ENGINEERING_DATE
, B.PRODUCT_FAMILY_ITEM_ID AS PRODUCT_FAMILY_ITEM_ID
, B.AUTO_CREATED_CONFIG_FLAG AS AUTO_CREATED_CONFIG_FLAG
, B.MODEL_CONFIG_CLAUSE_NAME AS MODEL_CONFIG_CLAUSE_NAME
, B.NEW_REVISION_CODE AS NEW_REVISION_CODE
, B.COSTING_ENABLED_FLAG AS COSTING_ENABLED_FLAG
, B.INVENTORY_ASSET_FLAG AS INVENTORY_ASSET_FLAG
, B.DEFAULT_INCLUDE_IN_ROLLUP_FLAG AS DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, B.COST_OF_SALES_ACCOUNT AS COST_OF_SALES_ACCOUNT
, B.STD_LOT_SIZE AS STD_LOT_SIZE
, B.PURCHASING_ITEM_FLAG AS PURCHASING_ITEM_FLAG
, B.PURCHASING_ENABLED_FLAG AS PURCHASING_ENABLED_FLAG
, B.MUST_USE_APPROVED_VENDOR_FLAG AS MUST_USE_APPROVED_VENDOR_FLAG
, B.ALLOW_ITEM_DESC_UPDATE_FLAG AS ALLOW_ITEM_DESC_UPDATE_FLAG
, B.RFQ_REQUIRED_FLAG AS RFQ_REQUIRED_FLAG
, B.OUTSIDE_OPERATION_FLAG AS OUTSIDE_OPERATION_FLAG
, B.OUTSIDE_OPERATION_UOM_TYPE AS OUTSIDE_OPERATION_UOM_TYPE
, B.TAXABLE_FLAG AS TAXABLE_FLAG
, B.PURCHASING_TAX_CODE AS PURCHASING_TAX_CODE
, B.RECEIPT_REQUIRED_FLAG AS RECEIPT_REQUIRED_FLAG
, B.INSPECTION_REQUIRED_FLAG AS INSPECTION_REQUIRED_FLAG
, B.BUYER_ID AS BUYER_ID
, B.UNIT_OF_ISSUE AS UNIT_OF_ISSUE
, B.RECEIVE_CLOSE_TOLERANCE AS RECEIVE_CLOSE_TOLERANCE
, B.INVOICE_CLOSE_TOLERANCE AS INVOICE_CLOSE_TOLERANCE
, B.UN_NUMBER_ID AS UN_NUMBER_ID
, B.HAZARD_CLASS_ID AS HAZARD_CLASS_ID
, B.LIST_PRICE_PER_UNIT AS LIST_PRICE_PER_UNIT
, B.MARKET_PRICE AS MARKET_PRICE
, B.PRICE_TOLERANCE_PERCENT AS PRICE_TOLERANCE_PERCENT
, B.ROUNDING_FACTOR AS ROUNDING_FACTOR
, B.ENCUMBRANCE_ACCOUNT AS ENCUMBRANCE_ACCOUNT
, B.EXPENSE_ACCOUNT AS EXPENSE_ACCOUNT
, B.ASSET_CATEGORY_ID AS ASSET_CATEGORY_ID
, B.RECEIPT_DAYS_EXCEPTION_CODE AS RECEIPT_DAYS_EXCEPTION_CODE
, B.DAYS_EARLY_RECEIPT_ALLOWED AS DAYS_EARLY_RECEIPT_ALLOWED
, B.DAYS_LATE_RECEIPT_ALLOWED AS DAYS_LATE_RECEIPT_ALLOWED
, B.ALLOW_SUBSTITUTE_RECEIPTS_FLAG AS ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, B.ALLOW_UNORDERED_RECEIPTS_FLAG AS ALLOW_UNORDERED_RECEIPTS_FLAG
, B.ALLOW_EXPRESS_DELIVERY_FLAG AS ALLOW_EXPRESS_DELIVERY_FLAG
, B.QTY_RCV_EXCEPTION_CODE AS QTY_RCV_EXCEPTION_CODE
, B.QTY_RCV_TOLERANCE AS QTY_RCV_TOLERANCE
, B.RECEIVING_ROUTING_ID AS RECEIVING_ROUTING_ID
, B.ENFORCE_SHIP_TO_LOCATION_CODE AS ENFORCE_SHIP_TO_LOCATION_CODE
, B.WEIGHT_UOM_CODE AS WEIGHT_UOM_CODE
, B.UNIT_WEIGHT AS UNIT_WEIGHT
, B.VOLUME_UOM_CODE AS VOLUME_UOM_CODE
, B.UNIT_VOLUME AS UNIT_VOLUME
, B.CONTAINER_ITEM_FLAG AS CONTAINER_ITEM_FLAG
, B.VEHICLE_ITEM_FLAG AS VEHICLE_ITEM_FLAG
, B.CONTAINER_TYPE_CODE AS CONTAINER_TYPE_CODE
, B.INTERNAL_VOLUME AS INTERNAL_VOLUME
, B.MAXIMUM_LOAD_WEIGHT AS MAXIMUM_LOAD_WEIGHT
, B.MINIMUM_FILL_PERCENT AS MINIMUM_FILL_PERCENT
, B.INVENTORY_PLANNING_CODE AS INVENTORY_PLANNING_CODE
, B.PLANNER_CODE AS PLANNER_CODE
, B.PLANNING_MAKE_BUY_CODE AS PLANNING_MAKE_BUY_CODE
, B.MIN_MINMAX_QUANTITY AS MIN_MINMAX_QUANTITY
, B.MAX_MINMAX_QUANTITY AS MAX_MINMAX_QUANTITY
, B.MINIMUM_ORDER_QUANTITY AS MINIMUM_ORDER_QUANTITY
, B.MAXIMUM_ORDER_QUANTITY AS MAXIMUM_ORDER_QUANTITY
, B.ORDER_COST AS ORDER_COST
, B.CARRYING_COST AS CARRYING_COST
, B.SOURCE_TYPE AS SOURCE_TYPE
, B.SOURCE_ORGANIZATION_ID AS SOURCE_ORGANIZATION_ID
, B.SOURCE_SUBINVENTORY AS SOURCE_SUBINVENTORY
, B.MRP_SAFETY_STOCK_CODE AS MRP_SAFETY_STOCK_CODE
, B.SAFETY_STOCK_BUCKET_DAYS AS SAFETY_STOCK_BUCKET_DAYS
, B.MRP_SAFETY_STOCK_PERCENT AS MRP_SAFETY_STOCK_PERCENT
, B.FIXED_ORDER_QUANTITY AS FIXED_ORDER_QUANTITY
, B.FIXED_DAYS_SUPPLY AS FIXED_DAYS_SUPPLY
, B.FIXED_LOT_MULTIPLIER AS FIXED_LOT_MULTIPLIER
, B.MRP_PLANNING_CODE AS MRP_PLANNING_CODE
, B.ATO_FORECAST_CONTROL AS ATO_FORECAST_CONTROL
, B.PLANNING_EXCEPTION_SET AS PLANNING_EXCEPTION_SET
, B.END_ASSEMBLY_PEGGING_FLAG AS END_ASSEMBLY_PEGGING_FLAG
, B.SHRINKAGE_RATE AS SHRINKAGE_RATE
, B.ROUNDING_CONTROL_TYPE AS ROUNDING_CONTROL_TYPE
, B.ACCEPTABLE_EARLY_DAYS AS ACCEPTABLE_EARLY_DAYS
, B.REPETITIVE_PLANNING_FLAG AS REPETITIVE_PLANNING_FLAG
, B.OVERRUN_PERCENTAGE AS OVERRUN_PERCENTAGE
, B.ACCEPTABLE_RATE_INCREASE AS ACCEPTABLE_RATE_INCREASE
, B.ACCEPTABLE_RATE_DECREASE AS ACCEPTABLE_RATE_DECREASE
, B.MRP_CALCULATE_ATP_FLAG AS MRP_CALCULATE_ATP_FLAG
, B.AUTO_REDUCE_MPS AS AUTO_REDUCE_MPS
, B.PLANNING_TIME_FENCE_CODE AS PLANNING_TIME_FENCE_CODE
, B.PLANNING_TIME_FENCE_DAYS AS PLANNING_TIME_FENCE_DAYS
, B.DEMAND_TIME_FENCE_CODE AS DEMAND_TIME_FENCE_CODE
, B.DEMAND_TIME_FENCE_DAYS AS DEMAND_TIME_FENCE_DAYS
, B.RELEASE_TIME_FENCE_CODE AS RELEASE_TIME_FENCE_CODE
, B.RELEASE_TIME_FENCE_DAYS AS RELEASE_TIME_FENCE_DAYS
, B.PREPROCESSING_LEAD_TIME AS PREPROCESSING_LEAD_TIME
, B.FULL_LEAD_TIME AS FULL_LEAD_TIME
, B.POSTPROCESSING_LEAD_TIME AS POSTPROCESSING_LEAD_TIME
, B.FIXED_LEAD_TIME AS FIXED_LEAD_TIME
, B.VARIABLE_LEAD_TIME AS VARIABLE_LEAD_TIME
, B.CUM_MANUFACTURING_LEAD_TIME AS CUM_MANUFACTURING_LEAD_TIME
, B.CUMULATIVE_TOTAL_LEAD_TIME AS CUMULATIVE_TOTAL_LEAD_TIME
, B.LEAD_TIME_LOT_SIZE AS LEAD_TIME_LOT_SIZE
, B.BUILD_IN_WIP_FLAG AS BUILD_IN_WIP_FLAG
, B.WIP_SUPPLY_TYPE AS WIP_SUPPLY_TYPE
, B.WIP_SUPPLY_SUBINVENTORY AS WIP_SUPPLY_SUBINVENTORY
, B.WIP_SUPPLY_LOCATOR_ID AS WIP_SUPPLY_LOCATOR_ID
, B.OVERCOMPLETION_TOLERANCE_TYPE AS OVERCOMPLETION_TOLERANCE_TYPE
, B.OVERCOMPLETION_TOLERANCE_VALUE AS OVERCOMPLETION_TOLERANCE_VALUE
, B.CUSTOMER_ORDER_FLAG AS CUSTOMER_ORDER_FLAG
, B.CUSTOMER_ORDER_ENABLED_FLAG AS CUSTOMER_ORDER_ENABLED_FLAG
, B.SHIPPABLE_ITEM_FLAG AS SHIPPABLE_ITEM_FLAG
, B.INTERNAL_ORDER_FLAG AS INTERNAL_ORDER_FLAG
, B.INTERNAL_ORDER_ENABLED_FLAG AS INTERNAL_ORDER_ENABLED_FLAG
, B.SO_TRANSACTIONS_FLAG AS SO_TRANSACTIONS_FLAG
, B.PICK_COMPONENTS_FLAG AS PICK_COMPONENTS_FLAG
, B.ATP_FLAG AS ATP_FLAG
, B.REPLENISH_TO_ORDER_FLAG AS REPLENISH_TO_ORDER_FLAG
, B.ATP_RULE_ID AS ATP_RULE_ID
, B.ATP_COMPONENTS_FLAG AS ATP_COMPONENTS_FLAG
, B.SHIP_MODEL_COMPLETE_FLAG AS SHIP_MODEL_COMPLETE_FLAG
, B.PICKING_RULE_ID AS PICKING_RULE_ID
, B.COLLATERAL_FLAG AS COLLATERAL_FLAG
, B.DEFAULT_SHIPPING_ORG AS DEFAULT_SHIPPING_ORG
, B.RETURNABLE_FLAG AS RETURNABLE_FLAG
, B.RETURN_INSPECTION_REQUIREMENT AS RETURN_INSPECTION_REQUIREMENT
, B.OVER_SHIPMENT_TOLERANCE AS OVER_SHIPMENT_TOLERANCE
, B.UNDER_SHIPMENT_TOLERANCE AS UNDER_SHIPMENT_TOLERANCE
, B.OVER_RETURN_TOLERANCE AS OVER_RETURN_TOLERANCE
, B.UNDER_RETURN_TOLERANCE AS UNDER_RETURN_TOLERANCE
, B.INVOICEABLE_ITEM_FLAG AS INVOICEABLE_ITEM_FLAG
, B.INVOICE_ENABLED_FLAG AS INVOICE_ENABLED_FLAG
, B.ACCOUNTING_RULE_ID AS ACCOUNTING_RULE_ID
, B.INVOICING_RULE_ID AS INVOICING_RULE_ID
, B.TAX_CODE AS TAX_CODE
, B.SALES_ACCOUNT AS SALES_ACCOUNT
, B.PAYMENT_TERMS_ID AS PAYMENT_TERMS_ID
, B.SERVICE_ITEM_FLAG AS SERVICE_ITEM_FLAG
, B.VENDOR_WARRANTY_FLAG AS VENDOR_WARRANTY_FLAG
, B.COVERAGE_SCHEDULE_ID AS COVERAGE_SCHEDULE_ID
, B.SERVICE_DURATION AS SERVICE_DURATION
, B.SERVICE_DURATION_PERIOD_CODE AS SERVICE_DURATION_PERIOD_CODE
, B.SERVICEABLE_PRODUCT_FLAG AS SERVICEABLE_PRODUCT_FLAG
, B.SERVICE_STARTING_DELAY AS SERVICE_STARTING_DELAY
, B.MATERIAL_BILLABLE_FLAG AS MATERIAL_BILLABLE_FLAG
, B.TIME_BILLABLE_FLAG AS TIME_BILLABLE_FLAG
, B.EXPENSE_BILLABLE_FLAG AS EXPENSE_BILLABLE_FLAG
, B.SERVICEABLE_COMPONENT_FLAG AS SERVICEABLE_COMPONENT_FLAG
, B.PREVENTIVE_MAINTENANCE_FLAG AS PREVENTIVE_MAINTENANCE_FLAG
, B.PRORATE_SERVICE_FLAG AS PRORATE_SERVICE_FLAG
, B.SERVICEABLE_ITEM_CLASS_ID AS SERVICEABLE_ITEM_CLASS_ID
, B.BASE_WARRANTY_SERVICE_ID AS BASE_WARRANTY_SERVICE_ID
, B.WARRANTY_VENDOR_ID AS WARRANTY_VENDOR_ID
, B.MAX_WARRANTY_AMOUNT AS MAX_WARRANTY_AMOUNT
, B.RESPONSE_TIME_PERIOD_CODE AS RESPONSE_TIME_PERIOD_CODE
, B.RESPONSE_TIME_VALUE AS RESPONSE_TIME_VALUE
, B.PRIMARY_SPECIALIST_ID AS PRIMARY_SPECIALIST_ID
, B.SECONDARY_SPECIALIST_ID AS SECONDARY_SPECIALIST_ID
, B.WH_UPDATE_DATE AS WH_UPDATE_DATE
, B.SEGMENT1 AS SEGMENT1
, B.SEGMENT2 AS SEGMENT2
, B.SEGMENT3 AS SEGMENT3
, B.SEGMENT4 AS SEGMENT4
, B.SEGMENT5 AS SEGMENT5
, B.SEGMENT6 AS SEGMENT6
, B.SEGMENT7 AS SEGMENT7
, B.SEGMENT8 AS SEGMENT8
, B.SEGMENT9 AS SEGMENT9
, B.SEGMENT10 AS SEGMENT10
, B.SEGMENT11 AS SEGMENT11
, B.SEGMENT12 AS SEGMENT12
, B.SEGMENT13 AS SEGMENT13
, B.SEGMENT14 AS SEGMENT14
, B.SEGMENT15 AS SEGMENT15
, B.SEGMENT16 AS SEGMENT16
, B.SEGMENT17 AS SEGMENT17
, B.SEGMENT18 AS SEGMENT18
, B.SEGMENT19 AS SEGMENT19
, B.SEGMENT20 AS SEGMENT20
, B.SUMMARY_FLAG AS SUMMARY_FLAG
, B.ENABLED_FLAG AS ENABLED_FLAG
, B.START_DATE_ACTIVE AS START_DATE_ACTIVE
, B.END_DATE_ACTIVE AS END_DATE_ACTIVE
, B.ATTRIBUTE_CATEGORY AS ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1 AS ATTRIBUTE1
, B.ATTRIBUTE2 AS ATTRIBUTE2
, B.ATTRIBUTE3 AS ATTRIBUTE3
, B.ATTRIBUTE4 AS ATTRIBUTE4
, B.ATTRIBUTE5 AS ATTRIBUTE5
, B.ATTRIBUTE6 AS ATTRIBUTE6
, B.ATTRIBUTE7 AS ATTRIBUTE7
, B.ATTRIBUTE8 AS ATTRIBUTE8
, B.ATTRIBUTE9 AS ATTRIBUTE9
, B.ATTRIBUTE10 AS ATTRIBUTE10
, B.ATTRIBUTE11 AS ATTRIBUTE11
, B.ATTRIBUTE12 AS ATTRIBUTE12
, B.ATTRIBUTE13 AS ATTRIBUTE13
, B.ATTRIBUTE14 AS ATTRIBUTE14
, B.ATTRIBUTE15 AS ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE_CATEGORY AS GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1 AS GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2 AS GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3 AS GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4 AS GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5 AS GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6 AS GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7 AS GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8 AS GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9 AS GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10 AS GLOBAL_ATTRIBUTE10
, B.EQUIPMENT_TYPE AS EQUIPMENT_TYPE
, B.RECOVERED_PART_DISP_CODE AS RECOVERED_PART_DISP_CODE
, B.DEFECT_TRACKING_ON_FLAG AS DEFECT_TRACKING_ON_FLAG
, B.USAGE_ITEM_FLAG AS USAGE_ITEM_FLAG
, B.EVENT_FLAG AS EVENT_FLAG
, B.ELECTRONIC_FLAG AS ELECTRONIC_FLAG
, B.DOWNLOADABLE_FLAG AS DOWNLOADABLE_FLAG
, B.VOL_DISCOUNT_EXEMPT_FLAG AS VOL_DISCOUNT_EXEMPT_FLAG
, B.COUPON_EXEMPT_FLAG AS COUPON_EXEMPT_FLAG
, B.COMMS_NL_TRACKABLE_FLAG AS COMMS_NL_TRACKABLE_FLAG
, B.ASSET_CREATION_CODE AS ASSET_CREATION_CODE
, B.COMMS_ACTIVATION_REQD_FLAG AS COMMS_ACTIVATION_REQD_FLAG
, B.ORDERABLE_ON_WEB_FLAG AS ORDERABLE_ON_WEB_FLAG
, B.BACK_ORDERABLE_FLAG AS BACK_ORDERABLE_FLAG
, B.WEB_STATUS AS WEB_STATUS
, B.INDIVISIBLE_FLAG AS INDIVISIBLE_FLAG
, B.DIMENSION_UOM_CODE AS DIMENSION_UOM_CODE
, B.UNIT_LENGTH AS UNIT_LENGTH
, B.UNIT_WIDTH AS UNIT_WIDTH
, B.UNIT_HEIGHT AS UNIT_HEIGHT
, B.BULK_PICKED_FLAG AS BULK_PICKED_FLAG
, B.LOT_STATUS_ENABLED AS LOT_STATUS_ENABLED
, B.DEFAULT_LOT_STATUS_ID AS DEFAULT_LOT_STATUS_ID
, B.SERIAL_STATUS_ENABLED AS SERIAL_STATUS_ENABLED
, B.DEFAULT_SERIAL_STATUS_ID AS DEFAULT_SERIAL_STATUS_ID
, B.LOT_SPLIT_ENABLED AS LOT_SPLIT_ENABLED
, B.LOT_MERGE_ENABLED AS LOT_MERGE_ENABLED
, B.INVENTORY_CARRY_PENALTY AS INVENTORY_CARRY_PENALTY
, B.OPERATION_SLACK_PENALTY AS OPERATION_SLACK_PENALTY
, B.FINANCING_ALLOWED_FLAG AS FINANCING_ALLOWED_FLAG
, B.EAM_ITEM_TYPE AS EAM_ITEM_TYPE
, B.EAM_ACTIVITY_TYPE_CODE AS EAM_ACTIVITY_TYPE_CODE
, B.EAM_ACTIVITY_CAUSE_CODE AS EAM_ACTIVITY_CAUSE_CODE
, B.EAM_ACT_NOTIFICATION_FLAG AS EAM_ACT_NOTIFICATION_FLAG
, B.EAM_ACT_SHUTDOWN_STATUS AS EAM_ACT_SHUTDOWN_STATUS
, B.DUAL_UOM_CONTROL AS DUAL_UOM_CONTROL
, B.SECONDARY_UOM_CODE AS SECONDARY_UOM_CODE
, B.DUAL_UOM_DEVIATION_HIGH AS DUAL_UOM_DEVIATION_HIGH
, B.DUAL_UOM_DEVIATION_LOW AS DUAL_UOM_DEVIATION_LOW
, B.CONTRACT_ITEM_TYPE_CODE AS CONTRACT_ITEM_TYPE_CODE
, B.SUBSCRIPTION_DEPEND_FLAG AS SUBSCRIPTION_DEPEND_FLAG
, B.SERV_REQ_ENABLED_CODE AS SERV_REQ_ENABLED_CODE
, B.SERV_BILLING_ENABLED_FLAG AS SERV_BILLING_ENABLED_FLAG
, B.SERV_IMPORTANCE_LEVEL AS SERV_IMPORTANCE_LEVEL
, B.PLANNED_INV_POINT_FLAG AS PLANNED_INV_POINT_FLAG
, B.LOT_TRANSLATE_ENABLED AS LOT_TRANSLATE_ENABLED
, B.DEFAULT_SO_SOURCE_TYPE AS DEFAULT_SO_SOURCE_TYPE
, B.CREATE_SUPPLY_FLAG AS CREATE_SUPPLY_FLAG
, B.SUBSTITUTION_WINDOW_CODE AS SUBSTITUTION_WINDOW_CODE
, B.SUBSTITUTION_WINDOW_DAYS AS SUBSTITUTION_WINDOW_DAYS
, B.IB_ITEM_INSTANCE_CLASS AS IB_ITEM_INSTANCE_CLASS
, B.CONFIG_MODEL_TYPE AS CONFIG_MODEL_TYPE
, B.LOT_SUBSTITUTION_ENABLED AS LOT_SUBSTITUTION_ENABLED
, B.MINIMUM_LICENSE_QUANTITY AS MINIMUM_LICENSE_QUANTITY
, B.EAM_ACTIVITY_SOURCE_CODE AS EAM_ACTIVITY_SOURCE_CODE
, B.LIFECYCLE_ID AS LIFECYCLE_ID
, B.CURRENT_PHASE_ID AS CURRENT_PHASE_ID
, B.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER
, B.TRACKING_QUANTITY_IND AS TRACKING_QUANTITY_IND
, B.ONT_PRICING_QTY_SOURCE AS ONT_PRICING_QTY_SOURCE
, B.SECONDARY_DEFAULT_IND AS SECONDARY_DEFAULT_IND
, B.OPTION_SPECIFIC_SOURCED AS OPTION_SPECIFIC_SOURCED
, B.APPROVAL_STATUS AS APPROVAL_STATUS
, B.VMI_MINIMUM_UNITS AS VMI_MINIMUM_UNITS
, B.VMI_MINIMUM_DAYS AS VMI_MINIMUM_DAYS
, B.VMI_MAXIMUM_UNITS AS VMI_MAXIMUM_UNITS
, B.VMI_MAXIMUM_DAYS AS VMI_MAXIMUM_DAYS
, B.VMI_FIXED_ORDER_QUANTITY AS VMI_FIXED_ORDER_QUANTITY
, B.SO_AUTHORIZATION_FLAG AS SO_AUTHORIZATION_FLAG
, B.CONSIGNED_FLAG AS CONSIGNED_FLAG
, B.ASN_AUTOEXPIRE_FLAG AS ASN_AUTOEXPIRE_FLAG
, B.VMI_FORECAST_TYPE AS VMI_FORECAST_TYPE
, B.FORECAST_HORIZON AS FORECAST_HORIZON
, B.EXCLUDE_FROM_BUDGET_FLAG AS EXCLUDE_FROM_BUDGET_FLAG
, B.DAYS_TGT_INV_SUPPLY AS DAYS_TGT_INV_SUPPLY
, B.DAYS_TGT_INV_WINDOW AS DAYS_TGT_INV_WINDOW
, B.DAYS_MAX_INV_SUPPLY AS DAYS_MAX_INV_SUPPLY
, B.DAYS_MAX_INV_WINDOW AS DAYS_MAX_INV_WINDOW
, B.DRP_PLANNED_FLAG AS DRP_PLANNED_FLAG
, B.CRITICAL_COMPONENT_FLAG AS CRITICAL_COMPONENT_FLAG
, B.CONTINOUS_TRANSFER AS CONTINOUS_TRANSFER
, B.CONVERGENCE AS CONVERGENCE
, B.DIVERGENCE AS DIVERGENCE
, B.CONFIG_ORGS AS CONFIG_ORGS
, B.CONFIG_MATCH AS CONFIG_MATCH
, B.CREATION_DATE AS CREATION_DATE
, B.CREATED_BY AS CREATED_BY
, B.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, B.LAST_UPDATED_BY AS LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN
, B.REQUEST_ID AS REQUEST_ID
, B.PROGRAM_APPLICATION_ID AS PROGRAM_APPLICATION_ID
, B.PROGRAM_ID AS PROGRAM_ID
, B.PROGRAM_UPDATE_DATE AS PROGRAM_UPDATE_DATE
, T.DESCRIPTION AS DESCRIPTION
, T.LONG_DESCRIPTION AS LONG_DESCRIPTION
, B.CONCATENATED_SEGMENTS AS CONCATENATED_SEGMENTS
, B.PADDED_CONCATENATED_SEGMENTS AS PADDED_CONCATENATED_SEGMENTS
, B.ATTRIBUTE16 AS ATTRIBUTE16
, B.ATTRIBUTE17 AS ATTRIBUTE17
, B.ATTRIBUTE18 AS ATTRIBUTE18
, B.ATTRIBUTE19 AS ATTRIBUTE19
, B.ATTRIBUTE20 AS ATTRIBUTE20
, B.ATTRIBUTE21 AS ATTRIBUTE21
, B.ATTRIBUTE22 AS ATTRIBUTE22
, B.ATTRIBUTE23 AS ATTRIBUTE23
, B.ATTRIBUTE24 AS ATTRIBUTE24
, B.ATTRIBUTE25 AS ATTRIBUTE25
, B.ATTRIBUTE26 AS ATTRIBUTE26
, B.ATTRIBUTE27 AS ATTRIBUTE27
, B.ATTRIBUTE28 AS ATTRIBUTE28
, B.ATTRIBUTE29 AS ATTRIBUTE29
, B.ATTRIBUTE30 AS ATTRIBUTE30
, B.CAS_NUMBER AS CAS_NUMBER
, B.CHILD_LOT_FLAG AS CHILD_LOT_FLAG
, B.CHILD_LOT_PREFIX AS CHILD_LOT_PREFIX
, B.CHILD_LOT_STARTING_NUMBER AS CHILD_LOT_STARTING_NUMBER
, B.CHILD_LOT_VALIDATION_FLAG AS CHILD_LOT_VALIDATION_FLAG
, B.COPY_LOT_ATTRIBUTE_FLAG AS COPY_LOT_ATTRIBUTE_FLAG
, B.DEFAULT_GRADE AS DEFAULT_GRADE
, B.EXPIRATION_ACTION_CODE AS EXPIRATION_ACTION_CODE
, B.EXPIRATION_ACTION_INTERVAL AS EXPIRATION_ACTION_INTERVAL
, B.GRADE_CONTROL_FLAG AS GRADE_CONTROL_FLAG
, B.HAZARDOUS_MATERIAL_FLAG AS HAZARDOUS_MATERIAL_FLAG
, B.HOLD_DAYS AS HOLD_DAYS
, B.LOT_DIVISIBLE_FLAG AS LOT_DIVISIBLE_FLAG
, B.MATURITY_DAYS AS MATURITY_DAYS
, B.PARENT_CHILD_GENERATION_FLAG AS PARENT_CHILD_GENERATION_FLAG
, B.PROCESS_COSTING_ENABLED_FLAG AS PROCESS_COSTING_ENABLED_FLAG
, B.PROCESS_EXECUTION_ENABLED_FLAG AS PROCESS_EXECUTION_ENABLED_FLAG
, B.PROCESS_QUALITY_ENABLED_FLAG AS PROCESS_QUALITY_ENABLED_FLAG
, B.PROCESS_SUPPLY_LOCATOR_ID AS PROCESS_SUPPLY_LOCATOR_ID
, B.PROCESS_SUPPLY_SUBINVENTORY AS PROCESS_SUPPLY_SUBINVENTORY
, B.PROCESS_YIELD_LOCATOR_ID AS PROCESS_YIELD_LOCATOR_ID
, B.PROCESS_YIELD_SUBINVENTORY AS PROCESS_YIELD_SUBINVENTORY
, B.RECIPE_ENABLED_FLAG AS RECIPE_ENABLED_FLAG
, B.RETEST_INTERVAL AS RETEST_INTERVAL
, B.CHARGE_PERIODICITY_CODE AS CHARGE_PERIODICITY_CODE
, B.REPAIR_LEADTIME AS REPAIR_LEADTIME
, B.REPAIR_YIELD AS REPAIR_YIELD
, B.PREPOSITION_POINT AS PREPOSITION_POINT
, B.REPAIR_PROGRAM AS REPAIR_PROGRAM
, B.SUBCONTRACTING_COMPONENT AS SUBCONTRACTING_COMPONENT
, B.OUTSOURCED_ASSEMBLY AS OUTSOURCED_ASSEMBLY
, HAOU.NAME AS OPERATING_UNIT_NAME
, HAOU.ORGANIZATION_ID AS OPERATING_UNIT_ID
, MP.MASTER_ORGANIZATION_ID AS MASTER_ORGANIZATION_ID
, MP.ORGANIZATION_CODE AS ORGANIZATION_CODE
FROM MTL_SYSTEM_ITEMS_TL T
, MTL_SYSTEM_ITEMS_B_KFV B
, HR_ALL_ORGANIZATION_UNITS HAOU
, HR_ORGANIZATION_INFORMATION HOI
, MTL_PARAMETERS MP
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND B.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND UPPER((HOI.ORG_INFORMATION_CONTEXT||'')) ='ACCOUNTING INFORMATION'
AND HAOU.ORGANIZATION_ID = DECODE(ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(ORG_INFORMATION3)
, TO_NUMBER(NULL))
AND T.LANGUAGE = USERENV('LANG')
AND B.ORGANIZATION_ID = MP.ORGANIZATION_ID