DBA Data[Home] [Help]

APPS.INV_INVPRFDH_XMLP_PKG SQL Statements

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

Line: 16

	(select  MIC.INVENTORY_ITEM_ID from MTL_ITEM_CATEGORIES  MIC, MTL_CATEGORIES MC
	where  MIC.CATEGORY_SET_ID =''' || CAT_SET || ''' and ' || CAT_WHERE || '
	and MIC.organization_id = ''' || ORG || ''' and MC.CATEGORY_ID =MIC.CATEGORY_ID)');
Line: 43

                   ,'Item Flex Select failed in before report trigger')*/NULL;