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.WSH_PICKING_RULES_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)