DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WSH_DELIVERY_DETAILS

Line 9735: FROM wsh_delivery_details

9731: IF p_transaction_type_id in (52,53) THEN --sales orders, internal orders
9732: BEGIN
9733: SELECT source_header_type_id, source_header_id, source_line_id
9734: INTO l_source_type_id, l_source_header_id, l_source_line_id
9735: FROM wsh_delivery_details
9736: WHERE move_order_line_id = p_transaction_temp_id
9737: AND rownum = 1;
9738: EXCEPTION
9739: WHEN NO_DATA_FOUND THEN

Line 11231: FROM wsh_delivery_details

11227: IF p_transaction_type_id in (52,53) THEN --sales orders, internal orders
11228: BEGIN
11229: SELECT source_header_type_id, source_header_id, source_line_id
11230: INTO l_source_type_id, l_source_header_id, l_source_line_id
11231: FROM wsh_delivery_details
11232: WHERE move_order_line_id = p_transaction_temp_id
11233: AND rownum = 1;
11234: EXCEPTION
11235: WHEN NO_DATA_FOUND THEN