DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 883: v_bol_uom_code mtl_units_of_measure.uom_code%TYPE :=NULL;

879: v_group_id NUMBER;
880:
881: /** MC BUG# 1554088 **/
882: /** create a variable and a cursor to select apps side uom code **/
883: v_bol_uom_code mtl_units_of_measure.uom_code%TYPE :=NULL;
884: v_recv_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
885: CURSOR UOM_CODE(v_um_code VARCHAR2 ) IS
886: SELECT b.UOM_CODE
887: FROM sy_uoms_mst a,mtl_units_of_measure b

Line 884: v_recv_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

880:
881: /** MC BUG# 1554088 **/
882: /** create a variable and a cursor to select apps side uom code **/
883: v_bol_uom_code mtl_units_of_measure.uom_code%TYPE :=NULL;
884: v_recv_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
885: CURSOR UOM_CODE(v_um_code VARCHAR2 ) IS
886: SELECT b.UOM_CODE
887: FROM sy_uoms_mst a,mtl_units_of_measure b
888: WHERE a.um_code = v_um_code

Line 887: FROM sy_uoms_mst a,mtl_units_of_measure b

883: v_bol_uom_code mtl_units_of_measure.uom_code%TYPE :=NULL;
884: v_recv_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
885: CURSOR UOM_CODE(v_um_code VARCHAR2 ) IS
886: SELECT b.UOM_CODE
887: FROM sy_uoms_mst a,mtl_units_of_measure b
888: WHERE a.um_code = v_um_code
889: AND a.unit_of_measure = b.unit_of_measure;
890:
891: CURSOR UNIT_OF_MEASURE(v_um_code VARCHAR2 ) IS