View: WSHFV_PICK_RELEASE_RULE

View Text

SELECT SPR.PICKING_RULE
, SPR.CREATION_DATE
, SPR.CREATED_BY
, SPR.LAST_UPDATE_DATE
, SPR.LAST_UPDATED_BY
, SPR.LAST_UPDATE_LOGIN
, SPR.PROGRAM_APPLICATION_ID
, SPR.PROGRAM_ID
, SPR.PROGRAM_UPDATE_DATE
, SPR.REQUEST_ID
, SPR.BACKORDERS_ONLY_FLAG
, SPR.SHIPMENT_PRIORITY_CODE
, SPR.HEADER_ID
, SH.ORDER_NUMBER
, SPR.ORDER_TYPE_ID
, SOT.NAME ORDER_TYPE_NAME
, SPR.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE ORGANIZATION_CODE
, SPR.CUSTOMER_ID
, RC.CUSTOMER_NAME
, SPR.SITE_USE_ID
, SU.LOCATION SHIP_TO
, SPR.SHIP_METHOD_CODE
, OGF.DESCRIPTION SHIP_METHOD
, SPR.GROUP_ID
, SIG.NAME ITEM_GROUP_NAME
, SPR.SUBINVENTORY
, SPR.SHIP_SET_NUMBER
, SPR.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SPR.DATE_REQUESTED_FROM FROM_REQUESTED_DATE
, SPR.DATE_REQUESTED_TO TO_REQUESTED_DATE
, SPR.SCHEDULED_SHIPMENT_DATE_FROM FROM_SCHEDULED_SHIPMENT_DATE
, SPR.SCHEDULED_SHIPMENT_DATE_TO TO_SCHEDULED_SHIPMENT_DATE
, SPR.START_DATE_ACTIVE ACTIVE_START_DATE
, SPR.END_DATE_ACTIVE ACTIVE_END_DATE
, SPR.EXISTING_RSVS_ONLY_FLAG
, SPR.PICK_SLIP_RULE_ID
, WPSR.NAME PICK_SLIP_RULE_NAME
, SPR.RELEASE_SEQ_RULE_SET_ID
, SPR.PARTIAL_ALLOWED_FLAG
, SPR.INCLUDE_PLANNED_LINES_FLAG
, SPR.AUTOCREATE_DELIVERY_FLAG
FROM SO_PICKING_RULES SPR
, SO_HEADERS_ALL SH
, ORG_FREIGHT OGF
, SO_ORDER_TYPES_ALL SOT
, RA_CUSTOMERS RC
, MTL_PARAMETERS ORG
, RA_SITE_USES_ALL SU
, SO_ITEM_GROUPS SIG
, MTL_SYSTEM_ITEMS MSI
, WSH_PICK_SLIP_RULES WPSR
WHERE SH.HEADER_ID (+) = SPR.HEADER_ID
AND OGF.FREIGHT_CODE (+) = SPR.SHIP_METHOD_CODE
AND OGF.ORGANIZATION_ID (+) = SPR.WAREHOUSE_ID
AND SOT.ORDER_TYPE_ID (+) = SPR.ORDER_TYPE_ID
AND RC.CUSTOMER_ID (+) = SPR.CUSTOMER_ID
AND ORG.ORGANIZATION_ID (+) = SPR.WAREHOUSE_ID
AND SU.SITE_USE_ID (+) = SPR.SITE_USE_ID
AND SIG.GROUP_ID (+) = SPR.GROUP_ID
AND MSI.INVENTORY_ITEM_ID (+) = SPR.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+)= SPR.WAREHOUSE_ID
AND WPSR.PICK_SLIP_RULE_ID (+) = SPR.PICK_SLIP_RULE_ID

Columns