[Home] [Help]
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);
333: BEGIN
334: l_inventory_id := p_inventory_id;
340: FETCH uom_c INTO l_edw_uom_code;
341: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
342: l_inventory_id := 0;
343: CLOSE uom_c;
344: -- no item specific uom - getting STANDARD uom
345: OPEN uom_c;
346: FETCH uom_c INTO l_edw_uom_code;
347: END IF;
348: IF uom_c%NOTFOUND THEN
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);
385: BEGIN
386: l_inventory_id := p_inventory_id;
392: FETCH uom_c INTO l_edw_uom_code;
393: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
394: l_inventory_id := 0;
395: CLOSE uom_c;
396: -- no item specific uom - getting STANDARD uom
397: OPEN uom_c;
398: FETCH uom_c INTO l_edw_uom_code;
399: END IF;
400: IF uom_c%NOTFOUND THEN
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)
437: OR (l_inventory_id <> 0
438: AND uom_conv_pk = l_inventory_id||'-'||p_uom_code||'-'||instance_code) );
439: BEGIN
440: l_inventory_id := p_inventory_id;
446: FETCH uom_c INTO l_edw_conv_rate;
447: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
448: l_inventory_id := 0;
449: CLOSE uom_c;
450: -- no item specific uom. Getting STANDARD uom
451: OPEN uom_c;
452: FETCH uom_c INTO l_edw_conv_rate;
453: END IF;
454: IF uom_c%NOTFOUND THEN
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 )
491: OR (l_inventory_id <> 0
492: AND uom_conv_pk = l_inventory_id||'-'||p_uom_code||'-'||p_instance_code) );
493: BEGIN
494: l_inventory_id := p_inventory_id;
500: FETCH uom_c INTO l_edw_conv_rate;
501: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
502: l_inventory_id := 0;
503: CLOSE uom_c;
504: -- no item specific uom. Getting STANDARD uom
505: OPEN uom_c;
506: FETCH uom_c INTO l_edw_conv_rate;
507: END IF;
508: IF uom_c%NOTFOUND THEN
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||'-'||
539: p_to_edw_base_uom_code||'-'||instance_code)
540: OR (l_inventory_id <> 0
541: AND uom_conv_pk = l_inventory_id||'-'|| p_from_edw_base_uom_code||'-'||
542: p_to_edw_base_uom_code||'-'||instance_code) );
547: FETCH uom_c INTO l_edw_conv_rate;
548: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
549: l_inventory_id := 0;
550: CLOSE uom_c;
551: -- no item specific uom. Getting STANDARD uom
552: OPEN uom_c;
553: FETCH uom_c INTO l_edw_conv_rate;
554: END IF;
555: IF uom_c%NOTFOUND THEN
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||'-'||
586: p_to_edw_base_uom_code||'-'||p_instance_code)
587: OR (l_inventory_id <> 0
588: AND uom_conv_pk = l_inventory_id||'-'|| p_from_edw_base_uom_code||'-'||
589: p_to_edw_base_uom_code||'-'||p_instance_code) );
594: FETCH uom_c INTO l_edw_conv_rate;
595: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
596: l_inventory_id := 0;
597: CLOSE uom_c;
598: -- no item specific uom. Getting STANDARD uom
599: OPEN uom_c;
600: FETCH uom_c INTO l_edw_conv_rate;
601: END IF;
602: IF uom_c%NOTFOUND THEN
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);
635: BEGIN
636: l_inventory_id := p_inventory_id;
642: FETCH uom_c INTO l_edw_uom_code;
643: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
644: l_inventory_id := 0;
645: CLOSE uom_c;
646: -- no item specific uom - getting STANDARD uom
647: OPEN uom_c;
648: FETCH uom_c INTO l_edw_uom_code;
649: END IF;
650: IF uom_c%NOTFOUND THEN
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);
686: BEGIN
687: l_inventory_id := p_inventory_id;
693: FETCH uom_c INTO l_edw_uom_code;
694: IF uom_c%NOTFOUND AND l_inventory_id <> 0 THEN
695: l_inventory_id := 0;
696: CLOSE uom_c;
697: -- no item specific uom - getting STANDARD uom
698: OPEN uom_c;
699: FETCH uom_c INTO l_edw_uom_code;
700: END IF;
701: IF uom_c%NOTFOUND THEN