DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on JA_CN_CFS_ITEM_MAPPING_HDRS

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

808: AND jeh.status = 'P'
809: --fix bug 5665083, 2006-11-16, Andrew/ 4/03/2007, Altered by Yucheng.Sun :
810: -- should exclude AGIS, AP, AR in GL data collection.
811: AND jeh.je_source NOT IN ('Intercompany')--, 'Payables', 'Receivables'
812: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)
813: AND jeh.je_source NOT IN ( SELECT FAPP.APPLICATION_SHORT_NAME
814: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH
815: WHERE FAPP.APPLICATION_ID=JCCIMH.APPLICATION_ID
816: )

Line 814: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH

810: -- should exclude AGIS, AP, AR in GL data collection.
811: AND jeh.je_source NOT IN ('Intercompany')--, 'Payables', 'Receivables'
812: -- exclude the source defined in in cash flow item mapping form (ja_cn_cfs_item_mapping_hdrs)
813: AND jeh.je_source NOT IN ( SELECT FAPP.APPLICATION_SHORT_NAME
814: FROM FND_APPLICATION FAPP, JA_CN_CFS_ITEM_MAPPING_HDRS JCCIMH
815: WHERE FAPP.APPLICATION_ID=JCCIMH.APPLICATION_ID
816: )
817: ;
818: