ECC Product Information Management, Organization Items

Description
Categories: Enterprise Command Center
Columns: Eam Item Type, Eam Activity Type Code, Eam Activity Cause Code, Eam Activity Source Code, Eam Act Shutdown Status, Eam Act Notification Flag, Bom Enabled Flag, Bom Item Type, Base Item Id, Auto Created Config Flag ...
Imported from Enterprise Command Center
Dataset Key: inv-item-grain
Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues
select
x.*
from
(
select * from (SELECT /*+leading(mtl_v.mir) push_pred(mtl_v.buyer) push_pred(mtl_v.rpc) */
  EAM_ITEM_TYPE,EAM_ACTIVITY_TYPE_CODE,EAM_ACTIVITY_CAUSE_CODE,EAM_ACTIVITY_SOURCE_CODE,EAM_ACT_SHUTDOWN_STATUS,EAM_ACT_NOTIFICATION_FLAG,
  BOM_ENABLED_FLAG,BOM_ITEM_TYPE,BASE_ITEM_ID,AUTO_CREATED_CONFIG_FLAG,EFFECTIVITY_CONTROL,CONFIG_MODEL_TYPE,CONFIG_ORGS,CONFIG_MATCH,ENG_ITEM_FLAG,
  COSTING_ENABLED_FLAG,INVENTORY_ASSET_FLAG,DEFAULT_INCLUDE_IN_ROLLUP_FLAG,COST_OF_SALES_ACCOUNT,STD_LOT_SIZE,INVENTORY_PLANNING_CODE,PLANNER_CODE,
  PLANNING_MAKE_BUY_CODE,MIN_MINMAX_QUANTITY,MAX_MINMAX_QUANTITY,MINIMUM_ORDER_QUANTITY,MAXIMUM_ORDER_QUANTITY,ORDER_COST,CARRYING_COST,SOURCE_TYPE,SOURCE_ORGANIZATION_CODE,
  SOURCE_SUBINVENTORY,MRP_SAFETY_STOCK_CODE,SAFETY_STOCK_BUCKET_DAYS,MRP_SAFETY_STOCK_PERCENT,FIXED_ORDER_QUANTITY,FIXED_DAYS_SUPPLY,FIXED_LOT_MULTIPLIER,
  VMI_MINIMUM_UNITS,VMI_MINIMUM_DAYS, VMI_MAXIMUM_UNITS,VMI_MAXIMUM_DAYS,VMI_FIXED_ORDER_QUANTITY,SO_AUTHORIZATION_FLAG,CONSIGNED_FLAG,ASN_AUTOEXPIRE_FLAG,
  VMI_FORECAST_TYPE,FORECAST_HORIZON,SUBCONTRACTING_COMPONENT,INVENTORY_ITEM_FLAG,STOCK_ENABLED_CODE,STOCK_ENABLED_FLAG,MTL_TRANSACTIONS_ENABLED_FLAG,REVISION_QTY_CONTROL_CODE,
  RESERVABLE_TYPE,CHECK_SHORTAGES_FLAG,SHELF_LIFE_CODE,SHELF_LIFE_DAYS,CYCLE_COUNT_ENABLED_FLAG,NEGATIVE_MEASUREMENT_ERROR,POSITIVE_MEASUREMENT_ERROR,
  LOT_CONTROL_CODE,AUTO_LOT_ALPHA_PREFIX,START_AUTO_LOT_NUMBER,SERIAL_NUMBER_CONTROL_CODE,AUTO_SERIAL_ALPHA_PREFIX,START_AUTO_SERIAL_NUMBER,LOCATION_CONTROL_CODE,
  RESTRICT_SUBINVENTORIES_CODE,RESTRICT_LOCATORS_CODE,LOT_STATUS_ENABLED,DEFAULT_LOT_STATUS_ID,SERIAL_STATUS_ENABLED,DEFAULT_SERIAL_STATUS_ID,LOT_SPLIT_ENABLED,
  LOT_MERGE_ENABLED,LOT_TRANSLATE_ENABLED,LOT_SUBSTITUTION_ENABLED,BULK_PICKED_FLAG,MATURITY_DAYS,HOLD_DAYS,RETEST_INTERVAL,EXPIRATION_ACTION_INTERVAL,
  EXPIRATION_ACTION_CODE,GRADE_CONTROL_FLAG,DEFAULT_GRADE,LOT_DIVISIBLE_FLAG,CHILD_LOT_FLAG,PARENT_CHILD_GENERATION_FLAG,CHILD_LOT_PREFIX,CHILD_LOT_STARTING_NUMBER,
  CHILD_LOT_VALIDATION_FLAG,COPY_LOT_ATTRIBUTE_FLAG,INVOICEABLE_ITEM_FLAG,INVOICE_ENABLED_FLAG,ACCOUNTING_RULE_ID,INVOICING_RULE_ID,TAX_CODE,SALES_ACCOUNT,
  PAYMENT_TERMS_ID,PREPROCESSING_LEAD_TIME,FULL_LEAD_TIME,POSTPROCESSING_LEAD_TIME,FIXED_LEAD_TIME,VARIABLE_LEAD_TIME,CUM_MANUFACTURING_LEAD_TIME,
  CUMULATIVE_TOTAL_LEAD_TIME,LEAD_TIME_LOT_SIZE,MRP_PLANNING_CODE,ATO_FORECAST_CONTROL,END_ASSEMBLY_PEGGING_FLAG,PLANNING_EXCEPTION_SET,SHRINKAGE_RATE,
  ACCEPTABLE_EARLY_DAYS,ROUNDING_CONTROL_TYPE,PLANNED_INV_POINT_FLAG,CREATE_SUPPLY_FLAG,REPETITIVE_PLANNING_FLAG,OVERRUN_PERCENTAGE,ACCEPTABLE_RATE_INCREASE,
  ACCEPTABLE_RATE_DECREASE,MRP_CALCULATE_ATP_FLAG,AUTO_REDUCE_MPS,PLANNING_TIME_FENCE_CODE,PLANNING_TIME_FENCE_DAYS,DEMAND_TIME_FENCE_CODE,DEMAND_TIME_FENCE_DAYS,
  RELEASE_TIME_FENCE_CODE,RELEASE_TIME_FENCE_DAYS,SUBSTITUTION_WINDOW_CODE,SUBSTITUTION_WINDOW_DAYS,EXCLUDE_FROM_BUDGET_FLAG,CRITICAL_COMPONENT_FLAG,
  CONTINOUS_TRANSFER,CONVERGENCE,DIVERGENCE,DRP_PLANNED_FLAG,DAYS_MAX_INV_SUPPLY,DAYS_MAX_INV_WINDOW,DAYS_TGT_INV_SUPPLY,DAYS_TGT_INV_WINDOW,REPAIR_LEADTIME,
  REPAIR_YIELD,REPAIR_PROGRAM,PREPOSITION_POINT,TRACKING_QUANTITY_IND,ONT_PRICING_QTY_SOURCE,SECONDARY_UOM_CODE,SECONDARY_DEFAULT_IND,DUAL_UOM_DEVIATION_HIGH,
  DUAL_UOM_DEVIATION_LOW,ALLOWED_UNITS_LOOKUP_CODE,ITEM_TYPE,DESCRIPTION,INVENTORY_ITEM_STATUS_CODE,PRIMARY_UNIT_OF_MEASURE,CUSTOMER_ORDER_FLAG,CUSTOMER_ORDER_ENABLED_CODE,
  CUSTOMER_ORDER_ENABLED_FLAG,SHIPPABLE_ITEM_CODE,SHIPPABLE_ITEM_FLAG,INTERNAL_ORDER_FLAG,INTERNAL_ORDER_ENABLED_FLAG,SO_TRANSACTIONS_FLAG,PICK_COMPONENTS_FLAG,
  ATP_FLAG,REPLENISH_TO_ORDER_FLAG,ATP_RULE_ID,ATP_COMPONENTS_FLAG,SHIP_MODEL_COMPLETE_FLAG,PICKING_RULE_ID,DEFAULT_SHIPPING_ORG,DEFAULT_SO_SOURCE_TYPE,
  CHARGE_PERIODICITY_CODE,RETURNABLE_FLAG,RETURN_INSPECTION_REQUIREMENT,FINANCING_ALLOWED_FLAG,OVER_SHIPMENT_TOLERANCE,OVER_RETURN_TOLERANCE,UNDER_SHIPMENT_TOLERANCE,
  UNDER_RETURN_TOLERANCE,WEIGHT_UOM_CODE,UNIT_WEIGHT,VOLUME_UOM_CODE,UNIT_VOLUME,DIMENSION_UOM_CODE,UNIT_LENGTH,UNIT_WIDTH,UNIT_HEIGHT,CONTAINER_ITEM_FLAG,
  VEHICLE_ITEM_FLAG,CONTAINER_TYPE_CODE,INTERNAL_VOLUME,MAXIMUM_LOAD_WEIGHT,MINIMUM_FILL_PERCENT,COLLATERAL_FLAG,ELECTRONIC_FLAG,EVENT_FLAG,DOWNLOADABLE_FLAG,
  INDIVISIBLE_FLAG,EQUIPMENT_TYPE,RECIPE_ENABLED_FLAG,PROCESS_COSTING_ENABLED_FLAG,PROCESS_QUALITY_ENABLED_FLAG,PROCESS_EXECUTION_ENABLED_FLAG,PROCESS_SUPPLY_SUBINVENTORY,
  PROCESS_SUPPLY_LOCATOR_ID,PROCESS_YIELD_SUBINVENTORY,PROCESS_YIELD_LOCATOR_ID,HAZARDOUS_MATERIAL_FLAG,CAS_NUMBER,PURCHASING_ITEM_FLAG,PURCHASING_ENABLED_CODE,
  PURCHASING_ENABLED_FLAG,MUST_USE_APPROVED_VENDOR_FLAG,ALLOW_ITEM_DESC_UPDATE_FLAG,RFQ_REQUIRED_FLAG,OUTSIDE_OPERATION_FLAG,OUTSIDE_OPERATION_UOM_TYPE,
  TAXABLE_FLAG,PURCHASING_TAX_CODE,RECEIPT_REQUIRED_FLAG,INSPECTION_REQUIRED_FLAG,BUYER_ID,UNIT_OF_ISSUE,RECEIVE_CLOSE_TOLERANCE,INVOICE_CLOSE_TOLERANCE,UN_NUMBER_ID,
  HAZARD_CLASS_ID,LIST_PRICE_PER_UNIT,MARKET_PRICE,PRICE_TOLERANCE_PERCENT,ROUNDING_FACTOR,ENCUMBRANCE_ACCOUNT,EXPENSE_ACCOUNT,ASSET_CATEGORY_ID,OUTSOURCED_ASSEMBLY,
  RECEIPT_DAYS_EXCEPTION_CODE,DAYS_EARLY_RECEIPT_ALLOWED,DAYS_LATE_RECEIPT_ALLOWED,ALLOW_SUBSTITUTE_RECEIPTS_FLAG,ALLOW_UNORDERED_RECEIPTS_FLAG,ALLOW_EXPRESS_DELIVERY_FLAG,
  QTY_RCV_EXCEPTION_CODE,QTY_RCV_TOLERANCE,RECEIVING_ROUTING_ID,ENFORCE_SHIP_TO_LOCATION_CODE,SERV_REQ_ENABLED_CODE,SERVICEABLE_PRODUCT_CODE,SERVICEABLE_PRODUCT_FLAG,
  DEFECT_TRACKING_ON_FLAG,COMMS_ACTIVATION_REQD_FLAG,CONTRACT_ITEM_TYPE_CODE,SERVICE_DURATION,SERVICE_DURATION_PERIOD_CODE,COVERAGE_SCHEDULE_ID,SERVICE_STARTING_DELAY,
  COMMS_NL_TRACKABLE_FLAG,ASSET_CREATION_CODE,IB_ITEM_INSTANCE_CLASS,RECOVERED_PART_DISP_CODE,SERV_BILLING_ENABLED_FLAG,MATERIAL_BILLABLE_FLAG,WEB_STATUS,
  ORDERABLE_ON_WEB_FLAG,BACK_ORDERABLE_FLAG,MINIMUM_LICENSE_QUANTITY,BUILD_IN_WIP_CODE,BUILD_IN_WIP_FLAG,WIP_SUPPLY_TYPE,WIP_SUPPLY_SUBINVENTORY,WIP_SUPPLY_LOCATOR_ID,
  INVENTORY_CARRY_PENALTY,OPERATION_SLACK_PENALTY,OVERCOMPLETION_TOLERANCE_TYPE,OVERCOMPLETION_TOLERANCE_VALUE,ITEM,LONG_DESCRIPTION,CATALOG_GROUP,ORG_CODE,ORG_NAME,
  INVENTORY_ITEM_ID,ORGANIZATION_ID,ITEM_COST,LTRIM(ITEM_FUNCTIONS,fnd_global.local_chr(44)||fnd_global.local_chr(127)) ITEM_FUNCTIONS,ECC_LAST_UPDATE_DATE,ECC_SPEC_ID,DETAILS,CURRENCY,RECV_SUBINVENTORY,
  IB_ITEM_TRACKING_LEVEL,ATTRIBUTE_CATEGORY,
  /*ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15,
  ATTRIBUTE16,
  ATTRIBUTE17,
  ATTRIBUTE18,
  ATTRIBUTE19,
  ATTRIBUTE20,
  ATTRIBUTE21,
  ATTRIBUTE22,
  ATTRIBUTE23,
  ATTRIBUTE24,
  ATTRIBUTE25,
  ATTRIBUTE26,
  ATTRIBUTE27,
  ATTRIBUTE28,
  ATTRIBUTE29,
  ATTRIBUTE30,*/
  LANGUAGE,'OA_MEDIA/action_link' as UPDATE_ITEM,'OA_MEDIA/action_link' as ON_HAND_LINK,'OA_MEDIA/action_link' as ITEM_ATTACHMENT , ITMDFF.* 
FROM MTL_ITEM_ECC_GRAIN_V mtl_v , (select ROW_ID "'ITMDFFROW_ID'",CONTEXT "'ITMDFFCONTEXT'",to_char(LATE_DEMANDS_PENALTY) "'ITMDFFLATE_DEMANDS_PENALTY'",INVOICE_UOM "'ITMDFFINVOICE_UOM'",GRAPHICAL_LINK_FOR_WEB_REQS "'ITMDFFGRAPHICAL_LINK_FOR_WEB_REQS'",to_char(MATERIAL_OVER_CAPACITY_PENALTY) "'ITMDFFMATERIAL_OVER_CAPACITY_PENALTY'",CHARGE_DESCRIPTION_MASTER "'ITMDFFCHARGE_DESCRIPTION_MASTER'",ITEM_MODEL "'ITMDFFITEM_MODEL'",TAX_DENOMINATION "'ITMDFFTAX_DENOMINATION'",CONCATENATED_SEGMENTS "'ITMDFFCONCATENATED_SEGMENTS'" from MTL_SYSTEM_ITEMS_B_DFV) ITMDFF
where  language in ('US')
 AND ITMDFF."'ITMDFFROW_ID'"(+) = ITEM_ROWID )
PIVOT (
MAX(DESCRIPTION) AS DESCRIPTION,
MAX(LONG_DESCRIPTION) AS LONG_DESCRIPTION,
max(DEFAULT_LOT_STATUS_ID) AS DEFAULT_LOT_STATUS_ID,
max(DEFAULT_SERIAL_STATUS_ID) AS DEFAULT_SERIAL_STATUS_ID,
max(EXPIRATION_ACTION_CODE) AS EXPIRATION_ACTION_CODE,
max(DEFAULT_GRADE) AS DEFAULT_GRADE,
max(UN_NUMBER_ID) AS UN_NUMBER_ID,
max(HAZARD_CLASS_ID) AS HAZARD_CLASS_ID,
max(INVENTORY_ITEM_STATUS_CODE) AS INVENTORY_ITEM_STATUS_CODE,
max(SERVICE_DURATION_PERIOD_CODE) AS SERVICE_DURATION_PERIOD,
max(PAYMENT_TERMS_ID) AS PAYMENT_TERMS_ID
for LANGUAGE in ('US' "US"))
 
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.org_code=:organization_code
LOV