DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on MTL_UOM_CLASSES

Line 776: MTL_UOM_CLASSES MTLCLS

772: cursor c_std_cvr_sameClass is
773: select MTLUOM2.uom_code, MTLUCV.uom_class
774: from MTL_UNITS_OF_MEASURE MTLUOM2,
775: MTL_UOM_CONVERSIONS MTLUCV,
776: MTL_UOM_CLASSES MTLCLS
777: where
778: MTLUOM2.uom_code = p_uom_code AND
779: MTLUCV.uom_code = MTLUOM2.uom_code AND
780: MTLUCV.inventory_item_id=0 AND

Line 795: MTL_UOM_CLASSES MTLCLS

791: cursor c_item_cvr_sameClass is
792: select MTLUOM2.uom_code, MTLUCV.uom_class
793: from MTL_UNITS_OF_MEASURE MTLUOM2,
794: MTL_UOM_CONVERSIONS MTLUCV,
795: MTL_UOM_CLASSES MTLCLS
796: where MTLUOM2.uom_code = p_uom_code AND
797: MTLUCV.uom_code = MTLUOM2.uom_code AND
798: MTLUCV.inventory_item_id = p_item_id AND
799: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 810: MTL_UOM_CLASSES MTLCLS

806:
807: select MTLUOM2.uom_code, MTLUOM2.uom_class
808: from MTL_UNITS_OF_MEASURE MTLUOM2,
809: MTL_UOM_CONVERSIONS MTLUCV,
810: MTL_UOM_CLASSES MTLCLS
811: where
812: MTLUOM2.uom_code = p_uom_code AND
813: MTLUCV.uom_code = MTLUOM2.uom_code AND
814: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 823: MTL_UOM_CLASSES MTLCLS

819: UNION ALL
820: select MTLUOM2.uom_code, MTLUOM2.uom_class
821: from MTL_UNITS_OF_MEASURE MTLUOM2,
822: MTL_UOM_CONVERSIONS MTLUCV,
823: MTL_UOM_CLASSES MTLCLS
824: where
825: MTLUOM2.uom_code = p_uom_code AND
826: MTLUCV.uom_code = MTLUOM2.uom_code AND
827: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 840: MTL_UOM_CLASSES MTLCLS

836: UNION ALL
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 861: MTL_UOM_CLASSES MTLCLS

857: UNION ALL
858: select MTLUOM2.uom_code, MTLUOM2.uom_class
859: from MTL_UNITS_OF_MEASURE MTLUOM2,
860: MTL_UOM_CONVERSIONS MTLUCV,
861: MTL_UOM_CLASSES MTLCLS
862: where
863: MTLUOM2.uom_code = p_uom_code AND
864: MTLUCV.uom_code = MTLUOM2.uom_code AND
865: MTLCLS.uom_class = MTLUOM2.uom_class AND

Line 882: MTL_UOM_CLASSES MTLCLS

878: UNION ALL
879: select MTLUOM2.uom_code, MTLUOM2.uom_class
880: from MTL_UNITS_OF_MEASURE MTLUOM2,
881: MTL_UOM_CONVERSIONS MTLUCV,
882: MTL_UOM_CLASSES MTLCLS
883: where
884: MTLUOM2.uom_code = p_uom_code AND
885: MTLUCV.uom_code = MTLUOM2.uom_code AND
886: MTLCLS.uom_class = MTLUOM2.uom_class AND