APPS.OE_INVOICE_PUB dependencies on OE_SETS

Line 2055: select set_type into l_set_type from oe_sets where set_id = p_line_rec.line_set_id;

2051:
2052: -- changes for bug 3728587 start
2053: --check if line is splitted or not
2054: if(p_line_rec.line_set_id is not null) then
2055: select set_type into l_set_type from oe_sets where set_id = p_line_rec.line_set_id;
2056: end if;
2057: oe_debug_pub.add('l_set_type = '||l_set_type, 5 ) ;
2058:
2059: if(l_set_type = 'SPLIT') then

Line 5994: oe_sets os

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');
5998: EXCEPTION WHEN NO_DATA_FOUND THEN