PO Vendor Affiliated Structure Listing
Description
- Categories
- BI Publisher
- Application
- Purchasing
- Source
- Vendor Affiliated Structure Listing (XML)
- Short Name
- POXVESTR_XML
- DB package
- PO_POXVESTR_XMLP_PKG
SQL 20 lines
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' |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Title | Char | |
| Vendors From | LOV Oracle | |
| To | LOV Oracle |