1321: -- trx_headers
1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1324: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1325: l_trx_send_name hz_parties.party_name%TYPE;
1326: l_trx_recv_name hz_parties.party_name%TYPE;
1327: l_trx_gl_date fun_trx_batches.gl_date%TYPE;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);
1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1324: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1325: l_trx_send_name hz_parties.party_name%TYPE;
1326: l_trx_recv_name hz_parties.party_name%TYPE;
1327: l_trx_gl_date fun_trx_batches.gl_date%TYPE;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);
1330: l_trx_line_sob NUMBER;
1428: , '') trxh_cash_related_item*/
1429: FROM FUN_TRX_HEADERS trxh
1430: ,FUN_TRX_BATCHES trxb
1431: ,FUN_TRX_TYPES_TL trxtype
1432: ,HZ_PARTIES party_init
1433: ,HZ_PARTIES party_reci
1434: --,JA_CN_DFF_ASSIGNMENTS dff
1435: WHERE trxh.batch_id=trxb.batch_id
1436: AND trxb.trx_type_id=trxtype.trx_type_id
1429: FROM FUN_TRX_HEADERS trxh
1430: ,FUN_TRX_BATCHES trxb
1431: ,FUN_TRX_TYPES_TL trxtype
1432: ,HZ_PARTIES party_init
1433: ,HZ_PARTIES party_reci
1434: --,JA_CN_DFF_ASSIGNMENTS dff
1435: WHERE trxh.batch_id=trxb.batch_id
1436: AND trxb.trx_type_id=trxtype.trx_type_id
1437: AND party_init.party_id=trxh.initiator_id