eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INV_CONVERT dependencies on MTL_UOM_CLASSES

Line 806: MTL_UOM_CLASSES MTLCLS

802: cursor c_std_cvr_sameClass is
803: select MTLUOM2.uom_code, MTLUCV.uom_class
804: from MTL_UNITS_OF_MEASURE MTLUOM2,
805: MTL_UOM_CONVERSIONS MTLUCV,
806: MTL_UOM_CLASSES MTLCLS
807: where
808: MTLUOM2.uom_code = p_uom_code AND
809: MTLUCV.uom_code = MTLUOM2.uom_code AND
810: MTLUCV.inventory_item_id=0 AND

Line 825: MTL_UOM_CLASSES MTLCLS

821: cursor c_item_cvr_sameClass is
822: select MTLUOM2.uom_code, MTLUCV.uom_class
823: from MTL_UNITS_OF_MEASURE MTLUOM2,
824: MTL_UOM_CONVERSIONS MTLUCV,
825: MTL_UOM_CLASSES MTLCLS
826: where MTLUOM2.uom_code = p_uom_code AND
827: MTLUCV.uom_code = MTLUOM2.uom_code AND
828: MTLUCV.inventory_item_id = p_item_id AND
829: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 840: MTL_UOM_CLASSES MTLCLS

836:
837: select MTLUOM2.uom_code, MTLUOM2.uom_class
838: from MTL_UNITS_OF_MEASURE MTLUOM2,
839: MTL_UOM_CONVERSIONS MTLUCV,
840: MTL_UOM_CLASSES MTLCLS
841: where
842: MTLUOM2.uom_code = p_uom_code AND
843: MTLUCV.uom_code = MTLUOM2.uom_code AND
844: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 853: MTL_UOM_CLASSES MTLCLS

849: UNION ALL
850: select MTLUOM2.uom_code, MTLUOM2.uom_class
851: from MTL_UNITS_OF_MEASURE MTLUOM2,
852: MTL_UOM_CONVERSIONS MTLUCV,
853: MTL_UOM_CLASSES MTLCLS
854: where
855: MTLUOM2.uom_code = p_uom_code AND
856: MTLUCV.uom_code = MTLUOM2.uom_code AND
857: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 870: MTL_UOM_CLASSES MTLCLS

866: UNION ALL
867: select MTLUOM2.uom_code, MTLUOM2.uom_class
868: from MTL_UNITS_OF_MEASURE MTLUOM2,
869: MTL_UOM_CONVERSIONS MTLUCV,
870: MTL_UOM_CLASSES MTLCLS
871: where
872: MTLUOM2.uom_code = p_uom_code AND
873: MTLUCV.uom_code = MTLUOM2.uom_code AND
874: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 891: MTL_UOM_CLASSES MTLCLS

887: UNION ALL
888: select MTLUOM2.uom_code, MTLUOM2.uom_class
889: from MTL_UNITS_OF_MEASURE MTLUOM2,
890: MTL_UOM_CONVERSIONS MTLUCV,
891: MTL_UOM_CLASSES MTLCLS
892: where
893: MTLUOM2.uom_code = p_uom_code AND
894: MTLUCV.uom_code = MTLUOM2.uom_code AND
895: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 912: MTL_UOM_CLASSES MTLCLS

908: UNION ALL
909: select MTLUOM2.uom_code, MTLUOM2.uom_class
910: from MTL_UNITS_OF_MEASURE MTLUOM2,
911: MTL_UOM_CONVERSIONS MTLUCV,
912: MTL_UOM_CLASSES MTLCLS
913: where
914: MTLUOM2.uom_code = p_uom_code AND
915: MTLUCV.uom_code = MTLUOM2.uom_code AND
916: MTLCLS.uom_class = MTLUOM2.uom_class AND