APPS.INVPVDR5 dependencies on MTL_UNITS_OF_MEASURE

Line 820: from MTL_UNITS_OF_MEASURE

816: temp_uom_valid := TRUE; /* Added bug 14104913 */
817: IF cr.PRIMARY_UNIT_OF_MEASURE IS NOT NULL THEN
818: BEGIN
819: select UOM_CODE into temp_uom_code
820: from MTL_UNITS_OF_MEASURE
821: where UNIT_OF_MEASURE = cr.PRIMARY_UNIT_OF_MEASURE /*Bug 5192495*/
822: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
823:
824: if cr.PRIMARY_UOM_CODE is null then

Line 877: from MTL_UNITS_OF_MEASURE

873: */
874: ELSIF cr.PRIMARY_UOM_CODE is not null THEN
875: BEGIN
876: select UNIT_OF_MEASURE into temp_u_o_m /*Bug 5192495*/
877: from MTL_UNITS_OF_MEASURE
878: where UOM_CODE = cr.PRIMARY_UOM_CODE
879: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
880:
881: cr.PRIMARY_UNIT_OF_MEASURE := temp_u_o_m;

Line 921: from MTL_UNITS_OF_MEASURE

917: -- validate foreign keys
918: if cr.PRIMARY_UOM_CODE is not null AND temp_uom_valid THEN --* Modified for Bug 4366615
919: begin
920: select UOM_CLASS into temp_uom_class
921: from MTL_UNITS_OF_MEASURE
922: where UOM_CODE = cr.PRIMARY_UOM_CODE; --* Modified for Bug 4366615
923:
924: /*Fix for bug 4564472 -Organizaition_id filter was added in the where clause of the below query
925: to improve its performance. */

Line 937: from MTL_UNITS_OF_MEASURE MUOM

933: where ORGANIZATION_ID = MASTER_ORGANIZATION_ID )
934: and rownum = 1
935: and not exists
936: (select UNIT_OF_MEASURE
937: from MTL_UNITS_OF_MEASURE MUOM
938: where UOM_CLASS = temp_uom_class
939: and msi.PRIMARY_UOM_CODE
940: = MUOM.UOM_CODE);
941:

Line 988: from MTL_UNITS_OF_MEASURE

984: /* if (cr.ALLOWED_UNITS_LOOKUP_CODE = 1) and */
985: if cr.PRIMARY_UOM_CODE is not null AND temp_uom_valid THEN --* Modified for Bug 4366615
986: select BASE_UOM_FLAG
987: into temp_base_uom_flag
988: from MTL_UNITS_OF_MEASURE
989: where UOM_CODE = cr.PRIMARY_UOM_CODE; --* Modified for Bug 4366615
990:
991: if (temp_base_uom_flag <> 'Y') then
992: begin

Line 1087: from MTL_UNITS_OF_MEASURE

1083: -- validate foreign keys
1084: if cr.VOLUME_UOM_CODE is not null then
1085: begin
1086: select 'x' into temp
1087: from MTL_UNITS_OF_MEASURE
1088: where UOM_CODE = cr.VOLUME_UOM_CODE;
1089: exception
1090: when NO_DATA_FOUND then
1091: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1117: from MTL_UNITS_OF_MEASURE

1113: /* R12 C Unit Weight can now be updated for Pending items. Moving the below set of validations to INVPVHDR
1114: if cr.WEIGHT_UOM_CODE is not null then
1115: begin
1116: select 'x' into temp
1117: from MTL_UNITS_OF_MEASURE
1118: where UOM_CODE = cr.WEIGHT_UOM_CODE;
1119: exception
1120: when NO_DATA_FOUND then
1121: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1896: from MTL_UNITS_OF_MEASURE

1892: end if;
1893: if cr.SECONDARY_UOM_CODE is not null THEN
1894: BEGIN
1895: select UNIT_OF_MEASURE into temp_u_o_m
1896: from MTL_UNITS_OF_MEASURE
1897: where UOM_CODE = cr.SECONDARY_UOM_CODE
1898: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
1899: if(cr.SECONDARY_UOM_CODE = cr.PRIMARY_UOM_CODE ) then
1900: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 2097: from MTL_UNITS_OF_MEASURE

2093: if cr.SECONDARY_UOM_CODE is not null THEN
2094: begin
2095: select UOM_CLASS
2096: into temp_uom_class
2097: from MTL_UNITS_OF_MEASURE
2098: where UOM_CODE = cr.SECONDARY_UOM_CODE;
2099:
2100: select 'x' into temp
2101: from MTL_SYSTEM_ITEMS msi

Line 2105: from MTL_UNITS_OF_MEASURE MUOM

2101: from MTL_SYSTEM_ITEMS msi
2102: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
2103: and secondary_uom_code IS NOT NULL
2104: and not exists (select UNIT_OF_MEASURE
2105: from MTL_UNITS_OF_MEASURE MUOM
2106: where UOM_CLASS = temp_uom_class
2107: and MUOM.UOM_CODE = msi.SECONDARY_UOM_CODE)
2108: and rownum = 1;
2109:

Line 2171: from MTL_UNITS_OF_MEASURE

2167: -- validate foreign keys
2168: if cr.DIMENSION_UOM_CODE is not null then
2169: begin
2170: select 'x' into temp
2171: from MTL_UNITS_OF_MEASURE
2172: where UOM_CODE = cr.DIMENSION_UOM_CODE;
2173: exception
2174: when NO_DATA_FOUND then
2175: dumm_status := INVPUOPI.mtl_log_interface_err(