APPS.OPI_EDW_UOM_CONV_F_SZ dependencies on STANDARD

Line 30: group by DECODE(MUCC.INVENTORY_ITEM_ID,0, 'STANDARD',

26: where
27: mucc.from_uom_code <> mucc.to_uom_code and
28: msik.inventory_item_id = MUCC.INVENTORY_ITEM_ID and
29: mucc.last_update_date between p_from_date and p_to_date
30: group by DECODE(MUCC.INVENTORY_ITEM_ID,0, 'STANDARD',
31: TO_CHAR(MUCC.INVENTORY_ITEM_ID)) ||'-' ||
32: MUCC.FROM_UOM_CODE||'-'||MUCC.TO_UOM_CODE||'-'||
33: ELI.INSTANCE_CODE , MUCC.INVENTORY_ITEM_ID,
34: MUCC.FROM_UOM_CODE, MUCC.TO_UOM_CODE,

Line 66: avg(nvl(vsize(DECODE(MUC.INVENTORY_ITEM_ID,0,'STANDARD',TO_CHAR(MUC.INVENTORY_ITEM_ID))||MUC.UOM_CODE||eli.instance_code), 0)) ,

62:
63: CURSOR c_1 IS
64: SELECT
65: -- x_UOM_CONV_PK NUMBER ;
66: avg(nvl(vsize(DECODE(MUC.INVENTORY_ITEM_ID,0,'STANDARD',TO_CHAR(MUC.INVENTORY_ITEM_ID))||MUC.UOM_CODE||eli.instance_code), 0)) ,
67: -- x_EDW_UOM_FK NUMBER ;
68: -- NULL,
69: -- x_EDW_BASE_UOM_FK NUMBER ;
70: -- NULL,