DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on MSC_ITEM_TYPE_DEFINITIONS

Line 1334: FROM MSC_ITEM_TYPE_DEFINITIONS

1330:
1331: BEGIN
1332: SELECT ITEM_TYPE_ID, ITEM_TYPE_VALUE
1333: INTO G_PARTCONDN_ITEMTYPEID, G_PARTCONDN_GOOD
1334: FROM MSC_ITEM_TYPE_DEFINITIONS
1335: WHERE ITEM_TYPE_NAME = 'PART_CONDITION'
1336: AND ITEM_TYPE_VALUE_MEANING = 'USABLE';
1337:
1338: SELECT ITEM_TYPE_VALUE

Line 1340: FROM MSC_ITEM_TYPE_DEFINITIONS

1336: AND ITEM_TYPE_VALUE_MEANING = 'USABLE';
1337:
1338: SELECT ITEM_TYPE_VALUE
1339: INTO G_PARTCONDN_BAD
1340: FROM MSC_ITEM_TYPE_DEFINITIONS
1341: WHERE ITEM_TYPE_NAME = 'PART_CONDITION'
1342: AND ITEM_TYPE_VALUE_MEANING = 'DEFECTIVE';
1343:
1344: EXCEPTION