eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSHFV_PICKING_RULES

Source

View Text - Preformatted


SELECT WPR.PICKING_RULE_ID, WPR.NAME ,WPR.DOCUMENT_SET_ID ,WRS.NAME DOCUMENT_SET_NAME ,LOC1.SOURCE_LOCATION_ID, LOC1.UI_LOCATION_CODE SHIP_FROM_LOCATION , WPR.ORGANIZATION_ID , WPR.DEFAULT_STAGE_SUBINVENTORY , SUBINV1.DESCRIPTION DEFAULT_STAGE_DESCRIPTION , '_KF:INV:MTLL:MIL1' , WPR.PICK_FROM_SUBINVENTORY , SUBINV2.DESCRIPTION PICK_FROM_DESCRIPTION , '_KF:INV:MTLL:MIL2' ,'_LA:WPR.AUTODETAIL_PR_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,'_LA:WPR.AUTO_PICK_CONFIRM_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,LOC.SOURCE_LOCATION_ID, LOC.UI_LOCATION_CODE SHIP_TO_LOCATION , WPR.CARRIER_ID , WPR.PICK_GROUPING_RULE_ID ,WPGR.NAME PICK_GROUPING_RULE_NAME , WPR.PICK_SEQUENCE_RULE_ID ,WPSR.NAME PICK_SEQUENCE_RULE_NAME ,'_LA:WPR.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING' , WPR.PROJECT_ID ,PROJ.NAME PROJECT_NAME , WPR.TASK_ID ,PROJTASK.TASK_NUMBER ,WPR.CREATION_DATE , WPR.CREATED_BY , WPR.LAST_UPDATE_DATE , WPR.LAST_UPDATED_BY , WPR.BACKORDERS_ONLY_FLAG , '_LA:WPR.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING', WPR.ORDER_HEADER_ID , OOHA.ORDER_NUMBER, WPR.ORDER_TYPE_ID , OTTA.TRANSACTION_TYPE_CODE ORDER_TYPE_CODE, WPR.CUSTOMER_ID , PARTY.PARTY_NAME CUSTOMER_NAME, '_LA:WPR.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING', WPR.SUBINVENTORY , SUBINV3.DESCRIPTION SUBINV_DESCRIPTION, WPR.SHIP_SET_NUMBER , WPR.FROM_REQUESTED_DATE, WPR.TO_REQUESTED_DATE, WPR.FROM_SCHEDULED_SHIP_DATE , WPR.TO_SCHEDULED_SHIP_DATE , WPR.START_DATE_ACTIVE , WPR.END_DATE_ACTIVE , '_LA:WPR.EXISTING_RSVS_ONLY_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPR.PARTIAL_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPR.AUTOCREATE_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_DF:WSH:WSH_PICKING_RULES:WPR', WPR.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI' FROM WSH_PICKING_RULES WPR, MTL_SYSTEM_ITEMS MSI, WSH_REPORT_SETS WRS,WSH_LOCATIONS LOC, WSH_LOCATIONS LOC1, OE_ORDER_HEADERS_ALL OOHA, MTL_SECONDARY_INVENTORIES SUBINV1, MTL_SECONDARY_INVENTORIES SUBINV2, MTL_SECONDARY_INVENTORIES SUBINV3, WSH_PICK_SEQUENCE_RULES WPSR, WSH_PICK_GROUPING_RULES WPGR, PA_PROJECTS_ALL PROJ , PA_TASKS PROJTASK, HZ_CUST_ACCOUNTS CUSTACCT, HZ_PARTIES PARTY, OE_TRANSACTION_TYPES_ALL OTTA, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2 WHERE WPR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND WPR.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+) AND '_SEC:WPR.ORGANIZATION_ID' is not null AND WPR.DOCUMENT_SET_ID=WRS.REPORT_SET_ID(+) AND WPR.SHIP_TO_LOCATION_ID = LOC.WSH_LOCATION_ID(+) AND WPR.SHIP_FROM_LOCATION_ID = LOC1.WSH_LOCATION_ID(+) AND WPR.ORDER_HEADER_ID=OOHA.HEADER_ID(+) AND WPR.DEFAULT_STAGE_SUBINVENTORY = SUBINV1.SECONDARY_INVENTORY_NAME(+) AND WPR.ORGANIZATION_ID = SUBINV1.ORGANIZATION_ID(+) AND WPR.PICK_FROM_SUBINVENTORY = SUBINV2.SECONDARY_INVENTORY_NAME(+) AND WPR.ORGANIZATION_ID = SUBINV2.ORGANIZATION_ID(+) AND WPR.SUBINVENTORY = SUBINV3.SECONDARY_INVENTORY_NAME(+) AND WPR.ORGANIZATION_ID = SUBINV3.ORGANIZATION_ID(+) AND WPR.PICK_SEQUENCE_RULE_ID=WPSR.PICK_SEQUENCE_RULE_ID(+) AND WPR.PICK_GROUPING_RULE_ID=WPGR.PICK_GROUPING_RULE_ID(+) AND WPR.PROJECT_ID = PROJ.PROJECT_ID(+) AND WPR.TASK_ID = PROJTASK.TASK_ID(+) AND WPR.CUSTOMER_ID = CUSTACCT.CUST_ACCOUNT_ID(+) AND CUSTACCT.PARTY_ID = PARTY.PARTY_ID(+) AND WPR.ORDER_TYPE_ID=OTTA.TRANSACTION_TYPE_ID(+) AND WPR.DEFAULT_STAGE_LOCATOR_ID=MIL1.INVENTORY_LOCATION_ID(+) AND WPR.ORGANIZATION_ID=MIL1.ORGANIZATION_ID(+) AND WPR.PICK_FROM_LOCATOR_ID=MIL2.INVENTORY_LOCATION_ID(+) AND WPR.ORGANIZATION_ID=MIL2.ORGANIZATION_ID(+) with read only

View Text - HTML Formatted

SELECT WPR.PICKING_RULE_ID
, WPR.NAME
, WPR.DOCUMENT_SET_ID
, WRS.NAME DOCUMENT_SET_NAME
, LOC1.SOURCE_LOCATION_ID
, LOC1.UI_LOCATION_CODE SHIP_FROM_LOCATION
, WPR.ORGANIZATION_ID
, WPR.DEFAULT_STAGE_SUBINVENTORY
, SUBINV1.DESCRIPTION DEFAULT_STAGE_DESCRIPTION
, '_KF:INV:MTLL:MIL1'
, WPR.PICK_FROM_SUBINVENTORY
, SUBINV2.DESCRIPTION PICK_FROM_DESCRIPTION
, '_KF:INV:MTLL:MIL2'
, '_LA:WPR.AUTODETAIL_PR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPR.AUTO_PICK_CONFIRM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, LOC.SOURCE_LOCATION_ID
, LOC.UI_LOCATION_CODE SHIP_TO_LOCATION
, WPR.CARRIER_ID
, WPR.PICK_GROUPING_RULE_ID
, WPGR.NAME PICK_GROUPING_RULE_NAME
, WPR.PICK_SEQUENCE_RULE_ID
, WPSR.NAME PICK_SEQUENCE_RULE_NAME
, '_LA:WPR.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING'
, WPR.PROJECT_ID
, PROJ.NAME PROJECT_NAME
, WPR.TASK_ID
, PROJTASK.TASK_NUMBER
, WPR.CREATION_DATE
, WPR.CREATED_BY
, WPR.LAST_UPDATE_DATE
, WPR.LAST_UPDATED_BY
, WPR.BACKORDERS_ONLY_FLAG
, '_LA:WPR.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING'
, WPR.ORDER_HEADER_ID
, OOHA.ORDER_NUMBER
, WPR.ORDER_TYPE_ID
, OTTA.TRANSACTION_TYPE_CODE ORDER_TYPE_CODE
, WPR.CUSTOMER_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, '_LA:WPR.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WPR.SUBINVENTORY
, SUBINV3.DESCRIPTION SUBINV_DESCRIPTION
, WPR.SHIP_SET_NUMBER
, WPR.FROM_REQUESTED_DATE
, WPR.TO_REQUESTED_DATE
, WPR.FROM_SCHEDULED_SHIP_DATE
, WPR.TO_SCHEDULED_SHIP_DATE
, WPR.START_DATE_ACTIVE
, WPR.END_DATE_ACTIVE
, '_LA:WPR.EXISTING_RSVS_ONLY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPR.PARTIAL_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPR.AUTOCREATE_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:WSH:WSH_PICKING_RULES:WPR'
, WPR.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
FROM WSH_PICKING_RULES WPR
, MTL_SYSTEM_ITEMS MSI
, WSH_REPORT_SETS WRS
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, OE_ORDER_HEADERS_ALL OOHA
, MTL_SECONDARY_INVENTORIES SUBINV1
, MTL_SECONDARY_INVENTORIES SUBINV2
, MTL_SECONDARY_INVENTORIES SUBINV3
, WSH_PICK_SEQUENCE_RULES WPSR
, WSH_PICK_GROUPING_RULES WPGR
, PA_PROJECTS_ALL PROJ
, PA_TASKS PROJTASK
, HZ_CUST_ACCOUNTS CUSTACCT
, HZ_PARTIES PARTY
, OE_TRANSACTION_TYPES_ALL OTTA
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
WHERE WPR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WPR.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND '_SEC:WPR.ORGANIZATION_ID' IS NOT NULL
AND WPR.DOCUMENT_SET_ID=WRS.REPORT_SET_ID(+)
AND WPR.SHIP_TO_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND WPR.SHIP_FROM_LOCATION_ID = LOC1.WSH_LOCATION_ID(+)
AND WPR.ORDER_HEADER_ID=OOHA.HEADER_ID(+)
AND WPR.DEFAULT_STAGE_SUBINVENTORY = SUBINV1.SECONDARY_INVENTORY_NAME(+)
AND WPR.ORGANIZATION_ID = SUBINV1.ORGANIZATION_ID(+)
AND WPR.PICK_FROM_SUBINVENTORY = SUBINV2.SECONDARY_INVENTORY_NAME(+)
AND WPR.ORGANIZATION_ID = SUBINV2.ORGANIZATION_ID(+)
AND WPR.SUBINVENTORY = SUBINV3.SECONDARY_INVENTORY_NAME(+)
AND WPR.ORGANIZATION_ID = SUBINV3.ORGANIZATION_ID(+)
AND WPR.PICK_SEQUENCE_RULE_ID=WPSR.PICK_SEQUENCE_RULE_ID(+)
AND WPR.PICK_GROUPING_RULE_ID=WPGR.PICK_GROUPING_RULE_ID(+)
AND WPR.PROJECT_ID = PROJ.PROJECT_ID(+)
AND WPR.TASK_ID = PROJTASK.TASK_ID(+)
AND WPR.CUSTOMER_ID = CUSTACCT.CUST_ACCOUNT_ID(+)
AND CUSTACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND WPR.ORDER_TYPE_ID=OTTA.TRANSACTION_TYPE_ID(+)
AND WPR.DEFAULT_STAGE_LOCATOR_ID=MIL1.INVENTORY_LOCATION_ID(+)
AND WPR.ORGANIZATION_ID=MIL1.ORGANIZATION_ID(+)
AND WPR.PICK_FROM_LOCATOR_ID=MIL2.INVENTORY_LOCATION_ID(+)
AND WPR.ORGANIZATION_ID=MIL2.ORGANIZATION_ID(+) WITH READ ONLY