DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on OE_LINE_TYPES_V

Line 106: FROM OE_ORDER_LINES_ALL OLA, OE_LINE_TYPES_V OLT

102:
103: -- Cursor to get all the RMA type lines for the given sales order.
104: CURSOR get_rma_lines (c_oe_header_id NUMBER) IS
105: SELECT OLA.line_id
106: FROM OE_ORDER_LINES_ALL OLA, OE_LINE_TYPES_V OLT
107: WHERE OLA.header_id = c_oe_header_id
108: AND OLT.line_type_id = OLA.line_type_id
109: AND OLT.order_category_code = 'RETURN';
110: