Hi! About note How to Setup Pick Release Rules to be Org or User Specific (Doc ID 742771.1)

Hi!

I tried to paste the SQL for  12.1 version on Argument field To create Record Group from Query, but doesn't let me do it?

Do you know why? There is a size limit in this field? So, why recomend the note use that sql?

Regards

This is the SQL

SELECT WSH.PICKING_RULE_NAME,WSH.BACKORDERS_ONLY_FLAG ,WSH.backorders ,WSH.SHIPMENT_PRIORITY ,WSH.SHIPMENT_PRIORITY_CODE ,WSH.ORGANIZATION_ID,WSH.ORG_ID,WSH.WAREHOUSE_ID_LOV,WSH.WAREHOUSE,WSH.WAREHOUSE_CODE ,WSH.RESERVATION_STAR ,WSH.EXISTING_RSVS_ONLY_FLAG ,WSH.SHIP_METHOD_CODE ,WSH.FROM_SCHEDULED_SHIP_DATE,WSH.TO_SCHEDULED_SHIP_DATE,WSH.FROM_REQUESTED_DATE,WSH.TO_REQUESTED_DATE,WSH.ORDER_TYPE ,WSH.ORDER_TYPE_ID ,WSH.ORDER_NUMBER,WSH.ORDER_HEADER_ID ,WSH.SHIP_SET_NUMBER,WSH.INVENTORY_ITEM_ID ,WSH.ITEM_DESCRIPTION,WSH.CUSTOMER_NAME ,WSH.OLD_CUSTOMER_NAME ,WSH.CUSTOMER_ID ,WSH.SHIP_TO_LOCATION,WSH.SHIP_TO_LOCATION_ID ,WSH.INCLUDE_PLANNED_LINES,WSH.AUTOCREATE_DELIVERY_FLAG,WSH.PICK_GROUPING_RULE_NAME ,WSH.PICK_SEQ_RULE_NAME ,WSH.TASK_ID,WSH.PROJECT_ID,WSH.AUTODETAIL_PR_FLAG,WSH.AUTO_PICK_CONFIRM_FLAG,WSH.SHIP_SET_NUMBER SHIP_SET_ID,WSH.SHIP_FROM_LOCATION,WSH.SHIP_FROM_LOCATION_ID,WSH.DOCUMENT_SET_ID ,WSH.DOC_NAME,WSH.PICK_FROM_SUBINVENTORY ,WSH.PICK_FROM_LOCATOR_ID,WSH.PICK_FROM_LOCATOR,WSH.DEFAULT_STAGE_SUBINVENTORY,WSH.DEFAULT_STAGE_LOCATOR_ID,WSH.DEFAULT_STAGE_LOCATOR,WSH.SHIP_METHOD_MEANING,WSH.AUTOPACK_FLAG,WSH.AUTOPACK_LEVEL,WSH.SHIP_CONFIRM_RULE_ID,WSH.SHIP_CONFIRM_RULE_NAME,WSH.TASK_PLANNING_FLAG,WSH.REGION_ID,WSH.zone_id,WSH.ac_delivery_criteria,WSH.rel_subinventory,WSH.category_set_id,WSH.category_id,WSH.sch_start_days,WSH.sch_end_days,WSH.sch_start_hours,WSH.sch_end_hours,WSH.req_start_days,WSH.req_end_days,WSH.req_start_hours,WSH.req_end_hours,WSH.append_flag,WSH.task_priority,WSH.allocation_method,WSH.crossdock_criteria_id,WSH.dynamic_replenishment_flag,WSH.client_id ,WSH.client_name FROM( SELECT WPR.NAME PICKING_RULE_NAME,WPR.BACKORDERS_ONLY_FLAG ,decode(S2.MEANING, 'Exclude','Unreleased' ,'Include','All', 'Only', 'Backordered') backorders ,S1.MEANING SHIPMENT_PRIORITY ,WPR.SHIPMENT_PRIORITY_CODE ,WPR.ORGANIZATION_ID,WPR.ORGANIZATION_ID org_id,WPR.ORGANIZATION_ID warehouse_id_lov,H_ORG_TL.NAME WAREHOUSE,ORG.ORGANIZATION_CODE WAREHOUSE_CODE ,DECODE(WPR.EXISTING_RSVS_ONLY_FLAG, 'Y','*', NULL)RESERVATION_STAR ,WPR.EXISTING_RSVS_ONLY_FLAG ,WPR.SHIP_METHOD_CODE ,WPR.FROM_SCHEDULED_SHIP_DATE,WPR.TO_SCHEDULED_SHIP_DATE,WPR.FROM_REQUESTED_DATE,WPR.TO_REQUESTED_DATE,OTT.NAME ORDER_TYPE ,WPR.ORDER_TYPE_ID ,to_char(H.ORDER_NUMBER) ORDER_NUMBER,WPR.ORDER_HEADER_ID ,OS.SET_NAME SHIP_SET_NUMBER,WPR.INVENTORY_ITEM_ID ,msi.description item_description,substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME ,substrb(PARTY.PARTY_NAME,1,50) OLD_CUSTOMER_NAME ,WPR.CUSTOMER_ID ,WHZL.UI_LOCATION_CODE SHIP_TO_LOCATION,WPR.SHIP_TO_LOCATION_ID ,WPR.INCLUDE_PLANNED_LINES,WPR.AUTOCREATE_DELIVERY_FLAG,PGR.NAME PICK_GROUPING_RULE_NAME ,RSQR.NAME PICK_SEQ_RULE_NAME ,WPR.TASK_ID,WPR.PROJECT_ID,WPR.AUTODETAIL_PR_FLAG,WPR.AUTO_PICK_CONFIRM_FLAG,WPR.SHIP_SET_NUMBER SHIP_SET_ID,WHRL.UI_LOCATION_CODE SHIP_FROM_LOCATION,WPR.SHIP_FROM_LOCATION_ID,WPR.DOCUMENT_SET_ID ,WRS.NAME DOC_NAME,WPR.PICK_FROM_SUBINVENTORY ,WPR.PICK_FROM_LOCATOR_ID,NULL pick_from_locator,WPR.DEFAULT_STAGE_SUBINVENTORY,WPR.DEFAULT_STAGE_LOCATOR_ID,NULL default_stage_locator ,SM.meaning ship_method_meaning,WPR.AUTOPACK_FLAG,WPR.AUTOPACK_LEVEL,WPR.SHIP_CONFIRM_RULE_ID,WSCR.NAME ship_confirm_rule_name,WPR.TASK_PLANNING_FLAG,WPR.region_id,WPR.zone_id,WPR.ac_delivery_criteria,WPR.rel_subinventory,WPR.category_set_id,WPR.category_id,WPR.sch_start_days,WPR.sch_end_days,WPR.sch_start_hours,WPR.sch_end_hours,WPR.req_start_days,WPR.req_end_days,WPR.req_start_hours,WPR.req_end_hours,WPR.append_flag,WPR.task_priority,WPR.allocation_method,WPR.crossdock_criteria_id,WPR.dynamic_replenishment_flag,WPR.Client_id client_id,MCPV.CLIENT_NAME client_name FROM WSH_PICKING_RULES WPR,MTL_PARAMETERS ORG,HR_ALL_ORGANIZATION_UNITS_TL H_ORG_TL,HZ_PARTIES PARTY,HZ_CUST_ACCOUNTS CUST_ACCT,FND_LOOKUP_VALUES S1,FND_LOOKUP_VALUES S2,OE_SETS OS,WSH_PICK_GROUPING_RULES PGR,WSH_PICK_SEQUENCE_RULES RSQR,OE_TRANSACTION_TYPES_TL OTT,OE_TRANSACTION_TYPES_ALL OTB ,OE_ORDER_HEADERS_ALL H,WSH_LOCATIONS WHRL,WSH_LOCATIONS WHZL,WSH_REPORT_SETS WRS,WSH_SHIP_CONFIRM_RULES WSCR,mtl_system_items_b msi