APPS.EDW_UTIL dependencies on OPI_EDW_LOCAL_UOM_CONV_F

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 380: FROM OPI_EDW_LOCAL_UOM_CONV_F

376: UOM_EDW_UOM_PK = p_uom_code
377: AND UOM_global_flag = 'Y';
378: CURSOR uom_c IS
379: SELECT edw_base_uom_fk
380: FROM OPI_EDW_LOCAL_UOM_CONV_F
381: WHERE ((l_inventory_id IS NULL OR l_inventory_id = 0)
382: AND uom_conv_pk = 'STANDARD'||'-'|| p_uom_code||'-'||p_instance_code)
383: OR (l_inventory_id <> 0
384: AND uom_conv_pk = l_inventory_id||'-'||p_uom_code||'-'||p_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 486: FROM OPI_EDW_LOCAL_UOM_CONV_F

482: UOM_EDW_UOM_PK = p_uom_code
483: AND UOM_global_flag = 'Y';
484: CURSOR uom_c IS
485: SELECT EDW_CONVERSION_RATE
486: FROM OPI_EDW_LOCAL_UOM_CONV_F
487: WHERE
488: CLASS_CONVERSION_FLAG = 'N' AND (
489: ((l_inventory_id IS NULL OR l_inventory_id = 0)
490: AND uom_conv_pk = 'STANDARD'||'-'|| p_uom_code||'-'|| p_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 581: FROM OPI_EDW_LOCAL_UOM_CONV_F

577: l_edw_conv_rate NUMBER;
578:
579: CURSOR uom_c IS
580: SELECT EDW_CONVERSION_RATE
581: FROM OPI_EDW_LOCAL_UOM_CONV_F
582: WHERE
583: CLASS_CONVERSION_FLAG = 'Y' AND (
584: ((l_inventory_id IS NULL OR l_inventory_id = 0)
585: 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);

Line 681: FROM OPI_EDW_LOCAL_UOM_CONV_F

677: UOM_EDW_UOM_PK = p_uom_code
678: AND UOM_global_flag = 'Y';
679: CURSOR uom_c IS
680: SELECT edw_uom_fk
681: FROM OPI_EDW_LOCAL_UOM_CONV_F
682: WHERE ((l_inventory_id IS NULL OR l_inventory_id = 0)
683: AND uom_conv_pk = 'STANDARD'||'-'|| p_uom_code||'-'|| p_instance_code)
684: OR (l_inventory_id <> 0
685: AND uom_conv_pk = l_inventory_id||'-'||p_uom_code||'-'||p_instance_code);