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: 496

         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
             )
           VALUES
           ( l_serial_temp_id,
             SYSDATE,
             UserID,
             SYSDATE,
             UserID,
             LoginID,
             SerialNum,
             SerialNum,
             l_serial_prefix,
             TxnHeaderId);

Line: 524

      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,
          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
          );