APPS.EDW_UTIL dependencies on EDW_LOCAL_INSTANCE

Line 328: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance

324: UOM_EDW_UOM_PK = p_uom_code
325: AND UOM_global_flag = 'Y';
326: CURSOR uom_c IS
327: SELECT edw_base_uom_fk
328: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance
329: WHERE ((l_inventory_id IS NULL OR l_inventory_id = 0)
330: AND uom_conv_pk = 'STANDARD'||'-'|| p_uom_code||'-'|| instance_code)
331: OR (l_inventory_id <> 0
332: AND uom_conv_pk = l_inventory_id||'-'||p_uom_code||'-'||instance_code);

Line 432: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance

428: UOM_EDW_UOM_PK = p_uom_code
429: AND UOM_global_flag = 'Y';
430: CURSOR uom_c IS
431: SELECT EDW_CONVERSION_RATE
432: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance
433: WHERE
434: CLASS_CONVERSION_FLAG = 'N' AND (
435: ((l_inventory_id IS NULL OR l_inventory_id = 0)
436: AND uom_conv_pk = 'STANDARD'||'-'|| p_uom_code||'-'|| instance_code)

Line 534: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance

530: l_edw_conv_rate NUMBER;
531:
532: CURSOR uom_c IS
533: SELECT EDW_CONVERSION_RATE
534: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance
535: WHERE
536: CLASS_CONVERSION_FLAG = 'Y' AND (
537: ((l_inventory_id IS NULL OR l_inventory_id = 0)
538: AND uom_conv_pk = 'STANDARD'||'-'|| p_from_edw_base_uom_code||'-'||

Line 630: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance

626: UOM_EDW_UOM_PK = p_uom_code
627: AND UOM_global_flag = 'Y';
628: CURSOR uom_c IS
629: SELECT edw_uom_fk
630: FROM OPI_EDW_LOCAL_UOM_CONV_F, edw_local_instance
631: WHERE ((l_inventory_id IS NULL OR l_inventory_id = 0)
632: AND uom_conv_pk = 'STANDARD'||'-'|| p_uom_code||'-'|| instance_code)
633: OR (l_inventory_id <> 0
634: AND uom_conv_pk = l_inventory_id||'-'||p_uom_code||'-'||instance_code);