[Home] [Help]
329: FROM gl_je_lines jel
330: , fun_trx_headers trxh
331: , fun_trx_lines trxl
332: , fun_dist_lines distl
333: -- ,ja_cn_dff_assignments dffa --
334: WHERE distl.dist_id = l_jt_id -- transaction header id
335: AND distl.line_id=trxl.line_id
336: AND trxh.trx_id = trxl.trx_id
337: AND jel.reference_2 = TO_CHAR(trxh.batch_id)
789: ) inter_flag
790: ,jeh.DEFAULT_EFFECTIVE_DATE effective_date
791: FROM GL_JE_HEADERS jeh
792: ,gl_je_categories_tl jec
793: ,JA_CN_DFF_ASSIGNMENTS DFF
794: WHERE jeh.ledger_id = l_ledger_id --using variable P_LEDGER_ID
795: AND jeh.period_name = l_period_name --using variable l_period_name
796: --check the Journal Category is Cash Related or not
797: AND jeh.je_category = jec.je_category_name --user_je_category_name
838: ,nvl(jel.ACCOUNTED_DR, 0) -
839: nvl(jel.ACCOUNTED_CR, 0) je_accounted_amount
840: FROM GL_JE_LINES jel
841: ,GL_JE_HEADERS jeh
842: --,ja_cn_dff_assignments dffa
843: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
844: AND jeh.je_header_id = jel.je_header_id;
845: -- to locate cash flow item in dff_assignment
846: -- AND dffa.Application_Id = 101
882: , '') trxh_cash_related_item*/
883: FROM FUN_TRX_HEADERS trxh
884: , FUN_TRX_BATCHES trxb
885: , FUN_TRX_TYPES_TL trxtype
886: --, JA_CN_DFF_ASSIGNMENTS dff
887: WHERE trxh.batch_id=trxb.batch_id
888: AND trxb.trx_type_id=trxtype.trx_type_id
889: --
890: --AND dff.DFF_TITLE_CODE='IITL'--'JOCA'
928: ,FUN_DIST_LINES trldist
929: ,GL_CODE_COMBINATIONS codecmb
930: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
931: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
932: ,JA_CN_DFF_ASSIGNMENTS dff
933: ,xle_entity_profiles xep -- Added for fixing bug# 8744259 by Chaoqun on 30-Jul-2009
934: WHERE trl.line_id=trldist.line_id
935: AND trl.trx_id=trldist.trx_id
936: AND trldist.ccid=codecmb.code_combination_id