APPS.AHL_MM_MTL_MGT_PVT dependencies on WSH_DELIVERY_DETAILS

Line 3085: FROM WSH_DELIVERY_DETAILS

3081: -- get the delivery line status.
3082: BEGIN
3083: SELECT released_status,requested_quantity,requested_quantity_uom,delivery_detail_id
3084: INTO l_delivery_status,l_requested_qty,l_transaction_uom,l_delivery_detail_id
3085: FROM WSH_DELIVERY_DETAILS
3086: WHERE SOURCE_HEADER_ID = P_ORDER_HEADER_ID
3087: and released_status not in ('S', 'Y', 'C');
3088: EXCEPTION
3089: WHEN NO_DATA_FOUND THEN

Line 3284: FROM wsh_delivery_details wdd,

3280: SELECT mtrh.header_id,mmtt.transaction_temp_id,
3281: mtrl.line_id,wdd.delivery_detail_id
3282: INTO l_move_order_hdr_id,l_mmtt_temp_id,
3283: l_move_order_line_id,G_DELIVERY_DETAIL_ID
3284: FROM wsh_delivery_details wdd,
3285: mtl_txn_request_headers mtrh,
3286: mtl_txn_request_lines mtrl,
3287: mtl_material_transactions_temp mmtt
3288: WHERE wdd.source_header_id = p_order_header_id

Line 3312: FROM wsh_delivery_details wdd

3308: -- we would need to create the allocation here. We make use of inv_replenish_detail_pub.line_details
3309: -- to create the allocations.
3310: SELECT wdd.move_order_line_id
3311: INTO l_move_order_line_id
3312: FROM wsh_delivery_details wdd
3313: WHERE wdd.source_header_id = p_order_header_id;
3314:
3315: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3316: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'Creating the allocations for move line id'||l_move_order_line_id);

Line 3615: FROM wsh_delivery_details

3611: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'Checking if the delivery is successfully pick released. DDID='||l_delivery_detail_id);
3612: END IF;
3613: SELECT released_status,delivery_detail_id,picked_quantity
3614: INTO l_delivery_status,l_delivery_detail_id_new,l_picked_qty
3615: FROM wsh_delivery_details
3616: WHERE move_order_line_id = l_move_order_line_id;
3617:
3618: IF l_delivery_status <> 'Y'
3619: THEN

Line 5936: || ' WSH_DELIVERY_DETAILS WDD,'

5932: || ' OE_ORDER_HEADERS_ALL OOHA,'
5933: || ' MTL_SERIAL_NUMBERS MSN,'
5934: || ' CSI_ITEM_INSTANCES CSIII,'
5935: || ' MTL_SERIAL_NUMBERS_TEMP MSNT,'
5936: || ' WSH_DELIVERY_DETAILS WDD,'
5937: || ' WSH_SERIAL_NUMBERS WSN,'
5938: || ' AHL_MM_TXN_INTERFACE AMTI'
5939: || ' WHERE PRHA.REQUISITION_HEADER_ID = OOHA.SOURCE_DOCUMENT_ID'
5940: || ' AND OOHA.HEADER_ID = WDD.SOURCE_HEADER_ID'