DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on JA_CN_CFS_ITEM_MAPPING_HDRS

Line 794: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)

790: AND jeh.status = 'P'
791: --fix bug 5665083, 2006-11-16, Andrew/ 4/03/2007, Altered by Yucheng.Sun :
792: -- should exclude AGIS, AP, AR in GL data collection.
793: AND jeh.je_source NOT IN ('Intercompany')--, 'Payables', 'Receivables'
794: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)
795: AND jeh.je_source NOT IN ( SELECT FAPP.APPLICATION_SHORT_NAME
796: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH
797: WHERE FAPP.APPLICATION_ID=JCCIMH.APPLICATION_ID
798: )

Line 796: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH

792: -- should exclude AGIS, AP, AR in GL data collection.
793: AND jeh.je_source NOT IN ('Intercompany')--, 'Payables', 'Receivables'
794: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)
795: AND jeh.je_source NOT IN ( SELECT FAPP.APPLICATION_SHORT_NAME
796: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH
797: WHERE FAPP.APPLICATION_ID=JCCIMH.APPLICATION_ID
798: )
799: ;
800: