ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN DEBCF98A0413E9B7E05362FB0905EECDY select 1 from dual US OE Order Processing Key Indicators Imported from Concurrent Program Application: Order Entry Source: Order Processing Key Indicators Short Name: OEXOEPKI Concurrent Program 1 -30 :p_sob_id Number fnd_profile.value('SO_SET_OF_BOOKS_ID') Y US Set of Books Id Set of Books Id 2 -20 :p_organization_id Number fnd_profile.value('SO_ORGANIZATION_ID') Y US Organization Id Organization Id 3 -10 :p_item_flex_code Char fnd_profile.value('SO_ID_FLEX_CODE') Y US Item Flex Code Inventory Item Flex Code 4 10 :p_order_by LOV Oracle OE: OEXOEPKI Sort By Y select lookup_code id, meaning value, description description from so_lookups where lookup_type='OEXOEPKI ORDER BY' order by meaning select meaning from so_lookups where lookup_code = 'ORDER_TYPE' and lookup_type = 'OEXOEPKI ORDER BY' Y US Sort By Sort By 5 20 :p_order_date_low Date Y US Order Date (Low) Order Date (Low) 6 30 :p_order_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.order_date_low)) from sys.dual Y US Order Date (High) Order Date (High) 7 40 :p_order_type LOV Oracle OE: Order Type Y select order_type_id id, name value, description description from so_order_types order by name US Order Type Order Type 8 50 :p_customer LOV Oracle OE_CUSTOMER Y Y select customer_id id, customer_name value, null description from ra_customers order by customer_name US Customer Customer 9 60 :p_site_use LOV Oracle OE_SITE_USE_CODES Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SITE_USE_CODE' and lookup_code in ('BILL_TO','SHIP_TO') order by meaning US Site Use Site Use 10 70 :p_customer_site LOV Oracle OE_CUSTOMER_SITES Y select site_use_id id, address1 value, null description from ra_addresses,ra_site_uses where ra_addresses.address_id=ra_site_uses.address_id and ra_site_uses.site_use_code=:$flex$.oe_site_use_codes and ra_addresses.customer_id=:$flex$.oe_customer order by value,description US Customer Site Customer Site 11 80 :p_customer_type LOV Oracle OE_SRS_CUSTOMER_TYPE Y select lookup_code id, meaning value, description description from ar_lookups where lookup_type='CUSTOMER_TYPE' order by meaning US Customer Type Customer Type 12 90 :p_salesrep LOV Oracle OE: Salesperson Y Y select salesrep_id id, name value, null description from ra_salesreps order by name US Sales Person Sales Person 13 100 :p_sales_channel LOV Oracle OE: Sales Channel Y select lookup_code id, meaning value, null description from so_lookups where lookup_type='SALES_CHANNEL' order by meaning US Sales Channel Sales Channel 14 110 :p_item Char US Item Item 15 120 :p_item_category_set LOV Oracle OE_SRS_CAT_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by category_set_name US Item Category Set Item Category Set 16 130 :p_item_category LOV Oracle OE_SRS_ITEM_CATEGORY_ALL_SETS Y select category_id id, description value, null description from mtl_categories where category_id in( select distinct ic.category_id from mtl_item_categories ic where ic.organization_id= fnd_profile.value('SO_ORGANIZATION_ID') and ic.category_set_id=:$flex$.oe_srs_cat_set) order by value,description US Item Category Item Category