DBA Data[Home] [Help]

APPS.INV_INVKBCPR_XMLP_PKG SQL Statements

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

Line: 29

                   ,'Failed in before report trigger, item select. ')*/NULL;
Line: 37

                   ,'Failed in before report trigger, locator select. ')*/NULL;
Line: 45

                   ,'Failed in before report trigger, source locator select. ')*/NULL;
Line: 118

        P_CALL_WHERE := P_CALL_WHERE || ' AND (MKC.KANBAN_CARD_ID IN ( SELECT MKBNT.KANBAN_CARD_ID FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
                        			WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')
                        		  OR MKC.KANBAN_CARD_ID IN ( SELECT MKC.KANBAN_CARD_ID FROM MTL_KANBAN_CARDS MKC WHERE
                        			MKC.PULL_SEQUENCE_ID IN ( SELECT MKBNT.PULL_SEQUENCE_ID
                        				 FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
                        				WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')))';
Line: 149

        DELETE FROM MTL_KANBAN_CARD_PRINT_TEMP
         WHERE REPORT_ID = P_REPORT_ID;