Oracle Application Framework (OAF) View Object Extension

May 12, 2014 · by altunkan · in Oracle Application Framework (OAF)

Merhaba, OAF geliştirmeleri yaparken bazı durumlarda standart View Object nesnelerinin SQL sorgularındaki alanlar yetmeyebiliyor. Bu tarz durumlarda standard View Object nesnesini EXTEND ederek onun özelliklerini kapsayan ve ek alanlar koyabildiğimiz yeni bir CUSTOM View Object nesnesi oluşturuyoruz. Yeni oluşan bu…

Oracle APPS Profil Sorgusu

May 12, 2014 · by altunkan · in E-Business Suite

Merhaba, Profil değerlerini bulmak için aşağıdaki sorguyu kullanabilirsiniz.


SELECT fpo.profile_option_name profil_adi,
       fpl.user_profile_option_name profil_kullanici_adi,
       DECODE (fpv.level_id,
               10001, 'Site',
               10002, 'Uygulama Yazılımı',
               10003, 'Sorumluluk',
               10004, 'Kullanıcı')
          profil_seviyesi,
       DECODE (fpv.level_id,
               10001, 'Site',
               10002, fa.application_short_name,
               10003, frt.responsibility_name,
               10004, fu.user_name)
          seviye_degeri,
       profile_option_value profil_degeri
  FROM fnd_profile_options fpo,
       fnd_profile_options_tl fpl,
       fnd_profile_option_values fpv,
       fnd_responsibility_tl frt,
       fnd_application fa,
       fnd_user fu
 WHERE     fpo.profile_option_name = fpl.profile_option_name
       AND fpo.profile_option_id = fpv.profile_option_id
       AND fpv.level_value = fu.user_id(+)
       AND fpv.level_value = frt.responsibility_id(+)
       AND fpv.level_value = fa.application_id(+)
       AND fpl.user_profile_option_name =
              'Self Servis Tanımını Kişiselleştir'

SELECT fpo.profile_option_name profil_adi,

fpl.user_profile_option_name profil_kullanici_adi,

DECODE (fpv.level_id,

10001, 'Site',

10002, 'Uygulama Yazılımı',

10003, 'Sorumluluk',

10004, 'Kullanıcı')

profil_seviyesi,

DECODE (fpv.level_id,

10001, 'Site',

10002, fa.application_short_name,

10003, frt.responsibility_name,

10004, fu.user_name)

seviye_degeri,

profile_option_value profil_degeri

FROM fnd_profile_options fpo,

fnd_profile_options_tl fpl,

fnd_profile_option_values fpv,

fnd_responsibility_tl frt,

fnd_application fa,

fnd_user fu

WHERE fpo.profile_option_name = fpl.profile_option_name

AND fpo.profile_option_id = fpv.profile_option_id

AND fpv.level_value = fu.user_id(+)

AND fpv.level_value = frt.responsibility_id(+)

AND fpv.level_value = fa.application_id(+)

AND fpl.user_profile_option_name =

'Self Servis Tanımını Kişiselleştir'

R12 TEDARİKÇİ BANKA HESAP SORGULARI

April 25, 2014 · by altunkan · in E-Business Suite

Merhaba, Aşağıdaki iki sorgu tedarikçinin kendisine ve işletme birimlerine ait banka hesaplarını bulmak için kullanabilirsiniz. Tedarikçi Seviyesi İçin


SELECT APS.VENDOR_NAME, IEB.BANK_aCCOUNT_NUM, IEB.IBAN
  FROM AP_SUPPLIERS APS,
       HZ_PARTIES HP,
       IBY_EXTERNAL_PAYEES_ALL IEP,
       IBY_PMT_INSTR_USES_ALL USES,
       IBY_EXT_bANK_ACCOUNTS IEB
 WHERE     HP.PARTY_ID = APS.PARTY_ID
       AND IEP.PAYEE_PARTY_ID = HP.PARTY_ID
       AND USES.EXT_PMT_PARTY_ID = IEP.EXT_PAYEE_ID
       AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID

SELECT APS.VENDOR_NAME, IEB.BANK_aCCOUNT_NUM, IEB.IBAN

FROM AP_SUPPLIERS APS,

HZ_PARTIES HP,

IBY_EXTERNAL_PAYEES_ALL IEP,

IBY_PMT_INSTR_USES_ALL USES,

IBY_EXT_bANK_ACCOUNTS IEB

WHERE HP.PARTY_ID = APS.PARTY_ID

AND IEP.PAYEE_PARTY_ID = HP.PARTY_ID

AND USES.EXT_PMT_PARTY_ID = IEP.EXT_PAYEE_ID

AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID

Tedarikçi İşletme Birimi Seviyesi İçin


SELECT APS.VENDOR_NAME,
 ASS.VENDOR_SITE_CODE,
 IEB.BANK_aCCOUNT_NUM,
 IEB.IBAN
 FROM AP_SUPPLIERS APS,
 AP_SUPPLIER_SITES_ALL ASS,
 HZ_PARTIES HP,
 IBY_EXTERNAL_PAYEES_ALL IEP,
 IBY_PMT_INSTR_USES_ALL USES,
 HZ_PARTY_SITES HPS,
 IBY_EXT_bANK_ACCOUNTS IEB
 WHERE APS.VENDOR_ID = ASS.VENDOR_ID
 AND HP.PARTY_ID = APS.PARTY_ID
 AND IEP.PAYEE_PARTY_ID = HP.PARTY_ID
 AND USES.EXT_PMT_PARTY_ID = IEP.EXT_PAYEE_ID
 AND HP.PARTY_ID = HPS.PARTY_ID
 AND IEP.PARTY_SITE_ID = HPS.PARTY_SITE_ID
 AND IEP.SUPPLIER_SITE_ID = ASS.VENDOR_SITE_ID
 AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID

SELECT APS.VENDOR_NAME,

ASS.VENDOR_SITE_CODE,

IEB.BANK_aCCOUNT_NUM,

IEB.IBAN

FROM AP_SUPPLIERS APS,

AP_SUPPLIER_SITES_ALL ASS,

HZ_PARTIES HP,

IBY_EXTERNAL_PAYEES_ALL IEP,

IBY_PMT_INSTR_USES_ALL USES,

HZ_PARTY_SITES HPS,

IBY_EXT_bANK_ACCOUNTS IEB

WHERE APS.VENDOR_ID = ASS.VENDOR_ID

AND HP.PARTY_ID = APS.PARTY_ID

AND IEP.PAYEE_PARTY_ID = HP.PARTY_ID

AND USES.EXT_PMT_PARTY_ID = IEP.EXT_PAYEE_ID

AND HP.PARTY_ID = HPS.PARTY_ID

AND IEP.PARTY_SITE_ID = HPS.PARTY_SITE_ID

AND IEP.SUPPLIER_SITE_ID = ASS.VENDOR_SITE_ID

AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID

ORACLE E-BUSINESS SUITE KUR SİLME PROGRAMI

April 23, 2014 · by altunkan · in E-Business Suite

Merhaba, Kurları ekrandan silmek yerine aşağıdaki kod parçası kullanılabilir. Interface tablosu mode_flag alanı ‘D’ olacak şekilde doldurulur. Bu işlem bittikten sonra GLDRICCP (Günlük kurlar içe aktarma) eş zamanlı programı çalıştırılmalıdır.


DECLARE
   CURSOR csr
   IS
      SELECT gdc.user_conversion_type, gr.*
        FROM gl_daily_rates gr, gl_daily_conversion_types gdc
       WHERE     conversion_date = TRUNC (SYSDATE - 1)
             AND from_currency <> 'TRY'
             AND gr.conversion_type = gdc.conversion_type;
BEGIN
   FOR sel IN csr
   LOOP
      INSERT INTO gl.gl_daily_rates_interface (from_currency,
                                               to_currency,
                                               from_conversion_date,
                                               to_conversion_date,
                                               user_conversion_type,
                                               conversion_rate,
                                               mode_flag)
           VALUES (sel.from_currency,
                   'TRY',
                   sel.conversion_date,
                   sel.conversion_date,
                   sel.user_conversion_type,
                   sel.conversion_rate,
                   'D');
   END LOOP;
END;

DECLARE

CURSOR csr

SELECT gdc.user_conversion_type, gr.*

FROM gl_daily_rates gr, gl_daily_conversion_types gdc

WHERE conversion_date = TRUNC (SYSDATE - 1)

AND from_currency <> 'TRY'

AND gr.conversion_type = gdc.conversion_type;

BEGIN

FOR sel IN csr

LOOP

INSERT INTO gl.gl_daily_rates_interface (from_currency,

to_currency,

from_conversion_date,

to_conversion_date,

user_conversion_type,

conversion_rate,

mode_flag)

VALUES (sel.from_currency,

'TRY',

sel.conversion_date,

sel.user_conversion_type,

sel.conversion_rate,

'D');

END LOOP;

END;

ORACLE E-BUSINESS SUITE DFF NASIL BULUNUR

April 23, 2014 · by altunkan · in E-Business Suite

Merhaba, DFF (Esken Alan) Oracle E-Business Suite için en gerekli özelliklerden biridir. Çoğu zaman DFF kurulumu yapmak istediğimiz ekranın DFF adını bulmakta zorlanıyoruz. Bunun için ilgili ekranın tablosu belirlendikten sonra aşağıdaki SQL cümlecikleri kullanılabilinir. APPLICATION_TABLE_NAME alanına esken alanını aradığınız…

Oracle Application Framework (OAF) View Object Extension

Oracle APPS Profil Sorgusu

R12 TEDARİKÇİ BANKA HESAP SORGULARI

ORACLE E-BUSINESS SUITE KUR SİLME PROGRAMI

ORACLE E-BUSINESS SUITE DFF NASIL BULUNUR

Visitors

Subscribe to Blog via Email