DBA Data[Home] [Help]

APPS.JA_CN_SIOA_EXPORT_PKG dependencies on FND_LOOKUP_VALUES

Line 239: FROM FND_LOOKUP_VALUES FLV1,

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'

Line 240: FND_LOOKUP_VALUES FLV2,

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',