[Home] [Help]
318: FROM gl_je_lines jel
319: , fun_trx_headers trxh
320: , fun_trx_lines trxl
321: , fun_dist_lines distl
322: ,ja_cn_dff_assignments dffa --
323: WHERE distl.dist_id = l_jt_id -- transaction header id
324: AND distl.line_id=trxl.line_id
325: AND trxh.trx_id = trxl.trx_id
326: AND jel.reference_2 = TO_CHAR(trxh.batch_id)
771: ) inter_flag
772: ,jeh.DEFAULT_EFFECTIVE_DATE effective_date
773: FROM GL_JE_HEADERS jeh
774: ,gl_je_categories_tl jec
775: ,JA_CN_DFF_ASSIGNMENTS DFF
776: WHERE jeh.ledger_id = l_ledger_id --using variable P_LEDGER_ID
777: AND jeh.period_name = l_period_name --using variable l_period_name
778: --check the Journal Category is Cash Related or not
779: AND jeh.je_category = jec.je_category_name --user_je_category_name
818: ,nvl(jel.ACCOUNTED_DR, 0) -
819: nvl(jel.ACCOUNTED_CR, 0) je_accounted_amount
820: FROM GL_JE_LINES jel
821: ,GL_JE_HEADERS jeh
822: ,ja_cn_dff_assignments dffa
823: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
824: AND jeh.je_header_id = jel.je_header_id
825: -- to locate cash flow item in dff_assignment
826: AND dffa.Application_Id = 101
862: , '') trxh_cash_related_item*/
863: FROM FUN_TRX_HEADERS trxh
864: , FUN_TRX_BATCHES trxb
865: , FUN_TRX_TYPES_TL trxtype
866: --, JA_CN_DFF_ASSIGNMENTS dff
867: WHERE trxh.batch_id=trxb.batch_id
868: AND trxb.trx_type_id=trxtype.trx_type_id
869: --
870: --AND dff.DFF_TITLE_CODE='IITL'--'JOCA'
908: ,FUN_DIST_LINES trldist
909: ,GL_CODE_COMBINATIONS codecmb
910: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
911: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
912: ,JA_CN_DFF_ASSIGNMENTS dff
913: WHERE trl.line_id=trldist.line_id
914: AND trl.trx_id=trldist.trx_id
915: AND trldist.ccid=codecmb.code_combination_id
916: AND trl.trx_id=l_trxh_header_id --using variable l_trx_id