ITPub博客

首页 > Linux操作系统 > Linux操作系统 > datafix for project transfer

datafix for project transfer

原创 Linux操作系统 作者:susie0409 时间:2011-10-19 22:14:18 0 删除 编辑
 INSERT INTO MTL_TRANSACTIONS_INTERFACE
    (TRANSACTION_HEADER_ID,
     TRANSACTION_INTERFACE_ID,
     SOURCE_CODE,
     SOURCE_HEADER_ID,
     SOURCE_LINE_ID,
     TRANSACTION_MODE,
     LOCK_FLAG,
     PROCESS_FLAG,
     VALIDATION_REQUIRED,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_LOGIN,
     INVENTORY_ITEM_ID,
     REVISION,
     ORGANIZATION_ID,
     SUBINVENTORY_CODE,
     LOCATOR_ID,
     TRANSACTION_QUANTITY,
     TRANSACTION_UOM,
     PRIMARY_QUANTITY,
     TRANSACTION_TYPE_ID,
     TRANSACTION_ACTION_ID,
     TRANSACTION_SOURCE_TYPE_ID,
     TRANSACTION_DATE,
     ACCT_PERIOD_ID,
     REASON_ID,
     TRANSFER_ORGANIZATION,
     TRANSFER_SUBINVENTORY,
     TRANSFER_LOCATOR,
     TRANSACTION_REFERENCE,
     ATTRIBUTE_CATEGORY)
   VALUES
    (V_TXN_ID,--NULL,
     V_TXN_ID,--NULL,
     'SUB&PRJ Transf Program', -- Source Code
     0, -- Source Header ID
     0, -- Source Line ID
     3, -- Transaction Mode => 1: On-Line processing; 2: Concurrent processing; 3: Background processing
     2, -- Lock Flag => 1: Yes; 2: No
     1, -- Process Flag
     1, -- Validation Required
     SYSDATE,
     FND_GLOBAL.USER_ID,
     SYSDATE,
     FND_GLOBAL.USER_ID,
     NULL,
     P_ITEM_ID,
     NULL,
     P_ORGANIZATION_ID,
     P_SUBINV_CODE,
     P_FROM_LOC_ID,
     (-1)*P_TRANSACTION_QTY,
     V_UOM_CODE,
     (-1)*P_TRANSACTION_QTY,
     V_TXN_TYPE_ID, -- Transaction Type ID - Project Transfer
     2,             -- Transaction Action ID - Subinventory Transfer
     13,            -- Trasaction Source Type ID - Inventory
     SYSDATE,
     V_ACCT_PERIOD, -- Accounting Period ID
     P_REASON_ID,   -- Reason ID
     P_ORGANIZATION_ID,
     P_TO_SUBINV_CODE,
     P_TO_LOC_ID,
     P_REFERENCE, -- Transaction Reference
     NULL);

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15225049/viewspace-709379/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: xml report issue
请登录后发表评论 登录
全部评论

注册时间:2009-09-30

  • 博文量
    115
  • 访问量
    305727