Showing posts with label Inventory. Show all posts
Showing posts with label Inventory. Show all posts
Tuesday, May 24, 2022

Fusion: SQL: Query to Extract the Business Units and its related Inventory Organizations, Business Units and Costing Organizations

›
    SELECT hou.organization_id        , hou.name organization_name        , iop.organization_code organization_code        , lgr.ledger_id s...
Wednesday, April 13, 2022

Fusion:SCM:MFG: SQL to Validat the Componenet Issue and WO Completion transactions against Work Order

›
SELECT imt.transaction_id,iop.organization_code warehouse_code      , TO_CHAR(imt.creation_date,'DD-MON-YYYY') txn_creation_date    ...
Sunday, February 27, 2022

Oracle Fusion SQL : SQL to Extract Transfer Order details

›
SELECT d.header_number        , e.line_number        , so.organization_code source_inv_org        , do.organization_code dest_inv_org       ...

Oracle Fusion SQL: OSQL to Extract Inventory Pending Transactions (Records stuck in Oracle inventory Interface table)

›
 SELECT iop.organization_code,     iop.organization_name,     ittv.transaction_type_name,     flva.meaning transaction_action,     mti.tRANS...

Oracle Fusion: SQL to extract Inventory Organization Parameters Details

›
  SELECT a.organization_id,        a.organization_code,        g.name organization_name,        a.master_organization_id,        b.organizat...
Monday, February 21, 2022

Oralce Fusion: SQL to Get Concatenated Address example

›
Inventory Organization Location ================================= SELECT z.organization_code,        z.organization_name,        b.location_...
Wednesday, April 18, 2018

Script to get the Inventory transaction types/Source/Action Name

›
Script to get the Inventory transaction types/Source/Action Name   SELECT a.transaction_type_id        , a.transaction_type_name        ,...
Sunday, October 8, 2017

Sample script to update the Item attributes (Inventory)

›
DECLARE    CURSOR c1    IS       SELECT inventory_item_id            , segment1         FROM mtl_system_items_b        WHERE organiza...
Wednesday, October 4, 2017

Script to create New Item copying existing SKU, it's attributes and all categories and also Assign it to all Inventory Organization.

›
Please test the script first in NON PROD instance. DECLARE    k                                            NUMBER;    l_api_version    ...
Tuesday, December 15, 2015

API to get the On hand quantity details for Item in Inveontory

›
PROCEDURE get_onhand_quantities(    p_item_name              IN            VARCHAR2  , p_organziation_id        IN            NUMBER  , ...