APPS.OE_INVOICE_PUB dependencies on OE_LINE_SETS

Line 5989: oe_line_sets ols

5985: BEGIN
5986: SELECT max(actual_shipment_date)
5987: INTO l_max_actual_shipment_date
5988: FROM oe_order_lines_all ool,
5989: oe_line_sets ols
5990: WHERE ool.shippable_flag = 'Y'
5991: AND ool.line_id = ols.line_id
5992: AND ols.set_id IN (SELECT os.set_id
5993: FROM oe_line_sets ls,

Line 5993: FROM oe_line_sets ls,

5989: oe_line_sets ols
5990: WHERE ool.shippable_flag = 'Y'
5991: AND ool.line_id = ols.line_id
5992: AND ols.set_id IN (SELECT os.set_id
5993: FROM oe_line_sets ls,
5994: oe_sets os
5995: WHERE ls.line_id = p_line_rec.line_id
5996: AND ls.set_id = os.set_id
5997: AND os.set_type='FULFILLMENT_SET');