DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_SETS

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

2268:
2269: -- changes for bug 3728587 start
2270: --check if line is splitted or not
2271: if(p_line_rec.line_set_id is not null) then
2272: select set_type into l_set_type from oe_sets where set_id = p_line_rec.line_set_id;
2273: end if;
2274: oe_debug_pub.add('l_set_type = '||l_set_type, 5 ) ;
2275:
2276: if(l_set_type = 'SPLIT') then

Line 6239: oe_sets os

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