DBA Data[Home] [Help]

APPS.BIM_TARGET_SEGMENT_PKG SQL Statements

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

Line: 13

	SELECT CELL_ID
	FROM
		AMS_CELLS_ALL_B CELL,
		AMS_LIST_ENTRIES LIST
	WHERE
		LIST.CUSTOMER_ID = P_CUSTOMER_ID AND
		LIST.SOURCE_CODE = P_SOURCE_CODE AND
		CELL.CELL_CODE = LIST.CELL_CODE AND
		MARKED_AS_DUPLICATE_FLAG = 'N'
	ORDER BY LIST_ENTRY_ID DESC;