DBA Data[Home] [Help]

APPS.BOM_BOMRDDEL_XMLP_PKG SQL Statements

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

Line: 24

        RETURN ('and bdg.DELETE_GROUP_NAME between ''' || GROUP_FROM || ''' and ''' || GROUP_TO || '''');
Line: 27

          RETURN ('and bdg.DELETE_GROUP_NAME like ''' || GROUP_FROM || '''');
Line: 30

            RETURN ('and bdg.DELETE_GROUP_NAME like ''' || GROUP_TO || '''');
Line: 86

      RETURN ('and bdg.DELETE_TYPE in ( ' || ITEM_TYPE || ', ' || BILL_TYPE || ', ' || ROUT_TYPE || ', ' || COMP_TYPE || ', ' || OPER_TYPE || ', ' || BR_TYPE || ', ' || IBR_TYPE || ')');
Line: 137

      RETURN ('and bdg.DELETE_TYPE in ( ' || ITEM_TYPE || ', ' || BILL_TYPE || ', ' || ROUT_TYPE || ', ' || COMP_TYPE || ', ' || OPER_TYPE || ', ' || BR_TYPE || ', ' || IBR_TYPE || ')');
Line: 170

      RETURN ('and ( bde.delete_status_type is null or bde.DELETE_STATUS_TYPE in ( ' || PEND || ', ' || CHECK_OK || ', ' || ERROR || ', ' || DEL || '))');
Line: 203

      RETURN ('and ( bdse.delete_status_type is null or bdse.DELETE_STATUS_TYPE in ( ' || PEND || ', ' || CHECK_OK || ', ' || ERROR || ', ' || DEL || '))');