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]
