PO Quality Code Listing

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source: Quality Code Listing (XML)
Short Name: POXSURQC_XML
DB package: PO_POXSURQC_XMLP_PKG
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
Sort By
 
LOV Oracle
Active/Inactive
 
LOV Oracle
Title
 
Ask a question