APPS.ICX_POR_EXT_DIAG dependencies on MTL_UNITS_OF_MEASURE

Line 1625: FROM mtl_units_of_measure uom1,

1621: SELECT VALID_FOR_EXTRACT
1622: INTO xStatus
1623: FROM dual
1624: WHERE EXISTS (SELECT 'same UOM class'
1625: FROM mtl_units_of_measure uom1,
1626: mtl_units_of_measure uom2,
1627: mtl_units_of_measure uom3
1628: WHERE uom1.uom_code = p_uom_code
1629: AND uom2.uom_code = p_local_uom_code

Line 1626: mtl_units_of_measure uom2,

1622: INTO xStatus
1623: FROM dual
1624: WHERE EXISTS (SELECT 'same UOM class'
1625: FROM mtl_units_of_measure uom1,
1626: mtl_units_of_measure uom2,
1627: mtl_units_of_measure uom3
1628: WHERE uom1.uom_code = p_uom_code
1629: AND uom2.uom_code = p_local_uom_code
1630: AND uom3.uom_code = p_purchasing_uom_code

Line 1627: mtl_units_of_measure uom3

1623: FROM dual
1624: WHERE EXISTS (SELECT 'same UOM class'
1625: FROM mtl_units_of_measure uom1,
1626: mtl_units_of_measure uom2,
1627: mtl_units_of_measure uom3
1628: WHERE uom1.uom_code = p_uom_code
1629: AND uom2.uom_code = p_local_uom_code
1630: AND uom3.uom_code = p_purchasing_uom_code
1631: AND uom1.uom_class = uom2.uom_class

Line 1853: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1849: l_enabled_flag VARCHAR2(1);
1850: l_purchasing_site VARCHAR2(1);
1851: l_purchasing_enabled VARCHAR2(1);
1852: l_outside_operation VARCHAR2(1);
1853: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1854:
1855: -- Centralized Procurement Impacts Enhancement - pcreddy
1856: l_purchasing_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1857: l_local_purchasing_enabled VARCHAR2(1);

Line 1856: l_purchasing_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1852: l_outside_operation VARCHAR2(1);
1853: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1854:
1855: -- Centralized Procurement Impacts Enhancement - pcreddy
1856: l_purchasing_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1857: l_local_purchasing_enabled VARCHAR2(1);
1858: l_local_outside_operation VARCHAR2(1);
1859:
1860: l_local_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 1860: l_local_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1856: l_purchasing_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1857: l_local_purchasing_enabled VARCHAR2(1);
1858: l_local_outside_operation VARCHAR2(1);
1859:
1860: l_local_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1861: l_disable_flag VARCHAR2(1);
1862: l_asl_status_id NUMBER;
1863: l_item_price NUMBER;
1864: l_internal_order_enabled VARCHAR2(1);