IR(Internal Requisition) 與PR單價帶入的來源是不同的

IR單價 ==> 由Destination Org Item cost 帶出

維護新的 Item cost 即可

temp

PR單價 ==> 是由Item 上的List price帶出

temp

Somebaby 發表在 痞客邦 留言(1) 人氣()

▲top

Metalink Doc ID: 158088.1

The output and log directories are setup at installation level.

This could be done by defining the BD or Server environment variables APPLCSF, APPLLOG, and APPLOUT.

If APPLCSF has a value, the request log files will be written in $APPLCSF/log directory, and the output files in $APPLCSF/out directory for all modules.

If APPLCSF has no a value, the request log files will be writen in $<MODULE& gt; _TOP/$APPLLOG and the output files will be written in $<MODULE>_TOP/$ APPLOUT for each modules.

Where <MODULE> is the shortname of the module; for example, GL for General Ledger Module.

Those variables are defined in the applications environment file. When the concurrent managers start, they look the values in these variables. When a concurent process is executed depending on the environment variable values and the applications module, the directory for log and out files is determined.

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

需求：將特定料號失效

1. Run SQL

<<SQL Example>>

DECLARE
   p_organization_id   mtl_system_items_interface.organization_id%TYPE   := 107;
   p_user_id           fnd_user.user_id%TYPE;
   p_set_process_id    mtl_system_items_interface.set_process_id%TYPE    := 2000;

   CURSOR cur IS
      SELECT inventory_item_id
        FROM mtl_system_items_b
       WHERE organization_id = p_organization_id AND segment1 = 'MBR10150';
BEGIN
   SELECT user_id
     INTO p_user_id
     FROM fnd_user
    WHERE user_name = 'TTTT';

   FOR rec IN cur LOOP
      INSERT INTO mtl_system_items_interface
                  (
                   process_flag , set_process_id
                 , transaction_type, inventory_item_id
                 , organization_id , inventory_item_status_code
                 , end_date_active  , creation_date
                 , created_by   , last_update_date
                 , last_updated_by , last_update_login
                 , check_shortages_flag  , mrp_planning_code
                 , atp_flag, atp_components_flag
                  )
           VALUES (
                   1 , p_set_process_id
                 , 'UPDATE'  rec.inventory_item_id
                 , p_organization_id  , 'Inactive'
                 , SYSDATE, SYSDATE
                 , p_user_id   , SYSDATE
                 , p_user_id   , -1
                 , 'N'  , 6
                 , 'N'  'N'
                  );
   END LOOP;

   COMMIT;
END;


2. Run Item Import

image

image

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

 Insert by Using RECORD Type Variable

SQL>
SQL> -- create demo table
SQL> create table Employee(
  2    ID                 VARCHAR2(4 BYTE),
  3    First_Name         VARCHAR2(10 BYTE),
  4    City               VARCHAR2(10 BYTE)
  5  )
  6  /

Table created.

SQL>
SQL>
SQL> create or replace procedure p_create(i_deptNo VARCHAR, i_dName VARCHAR2, i_loc VARCHAR2) is
  2  v_row employee%ROWTYPE;
  3  begin
  4      if length(i_dName)>10 then
  5          raise_application_error(-20999,'first name is too long');
  6      end if;
  7
  8      v_row.id:=i_deptNo;
  9      v_row.first_Name:=i_dName;
 10      v_row.city:=i_loc;
 11
 12      insert into employee values v_row;
 13  end;
 14  /

Procedure created.

SQL>
SQL> call p_create ('01','new','new');

Call completed.

SQL>
SQL> select * from employee;

ID   FIRST_NAME CITY
---- ---------- ----------
01   new        new

SQL>
SQL>
SQL> -- clean the table
SQL> drop table Employee
  2  /

Table dropped.
資料來源：http://www.java2s.com/Tutorial/Oracle/0480__PL-SQL-Programming/InsertbyUsingRECORDTypeVariable.htm

Somebaby 發表在 痞客邦 留言(0) 人氣()

▲top

目前這個網站, 免費提供試跑 Oracle ERP R12 應用程式.

你可以在這裡, 看看 R12 多了哪些作業 / 功能.

Oracle ERP R12 體驗網址 : http://vis1200.solutionbeacon.net/OA_HTML/AppsLogin

登入資訊:

username=TK9420

密碼: 9420TK

 

資料來源： 天翔blog

Somebaby 發表在 痞客邦 留言(3) 人氣()

▲top
«1...444546 4748...62