WSH_LINES_LPN_TL_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name

ENTITY_ID LPN_ID LICENSE_PLATE_NUMBER INVENTORY_ITEM_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID REVISION LOT_NUMBER SERIAL_NUMBER ORGANIZATION_ID SUBINVENTORY LOCATOR_ID PARENT_LPN_ID OUTERMOST_LPN_ID GROSS_WEIGHT_UOM_CODE GROSS_WEIGHT CONTENT_VOLUME_UOM_CODE CONTENT_VOLUME TARE_WEIGHT_UOM_CODE TARE_WEIGHT STATUS_ID LPN_CONTEXT SEALED_STATUS LPN_REUSABILITY HOMOGENEOUS_CONTAINER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 SOURCE_TYPE_ID SOURCE_HEADER_ID SOURCE_LINE_ID SOURCE_LINE_DETAIL_ID SOURCE_NAME VOLUME VOLUME_UOM_CODE OBJECT_VERSION_NUMBER JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE SOLD_TO_PARTY_ID SHIP_TO_PARTY_ID SHIP_FROM_LOCATION_ID SHIP_TO_LOCATION_ID FREIGHT_TERMS_CODE FOB_CODE CARRIER_ID SERVICE_LEVEL MODE_OF_TRANSPORT SHIP_METHOD_CODE SHIPPING_INSTRUCTIONS PACKING_INSTRUCTIONS MASTER_SERIAL_NUMBER EARLIEST_PICKUP_DATE LATEST_PICKUP_DATE EARLIEST_DROPOFF_DATE LATEST_DROPOFF_DATE WV_FROZEN_FLAG FILL_PERCENT FILLED_VOLUME DELIVERY_ID TRACKING_NUMBER BATCH_ID OUTSOURCER_PARTY_ID NET_WEIGHT NET_WEIGHT_UOM_CODE MAXIMUM_LOAD_WEIGHT MAXIMUM_VOLUME MINIMUM_FILL_PERCENT CONTAINER_TYPE_CODE UNIT_WEIGHT UNIT_VOLUME DELIVERY_DETAIL_ID SOURCE_HEADER_NUMBER CUST_PO_NUMBER SOLD_TO_CONTACT_ID ITEM_DESCRIPTION SHIP_TO_CONTACT_ID SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_BELOW SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY_UOM CANCELLED_QUANTITY REQUESTED_QUANTITY REQUESTED_QUANTITY_UOM SHIPPED_QUANTITY DELIVERED_QUANTITY CYCLE_COUNT_QUANTITY MOVE_ORDER_LINE_ID RELEASED_STATUS DATE_REQUESTED DATE_SCHEDULED LOAD_SEQ_NUMBER SHIPMENT_PRIORITY_CODE CUSTOMER_ITEM_ID WEIGHT_UOM_CODE ORG_ID MVT_STAT_STATUS TRANSACTION_TEMP_ID MOVEMENT_ID SPLIT_FROM_DELIVERY_DETAIL_ID INV_INTERFACED_FLAG SOURCE_LINE_NUMBER SEAL_CODE PREFERRED_GRADE SRC_REQUESTED_QUANTITY2 SRC_REQUESTED_QUANTITY_UOM2 REQUESTED_QUANTITY2 SHIPPED_QUANTITY2 DELIVERED_QUANTITY2 CANCELLED_QUANTITY2 CYCLE_COUNT_QUANTITY2 REQUESTED_QUANTITY_UOM2 UNIT_PRICE CURRENCY_CODE LPN_CONTENT_ID INSPECTION_FLAG ORIGINAL_SUBINVENTORY PICKABLE_FLAG PICKED_QUANTITY PICKED_QUANTITY2 TRANSACTION_ID REQUEST_DATE_TYPE_CODE SOURCE_DOCUMENT_TYPE_ID BILL_TO_PARTY_ID BILL_TO_LOCATION_ID BILL_TO_CONTACT_ID SHIP_SET_NAME ARRIVAL_SET_NAME SOURCE_LINE_UPDATE_DATE SELLING_PRICE CONVERTED_QUANTITY SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_NUMBER SOURCE_SYSTEM_ID SALES_ORDER_LINE_NUMBER SALES_ORDER_NUMBER SALES_ORDER_SHIPMENT_NUMBER DO_NOT_SHIP_BEFORE_DATE DO_NOT_SHIP_AFTER_DATE ORGANIZATION_CODE ORGANIZATION_NAME RELEASED_STATUS_NAME DELIVERY_NAME PARENT_LPN_ID1 PARENT_LPN LINE_OR_LPN SHIPMENT_ADVICE_STATUS ACTUAL_SHIP_DATE CONVERTED_QUANTITY2 CALC_WND_WDD_DATE DEFAULT_TAXATION_COUNTRY FIRST_PTY_REG_ID THIRD_PTY_REG_ID FINAL_DISCHARGE_LOCATION_ID DOCUMENT_SUB_TYPE TRX_BUSINESS_CATEGORY USER_DEFINED_FISC_CLASS TAX_INVOICE_NUMBER TAX_INVOICE_DATE PRODUCT_CATEGORY INTENDED_USE_CLASSIF_ID PRODUCT_TYPE ASSESSABLE_VALUE TAX_CLASSIFICATION_CODE EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE SOURCE_LINE_TYPE SHIP_TO_PARTY_SITE_ID SHIP_TO_LOCATION_TYPE CATEGORY_ID BILL_TO_PARTY_SITE_ID WMS_INTERFACED_FLAG PACKING_SLIP_NUMBER PACKING_SLIP_STATUS PICKED_FROM_SUBINVENTORY END_ASSEMBLY_ITEM_NUMBER TP_STATUS_CODE TP_RECEIVED_DATE TP_SHIPMENT_NUMBER TP_SHIPMENT_LINE TP_INITIAL_LEG_DEST_LOC_ID TRADE_COMPLIANCE_STATUS TRADE_COMPLIANCE_DATE TRADE_COMPLIANCE_REASON TRADE_COMPLIANCE_METHOD FISCAL_DOC_HEADER_ID FISCAL_DOC_LINE_ID QUICK_SHIP_STATUS PROJECT_EXPENSE_FLAG PJC_PROJECT_ID PJC_TASK_ID PROJECT_ID TASK_ID COUNTRY_OF_ORIGIN_CODE INV_STRIPING_CATEGORY INV_RESERVED_ATTRIBUTE1 INV_RESERVED_ATTRIBUTE2 INV_USER_DEF_ATTRIBUTE1 INV_USER_DEF_ATTRIBUTE2 INV_USER_DEF_ATTRIBUTE3 INV_USER_DEF_ATTRIBUTE4 INV_USER_DEF_ATTRIBUTE5 INV_USER_DEF_ATTRIBUTE6 INV_USER_DEF_ATTRIBUTE7 INV_USER_DEF_ATTRIBUTE8 INV_USER_DEF_ATTRIBUTE9 INV_USER_DEF_ATTRIBUTE10 CONVERTED_REQUESTED_QUANTITY ALLOW_ITEM_SUBSTITUTION_FLAG ORIGINAL_ITEM_ID ORIGINAL_DELIVERY_DETAIL_ID NEW_SOURCE_SHIPMENT_ID NEW_SOURCE_SHIPMENT_NUMBER CANCEL_BACKORDERS ENFORCE_SINGLE_SHIPMENT RETURN_TYPE

Query

SQL_Statement

SELECT LPN.LPN_ID ENTITY_ID, LPN.LPN_ID , LPN.LICENSE_PLATE_NUMBER , LPN.INVENTORY_ITEM_ID , LPN.LAST_UPDATE_DATE , LPN.LAST_UPDATED_BY , LPN.CREATION_DATE , LPN.CREATED_BY , LPN.LAST_UPDATE_LOGIN , LPN.REQUEST_ID , LPN.REVISION , LPN.LOT_NUMBER , LPN.SERIAL_NUMBER , LPN.ORGANIZATION_ID , LPN.SUBINVENTORY_CODE SUBINVENTORY , LPN.LOCATOR_ID , LPN.PARENT_LPN_ID , LPN.OUTERMOST_LPN_ID , LPN.GROSS_WEIGHT_UOM_CODE , LPN.GROSS_WEIGHT , LPN.CONTENT_VOLUME_UOM_CODE , LPN.CONTENT_VOLUME , LPN.TARE_WEIGHT_UOM_CODE , LPN.TARE_WEIGHT , LPN.STATUS_ID , LPN.LPN_CONTEXT , LPN.SEALED_STATUS , LPN.LPN_REUSABILITY , LPN.HOMOGENEOUS_CONTAINER , LPN.ATTRIBUTE_CATEGORY , LPN.ATTRIBUTE1 , LPN.ATTRIBUTE2 , LPN.ATTRIBUTE3 , LPN.ATTRIBUTE4 , LPN.ATTRIBUTE5 , LPN.ATTRIBUTE6 , LPN.ATTRIBUTE7 , LPN.ATTRIBUTE8 , LPN.ATTRIBUTE9 , LPN.ATTRIBUTE10 , LPN.ATTRIBUTE11 , LPN.ATTRIBUTE12 , LPN.ATTRIBUTE13 , LPN.ATTRIBUTE14 , LPN.ATTRIBUTE15 , LPN.ATTRIBUTE16 , LPN.ATTRIBUTE17 , LPN.ATTRIBUTE18 , LPN.ATTRIBUTE19 , LPN.ATTRIBUTE20 , LPN.ATTRIBUTE_NUMBER1, LPN.ATTRIBUTE_NUMBER2, LPN.ATTRIBUTE_NUMBER3, LPN.ATTRIBUTE_NUMBER4, LPN.ATTRIBUTE_NUMBER5, LPN.ATTRIBUTE_NUMBER6, LPN.ATTRIBUTE_NUMBER7, LPN.ATTRIBUTE_NUMBER8, LPN.ATTRIBUTE_NUMBER9, LPN.ATTRIBUTE_NUMBER10, LPN.ATTRIBUTE_DATE1, LPN.ATTRIBUTE_DATE2, LPN.ATTRIBUTE_DATE3, LPN.ATTRIBUTE_DATE4, LPN.ATTRIBUTE_DATE5, LPN.ATTRIBUTE_TIMESTAMP1, LPN.ATTRIBUTE_TIMESTAMP2, LPN.ATTRIBUTE_TIMESTAMP3, LPN.ATTRIBUTE_TIMESTAMP4, LPN.ATTRIBUTE_TIMESTAMP5, LPN.SOURCE_TYPE_ID , LPN.SOURCE_HEADER_ID , LPN.SOURCE_LINE_ID , LPN.SOURCE_LINE_DETAIL_ID , LPN.SOURCE_NAME , LPN.CONTAINER_VOLUME VOLUME , LPN.CONTAINER_VOLUME_UOM VOLUME_UOM_CODE , LPN.OBJECT_VERSION_NUMBER , LPN.JOB_DEFINITION_NAME , LPN.JOB_DEFINITION_PACKAGE , LPN.SOLD_TO_PARTY_ID , LPN.SHIP_TO_PARTY_ID , LPN.SHIP_FROM_LOCATION_ID , LPN.SHIP_TO_LOCATION_ID , LPN.FREIGHT_TERMS_CODE , LPN.FOB_CODE , LPN.CARRIER_ID , LPN.SERVICE_LEVEL , LPN.MODE_OF_TRANSPORT , LPN.SHIP_METHOD_CODE , LPN.SHIPPING_INSTRUCTIONS , LPN.PACKING_INSTRUCTIONS , LPN.MASTER_SERIAL_NUMBER , LPN.EARLIEST_PICKUP_DATE , LPN.LATEST_PICKUP_DATE , LPN.EARLIEST_DROPOFF_DATE , LPN.LATEST_DROPOFF_DATE , LPN.WV_FROZEN_FLAG , LPN.FILL_PERCENT , LPN.FILLED_VOLUME , LPN.DELIVERY_ID , LPN.TRACKING_NUMBER , LPN.BATCH_ID , LPN.OUTSOURCER_PARTY_ID , LPN.NET_WEIGHT , LPN.NET_WEIGHT_UOM_CODE , LPN.MAXIMUM_LOAD_WEIGHT , LPN.MAXIMUM_VOLUME , LPN.MINIMUM_FILL_PERCENT , LPN.CONTAINER_TYPE_CODE , LPN.UNIT_WEIGHT , LPN.UNIT_VOLUME , NULL DELIVERY_DETAIL_ID, NULL SOURCE_HEADER_NUMBER, NULL CUST_PO_NUMBER, NULL SOLD_TO_CONTACT_ID, ESIV.DESCRIPTION ITEM_DESCRIPTION, NULL SHIP_TO_CONTACT_ID, NULL SHIP_TOLERANCE_ABOVE, NULL SHIP_TOLERANCE_BELOW, NULL SRC_REQUESTED_QUANTITY, NULL SRC_REQUESTED_QUANTITY_UOM, NULL CANCELLED_QUANTITY, NULL REQUESTED_QUANTITY, NULL REQUESTED_QUANTITY_UOM, NULL SHIPPED_QUANTITY, NULL DELIVERED_QUANTITY, NULL CYCLE_COUNT_QUANTITY, NULL MOVE_ORDER_LINE_ID, NULL RELEASED_STATUS, NULL DATE_REQUESTED, NULL DATE_SCHEDULED, NULL LOAD_SEQ_NUMBER, NULL SHIPMENT_PRIORITY_CODE, NULL CUSTOMER_ITEM_ID, NULL WEIGHT_UOM_CODE, NULL ORG_ID, NULL MVT_STAT_STATUS, NULL TRANSACTION_TEMP_ID, NULL MOVEMENT_ID, NULL SPLIT_FROM_DELIVERY_DETAIL_ID, NULL INV_INTERFACED_FLAG, NULL SOURCE_LINE_NUMBER, LPN.SEAL_CODE, NULL PREFERRED_GRADE, NULL SRC_REQUESTED_QUANTITY2, NULL SRC_REQUESTED_QUANTITY_UOM2, NULL REQUESTED_QUANTITY2, NULL SHIPPED_QUANTITY2, NULL DELIVERED_QUANTITY2, NULL CANCELLED_QUANTITY2, NULL CYCLE_COUNT_QUANTITY2, NULL REQUESTED_QUANTITY_UOM2, NULL UNIT_PRICE, NULL CURRENCY_CODE, NULL LPN_CONTENT_ID, NULL INSPECTION_FLAG, NULL ORIGINAL_SUBINVENTORY, NULL PICKABLE_FLAG, NULL PICKED_QUANTITY, NULL PICKED_QUANTITY2, NULL TRANSACTION_ID, NULL REQUEST_DATE_TYPE_CODE, NULL SOURCE_DOCUMENT_TYPE_ID, NULL BILL_TO_PARTY_ID, NULL BILL_TO_LOCATION_ID, NULL BILL_TO_CONTACT_ID, NULL SHIP_SET_NAME, NULL ARRIVAL_SET_NAME, NULL SOURCE_LINE_UPDATE_DATE, NULL SELLING_PRICE, NULL converted_quantity, NULL source_shipment_id, NULL source_shipment_number, NULL source_system_id, NULL sales_order_line_number, NULL sales_order_number, NULL sales_order_shipment_number, NULL do_not_ship_before_date, NULL do_not_ship_after_date, IOP.ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, LKUP1.meaning RELEASED_STATUS_NAME, WND.DELIVERY_NAME, ParentLPN.lpn_id parent_lpn_id1, ParentLPN.license_plate_number parent_lpn, 'LPN' LINE_OR_LPN, NULL SHIPMENT_ADVICE_STATUS, WND.ACTUAL_SHIP_DATE, NULL CONVERTED_QUANTITY2, NULL CALC_WND_WDD_DATE, NULL DEFAULT_TAXATION_COUNTRY, NULL FIRST_PTY_REG_ID, NULL THIRD_PTY_REG_ID, NULL FINAL_DISCHARGE_LOCATION_ID, NULL DOCUMENT_SUB_TYPE, NULL TRX_BUSINESS_CATEGORY, NULL USER_DEFINED_FISC_CLASS, NULL TAX_INVOICE_NUMBER, NULL TAX_INVOICE_DATE, NULL PRODUCT_CATEGORY, NULL INTENDED_USE_CLASSIF_ID, NULL PRODUCT_TYPE, NULL ASSESSABLE_VALUE, NULL TAX_CLASSIFICATION_CODE, NULL EXEMPT_CERTIFICATE_NUMBER, NULL EXEMPT_REASON_CODE, LPN.SOURCE_LINE_TYPE SOURCE_LINE_TYPE, NULL SHIP_TO_PARTY_SITE_ID, LPN.SHIP_TO_LOCATION_TYPE SHIP_TO_LOCATION_TYPE, NULL CATEGORY_ID, NULL BILL_TO_PARTY_SITE_ID, NULL WMS_INTERFACED_FLAG, WND.PACKING_SLIP_NUMBER, WND.PACKING_SLIP_STATUS, NULL PICKED_FROM_SUBINVENTORY, NULL END_ASSEMBLY_ITEM_NUMBER, NULL TP_STATUS_CODE, NULL TP_RECEIVED_DATE, LPN.TP_SHIPMENT_NUMBER, NULL TP_SHIPMENT_LINE, NULL TP_INITIAL_LEG_DEST_LOC_ID, NULL TRADE_COMPLIANCE_STATUS, NULL TRADE_COMPLIANCE_DATE, NULL TRADE_COMPLIANCE_REASON, NULL TRADE_COMPLIANCE_METHOD, NULL FISCAL_DOC_HEADER_ID, NULL FISCAL_DOC_LINE_ID, NULL QUICK_SHIP_STATUS, NULL PROJECT_EXPENSE_FLAG, NULL PJC_PROJECT_ID, NULL PJC_TASK_ID, NULL PROJECT_ID, NULL TASK_ID, NULL COUNTRY_OF_ORIGIN_CODE, NULL INV_STRIPING_CATEGORY, NULL INV_RESERVED_ATTRIBUTE1, NULL INV_RESERVED_ATTRIBUTE2, NULL INV_USER_DEF_ATTRIBUTE1, NULL INV_USER_DEF_ATTRIBUTE2, NULL INV_USER_DEF_ATTRIBUTE3, NULL INV_USER_DEF_ATTRIBUTE4, NULL INV_USER_DEF_ATTRIBUTE5, NULL INV_USER_DEF_ATTRIBUTE6, NULL INV_USER_DEF_ATTRIBUTE7, NULL INV_USER_DEF_ATTRIBUTE8, NULL INV_USER_DEF_ATTRIBUTE9, NULL INV_USER_DEF_ATTRIBUTE10, NULL CONVERTED_REQUESTED_QUANTITY, NULL ALLOW_ITEM_SUBSTITUTION_FLAG, NULL ORIGINAL_ITEM_ID, NULL ORIGINAL_DELIVERY_DETAIL_ID, NULL NEW_SOURCE_SHIPMENT_ID, NULL NEW_SOURCE_SHIPMENT_NUMBER, NULL CANCEL_BACKORDERS, NULL ENFORCE_SINGLE_SHIPMENT, NULL RETURN_TYPE FROM INV_LICENSE_PLATE_NUMBERS LPN, EGP_SYSTEM_ITEMS_VL ESIV, HR_ALL_ORGANIZATION_UNITS_X HOU, INV_ORG_PARAMETERS IOP, FND_LOOKUP_VALUES_VL LKUP1, WSH_NEW_DELIVERIES WND, INV_LICENSE_PLATE_NUMBERS ParentLPN WHERE IOP.ORGANIZATION_ID = LPN.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = IOP.ORGANIZATION_ID AND LKUP1.lookup_type = 'INV_LPN_CONTEXT' AND LKUP1.lookup_code = LPN.LPN_CONTEXT AND LKUP1.view_application_id = 0 AND LKUP1.set_id = 0 AND LPN.parent_lpn_id = ParentLPN.lpn_id (+) AND LPN.DELIVERY_ID = WND.DELIVERY_ID (+) AND ESIV.inventory_item_id(+) = LPN.INVENTORY_ITEM_ID AND ESIV.organization_id(+) = LPN.organization_id UNION ALL SELECT WDD.DELIVERY_DETAIL_ID ENTITY_ID, NULL LPN_ID, NULL LICENSE_PLATE_NUMBER, wdd.INVENTORY_ITEM_ID , wdd.LAST_UPDATE_DATE , wdd.LAST_UPDATED_BY , wdd.CREATION_DATE , wdd.CREATED_BY , wdd.LAST_UPDATE_LOGIN , wdd.REQUEST_ID , wdd.REVISION , wdd.LOT_NUMBER , wdd.SERIAL_NUMBER , WDD.ORGANIZATION_ID , wdd.SUBINVENTORY , wdd.LOCATOR_ID , wdd.PARENT_LPN_ID , NULL OUTERMOST_LPN_ID, NULL GROSS_WEIGHT_UOM_CODE, wdd.GROSS_WEIGHT , NULL CONTENT_VOLUME_UOM_CODE, NULL CONTENT_VOLUME, NULL TARE_WEIGHT_UOM_CODE, (wdd.gross_weight - wdd.net_weight) TARE_WEIGHT, NULL STATUS_ID, NULL LPN_CONTEXT, NULL SEALED_STATUS, NULL LPN_REUSABILITY, NULL HOMOGENOUS_CONTAINER, wdd.ATTRIBUTE_CATEGORY , wdd.ATTRIBUTE1 , wdd.ATTRIBUTE2 , wdd.ATTRIBUTE3 , wdd.ATTRIBUTE4 , wdd.ATTRIBUTE5 , wdd.ATTRIBUTE6 , wdd.ATTRIBUTE7 , wdd.ATTRIBUTE8 , wdd.ATTRIBUTE9 , wdd.ATTRIBUTE10 , wdd.ATTRIBUTE11 , wdd.ATTRIBUTE12 , wdd.ATTRIBUTE13 , wdd.ATTRIBUTE14 , wdd.ATTRIBUTE15 , wdd.ATTRIBUTE16 , wdd.ATTRIBUTE17 , wdd.ATTRIBUTE18 , wdd.ATTRIBUTE19 , wdd.ATTRIBUTE20 , wdd.ATTRIBUTE_NUMBER1, wdd.ATTRIBUTE_NUMBER2, wdd.ATTRIBUTE_NUMBER3, wdd.ATTRIBUTE_NUMBER4, wdd.ATTRIBUTE_NUMBER5, wdd.ATTRIBUTE_NUMBER6, wdd.ATTRIBUTE_NUMBER7, wdd.ATTRIBUTE_NUMBER8, wdd.ATTRIBUTE_NUMBER9, wdd.ATTRIBUTE_NUMBER10, wdd.ATTRIBUTE_DATE1, wdd.ATTRIBUTE_DATE2, wdd.ATTRIBUTE_DATE3, wdd.ATTRIBUTE_DATE4, wdd.ATTRIBUTE_DATE5, wdd.ATTRIBUTE_TIMESTAMP1, wdd.ATTRIBUTE_TIMESTAMP2, wdd.ATTRIBUTE_TIMESTAMP3, wdd.ATTRIBUTE_TIMESTAMP4, wdd.ATTRIBUTE_TIMESTAMP5, NULL SOURCE_TYPE_ID, wdd.SOURCE_HEADER_ID , wdd.SOURCE_LINE_ID , NULL SOURCE_LINE_DETAIL_ID, NULL SOURCE_NAME, WDD.VOLUME, WDD.VOLUME_UOM_CODE, wdd.OBJECT_VERSION_NUMBER , wdd.JOB_DEFINITION_NAME , wdd.JOB_DEFINITION_PACKAGE , wdd.SOLD_TO_PARTY_ID , wdd.SHIP_TO_PARTY_ID , wdd.SHIP_FROM_LOCATION_ID , wdd.SHIP_TO_LOCATION_ID , wdd.FREIGHT_TERMS_CODE , wdd.FOB_CODE , wdd.CARRIER_ID , wdd.SERVICE_LEVEL , wdd.MODE_OF_TRANSPORT , wdd.SHIP_METHOD_CODE , wdd.SHIPPING_INSTRUCTIONS , wdd.PACKING_INSTRUCTIONS , NULL MASTER_SERIAL_NUMBER , wdd.EARLIEST_PICKUP_DATE , wdd.LATEST_PICKUP_DATE , wdd.EARLIEST_DROPOFF_DATE , wdd.LATEST_DROPOFF_DATE , wdd.WV_FROZEN_FLAG , NULL FILL_PERCENT , NULL FILLED_VOLUME , WDA.DELIVERY_ID , wdd.TRACKING_NUMBER , wdd.BATCH_ID , wdd.OUTSOURCER_PARTY_ID , wdd.NET_WEIGHT , NULL NET_WEIGHT_UOM_CODE, NULL MAXIMUM_LOAD_WEIGHT , NULL MAXIMUM_VOLUME , NULL MINIMUM_FILL_PERCENT , NULL CONTAINER_TYPE_CODE, wdd.UNIT_WEIGHT , wdd.UNIT_VOLUME , WDD.DELIVERY_DETAIL_ID, wdd.SOURCE_HEADER_NUMBER, wdd.CUST_PO_NUMBER, wdd.SOLD_TO_CONTACT_ID, wdd.ITEM_DESCRIPTION, wdd.SHIP_TO_CONTACT_ID, wdd.SHIP_TOLERANCE_ABOVE, wdd.SHIP_TOLERANCE_BELOW, wdd.SRC_REQUESTED_QUANTITY, wdd.SRC_REQUESTED_QUANTITY_UOM, wdd.CANCELLED_QUANTITY, wdd.REQUESTED_QUANTITY, wdd.REQUESTED_QUANTITY_UOM, wdd.SHIPPED_QUANTITY, wdd.DELIVERED_QUANTITY, wdd.CYCLE_COUNT_QUANTITY, wdd.MOVE_ORDER_LINE_ID, wdd.RELEASED_STATUS, wdd.DATE_REQUESTED, wdd.DATE_SCHEDULED, wdd.LOAD_SEQ_NUMBER, wdd.SHIPMENT_PRIORITY_CODE, wdd.CUSTOMER_ITEM_ID, wdd.WEIGHT_UOM_CODE, wdd.ORG_ID, wdd.MVT_STAT_STATUS, wdd.TRANSACTION_TEMP_ID, wdd.MOVEMENT_ID, wdd.SPLIT_FROM_DELIVERY_DETAIL_ID, wdd.INV_INTERFACED_FLAG, wdd.SOURCE_LINE_NUMBER, WDD.SEAL_CODE, wdd.PREFERRED_GRADE, wdd.SRC_REQUESTED_QUANTITY2, wdd.SRC_REQUESTED_QUANTITY_UOM2, wdd.REQUESTED_QUANTITY2, wdd.SHIPPED_QUANTITY2, wdd.DELIVERED_QUANTITY2, wdd.CANCELLED_QUANTITY2, wdd.CYCLE_COUNT_QUANTITY2, wdd.REQUESTED_QUANTITY_UOM2, wdd.UNIT_PRICE, WDD.CURRENCY_CODE, wdd.LPN_CONTENT_ID, wdd.INSPECTION_FLAG, wdd.ORIGINAL_SUBINVENTORY, wdd.PICKABLE_FLAG, wdd.PICKED_QUANTITY, wdd.PICKED_QUANTITY2, wdd.TRANSACTION_ID, wdd.REQUEST_DATE_TYPE_CODE, wdd.SOURCE_DOCUMENT_TYPE_ID, wdd.BILL_TO_PARTY_ID, wdd.BILL_TO_LOCATION_ID, wdd.BILL_TO_CONTACT_ID, wdd.SHIP_SET_NAME, wdd.ARRIVAL_SET_NAME, wdd.SOURCE_LINE_UPDATE_DATE, wdd.SELLING_PRICE, wdd.converted_quantity, wdd.source_shipment_id, wdd.source_shipment_number, wdd.source_system_id, wdd.sales_order_line_number, wdd.sales_order_number, wdd.sales_order_shipment_number, wdd.do_not_ship_before_date, wdd.do_not_ship_after_date, IOP.ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, LKUP1.meaning RELEASED_STATUS_NAME, WND.DELIVERY_NAME, NULL parent_lpn_id1, LPN.LICENSE_PLATE_NUMBER parent_lpn, 'LINE' LINE_OR_LPN, WDD.SHIPMENT_ADVICE_STATUS, WND.ACTUAL_SHIP_DATE, WDD.CONVERTED_QUANTITY2, WDD.CALC_WND_WDD_DATE, WDD.DEFAULT_TAXATION_COUNTRY, WDD.FIRST_PTY_REG_ID, WDD.THIRD_PTY_REG_ID, WDD.FINAL_DISCHARGE_LOCATION_ID, WDD.DOCUMENT_SUB_TYPE, WDD.TRX_BUSINESS_CATEGORY, WDD.USER_DEFINED_FISC_CLASS, WDD.TAX_INVOICE_NUMBER, WDD.TAX_INVOICE_DATE, WDD.PRODUCT_CATEGORY, WDD.INTENDED_USE_CLASSIF_ID, WDD.PRODUCT_TYPE, WDD.ASSESSABLE_VALUE, WDD.TAX_CLASSIFICATION_CODE, WDD.EXEMPT_CERTIFICATE_NUMBER, WDD.EXEMPT_REASON_CODE, WDD.SOURCE_LINE_TYPE, WDD.SHIP_TO_PARTY_SITE_ID, WDD.SHIP_TO_LOCATION_TYPE, WDD.CATEGORY_ID, WDD.BILL_TO_PARTY_SITE_ID, WDD.WMS_INTERFACED_FLAG, WND.PACKING_SLIP_NUMBER, WND.PACKING_SLIP_STATUS, WDD.PICKED_FROM_SUBINVENTORY, WDD.END_ASSEMBLY_ITEM_NUMBER, WDD.TP_STATUS_CODE, WDD.TP_RECEIVED_DATE, WDD.TP_SHIPMENT_NUMBER, WDD.TP_SHIPMENT_LINE, WDD.TP_INITIAL_LEG_DEST_LOC_ID, WDD.TRADE_COMPLIANCE_STATUS, WDD.TRADE_COMPLIANCE_DATE, WDD.TRADE_COMPLIANCE_REASON, WDD.TRADE_COMPLIANCE_METHOD, WDD.FISCAL_DOC_HEADER_ID, WDD.FISCAL_DOC_LINE_ID, WDD.QUICK_SHIP_STATUS, WDD.PROJECT_EXPENSE_FLAG, WDD.PJC_PROJECT_ID, WDD.PJC_TASK_ID, WDD.PROJECT_ID, WDD.TASK_ID, WDD.COUNTRY_OF_ORIGIN_CODE, WDD.INV_STRIPING_CATEGORY, WDD.INV_RESERVED_ATTRIBUTE1, WDD.INV_RESERVED_ATTRIBUTE2, WDD.INV_USER_DEF_ATTRIBUTE1, WDD.INV_USER_DEF_ATTRIBUTE2, WDD.INV_USER_DEF_ATTRIBUTE3, WDD.INV_USER_DEF_ATTRIBUTE4, WDD.INV_USER_DEF_ATTRIBUTE5, WDD.INV_USER_DEF_ATTRIBUTE6, WDD.INV_USER_DEF_ATTRIBUTE7, WDD.INV_USER_DEF_ATTRIBUTE8, WDD.INV_USER_DEF_ATTRIBUTE9, WDD.INV_USER_DEF_ATTRIBUTE10, WDD.CONVERTED_REQUESTED_QUANTITY, WDD.ALLOW_ITEM_SUBSTITUTION_FLAG, WDD.ORIGINAL_ITEM_ID, WDD.ORIGINAL_DELIVERY_DETAIL_ID, WDD.NEW_SOURCE_SHIPMENT_ID, WDD.NEW_SOURCE_SHIPMENT_NUMBER, WDD.CANCEL_BACKORDERS, WDD.ENFORCE_SINGLE_SHIPMENT, WDD.RETURN_TYPE FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, HR_ALL_ORGANIZATION_UNITS_X HOU, INV_ORG_PARAMETERS IOP, FND_LOOKUP_VALUES_VL LKUP1,WSH_NEW_DELIVERIES WND, INV_LICENSE_PLATE_NUMBERS LPN WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.parent_lpn_id = LPN.lpn_id(+) AND IOP.ORGANIZATION_ID = WDD.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = IOP.ORGANIZATION_ID AND LKUP1.lookup_type = 'WSH_PICK_STATUS' AND LKUP1.lookup_code = WDD.RELEASED_STATUS AND LKUP1.view_application_id = 0 AND LKUP1.set_id = 0 AND WDA.DELIVERY_ID = WND.DELIVERY_ID(+)