wew saya belum coba script view agan euy..soalnya saya tidak punya struktur tabel. Analisis saya memang hal itu perlu waktu yang banyak. Coba diakali dengan user profile bagian waktu session diperpanjang untuk user anda login. CMIIW...
On 2/15/10, kurniawan . <[email protected]> wrote: > Berikut saya tampilkan script viewnya : mohon di review gan : > ------------------------------------------------------------------------------------------ > > CREATE OR REPLACE VIEW XX20MBOM_I.XX00MBM_V_DL_UN_SUPPLY_TYPE > (PLACE_CODE,ORGANIZATION_CODE,PARENT_ITEM_CODE,COMPONENT_ITEM_CODE, > ITEM_TYPE,ITEM_TYPE_NAME,SUPPLY_TYPE,SUPPLY_TYPE_NAME) > AS > SELECT supply_data.place_code,supply_data.organization_code, > supply_data.parent_item_code,supply_data.component_item_code, > supply_data.item_type,supply_data.item_type_name, > supply_data.supply_type,supply_data.supply_type_name > FROM > ( > SELECT bom.place_code,bom.organization_code,bom.parent_item_code, > bom.component_item_code,item.item_type, > itn.item_type_name,bom.supply_type,name.code_name supply_type_name > FROM > XX00MBM_V_NEWEST_MBOM_BOM bom, > XX00MBM_V_NEWEST_MBOM_ITEM item, > (SELECT code_master_code,code_name item_type_name > FROM XX00MBM_CM_CODE_MASTER > WHERE group_id='10027')itn, > (SELECT code_master_code,code_name > FROM XX00MBM_CM_CODE_MASTER > WHERE group_id='10028')name > WHERE > bom.place_code=item.place_code and > bom.organization_code=item.organization_code and > bom.component_item_code=item.item_code and > itn.code_master_code=item.item_type and > name.code_master_code=bom.supply_type and > bom.delete_flag=0 > ) supply_data > WHERE NOT EXISTS > (SELECT 'x' FROM xx00mbm_cm_itemtype_supplytype it > WHERE supply_data.place_code=it.place_code > AND supply_data.organization_code=it.organization_code > AND supply_data.item_type=it.item_type > AND supply_data.supply_type=it.supply_type) > / > > > On Sat, Feb 13, 2010 at 4:20 PM, dedi humaedi <[email protected]> wrote: > >> minta script ttg view anda donk >> >> 2010/2/12 kurniawan . <[email protected]> >> >> > >> > >> > Dear ALL, >> > >> > Saya selalu dapat masalah saat melakukan "View" data dalam Oracle EBS, >> > The issue was "Program takes long time for searching, then the session >> > is >> > timed out". >> > >> > Asumsinya adalah bahwa view bukan cara yang simple, atau memang ada yang >> > bermasalah dengan object lainnya dalam Oracle. Mohon kira - kira >> > kawan-kawan ada yg bisa memberikan pencerahan. How's the "VIEW" do the >> > logic >> > exactly... ????? >> > >> > thanks >> > Kurniawan gantinx >> > >> > [Non-text portions of this message have been removed] >> > >> > >> > >> >> >> >> -- >> Regards >> Dedi Caesar Humaedi >> >> >> [Non-text portions of this message have been removed] >> >> >> >> ------------------------------------ >> >> -- >> -----------I.N.D.O - O.R.A.C.L.E--------------- >> Keluar: [email protected] >> Website: http://indooracle.wordpress.com >> http://www.facebook.com/group.php?gid=51973053515 >> ----------------------------------------------- >> >> Bergabung dengan Indonesia Thin Client User Groups, >> Terminal Server, Citrix, New Moon Caneveral, di: >> http://indo-thin.blogspot.comYahoo! Groups Links >> >> >> >> > > > [Non-text portions of this message have been removed] > > -- Regards Dedi Caesar Humaedi
