INV_LEGACY_FEATURE_ORGS_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

LAST_UPDATE_DATE TRACK_COUNTRY_OF_ORIGIN_FLAG FILL_KILL_TRANSFER_ORDERS_FLAG ORGANIZATION_ID LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ORGANIZATION_CODE MASTER_ORGANIZATION_ID BUSINESS_UNIT_ID LEGAL_ENTITY_ID SCHEDULE_ID DEFAULT_PICKING_RULE_ID DEFAULT_LOCATOR_ORDER_VALUE DEFAULT_SUBINV_ORDER_VALUE NEGATIVE_INV_RECEIPT_CODE STOCK_LOCATOR_CONTROL_CODE SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY SOURCE_TYPE SERIAL_NUMBER_TYPE AUTO_SERIAL_ALPHA_PREFIX START_AUTO_SERIAL_NUMBER AUTO_LOT_ALPHA_PREFIX LOT_NUMBER_UNIQUENESS LOT_NUMBER_GENERATION LOT_NUMBER_ZERO_PADDING LOT_NUMBER_LENGTH STARTING_REVISION LPN_PREFIX LPN_SUFFIX LPN_STARTING_NUMBER TOTAL_LPN_LENGTH UCC_128_SUFFIX_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 SERIAL_NUMBER_GENERATION GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 MO_PICK_CONFIRM_REQUIRED OVPK_TRANSFER_ORDERS_ENABLED ALLOCATE_SERIAL_FLAG DISTRIBUTED_ORGANIZATION_FLAG ALLOW_DIFFERENT_STATUS CHILD_LOT_ALPHA_PREFIX CHILD_LOT_NUMBER_LENGTH CHILD_LOT_VALIDATION_FLAG CHILD_LOT_ZERO_PADDING_FLAG COPY_LOT_ATTRIBUTE_FLAG CREATE_LOT_UOM_CONVERSION PARENT_CHILD_GENERATION_FLAG AUTO_DEL_ALLOC_FLAG ENFORCE_LOCATOR_ALIS_UNQ_FLAG PRE_FILL_PICKED_QTY CAPTURE_PICKING_EXCEPTION INVENTORY_FLAG OBJECT_VERSION_NUMBER QA_SKIPPING_INSP_FLAG WCS_ENABLED EAM_ENABLED_FLAG WMS_ENABLED_FLAG MAINT_ORGANIZATION_ID TRADING_PARTNER_ORG_FLAG PREGEN_PUTAWAY_TASKS_FLAG REGENERATION_INTERVAL TIMEZONE_ID DEFAULT_WMS_PICKING_RULE_ID DEFAULT_PUT_AWAY_RULE_ID DEFAULT_CARTON_RULE_ID DEFAULT_CYC_COUNT_HEADER_ID CROSSDOCK_FLAG CARTONIZATION_FLAG PROJECT_REFERENCE_ENABLED PROJECT_CONTROL_LEVEL PM_COST_COLLECTION_ENABLED JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE REQUEST_ID PICK_QTY_DEFAULT_REASON_ID FIFO_ORIG_RCPT_DATE_FLAG ALLOW_NEG_ONHAND_CC_TXNS PURCHASING_BY_REVISION ROUND_REORDER_QTY_FLAG REPLNSH_MOVE_ORDER_GROUPING FILL_KILL_MOVE_ORDER_FLAG PICK_SLIP_BATCH_SIZE STANDARD_PACK_ENABLED AUTO_BREAKDOWN_ENABLED ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 PROFIT_CENTER_BU_ID MANUAL_RECEIPT_EXP_AT_DEST MFG_PLANT_FLAG CONTRACT_MFG_FLAG SUPPLIER_ID SUPPLIER_SITE_ID TIMEZONE_CODE INTEGRATED_SYSTEM_CODE ITEM_GROUPING_CODE ITEM_DEFINITION_ORG_ID GROUPING_JOB_STATUS GROUPING_JOB_ID INTERNAL_CUSTOMER_FLAG CUSTOMER_ACCOUNT_NUMBER PARTY_ID USE_CUR_ITEM_COST_FLAG SPECIAL_HNDLNG_OVRPK_FLAG FA_BOOK_TYPE_CODE ALLOW_ITEM_SUBSTITUTIONS WMS_WITH_MFG_ALM FILL_KILL_SALES_ORDER_FLAG KANBAN_CARD_PREFIX KANBAN_CARD_START_NUMBER KANBAN_DOC_SEQ_ID KANBAN_DOC_SEQ_CAT_CODE MAINT_TECH_WB_ENABLED_FLAG EXPIRED_LOT_SUBINVENTORY EXPIRED_LOT_LOCATOR LOT_CONVERSION_ENABLED_FLAG AUTOCRT_LOT_UOM_CONV_FLAG ALLOW_OVERISSUE_WO_PICK REQ_BARCODE_VALIDATION FEATURE_LOT_UOM_CONV_ENABLED FEATURE_LPN_ENABLED FEATURE_STRIPING_ATTRIBUTES_ENABLED FEATURE_PARENT_LOT LEGACY_UI_ALLOWED

Query

SQL_Statement

WITH orgs_with_features AS ( SELECT iop.last_update_date , iop.track_country_of_origin_flag , iop.fill_kill_transfer_orders_flag , iop.organization_id , iop.last_updated_by , iop.creation_date , iop.created_by , iop.last_update_login , iop.organization_code , iop.master_organization_id , iop.business_unit_id , iop.legal_entity_id , iop.schedule_id , iop.default_picking_rule_id , iop.default_locator_order_value , iop.default_subinv_order_value , iop.negative_inv_receipt_code , iop.stock_locator_control_code , iop.source_organization_id , iop.source_subinventory , iop.source_type , iop.serial_number_type , iop.auto_serial_alpha_prefix , iop.start_auto_serial_number , iop.auto_lot_alpha_prefix , iop.lot_number_uniqueness , iop.lot_number_generation , iop.lot_number_zero_padding , iop.lot_number_length , iop.starting_revision , iop.lpn_prefix , iop.lpn_suffix , iop.lpn_starting_number , iop.total_lpn_length , iop.ucc_128_suffix_flag , iop.attribute_category , iop.attribute1 , iop.attribute2 , iop.attribute3 , iop.attribute4 , iop.attribute5 , iop.attribute6 , iop.attribute7 , iop.attribute8 , iop.attribute9 , iop.attribute10 , iop.attribute11 , iop.attribute12 , iop.attribute13 , iop.attribute14 , iop.attribute15 , iop.serial_number_generation , iop.global_attribute_category , iop.global_attribute1 , iop.global_attribute2 , iop.global_attribute3 , iop.global_attribute4 , iop.global_attribute5 , iop.global_attribute6 , iop.global_attribute7 , iop.global_attribute8 , iop.global_attribute9 , iop.global_attribute10 , iop.global_attribute11 , iop.global_attribute12 , iop.global_attribute13 , iop.global_attribute14 , iop.global_attribute15 , iop.global_attribute16 , iop.global_attribute17 , iop.global_attribute18 , iop.global_attribute19 , iop.global_attribute20 , iop.mo_pick_confirm_required , iop.ovpk_transfer_orders_enabled , iop.allocate_serial_flag , iop.distributed_organization_flag , iop.allow_different_status , iop.child_lot_alpha_prefix , iop.child_lot_number_length , iop.child_lot_validation_flag , iop.child_lot_zero_padding_flag , iop.copy_lot_attribute_flag , iop.create_lot_uom_conversion , iop.parent_child_generation_flag , iop.auto_del_alloc_flag , iop.enforce_locator_alis_unq_flag , iop.pre_fill_picked_qty , iop.capture_picking_exception , iop.inventory_flag , iop.object_version_number , iop.qa_skipping_insp_flag , iop.wcs_enabled , iop.eam_enabled_flag , iop.wms_enabled_flag , iop.maint_organization_id , iop.trading_partner_org_flag , iop.pregen_putaway_tasks_flag , iop.regeneration_interval , iop.timezone_id , iop.default_wms_picking_rule_id , iop.default_put_away_rule_id , iop.default_carton_rule_id , iop.default_cyc_count_header_id , iop.crossdock_flag , iop.cartonization_flag , iop.project_reference_enabled , iop.project_control_level , iop.pm_cost_collection_enabled , iop.job_definition_name , iop.job_definition_package , iop.request_id , iop.pick_qty_default_reason_id , iop.fifo_orig_rcpt_date_flag , iop.allow_neg_onhand_cc_txns , iop.purchasing_by_revision , iop.round_reorder_qty_flag , iop.replnsh_move_order_grouping , iop.fill_kill_move_order_flag , iop.pick_slip_batch_size , iop.standard_pack_enabled , iop.auto_breakdown_enabled , iop.attribute_number1 , iop.attribute_number2 , iop.attribute_number3 , iop.attribute_number4 , iop.attribute_number5 , iop.attribute_number6 , iop.attribute_number7 , iop.attribute_number8 , iop.attribute_number9 , iop.attribute_number10 , iop.attribute_date1 , iop.attribute_date2 , iop.attribute_date3 , iop.attribute_date4 , iop.attribute_date5 , iop.attribute_timestamp1 , iop.attribute_timestamp2 , iop.attribute_timestamp3 , iop.attribute_timestamp4 , iop.attribute_timestamp5 , iop.profit_center_bu_id , iop.manual_receipt_exp_at_dest , iop.mfg_plant_flag , iop.contract_mfg_flag , iop.supplier_id , iop.supplier_site_id , iop.timezone_code , iop.integrated_system_code , iop.item_grouping_code , iop.item_definition_org_id , iop.grouping_job_status , iop.grouping_job_id , iop.internal_customer_flag , iop.customer_account_number , iop.party_id , iop.use_cur_item_cost_flag , iop.special_hndlng_ovrpk_flag , iop.fa_book_type_code , iop.allow_item_substitutions , iop.wms_with_mfg_alm , iop.fill_kill_sales_order_flag , iop.kanban_card_prefix , iop.kanban_card_start_number , iop.kanban_doc_seq_id , iop.kanban_doc_seq_cat_code , iop.maint_tech_wb_enabled_flag , iop.expired_lot_subinventory , iop.expired_lot_locator , iop.lot_conversion_enabled_flag , iop.autocrt_lot_uom_conv_flag , iop.allow_overissue_wo_pick , iop.req_barcode_validation , nvl(iop.lot_conversion_enabled_flag, 'N') feature_lot_uom_conv_enabled , CASE WHEN EXISTS ( SELECT 1 FROM inv_advanced_inv_params iaip WHERE iaip.organization_id = iop.organization_id AND nvl(iaip.lpn_enabled_flag, 'N') = 'Y' ) THEN 'Y' ELSE 'N' END feature_lpn_enabled , CASE WHEN EXISTS ( SELECT 1 FROM inv_attribute_setups atrsetup WHERE atrsetup.enabled_flag = 'Y' AND atrsetup.status IN ('ORA_DEPLOYED', 'ORA_REDEPLOY_NEEDED', 'ORA_DEPLOYING') AND atrsetup.attribute_code NOT IN ( 'PROJECT_ID', 'TASK_ID', 'COUNTRY_OF_ORIGIN_CODE' ) AND ( atrsetup.applicability_code = 'ORA_ALL_ORGANIZATIONS' OR ( atrsetup.applicability_code IN ( 'ORA_SPECIFIC_ORGANIZATION', 'ORA_CATEGORY' ) AND EXISTS ( SELECT 1 FROM inv_attribute_applicabilities atrmaps WHERE atrmaps.inv_attribute_setup_id = atrsetup.inv_attribute_setup_id AND atrmaps.organization_id = iop.organization_id ) ) ) ) THEN 'Y' ELSE 'N' END feature_striping_attributes_enabled , nvl(iop.allow_parent_lot_flag, 'N') feature_parent_lot FROM inv_org_parameters iop WHERE EXISTS ( SELECT 1 FROM hr_org_unit_classifications_x houcx WHERE houcx.organization_id = iop.organization_id AND houcx.classification_code = 'INV' AND houcx.status = 'A' ) ) SELECT orgs_with_features.* , CASE WHEN nvl(feature_lot_uom_conv_enabled, 'N') = 'Y' OR nvl(feature_lpn_enabled, 'N') = 'Y' OR nvl(feature_striping_attributes_enabled, 'N') = 'Y' OR nvl(feature_parent_lot, 'N') = 'Y' THEN 'N' ELSE 'Y' END legacy_ui_allowed FROM orgs_with_features