Showing posts with label SQL/PLSQL. Show all posts
Showing posts with label SQL/PLSQL. Show all posts
Thursday, June 23, 2022

FA:OM:SQL: To get the RMA Order receipt details along with the Serial numbers

›
 WITH sn_tbl as (  SELECT dha.header_id                             , dla.line_id                             , dfla.fulfill_line_id        ...
Tuesday, June 14, 2022

FA:SQL: Query to get inventory organization/inventory organization location and business unit and Legal entity

›
SELECT iod.organization_code,        iod.organization_name,        iod.business_unit_name,        iod.business_unit_id,        iod.legal_ent...
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

FA:SCM:CST: SQL to Get Item Standard Cost

›
 SELECT houft.name cost_organization_name        , esi.item_number        , csc.total_cost        , uom.uom_code        , cvu.val_unit_code ...

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, February 6, 2019

Script to Get Application user password from backend

›
--Package Specification CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARC...
Monday, December 25, 2017

Joins and Subqueries

›
This article is the second in a series that helps you build on the fundamentals you learned in the 12-part SQL 101 series in Oracle Magazin...
Tuesday, August 9, 2016

Matrix/Crosstab SQL using PIVOT functionality

›
Sample SQL's  Using Decode and aggregate functions. SELECT item      , inventory      , product_family   FROM ( SELECT msi.segmen...
Tuesday, June 28, 2016

SQL to get DB Server Details

›
SELECT (SELECT UTL_INADDR.get_host_address FROM DUAL) local_host_address      , (SELECT UTL_INADDR.get_host_name( (SELECT UTL_INADDR.get_ho...
Tuesday, June 14, 2016

Build Dynamic block for DML operations....

›
PROCEDURE execute_dml_dynamically(           p_table_name         IN VARCHAR2         , p_where_column       IN VARCHAR2         , p_whe...