View: SO_PICKING_BATCHES_V

View Text

SELECT SPB.ROWID ROW_ID
, SPB.BATCH_ID
, SPB.CREATION_DATE
, SPB.CREATED_BY
, SPB.LAST_UPDATE_DATE
, SPB.LAST_UPDATED_BY
, SPB.LAST_UPDATE_LOGIN
, SPB.PROGRAM_APPLICATION_ID
, SPB.PROGRAM_ID
, SPB.PROGRAM_UPDATE_DATE
, SPB.REQUEST_ID
, SPB.NAME BATCH_NAME
, SPB.BACKORDERS_ONLY_FLAG
, S1.MEANING BACKORDERS
, SPB.PRINT_FLAG
, SRS.NAME DOC_NAME
, SPB.EXISTING_RSVS_ONLY_FLAG
, S3.MEANING RESERVATION
, DECODE(SPB.EXISTING_RSVS_ONLY_FLAG
, 'Y'
, '*'
, NULL) RESERVATION_STAR
, SPB.SHIPMENT_PRIORITY_CODE
, S2.MEANING SHIPMENT_PRIORITY
, SPB.SHIP_METHOD_CODE
, SPB.CUSTOMER_ID
, RC.CUSTOMER_NAME
, RC.CUSTOMER_NUMBER
, SPB.GROUP_ID
, SPB.HEADER_COUNT
, SPB.HEADER_ID
, H.ORDER_NUMBER
, SPB.SHIP_SET_NUMBER
, SPB.INVENTORY_ITEM_ID
, SPB.ORDER_TYPE_ID
, OT.NAME ORDER_TYPE
, SPB.DATE_REQUESTED_FROM
, SPB.DATE_REQUESTED_TO
, SPB.SCHEDULED_SHIPMENT_DATE_FROM
, SPB.SCHEDULED_SHIPMENT_DATE_TO
, SPB.SITE_USE_ID
, SU.LOCATION
, SPB.WAREHOUSE_ID
, ORG.ORGANIZATION_CODE WAREHOUSE_CODE
, H_ORG_TL.NAME WAREHOUSE
, SPB.SUBINVENTORY
, SPB.DATE_COMPLETED
, SPB.DATE_CONFIRMED
, SPB.DATE_LAST_PRINTED
, SPB.DATE_RELEASED
, SPB.DATE_UNRELEASED
, SPB.CONTEXT
, SPB.ATTRIBUTE1
, SPB.ATTRIBUTE2
, SPB.ATTRIBUTE3
, SPB.ATTRIBUTE4
, SPB.ATTRIBUTE5
, SPB.ATTRIBUTE6
, SPB.ATTRIBUTE7
, SPB.ATTRIBUTE8
, SPB.ATTRIBUTE9
, SPB.ATTRIBUTE10
, SPB.ATTRIBUTE11
, SPB.ATTRIBUTE12
, SPB.ATTRIBUTE13
, SPB.ATTRIBUTE14
, SPB.ATTRIBUTE15
, SPB.ERROR_REPORT_FLAG
, SPB.ORG_ID
, SPB.DEPARTURE_ID
, DP.NAME DEPARTURE_NAME
, SPB.DELIVERY_ID
, DL.NAME DELIVERY_NAME
, SPB.PICK_SLIP_RULE_ID
, PSR.NAME PICK_SLIP_RULE_NAME
, SPB.RELEASE_SEQ_RULE_ID
, RSR.NAME RELEASE_SEQ_RULE_NAME
, SPB.PARTIAL_ALLOWED_FLAG
, SPB.INCLUDE_PLANNED_LINES
, SPB.AUTOCREATE_DELIVERY_FLAG
FROM MTL_PARAMETERS ORG
, HR_ORG_UNITS_NO_JOIN H_ORG_NJ
, HR_ALL_ORGANIZATION_UNITS_TL H_ORG_TL
, RA_CUSTOMERS RC
, SO_REPORT_SETS SRS
, SO_ORDER_TYPES_ALL OT
, RA_SITE_USES SU
, WSH_DEPARTURES DP
, WSH_DELIVERIES DL
, WSH_PICK_SLIP_RULES PSR
, WSH_RELEASE_SEQ_RULES RSR
, SO_HEADERS_ALL H
, SO_LOOKUPS S1
, SO_LOOKUPS S2
, SO_LOOKUPS S3
, SO_PICKING_BATCHES_ALL SPB
WHERE RC.CUSTOMER_ID(+) = SPB.CUSTOMER_ID
AND ORG.ORGANIZATION_ID(+) = SPB.WAREHOUSE_ID
AND H_ORG_TL.ORGANIZATION_ID(+) = SPB.WAREHOUSE_ID
AND H_ORG_NJ.ORGANIZATION_ID(+) = SPB.WAREHOUSE_ID
AND H_ORG_TL.LANGUAGE(+) = USERENV('LANG')
AND SRS.REPORT_SET_ID(+) = TO_NUMBER(DECODE(SPB.PRINT_FLAG
, ''
, '-1'
, 'S'
, '3'
, 'B'
, '3'
, 'C'
, '3'
, 'N'
, '3'
, SPB.PRINT_FLAG))
AND OT.ORDER_TYPE_ID(+) = NVL(SPB.ORDER_TYPE_ID
, -1)
AND SU.SITE_USE_ID(+) = NVL(SPB.SITE_USE_ID
, -1)
AND H.HEADER_ID(+) = NVL(SPB.HEADER_ID
, -1)
AND S1.LOOKUP_TYPE(+) = 'PICK_RELEASE_OPTIONS'
AND S1.LOOKUP_CODE(+) = SPB.BACKORDERS_ONLY_FLAG
AND S2.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
AND S2.LOOKUP_CODE(+) = SPB.SHIPMENT_PRIORITY_CODE
AND S3.LOOKUP_TYPE(+) = 'YES_NO'
AND S3.LOOKUP_CODE(+) = SPB.EXISTING_RSVS_ONLY_FLAG
AND DP.DEPARTURE_ID(+) = SPB.DEPARTURE_ID
AND DL.DELIVERY_ID(+) = SPB.DELIVERY_ID
AND PSR.PICK_SLIP_RULE_ID(+) = SPB.PICK_SLIP_RULE_ID
AND RSR.RELEASE_SEQ_RULE_ID(+) = SPB.RELEASE_SEQ_RULE_ID

Columns