APPS.INVPVDR5 dependencies on MTL_UNITS_OF_MEASURE

Line 800: from MTL_UNITS_OF_MEASURE

796:
797: IF cr.PRIMARY_UNIT_OF_MEASURE IS NOT NULL THEN
798: BEGIN
799: select UOM_CODE into temp_uom_code
800: from MTL_UNITS_OF_MEASURE
801: where UNIT_OF_MEASURE = cr.PRIMARY_UNIT_OF_MEASURE /*Bug 5192495*/
802: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
803:
804: if cr.PRIMARY_UOM_CODE is null then

Line 855: from MTL_UNITS_OF_MEASURE

851: */
852: ELSIF cr.PRIMARY_UOM_CODE is not null THEN
853: BEGIN
854: select UNIT_OF_MEASURE into temp_u_o_m /*Bug 5192495*/
855: from MTL_UNITS_OF_MEASURE
856: where UOM_CODE = cr.PRIMARY_UOM_CODE
857: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
858:
859: cr.PRIMARY_UNIT_OF_MEASURE := temp_u_o_m;

Line 895: from MTL_UNITS_OF_MEASURE

891: -- validate foreign keys
892: if cr.PRIMARY_UOM_CODE is not null THEN --* Modified for Bug 4366615
893: begin
894: select UOM_CLASS into temp_uom_class
895: from MTL_UNITS_OF_MEASURE
896: where UOM_CODE = cr.PRIMARY_UOM_CODE; --* Modified for Bug 4366615
897:
898: /*Fix for bug 4564472 -Organizaition_id filter was added in the where clause of the below query
899: to improve its performance. */

Line 911: from MTL_UNITS_OF_MEASURE MUOM

907: where ORGANIZATION_ID = MASTER_ORGANIZATION_ID )
908: and rownum = 1
909: and not exists
910: (select UNIT_OF_MEASURE
911: from MTL_UNITS_OF_MEASURE MUOM
912: where UOM_CLASS = temp_uom_class
913: and msi.PRIMARY_UOM_CODE
914: = MUOM.UOM_CODE);
915:

Line 959: from MTL_UNITS_OF_MEASURE

955: /* if (cr.ALLOWED_UNITS_LOOKUP_CODE = 1) and */
956: if cr.PRIMARY_UOM_CODE is not null THEN --* Modified for Bug 4366615
957: select BASE_UOM_FLAG
958: into temp_base_uom_flag
959: from MTL_UNITS_OF_MEASURE
960: where UOM_CODE = cr.PRIMARY_UOM_CODE; --* Modified for Bug 4366615
961:
962: if (temp_base_uom_flag <> 'Y') then
963: begin

Line 1058: from MTL_UNITS_OF_MEASURE

1054: -- validate foreign keys
1055: if cr.VOLUME_UOM_CODE is not null then
1056: begin
1057: select 'x' into temp
1058: from MTL_UNITS_OF_MEASURE
1059: where UOM_CODE = cr.VOLUME_UOM_CODE;
1060: exception
1061: when NO_DATA_FOUND then
1062: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1088: from MTL_UNITS_OF_MEASURE

1084: /* R12 C Unit Weight can now be updated for Pending items. Moving the below set of validations to INVPVHDR
1085: if cr.WEIGHT_UOM_CODE is not null then
1086: begin
1087: select 'x' into temp
1088: from MTL_UNITS_OF_MEASURE
1089: where UOM_CODE = cr.WEIGHT_UOM_CODE;
1090: exception
1091: when NO_DATA_FOUND then
1092: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1867: from MTL_UNITS_OF_MEASURE

1863: end if;
1864: if cr.SECONDARY_UOM_CODE is not null THEN
1865: BEGIN
1866: select UNIT_OF_MEASURE into temp_u_o_m
1867: from MTL_UNITS_OF_MEASURE
1868: where UOM_CODE = cr.SECONDARY_UOM_CODE
1869: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
1870: if(cr.SECONDARY_UOM_CODE = cr.PRIMARY_UOM_CODE ) then
1871: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 2068: from MTL_UNITS_OF_MEASURE

2064: if cr.SECONDARY_UOM_CODE is not null THEN
2065: begin
2066: select UOM_CLASS
2067: into temp_uom_class
2068: from MTL_UNITS_OF_MEASURE
2069: where UOM_CODE = cr.SECONDARY_UOM_CODE;
2070:
2071: select 'x' into temp
2072: from MTL_SYSTEM_ITEMS msi

Line 2076: from MTL_UNITS_OF_MEASURE MUOM

2072: from MTL_SYSTEM_ITEMS msi
2073: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
2074: and secondary_uom_code IS NOT NULL
2075: and not exists (select UNIT_OF_MEASURE
2076: from MTL_UNITS_OF_MEASURE MUOM
2077: where UOM_CLASS = temp_uom_class
2078: and MUOM.UOM_CODE = msi.SECONDARY_UOM_CODE)
2079: and rownum = 1;
2080:

Line 2142: from MTL_UNITS_OF_MEASURE

2138: -- validate foreign keys
2139: if cr.DIMENSION_UOM_CODE is not null then
2140: begin
2141: select 'x' into temp
2142: from MTL_UNITS_OF_MEASURE
2143: where UOM_CODE = cr.DIMENSION_UOM_CODE;
2144: exception
2145: when NO_DATA_FOUND then
2146: dumm_status := INVPUOPI.mtl_log_interface_err(