Thursday, 25 September 2014

supplier liability account detail in oracle apps


/* Formatted on 9/25/2014 9:05:48 AM (QP5 v5.115.810.9015) */
SELECT   VENDOR_NAME,
            gcc.SEGMENT1
         || ','
         || gcc.SEGMENT2
         || ','
         || gcc.SEGMENT3
         || ','
         || gcc.SEGMENT4
         || ','
         || gcc.SEGMENT5
         || ','
         || gcc.SEGMENT6
            liability_account
  FROM   ap_suppliers aps,
         ap_supplier_sites_all apss,
         GL_CODE_COMBINATIONS gcc
 WHERE       2 = 2
         AND aps.VENDOR_ID = apss.VENDOR_ID
         AND apss.ACCTS_PAY_CODE_COMBINATION_ID = gcc.CODE_COMBINATION_ID
         AND aps.VENDOR_ID = 723
         AND CODE_COMBINATION_ID = 114582

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete