APPS.MSC_UTIL dependencies on MSC_ITEM_TYPE_DEFINITIONS

Line 1076: FROM MSC_ITEM_TYPE_DEFINITIONS

1072:
1073: BEGIN
1074: SELECT ITEM_TYPE_ID, ITEM_TYPE_VALUE
1075: INTO G_PARTCONDN_ITEMTYPEID, G_PARTCONDN_GOOD
1076: FROM MSC_ITEM_TYPE_DEFINITIONS
1077: WHERE ITEM_TYPE_NAME = 'PART_CONDITION'
1078: AND ITEM_TYPE_VALUE_MEANING = 'USABLE';
1079:
1080: SELECT ITEM_TYPE_VALUE

Line 1082: FROM MSC_ITEM_TYPE_DEFINITIONS

1078: AND ITEM_TYPE_VALUE_MEANING = 'USABLE';
1079:
1080: SELECT ITEM_TYPE_VALUE
1081: INTO G_PARTCONDN_BAD
1082: FROM MSC_ITEM_TYPE_DEFINITIONS
1083: WHERE ITEM_TYPE_NAME = 'PART_CONDITION'
1084: AND ITEM_TYPE_VALUE_MEANING = 'DEFECTIVE';
1085:
1086: EXCEPTION