View: WSH_PICKING_RULES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_PICKING_RULES_V

View Text

SELECT WPR.ROWID ROW_ID
, WPR.PICKING_RULE_ID
, WPR.NAME PICKING_RULE_NAME
, WPR.CREATION_DATE
, WPR.CREATED_BY
, WPR.LAST_UPDATE_DATE
, WPR.LAST_UPDATED_BY
, WPR.LAST_UPDATE_LOGIN
, WPR.PROGRAM_APPLICATION_ID
, WPR.PROGRAM_ID
, WPR.PROGRAM_UPDATE_DATE
, WPR.REQUEST_ID
, WPR.BACKORDERS_ONLY_FLAG
, S2.MEANING BACKORDERS
, WPR.EXISTING_RSVS_ONLY_FLAG
, DECODE(WPR.EXISTING_RSVS_ONLY_FLAG
, 'Y'
, '*'
, NULL) RESERVATION_STAR
, WPR.SHIPMENT_PRIORITY_CODE
, S1.MEANING SHIPMENT_PRIORITY
, WPR.SHIP_METHOD_CODE
, WPR.CUSTOMER_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HZP.PARTY_NUMBER CUSTOMER_NUMBER
, WPR.ORDER_HEADER_ID
, H.ORDER_NUMBER
, OS.SET_NAME SHIP_SET_NUMBER
, WPR.SHIP_SET_NUMBER SHIP_SET_ID
, WPR.INVENTORY_ITEM_ID
, WPR.ORDER_TYPE_ID
, OT.NAME ORDER_TYPE
, DECODE(TO_CHAR(WPR.FROM_REQUESTED_DATE
, 'DD-MON-YYYY')
, TO_CHAR(TO_DATE('1'
, 'J')
, 'DD-MON-YYYY')
, TO_DATE(TO_CHAR(SYSDATE
, 'MM/DD/YYYY') || TO_CHAR(WPR.FROM_REQUESTED_DATE
, ' HH24:MI:SS')
, 'MM/DD/YYYY HH24:MI:SS')
, WPR.FROM_REQUESTED_DATE) FROM_REQUESTED_DATE
, DECODE(TO_CHAR(WPR.TO_REQUESTED_DATE
, 'DD-MON-YYYY')
, TO_CHAR(TO_DATE('1'
, 'J')
, 'DD-MON-YYYY')
, TO_DATE(TO_CHAR(SYSDATE
, 'MM/DD/YYYY') || TO_CHAR(WPR.TO_REQUESTED_DATE
, ' HH24:MI:SS')
, 'MM/DD/YYYY HH24:MI:SS')
, WPR.TO_REQUESTED_DATE) TO_REQUESTED_DATE
, DECODE(TO_CHAR(WPR.FROM_SCHEDULED_SHIP_DATE
, 'DD-MON-YYYY')
, TO_CHAR(TO_DATE('1'
, 'J')
, 'DD-MON-YYYY')
, TO_DATE(TO_CHAR(SYSDATE
, 'MM/DD/YYYY') || TO_CHAR(WPR.FROM_SCHEDULED_SHIP_DATE
, ' HH24:MI:SS')
, 'MM/DD/YYYY HH24:MI:SS')
, WPR.FROM_SCHEDULED_SHIP_DATE) FROM_SCHEDULED_SHIP_DATE
, DECODE(TO_CHAR(WPR.TO_SCHEDULED_SHIP_DATE
, 'DD-MON-YYYY')
, TO_CHAR(TO_DATE('1'
, 'J')
, 'DD-MON-YYYY')
, TO_DATE(TO_CHAR(SYSDATE
, 'MM/DD/YYYY') || TO_CHAR(WPR.TO_SCHEDULED_SHIP_DATE
, ' HH24:MI:SS')
, 'MM/DD/YYYY HH24:MI:SS')
, WPR.TO_SCHEDULED_SHIP_DATE) TO_SCHEDULED_SHIP_DATE
, WPR.SHIP_TO_LOCATION_ID
, WHZL.UI_LOCATION_CODE SHIP_TO_LOCATION
, WHRL.UI_LOCATION_CODE SHIP_FROM_LOCATION
, WPR.SHIP_FROM_LOCATION_ID
, WPR.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE WAREHOUSE_CODE
, H_ORG_TL.NAME WAREHOUSE
, WPR.PICK_FROM_SUBINVENTORY
, WPR.DEFAULT_STAGE_SUBINVENTORY
, WPR.PICK_FROM_LOCATOR_ID
, WPR.DEFAULT_STAGE_LOCATOR_ID
, WPR.PICK_GROUPING_RULE_ID
, PGR.NAME PICK_GROUPING_RULE_NAME
, WPR.PICK_SEQUENCE_RULE_ID
, RSQR.NAME PICK_SEQ_RULE_NAME
, WPR.INCLUDE_PLANNED_LINES
, WPR.START_DATE_ACTIVE
, WPR.END_DATE_ACTIVE
, WPR.AUTOCREATE_DELIVERY_FLAG
, WPR.PROJECT_ID
, PJP.PROJECT_NUMBER
, WPR.TASK_ID
, PJT.TASK_NUMBER
, WPR.AUTODETAIL_PR_FLAG
, WPR.AUTO_PICK_CONFIRM_FLAG
, WPR.DOCUMENT_SET_ID
, WRS.NAME DOC_NAME
, WPR.ATTRIBUTE_CATEGORY
, WPR.ATTRIBUTE1
, WPR.ATTRIBUTE2
, WPR.ATTRIBUTE3
, WPR.ATTRIBUTE4
, WPR.ATTRIBUTE5
, WPR.ATTRIBUTE6
, WPR.ATTRIBUTE7
, WPR.ATTRIBUTE8
, WPR.ATTRIBUTE9
, WPR.ATTRIBUTE10
, WPR.ATTRIBUTE11
, WPR.ATTRIBUTE12
, WPR.ATTRIBUTE13
, WPR.ATTRIBUTE14
, WPR.ATTRIBUTE15
, WPR.AUTOPACK_FLAG
, WPR.AUTOPACK_LEVEL
, WPR.SHIP_CONFIRM_RULE_ID
, WPR.TASK_PLANNING_FLAG
, WPR.APPEND_FLAG
, WPR.SCH_START_DAYS
, WPR.SCH_START_HOURS
, WPR.SCH_END_DAYS
, WPR.SCH_END_HOURS
, WPR.REQ_START_DAYS
, WPR.REQ_START_HOURS
, WPR.REQ_END_DAYS
, WPR.REQ_END_HOURS
, WPR.REGION_ID
, WPR.ZONE_ID
, WPR.CATEGORY_ID
, WPR.CATEGORY_SET_ID
, WPR.AC_DELIVERY_CRITERIA
, WPR.REL_SUBINVENTORY
, WPR.TASK_PRIORITY
, WPR.ALLOCATION_METHOD
, WPR.CROSSDOCK_CRITERIA_ID
, WPR.DYNAMIC_REPLENISHMENT_FLAG
, WPR.CLIENT_ID
FROM MTL_PARAMETERS ORG
, HR_ORG_UNITS_NO_JOIN H_ORG_NJ
, HR_ALL_ORGANIZATION_UNITS_TL H_ORG_TL
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, OE_LOOKUPS S1
, OE_LOOKUPS S2
, OE_SETS OS
, WSH_PICK_GROUPING_RULES PGR
, WSH_PICK_SEQUENCE_RULES RSQR
, OE_TRXT_TYPES_NOORGS_VL OT
, OE_ORDER_HEADERS_ALL H
, WSH_LOCATIONS WHZL
, WSH_LOCATIONS WHRL
, PJM_PROJECTS_ALL_V PJP
, PJM_TASKS_V PJT
, WSH_PICKING_RULES WPR
, WSH_REPORT_SETS WRS
WHERE ORG.ORGANIZATION_ID(+) = WPR.ORGANIZATION_ID
AND H_ORG_NJ.ORGANIZATION_ID(+) = WPR.ORGANIZATION_ID
AND H_ORG_TL.ORGANIZATION_ID(+) = WPR.ORGANIZATION_ID
AND HCA.PARTY_ID = HZP.PARTY_ID(+)
AND HCA.CUST_ACCOUNT_ID(+) = WPR.CUSTOMER_ID
AND H_ORG_TL.LANGUAGE(+) = USERENV('LANG')
AND PGR.PICK_GROUPING_RULE_ID(+) = WPR.PICK_GROUPING_RULE_ID
AND RSQR.PICK_SEQUENCE_RULE_ID(+) = WPR.PICK_SEQUENCE_RULE_ID
AND S1.LOOKUP_CODE(+) = WPR.SHIPMENT_PRIORITY_CODE
AND S1.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
AND S2.LOOKUP_CODE = WPR.BACKORDERS_ONLY_FLAG
AND S2.LOOKUP_TYPE = 'PICK_RELEASE_OPTIONS'
AND OT.TRANSACTION_TYPE_ID(+) = NVL(WPR.ORDER_TYPE_ID
, -1)
AND OT.TRANSACTION_TYPE_CODE(+) = 'ORDER'
AND NVL(WPR.SHIP_TO_LOCATION_ID
, -1) = WHZL.WSH_LOCATION_ID(+)
AND WHRL.WSH_LOCATION_ID(+) = NVL(WPR.SHIP_FROM_LOCATION_ID
, -1)
AND PJT.TASK_ID(+) = WPR.TASK_ID
AND WRS.REPORT_SET_ID(+) = WPR.DOCUMENT_SET_ID
AND PJP.PROJECT_ID(+) = WPR.PROJECT_ID
AND OS.SET_ID(+) = NVL(WPR.SHIP_SET_NUMBER
, -1)
AND H.HEADER_ID(+) = NVL(WPR.ORDER_HEADER_ID
, -1)

Columns