VIEW: APPS.WSHBV_PICKING_RULES

Source

View Text - Preformatted

SELECT WPR.PICKING_RULE_ID, WPR.NAME,WPR.DOCUMENT_SET_ID ,LOC.SOURCE_LOCATION_ID, WPR.ORGANIZATION_ID, WPR.DEFAULT_STAGE_SUBINVENTORY , '_KF:INV:MTLL:MIL1' , WPR.PICK_FROM_SUBINVENTORY , '_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' ,LOC1.SOURCE_LOCATION_ID, WPR.CARRIER_ID, WPR.PICK_GROUPING_RULE_ID, WPR.PICK_SEQUENCE_RULE_ID ,'_LA:WPR.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING' , WPR.PROJECT_ID, WPR.TASK_ID ,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 , WPR.ORDER_TYPE_ID , WPR.CUSTOMER_ID , '_LA:WPR.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING', WPR.SUBINVENTORY , 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', WPR.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI' FROM WSH_PICKING_RULES WPR, MTL_SYSTEM_ITEMS MSI, MTL_ITEM_LOCATIONS MIL1, WSH_LOCATIONS LOC, WSH_LOCATIONS LOC1,MTL_ITEM_LOCATIONS MIL2 WHERE WPR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND WPR.ORGANIZATION_ID = MSI.ORGANIZATION_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(+) AND WPR.SHIP_TO_LOCATION_ID= LOC1.WSH_LOCATION_ID(+) AND WPR.SHIP_FROM_LOCATION_ID = LOC.WSH_LOCATION_ID(+) AND '_SEC:WPR.ORGANIZATION_ID' is not null with read only

View Text - HTML Formatted

SELECT WPR.PICKING_RULE_ID
, WPR.NAME
, WPR.DOCUMENT_SET_ID
, LOC.SOURCE_LOCATION_ID
, WPR.ORGANIZATION_ID
, WPR.DEFAULT_STAGE_SUBINVENTORY
, '_KF:INV:MTLL:MIL1'
, WPR.PICK_FROM_SUBINVENTORY
, '_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'
, LOC1.SOURCE_LOCATION_ID
, WPR.CARRIER_ID
, WPR.PICK_GROUPING_RULE_ID
, WPR.PICK_SEQUENCE_RULE_ID
, '_LA:WPR.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING'
, WPR.PROJECT_ID
, WPR.TASK_ID
, 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
, WPR.ORDER_TYPE_ID
, WPR.CUSTOMER_ID
, '_LA:WPR.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WPR.SUBINVENTORY
, 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'
, WPR.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
FROM WSH_PICKING_RULES WPR
, MTL_SYSTEM_ITEMS MSI
, MTL_ITEM_LOCATIONS MIL1
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, MTL_ITEM_LOCATIONS MIL2
WHERE WPR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WPR.ORGANIZATION_ID = MSI.ORGANIZATION_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(+)
AND WPR.SHIP_TO_LOCATION_ID= LOC1.WSH_LOCATION_ID(+)
AND WPR.SHIP_FROM_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND '_SEC:WPR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY