DBA Data[Home] [Help]

APPS.OE_QUERY dependencies on SO_RMA_MTL_INT_V

Line 908: from so_rma_mtl_int_v mtlint,

904: nvl( min( mtlint.received_quantity *
905: (lin.Ordered_Quantity - nvl(lin.cancelled_quantity,0)) /
906: mtlint.interfaced_quantity),0))
907: into l_qty_received
908: from so_rma_mtl_int_v mtlint,
909: so_lines lin
910: where mtlint.rma_line_id = p_line_id
911: and lin.line_id = p_line_id
912: group by lin.line_id,

Line 1041: from so_rma_mtl_int_v mtlint,

1037: nvl( min( mtlint.accepted_quantity *
1038: (lin.Ordered_Quantity - nvl(lin.cancelled_quantity,0)) /
1039: mtlint.interfaced_quantity),0))
1040: into l_qty_received
1041: from so_rma_mtl_int_v mtlint,
1042: so_lines lin
1043: where mtlint.rma_line_id = p_line_id
1044: and lin.line_id = p_line_id
1045: group by lin.line_id,