eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CC_TRANSACT_PKG SQL Statements

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

Line: 213


      SELECT mtl_material_transactions_s.NEXTVAL
        INTO l_transaction_temp_id
        FROM dual;

Line: 236


         INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
           (
             TRANSACTION_HEADER_ID,
             TRANSACTION_TEMP_ID,
             INVENTORY_ITEM_ID,
             SUBINVENTORY_CODE,
             PRIMARY_QUANTITY,
             TRANSACTION_QUANTITY,
             TRANSACTION_UOM,
             TRANSACTION_DATE,
             ORGANIZATION_ID,
             ACCT_PERIOD_ID,
             TRANSACTION_MODE,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             TRANSACTION_SOURCE_ID,
             TRANSACTION_SOURCE_TYPE_ID,
             CYCLE_COUNT_ID,
             TRANSACTION_TYPE_ID,
             TRANSACTION_ACTION_ID,
             TRANSACTION_REFERENCE,
             REASON_ID,
             DISTRIBUTION_ACCOUNT_ID,
             --LOT_NUMBER,
             --WAYBILL_AIRBILL, /* Lot expiration date */
             REVISION,
             LOCATOR_ID,
             --SERIAL_NUMBER,
             PROCESS_FLAG,
             LAST_UPDATE_LOGIN,
             CREATED_BY,
             CREATION_DATE,
             LPN_ID,
             TRANSFER_SUBINVENTORY,
             TRANSFER_TO_LOCATION,
             COST_GROUP_ID,
             TRANSACTION_BATCH_ID,
             TRANSACTION_BATCH_SEQ,
         -- BEGIN INVCONV
             SECONDARY_UOM_CODE,
         SECONDARY_TRANSACTION_QUANTITY
         -- END INVCONV
             )
           VALUES
           (
             TxnHeaderId,
             l_transaction_Temp_id,
             item_id,
             sub,
             PUOMQty,
             TxnQty,
             TxnUOM,
             TxnDate,
             org_id,
             v_period_id,
             TxnProcMode,
             SYSDATE,
             UserID,
             cc_header_id,
             9,
             cc_entry_id,
             v_transaction_type_id,              -- 4159102
             v_transaction_action_id,
             TxnRef,
             ReasonId,
             TxnAcctID,
             --LotNum,
             --LotExpDate,
             rev,
             locator_id,
             --SerialNum,
             'Y',
             LoginID,
             UserID,
             SYSDATE,
             lpn_id,
             transfer_sub,
             transfer_loc_id,
             cost_group_id,
             l_transaction_Temp_id,
             l_transaction_Temp_id,
         -- BEGIN INVCONV
             secUOM,
         secQty
         -- END INVCONV
             );

Line: 330


         INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
           (
             TRANSACTION_HEADER_ID,
             TRANSACTION_TEMP_ID,
             INVENTORY_ITEM_ID,
             SUBINVENTORY_CODE,
             PRIMARY_QUANTITY,
             TRANSACTION_QUANTITY,
             TRANSACTION_UOM,
             TRANSACTION_DATE,
             ORGANIZATION_ID,
             ACCT_PERIOD_ID,
             TRANSACTION_MODE,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             TRANSACTION_SOURCE_ID,
             TRANSACTION_SOURCE_TYPE_ID,
             CYCLE_COUNT_ID,
             TRANSACTION_TYPE_ID,
             TRANSACTION_ACTION_ID,
             TRANSACTION_REFERENCE,
             REASON_ID,
             DISTRIBUTION_ACCOUNT_ID,
             --LOT_NUMBER,
             --WAYBILL_AIRBILL, /* Lot expiration date */
             REVISION,
             LOCATOR_ID,
             --SERIAL_NUMBER,
             PROCESS_FLAG,
             LAST_UPDATE_LOGIN,
             CREATED_BY,
             CREATION_DATE,
             TRANSFER_LPN_ID,
             TRANSFER_SUBINVENTORY,
             TRANSFER_TO_LOCATION,
             COST_GROUP_ID,
             TRANSACTION_BATCH_ID,
             TRANSACTION_BATCH_SEQ,
         -- BEGIN INVCONV
             SECONDARY_UOM_CODE,
         SECONDARY_TRANSACTION_QUANTITY
         -- END INVCONV
             )
           VALUES
           (
             TxnHeaderId,
             l_transaction_Temp_id,
             item_id,
             sub,
             PUOMQty,
             TxnQty,
             TxnUOM,
             TxnDate,
             org_id,
             v_period_id,
             TxnProcMode,
             SYSDATE,
             UserID,
             cc_header_id,
             9,
             cc_entry_id,
             v_transaction_type_id,              -- 4159102
             v_transaction_action_id,
             TxnRef,
             ReasonId,
             TxnAcctID,
             --LotNum,
             --LotExpDate,
             rev,
             locator_id,
             --SerialNum,
             'Y',
             LoginID,
             UserID,
             SYSDATE,
             lpn_id,
             transfer_sub,
             transfer_loc_id,
             cost_group_id,
             l_transaction_Temp_id,
             l_transaction_Temp_id,
         -- BEGIN INVCONV
             secUOM,
         secQty
         -- END INVCONV
             );

Line: 424


            SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
              INTO l_serial_temp_id
              FROM DUAL;

Line: 434


            SELECT  EXPIRATION_DATE
              INTO    l_lot_exp_date
              FROM    MTL_LOT_NUMBERS
              WHERE   INVENTORY_ITEM_ID = item_id
              AND     ORGANIZATION_ID = org_id
              AND     LOT_NUMBER = LotNum;

Line: 445


         INSERT INTO MTL_TRANSACTION_LOTS_TEMP
           ( TRANSACTION_TEMP_ID,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             CREATION_DATE,
             CREATED_BY,
             LAST_UPDATE_LOGIN,
             TRANSACTION_QUANTITY,
             PRIMARY_QUANTITY,
             LOT_NUMBER,
             LOT_EXPIRATION_DATE,
             SERIAL_TRANSACTION_TEMP_ID,
             GROUP_HEADER_ID
             , secondary_quantity         -- INVCONV,NSRIVAST
             , secondary_unit_of_measure  -- INVCONV,NSRIVAST
             )
           VALUES
           ( l_transaction_Temp_id,
             SYSDATE,
             UserID,
             SYSDATE,
             UserID,
             LoginID,
             TxnQty,
             PUOMQty,
             LotNum,
             l_lot_exp_date,
             l_serial_temp_id,
             TxnHeaderId
             ,secQty  -- INVCONV,NSRIVAST
             ,secUOM  -- INVCONV,NSRIVAST
             );

Line: 490


         SELECT    AUTO_SERIAL_ALPHA_PREFIX
           INTO    l_serial_prefix
           FROM    MTL_SYSTEM_ITEMS
           WHERE   INVENTORY_ITEM_ID = item_id
           AND     ORGANIZATION_ID = org_id;

Line: 497


         INSERT INTO MTL_SERIAL_NUMBERS_TEMP
           (  TRANSACTION_TEMP_ID
             ,LAST_UPDATE_DATE
             ,LAST_UPDATED_BY
             ,CREATION_DATE
             ,CREATED_BY
             ,LAST_UPDATE_LOGIN
             ,FM_SERIAL_NUMBER
             ,TO_SERIAL_NUMBER
             ,SERIAL_PREFIX
             ,GROUP_HEADER_ID
             ,C_ATTRIBUTE1
             ,C_ATTRIBUTE10
             ,C_ATTRIBUTE11
             ,C_ATTRIBUTE12
             ,C_ATTRIBUTE13
             ,C_ATTRIBUTE14
             ,C_ATTRIBUTE15
             ,C_ATTRIBUTE16
             ,C_ATTRIBUTE17
             ,C_ATTRIBUTE18
             ,C_ATTRIBUTE19
             ,C_ATTRIBUTE2
             ,C_ATTRIBUTE20
             ,C_ATTRIBUTE3
             ,C_ATTRIBUTE4
             ,C_ATTRIBUTE5
             ,C_ATTRIBUTE6
             ,C_ATTRIBUTE7
             ,C_ATTRIBUTE8
             ,C_ATTRIBUTE9
             ,CYCLES_SINCE_MARK
             ,CYCLES_SINCE_NEW
             ,CYCLES_SINCE_OVERHAUL
             ,CYCLES_SINCE_REPAIR
             ,CYCLES_SINCE_VISIT
             ,D_ATTRIBUTE1
             ,D_ATTRIBUTE10
             ,D_ATTRIBUTE2
             ,D_ATTRIBUTE3
             ,D_ATTRIBUTE4
             ,D_ATTRIBUTE5
             ,D_ATTRIBUTE6
             ,D_ATTRIBUTE7
             ,D_ATTRIBUTE8
             ,D_ATTRIBUTE9
             ,N_ATTRIBUTE1
             ,N_ATTRIBUTE10
             ,N_ATTRIBUTE2
             ,N_ATTRIBUTE3
             ,N_ATTRIBUTE4
             ,N_ATTRIBUTE5
             ,N_ATTRIBUTE6
             ,N_ATTRIBUTE7
             ,N_ATTRIBUTE8
             ,N_ATTRIBUTE9
             ,NUMBER_OF_REPAIRS
             ,SERIAL_ATTRIBUTE_CATEGORY
             ,TERRITORY_CODE
             ,TIME_SINCE_MARK
             ,TIME_SINCE_NEW
             ,TIME_SINCE_OVERHAUL
             ,TIME_SINCE_REPAIR
             ,TIME_SINCE_VISIT
             )
         SELECT
              l_serial_temp_id
             ,SYSDATE
             ,UserID
             ,SYSDATE
             ,UserID
             ,LoginID
             ,SerialNum
             ,SerialNum
             ,l_serial_prefix
             ,TxnHeaderId
             ,C_ATTRIBUTE1
             ,C_ATTRIBUTE10
             ,C_ATTRIBUTE11
             ,C_ATTRIBUTE12
             ,C_ATTRIBUTE13
             ,C_ATTRIBUTE14
             ,C_ATTRIBUTE15
             ,C_ATTRIBUTE16
             ,C_ATTRIBUTE17
             ,C_ATTRIBUTE18
             ,C_ATTRIBUTE19
             ,C_ATTRIBUTE2
             ,C_ATTRIBUTE20
             ,C_ATTRIBUTE3
             ,C_ATTRIBUTE4
             ,C_ATTRIBUTE5
             ,C_ATTRIBUTE6
             ,C_ATTRIBUTE7
             ,C_ATTRIBUTE8
             ,C_ATTRIBUTE9
             ,CYCLES_SINCE_MARK
             ,CYCLES_SINCE_NEW
             ,CYCLES_SINCE_OVERHAUL
             ,CYCLES_SINCE_REPAIR
             ,CYCLES_SINCE_VISIT
             ,D_ATTRIBUTE1
             ,D_ATTRIBUTE10
             ,D_ATTRIBUTE2
             ,D_ATTRIBUTE3
             ,D_ATTRIBUTE4
             ,D_ATTRIBUTE5
             ,D_ATTRIBUTE6
             ,D_ATTRIBUTE7
             ,D_ATTRIBUTE8
             ,D_ATTRIBUTE9
             ,N_ATTRIBUTE1
             ,N_ATTRIBUTE10
             ,N_ATTRIBUTE2
             ,N_ATTRIBUTE3
             ,N_ATTRIBUTE4
             ,N_ATTRIBUTE5
             ,N_ATTRIBUTE6
             ,N_ATTRIBUTE7
             ,N_ATTRIBUTE8
             ,N_ATTRIBUTE9
             ,NUMBER_OF_REPAIRS
             ,SERIAL_ATTRIBUTE_CATEGORY
             ,TERRITORY_CODE
             ,TIME_SINCE_MARK
             ,TIME_SINCE_NEW
             ,TIME_SINCE_OVERHAUL
             ,TIME_SINCE_REPAIR
             ,TIME_SINCE_VISIT
            FROM mtl_serial_numbers
            WHERE inventory_item_id = item_id
            AND serial_number = SerialNum;

Line: 635


      INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
        (
          TRANSACTION_HEADER_ID,
          TRANSACTION_TEMP_ID,
          INVENTORY_ITEM_ID,
          SUBINVENTORY_CODE,
          PRIMARY_QUANTITY,
          TRANSACTION_QUANTITY,
          TRANSACTION_UOM,
          TRANSACTION_DATE,
          ORGANIZATION_ID,
          ACCT_PERIOD_ID,
          TRANSACTION_MODE,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          TRANSACTION_SOURCE_ID,
          TRANSACTION_SOURCE_TYPE_ID,
          CYCLE_COUNT_ID,
          TRANSACTION_TYPE_ID,
          TRANSACTION_ACTION_ID,
          TRANSACTION_REFERENCE,
          REASON_ID,
          DISTRIBUTION_ACCOUNT_ID,
          LOT_NUMBER,
          WAYBILL_AIRBILL, /* Lot expiration date */
          REVISION,
          LOCATOR_ID,
          SERIAL_NUMBER,
          PROCESS_FLAG,
          LAST_UPDATE_LOGIN,
          CREATED_BY,
          CREATION_DATE,
          CONTENT_LPN_ID,
          TRANSFER_SUBINVENTORY,
          TRANSFER_TO_LOCATION,
          COST_GROUP_ID,
          TRANSACTION_BATCH_ID,
          TRANSACTION_BATCH_SEQ,
          -- BEGIN INVCONV
          SECONDARY_UOM_CODE,
      SECONDARY_TRANSACTION_QUANTITY
      -- END INVCONV
          )
        VALUES
        (
          TxnHeaderId,
          l_transaction_Temp_id,
          item_id,
          sub,
          PUOMQty,
          TxnQty,
          TxnUOM,
          TxnDate,
          org_id,
          v_period_id,
          TxnProcMode,
          SYSDATE,
          UserID,
          cc_header_id,
          9,
          NULL, --cc_entry_id,9452528
          v_transaction_type_id,                 --4159102
          v_transaction_action_id,
          TxnRef,
          ReasonId,
          TxnAcctID,
          LotNum,
          LotExpDate,
          rev,
          locator_id,
          SerialNum,
          'Y',
          LoginID,
          UserID,
          SYSDATE,
          lpn_id,
          transfer_sub,
          transfer_loc_id,
          cost_group_id,
          l_transaction_Temp_id,
          l_transaction_Temp_id,
          -- BEGIN INVCONV
          secUOM,
      secQty
      -- END INVCONV
          );