PO Quality Code Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Purchasing
Source: Quality Code Listing (XML)
Short Name: POXSURQC_XML
DB package: PO_POXSURQC_XMLP_PKG
Run PO Quality Code Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   gsb.name                      c_company
,        fsp.inventory_organization_id c_organization_id
,        gsb.currency_code             GL_CURRENCY
,        gsb.chart_of_accounts_id      STRUCTURE_ACC
,        mdv.structure_id              STRUCTURE_CAT
,        mdv.category_set_id           c_category_set_id
,        flo1.meaning                  c_yes
,        flo2.meaning                  c_no
FROM     gl_sets_of_books              gsb
,        financials_system_parameters  fsp
,        mtl_default_sets_view         mdv
,        fnd_lookups                   flo1
,        fnd_lookups                   flo2
WHERE    gsb.set_of_books_id           = fsp.set_of_books_id
AND      mdv.functional_area_id        = 2
AND      flo1.lookup_type              = 'YES_NO'
AND      flo1.lookup_code              = 'Y'
AND      flo2.lookup_type              = 'YES_NO'
AND      flo2.lookup_code              = 'N'
Parameter Name SQL text Validation
Title 
 
 Char
Active/Inactive 
 
 LOV Oracle
Sort By 
 
 LOV Oracle
Download
 
Related Blitz Reports
PO Requisition Import Exceptions PO Vendor Affiliated Structure Listing PO Unit of Measure Class Listing ECC Procurement, Requisitions ECC Project Manufacturing, Procurement Activities, SQL2 PO Receiving Account Distribution CST Supply Chain Consolidated Bills of Material Cost CST Temporary Supply Chain Cost Rollup - Print CST Supply Chain Cost Rollup - Print
Blitz Report™

Blitz Report™ provides multiple benefits: