INV Customer Item Commodity Codes Listing

Description

Categories
BI Publisher
Application
Inventory
Source
Customer Item Commodity Codes Listing (XML)
Short Name
INVIRCOC_XML
DB package
INV_INVIRCOC_XMLP_PKG

SQL 7 lines

SELECT 
  OOD.ORGANIZATION_NAME    ORG_NAME
FROM
  ORG_ORGANIZATION_DEFINITIONS    OOD
WHERE 
OOD.ORGANIZATION_ID = :P_ORG_ID

Parameters 3

ParameterTypeList of values SQL
OrganizationNumber
Commodity Code FromLOV Oracle
ToLOV Oracle