Showing posts with label INV. Show all posts
Showing posts with label INV. Show all posts

Oracle R12 Inventory Item with HSN Code query

›
--Item Master with HSN   SELECT msi.segment1 item_code,msi.description,         primary_unit_of_measure uom,         msi.auto_lot_alpha_pref...

Oracle Inventory MTL Temporary Data Delete Script

›
--Oracle Inventory Material Transactions Temporary data Delete   --Check first  SELECT * FROM MTL_TRANSACTIONS_TEMP_ALL_V;  SELECT *   FROM ...

Oracle R12 Item Update via API

›
 Oracle R12 Inventory Item Update through API - Sample for   SHIPPABLE_ITEM_FLAG update --CREATE OR REPLACE PROCEDURE JG_ITEMS_UPDATE_API --...

Oracle EBS R12 Item Master Query

›
--Oracle EBS R12  Active  Item Master Query with Category, O rganization and Buyer SELECT msi.segment1 "Item Code",        msi.des...

Material Transactions Type wise organization and SubInventory Data

›
 --- Organization and Sub Inventory and Transactions Type wise Material Transactions data  SELECT ood.organization_code,        ood.organiza...

How to Update FIFO Layer Cost through Interface table

›
--- Perform Layer Cost Update operations via the MTL_TRANSACTIONS_INTERFACE table. -- Sample code below:   declare l_trx_id Number; begin fn...

Inventory Item assigned Organization

›
  SELECT    moa . organization_id ,  moa . inventory_item_id ,  organization_code , msi . segment1 item_code ,         organization_name ,  ...

Inventory Organization and Item attributes Query

›
 SELECT MP.ORGANIZATION_CODE,MP.ATTRIBUTE_CATEGORY,MP.ATTRIBUTE1,  MP.ATTRIBUTE2,MP.ATTRIBUTE3,MP.ATTRIBUTE4,MP.ATTRIBUTE5,MP.ATTRIBUTE6, MP...

MTL Transaction Lot number to find OPM Batch Number Query

›
SELECT gbh.batch_no  FROM gme_batch_header gbh WHERE EXISTS (SELECT 1              FROM mtl_transaction_lot_numbers mtln,mtl_lot_numbers lot...

How to Upload Item in Inventory through Interface

›
Step1: Create Staging Table. CREATE TABLE APPS.XXCONA_ITEM_UPLOAD_STG (   ITEM_NUMBER        VARCHAR2(40 BYTE),   DESCRIPTION        V...