AP Payables Lookup Listing- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Payables
- Source
- Payables Lookup Listing (XML) - Not Supported: Reserved For Future Use
- Short Name
- APXQCQCL_XML
- DB package
- AP_APXQCQCL_XMLP_PKG
Imported from BI Publisher
Payables Lookup Listing
Payables Lookup Listing
SQL 46 lines
SELECT lc2.displayed_field C_PRODUCT, DECODE (:p_sort_option,'Type,QuickCode', lc.lookup_type , 'No order column') C_SORT_1, UPPER(lc.lookup_code) C_SORT_2, lc.lookup_code C_LOOKUP_CODE, lc.lookup_type C_LOOKUP_TYPE, lc.displayed_field C_DISPLAYED_FIELD, lc.description C_DESCRIPTION, lc.inactive_date C_INACTIVE_DATE FROM ap_lookup_codes lc, ap_lookup_codes lc2, ap_lookup_types lt WHERE DECODE(Upper(:p_active_type),'ACTIVE', nvl(lc.inactive_date, :lp_effective_date + 1) - :lp_effective_date, 'INACTIVE', :lp_effective_date +1 - nvl(lc.inactive_date, :lp_effective_date + 1), 'BOTH',1, NULL,1) > 0 AND lc2.lookup_type = 'PRODUCT_NAMES' AND lc2.lookup_code = 'AP' AND lc.lookup_type = lt.lookup_type AND lt.user_updatable_flag = 'Y' UNION SELECT lc2.displayed_field C_PRODUCT, DECODE (:p_sort_option,'Type,QuickCode', lc.lookup_type , 'No order column') C_SORT_1, UPPER(lc.lookup_code) C_SORT_2, lc.lookup_code C_LOOKUP_CODE, lc.lookup_type C_LOOKUP_TYPE, lc.displayed_field C_DISPLAYED_FIELD, lc.description C_DESCRIPTION, lc.inactive_date C_INACTIVE_DATE FROM po_lookup_codes lc, ap_lookup_codes lc2, po_lookup_types lt WHERE DECODE(Upper(:p_active_type),'ACTIVE', nvl(lc.inactive_date, :lp_effective_date + 1) - :lp_effective_date, 'INACTIVE', :lp_effective_date +1 - nvl(lc.inactive_date, :lp_effective_date + 1), 'BOTH',1, NULL,1) > 0 AND lc2.lookup_type = 'PRODUCT_NAMES' AND lc2.lookup_code = 'PO' AND lc.lookup_type = lt.lookup_type AND lt.user_updatable_flag = 'U' ORDER BY 1, 2, 3, 4, 5, 6, 7 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Sort QuickCodes By | LOV Oracle | |
| Include Active/Inactive Codes | LOV Oracle | |
| Effective Date | Date |