INV Freight carrier listing

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
Inventory
Source
Freight carrier listing (XML)
Short Name
INVSRFRT_XML
DB package
INV_INVSRFRT_XMLP_PKG
Imported from BI Publisher
Freight carrier listing

SQL 12 lines

select o.organization_name             org_name,
       o.chart_of_accounts_id              chart_id,
       g.currency_code              currency_code,
       c.precision		std_precision,
       nvl(c.extended_precision,c.precision)	ext_precision
from   org_organization_definitions o,
          gl_sets_of_books                g,
          fnd_currencies                    c
where  o.organization_id = :P_org_id
and      o.set_of_books_id = g.set_of_books_id
and      g.currency_code  = c.currency_code (+)