235: 8)) AS SUB_ITEM_NUM, --Subsidiary Item Number
236: FLV1.MEANING AS SUB_ITEM_NAME, --Subsidiary Item Name
237: FLV2.MEANING AS CORR_RECORD, --Corresponding Record
238: FLV1.MEANING AS SUB_ITEM_DESC --Subsidiary Item Description
239: FROM FND_LOOKUP_VALUES FLV1,
240: FND_LOOKUP_VALUES FLV2,
241: JA_CN_SUB_ACC_MAPPING SAM
242: WHERE FLV1.LOOKUP_TYPE = 'JA_CN_SUB_ACC_SLA_CONTEXT'
243: AND FLV2.LOOKUP_TYPE = 'JA_CN_SLA_CORR_RECO'
236: FLV1.MEANING AS SUB_ITEM_NAME, --Subsidiary Item Name
237: FLV2.MEANING AS CORR_RECORD, --Corresponding Record
238: FLV1.MEANING AS SUB_ITEM_DESC --Subsidiary Item Description
239: FROM FND_LOOKUP_VALUES FLV1,
240: FND_LOOKUP_VALUES FLV2,
241: JA_CN_SUB_ACC_MAPPING SAM
242: WHERE FLV1.LOOKUP_TYPE = 'JA_CN_SUB_ACC_SLA_CONTEXT'
243: AND FLV2.LOOKUP_TYPE = 'JA_CN_SLA_CORR_RECO'
244: AND DECODE(FLV1.LOOKUP_CODE, 'CUSTOMER', 'CUSTOMER RECORD',