You are browsing the archive for Oracle Inventory.

by oracleguru

Generate Kanban Cards

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Generate Kanban Cards
SHORT CODE: INVKBCGN
MODULE: Oracle Inventory

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

Report Parameters:

  • P_ORG_ID : The Current organization which launches the PL/SQL procedure
  • P_ITEM_LOW : Item Range – From
  • P_ITEM_HIGH : Item Range – To
  • P_SUBINV : Subinventory selected for card generation
  • P_LOCATOR_LOW : Low Range for locators selected
  • P_LOCATOR_HI : High range for locators selected
  • P_SOURCE_TYPE : The source based on replishment source
  • P_SUPPLIER_ID : Replenished by external supplier
  • P_SUPPLIER_SITE_ID : External supplier site
  • P_SOURCING_ORG_ID : Replenishment done by another organization
  • P_SOURCING_SUBINV : The subinventory from the sourcing org
  • P_SOURCING_LOC_ID : Sourcing Locator
  • P_WIP_LINE_ID : WIP Line Code
  • P_STATUS : Status assigned to a Kanban Card
  • P_PULL_SEQUENCE_ID : Kanban Pull Sequence Id
  • P_PRINT_KANBAN_CARD : Print Kanban Card? (yes/no)
  • P_REPORT_ID : Report Id

 

Tags: No Comments »

by oracleguru

View Multiple Organization Quantity Report (180 col format)

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: View Multiple Organization Quantity Report (180 col format)
SHORT CODE: INVM2MQT
MODULE: Oracle Inventory

Description: View Multiple Organization Quantity Report (180 col format)
Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_organization_id : p_organization_id
  • report id : report id
  • p_range_code : p_range_code
  • p_item_low : p_item_low
  • p_item_hi : p_item_hi
  • p_item_intransit : p_item_intransit
  • p_item_rev : p_item_rev
  • p_nettable :
  • p_asset : p_asset
  • p_cost : p_cost
  • p_consigned : p_consigned

 

Tags: No Comments »

by oracleguru

Movement Statistics Exception Report (XML)

ORACLE APPS COMMUNITY > Tutorial > Logistics & Warehouse > Oracle Inventory

 

NAME: Movement Statistics Exception Report (XML)
SHORT CODE: INVMVTEX_XML
MODULE: Oracle Inventory

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

Report Parameters:

  • p_legal_entity_id : Legal Entity Id
  • p_economic_zone_code : Economic Zone
  • p_usage_type : Usage Type
  • p_stat_type : Statistical Type
  • p_period_name : Period Name
  • p_document_source_type : Document Source Type
  • p_display_warn_flag : Display Warnings
  • DebugFlag : Debug Flag

 

Tags: No Comments »