DBA Data[Home] [Help]

APPS.ISC_EDW_BOOKINGS_F_C dependencies on EDW_UTIL

Line 661: EDW_UTIL.Get_Edw_Base_Uom(

657: '' FROM_CURRENCY,
658: '' TO_CURRENCY,
659: '' RATE_TYPE,
660: l.order_quantity_uom FROM_UOM_CODE,
661: EDW_UTIL.Get_Edw_Base_Uom(
662: l.order_quantity_uom,
663: l.inventory_item_id) TO_UOM_CODE,
664: l.inventory_item_id INVENTORY_ITEM_ID,
665: nvl(mtl.segment1,'Item number unavailable')

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

676: AND h.booked_flag = 'Y'
677: AND h.booked_date IS NOT NULL
678: AND l.ship_from_org_id = mtl.organization_id
679: AND l.inventory_item_id = mtl.inventory_item_id
680: AND EDW_UTIL.Get_Uom_Conv_Rate(l.order_quantity_uom,l.inventory_item_id) IS NULL;
681:
682: p_count := p_count + sql%rowcount;
683:
684: RETURN(p_count);