DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on WSH_INV_DELIVERY_DETAILS_V

Line 1219: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;

1215:
1216: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
1217:
1218: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1219: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
1220: l_prim_qty NUMBER;
1221: l_primary_temp_qty NUMBER;
1222: l_prim_uom VARCHAR2(3);
1223: l_sub VARCHAR2(10);

Line 1429: from wsh_inv_delivery_details_v

1425: END IF;
1426:
1427: -- Create Reservation
1428: SELECT * INTO l_demand_info
1429: from wsh_inv_delivery_details_v
1430: WHERE delivery_detail_id=l_del_id;
1431:
1432:
1433: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.

Line 1757: from wsh_inv_delivery_details_v

1753: -- UPDATE SHIPPING
1754: -- TEST should modify to get from demand info
1755: select oe_header_id, oe_line_id
1756: into l_source_header_id, l_source_line_id
1757: from wsh_inv_delivery_details_v
1758: WHERE delivery_detail_id=l_del_id;
1759:
1760: IF ((l_serial_control_code>1 AND l_serial_control_code<>6)
1761: OR l_lot_control_code > 1) THEN