DBA Data[Home] [Help]

APPS.OE_COGS_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 115

                         SELECT 'Y' INTO l_notify_costing
			    FROM DUAL WHERE EXISTS (SELECT l.line_id
                                                     FROM oe_order_lines_all l,
                                                          mtl_system_items msi
                                                     WHERE link_to_line_id = p_line_id
                                                     AND   l.inventory_item_id=msi.inventory_item_id
                                                     AND   msi.organization_id= l_master_org_id
                                                     AND   (msi.invoice_enabled_flag =	'N'
						            OR msi.invoiceable_item_flag = 'N'
							    OR l.item_type_code='INCLUDED'
                                                            OR l.item_type_code='CONFIG'));