Monday, March 31, 2025

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link between inventory and general ledger for Drilldown SELECT xld.source_distribution_type, xld.accounting_line_code, xld.accounting_line_type_code, xld.line_definition_code, xld.event_class_code, xld.event_type_code, xld.rounding_class_code, xld.unrounded_entered_cr, xld.unrounded_entered_dr, xld.unrounded_accounted_cr, xld.unrounded_accounted_dr, ael.gl_sl_link_id, ael.gl_sl_link_table, GJB.NAME BATCH_NAME, gL.period_name, gl.accounted_cr, gl.accounted_dr, gl.entered_cr, gl.entered_dr, gh.je_source, gh.je_category, gh.posted_date, mta.inv_sub_ledger_id, mta.base_transaction_value, mta.currency_conversion_rate, mta.rate_or_amount, mta.currency_code, mmt.subinventory_code, TRUNC (mmt.transaction_date) transaction_date, mmt.transaction_quantity, mmt.transaction_uom, mmt.primary_quantity, mmt.actual_cost, mmt.source_code, mmt.source_line_id, mmt.rcv_transaction_id, msi.concatenated_segments item, gcc.concatenated_segments GL_ACCOUNT_STRING, ood.organization_code, ood.organization_name, mmt.transaction_id, ael.ae_header_id, ael.ae_line_num, gl.je_header_id, gl.je_line_num, gcc.code_combination_id, msi.inventory_item_id, msi.organization_id, gjb.je_batch_id FROM xla_transaction_entities_upg ent, xla_events e, xla_distribution_links xld, mtl_transaction_accounts mta, mtl_material_transactions mmt, xla_ae_headers ah, xla_ae_lines ael, gl_import_references gir, gl_je_lines gl, gl_code_combinations_kfv gcc, gl_je_headers gh, GL_JE_BATCHES GJB, mtl_system_items_kfv msi, org_organization_definitions ood WHERE mmt.transaction_id = NVL (ent.source_id_int_1, -99) AND ent.entity_code = 'MTL_ACCOUNTING_EVENTS' AND ent.application_id = 707 AND ent.entity_id = e.entity_id AND e.application_id = 707 AND e.event_id = xld.event_id AND ah.application_id = 707 AND ah.entity_id = ent.entity_id AND ah.event_id = e.event_id AND ah.ledger_id = ent.ledger_id AND ah.ae_header_id = ael.ae_header_id AND ael.application_id = 707 AND ael.ledger_id = ah.ledger_id AND ael.AE_HEADER_ID = xld.AE_HEADER_ID AND ael.AE_LINE_NUM = xld.AE_LINE_NUM AND xld.application_id = 707 AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS' AND xld.source_distribution_id_num_1 = mta.inv_sub_ledger_id AND mta.transaction_id = mmt.transaction_id AND ael.gl_sl_link_id = gir.gl_sl_link_id AND ael.gl_sl_link_table = gir.gl_sl_link_table AND gir.je_header_id = gl.je_header_id AND gir.je_line_num = gl.je_line_num AND gl.code_combination_id = gcc.code_Combination_id AND gl.je_header_id = gh.je_header_id AND GH.JE_BATCH_ID = GJB.JE_BATCH_ID AND mta.transaction_id = mmt.transaction_id AND mmt.inventory_item_id = msi.inventory_item_id AND mmt.organization_id = msi.organization_id AND msi.organization_id = ood.organization_id

Thursday, March 13, 2025

If your Chrome browser is opening new tabs with random content

If your Chrome browser is opening new tabs with random content, it may be due to adware, a browser hijacker, or an extension that you didn't intend to install. Here are some steps you can take to fix the issue: Close Unwanted Tabs: - Close the tabs that are opening randomly to avoid further distraction. Check for Suspicious Extensions: - Open Chrome and go to chrome://extensions/. - Review the list of installed extensions and remove any that you do not recognize or that look suspicious. Reset Chrome Settings: - Go to chrome://settings/reset. - Click on "Restore settings to their original defaults" and confirm the action. This will reset your startup page, new tab page, search engine, and pinned tabs. Run a Malware Scan: - Use a reputable antivirus or anti-malware tool to scan your computer for malicious software. Programs like Malwarebytes can help identify and remove unwanted software. Check your Homepage and Startup Pages: - Go to chrome://settings/onStartup. - Make sure "Open the New Tab page" or your preferred homepage is selected, and remove any other URLs that you do not recognize. Clear Browsing Data: - Go to chrome://settings/clearBrowserData. - Clear your browsing history, cookies, and cached images and files. Update Chrome: - Ensure that you are using the latest version of Chrome. Go to chrome://settings/help to check for updates. Consider a Fresh Install: - If the problem persists, you may want to uninstall Chrome and then reinstall it. This can help remove any lingering issues. If these steps do not resolve the problem, you may want to seek further assistance from a tech professional.

Saturday, May 4, 2024

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are some popular animation styles: 1. **Traditional Animation**: - Also known as cel animation, this style involves drawing each frame by hand. It's the oldest form of animation and was used in classic films like Disney's "Snow White and the Seven Dwarfs." 2. **2D Animation**: - This style has two dimensions, width and height. It's widely used for creating cartoons, marketing videos, and explainer videos. 3. **3D Animation**: - 3D animation adds depth to the images, creating a more lifelike experience. It's commonly used in movies, video games, and virtual reality. 4. **Motion Graphics**: - This style involves animating graphic elements, often used in advertisements, promotional videos, and informational content. 5. **Stop Motion**: - A technique where objects are physically manipulated and photographed frame by frame, creating the illusion of movement when the series of frames is played as a continuous sequence. 6. **Typography Animation**: - This style focuses on animating text to express ideas or convey messages, often used in title sequences and lyric videos. 7. **Clay Animation (Claymation)**: - A form of stop motion that uses malleable clay figures which are reshaped and moved for each frame. 8. **Cut-out Animation**: - Involves characters and backgrounds cut from materials like paper, which are then animated frame by frame. 9. **Rotoscope Animation**: - A technique where animators trace over live-action footage frame by frame for realistic movements. 10. **Experimental Animation**: - This style encompasses a wide range of non-traditional techniques, often pushing the boundaries of visual storytelling. Each style has its own unique charm and applications, and many animators blend different styles to create something truly unique¹²⁴⁵. Whether you're looking to create something whimsical, realistic, or somewhere in between, there's an animation style that can bring your ideas to life! Source: Conversation with Bing, 4/5/2024 (1) 31 Types of Animation Styles [Examples & Sources] - Yans Media. https://www.yansmedia.com/blog/types-of-animation-styles-and-techniques. (2) Types of Animation — Styles, Genres & Techniques - StudioBinder. https://www.studiobinder.com/blog/types-of-animation-styles/. (3) 10 Types of Animations [With inspiring examples]. https://www.animaker.com/blog/10-types-of-animations/. (4) What Are The 5 Main Types of Animation? (2024 Guide). https://academyofanimatedart.com/types-of-animation/. (5) What Are The 5 Main Types of Animation? (2024 Guide). https://bing.com/search?q=popular+animation+styles. (6) en.wikipedia.org. https://en.wikipedia.org/wiki/Animation.

How to convert normal video to animation video

Certainly! There are several tools and software options available to convert normal videos into animated videos. Here are some popular choices: 1. **Media.io Video Cartoonizer**: - This online browser-based tool allows you to create cartoons from videos instantly and for free. It's easy to use and doesn't require any software download. - **How to use**: 1. Launch the **Media.io AI Restyle** in your browser. 2. Select your preferred cartoon template from options like K-pop, Cyberpunk, Fantasy, Disney, Graffiti, and other trending effects. 3. Upload your video file, and the AI animation video maker will automatically convert your video into a cartoon. 4. Download the resulting video with the cartoon filter applied⁴. 2. **AILab Video Cartoonizer**: - AILab's video cartoonizer can transform real-life videos into cartoons instantly with just a few clicks. - **How to use**: 1. Upload your video file to the AILab platform. 2. The video cartoonizer will automatically create a cartoon-style video. 3. You can customize the cartoon level and add different filters and styles. 4. Download the cartoonized video⁵. 3. **Adobe Animate**: - Adobe Animate is a powerful tool for creating 2D animations. While it's not free, it offers top-notch video-to-animation conversion capabilities. 4. **Adobe After Effects**: - Although primarily used for visual effects, Adobe After Effects can also be used to convert videos into anime-style animations. 5. **AKVIS Sketch**: - AKVIS Sketch provides batch processing for video cartoonization. It's a versatile tool for creating artistic effects. 6. **PowToon**: - PowToon is an online platform that specializes in creating animated presentations. While it's not specifically for video cartoonization, it can be used creatively to achieve cartoon effects. Remember that each tool has its own features and limitations, so choose the one that best suits your needs and preferences. Whether you're a professional animator or just experimenting with creative videos, these tools can help you achieve impressive results! 🎥🎨⁶⁷. Source: Conversation with Bing, 4/5/2024 (1) Free Video Cartoonizer - Media.io. https://www.media.io/video-cartoonizer.html. (2) Turn Video Into Cartoon Instantly And Free - AILab Video Cartoonizer. https://ailab.wondershare.com/tools/video-cartoonizer.html. (3) Best Video Cartoonizer to Convert Your Video to Animation - Windows Report. https://windowsreport.com/video-cartoonizer-software/. (4) 11 Best Video Cartoonizer Software in 2024 - FixThePhoto.com. https://fixthephoto.com/best-video-cartoonizer-software.html. (5) Convert Any Video Into Animation With Ai | Video To Animation Ai | Ai Video Generator | Ai Animation. https://www.youtube.com/watch?v=7MrdY96bJ0U. (6) 2 Free Ways To Turn Any Video Into Animation With Ai | Free Video To Animation Ai. https://www.youtube.com/watch?v=_gaFl7aFrUM. (7) Using A.I to Convert Real Footage To Animation | Computer Generated Cartoonization. https://www.youtube.com/watch?v=n5DZFbQTOus.

Thursday, March 30, 2023

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, improving the quality of the content, and promoting the blog to attract more readers. Here are some suggestions that may help: Optimize your website's technical infrastructure: 1 Use a fast and reliable web hosting service. 2 Optimize your images and other media files to reduce page load times. 3 Use caching and other performance optimization tools to speed up your website. 4 Ensure that your website is mobile-friendly and responsive. 5 Focus on high-quality content: 6 Make sure your content is well-written, engaging, and informative. Use headlines and subheadings to make your content easy to read and navigate. Incorporate multimedia elements such as images, videos, and infographics to make your content more visually appealing. Research your topic thoroughly and provide accurate information. Write for your audience, not for search engines. Promote your blog: 1 Use social media to promote your blog and engage with your audience. 2 Participate in online communities related to your blog's topic and share your content with them. 3 Build an email list and use it to keep your subscribers updated on new content. 4 Consider guest blogging on other websites to gain exposure and backlinks to your blog. 5 Use search engine optimization (SEO) techniques to improve your blog's visibility in search engine results. Measure and analyze your performance: 1 Use analytics tools to track your website's traffic and user behavior. 2 Monitor your website's search engine rankings and use this information to make improvements. 3 Test different strategies and see what works best for your audience. 4 continuously monitor and adjust your approach to ensure that you are meeting your goals.

Sunday, October 9, 2022

Query to Get Profile value at any level

Query to Get Profile value at any level  

SELECT 

  distinct pot.user_profile_option_name Profile, 

  DECODE (

    a.profile_option_value, '1', '1 (may be "Yes")', 

    '2', '2 (may be "No")', a.profile_option_value

  ) Value, 

  DECODE (

    a.level_id, 10001, 'Site', 10002, 'Application', 

    10003, 'Responsibility', 10004, 'User', 

    '????'

  ) Level_identifier, 

  DECODE (

    a.level_id, 10002, e.application_name, 

    10003, c.responsibility_name, 10004, 

    d.user_name, '-'

  ) Level_Name 

FROM 

  applsys.fnd_application_tl e, 

  applsys.fnd_user d, 

  applsys.fnd_responsibility_tl c, 

  applsys.fnd_profile_option_values a, 

  applsys.fnd_profile_options b, 

  applsys.fnd_profile_options_tl pot 

WHERE 

  1 = 1 

  AND UPPER (pot.user_profile_option_name) LIKE UPPER ('%&v_profile%') 

  AND pot.profile_option_name = b.profile_option_name 

  AND pot.language = userenv('lang') 

  AND b.application_id = a.application_id(+) 

  AND b.profile_option_id = a.profile_option_id(+) 

  AND a.level_value = c.responsibility_id(+) 

  AND a.level_value = d.user_id(+) 

  AND a.level_value = e.application_id(+) 

  AND e.language(+) = userenv('lang') 

  AND (

    UPPER (e.application_name) LIKE UPPER ('%&appname_respname_username%') 

    OR UPPER (c.responsibility_name) LIKE UPPER (

      '%&&appname_respname_username%'

    ) 

    OR UPPER (d.user_name) LIKE UPPER (

      '%&&appname_respname_username%'

    )

  ) 

ORDER BY 

  Profile, 

  Level_identifier, 

  Level_name, 

  Value


Bom Explosion Query

Below query can be handy to explode and Query BOM Details

SELECT 

  DISTINCT LPAD (' ', LEVEL * 2) || LEVEL order_level, 

  msib.segment1 assembly_item, 

  msib.description assembly_description, 

  msib.inventory_item_status_code assembly_item_status, 

  SYS_CONNECT_BY_PATH (msib2.segment1, '/') PATH, 

  msib2.segment1 AS component_item, 

  msib2.description component_item_description, 

  msib2.inventory_item_status_code component_item_status, 

  bic.item_num, 

  bic.operation_seq_num, 

  bic.component_quantity 

FROM 

  bom.bom_components_b bic, 

  bom.bom_structures_b bom, 

  inv.mtl_system_items_b msib, 

  inv.mtl_system_items_b msib2, 

  mtl_parameters mp 

WHERE 

  1 = 1 

  AND bic.bill_sequence_id = bom.bill_sequence_id 

  AND SYSDATE BETWEEN bic.effectivity_date 

  AND Nvl(bic.disable_date, SYSDATE) 

  AND bom.assembly_item_id = msib.inventory_item_id 

  AND bom.organization_id = msib.organization_id 

  AND bic.component_item_id = msib2.inventory_item_id 

  AND bom.organization_id = msib2.organization_id 

  AND mp.organization_id = msib.organization_id 

  AND mp.organization_code = : p_org_code 

  /* organization here */

  AND bom.alternate_bom_designator IS NULL START WITH msib.segment1 = : p_item_number 

  /*  component item to be used here */

  CONNECT BY NOCYCLE PRIOR bic.component_item_id = msib.inventory_item_id 

ORDER BY 

  PATH