APPS.WMS_CROSS_DOCK_PVT dependencies on WSH_INV_DELIVERY_DETAILS_V

Line 1494: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;

1490:
1491: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
1492:
1493: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1494: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
1495: l_prim_qty NUMBER;
1496: l_primary_temp_qty NUMBER;
1497: l_prim_uom VARCHAR2(3);
1498: l_sub VARCHAR2(10);

Line 1720: from wsh_inv_delivery_details_v

1716: END IF;
1717:
1718: -- Create Reservation
1719: SELECT * INTO l_demand_info
1720: from wsh_inv_delivery_details_v
1721: WHERE delivery_detail_id=l_del_id;
1722:
1723:
1724: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.

Line 2057: from wsh_inv_delivery_details_v

2053: -- UPDATE SHIPPING
2054: -- TEST should modify to get from demand info
2055: select oe_header_id, oe_line_id
2056: into l_source_header_id, l_source_line_id
2057: from wsh_inv_delivery_details_v
2058: WHERE delivery_detail_id=l_del_id;
2059:
2060: /*9695544.added below query*/
2061: SELECT requested_quantity INTO l_wdd_req_qty