APPS.MTL_SERIAL_CHECK SQL Statements

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

Line: 427

     * Get the next sequence number for this 'object' and insert
     * into GEN_OBJECT_ID field : Object Genealogy
     */

    SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL
    INTO l_obj_seq_num FROM DUAL;

Line: 439

   		  mdebug('Inserting row with SL NO '||l_serial_number);

Line: 441

		  INSERT INTO MTL_SERIAL_NUMBERS
		    (INVENTORY_ITEM_ID,
		    SERIAL_NUMBER,
		    LAST_UPDATE_DATE,
		    LAST_UPDATED_BY,
		    INITIALIZATION_DATE,
		    CREATION_DATE,
		    CREATED_BY,
		    LAST_UPDATE_LOGIN,
		    CURRENT_STATUS,
		    CURRENT_ORGANIZATION_ID,
        GEN_OBJECT_ID)
		    VALUES
		    (P_Item_id, l_serial_number, sysdate,
		    l_user_id, sysdate, sysdate,
		    l_user_id, -1, 6, P_organization_id,l_obj_seq_num);

Line: 460

   		     mdebug('Inserted row with SL NO '||l_serial_number);

Line: 464

   		     mdebug('Inserted failure');

Line: 471

   		     mdebug('Exception : Inserted failure:');

Line: 665

         SELECT  'X'
         INTO    L_nothing
         FROM    MTL_SERIAL_NUMBERS
         WHERE   SERIAL_NUMBER = P_serial_number
         AND     CURRENT_ORGANIZATION_ID + 0 = P_org_id;

Line: 691

	 SELECT 'x'
	   INTO L_nothing
	     FROM MTL_SERIAL_NUMBERS S,
	     MTL_PARAMETERS P
	     WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
	     AND S.SERIAL_NUMBER = P_serial_number
	     AND P.SERIAL_NUMBER_TYPE = 3;

Line: 720

         SELECT 'x'
         INTO L_nothing
         FROM MTL_SERIAL_NUMBERS
         WHERE SERIAL_NUMBER = P_serial_number;

Line: 975

     SELECT  decode(current_status,6,1,current_status),
       revision,
       lot_number,
       current_subinventory_code,
       current_locator_id,
       current_organization_id,
       original_wip_entity_id
       INTO    L_current_status,
       L_current_revision,
       L_current_lot_number,
       L_current_subinventory,
       L_current_locator_id,
       L_current_organization_id,
       L_wip_entity_id
       FROM    MTL_SERIAL_NUMBERS
       WHERE   inventory_item_id = P_Item_id
       AND     serial_number = P_serial_number;