程序博客网 > vue.js 如何防止xss

SLA常用追溯子模块SQL

来源：互联网 发布：vue.js 如何防止xss 编辑：程序博客网 时间：2024/05/29 17:23

1.1.SLA与AP_INVOICE


  1. Select Aia.Org_Id,
  2.        Aia.Invoice_Id,
  3.        Aia.Invoice_Num,
  4.        Aila.Line_Number Invoice_Line_Number,
  5.        Aida.Distribution_Line_Number,
  6.        Aida.Invoice_Distribution_Id,
  7.        Aida.Line_Type_Lookup_Code,
  8.        Xte.Application_Id,
  9.        Xte.Entity_Id,
  10.        Xe.Event_Id,
  11.        Xah.Ae_Header_Id,
  12.        Xal.Ae_Line_Num,
  13.        Xal.Displayed_Line_Number,
  14.        Xdl.Source_Distribution_Type,
  15.        Xdl.Accounting_Line_Code,
  16.        Xdl.Unrounded_Accounted_Dr,
  17.        Xdl.Unrounded_Accounted_Cr,
  18.        Gjh.Name,
  19.        Gjl.Je_Line_Num
  20.   From Ap_Invoices_All              Aia,
  21.        Ap_Invoice_Lines_All         Aila,
  22.        Ap_Invoice_Distributions_All Aida,
  23.        Xla.Xla_Transaction_Entities Xte,
  24.        Xla_Events                   Xe,
  25.        Xla_Ae_Headers               Xah,
  26.        Xla_Ae_Lines                 Xal,
  27.        Xla_Distribution_Links       Xdl,
  28.        
  29.        Gl_Import_References Gir,
  30.        Gl_Je_Headers        Gjh,
  31.        Gl_Je_Lines          Gjl
  32.  Where Aia.Invoice_Id = Aila.Invoice_Id
  33.       
  34.    And Aila.Invoice_Id = Aida.Invoice_Id
  35.    And Aila.Line_Number = Aida.Invoice_Line_Number
  36.       
  37.    And Xte.Ledger_Id = Aia.Set_Of_Books_Id
  38.    And Xte.Entity_Code = 'AP_INVOICES'
  39.    And Nvl(Xte.Source_Id_Int_1, -99) = Aia.Invoice_Id
  40.       
  41.    And Xte.Application_Id = Xe.Application_Id
  42.    And Xte.Entity_Id = Xe.Entity_Id
  43.       
  44.    And Xe.Application_Id = Xah.Application_Id
  45.    And Xe.Event_Id = Xah.Event_Id
  46.       
  47.    And Xe.Event_Type_Code Not In ('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
  48.       
  49.    And Xah.Application_Id = Xal.Application_Id
  50.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  51.       
  52.    And Xal.Application_Id = Xdl.Application_Id
  53.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  54.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  55.       
  56.    And Xdl.Source_Distribution_Type = 'AP_INV_DIST'
  57.    And Xdl.Source_Distribution_Id_Num_1 = Aida.Invoice_Distribution_Id
  58.       
  59.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  60.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  61.       
  62.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  63.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  64.       
  65.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  66.       
  67.    And Aia.Invoice_Num = '02764984'
  68.    And Aida.Distribution_Line_Number = 1
  70.  Order By Aia.Invoice_Num, Aida.Invoice_Line_Number, Aida.Distribution_Line_Number;



预付款核销：



  1. Select Aia.Org_Id,
  2.        Aia.Invoice_Id,
  3.        Aia.Invoice_Num,
  4.        Aila.Line_Number Invoice_Line_Number,
  5.        Aida.Distribution_Line_Number,
  6.        Aida.Invoice_Distribution_Id,
  7.        Aida.Line_Type_Lookup_Code,
  8.        Xte.Application_Id,
  9.        Xte.Entity_Id,
  10.        Xe.Event_Id,
  11.        Xah.Ae_Header_Id,
  12.        Xal.Ae_Line_Num,
  13.        Xal.Displayed_Line_Number,
  14.        Xdl.Source_Distribution_Type,
  15.        Xdl.Accounting_Line_Code,
  16.        Xdl.Unrounded_Accounted_Dr,
  17.        Xdl.Unrounded_Accounted_Cr,
  18.        Gjh.Name,
  19.        Gjl.Je_Line_Num
  20.   From Ap_Invoices_All              Aia,
  21.        Ap_Invoice_Lines_All         Aila,
  22.        Ap_Invoice_Distributions_All Aida,
  23.        Ap_Prepay_App_Dists          Apad,
  24.        Xla.Xla_Transaction_Entities Xte,
  25.        Xla_Events                   Xe,
  26.        Xla_Ae_Headers               Xah,
  27.        Xla_Ae_Lines                 Xal,
  28.        Xla_Distribution_Links       Xdl,
  29.        
  30.        Gl_Import_References Gir,
  31.        Gl_Je_Headers        Gjh,
  32.        Gl_Je_Lines          Gjl
  33.  Where Aia.Invoice_Id = Aila.Invoice_Id
  34.       
  35.    And Aila.Invoice_Id = Aida.Invoice_Id
  36.    And Aila.Line_Number = Aida.Invoice_Line_Number
  37.       
  38.    And Aida.Invoice_Distribution_Id = Apad.Invoice_Distribution_Id
  39.       
  40.    And Xte.Ledger_Id = Aia.Set_Of_Books_Id
  41.    And Xte.Entity_Code = 'AP_INVOICES'
  42.    And Nvl(Xte.Source_Id_Int_1, -99) = Aia.Invoice_Id
  43.       
  44.    And Xte.Application_Id = Xe.Application_Id
  45.    And Xte.Entity_Id = Xe.Entity_Id
  46.       
  47.    And Xe.Application_Id = Xah.Application_Id
  48.    And Xe.Event_Id = Xah.Event_Id
  49.       
  50.    And Xe.Event_Type_Code In ('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
  51.       
  52.    And Xah.Application_Id = Xal.Application_Id
  53.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  54.       
  55.    And Xal.Application_Id = Xdl.Application_Id
  56.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  57.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  58.       
  59.    And Xdl.Source_Distribution_Type = 'AP_PREPAY'
  60.    And Xdl.Source_Distribution_Id_Num_1 = Apad.Prepay_App_Dist_Id
  61.       
  62.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  63.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  64.       
  65.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  66.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  67.       
  68.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  69.       
  70.    And Aia.Invoice_Num = '06532493'
  72.  Order By Aia.Invoice_Num, Aida.Invoice_Line_Number, Aida.Distribution_Line_Number;

1.1.SLA与AP_PAYMENT

  1. Select Ac.Org_Id,
  2.        Ac.Check_Id,
  3.        Ac.Check_Number,
  4.        Apha.Payment_History_Id,
  5.        Aphd.Payment_Hist_Dist_Id,
  6.        Aphd.Pay_Dist_Lookup_Code,
  7.        Xte.Application_Id,
  8.        Xte.Entity_Id,
  9.        Xe.Event_Id,
  10.        Xah.Ae_Header_Id,
  11.        Xal.Ae_Line_Num,
  12.        Xal.Displayed_Line_Number,
  13.        Xdl.Source_Distribution_Type,
  14.        Xdl.Accounting_Line_Code,
  15.        Xdl.Unrounded_Accounted_Dr,
  16.        Xdl.Unrounded_Accounted_Cr,
  17.        Gjh.Name,
  18.        Gjl.Je_Line_Num
  19.   From Ap_Checks_All                Ac,
  20.        Ap_System_Parameters_All     Aspa,
  21.        Ap_Payment_History_All       Apha,
  22.        Ap_Payment_Hist_Dists        Aphd,
  23.        Ap_Invoice_Distributions_All Aida,
  24.        Xla.Xla_Transaction_Entities Xte,
  25.        Xla_Events                   Xe,
  26.        Xla_Ae_Headers               Xah,
  27.        Xla_Ae_Lines                 Xal,
  28.        Xla_Distribution_Links       Xdl,
  29.        
  30.        Gl_Import_References Gir,
  31.        Gl_Je_Headers        Gjh,
  32.        Gl_Je_Lines          Gjl
  33.  Where Ac.Org_Id = Aspa.Org_Id
  34.       
  35.    And Ac.Check_Id = Apha.Check_Id
  36.    And Apha.Payment_History_Id = Aphd.Payment_History_Id
  37.    And Aphd.Invoice_Distribution_Id = Aida.Invoice_Distribution_Id
  38.       
  39.    And Xte.Ledger_Id = Aspa.Set_Of_Books_Id
  40.    And Xte.Entity_Code = 'AP_PAYMENTS'
  41.    And Nvl(Xte.Source_Id_Int_1, -99) = Ac.Check_Id
  42.       
  43.    And Xte.Application_Id = Xe.Application_Id
  44.    And Xte.Entity_Id = Xe.Entity_Id
  45.       
  46.    And Xe.Application_Id = Xah.Application_Id
  47.    And Xe.Event_Id = Xah.Event_Id
  48.       
  49.    And Xah.Application_Id = Xal.Application_Id
  50.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  51.       
  52.    And Xal.Application_Id = Xdl.Application_Id
  53.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  54.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  55.       
  56.    And Xdl.Source_Distribution_Type = 'AP_PMT_DIST'
  57.    And Xdl.Source_Distribution_Id_Num_1 = Aphd.Payment_Hist_Dist_Id
  58.       
  59.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  60.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  61.       
  62.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  63.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  64.       
  65.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  66.       
  67.    And Ac.Check_Id = 79508
  69.  Order By Ac.Check_Number;

1.1.SLA与AR_TRANSACTIONS

  1. 应收发票：
  2. Select Rcta.Org_Id,
  3.        Rcta.Customer_Trx_Id Source_Id,
  4.        Rctla.Customer_Trx_Line_Id Source_Line_Id,
  5.        Rcta.Trx_Number Source_Doc_Number,
  6.        Rctla.Line_Number Source_Doc_Line_Number,
  7.        Xte.Application_Id,
  8.        Xte.Entity_Id,
  9.        Xe.Event_Id,
  10.        Xah.Ae_Header_Id,
  11.        Xal.Ae_Line_Num,
  12.        Xal.Displayed_Line_Number,
  13.        Xdl.Source_Distribution_Type,
  14.        Xdl.Accounting_Line_Code,
  15.        Xdl.Unrounded_Entered_Dr,
  16.        Xdl.Unrounded_Entered_Cr,
  17.        Xdl.Unrounded_Accounted_Dr,
  18.        Xdl.Unrounded_Accounted_Cr,
  19.        Gjh.Ledger_Id Set_Of_Books_Id,
  20.        Gjl.Code_Combination_Id,
  21.        Gjh.Name,
  22.        Gjh.Je_Header_Id,
  23.        Gjl.Je_Line_Num,
  24.        Hca.Cust_Account_Id Third_Party_Id,
  25.        Hca.Account_Number Third_Party_Number,
  26.        Substrb(Hp.Party_Name, 1, 50) Third_Party_Name
  27.   From Ra_Customer_Trx_All          Rcta,
  28.        Ra_Customer_Trx_Lines_All    Rctla,
  29.        Ra_Cust_Trx_Line_Gl_Dist_All Rctlgda,
  30.        Hz_Cust_Accounts             Hca,
  31.        Hz_Parties                   Hp,
  32.        Xla.Xla_Transaction_Entities Xte,
  33.        Xla_Events                   Xe,
  34.        Xla_Ae_Headers               Xah,
  35.        Xla_Ae_Lines                 Xal,
  36.        Xla_Distribution_Links       Xdl,
  37.        
  38.        Gl_Import_References Gir,
  39.        Gl_Je_Headers        Gjh,
  40.        Gl_Je_Lines          Gjl
  41.  Where 1 = 1
  42.       
  43.       -- Altered by Mingwei.Liu on 2014/09/26 for Mantis 36670 分类为应付帐款时，没有对应的行信息
  44.    And Rcta.Customer_Trx_Id = Rctlgda.Customer_Trx_Id
  45.       
  46.    And Rctlgda.Customer_Trx_Id = Rctla.Customer_Trx_Id(+)
  47.    And Rctlgda.Customer_Trx_Line_Id = Rctla.Customer_Trx_Line_Id(+)
  48.       -- The End --
  49.       
  50.    And Hca.Cust_Account_Id(+) = Rcta.Bill_To_Customer_Id
  51.    And Hp.Party_Id(+) = Hca.Party_Id
  52.       
  53.    And Xte.Ledger_Id = Rcta.Set_Of_Books_Id
  54.    And Xte.Entity_Code = 'TRANSACTIONS'
  55.    And Nvl(Xte.Source_Id_Int_1, -99) = Rcta.Customer_Trx_Id
  56.       
  57.    And Xte.Application_Id = Xe.Application_Id
  58.    And Xte.Entity_Id = Xe.Entity_Id
  59.       
  60.    And Xe.Application_Id = Xah.Application_Id
  61.    And Xe.Event_Id = Xah.Event_Id
  62.       
  63.    And Xah.Application_Id = Xal.Application_Id
  64.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  65.       
  66.    And Xal.Application_Id = Xdl.Application_Id
  67.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  68.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  69.       
  70.    And Xdl.Source_Distribution_Type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
  71.    And Xdl.Source_Distribution_Id_Num_1 = Rctlgda.Cust_Trx_Line_Gl_Dist_Id
  72.       
  73.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  74.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  75.       
  76.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  77.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  78.       
  79.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id;
  1. -- 贷项通知单核销
  2. Select Rcta.Org_Id,
  3.        Rcta.Customer_Trx_Id,
  4.        Ada.Line_Id,
  5.        Rcta.Trx_Number,
  6.        Null Line_Number,
  7.        Xte.Application_Id,
  8.        Xte.Entity_Id,
  9.        Xe.Event_Id,
  10.        Xe.Event_Type_Code,
  11.        Xah.Ae_Header_Id,
  12.        Xal.Ae_Line_Num,
  13.        Xal.Displayed_Line_Number,
  14.        Xdl.Source_Distribution_Type,
  15.        Xdl.Accounting_Line_Code,
  16.        Xdl.Unrounded_Entered_Dr,
  17.        Xdl.Unrounded_Entered_Cr,
  18.        Xdl.Unrounded_Accounted_Dr,
  19.        Xdl.Unrounded_Accounted_Cr,
  20.        Gjh.Ledger_Id Set_Of_Books_Id,
  21.        Gjl.Code_Combination_Id,
  22.        Gjh.Name,
  23.        Gjh.Je_Header_Id,
  24.        Gjl.Je_Line_Num,
  25.        Hca.Cust_Account_Id Third_Party_Id,
  26.        Hca.Account_Number Third_Party_Number,
  27.        Substrb(Hp.Party_Name, 1, 50) Third_Party_Name
  28.   From Ra_Customer_Trx_All            Rcta,
  29.        Ar_Receivable_Applications_All Araa,
  30.        Ar_Distributions_All           Ada,
  31.        Hz_Cust_Accounts               Hca,
  32.        Hz_Parties                     Hp,
  33.        Xla.Xla_Transaction_Entities   Xte,
  34.        Xla_Events                     Xe,
  35.        Xla_Ae_Headers                 Xah,
  36.        Xla_Ae_Lines                   Xal,
  37.        Xla_Distribution_Links         Xdl,
  38.        
  39.        Gl_Import_References Gir,
  40.        Gl_Je_Headers        Gjh,
  41.        Gl_Je_Lines          Gjl
  42.  Where Rcta.Customer_Trx_Id = Araa.Customer_Trx_Id
  43.       
  44.    And Araa.Receivable_Application_Id = Ada.Source_Id
  45.    And Ada.Source_Table = 'RA'
  46.       
  47.    And Hca.Cust_Account_Id(+) = Ada.Third_Party_Id
  48.    And Hp.Party_Id(+) = Hca.Party_Id
  49.       
  50.    And Xte.Ledger_Id = Rcta.Set_Of_Books_Id
  51.    And Xte.Entity_Code = 'TRANSACTIONS'
  52.    And Nvl(Xte.Source_Id_Int_1, -99) = Rcta.Customer_Trx_Id
  53.       
  54.    And Xte.Application_Id = Xe.Application_Id
  55.    And Xte.Entity_Id = Xe.Entity_Id
  56.       
  57.    And Xe.Application_Id = Xah.Application_Id
  58.    And Xe.Event_Id = Xah.Event_Id
  59.       
  60.    And Xah.Application_Id = Xal.Application_Id
  61.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  62.       
  63.    And Xal.Application_Id = Xdl.Application_Id
  64.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  65.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  66.       
  67.    And Xdl.Source_Distribution_Type = 'AR_DISTRIBUTIONS_ALL'
  68.    And Xdl.Source_Distribution_Id_Num_1 = Ada.Line_Id
  69.       
  70.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  71.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  72.       
  73.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  74.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  75.       
  76.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  77.       
  78.    And Rcta.Customer_Trx_Id = 174721;
  1. -- Bills Receivable
  2. Select Rcta.Org_Id,
  3.        Rcta.Customer_Trx_Id,
  4.        Ada.Line_Id,
  5.        Rcta.Trx_Number,
  6.        Null Line_Number,
  7.        Xte.Application_Id,
  8.        Xte.Entity_Id,
  9.        Xe.Event_Id,
  10.        Xe.Event_Type_Code,
  11.        Xah.Ae_Header_Id,
  12.        Xal.Ae_Line_Num,
  13.        Xal.Displayed_Line_Number,
  14.        Xdl.Source_Distribution_Type,
  15.        Xdl.Accounting_Line_Code,
  16.        Xdl.Unrounded_Entered_Dr,
  17.        Xdl.Unrounded_Entered_Cr,
  18.        Xdl.Unrounded_Accounted_Dr,
  19.        Xdl.Unrounded_Accounted_Cr,
  20.        Gjh.Ledger_Id Set_Of_Books_Id,
  21.        Gjl.Code_Combination_Id,
  22.        Gjh.Name,
  23.        Gjh.Je_Header_Id,
  24.        Gjl.Je_Line_Num,
  25.        Hca.Cust_Account_Id Third_Party_Id,
  26.        Hca.Account_Number Third_Party_Number,
  27.        Substrb(Hp.Party_Name, 1, 50) Third_Party_Name
  28.   From Ra_Customer_Trx_All          Rcta,
  29.        Ar_Transaction_History_All   Atha,
  30.        Ar_Distributions_All         Ada,
  31.        Hz_Cust_Accounts             Hca,
  32.        Hz_Parties                   Hp,
  33.        Xla.Xla_Transaction_Entities Xte,
  34.        Xla_Events                   Xe,
  35.        Xla_Ae_Headers               Xah,
  36.        Xla_Ae_Lines                 Xal,
  37.        Xla_Distribution_Links       Xdl,
  38.        
  39.        Gl_Import_References Gir,
  40.        Gl_Je_Headers        Gjh,
  41.        Gl_Je_Lines          Gjl
  42.  Where Rcta.Customer_Trx_Id = Atha.Customer_Trx_Id
  43.       
  44.    And Atha.Transaction_History_Id = Ada.Source_Id
  45.    And Ada.Source_Table = 'TH'
  46.       
  47.    And Hca.Cust_Account_Id(+) = Ada.Third_Party_Id
  48.    And Hp.Party_Id(+) = Hca.Party_Id
  49.       
  50.    And Xte.Ledger_Id = Rcta.Set_Of_Books_Id
  51.    And Xte.Entity_Code = 'BILLS_RECEIVABLE'
  52.    And Nvl(Xte.Source_Id_Int_1, -99) = Rcta.Customer_Trx_Id
  53.       
  54.    And Xte.Application_Id = Xe.Application_Id
  55.    And Xte.Entity_Id = Xe.Entity_Id
  56.       
  57.    And Xe.Application_Id = Xah.Application_Id
  58.    And Xe.Event_Id = Xah.Event_Id
  59.       
  60.    And Xah.Application_Id = Xal.Application_Id
  61.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  62.       
  63.    And Xal.Application_Id = Xdl.Application_Id
  64.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  65.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  66.       
  67.    And Xdl.Source_Distribution_Type = 'AR_DISTRIBUTIONS_ALL'
  68.    And Xdl.Source_Distribution_Id_Num_1 = Ada.Line_Id
  69.       
  70.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  71.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  72.       
  73.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  74.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  75.       
  76.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id;

1.1.SLA与AR_RECEIPTS

  1. Select Acra.Org_Id,
  2.        Acra.Cash_Receipt_Id,
  3.        Ada.Line_Id,
  4.        Acra.Receipt_Number,
  5.        Null Line_Number,
  6.        Xte.Application_Id,
  7.        Xte.Entity_Id,
  8.        Xe.Event_Id,
  9.        Xah.Ae_Header_Id,
  10.        Xal.Ae_Line_Num,
  11.        Xal.Displayed_Line_Number,
  12.        Xdl.Source_Distribution_Type,
  13.        Xdl.Accounting_Line_Code,
  14.        Xdl.Unrounded_Entered_Dr,
  15.        Xdl.Unrounded_Entered_Cr,
  16.        Xdl.Unrounded_Accounted_Dr,
  17.        Xdl.Unrounded_Accounted_Cr,
  18.        Gjh.Name,
  19.        Gjh.Je_Header_Id,
  20.        Gjl.Je_Line_Num,
  21.        Hca.Cust_Account_Id Third_Party_Id,
  22.        Hca.Account_Number Third_Party_Number,
  23.        Substrb(Hp.Party_Name, 1, 50) Third_Party_Name
  24.   From Ar_Cash_Receipts_All         Acra,
  25.        Ar_Cash_Receipt_History_All  Acrha,
  26.        Ar_Distributions_All         Ada,
  27.        Hz_Cust_Accounts             Hca,
  28.        Hz_Parties                   Hp,
  29.        Xla.Xla_Transaction_Entities Xte,
  30.        Xla_Events                   Xe,
  31.        Xla_Ae_Headers               Xah,
  32.        Xla_Ae_Lines                 Xal,
  33.        Xla_Distribution_Links       Xdl,
  34.        
  35.        Gl_Import_References Gir,
  36.        Gl_Je_Headers        Gjh,
  37.        Gl_Je_Lines          Gjl
  38.  Where Acra.Cash_Receipt_Id = Acrha.Cash_Receipt_Id
  39.       
  40.    And Acrha.Cash_Receipt_History_Id = Ada.Source_Id
  41.    And Ada.Source_Table = 'CRH'
  42.       
  43.    And Hca.Cust_Account_Id(+) = Ada.Third_Party_Id
  44.    And Hp.Party_Id(+) = Hca.Party_Id
  45.       
  46.    And Xte.Ledger_Id = Acra.Set_Of_Books_Id
  47.    And Xte.Entity_Code = 'RECEIPTS'
  48.    And Nvl(Xte.Source_Id_Int_1, -99) = Acra.Cash_Receipt_Id
  49.       
  50.    And Xte.Application_Id = Xe.Application_Id
  51.    And Xte.Entity_Id = Xe.Entity_Id
  52.       
  53.    And Xe.Application_Id = Xah.Application_Id
  54.    And Xe.Event_Id = Xah.Event_Id
  55.       
  56.    And Xah.Application_Id = Xal.Application_Id
  57.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  58.       
  59.    And Xal.Application_Id = Xdl.Application_Id
  60.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  61.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  62.       
  63.    And Xdl.Source_Distribution_Type = 'AR_DISTRIBUTIONS_ALL'
  64.    And Xdl.Source_Distribution_Id_Num_1 = Ada.Line_Id
  65.       
  66.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  67.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  68.       
  69.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  70.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  71.       
  72.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  74. Union All
  76. -- Receipt applications
  77. Select Acra.Org_Id,
  78.        Acra.Cash_Receipt_Id,
  79.        Ada.Line_Id,
  80.        Acra.Receipt_Number,
  81.        Null Line_Number,
  82.        Xte.Application_Id,
  83.        Xte.Entity_Id,
  84.        Xe.Event_Id,
  85.        Xah.Ae_Header_Id,
  86.        Xal.Ae_Line_Num,
  87.        Xal.Displayed_Line_Number,
  88.        Xdl.Source_Distribution_Type,
  89.        Xdl.Accounting_Line_Code,
  90.        Xdl.Unrounded_Entered_Dr,
  91.        Xdl.Unrounded_Entered_Cr,
  92.        Xdl.Unrounded_Accounted_Dr,
  93.        Xdl.Unrounded_Accounted_Cr,
  94.        Gjh.Name,
  95.        Gjh.Je_Header_Id,
  96.        Gjl.Je_Line_Num,
  97.        Hca.Cust_Account_Id Third_Party_Id,
  98.        Hca.Account_Number Third_Party_Number,
  99.        Substrb(Hp.Party_Name, 1, 50) Third_Party_Name
  100.   From Ar_Cash_Receipts_All           Acra,
  101.        Ar_Receivable_Applications_All Araa,
  102.        Ar_Distributions_All           Ada,
  103.        Hz_Cust_Accounts               Hca,
  104.        Hz_Parties                     Hp,
  105.        Xla.Xla_Transaction_Entities   Xte,
  106.        Xla_Events                     Xe,
  107.        Xla_Ae_Headers                 Xah,
  108.        Xla_Ae_Lines                   Xal,
  109.        Xla_Distribution_Links         Xdl,
  110.        
  111.        Gl_Import_References Gir,
  112.        Gl_Je_Headers        Gjh,
  113.        Gl_Je_Lines          Gjl
  114.  Where Acra.Cash_Receipt_Id = Araa.Cash_Receipt_Id
  115.       
  116.    And Araa.Receivable_Application_Id = Ada.Source_Id
  117.    And Ada.Source_Table = 'RA'
  118.       
  119.    And Hca.Cust_Account_Id(+) = Ada.Third_Party_Id
  120.    And Hp.Party_Id(+) = Hca.Party_Id
  121.       
  122.    And Xte.Ledger_Id = Acra.Set_Of_Books_Id
  123.    And Xte.Entity_Code = 'RECEIPTS'
  124.    And Nvl(Xte.Source_Id_Int_1, -99) = Acra.Cash_Receipt_Id
  125.       
  126.    And Xte.Application_Id = Xe.Application_Id
  127.    And Xte.Entity_Id = Xe.Entity_Id
  128.       
  129.    And Xe.Application_Id = Xah.Application_Id
  130.    And Xe.Event_Id = Xah.Event_Id
  131.       
  132.    And Xah.Application_Id = Xal.Application_Id
  133.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  134.       
  135.    And Xal.Application_Id = Xdl.Application_Id
  136.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  137.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  138.       
  139.    And Xdl.Source_Distribution_Type = 'AR_DISTRIBUTIONS_ALL'
  140.    And Xdl.Source_Distribution_Id_Num_1 = Ada.Line_Id
  141.       
  142.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  143.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  144.       
  145.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  146.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  147.       
  148.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  150. Union All
  152. -- Misc Cash Dist
  153. Select Acra.Org_Id,
  154.        Acra.Cash_Receipt_Id,
  155.        Ada.Line_Id,
  156.        Acra.Receipt_Number,
  157.        Null Line_Number,
  158.        Xte.Application_Id,
  159.        Xte.Entity_Id,
  160.        Xe.Event_Id,
  161.        Xah.Ae_Header_Id,
  162.        Xal.Ae_Line_Num,
  163.        Xal.Displayed_Line_Number,
  164.        Xdl.Source_Distribution_Type,
  165.        Xdl.Accounting_Line_Code,
  166.        Xdl.Unrounded_Entered_Dr,
  167.        Xdl.Unrounded_Entered_Cr,
  168.        Xdl.Unrounded_Accounted_Dr,
  169.        Xdl.Unrounded_Accounted_Cr,
  170.        Gjh.Name,
  171.        Gjh.Je_Header_Id,
  172.        Gjl.Je_Line_Num,
  173.        Hca.Cust_Account_Id Third_Party_Id,
  174.        Hca.Account_Number Third_Party_Number,
  175.        Substrb(Hp.Party_Name, 1, 50) Third_Party_Name
  176.   From Ar_Cash_Receipts_All           Acra,
  177.        Ar_Misc_Cash_Distributions_All Amcda,
  178.        Ar_Distributions_All           Ada,
  179.        Hz_Cust_Accounts               Hca,
  180.        Hz_Parties                     Hp,
  181.        Xla.Xla_Transaction_Entities   Xte,
  182.        Xla_Events                     Xe,
  183.        Xla_Ae_Headers                 Xah,
  184.        Xla_Ae_Lines                   Xal,
  185.        Xla_Distribution_Links         Xdl,
  186.        
  187.        Gl_Import_References Gir,
  188.        Gl_Je_Headers        Gjh,
  189.        Gl_Je_Lines          Gjl
  190.  Where Acra.Cash_Receipt_Id = Amcda.Cash_Receipt_Id
  191.       
  192.    And Amcda.Misc_Cash_Distribution_Id = Ada.Source_Id
  193.    And Ada.Source_Table = 'MCD'
  194.       
  195.    And Hca.Cust_Account_Id(+) = Ada.Third_Party_Id
  196.    And Hp.Party_Id(+) = Hca.Party_Id
  197.       
  198.    And Xte.Ledger_Id = Acra.Set_Of_Books_Id
  199.    And Xte.Entity_Code = 'RECEIPTS'
  200.    And Nvl(Xte.Source_Id_Int_1, -99) = Acra.Cash_Receipt_Id
  201.       
  202.    And Xte.Application_Id = Xe.Application_Id
  203.    And Xte.Entity_Id = Xe.Entity_Id
  204.       
  205.    And Xe.Application_Id = Xah.Application_Id
  206.    And Xe.Event_Id = Xah.Event_Id
  207.       
  208.    And Xah.Application_Id = Xal.Application_Id
  209.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  210.       
  211.    And Xal.Application_Id = Xdl.Application_Id
  212.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  213.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  214.       
  215.    And Xdl.Source_Distribution_Type = 'AR_DISTRIBUTIONS_ALL'
  216.    And Xdl.Source_Distribution_Id_Num_1 = Ada.Line_Id
  217.       
  218.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  219.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  220.       
  221.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  222.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  223.       
  224.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id;

1.1.SLA与AR_ADJUSTMENT

  1. Select Adj.Org_Id,
  2.        Adj.Adjustment_Id,
  3.        Ada.Line_Id,
  4.        Rcta.Trx_Number,
  5.        Rctla.Line_Number            Trx_Line_Number,
  6.        Adj.Adjustment_Number,
  7.        Null                         Adj_Line_Number,
  8.        Xte.Application_Id,
  9.        Xte.Entity_Id,
  10.        Xe.Event_Id,
  11.        Xah.Ae_Header_Id,
  12.        Xal.Ae_Line_Num,
  13.        Xal.Displayed_Line_Number,
  14.        Xdl.Source_Distribution_Type,
  15.        Xdl.Accounting_Line_Code,
  16.        Xdl.Unrounded_Entered_Dr,
  17.        Xdl.Unrounded_Entered_Cr,
  18.        Xdl.Unrounded_Accounted_Dr,
  19.        Xdl.Unrounded_Accounted_Cr,
  20.        Gjh.Name,
  21.        Gjh.Je_Header_Id,
  22.        Gjl.Je_Line_Num
  23.   From Ra_Customer_Trx_All          Rcta,
  24.        Ra_Customer_Trx_Lines_All    Rctla,
  25.        Ar_Adjustments_All           Adj,
  26.        Ar_Distributions_All         Ada,
  27.        Xla.Xla_Transaction_Entities Xte,
  28.        Xla_Events                   Xe,
  29.        Xla_Ae_Headers               Xah,
  30.        Xla_Ae_Lines                 Xal,
  31.        Xla_Distribution_Links       Xdl,
  32.        
  33.        Gl_Import_References Gir,
  34.        Gl_Je_Headers        Gjh,
  35.        Gl_Je_Lines          Gjl
  36.  Where Adj.Customer_Trx_Id = Rcta.Customer_Trx_Id(+)
  37.       
  38.    And Adj.Customer_Trx_Id = Rctla.Customer_Trx_Id(+)
  39.    And Adj.Customer_Trx_Line_Id = Rctla.Customer_Trx_Line_Id(+)
  40.       
  41.    And Adj.Adjustment_Id = Ada.Source_Id
  42.    And Ada.Source_Table = 'ADJ'
  43.       
  44.    And Xte.Ledger_Id = Adj.Set_Of_Books_Id
  45.    And Xte.Entity_Code = 'ADJUSTMENTS'
  46.    And Nvl(Xte.Source_Id_Int_1, -99) = Adj.Adjustment_Id
  47.       
  48.    And Xte.Application_Id = Xe.Application_Id
  49.    And Xte.Entity_Id = Xe.Entity_Id
  50.       
  51.    And Xe.Application_Id = Xah.Application_Id
  52.    And Xe.Event_Id = Xah.Event_Id
  53.       
  54.    And Xah.Application_Id = Xal.Application_Id
  55.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  56.       
  57.    And Xal.Application_Id = Xdl.Application_Id
  58.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  59.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  60.       
  61.    And Xdl.Source_Distribution_Type = 'AR_DISTRIBUTIONS_ALL'
  62.    And Xdl.Source_Distribution_Id_Num_1 = Ada.Line_Id
  63.       
  64.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  65.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  66.       
  67.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  68.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  69.       
  70.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id
  71.       
  72.    And Rcta.Trx_Number = '01478574';

1.1.SLA与PO_RECEIVE

  1. Select Xah.Ae_Header_Id,
  2.        Xal.Ae_Line_Num,
  3.        Xal.Accounting_Class_Code,
  4.        Xal.Accounted_Dr,
  5.        Xal.Accounted_Cr,
  6.        Rt.Transaction_Id,
  7.        Rt.Shipment_Header_Id
  8.   From Rcv_Transactions             Rt,
  9.        Rcv_Receiving_Sub_Ledger     Rrsl,
  10.        Xla.Xla_Transaction_Entities Xte,
  11.        Xla_Events                   Xe,
  12.        Xla_Ae_Headers               Xah,
  13.        Xla_Ae_Lines                 Xal,
  14.        Xla_Distribution_Links       Xdl,
  15.        
  16.        Gl_Import_References Gir,
  17.        Gl_Je_Headers        Gjh,
  18.        Gl_Je_Lines          Gjl
  19.  Where Rt.Transaction_Id = Rrsl.Rcv_Transaction_Id
  20.       
  21.    And Xte.Ledger_Id = Rrsl.Set_Of_Books_Id
  22.    And Xte.Entity_Code = 'RCV_ACCOUNTING_EVENTS'
  23.    And Nvl(Xte.Source_Id_Int_1, -99) = Rt.Transaction_Id
  24.       
  25.    And Xte.Application_Id = Xe.Application_Id
  26.    And Xte.Entity_Id = Xe.Entity_Id
  27.       
  28.    And Xe.Application_Id = Xah.Application_Id
  29.    And Xe.Event_Id = Xah.Event_Id
  30.       
  31.    And Xah.Application_Id = Xal.Application_Id
  32.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  33.       
  34.    And Xal.Application_Id = Xdl.Application_Id
  35.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  36.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  37.       
  38.    And Xdl.Source_Distribution_Type = 'RCV_RECEIVING_SUB_LEDGER'
  39.    And Xdl.Source_Distribution_Id_Num_1 = Rrsl.Rcv_Sub_Ledger_Id
  40.       
  41.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  42.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  43.       
  44.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  45.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  46.       
  47.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id;

1.1.SLA与INV_TRANSACTIONS

  1. Select Xah.Ae_Header_Id,
  2.        Xal.Ae_Line_Num,
  3.        Xal.Accounting_Class_Code,
  4.        Xal.Accounted_Dr,
  5.        Xal.Accounted_Cr,
  6.        Mmt.Transaction_Id,
  7.        Mta.Inv_Sub_Ledger_Id
  8.   From Mtl_Material_Transactions    Mmt,
  9.        Mtl_Transaction_Accounts     Mta,
  10.        Org_Organization_Definitions Ood,
  11.        Xla.Xla_Transaction_Entities Xte,
  12.        Xla_Events                   Xe,
  13.        Xla_Ae_Headers               Xah,
  14.        Xla_Ae_Lines                 Xal,
  15.        Xla_Distribution_Links       Xdl,
  16.        
  17.        Gl_Import_References Gir,
  18.        Gl_Je_Headers        Gjh,
  19.        Gl_Je_Lines          Gjl
  20.  Where Mmt.Transaction_Id = Mta.Transaction_Id
  21.    And Ood.Organization_Id = Mta.Organization_Id
  22.       
  23.    And Xte.Ledger_Id = Ood.Set_Of_Books_Id
  24.    And Xte.Entity_Code = 'MTL_ACCOUNTING_EVENTS'
  25.    And Nvl(Xte.Source_Id_Int_1, -99) = Mta.Transaction_Id
  26.    And Nvl(Xte.Source_Id_Int_2, -99) = Mta.Organization_Id
  27.    And Nvl(Xte.Source_Id_Int_3, -99) = Mta.Transaction_Source_Type_Id
  28.       
  29.    And Xte.Application_Id = Xe.Application_Id
  30.    And Xte.Entity_Id = Xe.Entity_Id
  31.       
  32.    And Xe.Application_Id = Xah.Application_Id
  33.    And Xe.Event_Id = Xah.Event_Id
  34.       
  35.    And Xah.Application_Id = Xal.Application_Id
  36.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  37.       
  38.    And Xal.Application_Id = Xdl.Application_Id
  39.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  40.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  41.       
  42.    And Xdl.Source_Distribution_Type = 'MTL_TRANSACTION_ACCOUNTS'
  43.    And Xdl.Source_Distribution_Id_Num_1 = Mta.Inv_Sub_Ledger_Id
  44.       
  45.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  46.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  47.       
  48.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  49.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  50.       
  51.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id;

1.1.SLA与WIP_TRANSACTIONS

  1. Select Xah.Ae_Header_Id,
  2.        Xal.Ae_Line_Num,
  3.        Xal.Accounting_Class_Code,
  4.        Xal.Accounted_Dr,
  5.        Xal.Accounted_Cr,
  6.        Wt.Transaction_Id,
  7.        Wta.Wip_Sub_Ledger_Id
  8.   From Wip_Transactions             Wt,
  9.        Wip_Transaction_Accounts     Wta,
  10.        Org_Organization_Definitions Ood,
  11.        Xla.Xla_Transaction_Entities Xte,
  12.        Xla_Events                   Xe,
  13.        Xla_Ae_Headers               Xah,
  14.        Xla_Ae_Lines                 Xal,
  15.        Xla_Distribution_Links       Xdl,
  16.        
  17.        Gl_Import_References Gir,
  18.        Gl_Je_Headers        Gjh,
  19.        Gl_Je_Lines          Gjl
  20.  Where Wt.Transaction_Id = Wta.Transaction_Id
  21.    And Ood.Organization_Id = Wta.Organization_Id
  22.       
  23.    And Xte.Ledger_Id = Ood.Set_Of_Books_Id
  24.    And Xte.Entity_Code = 'WIP_ACCOUNTING_EVENTS'
  25.    And Nvl(Xte.Source_Id_Int_1, -99) = Wta.Transaction_Id
  26.    And Nvl(Xte.Source_Id_Int_2, -99) = Wta.Resource_Id
  27.    And Nvl(Xte.Source_Id_Int_3, -99) = Wta.Basis_Type
  28.       
  29.    And Xte.Application_Id = Xe.Application_Id
  30.    And Xte.Entity_Id = Xe.Entity_Id
  31.       
  32.    And Xe.Application_Id = Xah.Application_Id
  33.    And Xe.Event_Id = Xah.Event_Id
  34.       
  35.    And Xah.Application_Id = Xal.Application_Id
  36.    And Xah.Ae_Header_Id = Xal.Ae_Header_Id
  37.       
  38.    And Xal.Application_Id = Xdl.Application_Id
  39.    And Xal.Ae_Header_Id = Xdl.Ae_Header_Id
  40.    And Xal.Ae_Line_Num = Xdl.Ae_Line_Num
  41.       
  42.    And Xdl.Source_Distribution_Type = 'WIP_TRANSACTION_ACCOUNTS'
  43.    And Xdl.Source_Distribution_Id_Num_1 = Wta.Wip_Sub_Ledger_Id
  44.       
  45.    And Xal.Gl_Sl_Link_Table = Gir.Gl_Sl_Link_Table
  46.    And Xal.Gl_Sl_Link_Id = Gir.Gl_Sl_Link_Id
  47.       
  48.    And Gir.Je_Header_Id = Gjl.Je_Header_Id
  49.    And Gir.Je_Line_Num = Gjl.Je_Line_Num
  50.       
  51.    And Gjh.Je_Header_Id = Gjl.Je_Header_Id;
阅读全文
1 0
vue.js 如何防止xss vue.js 如何防止xss
原创粉丝点击
热门IT博客
mac实用工具mac实用工具
2016年对外贸易数据2016年对外贸易数据
淘宝信誉提升平台担保
国内外大数据公司
开通服务器端口
两台光谱仪数据不一样
十二五数据总结
联通h十是什么几g网络
手机淘宝订单号查询
网络作家培训班
易语言安卓模拟器源码
手机怎样发淘宝链接
java显示数据库表格
javascript电子书
html下拉框显示数据库
淘宝店适合卖什么
腾讯社招面试经验java
淘宝店最高等级是什么
怎么优化古墓丽影崛起
淘宝网首页怎么装修
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 墙面装饰图片 卧室照片墙设计 手机桌面图片唯美 手机图片下载 动态璧纸 下载图片到手机 手机桌面图片高清 手机桌面图片 手绘背景墙 屏纸 公司背景墙 背景墙材料 shoujibizhi 电脑桌面图片 手机屏幕图片 手機壁紙 手机卓面 桌面大全 简欧背景墙 好看的手机桌面图片 床头背景墙 礕纸 辟纸 手机高清 高清图片下载 图片手机 壁子 下载手机图片 壁紙 手机碧纸 手机纸壁 手机背景 bizhi 免费下载图片到手机 手机图像 主题房间装修图片 新型装修材料 家装步骤顺序 辅材包括哪些 120平米户型图 装修房子不建议贴墙纸

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里