425: --2.1. Assessable Value of item category is picked up for the Customer Id, Null Site, UOM Code, Assessable value date
426:
427: --3. Assessable Value and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
428: for the Primary UOM defined in Price List.
429: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
430: as the product of the Assessable value.
431: --3.1. Assessable Value of item category and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
432: for the Primary UOM defined in Price List.
433: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
429: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
430: as the product of the Assessable value.
431: --3.1. Assessable Value of item category and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
432: for the Primary UOM defined in Price List.
433: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
434: as the product of the Assessable value.
435:
436: --4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
437: on a first come first serve basis.
438: --4.1. Assessable Value of item category is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
439: on a first come first serve basis.
440:
441: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
442: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
443: as the product of the Assessable value.
444: */
445: ----------------------------------------------------------------------------------------------------------
446:
581: CLOSE c_gst_ass_value_pri_uom_cust;
582:
583: IF v_primary_uom_code IS NOT NULL THEN
584:
585: inv_convert.inv_um_conversion(p_uom_code,
586: v_primary_uom_code,
587: p_inventory_item_id,
588: v_conversion_rate);
589:
587: p_inventory_item_id,
588: v_conversion_rate);
589:
590: IF nvl(v_conversion_rate, 0) <= 0 THEN
591: Inv_Convert.inv_um_conversion(p_uom_code,
592: v_primary_uom_code,
593: 0,
594: v_conversion_rate);
595: IF NVL(v_conversion_rate, 0) <= 0 THEN
615: INTO v_assessable_value, v_primary_uom_code;
616: CLOSE cust_ass_value_pri_uom_cur;
617:
618: IF v_primary_uom_code IS NOT NULL THEN
619: inv_convert.inv_um_conversion(p_uom_code,
620: v_primary_uom_code,
621: p_inventory_item_id,
622: v_conversion_rate);
623:
621: p_inventory_item_id,
622: v_conversion_rate);
623:
624: IF NVL(v_conversion_rate, 0) <= 0 THEN
625: Inv_Convert.inv_um_conversion(p_uom_code,
626: v_primary_uom_code,
627: 0,
628: v_conversion_rate);
629: IF NVL(v_conversion_rate, 0) <= 0 THEN
653: INTO v_assessable_value, v_other_uom_code;
654: CLOSE c_gst_ass_value_other_uom_cust;
655:
656: IF v_other_uom_code IS NOT NULL THEN
657: inv_convert.inv_um_conversion(p_uom_code,
658: v_other_uom_code,
659: p_inventory_item_id,
660: v_conversion_rate);
661:
660: v_conversion_rate);
661:
662: IF nvl(v_conversion_rate, 0) <= 0 THEN
663:
664: Inv_Convert.inv_um_conversion(p_uom_code,
665: v_primary_uom_code,
666: 0,
667: v_conversion_rate);
668:
689: INTO v_assessable_value, v_other_uom_code;
690: CLOSE cust_ass_value_other_uom_cur;
691:
692: IF v_other_uom_code IS NOT NULL THEN
693: inv_convert.inv_um_conversion(p_uom_code,
694: v_other_uom_code,
695: p_inventory_item_id,
696: v_conversion_rate);
697:
695: p_inventory_item_id,
696: v_conversion_rate);
697:
698: IF NVL(v_conversion_rate, 0) <= 0 THEN
699: Inv_Convert.inv_um_conversion(p_uom_code,
700: v_primary_uom_code,
701: 0,
702: v_conversion_rate);
703: IF NVL(v_conversion_rate, 0) <= 0 THEN
743: --2.1. Assessable Value of item category is picked up for the Vendor Id, Null Site, UOM Code, Assessable value date
744:
745: --3. Assessable Value and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
746: for the Primary UOM defined in Price List.
747: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
748: as the product of the Assessable value.
749: --3.1. Assessable Value of item category and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
750: for the Primary UOM defined in Price List.
751: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
747: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
748: as the product of the Assessable value.
749: --3.1. Assessable Value of item category and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
750: for the Primary UOM defined in Price List.
751: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
752: as the product of the Assessable value.
753:
754: --4. Assessable Value is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
755: on a first come first serve basis.
756: --4.1. Assessable Value of item category is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
757: on a first come first serve basis.
758:
759: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
760: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
761: as the product of the Assessable value.
762: */
763: ----------------------------------------------------------------------------------------------------------
764:
899: CLOSE c_gst_ass_value_pri_uom_vend;
900:
901: IF v_primary_uom_code IS NOT NULL THEN
902:
903: inv_convert.inv_um_conversion(p_uom_code,
904: v_primary_uom_code,
905: p_inventory_item_id,
906: v_conversion_rate);
907:
905: p_inventory_item_id,
906: v_conversion_rate);
907:
908: IF nvl(v_conversion_rate, 0) <= 0 THEN
909: Inv_Convert.inv_um_conversion(p_uom_code,
910: v_primary_uom_code,
911: 0,
912: v_conversion_rate);
913: IF NVL(v_conversion_rate, 0) <= 0 THEN
933: INTO v_assessable_value, v_primary_uom_code;
934: CLOSE vend_ass_value_pri_uom_cur;
935:
936: IF v_primary_uom_code IS NOT NULL THEN
937: inv_convert.inv_um_conversion(p_uom_code,
938: v_primary_uom_code,
939: p_inventory_item_id,
940: v_conversion_rate);
941:
939: p_inventory_item_id,
940: v_conversion_rate);
941:
942: IF NVL(v_conversion_rate, 0) <= 0 THEN
943: Inv_Convert.inv_um_conversion(p_uom_code,
944: v_primary_uom_code,
945: 0,
946: v_conversion_rate);
947: IF NVL(v_conversion_rate, 0) <= 0 THEN
972: INTO v_assessable_value, v_other_uom_code;
973: CLOSE c_gst_ass_value_other_uom_vend;
974:
975: IF v_other_uom_code IS NOT NULL THEN
976: inv_convert.inv_um_conversion(p_uom_code,
977: v_other_uom_code,
978: p_inventory_item_id,
979: v_conversion_rate);
980:
979: v_conversion_rate);
980:
981: IF nvl(v_conversion_rate, 0) <= 0 THEN
982:
983: Inv_Convert.inv_um_conversion(p_uom_code,
984: v_primary_uom_code,
985: 0,
986: v_conversion_rate);
987:
1008: INTO v_assessable_value, v_other_uom_code;
1009: CLOSE vend_ass_value_other_uom_cur;
1010:
1011: IF v_other_uom_code IS NOT NULL THEN
1012: inv_convert.inv_um_conversion(p_uom_code,
1013: v_other_uom_code,
1014: p_inventory_item_id,
1015: v_conversion_rate);
1016:
1014: p_inventory_item_id,
1015: v_conversion_rate);
1016:
1017: IF NVL(v_conversion_rate, 0) <= 0 THEN
1018: Inv_Convert.inv_um_conversion(p_uom_code,
1019: v_primary_uom_code,
1020: 0,
1021: v_conversion_rate);
1022: IF NVL(v_conversion_rate, 0) <= 0 THEN