DBA Data[Home] [Help]

APPS.OE_QUERY dependencies on SO_RMA_MTL_INT_DETAIL_V

Line 938: FROM SO_RMA_MTL_INT_DETAIL_V MTLINT

934: /* Components are frozen so ratios exist */
935: IF (l_included_item_count > 0) THEN
936: SELECT floor(nvl(min(MTLINT.Received_Quantity),0))
937: INTO l_qty_received
938: FROM SO_RMA_MTL_INT_DETAIL_V MTLINT
939: WHERE MTLINT.Detail_line_id = l_link_to_line_id
940: AND MTLINT.RMA_LINE_ID = P_Line_Id;
941:
942: /* Components were not frozen at the time return was created. */

Line 1071: FROM SO_RMA_MTL_INT_DETAIL_V MTLINT

1067: /* Components are frozen so ratios exist */
1068: IF (l_included_item_count > 0) THEN
1069: SELECT floor(nvl(min(MTLINT.Accepted_Quantity),0))
1070: INTO l_qty_received
1071: FROM SO_RMA_MTL_INT_DETAIL_V MTLINT
1072: WHERE MTLINT.Detail_line_id = l_link_to_line_id
1073: AND MTLINT.RMA_LINE_ID = P_Line_Id;
1074:
1075: /* Components were not frozen at the time return was created. */