客户信息导入(改写程序)

最新推荐文章于 2022-10-28 16:15:12 发布
最新推荐文章于 2022-10-28 16:15:12 发布
阅读量1k 收藏 1
点赞数 1
分类专栏： OM 文章标签： wrapper module output table null application

客户导入程序：

--分步导入比较靠谱

--暂分成：1. 客户编号及名称导入

                   2. 客户地址及收货方 收单方导入

                   3. 客户层联系人及联系人电话导入

--客户编号及名称导入程序（即客户层信息导入）

--客户编号名称导入程序 HZ_PARTIES/ HZ_CUST_ACCOUNTS
DECLARE
  P_CUST_ACCOUNT_REC     HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; --对应表：HZ_CUST_ACCOUNTS
  P_ORGANIZATION_REC     HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; --对应表：HZ_PARTIES
  P_CUSTOMER_PROFILE_REC HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE; --对应表：从此VIEW AR_CUSTOMER_PROFILES_V 追溯至 HZ_CUSTOMER_PROFILES
  X_CUST_ACCOUNT_ID      NUMBER;
  X_ACCOUNT_NUMBER       VARCHAR2(2000);
  X_PARTY_ID             NUMBER;
  X_PARTY_NUMBER         VARCHAR2(2000);
  X_PROFILE_ID           NUMBER;
  X_RETURN_STATUS        VARCHAR2(2000);
  X_MSG_COUNT            NUMBER;
  X_MSG_DATA             VARCHAR2(2000);

BEGIN

  P_CUST_ACCOUNT_REC.ACCOUNT_NAME      := 'Fenner_01';
  P_CUST_ACCOUNT_REC.CREATED_BY_MODULE := 'TCAPI_EXAMPLE';

  P_CUSTOMER_PROFILE_REC.PROFILE_CLASS_ID := 1060; --取自AR_CUSTOMER_PROFILE_CLASSES_V OM模块-->设置-->客户-->客户配置文件分类

  P_ORGANIZATION_REC.ORGANIZATION_NAME := 'Fenner_01'; --Party_name
  P_ORGANIZATION_REC.CREATED_BY_MODULE := 'TCAPI_EXAMPLE';

  HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT('T'
                                           ,P_CUST_ACCOUNT_REC
                                           ,P_ORGANIZATION_REC
                                           ,P_CUSTOMER_PROFILE_REC
                                           ,'F'
                                           ,X_CUST_ACCOUNT_ID
                                           ,X_ACCOUNT_NUMBER
                                           ,X_PARTY_ID
                                           ,X_PARTY_NUMBER
                                           ,X_PROFILE_ID
                                           ,X_RETURN_STATUS
                                           ,X_MSG_COUNT
                                           ,X_MSG_DATA);

  DBMS_OUTPUT.PUT_LINE('***************************');
  DBMS_OUTPUT.PUT_LINE('Output information ....');
  DBMS_OUTPUT.PUT_LINE('x_cust_account_id: ' || X_CUST_ACCOUNT_ID);
  DBMS_OUTPUT.PUT_LINE('x_account_number: ' || X_ACCOUNT_NUMBER);
  DBMS_OUTPUT.PUT_LINE('x_party_id: ' || X_PARTY_ID);
  DBMS_OUTPUT.PUT_LINE('x_party_number: ' || X_PARTY_NUMBER);
  DBMS_OUTPUT.PUT_LINE('x_profile_id: ' || X_PROFILE_ID);
  DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
  DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
  DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
  DBMS_OUTPUT.PUT_LINE('***************************');

END;

--客户地址 收单方 收货方导入程序 

--客户地址及收货方收单方导入程序
/*BEGIN
  DBMS_APPLICATION_INFO.SET_CLIENT_INFO('236');
END;*/
DECLARE
  P_LOCATION_REC  HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
  X_LOCATION_ID   NUMBER;
  X_RETURN_STATUS VARCHAR2(2000);
  X_MSG_COUNT     NUMBER;
  X_MSG_DATA      VARCHAR2(2000);

  P_PARTY_SITE_REC    HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
  X_PARTY_SITE_ID     NUMBER;
  X_PARTY_SITE_NUMBER VARCHAR2(2000);

  P_CUST_ACCT_SITE_REC HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
  X_CUST_ACCT_SITE_ID  NUMBER;
  V_CUST_ACCOUNT_ID    NUMBER;

  P_CUST_SITE_USE_REC    HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
  P_CUSTOMER_PROFILE_REC HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
  X_SITE_USE_ID          NUMBER;
  V_BILL_TO_SITE_USE_ID  NUMBER;
  --客户信息
  --收单方与收货方地址一样，此时只需创建一个客户地址，然后先创建BILL_TO，再创建SHIP_TO,然后再把先前生成的BILL_TO，赋给SHIP_TO
  --收单方与收货方地址不一样，此时需先创建BILL_TO地址，然后只创建BILL_TO，接着再创建一个SHIP_TO地址,然后再把先前生成的BILL_TO，赋给SHIP_TO的BILL_TO
  CURSOR C1 IS
    SELECT (SELECT HP.PARTY_ID
              FROM HZ_PARTIES HP
             WHERE HP.PARTY_NAME = A.CUSTOMER_NAME) PARTY_ID
          ,A.*
      FROM MEWBACKUP.MEW_CUSTOMER_IMPORT_TMP A
     WHERE A.CUSTOMER_NUMBER = 'B80024010'
    --AND A.BILL_TO = A.SHIP_TO
    ;

BEGIN

  FOR R1 IN C1
  LOOP
 
    IF R1.SHIP_TO = R1.BILL_TO
    THEN
      --1 Location Create Begin
      P_LOCATION_REC.COUNTRY  := 'CN';
      P_LOCATION_REC.ADDRESS1 := R1.CUSTOMER_NAME;
      P_LOCATION_REC.ADDRESS2 := R1.SHIP_TO;
      P_LOCATION_REC.ADDRESS4 := R1.SHIP_TO;
      P_LOCATION_REC.CITY     := R1.CITY;
      --P_LOCATION_REC.POSTAL_CODE       := '94401';
      P_LOCATION_REC.PROVINCE          := R1.PROVINCE;
      P_LOCATION_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
      HZ_LOCATION_V2PUB.CREATE_LOCATION('T'
                                       ,P_LOCATION_REC
                                       ,X_LOCATION_ID
                                       ,X_RETURN_STATUS
                                       ,X_MSG_COUNT
                                       ,X_MSG_DATA);
   
      DBMS_OUTPUT.PUT_LINE('***************************');
      DBMS_OUTPUT.PUT_LINE('Output information ....');
      DBMS_OUTPUT.PUT_LINE('x_location_id: ' || X_LOCATION_ID);
      DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
      DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
      DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
      DBMS_OUTPUT.PUT_LINE('***************************');
      DBMS_OUTPUT.PUT_LINE(' ');
      --Location Create End
   
      --2 Party Site Create Begin 
      BEGIN
        P_PARTY_SITE_REC.PARTY_ID                 := R1.PARTY_ID; --<<value for party_id from step 2& GT;
        P_PARTY_SITE_REC.LOCATION_ID              := X_LOCATION_ID; --<<value for location_id from   STEP 3 >
        P_PARTY_SITE_REC.IDENTIFYING_ADDRESS_FLAG := 'Y';
        P_PARTY_SITE_REC.CREATED_BY_MODULE        := 'TCA_FORM_WRAPPER';
        HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE('T'
                                             ,P_PARTY_SITE_REC
                                             ,X_PARTY_SITE_ID
                                             ,X_PARTY_SITE_NUMBER
                                             ,X_RETURN_STATUS
                                             ,X_MSG_COUNT
                                             ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_party_site_id: ' || X_PARTY_SITE_ID);
        DBMS_OUTPUT.PUT_LINE('x_party_site_number: ' ||
                             X_PARTY_SITE_NUMBER);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
      END;
      --2 Party Site Create End
   
      --3 Cust Account Site ID Create Begin
      BEGIN
        V_CUST_ACCOUNT_ID := NULL;
        SELECT HCA.CUST_ACCOUNT_ID
          INTO V_CUST_ACCOUNT_ID
          FROM HZ_CUST_ACCOUNTS HCA
         WHERE HCA.PARTY_ID = R1.PARTY_ID;
     
        P_CUST_ACCT_SITE_REC.CUST_ACCOUNT_ID   := V_CUST_ACCOUNT_ID; --<<value for   CUST_ACCOUNT_ID YOU GET FROM STEP 2 >
        P_CUST_ACCT_SITE_REC.PARTY_SITE_ID     := X_PARTY_SITE_ID; --<<value for   PARTY_SITE_ID FROM STEP 4 >
        P_CUST_ACCT_SITE_REC.LANGUAGE          := 'ZHS';
        P_CUST_ACCT_SITE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE('T'
                                                        ,P_CUST_ACCT_SITE_REC
                                                        ,X_CUST_ACCT_SITE_ID
                                                        ,X_RETURN_STATUS
                                                        ,X_MSG_COUNT
                                                        ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_cust_acct_site_id: ' ||
                             X_CUST_ACCT_SITE_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
      END;
      --3 Cust Account Site ID Create End
   
      --4 Cust account Site Use ID Create Begin 
      BEGIN
     
        P_CUST_SITE_USE_REC.CUST_ACCT_SITE_ID := X_CUST_ACCT_SITE_ID; --<<value for   CUST_ACCT_SITE_ID FROM STEP 5 >
        P_CUST_SITE_USE_REC.SITE_USE_CODE     := 'BILL_TO';
        P_CUST_SITE_USE_REC.LOCATION          := R1.BILL_TO;
        -- P_CUST_SITE_USE_REC.BILL_TO_SITE_USE_ID := V_BILL_TO_SITE_USE_ID;
        --  P_CUST_SITE_USE_REC.PAYMENT_TERM_ID     := 1081;
        P_CUST_SITE_USE_REC.TAX_CODE := 'VAT 17%';
        -- P_CUST_SITE_USE_REC.ORDER_TYPE_ID       := 1579;
        --  P_CUST_SITE_USE_REC.PRICE_LIST_ID       := 179738;
        --  P_CUST_SITE_USE_REC.PRIMARY_SALESREP_ID := 100007105;
        P_CUST_SITE_USE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE('T'
                                                       ,P_CUST_SITE_USE_REC
                                                       ,P_CUSTOMER_PROFILE_REC
                                                       ,''
                                                       ,''
                                                       ,X_SITE_USE_ID
                                                       ,X_RETURN_STATUS
                                                       ,X_MSG_COUNT
                                                       ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_site_use_id: ' || X_SITE_USE_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
        V_BILL_TO_SITE_USE_ID := NULL;
     
        SELECT NVL(A.BILL_TO_SITE_USE_ID
                  ,A.SITE_USE_ID)
          INTO V_BILL_TO_SITE_USE_ID
          FROM HZ_CUST_SITE_USES_ALL A
         WHERE A.CUST_ACCT_SITE_ID IN
               (SELECT B.CUST_ACCT_SITE_ID
                  FROM HZ_CUST_ACCT_SITES_ALL B
                 WHERE B.CUST_ACCOUNT_ID = V_CUST_ACCOUNT_ID)
           AND A.LOCATION = R1.SHIP_TO
           AND A.SITE_USE_CODE = 'BILL_TO'
        --AND A.BILL_TO_SITE_USE_ID IS NOT NULL
        ;
     
        P_CUST_SITE_USE_REC.CUST_ACCT_SITE_ID   := X_CUST_ACCT_SITE_ID; --<<value for   CUST_ACCT_SITE_ID FROM STEP 5 >
        P_CUST_SITE_USE_REC.SITE_USE_CODE       := 'SHIP_TO';
        P_CUST_SITE_USE_REC.LOCATION            := R1.SHIP_TO;
        P_CUST_SITE_USE_REC.BILL_TO_SITE_USE_ID := V_BILL_TO_SITE_USE_ID;
        --  P_CUST_SITE_USE_REC.PAYMENT_TERM_ID     := 1081;
        P_CUST_SITE_USE_REC.TAX_CODE := 'VAT 17%';
        -- P_CUST_SITE_USE_REC.ORDER_TYPE_ID       := 1579;
        --  P_CUST_SITE_USE_REC.PRICE_LIST_ID       := 179738;
        --  P_CUST_SITE_USE_REC.PRIMARY_SALESREP_ID := 100007105;
        P_CUST_SITE_USE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE('T'
                                                       ,P_CUST_SITE_USE_REC
                                                       ,P_CUSTOMER_PROFILE_REC
                                                       ,''
                                                       ,''
                                                       ,X_SITE_USE_ID
                                                       ,X_RETURN_STATUS
                                                       ,X_MSG_COUNT
                                                       ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_site_use_id: ' || X_SITE_USE_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
      END;
   
    ELSE
   
      --导入BILL_TO地址 
      P_LOCATION_REC.COUNTRY  := 'CN';
      P_LOCATION_REC.ADDRESS1 := R1.CUSTOMER_NAME;
      P_LOCATION_REC.ADDRESS2 := R1.BILL_TO;
      -- P_LOCATION_REC.ADDRESS4 := R1.ADDRESS4;
      --P_LOCATION_REC.POSTAL_CODE       := '94401';
      P_LOCATION_REC.PROVINCE          := R1.PROVINCE;
      P_LOCATION_REC.CITY              := R1.CITY;
      P_LOCATION_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
      HZ_LOCATION_V2PUB.CREATE_LOCATION('T'
                                       ,P_LOCATION_REC
                                       ,X_LOCATION_ID
                                       ,X_RETURN_STATUS
                                       ,X_MSG_COUNT
                                       ,X_MSG_DATA);
   
      DBMS_OUTPUT.PUT_LINE('***************************');
      DBMS_OUTPUT.PUT_LINE('Output information ....');
      DBMS_OUTPUT.PUT_LINE('x_location_id: ' || X_LOCATION_ID);
      DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
      DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
      DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
      DBMS_OUTPUT.PUT_LINE('***************************');
      DBMS_OUTPUT.PUT_LINE(' ');
   
      BEGIN
        P_PARTY_SITE_REC.PARTY_ID                 := R1.PARTY_ID; --<<value for party_id from step 2& GT;
        P_PARTY_SITE_REC.LOCATION_ID              := X_LOCATION_ID; --<<value for location_id from   STEP 3 >
        P_PARTY_SITE_REC.IDENTIFYING_ADDRESS_FLAG := 'Y';
        P_PARTY_SITE_REC.CREATED_BY_MODULE        := 'TCA_FORM_WRAPPER';
        HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE('T'
                                             ,P_PARTY_SITE_REC
                                             ,X_PARTY_SITE_ID
                                             ,X_PARTY_SITE_NUMBER
                                             ,X_RETURN_STATUS
                                             ,X_MSG_COUNT
                                             ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_party_site_id: ' || X_PARTY_SITE_ID);
        DBMS_OUTPUT.PUT_LINE('x_party_site_number: ' ||
                             X_PARTY_SITE_NUMBER);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
      END;
   
      BEGIN
        V_CUST_ACCOUNT_ID := NULL;
        SELECT HCA.CUST_ACCOUNT_ID
          INTO V_CUST_ACCOUNT_ID
          FROM HZ_CUST_ACCOUNTS HCA
         WHERE HCA.PARTY_ID = R1.PARTY_ID;
     
        P_CUST_ACCT_SITE_REC.CUST_ACCOUNT_ID   := V_CUST_ACCOUNT_ID; --<<value for   CUST_ACCOUNT_ID YOU GET FROM STEP 2 >
        P_CUST_ACCT_SITE_REC.PARTY_SITE_ID     := X_PARTY_SITE_ID; --<<value for   PARTY_SITE_ID FROM STEP 4 >
        P_CUST_ACCT_SITE_REC.LANGUAGE          := 'ZHS';
        P_CUST_ACCT_SITE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE('T'
                                                        ,P_CUST_ACCT_SITE_REC
                                                        ,X_CUST_ACCT_SITE_ID
                                                        ,X_RETURN_STATUS
                                                        ,X_MSG_COUNT
                                                        ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_cust_acct_site_id: ' ||
                             X_CUST_ACCT_SITE_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
      END;
      --导入BILL_TO
      BEGIN
        P_CUST_SITE_USE_REC.CUST_ACCT_SITE_ID := X_CUST_ACCT_SITE_ID; --<<value for   CUST_ACCT_SITE_ID FROM STEP 5 >
        P_CUST_SITE_USE_REC.SITE_USE_CODE     := 'BILL_TO';
        P_CUST_SITE_USE_REC.LOCATION          := R1.BILL_TO;
        -- P_CUST_SITE_USE_REC.BILL_TO_SITE_USE_ID := V_BILL_TO_SITE_USE_ID;
        --  P_CUST_SITE_USE_REC.PAYMENT_TERM_ID     := 1081;
        P_CUST_SITE_USE_REC.TAX_CODE := 'VAT 17%';
        -- P_CUST_SITE_USE_REC.ORDER_TYPE_ID       := 1579;
        --  P_CUST_SITE_USE_REC.PRICE_LIST_ID       := 179738;
        --  P_CUST_SITE_USE_REC.PRIMARY_SALESREP_ID := 100007105;
        P_CUST_SITE_USE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE('T'
                                                       ,P_CUST_SITE_USE_REC
                                                       ,P_CUSTOMER_PROFILE_REC
                                                       ,''
                                                       ,''
                                                       ,X_SITE_USE_ID
                                                       ,X_RETURN_STATUS
                                                       ,X_MSG_COUNT
                                                       ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_site_use_id: ' || X_SITE_USE_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
        --导入SHIP_TO地址   
        P_LOCATION_REC.COUNTRY  := 'CN';
        P_LOCATION_REC.ADDRESS1 := R1.CUSTOMER_NAME;
        P_LOCATION_REC.ADDRESS2 := R1.SHIP_TO;
        P_LOCATION_REC.ADDRESS4 := R1.SHIP_TO;
        --P_LOCATION_REC.POSTAL_CODE       := '94401';
        P_LOCATION_REC.PROVINCE          := R1.PROVINCE;
        P_LOCATION_REC.CITY              := R1.CITY;
        P_LOCATION_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_LOCATION_V2PUB.CREATE_LOCATION('T'
                                         ,P_LOCATION_REC
                                         ,X_LOCATION_ID
                                         ,X_RETURN_STATUS
                                         ,X_MSG_COUNT
                                         ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_location_id: ' || X_LOCATION_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE(' ');
     
        BEGIN
          P_PARTY_SITE_REC.PARTY_ID                 := R1.PARTY_ID; --<<value for party_id from step 2& GT;
          P_PARTY_SITE_REC.LOCATION_ID              := X_LOCATION_ID; --<<value for location_id from   STEP 3 >
          P_PARTY_SITE_REC.IDENTIFYING_ADDRESS_FLAG := 'Y';
          P_PARTY_SITE_REC.CREATED_BY_MODULE        := 'TCA_FORM_WRAPPER';
          HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE('T'
                                               ,P_PARTY_SITE_REC
                                               ,X_PARTY_SITE_ID
                                               ,X_PARTY_SITE_NUMBER
                                               ,X_RETURN_STATUS
                                               ,X_MSG_COUNT
                                               ,X_MSG_DATA);
       
          DBMS_OUTPUT.PUT_LINE('***************************');
          DBMS_OUTPUT.PUT_LINE('Output information ....');
          DBMS_OUTPUT.PUT_LINE('x_party_site_id: ' || X_PARTY_SITE_ID);
          DBMS_OUTPUT.PUT_LINE('x_party_site_number: ' ||
                               X_PARTY_SITE_NUMBER);
          DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
          DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
          DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
          DBMS_OUTPUT.PUT_LINE('***************************');
       
        END;
     
        BEGIN
          V_CUST_ACCOUNT_ID := NULL;
          SELECT HCA.CUST_ACCOUNT_ID
            INTO V_CUST_ACCOUNT_ID
            FROM HZ_CUST_ACCOUNTS HCA
           WHERE HCA.PARTY_ID = R1.PARTY_ID;
       
          P_CUST_ACCT_SITE_REC.CUST_ACCOUNT_ID   := V_CUST_ACCOUNT_ID; --<<value for   CUST_ACCOUNT_ID YOU GET FROM STEP 2 >
          P_CUST_ACCT_SITE_REC.PARTY_SITE_ID     := X_PARTY_SITE_ID; --<<value for   PARTY_SITE_ID FROM STEP 4 >
          P_CUST_ACCT_SITE_REC.LANGUAGE          := 'ZHS';
          P_CUST_ACCT_SITE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
          HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE('T'
                                                          ,P_CUST_ACCT_SITE_REC
                                                          ,X_CUST_ACCT_SITE_ID
                                                          ,X_RETURN_STATUS
                                                          ,X_MSG_COUNT
                                                          ,X_MSG_DATA);
       
          DBMS_OUTPUT.PUT_LINE('***************************');
          DBMS_OUTPUT.PUT_LINE('Output information ....');
          DBMS_OUTPUT.PUT_LINE('x_cust_acct_site_id: ' ||
                               X_CUST_ACCT_SITE_ID);
          DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
          DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
          DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
          DBMS_OUTPUT.PUT_LINE('***************************');
       
        END;
     
        --导入SHIP_TO
        V_BILL_TO_SITE_USE_ID := NULL;
        SELECT NVL(A.BILL_TO_SITE_USE_ID
                  ,A.SITE_USE_ID)
          INTO V_BILL_TO_SITE_USE_ID
          FROM HZ_CUST_SITE_USES_ALL A
         WHERE A.CUST_ACCT_SITE_ID IN
               (SELECT B.CUST_ACCT_SITE_ID
                  FROM HZ_CUST_ACCT_SITES_ALL B
                 WHERE B.CUST_ACCOUNT_ID = V_CUST_ACCOUNT_ID)
           AND A.LOCATION = R1.SHIP_TO
           AND A.SITE_USE_CODE = 'BILL_TO'
        --AND A.BILL_TO_SITE_USE_ID IS NOT NULL
        ;
     
        P_CUST_SITE_USE_REC.CUST_ACCT_SITE_ID   := X_CUST_ACCT_SITE_ID; --<<value for   CUST_ACCT_SITE_ID FROM STEP 5 >
        P_CUST_SITE_USE_REC.SITE_USE_CODE       := 'SHIP_TO';
        P_CUST_SITE_USE_REC.LOCATION            := R1.SHIP_TO;
        P_CUST_SITE_USE_REC.BILL_TO_SITE_USE_ID := V_BILL_TO_SITE_USE_ID;
        --  P_CUST_SITE_USE_REC.PAYMENT_TERM_ID     := 1081;
        P_CUST_SITE_USE_REC.TAX_CODE := 'VAT 17%';
        -- P_CUST_SITE_USE_REC.ORDER_TYPE_ID       := 1579;
        --  P_CUST_SITE_USE_REC.PRICE_LIST_ID       := 179738;
        --  P_CUST_SITE_USE_REC.PRIMARY_SALESREP_ID := 100007105;
        P_CUST_SITE_USE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
        HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE('T'
                                                       ,P_CUST_SITE_USE_REC
                                                       ,P_CUSTOMER_PROFILE_REC
                                                       ,''
                                                       ,''
                                                       ,X_SITE_USE_ID
                                                       ,X_RETURN_STATUS
                                                       ,X_MSG_COUNT
                                                       ,X_MSG_DATA);
     
        DBMS_OUTPUT.PUT_LINE('***************************');
        DBMS_OUTPUT.PUT_LINE('Output information ....');
        DBMS_OUTPUT.PUT_LINE('x_site_use_id: ' || X_SITE_USE_ID);
        DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
        DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_COUNT);
        DBMS_OUTPUT.PUT_LINE('***************************');
     
      END;
   
    END IF;
 
  END LOOP;

END;

 

--3. 客户层联系人和联系人电话导入程序

--联系人电话导入程序

/*BEGIN
  DBMS_APPLICATION_INFO.SET_CLIENT_INFO('236');
END;*/
--7
DECLARE
  P_CREATE_PERSON_REC HZ_PARTY_V2PUB.PERSON_REC_TYPE;
  X_PARTY_ID          NUMBER /*:= 97293*/
  ;
  X_PARTY_NUMBER      VARCHAR2(2000);
  X_PROFILE_ID        NUMBER;
  X_RETURN_STATUS     VARCHAR2(2000);
  X_MSG_COUNT         NUMBER;
  X_MSG_DATA          VARCHAR2(2000);

  P_ORG_CONTACT_REC HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
  X_ORG_CONTACT_ID  NUMBER;
  X_PARTY_REL_ID    NUMBER;

  P_CR_CUST_ACC_ROLE_REC HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE;
  X_CUST_ACCOUNT_ROLE_ID NUMBER;

  P_CONTACT_POINT_REC HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
  P_PHONE_REC         HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
  P_EDI_REC_TYPE      HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
  P_EMAIL_REC_TYPE    HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
  P_TELEX_REC_TYPE    HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
  P_WEB_REC_TYPE      HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
  X_CONTACT_POINT_ID  NUMBER;

  CURSOR C1 IS
    SELECT (SELECT HP.PARTY_ID
              FROM HZ_PARTIES HP
             WHERE HP.PARTY_NAME = A.CUSTOMER_NAME) PARTY_ID
          ,(SELECT CUSTOMER_ID
              FROM AR_CUSTOMERS AC
             WHERE AC.CUSTOMER_NAME = A.CUSTOMER_NAME) CUSTOMBER_ACCOUNT_ID
          ,A.*
      FROM MEWBACKUP.MEW_CUSTOMER_IMPORT_TMP A
     WHERE A.CUSTOMER_NUMBER = 'B80024010';
BEGIN
  FOR R1 IN C1
  LOOP
    --7
    P_CREATE_PERSON_REC.PERSON_LAST_NAME  := NVL(R1.CONTACTOR
                                                ,'无');
    P_CREATE_PERSON_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
 
    HZ_PARTY_V2PUB.CREATE_PERSON('T'
                                ,P_CREATE_PERSON_REC
                                ,X_PARTY_ID
                                ,X_PARTY_NUMBER
                                ,X_PROFILE_ID
                                ,X_RETURN_STATUS
                                ,X_MSG_COUNT
                                ,X_MSG_DATA);
 
    DBMS_OUTPUT.PUT_LINE('***************************');
    DBMS_OUTPUT.PUT_LINE('Output information ....');
    DBMS_OUTPUT.PUT_LINE('x_party_id: ' || X_PARTY_ID);
    DBMS_OUTPUT.PUT_LINE('x_party_number: ' || X_PARTY_NUMBER);
    DBMS_OUTPUT.PUT_LINE('x_profile_id: ' || X_PROFILE_ID);
    DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
    DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
    DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
    DBMS_OUTPUT.PUT_LINE('***************************');
    --8
    P_ORG_CONTACT_REC.CREATED_BY_MODULE                := 'TCA_FORM_WRAPPER';
    P_ORG_CONTACT_REC.PARTY_REL_REC.SUBJECT_ID         := X_PARTY_ID; --<<value for party_id from step 7>
    P_ORG_CONTACT_REC.PARTY_REL_REC.SUBJECT_TYPE       := 'PERSON';
    P_ORG_CONTACT_REC.PARTY_REL_REC.SUBJECT_TABLE_NAME := 'HZ_PARTIES';
    P_ORG_CONTACT_REC.PARTY_REL_REC.OBJECT_ID          := R1.PARTY_ID; --<<value for party_id from step 2>
    P_ORG_CONTACT_REC.PARTY_REL_REC.OBJECT_TYPE        := 'ORGANIZATION';
    P_ORG_CONTACT_REC.PARTY_REL_REC.OBJECT_TABLE_NAME  := 'HZ_PARTIES';
    P_ORG_CONTACT_REC.PARTY_REL_REC.RELATIONSHIP_CODE  := 'CONTACT_OF';
    P_ORG_CONTACT_REC.PARTY_REL_REC.RELATIONSHIP_TYPE  := 'CONTACT';
    P_ORG_CONTACT_REC.PARTY_REL_REC.START_DATE         := SYSDATE;
    HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT('T'
                                             ,P_ORG_CONTACT_REC
                                             ,X_ORG_CONTACT_ID
                                             ,X_PARTY_REL_ID
                                             ,X_PARTY_ID
                                             ,X_PARTY_NUMBER
                                             ,X_RETURN_STATUS
                                             ,X_MSG_COUNT
                                             ,X_MSG_DATA);
 
    DBMS_OUTPUT.PUT_LINE('***************************');
    DBMS_OUTPUT.PUT_LINE('Output information ....');
    DBMS_OUTPUT.PUT_LINE('x_org_contact_id: ' || X_ORG_CONTACT_ID);
    DBMS_OUTPUT.PUT_LINE('x_party_rel_id: ' || X_PARTY_REL_ID);
    DBMS_OUTPUT.PUT_LINE('x_party_id: ' || X_PARTY_ID);
    DBMS_OUTPUT.PUT_LINE('x_party_number: ' || X_PARTY_NUMBER);
    DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
    DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
    DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
    DBMS_OUTPUT.PUT_LINE('***************************');
    --9
    P_CR_CUST_ACC_ROLE_REC.PARTY_ID          := X_PARTY_ID; --<<value for party_id from step 8>
    P_CR_CUST_ACC_ROLE_REC.CUST_ACCOUNT_ID   := R1.CUSTOMBER_ACCOUNT_ID; --<<value for cust_account_id from step 2>
    P_CR_CUST_ACC_ROLE_REC.PRIMARY_FLAG      := 'Y';
    P_CR_CUST_ACC_ROLE_REC.ROLE_TYPE         := 'CONTACT';
    P_CR_CUST_ACC_ROLE_REC.CREATED_BY_MODULE := 'TCA_FORM_WRAPPER';
 
    HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_CUST_ACCOUNT_ROLE('T'
                                                       ,P_CR_CUST_ACC_ROLE_REC
                                                       ,X_CUST_ACCOUNT_ROLE_ID
                                                       ,X_RETURN_STATUS
                                                       ,X_MSG_COUNT
                                                       ,X_MSG_DATA);
 
    DBMS_OUTPUT.PUT_LINE('***************************');
    DBMS_OUTPUT.PUT_LINE('Output information ....');
    DBMS_OUTPUT.PUT_LINE('x_cust_account_role_id: ' ||
                         X_CUST_ACCOUNT_ROLE_ID);
    DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
    DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
    DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
    DBMS_OUTPUT.PUT_LINE('***************************');
    --10电话
    P_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'PHONE';
    P_CONTACT_POINT_REC.OWNER_TABLE_NAME   := 'HZ_PARTIES';
    P_CONTACT_POINT_REC.OWNER_TABLE_ID     := X_PARTY_ID; --<value for party_id from step 8>
    P_CONTACT_POINT_REC.CREATED_BY_MODULE  := 'TCA_FORM_WRAPPER';
    P_PHONE_REC.PHONE_NUMBER               := R1.PHONE;
    P_PHONE_REC.PHONE_LINE_TYPE            := 'GEN';
 
    HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT('T'
                                               ,P_CONTACT_POINT_REC
                                               ,P_EDI_REC_TYPE
                                               ,P_EMAIL_REC_TYPE
                                               ,P_PHONE_REC
                                               ,P_TELEX_REC_TYPE
                                               ,P_WEB_REC_TYPE
                                               ,X_CONTACT_POINT_ID
                                               ,X_RETURN_STATUS
                                               ,X_MSG_COUNT
                                               ,X_MSG_DATA);
 
    DBMS_OUTPUT.PUT_LINE('***************************');
    DBMS_OUTPUT.PUT_LINE('Output information ....');
    DBMS_OUTPUT.PUT_LINE('x_contact_point_id: ' || X_CONTACT_POINT_ID);
    DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
    DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
    DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
    DBMS_OUTPUT.PUT_LINE('***************************');
 
    P_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'PHONE';
    P_CONTACT_POINT_REC.OWNER_TABLE_NAME   := 'HZ_PARTIES';
    P_CONTACT_POINT_REC.OWNER_TABLE_ID     := X_PARTY_ID; --<value for party_id from step 8>
    P_CONTACT_POINT_REC.CREATED_BY_MODULE  := 'TCA_FORM_WRAPPER';
    P_PHONE_REC.PHONE_NUMBER               := R1.FAX;
    P_PHONE_REC.PHONE_LINE_TYPE            := 'FAX';
    --11传真
    HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT('T'
                                               ,P_CONTACT_POINT_REC
                                               ,P_EDI_REC_TYPE
                                               ,P_EMAIL_REC_TYPE
                                               ,P_PHONE_REC
                                               ,P_TELEX_REC_TYPE
                                               ,P_WEB_REC_TYPE
                                               ,X_CONTACT_POINT_ID
                                               ,X_RETURN_STATUS
                                               ,X_MSG_COUNT
                                               ,X_MSG_DATA);
 
    DBMS_OUTPUT.PUT_LINE('***************************');
    DBMS_OUTPUT.PUT_LINE('Output information ....');
    DBMS_OUTPUT.PUT_LINE('x_contact_point_id: ' || X_CONTACT_POINT_ID);
    DBMS_OUTPUT.PUT_LINE('x_return_status: ' || X_RETURN_STATUS);
    DBMS_OUTPUT.PUT_LINE('x_msg_count: ' || X_MSG_COUNT);
    DBMS_OUTPUT.PUT_LINE('x_msg_data: ' || X_MSG_DATA);
    DBMS_OUTPUT.PUT_LINE('***************************');
 
  END LOOP;

END;

 

 

QQ51567242
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
动网论坛6.0转VBB 3.0.1程序
12-27
|| # 1、本程序参照Rik写的动网论坛转VBB程序改写而成。 # || || # 2、本程序只对数据作转移，不会对原来的mdb数据造成破坏，如果担心发生mdb # || || # 数据丢失，请先作备份，我不会对任何此类型的数据...
Oracle EBS客户表结构
qq_36620997的博客
02-18 2053
R12 客户表结构 客户表/联系人/PARTY关联 HZ_PARTIES 客户账户表 HZ_CUST_ACCOUNTS 例子： SELECT hp.party_number --客户注册标识 , hp.party_name --组织名/客户 , hp.known_as --别名 , hp.organi...
EBS中客户表的关系
热门推荐
rfb0204421的专栏
08-20 1万+
hz_parties是比较基本的表，里面可以是组织，也可以是人，这里面只是存储了基本的信息，这些信息会被其它表shared, hz_relations表里是这些hz_parties之前的关系，里面用subject_id和object_id形成对应关系。 HZ_PARTY_SITES里面有关于hz_parties的细节联系信息，如mailstop, addressee,但注意，这个表里面没有电话，
客户导入后需要Update的字段
weixin_34242658的博客
03-04 90
客户及地址导入成功后，需要回头来update，脚本如下： UPDATE ar.hz_cust_site_uses_all hcsu            SET hcsu.primary_salesrep_id = (SELECT rs.salesrep_id                                              FROM jtf_rs_sales...
Oracle EBS AR 更新客户组织层
weixin_30654419的博客
11-23 194
declare -- Local variables here i integer; g_module varchar2(30) := 'TCA_V2_API'; lrec_org hz_party_v2pub.organization_rec_type; lrec_party hz_party_v2pub.party_rec_type; l_retu...
oracle TCA 吓死我了 终于搞明白啦！！！
crfyqoa480081的博客
04-12 7857
首先明确一点，TCA既不是OA的一个独立模块也不是OA某个模块的功能，它仅仅是一种架构。TCA(Trading Community Architecture)是R12中通过增加供应商和银行来扩展R11客户模型以支持复杂的贸易关系...
修正美化：PB9自定义messageBox，不用修改你的程序代码即可直接套用
02-15
你的程序可以直接套用本messageBox，即是导入到PBL即可，不喜欢的话直接从应用中移除本PBL就行，都不用修改任何代码。可本messageBox与系统messageBox()各方面保持一致，包括默认按钮、按钮焦点的变换，返回数值、...
第三代移动WEB内核小程序风口-逐浪CMS2 x3.9.3全面发布
01-31
■扩展:用户信息(UserBase)增加移动设备专用页面 ■修复:订单前往付款,状态检测不正确Bug ■扩展:多选项字段,增加省份大学二级联动 ■增加:标签查询数据转换为json功能 { ZL:Json} ■扩展:按需修改当前日期标签 ...
User Access Admin
03-16
可以自定义，也可以在退出前自定义提示对话框等）、“发送管理信息”（启用后就可以发送一些信息给所有正在使用前端程序的用户，发送后前端会自动弹出对话框） 本程式的示例代码只是间单的自动退出演示，如果要...
第三个项目（东洋制罐）技术学习心得
weixin_42968500的博客
08-06 545
1 跟客服有关的表 客户表：hz_cust_accounts 客服site表：hz_cust_acct_sites_all，hz_cust_site_uses_all hz_cust_acct_sites_all与hz_cust_site_uses_all通过cust_acct_site_id字段进行关联。hz_cust_acct_sites_all与hz_cust_accounts通过cust_...
更新客户地点用途
qingtongqizhw的专栏
02-15 939
举例：更新客户地点用途下的收款账户 DECLARE v_site_use hz_cust_account_site_v2pub.cust_site_use_rec_type; v_cust_profile hz_customer_profile_v2pub.customer_profile_rec_type; v_version NUMBER; v_ret
EBS - API创建客户、地点和业务目的
写博客也要符合基本法
04-26 1546
一、创建客户（组织+账户） DECLARE x_cust_account_id NUMBER; x_account_number NUMBER; x_party_id NUMBER; x_party_number NUMBER; x_profile_id NUMBER; x_return_status VARCHAR2(5); x...
EBS - API创建客户联系人、联系方式和联系人职责
写博客也要符合基本法
04-28 1964
关于联系人和联系方式表结构的介绍，请参阅联系人数据结构和联系方式数据结构 一、创建联系人 DECLARE x_person_party_id NUMBER; x_person_party_number NUMBER; x_org_contact_id NUMBER; x_party_rel_id NUMB...
oracle ra hcustomers,EBS 11i升级R12详解
weixin_30015371的博客
04-16 637
从EBS 11i升级至R12，总的来说更变较大的就是多OU访问(MOAC)和表视图的更变。因为标准功能oracle都帮我们做了升级，本文档所说的11升12都是客户化的更改。多OU访问[1][2]不同于11i限定ORG_ID的方式，使得视图只能筛选单个OU的数据，R12使用安全策略来控制OU数据的访问，可以用类似下面的执行语句注册客户化的应用：DECLARECURSOR c_init_mo ISSE...
客户、订单知识
慢慢求索
11-30 2200
http://www.skyz.cn/post/2010-06-02/7321891 1、 什么是“客户” 按系统的结构，一个客户，下面有多个地点。过去一直理解为，客户的名称必须为客户“集团”的名称，各分公司、子公司因当建立为不同的客户地址。其实没有必要这个样子。 一个客户可以理解为是一个对方的业务实体（OU），只要是独立核算的，独立业务往来的都可能 是一个客户。也就是“分公司”
详解ebs接口之客户配置文件导入（二）
weixin_30443895的博客
09-17 214
------------------------------------ -- 1a. Setup the Org_id ------------------------------------ exec dbms_application_info.set_client_info('204'); ------------------------------------ ...
API及接口清单
kelly_yun的博客
10-28 1320
API及接口清单
R12客户表结构分析
weixin_33805557的博客
01-01 182
客户表/联系人/PARTY关联   HZ_PARTIES客户账户表   HZ_CUST_ACCOUNTS例子：   select hp.party_number --客户注册标识         ,          hp.party_name --组织名/客户         ,          hp.known_as --别名         ,          hp.organizati...
[zz]Oracle EBS API: TCA模型主要对象的API示例
coujie52097的博客
11-30 331
在Oracle EBS中, TCA(Trading Community Architecture)作为一个重要的基础模型, 用于保存客户, 员工, 供应商, 合作伙伴的数据, 以及其相互关系, 是CRM, OM, PO, C...
excel导入python改写
最新发布
11-02
如果想要在Python中修改Excel文件，可以使用一些常用的库，如xlrd、openpyxl、xlsxwriter、xlwt等。其中，xlrd和openpyxl用于读取Excel文件，xlsxwriter和xlwt用于写入Excel文件。下面是一个简单的例子，演示如何...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值