APPS.RCV_CHARGES_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 5: g_base_weight_uom mtl_units_of_measure.unit_of_measure%TYPE;

1: PACKAGE BODY RCV_CHARGES_GRP AS
2: /* $Header: RCVGFSCB.pls 120.11 2006/02/21 16:55:54 pjiang noship $*/
3:
4: -- package globals
5: g_base_weight_uom mtl_units_of_measure.unit_of_measure%TYPE;
6: g_base_volume_uom mtl_units_of_measure.unit_of_measure%TYPE;
7: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
8:
9: UNKNOWN_ALLOCATION_METHOD EXCEPTION;

Line 6: g_base_volume_uom mtl_units_of_measure.unit_of_measure%TYPE;

2: /* $Header: RCVGFSCB.pls 120.11 2006/02/21 16:55:54 pjiang noship $*/
3:
4: -- package globals
5: g_base_weight_uom mtl_units_of_measure.unit_of_measure%TYPE;
6: g_base_volume_uom mtl_units_of_measure.unit_of_measure%TYPE;
7: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
8:
9: UNKNOWN_ALLOCATION_METHOD EXCEPTION;
10:

Line 18: FROM mtl_units_of_measure_tl

14: BEGIN
15: IF g_base_weight_uom IS NULL THEN
16: SELECT unit_of_measure
17: INTO g_base_weight_uom
18: FROM mtl_units_of_measure_tl
19: WHERE base_uom_flag = 'Y'
20: AND uom_class = 'Weight'
21: AND ROWNUM < 2;
22: END IF;

Line 34: FROM mtl_units_of_measure_tl

30: BEGIN
31: IF g_base_volume_uom IS NULL THEN
32: SELECT unit_of_measure
33: INTO g_base_volume_uom
34: FROM mtl_units_of_measure_tl
35: WHERE base_uom_flag = 'Y'
36: AND uom_class = 'Volume'
37: AND ROWNUM < 2;
38: END IF;

Line 504: TYPE uom_table_type IS TABLE OF mtl_units_of_measure.unit_of_measure%TYPE;

500: PROCEDURE Allocate_Charge_By_Volume
501: ( p_charge IN po_rcv_charges%ROWTYPE
502: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
503: ) IS
504: TYPE uom_table_type IS TABLE OF mtl_units_of_measure.unit_of_measure%TYPE;
505: TYPE uom_class_table_type IS TABLE OF mtl_uom_classes.uom_class%TYPE;
506:
507: -- tables of values
508: l_shipment_line_ids dbms_utility.number_array;

Line 550: , mtl_units_of_measure muom_rsl

546: , l_unit_volumes
547: , l_volume_uoms
548: FROM rcv_shipment_lines rsl
549: , mtl_system_items msi
550: , mtl_units_of_measure muom_rsl
551: , mtl_units_of_measure muom_unit
552: WHERE rsl.shipment_header_id = p_charge.shipment_header_id
553: AND msi.inventory_item_id (+) = rsl.item_id
554: AND msi.organization_id (+) = rsl.to_organization_id

Line 551: , mtl_units_of_measure muom_unit

547: , l_volume_uoms
548: FROM rcv_shipment_lines rsl
549: , mtl_system_items msi
550: , mtl_units_of_measure muom_rsl
551: , mtl_units_of_measure muom_unit
552: WHERE rsl.shipment_header_id = p_charge.shipment_header_id
553: AND msi.inventory_item_id (+) = rsl.item_id
554: AND msi.organization_id (+) = rsl.to_organization_id
555: AND muom_unit.uom_code (+) = msi.volume_uom_code

Line 618: TYPE uom_table_type IS TABLE OF mtl_units_of_measure.unit_of_measure%TYPE;

614: PROCEDURE Allocate_Charge_By_Weight
615: ( p_charge IN po_rcv_charges%ROWTYPE
616: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
617: ) IS
618: TYPE uom_table_type IS TABLE OF mtl_units_of_measure.unit_of_measure%TYPE;
619: TYPE uom_class_table_type IS TABLE OF mtl_uom_classes.uom_class%TYPE;
620:
621: -- tables of values
622: l_shipment_line_ids dbms_utility.number_array;

Line 664: , mtl_units_of_measure muom_rsl

660: , l_unit_weights
661: , l_weight_uoms
662: FROM rcv_shipment_lines rsl
663: , mtl_system_items msi
664: , mtl_units_of_measure muom_rsl
665: , mtl_units_of_measure muom_unit
666: WHERE rsl.shipment_header_id = p_charge.shipment_header_id
667: AND msi.inventory_item_id (+) = rsl.item_id
668: AND msi.organization_id (+) = rsl.to_organization_id

Line 665: , mtl_units_of_measure muom_unit

661: , l_weight_uoms
662: FROM rcv_shipment_lines rsl
663: , mtl_system_items msi
664: , mtl_units_of_measure muom_rsl
665: , mtl_units_of_measure muom_unit
666: WHERE rsl.shipment_header_id = p_charge.shipment_header_id
667: AND msi.inventory_item_id (+) = rsl.item_id
668: AND msi.organization_id (+) = rsl.to_organization_id
669: AND muom_unit.uom_code (+) = msi.weight_uom_code