DBA Data[Home] [Help]

APPS.CTO_AUTO_DROPSHIP_PK dependencies on STANDARD

Line 269: --' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||

265: 'from oe_order_lines_all oelc '||
266: 'where oelc.ato_line_id = :p_sales_order_line_id '||
267: 'and (oelc.item_type_code = ''CONFIG'' '||
268: --Adding INCLUDED item type code for SUN ER#9793792
269: --' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||
270: ' or (oelc.item_type_code in (''STANDARD'',''OPTION'',''INCLUDED'') '||
271: ' and ato_line_id = line_id)) '||
272: ') ';
273: end if;

Line 270: ' or (oelc.item_type_code in (''STANDARD'',''OPTION'',''INCLUDED'') '||

266: 'where oelc.ato_line_id = :p_sales_order_line_id '||
267: 'and (oelc.item_type_code = ''CONFIG'' '||
268: --Adding INCLUDED item type code for SUN ER#9793792
269: --' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||
270: ' or (oelc.item_type_code in (''STANDARD'',''OPTION'',''INCLUDED'') '||
271: ' and ato_line_id = line_id)) '||
272: ') ';
273: end if;
274: