INV_RSVS_SPLIT_ORDER_LINES_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

FULFILL_LINE_ID PRIMARY_RSV_QUANTITY RSV_ROW_ID RESERVATION_ID ORDER_INTERFACE_STATUS BACK_TO_BACK_FLAG ORGANIZATION_ID INVENTORY_ITEM_ID DEMAND_SOURCE_TYPE_ID DEMAND_SOURCE_NAME DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_LINE_ID SOURCE_LINE_NUMBER SALES_ORDER_LINE_NUMBER SOURCE_FULFILLMENT_LINE_ID SOURCE_SHIPMENT_NUMBER SALES_ORDER_SHIPMENT_NUMBER DEMAND_SOURCE_DELIVERY SHIP_TO_PARTY_ID PRIMARY_UOM_CODE RESERVATION_UOM_CODE RESERVATION_QUANTITY PRIMARY_RESERVATION_QUANTITY SUPPLY_SOURCE_TYPE_ID SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_LINE_ID SUPPLY_SOURCE_LINE_DETAIL SUPPLY_SOURCE_NAME REVISION SUBINVENTORY_CODE LOCATOR_ID LOT_NUMBER LPN_ID REQUIREMENT_DATE SHIP_READY_FLAG DETAILED_QUANTITY CONTAINER_LPN_ID STAGED_FLAG SECONDARY_DETAILED_QUANTITY SECONDARY_RESERVATION_QUANTITY SECONDARY_UOM_CODE CROSSDOCK_FLAG CROSSDOCK_CRITERIA_ID DEMAND_SOURCE_LINE_DETAIL SERIAL_RESERVATION_QUANTITY SUPPLY_RECEIPT_DATE DEMAND_SHIP_DATE EXCEPTION_CODE ORIG_SUPPLY_SOURCE_TYPE_ID ORIG_SUPPLY_SOURCE_HEADER_ID ORIG_SUPPLY_SOURCE_LINE_ID ORIG_SUPPLY_SOURCE_LINE_DETAIL ORIG_DEMAND_SOURCE_TYPE_ID ORIG_DEMAND_SOURCE_HEADER_ID ORIG_DEMAND_SOURCE_LINE_ID ORIG_DEMAND_SOURCE_LINE_NUMBER ORIG_DEMAND_SOURCE_LINE_DETAIL CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PROJECT_ID TASK_ID OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE INV_STRIPING_CATEGORY COUNTRY_OF_ORIGIN_CODE 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_ATTRIBUTE8 INV_USER_DEF_ATTRIBUTE9 INV_USER_DEF_ATTRIBUTE10

Query

SQL_Statement

SELECT DISTINCT dfla.fulfill_line_id fulfill_line_id, ir.primary_reservation_quantity primary_rsv_quantity, ir.rowid RSV_ROW_ID, ir.reservation_id, ir.order_interface_status, ir.back_to_back_flag, ir.organization_id, ir.inventory_item_id, ir.demand_source_type_id, ir.demand_source_name, ir.demand_source_header_id, ir.demand_source_line_id, ir.source_line_number, ir.sales_order_line_number, ir.source_fulfillment_line_id, ir.source_shipment_number, ir.sales_order_shipment_number, ir.demand_source_delivery, ir.ship_to_party_id, ir.primary_uom_code, ir.reservation_uom_code, ir.reservation_quantity, ir.primary_reservation_quantity, ir.supply_source_type_id, ir.supply_source_header_id, ir.supply_source_line_id, ir.supply_source_line_detail, ir.supply_source_name, ir.revision, ir.subinventory_code, ir.locator_id, ir.lot_number, ir.lpn_id, ir.requirement_date, ir.ship_ready_flag, ir.detailed_quantity, ir.container_lpn_id, ir.staged_flag, ir.secondary_detailed_quantity, ir.secondary_reservation_quantity, ir.secondary_uom_code, ir.crossdock_flag, ir.crossdock_criteria_id, ir.demand_source_line_detail, ir.serial_reservation_quantity, ir.supply_receipt_date, ir.demand_ship_date, ir.exception_code, ir.orig_supply_source_type_id, ir.orig_supply_source_header_id, ir.orig_supply_source_line_id, ir.orig_supply_source_line_detail, ir.orig_demand_source_type_id, ir.orig_demand_source_header_id, ir.orig_demand_source_line_id, ir.orig_demand_source_line_number, ir.orig_demand_source_line_detail, ir.created_by, ir.creation_date, ir.last_updated_by, ir.last_update_date, ir.last_update_login, ir.project_id, ir.task_id, ir.object_version_number, ir.request_id, ir.job_definition_name, ir.job_definition_package, ir.inv_striping_category, ir.country_of_origin_code, ir.inv_reserved_attribute1, ir.inv_reserved_attribute2, ir.inv_user_def_attribute1, ir.inv_user_def_attribute2, ir.inv_user_def_attribute3, ir.inv_user_def_attribute4, ir.inv_user_def_attribute5, ir.inv_user_def_attribute6, ir.inv_user_def_attribute8, ir.inv_user_def_attribute9, ir.inv_user_def_attribute10 FROM inv_reservations ir , wsh_delivery_details wdd , doo_fulfill_lines_all dfla WHERE wdd.source_shipment_id = dfla.fulfillment_split_ref_id AND dfla.shipped_qty IS NULL AND ir.demand_source_header_id = wdd.source_header_id AND ir.demand_source_line_id = wdd.source_line_id