DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOGS_F_C dependencies on EDW_UTIL

Line 507: EDW_UTIL.Get_Edw_Base_Uom(

503: '' FROM_CURRENCY,
504: '' TO_CURRENCY,
505: '' RATE_TYPE,
506: l.order_quantity_uom FROM_UOM_CODE,
507: EDW_UTIL.Get_Edw_Base_Uom(
508: l.order_quantity_uom,
509: l.inventory_item_id) TO_UOM_CODE,
510: l.inventory_item_id INVENTORY_ITEM_ID,
511: nvl(mtl.segment1,'Item number unavailable')

Line 527: AND EDW_UTIL.Get_Uom_Conv_Rate(l.order_quantity_uom,l.inventory_item_id) IS NULL;

523: AND h.booked_flag = 'Y'
524: AND h.booked_date IS NOT NULL
525: AND l.ship_from_org_id = mtl.organization_id
526: AND l.inventory_item_id = mtl.inventory_item_id
527: AND EDW_UTIL.Get_Uom_Conv_Rate(l.order_quantity_uom,l.inventory_item_id) IS NULL;
528:
529: p_count := p_count + sql%rowcount;
530:
531: RETURN(p_count);