VIEW: APPS.WSHFV_PICKING_BATCHES

Source

View Text - Preformatted

SELECT WPB.BATCH_ID PICKING_BATCH_ID , WPB.DOCUMENT_SET_ID, WRS.NAME DOCUMENT_SET_NAME, WPB.CARRIER_ID, LOC.SOURCE_LOCATION_ID, LOC.UI_LOCATION_CODE SHIP_TO_LOCATION ,WPB.ORDER_HEADER_ID, WPB.ORDER_LINE_ID ,OOHA.ORDER_NUMBER, OOLA.LINE_NUMBER ORDER_LINE_NUMBER , LOC1.SOURCE_LOCATION_ID, LOC1.UI_LOCATION_CODE SHIP_TO_LOCATION ,WPB.DEFAULT_STAGE_SUBINVENTORY , SUBINV1.DESCRIPTION DEFAULT_STAGE_DESCRIPTION ,WPB.DEFAULT_STAGE_LOCATOR_ID , '_KF:INV:MTLL:MIL1' ,WPB.PICK_FROM_SUBINVENTORY , SUBINV2.DESCRIPTION PICK_FROM_DESCRIPTION ,WPB.PICK_FROM_LOCATOR_ID , '_KF:INV:MTLL:MIL2' ,'_LA:WPB.AUTODETAIL_PR_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,'_LA:WPB.AUTO_PICK_CONFIRM_FLAG:FND_LOOKUPS:YES_NO:MEANING' , WPB.TRIP_ID ,WT.NAME TRIP_NAME , LOC2.SOURCE_LOCATION_ID, LOC2.UI_LOCATION_CODE TRIP_STOP_LOCATION ,WPB.DELIVERY_ID ,WND.NAME DELIVERY_NAME ,WPB.DELIVERY_DETAIL_ID ,WPB.PICK_GROUPING_RULE_ID ,WPGR.NAME PICK_GROUPING_RULE_NAME ,WPB.PICK_SEQUENCE_RULE_ID ,WPSR.NAME PICK_SEQUENCE_NAME ,'_LA:WPB.AUTOCREATE_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,WPB.CREATION_DATE , WPB.CREATED_BY , WPB.LAST_UPDATE_DATE , WPB.LAST_UPDATED_BY , WPB.NAME , WPB.BACKORDERS_ONLY_FLAG, '_LA:WPB.EXISTING_RSVS_ONLY_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPB.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING', '_LA:WPB.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING', WPB.CUSTOMER_ID , PARTY.PARTY_NAME CUSTOMER_NAME , WPB.SHIP_SET_NUMBER , WPB.ORDER_TYPE_ID , OTTA.TRANSACTION_TYPE_CODE ORDER_TYPE_CODE, WPB.FROM_REQUESTED_DATE , WPB.TO_REQUESTED_DATE, WPB.FROM_SCHEDULED_SHIP_DATE , WPB.TO_SCHEDULED_SHIP_DATE , WPB.SUBINVENTORY , SUBINV3.DESCRIPTION SUBINV_DESCRIPTION, WPB.ORGANIZATION_ID , '_LA:WPB.PARTIAL_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:WPB.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING', '_DF:WSH:WSH_PICKING_BATCHES:WPB', WPB.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI' FROM WSH_PICKING_BATCHES WPB, MTL_SYSTEM_ITEMS MSI, WSH_REPORT_SETS WRS, WSH_LOCATIONS LOC, WSH_LOCATIONS LOC1, WSH_LOCATIONS LOC2, OE_ORDER_HEADERS_ALL OOHA, OE_ORDER_LINES_ALL OOLA, MTL_SECONDARY_INVENTORIES SUBINV1, MTL_SECONDARY_INVENTORIES SUBINV2, MTL_SECONDARY_INVENTORIES SUBINV3, WSH_TRIPS WT, WSH_NEW_DELIVERIES WND, WSH_PICK_SEQUENCE_RULES WPSR, WSH_PICK_GROUPING_RULES WPGR, WSH_TRIP_STOPS WTS1, HZ_CUST_ACCOUNTS CUSTACCT, HZ_PARTIES PARTY, OE_TRANSACTION_TYPES_ALL OTTA, MTL_ITEM_LOCATIONS MIL1,MTL_ITEM_LOCATIONS MIL2 WHERE WPB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND WPB.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+) AND '_SEC:WPB.ORGANIZATION_ID' is not null AND WPB.DOCUMENT_SET_ID=WRS.REPORT_SET_ID(+) AND WPB.SHIP_TO_LOCATION_ID =LOC.WSH_LOCATION_ID(+) AND WPB.SHIP_FROM_LOCATION_ID =LOC1.WSH_LOCATION_ID(+) AND WPB.ORDER_HEADER_ID=OOHA.HEADER_ID(+) AND WPB.ORDER_LINE_ID=OOLA.LINE_ID(+) AND WPB.DEFAULT_STAGE_SUBINVENTORY = SUBINV1.SECONDARY_INVENTORY_NAME(+) AND WPB.ORGANIZATION_ID = SUBINV1.ORGANIZATION_ID(+) AND WPB.PICK_FROM_SUBINVENTORY = SUBINV2.SECONDARY_INVENTORY_NAME(+) AND WPB.ORGANIZATION_ID = SUBINV2.ORGANIZATION_ID(+) AND WPB.SUBINVENTORY = SUBINV3.SECONDARY_INVENTORY_NAME(+) AND WPB.ORGANIZATION_ID = SUBINV3.ORGANIZATION_ID(+) AND WPB.TRIP_ID=WT.TRIP_ID(+) AND WPB.DELIVERY_ID=WND.DELIVERY_ID(+) AND WPB.PICK_SEQUENCE_RULE_ID=WPSR.PICK_SEQUENCE_RULE_ID(+) AND WPB.PICK_GROUPING_RULE_ID=WPGR.PICK_GROUPING_RULE_ID(+) AND WPB.TRIP_STOP_ID=WTS1.STOP_ID(+) AND WTS1.STOP_LOCATION_ID=LOC2.WSH_LOCATION_ID(+) AND WPB.CUSTOMER_ID = CUSTACCT.CUST_ACCOUNT_ID(+) AND CUSTACCT.PARTY_ID = PARTY.PARTY_ID(+) AND WPB.ORDER_TYPE_ID=OTTA.TRANSACTION_TYPE_ID(+) AND WPB.DEFAULT_STAGE_LOCATOR_ID=MIL1.INVENTORY_LOCATION_ID(+) AND WPB.ORGANIZATION_ID=MIL1.ORGANIZATION_ID(+) AND WPB.PICK_FROM_LOCATOR_ID=MIL2.INVENTORY_LOCATION_ID(+) AND WPB.ORGANIZATION_ID=MIL2.ORGANIZATION_ID(+) AND NVL(WND.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND NVL(WT.SHIPMENTS_TYPE_FLAG, 'O') IN ('O', 'M') AND NVL(WTS1.SHIPMENTS_TYPE_FLAG, 'O') IN ('O', 'M') with read only

View Text - HTML Formatted

SELECT WPB.BATCH_ID PICKING_BATCH_ID
, WPB.DOCUMENT_SET_ID
, WRS.NAME DOCUMENT_SET_NAME
, WPB.CARRIER_ID
, LOC.SOURCE_LOCATION_ID
, LOC.UI_LOCATION_CODE SHIP_TO_LOCATION
, WPB.ORDER_HEADER_ID
, WPB.ORDER_LINE_ID
, OOHA.ORDER_NUMBER
, OOLA.LINE_NUMBER ORDER_LINE_NUMBER
, LOC1.SOURCE_LOCATION_ID
, LOC1.UI_LOCATION_CODE SHIP_TO_LOCATION
, WPB.DEFAULT_STAGE_SUBINVENTORY
, SUBINV1.DESCRIPTION DEFAULT_STAGE_DESCRIPTION
, WPB.DEFAULT_STAGE_LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, WPB.PICK_FROM_SUBINVENTORY
, SUBINV2.DESCRIPTION PICK_FROM_DESCRIPTION
, WPB.PICK_FROM_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, '_LA:WPB.AUTODETAIL_PR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPB.AUTO_PICK_CONFIRM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WPB.TRIP_ID
, WT.NAME TRIP_NAME
, LOC2.SOURCE_LOCATION_ID
, LOC2.UI_LOCATION_CODE TRIP_STOP_LOCATION
, WPB.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, WPB.DELIVERY_DETAIL_ID
, WPB.PICK_GROUPING_RULE_ID
, WPGR.NAME PICK_GROUPING_RULE_NAME
, WPB.PICK_SEQUENCE_RULE_ID
, WPSR.NAME PICK_SEQUENCE_NAME
, '_LA:WPB.AUTOCREATE_DELIVERY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WPB.CREATION_DATE
, WPB.CREATED_BY
, WPB.LAST_UPDATE_DATE
, WPB.LAST_UPDATED_BY
, WPB.NAME
, WPB.BACKORDERS_ONLY_FLAG
, '_LA:WPB.EXISTING_RSVS_ONLY_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPB.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING'
, '_LA:WPB.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WPB.CUSTOMER_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, WPB.SHIP_SET_NUMBER
, WPB.ORDER_TYPE_ID
, OTTA.TRANSACTION_TYPE_CODE ORDER_TYPE_CODE
, WPB.FROM_REQUESTED_DATE
, WPB.TO_REQUESTED_DATE
, WPB.FROM_SCHEDULED_SHIP_DATE
, WPB.TO_SCHEDULED_SHIP_DATE
, WPB.SUBINVENTORY
, SUBINV3.DESCRIPTION SUBINV_DESCRIPTION
, WPB.ORGANIZATION_ID
, '_LA:WPB.PARTIAL_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:WPB.INCLUDE_PLANNED_LINES:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:WSH:WSH_PICKING_BATCHES:WPB'
, WPB.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
FROM WSH_PICKING_BATCHES WPB
, MTL_SYSTEM_ITEMS MSI
, WSH_REPORT_SETS WRS
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, OE_ORDER_HEADERS_ALL OOHA
, OE_ORDER_LINES_ALL OOLA
, MTL_SECONDARY_INVENTORIES SUBINV1
, MTL_SECONDARY_INVENTORIES SUBINV2
, MTL_SECONDARY_INVENTORIES SUBINV3
, WSH_TRIPS WT
, WSH_NEW_DELIVERIES WND
, WSH_PICK_SEQUENCE_RULES WPSR
, WSH_PICK_GROUPING_RULES WPGR
, WSH_TRIP_STOPS WTS1
, HZ_CUST_ACCOUNTS CUSTACCT
, HZ_PARTIES PARTY
, OE_TRANSACTION_TYPES_ALL OTTA
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
WHERE WPB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WPB.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND '_SEC:WPB.ORGANIZATION_ID' IS NOT NULL
AND WPB.DOCUMENT_SET_ID=WRS.REPORT_SET_ID(+)
AND WPB.SHIP_TO_LOCATION_ID =LOC.WSH_LOCATION_ID(+)
AND WPB.SHIP_FROM_LOCATION_ID =LOC1.WSH_LOCATION_ID(+)
AND WPB.ORDER_HEADER_ID=OOHA.HEADER_ID(+)
AND WPB.ORDER_LINE_ID=OOLA.LINE_ID(+)
AND WPB.DEFAULT_STAGE_SUBINVENTORY = SUBINV1.SECONDARY_INVENTORY_NAME(+)
AND WPB.ORGANIZATION_ID = SUBINV1.ORGANIZATION_ID(+)
AND WPB.PICK_FROM_SUBINVENTORY = SUBINV2.SECONDARY_INVENTORY_NAME(+)
AND WPB.ORGANIZATION_ID = SUBINV2.ORGANIZATION_ID(+)
AND WPB.SUBINVENTORY = SUBINV3.SECONDARY_INVENTORY_NAME(+)
AND WPB.ORGANIZATION_ID = SUBINV3.ORGANIZATION_ID(+)
AND WPB.TRIP_ID=WT.TRIP_ID(+)
AND WPB.DELIVERY_ID=WND.DELIVERY_ID(+)
AND WPB.PICK_SEQUENCE_RULE_ID=WPSR.PICK_SEQUENCE_RULE_ID(+)
AND WPB.PICK_GROUPING_RULE_ID=WPGR.PICK_GROUPING_RULE_ID(+)
AND WPB.TRIP_STOP_ID=WTS1.STOP_ID(+)
AND WTS1.STOP_LOCATION_ID=LOC2.WSH_LOCATION_ID(+)
AND WPB.CUSTOMER_ID = CUSTACCT.CUST_ACCOUNT_ID(+)
AND CUSTACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND WPB.ORDER_TYPE_ID=OTTA.TRANSACTION_TYPE_ID(+)
AND WPB.DEFAULT_STAGE_LOCATOR_ID=MIL1.INVENTORY_LOCATION_ID(+)
AND WPB.ORGANIZATION_ID=MIL1.ORGANIZATION_ID(+)
AND WPB.PICK_FROM_LOCATOR_ID=MIL2.INVENTORY_LOCATION_ID(+)
AND WPB.ORGANIZATION_ID=MIL2.ORGANIZATION_ID(+)
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')
AND NVL(WT.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')
AND NVL(WTS1.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M') WITH READ ONLY