You are browsing the archive for Oracle Process Manufacturing Inventory.

Inventory Transfer Report

 

NAME: Inventory Transfer Report
SHORT CODE: CMXFER01
MODULE: Oracle Process Manufacturing Inventory

Description: Inventory Transfer Report
Navigation: Oracle Process Manufacturing Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • From Actual Release Date : From Actual Release Date
  • To Actual Release Date : To Actual Release Date
  • From Scheduled Release Date : From Scheduled Release Date
  • To Scheduled Release Date : To Scheduled Release Date
  • From Actual Receive Date : From Actual Receive Date
  • To Actual Receive Date : To Actual Receive Date
  • From Cancel Date : From Cancel Date
  • To Cancel Date : To Cancel Date
  • From Source Warehouse : From Source Warehouse
  • To Source Warehouse : To Source Warehouse
  • From Destination Warehouse : From Destination Warehouse
  • To Destination Warehouse : To Destination Warehouse
  • From Transfer Status : From Transfer Status
  • To Transfer Status : To Transfer Status
  • User Id :

 

Inventory Valuation Report

 

NAME: Inventory Valuation Report
SHORT CODE: CMR02
MODULE: Oracle Process Manufacturing Inventory

Description: Inventory Valuation Report of OPM IC
Navigation: Oracle Process Manufacturing Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P Orgn : P Orgn
  • From Item : From Item
  • To Item : To Item
  • From Whse : From Whse
  • To Whse : To Whse
  • Current Balance : Current Balance
  • FISCAL YEAR : Fiscal Year
  • Period : Period
  • Non Block Sql : Non Block Sql
  • P_CURRENCY_CODE : Report Currency
  • P_EXCHANGE_RATE : Exchange Rate

 

Oracle Process Manufacturing Inventory Tables

Oracle Process Manufacturing Inventory – List of database tables

  • BISOPM_ONHANDSALE_SUM
  • BIS_OPM_PROD_SUM
  • GMI_AUTO_ALLOCATION_BATCH
  • GMI_CATEGORY_SETS
  • GMI_CLOS_WAREHOUSES
  • GMI_DISCRETE_TRANSFERS
  • GMI_DISCRETE_TRANSFER_LINES
  • GMI_DISCRETE_TRANSFER_LOTS
  • GMI_ITEMS_XML_INTERFACE
  • GMI_ITEM_CATEGORIES
  • GMI_ITEM_CONV_AUDIT
  • GMI_ITEM_CONV_AUDIT_DETAILS
  • GMI_ITEM_ORGANIZATIONS
  • GMI_LOTS_CONV_XML_INTERFACE
  • GMI_LOTS_XML_INTERFACE
  • GMI_LOT_TRACE
  • GMI_MASSTRANS_CTL
  • GMI_MIGRATION_PARAMETERS
  • GMI_OBSOLETE_ITEM_COLUMNS
  • GMI_QUANTITY_XML_INTERFACE
  • GMI_SUBLOT_GENERATE
  • GMI_TRAN_TMP
  • IC_ADJS_JNL
  • IC_ALLC_CLS
  • IC_ALOT_PRM
  • IC_CLDR_DTL
  • IC_CLDR_HDR
  • IC_CLDR_HDR_B
  • IC_CLDR_HDR_TL
  • IC_COMD_CDS
  • IC_COST_CLS
  • IC_CRUL_CLS
  • IC_CTMS_CLS
  • IC_CYCL_ADT
  • IC_CYCL_DTL
  • IC_CYCL_ERR
  • IC_CYCL_HDR
  • IC_CYCL_MSC
  • IC_DECM_MST
  • IC_FRGT_CLS
  • IC_GLED_CLS
  • IC_INVN_CLS
  • IC_INVN_TYP
  • IC_ITEM_CDT
  • IC_ITEM_CNV
  • IC_ITEM_CPG
  • IC_ITEM_HIERARCHY
  • IC_ITEM_MST
  • IC_ITEM_MST_B
  • IC_ITEM_MST_B_MIG
  • IC_ITEM_MST_TL
  • IC_ITEM_WHS
  • IC_JRNL_MST
  • IC_LOCT_INV
  • IC_LOCT_MST
  • IC_LOTS_CPG
  • IC_LOTS_MST
  • IC_LOTS_MST_MIG
  • IC_LOTS_STS
  • IC_PERD_BAL
  • IC_PHYS_CNT
  • IC_PHYS_ERR
  • IC_PKGS_MST
  • IC_PLNT_INV
  • IC_PRCE_CLS
  • IC_PRCH_CLS
  • IC_PURG_PRM
  • IC_RANK_MST
  • IC_SALE_CLS
  • IC_SHIP_CLS
  • IC_STAT_RPT
  • IC_STOR_CLS
  • IC_SUMM_INV
  • IC_TAXN_ASC
  • IC_TAXN_CLS
  • IC_TEXT_HDR
  • IC_TEXT_TBL_TL
  • IC_TRAN_ARC
  • IC_TRAN_CMP
  • IC_TRAN_PND
  • IC_TXN_REQUEST_HEADERS
  • IC_TXN_REQUEST_LINES
  • IC_WHSE_INV
  • IC_WHSE_MST
  • IC_WHSE_REL
  • IC_WHSE_STS
  • IC_XFER_MST
  • IN_ADDR_MST
  • IN_CTRY_MST
  • IN_ITEM_MST
  • IN_REGN_MST
  • IN_STAT_CTL
  • IN_STAT_DTL
  • IN_STAT_HDR
  • IN_STAT_MSG
  • IN_TEXT_HDR
  • IN_TEXT_TBL_TL
  • IN_TOFD_MST
  • SY_WF_ITEM_ROLES