View: WSHFV_PICKING_RULES

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Picking Rules.
Implementation/DBA Data:	APPS.WSHFV_PICKING_RULES

View Text

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

Columns