APPS.JA_CN_SIOA_EXPORT_PKG dependencies on JA_CN_SUB_ACC_MAPPING

Line 205: JA_CN_SUB_ACC_MAPPING SAM

201: FROM FND_ID_FLEX_SEGMENTS FIFS,
202: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
203: GL_LEDGERS LED,
204: FND_FLEX_VALUE_SETS FFVS,
205: JA_CN_SUB_ACC_MAPPING SAM
206: WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
207: AND FIFS.APPLICATION_COLUMN_NAME =
208: FSAV.APPLICATION_COLUMN_NAME
209: AND (FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL' OR

Line 241: JA_CN_SUB_ACC_MAPPING SAM

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',
245: 'SUPPLIER', 'SUPPLIER RECORD',

Line 262: JA_CN_SUB_ACC_MAPPING SAM

258: XAHB.ANALYTICAL_CRITERION_CODE AS CORR_RECORD, --Corresponding Record
259: XAHT.DESCRIPTION AS SUB_ITEM_DESC --Subsidiary Item Description
260: FROM XLA_ANALYTICAL_HDRS_B XAHB,
261: XLA_ANALYTICAL_HDRS_TL XAHT,
262: JA_CN_SUB_ACC_MAPPING SAM
263: WHERE XAHB.ANALYTICAL_CRITERION_CODE = 'PROJECT_NUMBER'
264: AND XAHB.ANALYTICAL_CRITERION_CODE =
265: XAHT.ANALYTICAL_CRITERION_CODE
266: AND XAHB.ANALYTICAL_CRITERION_TYPE_CODE =