MSC_SO_FULFILL_LINES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
FULFILL_LINE_ID FULFILL_ORG_INSTANCE_ID CUSTOMER_SITE_ID ITEM_ID PROMISING_TYPE REQUESTED_DATE SCHEDULE_ARRIVAL_DATE SCHEDULE_SHIP_DATE ORDERED_QTY ORCH_ORDER_HEADER_ID ORCH_ORDER_LINE_ID ORDERED_UOM FULFILL_ORG_ID SOURCE_ORG_ID RESERVATION_QUANTITY DEMAND_CLASS RESERVATION_DATE CARRIER SERVICE SHIP_MODE_OF_TRANSPORT

Query

SQL_Statement

SELECT doo.fulfill_line_id , null fulfill_org_instance_id, doo.ship_to_site_use_id customer_site_id, doo.inventory_item_id item_id, decode(doo.request_ship_date,NULL,'Arrival', 'Ship') promising_type, nvl(doo.request_ship_date, doo.request_arrival_date) requested_date, doo.schedule_arrival_date, doo.schedule_ship_date, doo.ordered_qty, doo.header_id orch_order_header_id, doo.line_id orch_order_line_id, doo.ordered_uom, doo.FULFILL_ORG_ID, doo.source_org_id, doo.reserved_qty reservation_quantity, doo.demand_class_code demand_class, doo.schedule_ship_date reservation_date, doo.carrier_id carrier, doo.ship_class_of_service service, doo.ship_mode_of_transport FROM doo_fulfill_lines_all doo, msc_parameters orgs WHERE doo.schedule_ship_date IS NOT NULL AND doo.ordered_qty <> 0 AND orgs.organization_id = doo.FULFILL_ORG_ID And doo.ordered_qty > nvl(doo.shipped_qty,0)