0 Replies Latest reply: Sep 3, 2013 5:55 AM by mustafa_yilmaz RSS

    FRM-40654 Record has been updated by another user.

    mustafa_yilmaz

      i execute query my detail block and When i change my data block's item value, i get this error message. /

      thats my view

       

      CREATE OR REPLACE VIEW XXTT_KONTRAT_LINES_V

      AS

      SELECT xyz.aciklama,

         xyz.bl_kontrat_tarihi,

                        xyz.bl_revize_tarihi, xyz.bl_tarihi_son, xyz.customer_id,

                        xyz.fatura_kes_tarihi, xyz.gumruk_durumu, xyz.kontrat_id,

                        xyz.kontrat_line_id, xyz.mfg_seri_no, xyz.options,

                        xyz.po_line_id, xyz.satis_birim_fiyat,

                        xyz.tahmini_v_tarihi, xyz.teslim_sekli, xyz.tt_tarihi,

                        xyz.kontrat_number, xyz.inventory_item_id,

                        xyz.musteri,

                         xyz.tedarikci,

                        xyz.ss_no, xyz.ss_satir_no,

                        xyz.kalem_kodu, xyz.kalem_tanimi,

                        xyz.makina_grubu, xyz.gauge,

                        xyz.ikinci_el, xyz.rezervasyon,

                        xyz.ss_para_birimi,

                        xyz.alis_fiyati,

                        xyz.odeme, xyz.dosya_tutar,

                        xyz.kesin_v_tarihi, xyz.kontrat_tarihi,

                        xyz.protokol_flag, xyz.oe_line_id, xyz.line_location_id,

                        xyz.creation_date, xyz.last_update_date,

                        xyz.last_update_login, xyz.last_updated_by,

                        xyz.created_by, xyz.po_header_id, xyz.vendor_id,

                        xyz.durum,

                        xyz.dosya_para_birimi,

                        xyz.dosya_no,

                        xyz.tip

           FROM (

           SELECT klin.aciklama, klin.bl_kontrat_tarihi,

                        klin.bl_revize_tarihi, klin.bl_tarihi_son, klin.customer_id,

                        klin.fatura_kes_tarihi, klin.gumruk_durumu, klin.kontrat_id,

                        klin.kontrat_line_id, klin.mfg_seri_no, klin.options,

                        klin.po_line_id, klin.satis_birim_fiyat,

                        klin.tahmini_v_tarihi, klin.teslim_sekli, klin.tt_tarihi,

                        klin.kontrat_number, klin.inventory_item_id,

                        hp.party_name musteri, pp.vendor_name tedarikci,

                        po.segment1 ss_no, pl.line_num ss_satir_no,

                        mtl.segment1 kalem_kodu, mtl.description kalem_tanimi,

                        mc.segment3 makina_grubu, mde.element_value gauge,

                        klin.ikinci_el, klin.rezervasyon,

                        po.currency_code ss_para_birimi,

                        pl.unit_price * pl.quantity alis_fiyati,

                        po.attribute1 odeme, TO_NUMBER (NULL) dosya_tutar,

                        TO_DATE (NULL) kesin_v_tarihi, klin.kontrat_tarihi,

                        klin.protokol_flag, klin.oe_line_id, pll.line_location_id,

                        klin.creation_date, klin.last_update_date,

                        klin.last_update_login, klin.last_updated_by,

                        klin.created_by, pl.po_header_id, klin.vendor_id,

                        klin.durum,

                        (SELECT vv.dovizcinsi

                           FROM xxtt_kontrat_dosya_v vv

                          WHERE vv.sip_line_location_id =

                                             pll.line_location_id

                            AND klin.mfg_seri_no = vv.serino) dosya_para_birimi,

                        (SELECT vv.referans

                           FROM xxtt_kontrat_dosya_v vv

                          WHERE vv.sip_line_location_id =

                                                      pll.line_location_id

                            AND klin.mfg_seri_no = vv.serino) dosya_no,

                        klin.tip

                   FROM xxtt.xxtt_kontrat_lines klin,

                        po_headers_all po,

                        po_lines_all pl,

                        mtl_system_items_b mtl,

                        mtl_item_categories mic,  --view

                        mtl_categories mc,

                        po_line_locations_all pll,

                        xxvb_beyannamemallar bey,

                        po_vendors pp,

                        mtl_descr_element_values mde,

                        xxvb_beyannameler_v xbv,  --view

                        hz_cust_accounts hca,

                        hz_parties hp

                  WHERE klin.po_header_id = po.po_header_id(+)

                    AND klin.po_line_id = pl.po_line_id(+)

                    AND pl.item_id = mtl.inventory_item_id(+)

                    AND mtl.organization_id(+) = 442

                    AND mtl.inventory_item_id = mic.inventory_item_id(+)

                    AND mic.organization_id(+) = fnd_profile.VALUE ('ORG_ID')

                    AND mic.category_set_id(+) = 1

                    AND mic.category_id = mc.category_id(+)

                    AND klin.po_line_id = pll.po_line_id(+)

                    AND NVL (pll.cancel_flag, 'N') = 'N'

                    AND klin.po_line_id = bey.sip_line_id(+)

                    AND klin.line_location_id = bey.sip_line_location_id(+)

                    AND klin.vendor_id = pp.vendor_id(+)

                    AND mtl.inventory_item_id = mde.inventory_item_id(+)

                    AND mde.element_name(+) = 'GAUGE'

                    AND bey.beyanname = xbv.beyanname(+)

                    AND klin.customer_id = hca.cust_account_id(+)

                    AND hca.party_id = hp.party_id(+)

                    ) xyz

      /