APPS.OE_INVOICE_PUB dependencies on OE_LINE_SETS

Line 6234: oe_line_sets ols

6230: BEGIN
6231: SELECT max(actual_shipment_date)
6232: INTO l_max_actual_shipment_date
6233: FROM oe_order_lines_all ool,
6234: oe_line_sets ols
6235: WHERE ool.shippable_flag = 'Y'
6236: AND ool.line_id = ols.line_id
6237: AND ols.set_id IN (SELECT os.set_id
6238: FROM oe_line_sets ls,

Line 6238: FROM oe_line_sets ls,

6234: oe_line_sets ols
6235: WHERE ool.shippable_flag = 'Y'
6236: AND ool.line_id = ols.line_id
6237: AND ols.set_id IN (SELECT os.set_id
6238: FROM oe_line_sets ls,
6239: oe_sets os
6240: WHERE ls.line_id = p_line_rec.line_id
6241: AND ls.set_id = os.set_id
6242: AND os.set_type='FULFILLMENT_SET');